[Sqlalchemy-tickets] Issue #3020: Improper column quoting with ORDER BY (zzzeek/sqlalchemy)
Brought to you by:
zzzeek
|
From: Jon N. <iss...@bi...> - 2014-04-11 01:30:25
|
New issue 3020: Improper column quoting with ORDER BY https://bitbucket.org/zzzeek/sqlalchemy/issue/3020/improper-column-quoting-with-order-by Jon Nelson: Below, please find a chunk of code. You'll note that - at least on 0.9.4 - the generated statement doesn't quote the column in the ORDER BY. import sqlalchemy as sa import sqlalchemy.dialects.postgresql as sa_pg import sqlalchemy.dialects.mysql as sa_mysql m = sa.MetaData() t = sa.Table( 'foo', m, sa.Column('a', sa.String()), ) c = t.c.a.label('t.c.a') q = sa.select([c]) q = q.order_by( c ) print q.compile(dialect=sa_pg.dialect()) print q.compile(dialect=sa_mysql.dialect()) Responsible: zzzeek |