1 CREATE TABLE t(a INT PRIMARY KEY, b INT)ENGINE=InnoDB;
2 INSERT INTO t VALUES(2,2),(4,4),(8,8),(16,16),(32,32);
5 INSERT INTO t VALUES(1,1);
9 INSERT INTO t VALUES(3,47),(5,67);
10 UPDATE t SET b=2*b WHERE a BETWEEN 5 AND 8;
14 UPDATE t SET b=4*a WHERE a=32;
17 call mtr.add_suppression("Found 3 prepared XA transactions");
18 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
30 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
43 formatID gtrid_length bqual_length data