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; |