auto-correlation in a FROM list subquery is nonsensical

this will be more important as we've changed Query to be auto-correlating by default, and I already got hit with this.

from sqlalchemy.sql import table, column, select


t1 = table('t1', column('x'), column('y'))
t2 = table('t2', column('q'), column('p'))


s = select([t1](t1)).where(t1.c.x == t2.c.q).alias()

s2 = select([t2](t2)).where(t2.c.p == s.c.y)

print s2

Comments (2)