summaryrefslogtreecommitdiff
path: root/test/sql/test_compiler.py
diff options
context:
space:
mode:
Diffstat (limited to 'test/sql/test_compiler.py')
-rw-r--r--test/sql/test_compiler.py11
1 files changed, 11 insertions, 0 deletions
diff --git a/test/sql/test_compiler.py b/test/sql/test_compiler.py
index f6f2ec740..924cc3cdd 100644
--- a/test/sql/test_compiler.py
+++ b/test/sql/test_compiler.py
@@ -1537,6 +1537,17 @@ class SelectTest(fixtures.TestBase, AssertsCompiledSQL):
"mytable.myid = :myid_1 OR myothertable.othername != :othername_1 "
"OR EXISTS (select yay from foo where boo = lar)", )
+ def test_full_outer_join(self):
+ self.assert_compile(
+ select(
+ [table1],
+ from_obj=[join(table1, table2, table1.c.myid
+ == table2.c.otherid, full=True)]
+ ),
+ "SELECT mytable.myid, mytable.name, mytable.description FROM "
+ "mytable FULL OUTER JOIN myothertable ON mytable.myid = myothertable.otherid")
+
+
def test_compound_selects(self):
assert_raises_message(
exc.ArgumentError,