summaryrefslogtreecommitdiff
path: root/test/orm
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2016-03-28 11:50:09 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2016-03-28 11:50:09 -0400
commitd61919118072f4c31ba2ee0bd8c4ac22a92e92f4 (patch)
tree1dd12ef15aa76f25d048377c518ff0c7f03a7fe7 /test/orm
parent63d2a486bf84f798387bd45db558610b247e0aa5 (diff)
downloadsqlalchemy-d61919118072f4c31ba2ee0bd8c4ac22a92e92f4.tar.gz
- Added support for rendering "FULL OUTER JOIN" to both Core and ORM.
Pull request courtesy Stefan Urbanek. fixes #1957
Diffstat (limited to 'test/orm')
-rw-r--r--test/orm/test_joins.py9
1 files changed, 9 insertions, 0 deletions
diff --git a/test/orm/test_joins.py b/test/orm/test_joins.py
index 540056dae..e7e943e8d 100644
--- a/test/orm/test_joins.py
+++ b/test/orm/test_joins.py
@@ -455,6 +455,15 @@ class JoinTest(QueryTest, AssertsCompiledSQL):
"FROM users LEFT OUTER JOIN orders ON users.id = orders.user_id"
)
+ def test_full_flag(self):
+ User = self.classes.User
+
+ self.assert_compile(
+ create_session().query(User).outerjoin('orders', full=True),
+ "SELECT users.id AS users_id, users.name AS users_name "
+ "FROM users FULL OUTER JOIN orders ON users.id = orders.user_id"
+ )
+
def test_multi_tuple_form(self):
"""test the 'tuple' form of join, now superseded