Bug #697 foreign key doesn't work any table is named user.

Description:
I know that Mysql 4.x with InnoDB supports foreign key.
But the foreign key doesn't work when it references other table is named
[user], if the table name is [users], it will be good job.

ex) foreign key references user(u_id) on delete set null;

*------------------------------------*
Gwang-Tae Kim  <acacia@mizi.com>
Mizi Research.
Linux Platform Company.
*------------------------------------*

How to repeat:
change the name of table  to any other thins.

You need to add a space between "user" and the starting parentheses, otherwise MySQL will parse 
it as a call to the user() function, which exists. So the correct syntax would be:

 foreign key references user (u_id) on delete set null;