diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-08-06 01:51:54 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2007-08-06 01:51:54 +0000 |
| commit | 68fd1be8d2dab6b6d1a9f4879dd6cb90c6adce85 (patch) | |
| tree | 57a005f96bfdc45818463d59592adc729ea965b6 /test/sql/select.py | |
| parent | d4102a21f491f27c0df92458f03c87beaab1b030 (diff) | |
| download | sqlalchemy-68fd1be8d2dab6b6d1a9f4879dd6cb90c6adce85.tar.gz | |
- edits
- added "params" to ansisql compiler
Diffstat (limited to 'test/sql/select.py')
| -rw-r--r-- | test/sql/select.py | 2 |
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): |
