Debian Codegraph @

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

raw
1 --source include/have_log_bin.inc
2
3 --echo #### Initialize ####
4 --echo
5
6 SET @start_binlog_row_value_options = @@global.binlog_row_value_options;
7 SET @start_binlog_row_image = @@global.binlog_row_image;
8 SET @start_binlog_format = @@global.binlog_format;
9
10 --echo # Default value
11 SELECT @start_binlog_row_value_options;
12
13 --echo
14 --echo #### Exists as session and global ####
15 --echo
16
17 --echo # Avoid warnings
18 SET SESSION binlog_row_image = MINIMAL;
19 SET GLOBAL binlog_row_image = MINIMAL;
20 SET SESSION binlog_format = 'ROW';
21 SET GLOBAL binlog_format = 'ROW';
22
23 --echo # Test
24 SELECT @@global.binlog_row_value_options;
25 SET @@global.binlog_row_value_options = PARTIAL_JSON;
26 SELECT @@binlog_row_value_options;
27 SET @@binlog_row_value_options= PARTIAL_JSON;
28 SELECT @@session.binlog_row_value_options;
29 SET @@session.binlog_row_value_options = PARTIAL_JSON;
30
31 --echo
32 --echo #### Valid and invalid values ####
33 --echo
34
35 --error ER_PARSE_ERROR
36 SET @@global.binlog_row_value_options = PARTIAL_JSON,PARTIAL_JSON;
37 --error ER_PARSE_ERROR
38 SET @@session.binlog_row_value_options = PARTIAL_JSON,PARTIAL_JSON;
39 SET @@global.binlog_row_value_options = 'PARTIAL_JSON';
40 SET @@session.binlog_row_value_options = 'PARTIAL_JSON';
41 SET @@global.binlog_row_value_options = 'PARTIAL_JSON,PARTIAL_JSON';
42 SET @@session.binlog_row_value_options = 'PARTIAL_JSON,PARTIAL_JSON';
43 SET @@global.binlog_row_value_options = '';
44 SET @@session.binlog_row_value_options = '';
45 SET @@global.binlog_row_value_options = 0;
46 SET @@session.binlog_row_value_options = 0;
47 SET @@global.binlog_row_value_options = 1;
48 SET @@session.binlog_row_value_options = 1;
49 SET @@global.binlog_row_value_options = DEFAULT;
50 SET @@session.binlog_row_value_options = DEFAULT;
51 SELECT @@global.binlog_row_value_options;
52 SELECT @@session.binlog_row_value_options;
53 --error ER_WRONG_VALUE_FOR_VAR
54 SET @@global.binlog_row_value_options = 2;
55 --error ER_WRONG_VALUE_FOR_VAR
56 SET @@session.binlog_row_value_options = 2;
57 --error ER_WRONG_VALUE_FOR_VAR
58 SET @@global.binlog_row_value_options = 'invalid';
59 --error ER_WRONG_VALUE_FOR_VAR
60 SET @@session.binlog_row_value_options = 'invalid';
61 --error ER_WRONG_VALUE_FOR_VAR
62 SET @@global.binlog_row_value_options = NULL;
63 --error ER_WRONG_VALUE_FOR_VAR
64 SET @@session.binlog_row_value_options = NULL;
65 --error ER_WRONG_VALUE_FOR_VAR
66 SET @@global.binlog_row_value_options = ON;
67 --error ER_WRONG_VALUE_FOR_VAR
68 SET @@session.binlog_row_value_options = ON;
69 --error ER_WRONG_VALUE_FOR_VAR
70 SET @@global.binlog_row_value_options = OFF;
71 --error ER_WRONG_VALUE_FOR_VAR
72 SET @@session.binlog_row_value_options = OFF;
73
74 --echo
75 --echo #### Warnings for incompatible options ####
76 --echo
77 --echo ---- Setting session or default value ----
78 --echo
79
80 SET @@global.binlog_row_value_options = '';
81 SET @@session.binlog_row_value_options = 'PARTIAL_JSON';
82
83 --echo
84 --echo # warning for sql_log_bin=0
85 SET SESSION sql_log_bin = 0; # warning
86 SET @@session.binlog_row_value_options = '';
87 SET @@session.binlog_row_value_options = 'PARTIAL_JSON'; # warning
88 SET @@binlog_row_value_options = '';
89 SET @@binlog_row_value_options = 'PARTIAL_JSON'; # warning
90 SET SESSION sql_log_bin = 1;
91
92 --echo
93 --echo # warning for statement
94 SET SESSION binlog_format = statement; # warning
95 SET @@session.binlog_row_value_options = '';
96 SET @@session.binlog_row_value_options = 'PARTIAL_JSON'; # warning
97 SET @@binlog_row_value_options = '';
98 SET @@binlog_row_value_options = 'PARTIAL_JSON'; # warning
99
100 --echo
101 --echo # no warning for mixed or row
102 SET SESSION binlog_format = mixed;
103 SET @@session.binlog_row_value_options = '';
104 SET @@session.binlog_row_value_options = 'PARTIAL_JSON';
105 SET @@binlog_row_value_options = '';
106 SET @@binlog_row_value_options = 'PARTIAL_JSON';
107 SET SESSION binlog_format = 'row';
108 SET @@session.binlog_row_value_options = '';
109 SET @@session.binlog_row_value_options = 'PARTIAL_JSON';
110 SET @@binlog_row_value_options = '';
111 SET @@binlog_row_value_options = 'PARTIAL_JSON';
112
113 --echo
114 --echo # warning for full
115 SET SESSION binlog_row_image = FULL; # warning
116 SET @@session.binlog_row_value_options = '';
117 SET @@session.binlog_row_value_options = 'PARTIAL_JSON'; # warning
118 SET @@binlog_row_value_options = '';
119 SET @@binlog_row_value_options = 'PARTIAL_JSON'; # warning
120
121 --echo
122 --echo # no warning for NOBLOB or MINIMAL
123 SET SESSION binlog_row_image = NOBLOB;
124 SET @@session.binlog_row_value_options = '';
125 SET @@session.binlog_row_value_options = 'PARTIAL_JSON';
126 SET @@binlog_row_value_options = '';
127 SET @@binlog_row_value_options = 'PARTIAL_JSON';
128 SET SESSION binlog_row_image = MINIMAL;
129 SET @@session.binlog_row_value_options = '';
130 SET @@session.binlog_row_value_options = 'PARTIAL_JSON';
131 SET @@binlog_row_value_options = '';
132 SET @@binlog_row_value_options = 'PARTIAL_JSON';
133
134 --echo
135 --echo # warning for old format
136 SET GLOBAL log_bin_use_v1_row_events = 1; # no warning, checked only against global
137 SET @@session.binlog_row_value_options = '';
138 SET @@session.binlog_row_value_options = 'PARTIAL_JSON'; # warning
139
140 --echo
141 --echo # no warning for new format
142 SET GLOBAL log_bin_use_v1_row_events = 0;
143 SET @@session.binlog_row_value_options = '';
144 SET @@session.binlog_row_value_options = 'PARTIAL_JSON';
145
146 --echo
147 --echo ---- Setting global value ----
148 --echo
149
150 SET @@session.binlog_row_value_options = '';
151 SET @@global.binlog_row_value_options = 'PARTIAL_JSON';
152
153 --echo
154 --echo # warning for statement
155 SET GLOBAL binlog_format = statement; # warning
156 SET @@global.binlog_row_value_options = '';
157 SET @@global.binlog_row_value_options = 'PARTIAL_JSON'; # warning
158
159 --echo
160 --echo # no warning for mixed or row
161 SET GLOBAL binlog_format = mixed;
162 SET @@global.binlog_row_value_options = '';
163 SET @@global.binlog_row_value_options = 'PARTIAL_JSON';
164 SET GLOBAL binlog_format = 'row';
165 SET @@global.binlog_row_value_options = '';
166 SET @@global.binlog_row_value_options = 'PARTIAL_JSON';
167
168 --echo
169 --echo # warning for full
170 SET GLOBAL binlog_row_image = FULL; # warning
171 SET @@global.binlog_row_value_options = '';
172 SET @@global.binlog_row_value_options = 'PARTIAL_JSON'; # warning
173
174 --echo
175 --echo # no warning for NOBLOB or MINIMAL
176 SET GLOBAL binlog_row_image = NOBLOB;
177 SET @@global.binlog_row_value_options = '';
178 SET @@global.binlog_row_value_options = 'PARTIAL_JSON';
179 SET GLOBAL binlog_row_image = MINIMAL;
180 SET @@global.binlog_row_value_options = '';
181 SET @@global.binlog_row_value_options = 'PARTIAL_JSON';
182
183 --echo
184 --echo # warning for old format
185 SET GLOBAL log_bin_use_v1_row_events = 1; # warning
186 SET @@global.binlog_row_value_options = '';
187 SET @@global.binlog_row_value_options = 'PARTIAL_JSON'; # warning
188
189 --echo
190 --echo # no warning for new format
191 SET GLOBAL log_bin_use_v1_row_events = 0;
192 SET @@global.binlog_row_value_options = '';
193 SET @@global.binlog_row_value_options = 'PARTIAL_JSON';
194
195 --echo
196 --echo ---- Setting persistent value ----
197 --echo
198
199 SET @@session.binlog_row_value_options = '';
200 SET @@persist.binlog_row_value_options = 'PARTIAL_JSON';
201
202 --echo
203 --echo # warning for statement
204 SET PERSIST binlog_format = statement; # warning
205 SET @@persist.binlog_row_value_options = '';
206 SET @@persist.binlog_row_value_options = 'PARTIAL_JSON'; # warning
207
208 --echo
209 --echo # no warning for mixed or row
210 SET PERSIST binlog_format = mixed;
211 SET @@persist.binlog_row_value_options = '';
212 SET @@persist.binlog_row_value_options = 'PARTIAL_JSON';
213 SET PERSIST binlog_format = 'row';
214 SET @@persist.binlog_row_value_options = '';
215 SET @@persist.binlog_row_value_options = 'PARTIAL_JSON';
216
217 --echo
218 --echo # warning for full
219 SET PERSIST binlog_row_image = FULL; # warning
220 SET @@persist.binlog_row_value_options = '';
221 SET @@persist.binlog_row_value_options = 'PARTIAL_JSON'; # warning
222
223 --echo
224 --echo # no warning for NOBLOB or MINIMAL
225 SET PERSIST binlog_row_image = NOBLOB;
226 SET @@persist.binlog_row_value_options = '';
227 SET @@persist.binlog_row_value_options = 'PARTIAL_JSON';
228 SET PERSIST binlog_row_image = MINIMAL;
229 SET @@persist.binlog_row_value_options = '';
230 SET @@persist.binlog_row_value_options = 'PARTIAL_JSON';
231
232 --echo
233 --echo #### Can't set in transaction, sp, sf, or trigger, or without root ####
234 --echo
235 --echo ---- transaction ----
236 --echo
237
238 BEGIN;
239 --error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
240 SET GLOBAL binlog_row_value_options = '';
241 --error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
242 SET GLOBAL binlog_row_value_options = 'PARTIAL_JSON';
243 --error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
244 SET SESSION binlog_row_value_options = '';
245 --error ER_VARIABLE_NOT_SETTABLE_IN_TRANSACTION
246 SET SESSION binlog_row_value_options = 'PARTIAL_JSON';
247 COMMIT;
248
249 --echo
250 --echo ---- SP ----
251 --echo
252
253 create procedure sp1 () set @@global.binlog_row_value_options = 'PARTIAL_JSON';
254 create procedure sp2 () set @@session.binlog_row_value_options = 'PARTIAL_JSON';
255 create procedure sp3 () set @@persist.binlog_row_value_options = 'PARTIAL_JSON';
256 create procedure sp4 () set @@binlog_row_value_options = 'PARTIAL_JSON';
257 --error ER_VARIABLE_NOT_SETTABLE_IN_SP
258 call sp1();
259 --error ER_VARIABLE_NOT_SETTABLE_IN_SP
260 call sp2();
261 --error ER_VARIABLE_NOT_SETTABLE_IN_SP
262 call sp3();
263 --error ER_VARIABLE_NOT_SETTABLE_IN_SP
264 call sp4();
265
266 --echo
267 --echo ---- SF ----
268 --echo
269
270 --eval create function sf1 () returns int begin set @@global.binlog_row_value_options = 'PARTIAL_JSON'; return 1; end
271 --eval create function sf2 () returns int begin set @@session.binlog_row_value_options = 'PARTIAL_JSON'; return 1; end
272 --eval create function sf3 () returns int begin set @@persist.binlog_row_value_options = 'PARTIAL_JSON'; return 1; end
273 --eval create function sf4 () returns int begin set @@binlog_row_value_options = 'PARTIAL_JSON'; return 1; end
274 --error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
275 select sf1();
276 --error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
277 select sf2();
278 --error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
279 select sf3();
280 --error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
281 select sf4();
282
283 --echo
284 --echo ---- Trigger ----
285 --echo
286
287 create table t1 (a int);
288 create table t2 (a int);
289 create table t3 (a int);
290 create table t4 (a int);
291 create trigger trig1 after insert on t1 for each row set @@global.binlog_row_value_options = 'PARTIAL_JSON';
292 create trigger trig2 before insert on t2 for each row set @@session.binlog_row_value_options = 'PARTIAL_JSON';
293 create trigger trig3 after insert on t3 for each row set @@persist.binlog_row_value_options = 'PARTIAL_JSON';
294 create trigger trig4 before insert on t4 for each row set @@binlog_row_value_options = 'PARTIAL_JSON';
295 --error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
296 insert into t1 values (1);
297 --error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
298 insert into t2 values (1);
299 --error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
300 insert into t3 values (1);
301 --error ER_VARIABLE_NOT_SETTABLE_IN_SF_OR_TRIGGER
302 insert into t4 values (1);
303
304 --echo
305 --echo ---- Non-super ----
306 --echo
307
308 CREATE USER user@localhost;
309 connect(con,localhost,user,,test,$MASTER_MYPORT,);
310 --connection con
311 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
312 SET @@global.binlog_row_value_options = '';
313 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
314 SET @@session.binlog_row_value_options = '';
315 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
316 SET @@persist.binlog_row_value_options = '';
317 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
318 SET @@binlog_row_value_options = '';
319 --connection default
320
321 --echo
322 --echo #### Clean up ####
323 --echo
324
325 DROP USER user@localhost;
326 DROP TABLE t1;
327 DROP TABLE t2;
328 DROP TABLE t3;
329 DROP TABLE t4;
330 DROP FUNCTION sf1;
331 DROP FUNCTION sf2;
332 DROP FUNCTION sf3;
333 DROP FUNCTION sf4;
334 DROP PROCEDURE sp1;
335 DROP PROCEDURE sp2;
336 DROP PROCEDURE sp3;
337 DROP PROCEDURE sp4;
338
339 SET @@global.binlog_row_value_options = @start_binlog_row_value_options;
340 SET @@global.binlog_row_image = @start_binlog_row_image;
341 SET @@global.binlog_format = @start_binlog_format;
342
343 RESET PERSIST;