Debian Codegraph @

mysql-test/suite/sys_vars/t/tx_compatibility.test

raw
1 --echo #
2 --echo # MDEV-21921 Make transaction_isolation and transaction_read_only into
3 --echo # system variables
4 --echo #
5
6 SET @saved_global_isolation= @@global.transaction_isolation;
7 SET @saved_global_read_only= @@global.transaction_read_only;
8
9 --echo # Case 1: Check the influence of --transaction_* on
10 --echo # @@session.transaction_* and @@global.transaction_*,
11 --echo # @@session.tx_*, @@global.tx_*.
12
13 SELECT @@session.transaction_isolation, @@global.transaction_isolation,
14 @@session.tx_isolation, @@global.tx_isolation;
15 SHOW GLOBAL VARIABLES LIKE '%_isolation';
16 SHOW SESSION VARIABLES LIKE '%_isolation';
17
18 SELECT @@session.transaction_read_only, @@global.transaction_read_only,
19 @@session.tx_read_only, @@global.tx_read_only;
20 SHOW GLOBAL VARIABLES LIKE '%_read_only';
21 SHOW SESSION VARIABLES LIKE '%_read_only';
22
23 --echo # Case 2: Check that the change to tx_* is reflected to transaction_*.
24
25 SET tx_isolation= 'REPEATABLE-READ';
26 SET @@global.tx_isolation= 'SERIALIZABLE';
27 SELECT @@session.tx_isolation, @@global.tx_isolation,
28 @@session.transaction_isolation, @@global.transaction_isolation;
29 SHOW GLOBAL VARIABLES LIKE '%_isolation';
30 SHOW SESSION VARIABLES LIKE '%_isolation';
31
32 SET STATEMENT tx_isolation= 'SERIALIZABLE' FOR SHOW SESSION VARIABLES LIKE '%_isolation';
33 SHOW SESSION VARIABLES LIKE '%_isolation';
34
35 SET tx_read_only= OFF;
36 SET @@global.tx_read_only= ON;
37 SELECT @@session.tx_read_only, @@global.tx_read_only,
38 @@session.transaction_read_only, @@global.transaction_read_only;
39 SHOW GLOBAL VARIABLES LIKE '%_read_only';
40 SHOW SESSION VARIABLES LIKE '%_read_only';
41
42 SET STATEMENT tx_read_only= ON FOR SHOW SESSION VARIABLES LIKE '%_read_only';
43 SHOW SESSION VARIABLES LIKE '%_read_only';
44
45 --echo # Case 3: Check that the change to transaction_* is reflected to tx_*.
46
47 SET transaction_isolation= 'SERIALIZABLE';
48 SET @@global.transaction_isolation= 'REPEATABLE-READ';
49 SELECT @@session.tx_isolation, @@global.tx_isolation,
50 @@session.transaction_isolation, @@global.transaction_isolation;
51 SHOW GLOBAL VARIABLES LIKE '%_isolation';
52 SHOW SESSION VARIABLES LIKE '%_isolation';
53
54 SET STATEMENT transaction_isolation= 'REPEATABLE-READ' FOR SHOW SESSION VARIABLES LIKE '%_isolation';
55 SHOW SESSION VARIABLES LIKE '%_isolation';
56
57 SET transaction_read_only= ON;
58 SET @@global.transaction_read_only= OFF;
59 SELECT @@session.tx_read_only, @@global.tx_read_only,
60 @@session.transaction_read_only, @@global.transaction_read_only;
61 SHOW GLOBAL VARIABLES LIKE '%_read_only';
62 SHOW SESSION VARIABLES LIKE '%_read_only';
63
64 SET STATEMENT transaction_read_only= OFF FOR SHOW SESSION VARIABLES LIKE '%_read_only';
65 SHOW SESSION VARIABLES LIKE '%_read_only';
66
67 SET @@global.transaction_isolation= @saved_global_isolation;
68 SET @@global.transaction_read_only= @saved_global_read_only;