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:
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.0-bk OS:
Assigned to: Sergei Glukhov CPU Architecture:Any

[18 Dec 2003 11:56] Sergey Petrunya
Doing "CREATE TABLE X LIKE Y" for an InnoDB table causes redundant errors in the error log.

How to repeat:
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
[31 Mar 2004 1:32] Sergei Glukhov
Fixed in 4.1 source tree