Re: [Sqlalchemy-tickets] [sqlalchemy] #2746: allow correlation of FROM elements to any SELECT which encloses via WHERE, columns, ORDER BY (but not FROM list) (was: Add a flag to explicitly enable correlation even when the subquery has `asfrom=True`)

[sqlalchemy <mi...@zz...>]

#2746: allow correlation of FROM elements to any SELECT which encloses via WHERE,
columns, ORDER BY (but not FROM list)
------------------------------+----------------------------------
      Reporter:  sayap        |      Owner:  zzzeek
          Type:  defect       |     Status:  new
      Priority:  highest      |  Milestone:  0.8.xx
     Component:  sql          |   Severity:  minor - half an hour
    Resolution:               |   Keywords:
Progress State:  in progress  |
------------------------------+----------------------------------

Comment (by zzzeek):

 good news.   We don't need a flag.   the latest patch has the compiler
 figure out what the legal "correlations" should be, so all these scenarios
 just work.

 this is a pretty big change but 0.8's current behavior is pretty broken.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2746#comment:8>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python