Debian Codegraph @

mysql-test/suite/innodb/r/innodb-ac-non-locking-select.result

raw
1 CREATE TABLE t1 (c1 INT , c2 CHAR(10), PRIMARY KEY (c1)) ENGINE = InnoDB;
2 INSERT INTO t1 VALUES(0, "0");
3 INSERT INTO t1 VALUES(1, "1");
4 INSERT INTO t1 VALUES(2, "2");
5 INSERT INTO t1 VALUES(3, "3");
6 SET AUTOCOMMIT=0;
7 BEGIN;
8 SELECT * FROM t1 FOR UPDATE;
9 c1 c2
10 0 0
11 1 1
12 2 2
13 3 3
14 SELECT * FROM t1 WHERE c1 <= 3;
15 c1 c2
16 0 0
17 1 1
18 2 2
19 3 3
20 SET DEBUG_SYNC='now WAIT_FOR waiting4';
21 SELECT trx_state, trx_query, trx_autocommit_non_locking
22 FROM INFORMATION_SCHEMA.INNODB_TRX
23 WHERE trx_state = 'LOCK WAIT'
24 ORDER BY trx_query;
25 trx_state trx_query trx_autocommit_non_locking
26 LOCK WAIT SELECT COUNT(*) FROM t1 LOCK IN SHARE MODE 0
27 LOCK WAIT SELECT COUNT(*) FROM t1 WHERE c1 >= 0 0
28 INSERT INTO t1 VALUES(4, '4');
29 COMMIT;
30 SELECT * FROM t1 WHERE c1 <= 4;
31 c1 c2
32 0 0
33 1 1
34 2 2
35 3 3
36 XA END '1';
37 XA PREPARE '1';
38 XA ROLLBACK '1';
39 COUNT(*)
40 5
41 COUNT(*)
42 5
43 DROP TABLE t1;
44 SET DEBUG_SYNC= 'RESET';