summaryrefslogtreecommitdiff
path: root/tests/join.ur
diff options
context:
space:
mode:
authorGravatar Adam Chlipala <adamc@hcoop.net>2009-04-28 11:14:24 -0400
committerGravatar Adam Chlipala <adamc@hcoop.net>2009-04-28 11:14:24 -0400
commitce12549593feae055d778b34ec9c5abef2b83123 (patch)
tree462c19c00c540828ba796762b20a4f9eff691726 /tests/join.ur
parent008b594412606bbf78fff76daff219a102ce2daa (diff)
RIGHT and FULL JOIN
Diffstat (limited to 'tests/join.ur')
-rw-r--r--tests/join.ur2
1 files changed, 2 insertions, 0 deletions
diff --git a/tests/join.ur b/tests/join.ur
index 74f49eec..d6647877 100644
--- a/tests/join.ur
+++ b/tests/join.ur
@@ -6,4 +6,6 @@ fun main () =
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/>