MySQL Forums

MySQL currently "supports" foreign keys in two ways:
(1) if storage engine = InnoDB then let InnoDB handle them,
(2) otherwise parse and ignore foreign-key clauses.

The goals of this task are:
- take the support out of the storage engine so that
foreign keys work for all storage engines (this is an
instruction from Brian Aker)
- support SQL standard syntax instead of InnoDB syntax.

For a question from an earlier version of this worklog
entry, Brian said he would go along with the "majority".
Please vote by commenting in the appropriate places for
anything that you like/dislike.

I use the abbreviation FK when discussing the referencing
table (the table with the foreign key), or its indexes and columns.
I use the abbreviation PK when discussing the referenced
table (which is often a table with a primary key), or its
indexes and columns.

Note that this implementation is for immediately-checked
constraints only. Deferred contraints -- i.e. constraints
that are checked at transaction-end rather than statement-end
are another task and will be implemented for all constraint
types (not just foreign key constraints) when the time comes.

http://forge.mysql.com/worklog/task.php?id=148