1CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
2INSERT INTO t1 VALUES (0);
3
4# On connection 1
5START TRANSACTION;
6UPDATE t1 SET c1=1 WHERE c1=0;
7
8# On connection 2
9include/start_transaction_high_prio.inc
10START TRANSACTION /* HIGH PRIORITY */;
11UPDATE t1 SET c1=2 WHERE c1=0;
12COMMIT;
13
14# On connection 1
15COMMIT;
16ERROR HY000: Got error 149 during COMMIT
17include/assert.inc ['There is a 2 in t1']
18include/assert.inc ['There is no 1 in t1']
19include/assert.inc ['There is no 0 in t1']
20DROP TABLE t1;
21