CTAS with empty result set will not be replicated
Bug #1246921 reported by
Seppo Jaakola
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership | Status tracked in 5.6 | |||||
5.5 |
New
|
Low
|
Seppo Jaakola | |||
5.6 |
Fix Released
|
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;
tags: | added: ctas |
To post a comment you must log in.
Fix pushed in wsrep-5.6 branch in revision: http:// bazaar. launchpad. net/~codership/ codership- mysql/5. 6/revision/ 3997