Debian Codegraph @

mysql-test/suite/binlog/t/binlog_mixed.test

raw
1 --source include/have_innodb.inc
2 --source include/have_binlog_format_mixed_or_row.inc
3
4 #
5 # MDEV-22048 Assertion `binlog_table_maps == 0 ||
6 # locked_tables_mode == LTM_LOCK_TABLES' failed in
7 # THD::reset_for_next_command
8 #
9
10 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
11 INSERT INTO t1 (a) VALUES (1),(2);
12
13 CREATE TABLE t2 (b INT) ENGINE=InnoDB;
14
15 CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW SET @a = 0;
16 CREATE TRIGGER tr2 BEFORE INSERT ON t2 FOR EACH ROW DELETE FROM t1 LIMIT 1;
17
18 SET AUTOCOMMIT= OFF;
19 LOCK TABLES t2 WRITE;
20 DELETE FROM t1 LIMIT 1;
21 SAVEPOINT A;
22 UNLOCK TABLES;
23 DROP TABLE t1, t2;