diff options
| -rw-r--r-- | test/sql/test_compiler.py | 11 |
1 files changed, 11 insertions, 0 deletions
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, |