On May 1, 2008, at 10:22 AM, Yannick Gingras wrote:
>
>
> Is there a workaround in the mean time? Calling reset_joinpoint()
> after filter_by() won't do it:
>
>> Item.query().join("ref_ids", aliased=True).filter_by(ref_id =
>> "OP-10")\
> .reset_joinpoint().filter(not_(Item.ref_ids.any(ref_id =
> "OP-10-47000")))\
> .all()
>
> <class 'sqlalchemy.exceptions.InvalidRequestError'>: Select
> statement 'SELECT 1 FROM items, item_ids AS item_ids_1 WHERE
> items.id = item_ids_1.item_id AND item_ids_1.ref_id =
> :item_ids_ref_id_1' is overcorrelated; returned no 'from' clauses
>
that I'm not able to reproduce. If i create a similar situation which
creates the same error, reset_joinpoint() turns off all the "aliasing"
for subsequent filter() calls and then it works. It also works on
0.4.5. Can you make sure you're on 0.4.5 and then create a test case
for me ?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
