regression from uniticketed CTE changeset

Issue #2801 resolved
Mike Bayer repo owner created an issue

this affects back to 0.7

878af426f7eb19c257f1db83f5b1af34624c2c6a

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)

Comments (3)

  1. Mike Bayer reporter

    the issue is that the uppercase name "CTE" doesn't get quoted when rendered a second time.

  2. Log in to comment