got lucky, the fix was pretty straightforward. if you can test again with latest master or rel_0_9 that would be great…thanks for the great bug report!
On Nov 1, 2013, at 2:36 PM, Michael Bayer <mike...@zzzcomputing.com> wrote: > its a significant issue, ticket #2858 is in progress. > > > On Nov 1, 2013, at 2:08 PM, Rich <richardmu...@gmail.com> wrote: > >> I'm having a small issue with 0.9b1. The example code below works for >> postgres, but fails with sqlite. It does work for sqlite on 0.8.3. It >> seems that the joinedload_all is causing something to reference the wrong >> alias. >> >> >> from sqlalchemy import * >> from sqlalchemy.orm import * >> from sqlalchemy.ext.declarative import * >> >> >> engine = create_engine('sqlite://') >> Base = declarative_base(bind=engine) >> metadata = Base.metadata >> >> >> account = Table('account', metadata, >> Column('account_id', Integer, key='id', primary_key=True), >> Column('name', String(255), nullable=False), >> ) >> >> account_address_map = Table('account_address_map', metadata, >> Column('account_id', Integer, ForeignKey('account.id'), nullable=False), >> Column('address_id', Integer, ForeignKey('address.id'), nullable=False), >> Column('role_id', Integer, nullable=False) >> ) >> >> address = Table('address', metadata, >> Column('address_id', Integer, key='id', primary_key=True), >> Column('address1', String(255), nullable=False), >> ) >> >> >> mapping = account_address_map.select()\ >> .where(account_address_map.c.role_id == 1) >> >> >> class Account(Base): >> __table__ = account >> >> service_address = relationship('Address', >> secondary=mapping, >> uselist=False, >> viewonly=True) >> >> >> class Address(Base): >> __table__ = address >> >> >> metadata.create_all() >> session = Session() >> session.query(Account).options(joinedload_all('service_address')).all() >> >> >> -- >> 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/groups/opt_out. > > > -- > 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/groups/opt_out. -- 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/groups/opt_out.