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

Bug #1671013 reported by Laurynas Biveinis
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;

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.