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 moved to https://jira.percona.com/projects/PXC
Status tracked in 5.6
5.5
Fix Released
Undecided
Unassigned
5.6
Fix Released
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

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1500

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

Other bug subscribers