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 innodb_snapshot_isolation=0;
7 connect con1,localhost,root,,;
8 set innodb_snapshot_isolation=0;
9 connect con2,localhost,root,,;
10 set innodb_snapshot_isolation=0;
11 connect con3,localhost,root,,;
12 set innodb_snapshot_isolation=0;
13 connect con4,localhost,root,,;
14 set innodb_snapshot_isolation=0;
15 connect con5,localhost,root,,;
16 set innodb_snapshot_isolation=0;
17 connect con6,localhost,root,,;
18 set innodb_snapshot_isolation=0;
19 connection default;
20 SET AUTOCOMMIT=0;
21 BEGIN;
22 SELECT * FROM t1 FOR UPDATE;
23 c1 c2
24 0 0
25 1 1
26 2 2
27 3 3
28 SELECT * FROM t1 WHERE c1 <= 3;
29 c1 c2
30 0 0
31 1 1
32 2 2
33 3 3
34 connection default;
35 SET DEBUG_SYNC='now WAIT_FOR waiting4';
36 SET DEBUG_SYNC= 'RESET';
37 SELECT trx_state, trx_query, trx_autocommit_non_locking
38 FROM INFORMATION_SCHEMA.INNODB_TRX
39 WHERE trx_state = 'LOCK WAIT'
40 ORDER BY trx_query;
41 trx_state trx_query trx_autocommit_non_locking
42 LOCK WAIT SELECT COUNT(*) FROM t1 LOCK IN SHARE MODE 0
43 LOCK WAIT SELECT COUNT(*) FROM t1 WHERE c1 >= 0 0
44 INSERT INTO t1 VALUES(4, '4');
45 COMMIT;
46 connection con6;
47 SELECT * FROM t1 WHERE c1 <= 4;
48 c1 c2
49 0 0
50 1 1
51 2 2
52 3 3
53 XA END '1';
54 XA PREPARE '1';
55 XA ROLLBACK '1';
56 disconnect con6;
57 disconnect con2;
58 disconnect con3;
59 disconnect con5;
60 connection con1;
61 COUNT(*)
62 5
63 disconnect con1;
64 connection con4;
65 COUNT(*)
66 5
67 disconnect con4;
68 connection default;
69 DROP TABLE t1;