From 37a61a1b497cb44d0098d188255238ddf4e8e38c Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Fri, 19 Jan 2007 02:19:38 +0000 Subject: - another fix to subquery correlation so that a subquery which has only one FROM element will *not* correlate that single element, since at least one FROM element is required in a query. --- test/sql/select.py | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'test/sql') diff --git a/test/sql/select.py b/test/sql/select.py index f11736652..bdc79c400 100644 --- a/test/sql/select.py +++ b/test/sql/select.py @@ -121,7 +121,10 @@ sq2.sq_myothertable_otherid, sq2.sq_myothertable_othername FROM \ (SELECT sq.mytable_myid AS sq_mytable_myid, sq.mytable_name AS sq_mytable_name, \ sq.mytable_description AS sq_mytable_description, sq.myothertable_otherid AS sq_myothertable_otherid, \ sq.myothertable_othername AS sq_myothertable_othername FROM (" + sqstring + ") AS sq) AS sq2") - + + def testdontovercorrelate(self): + self.runtest(select([table1], from_obj=[table1, table1.select()]), """SELECT mytable.myid, mytable.name, mytable.description FROM mytable, (SELECT mytable.myid AS myid, mytable.name AS name, mytable.description AS description FROM mytable)""") + def testwheresubquery(self): # TODO: this tests that you dont get a "SELECT column" without a FROM but its not working yet. #self.runtest( -- cgit v1.2.1