Percona XtraDB Cluster - HA scalable solution for MySQL

CTAS with empty result set will not be replicated

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 Trunk
5.6
Undecided
Unassigned
Trunk
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

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

Other bug subscribers