Re: [Sqlalchemy-tickets] [sqlalchemy] #2784: Incorrect quoting of the column names during creation of the constraints

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

#2784: Incorrect quoting of the column names during creation of the constraints
-----------------------------------+----------------------------------
      Reporter:  adam.markiewicz   |      Owner:  zzzeek
          Type:  defect            |     Status:  closed
      Priority:  medium            |  Milestone:  0.8.xx
     Component:  sql               |   Severity:  minor - half an hour
    Resolution:  fixed             |   Keywords:
Progress State:  completed/closed  |
-----------------------------------+----------------------------------
Changes (by zzzeek):

 * status:  new => closed
 * resolution:   => fixed
 * component:  engine => sql
 * severity:  no triage selected yet => minor - half an hour
 * status_field:  awaiting triage => completed/closed


Comment:

 the "ix_" names are only a default, you can make specific names using
 Index().   The quote flag isn't supported for the Index name right now but
 the main rationale for the quote flag at the moment is to get around
 reserved words not in SQLAlchemy dialects.  If "boolq" is a reserved word
 in DB2 you should send the ibm_db_sa folks a bug report to add it to the
 reserved word list in that dialect.

 check constraint quoting issue:

 6f265a4e6555a6040db1a6dc566825c0ac263fc7 0.7

 436ba1601d33de048a17e39a14856409c4e9c3b7 0.8

 0a54a4a4b0897bb8eaaf7a7857fb54924ccbd7ef 0.9

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