[Sqlalchemy-tickets] [sqlalchemy] #2841: MySQL doesn't support MATCH, INITIALLY, or DEFERRED

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

#2841: MySQL doesn't support MATCH, INITIALLY, or DEFERRED
--------------------------------+-----------------------------------------
 Reporter:  uijllji             |           Owner:  zzzeek
     Type:  defect              |          Status:  new
 Priority:  medium              |       Milestone:
Component:  cextensions         |        Severity:  no triage selected yet
 Keywords:  mysql, ddl, schema  |  Progress State:  awaiting triage
--------------------------------+-----------------------------------------
 MySQL does not support foreign key options of MATCH, INITIALLY, or
 DEFERRED. See:

 https://dev.mysql.com/doc/refman/5.5/en/create-table-foreign-keys.html,
 find for 'Important'

 MATCH causes later options such as ON UPDATE and ON DELETE to be silently
 ignored.

 So if a user sets MATCH, INIITALLY, or DEFERRED in their
 ForeignKeyConstraint object, their schema will differ without any warning.

 I therefore propose the MySQL dialect throw a CompileError if those
 options are specified.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2841>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python