Bug #8878 foreigh keys in innodb

Description:
Greetings,

When creating an InnoDB table if a foreign key is declared using only the 'references' keyword inline with the field that is being defined, MySQL will correctly parse the DDL query but it will not refer to the foreign key as a foreign key after the DDL query has been executed. The query is executed as if the 'references' keyword were not even there. The field that was intended to be a foreign key is a simple field only. I am using the InnoDB engine. The fact the the query is ignoring the 'references' keyword can be verified by using the SHOW CREATE TABLE or  DESCRIBE.

How to repeat:
CREATE TABLE shirt (
  id smallint(5) unsigned NOT NULL auto_increment primary key,
  style varchar(10) NOT NULL default '',
  color varchar(10) NOT NULL default '',
  fk_owner smallint(5) unsigned NOT NULL REFERENCES person (id) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB

Suggested fix:
1.  Throw an error
2.  Give it the same effect as when using the 'foreign key' keyword

Mike,

this is in the TODO.
http://www.innodb.com/todo.php

Regards,

Heikki

Duplicate of http://bugs.mysql.com/bug.php?id=13301