Debian Codegraph @

mysql-test/suite/sys_vars/r/tx_compatibility.result

raw
1 #
2 # MDEV-21921 Make transaction_isolation and transaction_read_only into
3 # system variables
4 #
5 SET @saved_global_isolation= @@global.transaction_isolation;
6 SET @saved_global_read_only= @@global.transaction_read_only;
7 # Case 1: Check the influence of --transaction_* on
8 # @@session.transaction_* and @@global.transaction_*,
9 # @@session.tx_*, @@global.tx_*.
10 SELECT @@session.transaction_isolation, @@global.transaction_isolation,
11 @@session.tx_isolation, @@global.tx_isolation;
12 @@session.transaction_isolation @@global.transaction_isolation @@session.tx_isolation @@global.tx_isolation
13 SERIALIZABLE SERIALIZABLE SERIALIZABLE SERIALIZABLE
14 SHOW GLOBAL VARIABLES LIKE '%_isolation';
15 Variable_name Value
16 transaction_isolation SERIALIZABLE
17 tx_isolation SERIALIZABLE
18 SHOW SESSION VARIABLES LIKE '%_isolation';
19 Variable_name Value
20 transaction_isolation SERIALIZABLE
21 tx_isolation SERIALIZABLE
22 SELECT @@session.transaction_read_only, @@global.transaction_read_only,
23 @@session.tx_read_only, @@global.tx_read_only;
24 @@session.transaction_read_only @@global.transaction_read_only @@session.tx_read_only @@global.tx_read_only
25 1 1 1 1
26 SHOW GLOBAL VARIABLES LIKE '%_read_only';
27 Variable_name Value
28 transaction_read_only ON
29 tx_read_only ON
30 SHOW SESSION VARIABLES LIKE '%_read_only';
31 Variable_name Value
32 transaction_read_only ON
33 tx_read_only ON
34 # Case 2: Check that the change to tx_* is reflected to transaction_*.
35 SET tx_isolation= 'REPEATABLE-READ';
36 Warnings:
37 Warning 1287 '@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead
38 SET @@global.tx_isolation= 'SERIALIZABLE';
39 Warnings:
40 Warning 1287 '@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead
41 SELECT @@session.tx_isolation, @@global.tx_isolation,
42 @@session.transaction_isolation, @@global.transaction_isolation;
43 @@session.tx_isolation @@global.tx_isolation @@session.transaction_isolation @@global.transaction_isolation
44 REPEATABLE-READ SERIALIZABLE REPEATABLE-READ SERIALIZABLE
45 SHOW GLOBAL VARIABLES LIKE '%_isolation';
46 Variable_name Value
47 transaction_isolation SERIALIZABLE
48 tx_isolation SERIALIZABLE
49 SHOW SESSION VARIABLES LIKE '%_isolation';
50 Variable_name Value
51 transaction_isolation REPEATABLE-READ
52 tx_isolation REPEATABLE-READ
53 SET STATEMENT tx_isolation= 'SERIALIZABLE' FOR SHOW SESSION VARIABLES LIKE '%_isolation';
54 Variable_name Value
55 transaction_isolation SERIALIZABLE
56 tx_isolation SERIALIZABLE
57 Warnings:
58 Warning 1287 '@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead
59 Warning 1287 '@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead
60 SHOW SESSION VARIABLES LIKE '%_isolation';
61 Variable_name Value
62 transaction_isolation REPEATABLE-READ
63 tx_isolation REPEATABLE-READ
64 SET tx_read_only= OFF;
65 Warnings:
66 Warning 1287 '@@tx_read_only' is deprecated and will be removed in a future release. Please use '@@transaction_read_only' instead
67 SET @@global.tx_read_only= ON;
68 Warnings:
69 Warning 1287 '@@tx_read_only' is deprecated and will be removed in a future release. Please use '@@transaction_read_only' instead
70 SELECT @@session.tx_read_only, @@global.tx_read_only,
71 @@session.transaction_read_only, @@global.transaction_read_only;
72 @@session.tx_read_only @@global.tx_read_only @@session.transaction_read_only @@global.transaction_read_only
73 0 1 0 1
74 SHOW GLOBAL VARIABLES LIKE '%_read_only';
75 Variable_name Value
76 transaction_read_only ON
77 tx_read_only ON
78 SHOW SESSION VARIABLES LIKE '%_read_only';
79 Variable_name Value
80 transaction_read_only OFF
81 tx_read_only OFF
82 SET STATEMENT tx_read_only= ON FOR SHOW SESSION VARIABLES LIKE '%_read_only';
83 Variable_name Value
84 transaction_read_only ON
85 tx_read_only ON
86 Warnings:
87 Warning 1287 '@@tx_read_only' is deprecated and will be removed in a future release. Please use '@@transaction_read_only' instead
88 Warning 1287 '@@tx_read_only' is deprecated and will be removed in a future release. Please use '@@transaction_read_only' instead
89 SHOW SESSION VARIABLES LIKE '%_read_only';
90 Variable_name Value
91 transaction_read_only OFF
92 tx_read_only OFF
93 # Case 3: Check that the change to transaction_* is reflected to tx_*.
94 SET transaction_isolation= 'SERIALIZABLE';
95 SET @@global.transaction_isolation= 'REPEATABLE-READ';
96 SELECT @@session.tx_isolation, @@global.tx_isolation,
97 @@session.transaction_isolation, @@global.transaction_isolation;
98 @@session.tx_isolation @@global.tx_isolation @@session.transaction_isolation @@global.transaction_isolation
99 SERIALIZABLE REPEATABLE-READ SERIALIZABLE REPEATABLE-READ
100 SHOW GLOBAL VARIABLES LIKE '%_isolation';
101 Variable_name Value
102 transaction_isolation REPEATABLE-READ
103 tx_isolation REPEATABLE-READ
104 SHOW SESSION VARIABLES LIKE '%_isolation';
105 Variable_name Value
106 transaction_isolation SERIALIZABLE
107 tx_isolation SERIALIZABLE
108 SET STATEMENT transaction_isolation= 'REPEATABLE-READ' FOR SHOW SESSION VARIABLES LIKE '%_isolation';
109 Variable_name Value
110 transaction_isolation REPEATABLE-READ
111 tx_isolation REPEATABLE-READ
112 SHOW SESSION VARIABLES LIKE '%_isolation';
113 Variable_name Value
114 transaction_isolation SERIALIZABLE
115 tx_isolation SERIALIZABLE
116 SET transaction_read_only= ON;
117 SET @@global.transaction_read_only= OFF;
118 SELECT @@session.tx_read_only, @@global.tx_read_only,
119 @@session.transaction_read_only, @@global.transaction_read_only;
120 @@session.tx_read_only @@global.tx_read_only @@session.transaction_read_only @@global.transaction_read_only
121 1 0 1 0
122 SHOW GLOBAL VARIABLES LIKE '%_read_only';
123 Variable_name Value
124 transaction_read_only OFF
125 tx_read_only OFF
126 SHOW SESSION VARIABLES LIKE '%_read_only';
127 Variable_name Value
128 transaction_read_only ON
129 tx_read_only ON
130 SET STATEMENT transaction_read_only= OFF FOR SHOW SESSION VARIABLES LIKE '%_read_only';
131 Variable_name Value
132 transaction_read_only OFF
133 tx_read_only OFF
134 SHOW SESSION VARIABLES LIKE '%_read_only';
135 Variable_name Value
136 transaction_read_only ON
137 tx_read_only ON
138 SET @@global.transaction_isolation= @saved_global_isolation;
139 SET @@global.transaction_read_only= @saved_global_read_only;