Re: [sqlalchemy] behavior of multiple correlated subqueries different from 0.7.10 to 0.9.8

2014-11-05 Thread Michael Bayer
On Nov 4, 2014, at 10:47 PM, Meelap Shah meelaps...@gmail.com wrote: With 0.9.8, the str(query) is the same with User having been dropped from subqueries, but the error output shows a different subquery being executed that selects from both Action and User. the error output here is

Re: [sqlalchemy] behavior of multiple correlated subqueries different from 0.7.10 to 0.9.8

2014-11-05 Thread Michael Bayer
this issue is fixed in the 0.9 and 1.0 branches, https://bitbucket.org/zzzeek/sqlalchemy/issue/3241/multiple-anonymous-expressions-in-query https://bitbucket.org/zzzeek/sqlalchemy/issue/3241/multiple-anonymous-expressions-in-query. On Nov 5, 2014, at 3:33 AM, Michael Bayer

[sqlalchemy] behavior of multiple correlated subqueries different from 0.7.10 to 0.9.8

2014-11-04 Thread Meelap Shah
I am trying to perform a query in which I from multiple correlated subqueries. My code works with 0.7.10, but not with 0.9.8. Base = declarative_base() class User(Base): __tablename__ = 'user' id = Column(Integer, primary_key=True) name = Column(String) class Action(Base):