Debian Codegraph @

mysql-test/suite/binlog/r/binlog_mixed.result

raw
1 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
2 INSERT INTO t1 (a) VALUES (1),(2);
3 CREATE TABLE t2 (b INT) ENGINE=InnoDB;
4 CREATE TRIGGER tr1 BEFORE UPDATE ON t1 FOR EACH ROW SET @a = 0;
5 CREATE TRIGGER tr2 BEFORE INSERT ON t2 FOR EACH ROW DELETE FROM t1 LIMIT 1;
6 SET AUTOCOMMIT= OFF;
7 LOCK TABLES t2 WRITE;
8 DELETE FROM t1 LIMIT 1;
9 SAVEPOINT A;
10 UNLOCK TABLES;
11 DROP TABLE t1, t2;