CREATE TEMPORARY TABLE ... SELECT ... gets a DROP binlogged on disconnect in mixed
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
High
|
Laurynas Biveinis | |||
5.7 |
Fix Released
|
High
|
Laurynas Biveinis |
Bug Description
Even with a fix for bug 1539504 / https:/
--source include/
--source include/
CREATE TABLE t1(a INT);
--source include/
--connect(
# --let $con1_id= `SELECT CONNECTION_ID()`
CREATE TEMPORARY TABLE tmp1 SELECT * FROM t1;
# CREATE TEMPORARY TABLE tmp1 (a INT);
--disconnect con1
--connection default
--source include/
--source include/
DROP TABLE t1;
https:/ /github. com/percona/ percona- server/ pull/1490 /github. com/percona/ percona- server/ pull/1491
https:/