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 ?
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 -~----------~----~----~----~------~----~------~--~---