Debian Codegraph @

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

raw
1 SET @start_global_value = @@GLOBAL.transaction_write_set_extraction;
2 Warnings:
3 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
4 SELECT @start_global_value;
5 @start_global_value
6 OFF
7 SET @start_session_value = @@SESSION.transaction_write_set_extraction;
8 Warnings:
9 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
10 SELECT @start_session_value;
11 @start_session_value
12 OFF
13 SET @start_global_binlog_format = @@GLOBAL.binlog_format;
14 Warnings:
15 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
16 SELECT @start_global_binlog_format;
17 @start_global_binlog_format
18 ROW
19 SET @@GLOBAL.binlog_format= 'ROW';
20 Warnings:
21 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
22 SET global transaction_write_set_extraction= DEFAULT;
23 Warnings:
24 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
25 SELECT @@global.transaction_write_set_extraction;
26 @@global.transaction_write_set_extraction
27 XXHASH64
28 Warnings:
29 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
30 SET global transaction_write_set_extraction='OFF';
31 Warnings:
32 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
33 SELECT @@global.transaction_write_set_extraction;
34 @@global.transaction_write_set_extraction
35 OFF
36 Warnings:
37 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
38 SET global transaction_write_set_extraction= 0;
39 Warnings:
40 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
41 SELECT @@global.transaction_write_set_extraction;
42 @@global.transaction_write_set_extraction
43 OFF
44 Warnings:
45 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
46 SET global transaction_write_set_extraction='MURMUR32';
47 Warnings:
48 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
49 SELECT @@global.transaction_write_set_extraction;
50 @@global.transaction_write_set_extraction
51 MURMUR32
52 Warnings:
53 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
54 SET global transaction_write_set_extraction= 1;
55 Warnings:
56 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
57 SELECT @@global.transaction_write_set_extraction;
58 @@global.transaction_write_set_extraction
59 MURMUR32
60 Warnings:
61 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
62 SET global transaction_write_set_extraction='XXHASH64';
63 Warnings:
64 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
65 SELECT @@global.transaction_write_set_extraction;
66 @@global.transaction_write_set_extraction
67 XXHASH64
68 Warnings:
69 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
70 SET global transaction_write_set_extraction= 2;
71 Warnings:
72 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
73 SELECT @@global.transaction_write_set_extraction;
74 @@global.transaction_write_set_extraction
75 XXHASH64
76 Warnings:
77 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
78 SELECT @@session.transaction_write_set_extraction;
79 @@session.transaction_write_set_extraction
80 OFF
81 Warnings:
82 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
83 SET @@SESSION.binlog_format= 'ROW';
84 Warnings:
85 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
86 SET session transaction_write_set_extraction=DEFAULT;
87 Warnings:
88 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
89 SELECT @@session.transaction_write_set_extraction;
90 @@session.transaction_write_set_extraction
91 XXHASH64
92 Warnings:
93 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
94 SET session transaction_write_set_extraction='OFF';
95 Warnings:
96 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
97 SELECT @@session.transaction_write_set_extraction;
98 @@session.transaction_write_set_extraction
99 OFF
100 Warnings:
101 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
102 SET session transaction_write_set_extraction=0;
103 Warnings:
104 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
105 SELECT @@session.transaction_write_set_extraction;
106 @@session.transaction_write_set_extraction
107 OFF
108 Warnings:
109 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
110 SET session transaction_write_set_extraction='MURMUR32';
111 Warnings:
112 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
113 SELECT @@session.transaction_write_set_extraction;
114 @@session.transaction_write_set_extraction
115 MURMUR32
116 Warnings:
117 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
118 SET session transaction_write_set_extraction=1;
119 Warnings:
120 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
121 SELECT @@session.transaction_write_set_extraction;
122 @@session.transaction_write_set_extraction
123 MURMUR32
124 Warnings:
125 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
126 SET session transaction_write_set_extraction='XXHASH64';
127 Warnings:
128 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
129 SELECT @@session.transaction_write_set_extraction;
130 @@session.transaction_write_set_extraction
131 XXHASH64
132 Warnings:
133 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
134 SET session transaction_write_set_extraction=2;
135 Warnings:
136 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
137 SELECT @@session.transaction_write_set_extraction;
138 @@session.transaction_write_set_extraction
139 XXHASH64
140 Warnings:
141 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
142 SET session transaction_write_set_extraction='ABC';
143 ERROR 42000: Variable 'transaction_write_set_extraction' can't be set to the value of 'ABC'
144 SELECT @@session.transaction_write_set_extraction;
145 @@session.transaction_write_set_extraction
146 XXHASH64
147 Warnings:
148 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
149 SET session transaction_write_set_extraction= 3;
150 ERROR 42000: Variable 'transaction_write_set_extraction' can't be set to the value of '3'
151 SELECT @@session.transaction_write_set_extraction;
152 @@session.transaction_write_set_extraction
153 XXHASH64
154 Warnings:
155 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
156 SET session transaction_write_set_extraction='1';
157 ERROR 42000: Variable 'transaction_write_set_extraction' can't be set to the value of '1'
158 SELECT @@session.transaction_write_set_extraction;
159 @@session.transaction_write_set_extraction
160 XXHASH64
161 Warnings:
162 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
163 SET @@global.transaction_write_set_extraction = @start_global_value;
164 Warnings:
165 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
166 SELECT @@global.transaction_write_set_extraction;
167 @@global.transaction_write_set_extraction
168 OFF
169 Warnings:
170 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
171 SET @@session.transaction_write_set_extraction = @start_session_value;
172 Warnings:
173 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
174 SELECT @@session.transaction_write_set_extraction;
175 @@session.transaction_write_set_extraction
176 OFF
177 Warnings:
178 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
179 SET @@GLOBAL.binlog_format= @start_global_binlog_format;
180 Warnings:
181 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
182 SELECT @@GLOBAL.binlog_format;
183 @@GLOBAL.binlog_format
184 ROW
185 Warnings:
186 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
187 include/assert.inc [The value for transaction_write_set_extraction shoudl be OFF]
188 CREATE TABLE t1 (i INT PRIMARY KEY);
189 SET @start_session_value = @@SESSION.transaction_write_set_extraction;
190 Warnings:
191 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
192 SELECT @start_session_value;
193 @start_session_value
194 OFF
195 BEGIN;
196 SET @@SESSION.transaction_write_set_extraction= MURMUR32;
197 ERROR HY000: The system variable transaction_write_set_extraction cannot be set when there is an ongoing transaction.
198 COMMIT;
199 CREATE TABLE t2(c1 INT, c2 INT);
200 CREATE TRIGGER tr2 AFTER INSERT ON t2 FOR EACH ROW
201 BEGIN
202 SET @@SESSION.transaction_write_set_extraction= MURMUR32;
203 END|
204 INSERT INTO t2 VALUES (0,0);
205 ERROR HY000: The system variable transaction_write_set_extraction cannot be set when there is an ongoing transaction.
206 DROP TABLE t2;
207 SET @@SESSION.transaction_write_set_extraction=MURMUR32;
208 Warnings:
209 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
210 SELECT @@SESSION.transaction_write_set_extraction;
211 @@SESSION.transaction_write_set_extraction
212 MURMUR32
213 Warnings:
214 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
215 SET @@SESSION.transaction_write_set_extraction=OFF;
216 Warnings:
217 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
218 include/assert.inc [The value for transaction_write_set_extraction should be OFF]
219 SET @@SESSION.binlog_format= 'STATEMENT';
220 Warnings:
221 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
222 SET @@SESSION.transaction_write_set_extraction= MURMUR32;
223 ERROR HY000: Cannot change the value of variable transaction_write_set_extraction without binary log format as ROW.
224 SET @@SESSION.binlog_format= 'MIXED';
225 Warnings:
226 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
227 SET @@SESSION.transaction_write_set_extraction= MURMUR32;
228 ERROR HY000: Cannot change the value of variable transaction_write_set_extraction without binary log format as ROW.
229 SET @@SESSION.binlog_format= 'ROW';
230 Warnings:
231 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
232 SET @@SESSION.transaction_write_set_extraction= MURMUR32;
233 Warnings:
234 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
235 SELECT @@SESSION.transaction_write_set_extraction;
236 @@SESSION.transaction_write_set_extraction
237 MURMUR32
238 Warnings:
239 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
240 SET @@SESSION.transaction_write_set_extraction = @start_session_value;
241 Warnings:
242 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
243 SELECT @@SESSION.transaction_write_set_extraction;
244 @@SESSION.transaction_write_set_extraction
245 OFF
246 Warnings:
247 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
248 SET @@GLOBAL.binlog_format= 'STATEMENT';
249 Warnings:
250 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
251 SET @@GLOBAL.transaction_write_set_extraction= MURMUR32;
252 ERROR HY000: Cannot change the value of variable transaction_write_set_extraction without binary log format as ROW.
253 SET @@GLOBAL.binlog_format= 'MIXED';
254 Warnings:
255 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
256 SET @@GLOBAL.transaction_write_set_extraction= MURMUR32;
257 ERROR HY000: Cannot change the value of variable transaction_write_set_extraction without binary log format as ROW.
258 SET @@GLOBAL.binlog_format= 'ROW';
259 Warnings:
260 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
261 SET @@GLOBAL.transaction_write_set_extraction= MURMUR32;
262 Warnings:
263 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
264 SELECT @@GLOBAL.transaction_write_set_extraction;
265 @@GLOBAL.transaction_write_set_extraction
266 MURMUR32
267 Warnings:
268 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
269 SET @@GLOBAL.transaction_write_set_extraction = @start_global_value;
270 Warnings:
271 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
272 SELECT @@GLOBAL.transaction_write_set_extraction;
273 @@GLOBAL.transaction_write_set_extraction
274 OFF
275 Warnings:
276 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
277 SET @@GLOBAL.binlog_format= @start_global_binlog_format;
278 Warnings:
279 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
280 DROP TABLE t1;