Mercurial > urweb

view tests/join.ur @ 1034:a779402841f6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Hooks for measuring how much interesting proving is going on in elaboration
author Adam Chlipala <adamc@hcoop.net>
date Tue, 17 Nov 2009 12:44:14 -0500
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/>