From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: comment with "foreign key" text causes innodb CREATE TABLE failure
Description: If an innodb table is created with a comment with the words "foreign key", the table creation fails. The syntax used to work with MySQL-4.0.4-beta-win and earlier, running on both Linux and Windows. This query (missing the comment) executes successfully: CREATE TABLE a(a INT) TYPE=innodb; I consider this bug pretty important since many of our existing scripts use this style of comments. How-To-Repeat: Execute this query: CREATE TABLE a(a INT /* foreign key */) TYPE=innodb; You'll get this output: ERROR 1005: Can't create table '.\a\a.frm' (errno: 150) Fix: Change the /* foreign key */ comment in all database scripts. "foreign-key" works. Synopsis: comment with "foreign key" text causes innodb table creation failure Submitter-Id: Originator: Brandon Bird Organization: Pacer/CATS MySQL support: none Severity: serious Priority: Category: mysqld Class: sw-bug Release: mysql-4.0.11 Exectutable: mysqld-max-nt Environment: dell 4400; ntfs System: WinXP Compiler: Architecture: i --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php