diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-05-15 16:51:40 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-05-15 16:51:40 +0000 |
| commit | 1848439d445ad3361b42a2e72f5604fda85dbf7b (patch) | |
| tree | eb9cbb7cb06a542285636181aefa6b2357bad4ae /test | |
| parent | b3817dc8c218b0fd5a60a9cf8b21a04395f59599 (diff) | |
| download | sqlalchemy-1848439d445ad3361b42a2e72f5604fda85dbf7b.tar.gz | |
restored outerjoin test
Diffstat (limited to 'test')
| -rw-r--r-- | test/sql/select.py | 18 |
1 files changed, 8 insertions, 10 deletions
diff --git a/test/sql/select.py b/test/sql/select.py index 6d0d3b04c..395243aee 100644 --- a/test/sql/select.py +++ b/test/sql/select.py @@ -644,17 +644,15 @@ FROM myothertable ORDER BY myid \ ), from_obj = [ outerjoin(table1, table2, table1.c.myid == table2.c.otherid) ] ) - if False: - self.runtest(query, - "SELECT mytable.myid, mytable.name, mytable.description, myothertable.otherid, myothertable.othername \ - FROM mytable LEFT OUTER JOIN myothertable ON mytable.myid = myothertable.otherid \ - WHERE mytable.name = %(mytable_name)s OR mytable.myid = %(mytable_myid)s OR \ - myothertable.othername != %(myothertable_othername)s OR \ - EXISTS (select yay from foo where boo = lar)", - dialect=postgres.dialect() - ) + self.runtest(query, + "SELECT mytable.myid, mytable.name, mytable.description, myothertable.otherid, myothertable.othername \ +FROM mytable LEFT OUTER JOIN myothertable ON mytable.myid = myothertable.otherid \ +WHERE mytable.name = %(mytable_name)s OR mytable.myid = %(mytable_myid)s OR \ +myothertable.othername != %(myothertable_othername)s OR \ +EXISTS (select yay from foo where boo = lar)", + dialect=postgres.dialect() + ) - print "-------------------------------------------------" self.runtest(query, "SELECT mytable.myid, mytable.name, mytable.description, myothertable.otherid, myothertable.othername \ FROM mytable, myothertable WHERE mytable.myid = myothertable.otherid(+) AND \ |
