MySQL Bugs: #22975: CREATE TABLE ... LIKE ... takes old table version

Bug #22975	CREATE TABLE ... LIKE ... takes old table version
Submitted:	4 Oct 2006 7:38	Modified:	19 Dec 2006 19:40
Reporter:	Oli Sennhauser	Email Updates:
Status:	Closed
Category:	Server: Docs	Severity:	S3 (Non-critical)
Version:	5.0.27-BK	OS:	Linux (Linux)
Assigned to:	Paul DuBois	Target Version:
Triage:	D4 (Minor)

Description:
Creating and new table with CREATE TABLE ... LIKE ... takes the version of the original
table. Instead of the actual MySQL version.

How to repeat:
show table status like '%';
+----------+--------+---------+
| Name     | Engine | Version |
+----------+--------+---------+
| bonus    | MyISAM |      10 |
| dept     | MyISAM |       7 |
+----------+--------+---------+

create table oli like dept;

show table status like '%';
+----------+--------+---------+
| Name     | Engine | Version |
+----------+--------+---------+
| bonus    | MyISAM |      10 |
| dept     | MyISAM |       7 |
| oli      | MyISAM |       7 |
+----------+--------+---------+

See also bug: http://bugs.mysql.com/bug.php?id=22909

Suggested fix:
I expect that new table is in the new table format. So table format should be taken over
but some things have to be changed!

Or at least docutment it correctly under CREATE TABLE LIKE...

Thank you for a bug report. Verified just as described with 5.0.27-BK on Linux.

This should be documented. CREATE TABLE ... LIKE makes an exact copy of the table
definition, this includes the version too

Thank you for your bug report. This issue has been addressed in the documentation. The
updated documentation will appear on our website shortly, and will be included in the
next release of the relevant products.