Re: [sqlalchemy] can't generate a correlated update without an anonymous alias

2016-03-25 Thread Jonathan Vanasco
> > subquery().as_scalar() > BINGO! thanks! -- 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,

Re: [sqlalchemy] can't generate a correlated update without an anonymous alias

2016-03-25 Thread Mike Bayer
On 03/25/2016 12:23 PM, Jonathan Vanasco wrote: I created a testcase here - https://gist.github.com/jvanasco/a2ff04614a23e192ac7f this has been stumping me this morning. the sql I want is: update table_a set id_b__latest = ( :other_query ) generated from something like:

[sqlalchemy] can't generate a correlated update without an anonymous alias

2016-03-25 Thread Jonathan Vanasco
I created a testcase here - https://gist.github.com/jvanasco/a2ff04614a23e192ac7f this has been stumping me this morning. the sql I want is: update table_a set id_b__latest = ( :other_query ) generated from something like: s.execute(TableA.__table__ .update()