[Sqlalchemy-tickets] [sqlalchemy] #2801: regression from uniticketed CTE changeset

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

#2801: regression from uniticketed CTE changeset
--------------------+------------------------------------
 Reporter:  zzzeek  |           Owner:  zzzeek
     Type:  defect  |          Status:  new
 Priority:  high    |       Milestone:  0.7.xx
Component:  sql     |        Severity:  major - 1-3 hours
 Keywords:          |  Progress State:  in queue
--------------------+------------------------------------
 this affects back to 0.7

 r878af426f7eb19c257f1db83f5b1af34624c2c6a

 {{{
 #!python
 from sqlalchemy.orm import Session
 import sqlalchemy as sa

 session = Session()

 cte = session.query(sa.literal(1).label("id")).cte(name='CTE')

 firstSubquery = session.query(cte.c.id).subquery()
 secondSubquery = session.query(cte.c.id).subquery()

 query = session.query(firstSubquery, secondSubquery)

 print("--------------")
 print(firstSubquery)
 print("--------------")
 print(secondSubquery)
 print("--------------")
 print(query)
 }}}

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