Bug #9832 Replication fails when doing "create table a like b"
Submitted: 12 Apr 2005 0:09 Modified: 12 May 2005 4:33
Reporter: Nigel Drego Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Replication Severity:S1 (Critical)
Version:5.0.0-alpha OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[12 Apr 2005 0:09] Nigel Drego 
Description:
This seems to be an exact replica of bug 2557 for the 4.1.1 release where the "create table a like b" would work on the master server but the replication would fail.

How to repeat:
create table xxyy like <any existing table> 

Check to see if the new table is on any of the slave servers. I usually get a replication error.

Suggested fix:
The same fix that was used for bug 2557.
[12 Apr 2005 4:33] Heikki Tuuri 
Please test with 5.0.3.

Regards,

Heikki
[12 May 2005 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".