added sql compiler test for FULL OUTER JOINpr/167

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,