From 1848439d445ad3361b42a2e72f5604fda85dbf7b Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Tue, 15 May 2007 16:51:40 +0000 Subject: [PATCH] restored outerjoin test --- test/sql/select.py | 18 ++++++++---------- 1 file changed, 8 insertions(+), 10 deletions(-) diff --git a/test/sql/select.py b/test/sql/select.py index 6d0d3b04cc..395243aeee 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 \ -- 2.47.2