summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2007-05-15 16:51:40 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2007-05-15 16:51:40 +0000
commit1848439d445ad3361b42a2e72f5604fda85dbf7b (patch)
treeeb9cbb7cb06a542285636181aefa6b2357bad4ae
parentb3817dc8c218b0fd5a60a9cf8b21a04395f59599 (diff)
downloadsqlalchemy-1848439d445ad3361b42a2e72f5604fda85dbf7b.tar.gz
restored outerjoin test
-rw-r--r--test/sql/select.py18
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 \