Re: [Sqlalchemy-tickets] [sqlalchemy] #2742: look into using inline=true for bindparam() inside of DDL sequences

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

#2742: look into using inline=true for bindparam() inside of DDL sequences
-----------------------------------+----------------------------------
      Reporter:  andreycizov       |      Owner:  zzzeek
          Type:  defect            |     Status:  closed
      Priority:  medium            |  Milestone:  0.8.xx
     Component:  postgres          |   Severity:  minor - half an hour
    Resolution:  fixed             |   Keywords:
Progress State:  completed/closed  |
-----------------------------------+----------------------------------
Changes (by zzzeek):

 * status:  new => closed
 * resolution:   => fixed
 * component:  schema => postgres
 * status_field:  in queue => completed/closed


Comment:

 two different issues:

 1. need to render literals inline, not bound - I applied this individually
 to the default compiler as well as to the compilers for postgresql, mssql,
 mysql even though I'm not sure if expressions are valid for those other
 two:

 9bc9d5c1068be878118202259add3c master

 d8c17e2a6f41d0aad331678e91 0.8


 2. Postgresql requires parenthesis around any SQL expression that isn't a
 straight
 column inside the list of cols in CREATE INDEX
 (http://www.postgresql.org/docs/9.1/static/sql-createindex.html)

 a2cce1bf43552e699f2b master

 70fdd3efa7a9a9a0fcf6ce 0.8

 with these two changes your test case passes.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2742#comment:4>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python