CREATE TEMPORARY TABLE ... SELECT ... gets a DROP binlogged on disconnect in mixed

Bug #1671013 reported by Laurynas Biveinis on 2017-03-08
6
This bug affects 1 person
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://bugs.mysql.com/bug.php?id=83003, CREATE TEMPORARY TABLE ... SELECT gets binlogged on a disconnect, in mixed but not in row mode. The following testcase results in extra "use `test`; DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `tmp1`, in mixed only.

--source include/have_log_bin.inc
--source include/have_binlog_format_row.inc

CREATE TABLE t1(a INT);

--source include/count_sessions.inc

--connect(con1,localhost,root)
# --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/wait_until_count_sessions.inc

--source include/show_binlog_events.inc

DROP TABLE t1;

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

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

Other bug subscribers