summaryrefslogtreecommitdiff
path: root/tests
diff options
context:
space:
mode:
authorGravatar Adam Chlipala <adamc@hcoop.net>2009-04-28 11:05:28 -0400
committerGravatar Adam Chlipala <adamc@hcoop.net>2009-04-28 11:05:28 -0400
commit008b594412606bbf78fff76daff219a102ce2daa (patch)
tree3fd436b0d0eff217ce878cae73dd070a73f12835 /tests
parent04dd6b3727c7786a4824897e78b0b2982ecd6f5b (diff)
LEFT JOIN
Diffstat (limited to 'tests')
-rw-r--r--tests/join.ur3
1 files changed, 2 insertions, 1 deletions
diff --git a/tests/join.ur b/tests/join.ur
index 30a0e744..74f49eec 100644
--- a/tests/join.ur
+++ b/tests/join.ur
@@ -1,8 +1,9 @@
-table t : { A : int }
+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);
return <xml/>