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