CTAS with empty result set will not be replicated

Bug #1246921 reported by Seppo Jaakola on 2013-10-31
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Status tracked in 5.6
5.5
Low
Seppo Jaakola
5.6
Low
Seppo Jaakola
Percona XtraDB Cluster
Status tracked in 5.6
5.5
Undecided
Unassigned
5.6
Undecided
Unassigned

Bug Description

Create table as select... will not be replicated, if the select result set is empty.

How to reproduce:
1. start two nodes
2. node1> CREATE TABLE t1 ( i int)
3. node1> CREATE TABLE t2 AS SELECT * FROM t1;
4. node1> SHOW TABLES;
5. node2> SHOW TABLES;

Seppo Jaakola (seppo-jaakola) wrote :

Revision #3997 has been overwritten in wsrep-5.6 branch, will need to merge it back in

Seppo Jaakola (seppo-jaakola) wrote :

fix in wsrep-5.6 branch is now pushed in revision: http://bazaar.launchpad.net/~codership/codership-mysql/5.6/revision/4004

tags: added: ctas
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers