Bug #153 comment containing "foreign key" results in error

• Submitted: 14 Mar 2003 19:15
• Modified: 22 Apr 2003 10:34
• Reporter: Alexander Keremidarski
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 3.23, 4.0
• OS: Any (all)
• Assigned to: Heikki Tuuri
• CPU Architecture: Any

[14 Mar 2003 19:15] Alexander Keremidarski

Description:
Comment /* foreign key */ is parsed as non comment text.

Does not happen in 4.1

How to repeat:
mysql> CREATE TABLE a(a INT /* foreign key */) TYPE=innodb;
ERROR 1005: Can't create table './bugs/a.frm' (errno: 150)

# perror 150
Error code 150:  Unknown error 150
150 = Foreign key constraint is incorrectly formed

[22 Apr 2003 10:34] Heikki Tuuri

Fixed in 4.0.13.