Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL)
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos73-ppc64le/builds/9249
bb-10.1-release 4177181e1617df185397ea275ee98eb4 |
binlog.binlog_stm_drop_tmp_tbl 'innodb_plugin,mix' w3 [ fail ]
|
Test ended at 2019-07-26 10:12:03
|
|
CURRENT_TEST: binlog.binlog_stm_drop_tmp_tbl
|
ERROR 1051 (42S02) at line 77: Unknown table 'test.t1'
|
mysqltest: In included file "./extra/binlog_tests/drop_temp_table.test":
|
included from /usr/share/mysql-test/suite/binlog/t/binlog_stm_drop_tmp_tbl.test at line 6:
|
At line 168: exec of '/usr/bin/mysql --defaults-file=/dev/shm/var/3/my.cnf < /dev/shm/var/3/tmp/bug28642318.sql' failed, error: 256, status: 1, errno: 95
|
Output from before failure:
|
# DROP table query fails with unknown table error without patch.
|
|
|
|
The result from queries just before the failure was:
|
< snip >
|
RESET MASTER;
|
# Set up.
|
SET @save_binlog_format= @@session.binlog_format;
|
SET @@session.binlog_format=STATEMENT;
|
CREATE TABLE t1 (a INT) ENGINE=INNODB;
|
SET @@session.binlog_format=STATEMENT;
|
CREATE TEMPORARY TABLE t1 (b BLOB) ENGINE=INNODB;
|
DELETE d1, d2 FROM t1 AS d1, t1 AS d2 WHERE d1.a<>d2.a;
|
DROP TABLE t1;
|
# DELETE query fails with table re-open error without patch.
|
# Clean up.
|
DROP TABLE IF EXISTS t1;
|
DROP TABLE IF EXISTS t1;
|
RESET MASTER;
|
# Test case for DROP query.
|
CREATE TABLE t1 (a INT) ENGINE=INNODB;
|
CREATE TEMPORARY TABLE t1 (b BLOB) ENGINE=INNODB;
|
DROP TABLE t1;
|
DROP TABLE t1;
|
# DROP table query fails with unknown table error without patch.
|