diff options
Diffstat (limited to 'mysql-test/suite/binlog/r/binlog_row_drop_tmp_tbl.result')
-rw-r--r-- | mysql-test/suite/binlog/r/binlog_row_drop_tmp_tbl.result | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/mysql-test/suite/binlog/r/binlog_row_drop_tmp_tbl.result b/mysql-test/suite/binlog/r/binlog_row_drop_tmp_tbl.result index 831a1c8a9a3..60596be480f 100644 --- a/mysql-test/suite/binlog/r/binlog_row_drop_tmp_tbl.result +++ b/mysql-test/suite/binlog/r/binlog_row_drop_tmp_tbl.result @@ -61,3 +61,44 @@ master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F master-bin.000001 # Query # # COMMIT RESET MASTER; DROP TABLE t1; +# +# BUG#28642318: POINT IN TIME RECOVERY USING MYSQLBINLOG BROKEN +# WITH TEMPORARY TABLE -> ERRORS +# Test case for DELETE query. +RESET MASTER; +connect con1,localhost,root,,; +# Set up. +connection default; +SET @save_binlog_format= @@session.binlog_format; +SET @@session.binlog_format=STATEMENT; +CREATE TABLE t1 (a INT) ENGINE=INNODB; +connection con1; +SET @@session.binlog_format=STATEMENT; +CREATE TEMPORARY TABLE t1 (b BLOB) ENGINE=INNODB; +connection default; +DELETE d1, d2 FROM t1 AS d1, t1 AS d2 WHERE d1.a<>d2.a; +connection default; +DROP TABLE t1; +# DELETE query fails with table re-open error without patch. +# Clean up. +connection con1; +DROP TABLE IF EXISTS t1; +connection default; +DROP TABLE IF EXISTS t1; +RESET MASTER; +# Test case for DROP query. +connection default; +CREATE TABLE t1 (a INT) ENGINE=INNODB; +connection con1; +CREATE TEMPORARY TABLE t1 (b BLOB) ENGINE=INNODB; +connection default; +DROP TABLE t1; +connection con1; +DROP TABLE t1; +connection default; +# DROP table query fails with unknown table error without patch. +# Clean up +connection default; +SET @@session.binlog_format= @save_binlog_format; +RESET MASTER; +disconnect con1; |