On Friday 27 June 2008 21:58:22 Michael Bayer wrote:
> 0.4 has trouble joining *to* a joined-table mapper, as below you
> can see its failing to convert "model join paramvalue" into a
> subquery. what's 0.5 say ?
seems to work, on the simplified case at least.
> On Jun 27, 2008, at 2:45 PM, [EMAIL PROTECTED] wrote:
> > some aliasing is missing or what?
> >
> > see attached file
> >
> > (sa 0.4)
> > print session.query( PVOwnership).join( 'param_value').all()
> > ...
> > sqlalchemy.exceptions.OperationalError: (OperationalError) no
> > such column: ParamValue.db_id
> > u'SELECT "PVOwnership".param_value_id
> > AS "PVOwnership_param_value_id", "PVOwnership".which_owner
> > AS "PVOwnership_which_owner", "PVOwnership"._someowner_id
> > AS "PVOwnership__someowner_id", "PVOwnership".db_id
> > AS "PVOwnership_db_id" \n
> > FROM "PVOwnership" JOIN ("Model" JOIN "ParamValue"
> > ON "ParamValue".db_id = "Model".db_id)
> > ON "PVOwnership".param_value_id = "ParamValue".db_id ORDER
> > BY "PVOwnership".oid' []
> >
> >
> > <a.py>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
