Re: [sqlalchemy] Potential Bug in 0.8b2

2013-02-17 Thread Michael Bayer
just to note, I can't reproduce this, this would be a pretty basic failure as described, so I really need to see mappings and working code, and it certainly looks like something is making it do that for you, so really need to know what it is.0.8.0 is going out very soon. See below where

[sqlalchemy] Potential Bug in 0.8b2

2013-02-15 Thread Chris
Hi The following fails to work in 0.8b2 (Works fine in 0.7.9) pp = aliased(PublicationPrice, name=pp) ppp= aliased(PublicationPrices, name=ppp) session.query(pp, ppp).\ join(ppp, ppp.id == pp.publicationpricesid).\ filter(pp.publicationid == publicationid).all() It generates the following SQL

Re: [sqlalchemy] Potential Bug in 0.8b2

2013-02-15 Thread Michael Bayer
Can I please get mapper definitions for this so that I can actually run this example, thanks. Also make sure the issue still remains in current tip. On Feb 15, 2013, at 9:34 AM, Chris chris.g@gmail.com wrote: Hi The following fails to work in 0.8b2 (Works fine in 0.7.9) pp =