MySQL Bugs: #1469: Foreign key definition missing in show create table

Bug #1469	Foreign key definition missing in show create table
Submitted:	2 Oct 2003 22:25	Modified:	3 Oct 2003 1:17
Reporter:	Dan Granroth	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.1 Alpha release	OS:	Windows (Windows XP proffesional)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
In earlier versions the foreign key definition showed up when using show create table xxx on an innodb table. In 4.1 this definition (f ex 0_27) is missing, maiking it impossible to drop the foreign key without dropping the whole table.

How to repeat:
Create to innodb tables where the first table has foreign key kolumn on the second table. Use "show create table firsttable_name".

Dan,

MySQL-4.1.0 is the earlier release. 4.0.13 was released later.

MySQL-4.1.1 will contain all the functionality of 4.0.xx.

Best regards,
Heikki