Mercurial > urweb

view tests/join.ur @ 1454:96353138f016

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix bug in projection of constructors from modules in class rules.
author Karn Kallio <kkallio@eka>
date Sun, 01 May 2011 00:26:08 -0430
parents f95d652086cd
children
line wrap: on
line source
table t : { A : int, B : string, C : option string }

fun main () =
    r <- oneRow (SELECT * FROM t);
    r <- oneRow (SELECT * FROM t AS T1, t AS T2);
    r <- oneRow (SELECT * FROM t AS T1 CROSS JOIN t AS T2);
    r <- oneRow (SELECT * FROM t AS T1 JOIN t AS T2 ON T1.A = T2.A);
    r <- oneRow (SELECT * FROM t AS T1 LEFT JOIN t AS T2 ON T1.A = T2.A);
    r <- oneRow (SELECT * FROM t AS T1 RIGHT OUTER JOIN t AS T2 ON T1.A = T2.A);
    r <- oneRow (SELECT * FROM t AS T1 FULL JOIN t AS T2 ON T1.A = T2.A);
    return <xml/>