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

Reply via email to