comment with foreign key text causes innodb CREATE TABLE failure
Hi! Brandon == Brandon Bird [EMAIL PROTECTED] writes: Brandon From: [EMAIL PROTECTED] Brandon To: [EMAIL PROTECTED] Brandon Subject: comment with foreign key text causes innodb CREATE TABLE Brandon failure Brandon Description: Brandon If an innodb table is created with a comment with the words foreign Brandon key, the table creation fails. cut Just a short note about this. Currently the InnoDB table handler scans the CREATE statement and handles the foreign key definition infernally in InnoDB. In 4.1 MySQL will handle the parsing of the foreign key definition and will store the foreign key definitions in the normal table definition file. This will fix these kind of problems once and for all. Regards, Monty -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - 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
Re: comment with foreign key text causes innodb CREATE TABLE failure
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
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: 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