Re: [sqlalchemy] sqla 0.6.4, orm, problem with self-referring joins

2010-09-20 Thread Michael Bayer
On Sep 19, 2010, at 11:59 PM, me wrote: > when i apply multiple joins to orm query, one of them self-referring, > using (target, property) form sqla generates the "wrong" join criteria > by selecting aliased table for the left side of the join. > > > sess = Session() > AliasedA = orm.aliased(A)

[sqlalchemy] sqla 0.6.4, orm, problem with self-referring joins

2010-09-19 Thread me
when i apply multiple joins to orm query, one of them self-referring, using (target, property) form sqla generates the "wrong" join criteria by selecting aliased table for the left side of the join. tried sqla 0.5.8 and 0.6.4, same result. e.g. for sqla 0.6.4 from sqlalch