MySQL Bugs: #2160: Extra error message for CREATE TABLE LIKE with InnoDB

Bug #2160	Extra error message for CREATE TABLE LIKE with InnoDB
Submitted:	18 Dec 2003 11:56	Modified:	31 Mar 2004 1:32
Reporter:	Sergey Petrunya	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S3 (Non-critical)
Version:	5.0-bk	OS:
Assigned to:	Sergei Glukhov	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Doing "CREATE TABLE X LIKE Y" for an InnoDB table causes redundant errors in the error log.

How to repeat:
Run
create table tx1 (a int) type=innodb;
create table tx2 like tx1;

And see something like this appear in the error log:

InnoDB: Error: table test/tx2
InnoDB: does not exist in the InnoDB internal
InnoDB: data dictionary though MySQL is trying to drop it.
InnoDB: Have you copied the .frm file of the table to the
InnoDB: MySQL database directory from another database?
InnoDB: You can look for further help from section 15.1 of
InnoDB: http://www.innodb.com/ibman.html

Fixed in 4.1 source tree