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;
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #1 |
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #2 |
Revision history for this message
| Seppo Jaakola (seppo-jaakola) wrote | #3 |
| tags: | added: ctas |
Revision history for this message
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #4 |
To post a comment you must log in.
Fix pushed in wsrep-5.6 branch in revision: http://