summaryrefslogtreecommitdiff
path: root/test/sql/select.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2007-08-06 01:51:54 +0000
committerMike Bayer <mike_mp@zzzcomputing.com>2007-08-06 01:51:54 +0000
commit68fd1be8d2dab6b6d1a9f4879dd6cb90c6adce85 (patch)
tree57a005f96bfdc45818463d59592adc729ea965b6 /test/sql/select.py
parentd4102a21f491f27c0df92458f03c87beaab1b030 (diff)
downloadsqlalchemy-68fd1be8d2dab6b6d1a9f4879dd6cb90c6adce85.tar.gz
- edits
- added "params" to ansisql compiler
Diffstat (limited to 'test/sql/select.py')
-rw-r--r--test/sql/select.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/test/sql/select.py b/test/sql/select.py
index 30f4d58ea..eb6636bc0 100644
--- a/test/sql/select.py
+++ b/test/sql/select.py
@@ -168,7 +168,7 @@ sq.myothertable_othername AS sq_myothertable_othername FROM (" + sqstring + ") A
self.runtest(
table1.select(exists([1]).where(table2.c.otherid == table1.c.myid).correlate(table1)).select_from(table1.join(table2, table1.c.myid==table2.c.otherid)).replace_selectable(table2, table2.alias()),
- "SELECT mytable.myid, mytable.name, mytable.description FROM mytable JOIN myothertable ON mytable.myid = myothertable_1.otherid, myothertable AS myothertable_1 WHERE EXISTS (SELECT 1 FROM myothertable AS myothertable_1 WHERE myothertable_1.otherid = mytable.myid)"
+ "SELECT mytable.myid, mytable.name, mytable.description FROM mytable JOIN myothertable AS myothertable_1 ON mytable.myid = myothertable_1.otherid WHERE EXISTS (SELECT 1 FROM myothertable AS myothertable_1 WHERE myothertable_1.otherid = mytable.myid)"
)
def testwheresubquery(self):