Re: [sqlalchemy] joinedload on inherited class causing subquery instead of raw joins?

2013-01-30 Thread Michael Bayer
On Jan 30, 2013, at 7:31 PM, Gerald Thibault wrote: > I have a user object, and an extended user object which inherits from the > base user object. I also have a test object, which has a FK to the extended > user object. When I try this: > > res = session.query(Test) \ > .options(joinedloa

[sqlalchemy] joinedload on inherited class causing subquery instead of raw joins?

2013-01-30 Thread Gerald Thibault
I have a user object, and an extended user object which inherits from the base user object. I also have a test object, which has a FK to the extended user object. When I try this: res = session.query(Test) \ .options(joinedload('user')) \ .all() I see this sql generated: SELECT test.id