From 72478db2f849220c2543bffed44d0f56fb609b48 Mon Sep 17 00:00:00 2001 From: Stefan Urbanek Date: Tue, 25 Aug 2015 23:55:12 -0700 Subject: added sql compiler test for FULL OUTER JOIN --- test/sql/test_compiler.py | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/test/sql/test_compiler.py b/test/sql/test_compiler.py index 7ff7d68af..e6d8d488d 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, -- cgit v1.2.1