Details
Description
--source include/have_innodb.inc
|
--source include/have_binlog_format_row.inc
|
|
CREATE TABLE t1 (a INT) ENGINE=InnoDB; |
CREATE TABLE t2 (b INT) ENGINE=InnoDB; |
CREATE TABLE t3 (c INT) ENGINE=InnoDB; |
CREATE TRIGGER tr1 BEFORE INSERT ON t3 FOR EACH ROW INSERT INTO t2 VALUES (NULL) ; |
CREATE TRIGGER tr2 BEFORE UPDATE ON t2 FOR EACH ROW SET @a = 1; |
|
LOCK TABLE t3 WRITE; |
SET AUTOCOMMIT = OFF; |
INSERT INTO t2 VALUES (1); |
SAVEPOINT A;
|
UNLOCK TABLES;
|
INSERT INTO t1 VALUES (2); |
|
# Cleanup
|
DROP TABLE t1, t2, t3; |
10.4 non-debug 3b401a69 |
|
line
2019-12-12 16:17:52 10 [Warning] WSREP: binlog trx cache not empty (34 bytes) @ connection close 10
2019-12-12 16:17:52 10 [Warning] WSREP: binlog stmt cache not empty (0 bytes) @ connection close 10
^ Found warnings in /data/bld/10.4-rel-nightly/mysql-test/var/log/mysqld.1.err
|
Debug builds additionally fail with MDEV-21307.