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