innodb/r/zlob_fragments.result

2 CREATE TABLE t1 (j1 JSON) ENGINE=InnoDB ROW_FORMAT=compressed;
6   `j1` json DEFAULT NULL
13 INSERT INTO t1 (j1) VALUES (@json_doc);
14 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
15 JSON_EXTRACT(j1, '$[1]')
17 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
18 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
19 JSON_EXTRACT(j1, '$[1]')
21 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
22 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
23 JSON_EXTRACT(j1, '$[1]')
25 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
26 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
27 JSON_EXTRACT(j1, '$[1]')
29 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
30 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
31 JSON_EXTRACT(j1, '$[1]')
33 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
34 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
35 JSON_EXTRACT(j1, '$[1]')
37 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
38 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
39 JSON_EXTRACT(j1, '$[1]')
41 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
42 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
43 JSON_EXTRACT(j1, '$[1]')
45 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
46 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
47 JSON_EXTRACT(j1, '$[1]')
49 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
50 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
51 JSON_EXTRACT(j1, '$[1]')
53 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
54 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
55 JSON_EXTRACT(j1, '$[1]')
57 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
58 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
59 JSON_EXTRACT(j1, '$[1]')
61 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
62 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
63 JSON_EXTRACT(j1, '$[1]')
65 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
66 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
67 JSON_EXTRACT(j1, '$[1]')
69 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
70 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
71 JSON_EXTRACT(j1, '$[1]')
73 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
74 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
75 JSON_EXTRACT(j1, '$[1]')
77 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
78 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
79 JSON_EXTRACT(j1, '$[1]')
81 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
82 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
83 JSON_EXTRACT(j1, '$[1]')
85 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
86 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
87 JSON_EXTRACT(j1, '$[1]')
89 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
90 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
91 JSON_EXTRACT(j1, '$[1]')
93 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
94 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
95 JSON_EXTRACT(j1, '$[1]')
97 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
98 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
99 JSON_EXTRACT(j1, '$[1]')
101 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
102 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
103 JSON_EXTRACT(j1, '$[1]')
105 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
106 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
107 JSON_EXTRACT(j1, '$[1]')
109 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
110 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
111 JSON_EXTRACT(j1, '$[1]')
113 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
114 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
115 JSON_EXTRACT(j1, '$[1]')
117 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
118 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
119 JSON_EXTRACT(j1, '$[1]')
121 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
122 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
123 JSON_EXTRACT(j1, '$[1]')
125 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
126 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
127 JSON_EXTRACT(j1, '$[1]')
129 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
130 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
131 JSON_EXTRACT(j1, '$[1]')
133 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
134 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
135 JSON_EXTRACT(j1, '$[1]')
137 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
138 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
139 JSON_EXTRACT(j1, '$[1]')
141 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
142 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
143 JSON_EXTRACT(j1, '$[1]')
145 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
146 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
147 JSON_EXTRACT(j1, '$[1]')
149 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
150 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
151 JSON_EXTRACT(j1, '$[1]')
153 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
154 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
155 JSON_EXTRACT(j1, '$[1]')
157 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
158 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
159 JSON_EXTRACT(j1, '$[1]')
161 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
162 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
163 JSON_EXTRACT(j1, '$[1]')
165 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
166 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
167 JSON_EXTRACT(j1, '$[1]')
169 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
170 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
171 JSON_EXTRACT(j1, '$[1]')
173 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
174 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
175 JSON_EXTRACT(j1, '$[1]')
177 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
178 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
179 JSON_EXTRACT(j1, '$[1]')
181 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
182 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
183 JSON_EXTRACT(j1, '$[1]')
185 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
186 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
187 JSON_EXTRACT(j1, '$[1]')
189 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
190 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
191 JSON_EXTRACT(j1, '$[1]')
193 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
194 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
195 JSON_EXTRACT(j1, '$[1]')
197 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
198 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
199 JSON_EXTRACT(j1, '$[1]')
201 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
202 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
203 JSON_EXTRACT(j1, '$[1]')
205 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
206 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
207 JSON_EXTRACT(j1, '$[1]')
209 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
210 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
211 JSON_EXTRACT(j1, '$[1]')
213 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
214 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
215 JSON_EXTRACT(j1, '$[1]')
217 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
218 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
219 JSON_EXTRACT(j1, '$[1]')
221 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
222 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
223 JSON_EXTRACT(j1, '$[1]')
225 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
226 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
227 JSON_EXTRACT(j1, '$[1]')
229 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
230 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
231 JSON_EXTRACT(j1, '$[1]')
233 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
234 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
235 JSON_EXTRACT(j1, '$[1]')
237 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
238 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
239 JSON_EXTRACT(j1, '$[1]')
241 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
242 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
243 JSON_EXTRACT(j1, '$[1]')
245 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
246 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
247 JSON_EXTRACT(j1, '$[1]')
249 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
250 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
251 JSON_EXTRACT(j1, '$[1]')
253 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
254 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
255 JSON_EXTRACT(j1, '$[1]')
257 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
258 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
259 JSON_EXTRACT(j1, '$[1]')
261 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
262 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
263 JSON_EXTRACT(j1, '$[1]')
265 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
266 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
267 JSON_EXTRACT(j1, '$[1]')
269 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
270 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
271 JSON_EXTRACT(j1, '$[1]')
273 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
274 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
275 JSON_EXTRACT(j1, '$[1]')
277 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
278 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
279 JSON_EXTRACT(j1, '$[1]')
281 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
282 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
283 JSON_EXTRACT(j1, '$[1]')
285 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
286 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
287 JSON_EXTRACT(j1, '$[1]')
289 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
290 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
291 JSON_EXTRACT(j1, '$[1]')
293 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
294 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
295 JSON_EXTRACT(j1, '$[1]')
297 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
298 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
299 JSON_EXTRACT(j1, '$[1]')
301 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
302 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
303 JSON_EXTRACT(j1, '$[1]')
305 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
306 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
307 JSON_EXTRACT(j1, '$[1]')
309 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
310 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
311 JSON_EXTRACT(j1, '$[1]')
313 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
314 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
315 JSON_EXTRACT(j1, '$[1]')
317 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
318 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
319 JSON_EXTRACT(j1, '$[1]')
321 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
322 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
323 JSON_EXTRACT(j1, '$[1]')
325 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
326 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
327 JSON_EXTRACT(j1, '$[1]')
329 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
330 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
331 JSON_EXTRACT(j1, '$[1]')
333 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
334 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
335 JSON_EXTRACT(j1, '$[1]')
337 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
338 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
339 JSON_EXTRACT(j1, '$[1]')
341 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
342 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
343 JSON_EXTRACT(j1, '$[1]')
345 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
346 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
347 JSON_EXTRACT(j1, '$[1]')
349 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
350 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
351 JSON_EXTRACT(j1, '$[1]')
353 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
354 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
355 JSON_EXTRACT(j1, '$[1]')
357 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
358 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
359 JSON_EXTRACT(j1, '$[1]')
361 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
362 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
363 JSON_EXTRACT(j1, '$[1]')
365 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
366 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
367 JSON_EXTRACT(j1, '$[1]')
369 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
370 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
371 JSON_EXTRACT(j1, '$[1]')
373 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
374 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
375 JSON_EXTRACT(j1, '$[1]')
377 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
378 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
379 JSON_EXTRACT(j1, '$[1]')
381 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
382 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
383 JSON_EXTRACT(j1, '$[1]')
385 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
386 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
387 JSON_EXTRACT(j1, '$[1]')
389 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
390 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
391 JSON_EXTRACT(j1, '$[1]')
393 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
394 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
395 JSON_EXTRACT(j1, '$[1]')
397 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
398 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
399 JSON_EXTRACT(j1, '$[1]')
401 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
402 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
403 JSON_EXTRACT(j1, '$[1]')
405 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
406 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
407 JSON_EXTRACT(j1, '$[1]')
409 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_2);
410 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
411 JSON_EXTRACT(j1, '$[1]')
413 UPDATE t1 SET j1 = JSON_REPLACE(j1, '$[1]', @medium_str_1);
414 SELECT JSON_EXTRACT(j1, '$[1]') FROM t1;
415 JSON_EXTRACT(j1, '$[1]')