- eager loading with LIMIT/OFFSET applied no longer adds the primary

table joined to a limited subquery of itself; the eager loads now
join directly to the subquery which also provides the primary table's
columns to the result set.  This eliminates a JOIN from all eager loads
with LIMIT/OFFSET.  [ticket:843]

1 files changed, 21 insertions, 1 deletions

diff --git a/test/sql/selectable.py b/test/sql/selectable.py
index 72f5f35d0..9fca3ee08 100755
--- a/test/sql/selectable.py
+++ b/test/sql/selectable.py
@@ -166,7 +166,27 @@ class SelectableTest(AssertMixin):
         print str(criterion)
         print str(j.onclause)
         self.assert_(criterion.compare(j.onclause))
-        
+    
+    def testtablejoinedtoselectoftable(self):
+        metadata = MetaData()
+        a = Table('a', metadata,
+            Column('id', Integer, primary_key=True))
+        b = Table('b', metadata,
+            Column('id', Integer, primary_key=True),
+            Column('aid', Integer, ForeignKey('a.id')),
+            )
+
+        j1 = a.outerjoin(b)
+        j2 = select([a.c.id.label('aid')]).alias('bar')
+
+        j3 = a.join(j2, j2.c.aid==a.c.id)
+
+        j4 = select([j3]).alias('foo')
+        print j4
+        print j4.corresponding_column(j2.c.aid)
+        print j4.c.aid
+        # TODO: this is the assertion case which fails
+#        assert j4.corresponding_column(j2.c.aid) is j4.c.aid
 
 class PrimaryKeyTest(AssertMixin):
     def test_join_pk_collapse_implicit(self):