regression from uniticketed CTE changeset
Issue #2801
resolved
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)
-
reporter -
reporter - changed status to resolved
-
reporter - removed milestone
Removing milestone: 0.7.xx (automated comment)
- Log in to comment
the issue is that the uppercase name "CTE" doesn't get quoted when rendered a second time.