Debian Codegraph @

mysql-test/suite/innodb/t/innodb_i_s_innodb_trx.test

raw
1 --source include/have_innodb.inc
2
3 #
4 # Test that transaction data is correctly "visualized" in
5 # INFORMATION_SCHEMA.INNODB_TRX
6 #
7
8 SET @save_timeout=@@GLOBAL.innodb_lock_wait_timeout;
9 SET GLOBAL innodb_lock_wait_timeout=100000000;
10
11 DESCRIBE INFORMATION_SCHEMA.INNODB_TRX;
12
13 CREATE TABLE t1 (
14 c01 INT,
15 c02 INT,
16 PRIMARY KEY (c01)
17 ) ENGINE=INNODB STATS_AUTO_RECALC=0;
18
19 INSERT INTO t1 VALUES
20 (1,2),(2,4),(3,6),(4,8);
21
22 CREATE TABLE t2 (
23 c01 INT,
24 c02 INT,
25 PRIMARY KEY (c01),
26 FOREIGN KEY fk1 (c02) REFERENCES t1 (c01)
27 ) ENGINE=INNODB STATS_AUTO_RECALC=0;
28
29 INSERT INTO t2 VALUES
30 (1,1),(2,2),(3,3);
31
32 -- source include/count_sessions.inc
33
34 -- connect (con_trx,localhost,root,,)
35 -- connect (con_verify_innodb_trx,localhost,root,,)
36
37 -- connection con_trx
38 SET autocommit=0;
39 INSERT INTO t1 VALUES (5,10);
40 SELECT * FROM t1 FOR UPDATE;
41
42 let $wait_timeout= 300;
43 let $wait_condition=
44 SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_TRX;
45 -- source include/wait_condition.inc
46
47 -- connection con_verify_innodb_trx
48 SELECT trx_state, trx_weight, trx_tables_in_use, trx_tables_locked,
49 trx_rows_locked, trx_rows_modified, trx_concurrency_tickets,
50 trx_isolation_level, trx_unique_checks, trx_foreign_key_checks
51 FROM INFORMATION_SCHEMA.INNODB_TRX;
52
53 -- connection con_trx
54 ROLLBACK;
55 SET FOREIGN_KEY_CHECKS = 0;
56 SET UNIQUE_CHECKS = 0;
57 SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
58 BEGIN;
59 INSERT INTO t1 VALUES (6,12);
60
61 let $wait_timeout= 300;
62 let $wait_condition=
63 SELECT trx_unique_checks = 0 FROM INFORMATION_SCHEMA.INNODB_TRX;
64 -- source include/wait_condition.inc
65
66 -- connection con_verify_innodb_trx
67 SELECT trx_isolation_level, trx_unique_checks, trx_foreign_key_checks
68 FROM INFORMATION_SCHEMA.INNODB_TRX;
69
70 -- connection con_trx
71 ROLLBACK;
72 SET FOREIGN_KEY_CHECKS = 1;
73 SET UNIQUE_CHECKS = 1;
74 BEGIN;
75 --error ER_NO_REFERENCED_ROW_2
76 INSERT INTO t2 VALUES (4,10);
77
78 let $wait_timeout= 300;
79 let $wait_condition=
80 SELECT trx_unique_checks = 1 FROM INFORMATION_SCHEMA.INNODB_TRX;
81 -- source include/wait_condition.inc
82 -- disconnect con_trx
83
84 -- connection con_verify_innodb_trx
85 SELECT trx_state, trx_isolation_level, trx_last_foreign_key_error
86 FROM INFORMATION_SCHEMA.INNODB_TRX;
87 -- disconnect con_verify_innodb_trx
88
89 -- connection default
90 DROP TABLE t2;
91 DROP TABLE t1;
92
93 -- source include/wait_until_count_sessions.inc
94
95 SET GLOBAL innodb_lock_wait_timeout=@save_timeout;