[Sqlalchemy-tickets] Issue #3020: Improper column quoting with ORDER BY (zzzeek/sqlalchemy)

[Jon N. <iss...@bi...>]

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