[Sqlalchemy-tickets] [sqlalchemy] #2321: Nested select in query with tightly linked tables causes SQL Alchemy to repeat from clause information

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

#2321: Nested select in query with tightly linked tables causes SQL Alchemy to
repeat from clause information
--------------------+-------------------------------------------------------
 Reporter:  guest   |          Owner:  zzzeek                
     Type:  defect  |         Status:  new                   
 Priority:  medium  |      Milestone:  0.7.xx                
Component:  (none)  |       Severity:  no triage selected yet
 Keywords:          |   Status_field:  awaiting triage       
--------------------+-------------------------------------------------------
 Although the select, when evaluated directly, is correct, when nested in a
 query via the in_ function, with very circularly interconnected tables
 with joined table inheritance, it repeats a from clause element, which is
 sufficient to cause most databases not to execute the command.

 See the attached code for an example...

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2321>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python