On 6/30/14, 7:29 PM, Jack Zhou wrote: > Thanks for the quick response, Mike!
that's all fixed in master / rel_1_0 and rel_0_9 branches (as you know I like to fix these deep polymorphic loader issues ASAP) > > > On Mon, Jun 30, 2014 at 4:26 PM, Mike Bayer <mike...@zzzcomputing.com > <mailto:mike...@zzzcomputing.com>> wrote: > > > On 6/30/14, 7:03 PM, Mike Bayer wrote: >> >> >> there's a little bit of a glitch here, however in any case, the >> ORDER BY would be from E.Engineer.specialty. >> >> The glitch is that the subq load at the moment seems to need an >> additional hint as to what its selecting from: >> >> >> session.query(E).select_from(E).options(subqueryload(E.cars)).order_by(E.Engineer.specialty).first() >> >> will look into that. > > OK, for now > > session.query(E).select_from(E).options(subqueryload(E.cars)).order_by(Engineer.specialty).first() > is fine (don't need E.Engineer in the order_by), the issue is > > https://bitbucket.org/zzzeek/sqlalchemy/issue/3106/subquery-load-on-with_polymorphic-entity > and with the patch there once I get tests in, the query will work > as you had it originally. > > > > -- > You received this message because you are subscribed to a topic in > the Google Groups "sqlalchemy" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/sqlalchemy/gvOJr4cSO-A/unsubscribe. > To unsubscribe from this group and all its topics, send an email > to sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy+unsubscr...@googlegroups.com>. > To post to this group, send email to sqlalchemy@googlegroups.com > <mailto:sqlalchemy@googlegroups.com>. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > > > -- > You received this message because you are subscribed to the Google > Groups "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send > an email to sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy+unsubscr...@googlegroups.com>. > To post to this group, send email to sqlalchemy@googlegroups.com > <mailto:sqlalchemy@googlegroups.com>. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
