Brandon, thank you for the bug report. I will try to fix this in 4.0.xx.
Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query ----- Original Message ----- From: ""Brandon Bird"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, March 15, 2003 12:36 AM Subject: comment with "foreign key" text causes innodb CREATE TABLE failure > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: comment with "foreign key" text causes innodb CREATE TABLE > failure > > Description:=09 > If an innodb table is created with a comment with the words "foreign > key", the table creation fails.=20 > > 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=3Dinnodb; > > I consider this bug pretty important since many of our existing scripts > use this style of comments. > > > How-To-Repeat:=09 > Execute this query: > CREATE TABLE a(a INT /* foreign key */) TYPE=3Dinnodb; > =20 > You'll get this output: > ERROR 1005: Can't create table '.\a\a.frm' (errno: 150)=09 > > > Fix:=09 > 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:=09 > Originator: Brandon Bird > Organization: Pacer/CATS > MySQL support: none > Severity: serious > Priority:=09 > Category: mysqld > Class: sw-bug > Release: mysql-4.0.11 > > Exectutable: mysqld-max-nt=20 > Environment: dell 4400; ntfs > System: WinXP > Compiler: =20 > 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 > --------------------------------------------------------------------- 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