Debian Codegraph @

mysql-test/suite/innodb/r/blob_partial_update_2.result

raw
1 USE test;
2 CREATE TABLE tab(j1 JSON);
3 Table Op Msg_type Msg_text
4 test.tab analyze status OK
5 # Sven
6 json_extract(j1, '$[1]')
7 "Svenxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
8 EXPLAIN
9 {
10 "query_block": {
11 "select_id": 1,
12 "table": {
13 "update": true,
14 "table_name": "tab",
15 "access_type": "ALL",
16 "rows_examined_per_scan": 1,
17 "filtered": "100.00",
18 "partial_update_columns": [
19 "j1"
20 ]
21 }
22 }
23 }
24 Warnings:
25 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_set(`test`.`tab`.`j1`,'$[1]',concat('Viswa',(@`chars128`)))
26 # Show Viswa
27 json_extract(j1, '$[1]')
28 "Viswaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
29 EXPLAIN
30 {
31 "query_block": {
32 "select_id": 1,
33 "table": {
34 "update": true,
35 "table_name": "tab",
36 "access_type": "ALL",
37 "rows_examined_per_scan": 1,
38 "filtered": "100.00",
39 "partial_update_columns": [
40 "j1"
41 ]
42 }
43 }
44 }
45 Warnings:
46 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_replace(`test`.`tab`.`j1`,'$[1]',concat('Nath',(@`chars128`)))
47 # Show Nath
48 json_extract(j1, '$[1]')
49 "Nathxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
50 # Modify column type from JSON to LONGTEXT
51 EXPLAIN
52 {
53 "query_block": {
54 "select_id": 1,
55 "table": {
56 "update": true,
57 "table_name": "tab",
58 "access_type": "ALL",
59 "rows_examined_per_scan": 1,
60 "filtered": "100.00"
61 }
62 }
63 }
64 Warnings:
65 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_set(`test`.`tab`.`j1`,'$[1]',concat('Setlongtext',(@`chars128`)))
66 Table Op Msg_type Msg_text
67 test.tab analyze status OK
68 # Check JSON functions works on TEXT datatype
69 JSON_STORAGE_SIZE(j1)
70 360531
71 JSON_STORAGE_FREE(j1)
72 0
73 # Show Setlongtext
74 json_extract(j1, '$[1]')
75 "Setlongtextxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
76 EXPLAIN
77 {
78 "query_block": {
79 "select_id": 1,
80 "table": {
81 "update": true,
82 "table_name": "tab",
83 "access_type": "ALL",
84 "rows_examined_per_scan": 1,
85 "filtered": "100.00"
86 }
87 }
88 }
89 Warnings:
90 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_replace(`test`.`tab`.`j1`,'$[1]',concat('Replongtext',(@`chars128`)))
91 Table Op Msg_type Msg_text
92 test.tab analyze status OK
93 # Check JSON functions works on TEXT datatype
94 JSON_STORAGE_SIZE(j1)
95 360531
96 JSON_STORAGE_FREE(j1)
97 0
98 # Show Replongtext
99 json_extract(j1, '$[1]')
100 "Replongtextxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
101 When column modify from LONGTEXT to JSON
102 EXPLAIN
103 {
104 "query_block": {
105 "select_id": 1,
106 "table": {
107 "update": true,
108 "table_name": "tab",
109 "access_type": "ALL",
110 "rows_examined_per_scan": 1,
111 "filtered": "100.00",
112 "partial_update_columns": [
113 "j1"
114 ]
115 }
116 }
117 }
118 Warnings:
119 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_set(`test`.`tab`.`j1`,'$[1]',concat('Setjson',(@`chars128`)))
120 Table Op Msg_type Msg_text
121 test.tab analyze status OK
122 # Show Setjson
123 json_extract(j1, '$[1]')
124 "Setjsonxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
125 EXPLAIN
126 {
127 "query_block": {
128 "select_id": 1,
129 "table": {
130 "update": true,
131 "table_name": "tab",
132 "access_type": "ALL",
133 "rows_examined_per_scan": 1,
134 "filtered": "100.00",
135 "partial_update_columns": [
136 "j1"
137 ]
138 }
139 }
140 }
141 Warnings:
142 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_replace(`test`.`tab`.`j1`,'$[1]',concat('Repjson',(@`chars128`)))
143 Table Op Msg_type Msg_text
144 test.tab analyze status OK
145 # Show Repjson
146 json_extract(j1, '$[1]')
147 "Repjsonxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
148 To COMPRESSED
149 Table Create Table
150 tab CREATE TABLE `tab` (
151 `j1` json DEFAULT NULL
152 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED
153 EXPLAIN
154 {
155 "query_block": {
156 "select_id": 1,
157 "table": {
158 "update": true,
159 "table_name": "tab",
160 "access_type": "ALL",
161 "rows_examined_per_scan": 1,
162 "filtered": "100.00",
163 "partial_update_columns": [
164 "j1"
165 ]
166 }
167 }
168 }
169 Warnings:
170 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_set(`test`.`tab`.`j1`,'$[1]',concat('Setcomp',(@`chars128`)))
171 Table Op Msg_type Msg_text
172 test.tab analyze status OK
173 # Show Setcomp
174 json_extract(j1, '$[1]')
175 "Setcompxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
176 EXPLAIN
177 {
178 "query_block": {
179 "select_id": 1,
180 "table": {
181 "update": true,
182 "table_name": "tab",
183 "access_type": "ALL",
184 "rows_examined_per_scan": 1,
185 "filtered": "100.00",
186 "partial_update_columns": [
187 "j1"
188 ]
189 }
190 }
191 }
192 Warnings:
193 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_replace(`test`.`tab`.`j1`,'$[1]',concat('Repcomp',(@`chars128`)))
194 # Show Repcomp
195 json_extract(j1, '$[1]')
196 "Repcompxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
197 COMPRESSED to DYNAMIC
198 Table Op Msg_type Msg_text
199 test.tab analyze status OK
200 Table Create Table
201 tab CREATE TABLE `tab` (
202 `j1` json DEFAULT NULL
203 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC
204 EXPLAIN
205 {
206 "query_block": {
207 "select_id": 1,
208 "table": {
209 "update": true,
210 "table_name": "tab",
211 "access_type": "ALL",
212 "rows_examined_per_scan": 1,
213 "filtered": "100.00",
214 "partial_update_columns": [
215 "j1"
216 ]
217 }
218 }
219 }
220 Warnings:
221 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_set(`test`.`tab`.`j1`,'$[1]',concat('Setdyna',(@`chars128`)))
222 Table Op Msg_type Msg_text
223 test.tab analyze status OK
224 # Show Setdyna
225 json_extract(j1, '$[1]')
226 "Setdynaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
227 EXPLAIN
228 {
229 "query_block": {
230 "select_id": 1,
231 "table": {
232 "update": true,
233 "table_name": "tab",
234 "access_type": "ALL",
235 "rows_examined_per_scan": 1,
236 "filtered": "100.00",
237 "partial_update_columns": [
238 "j1"
239 ]
240 }
241 }
242 }
243 Warnings:
244 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_replace(`test`.`tab`.`j1`,'$[1]',concat('Repdyna',(@`chars128`)))
245 Table Op Msg_type Msg_text
246 test.tab analyze status OK
247 # Show Repdyna
248 json_extract(j1, '$[1]')
249 "Repdynaxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
250 DYNAMIC to REDUNDANT
251 Table Create Table
252 tab CREATE TABLE `tab` (
253 `j1` json DEFAULT NULL
254 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=REDUNDANT
255 EXPLAIN
256 {
257 "query_block": {
258 "select_id": 1,
259 "table": {
260 "update": true,
261 "table_name": "tab",
262 "access_type": "ALL",
263 "rows_examined_per_scan": 1,
264 "filtered": "100.00",
265 "partial_update_columns": [
266 "j1"
267 ]
268 }
269 }
270 }
271 Warnings:
272 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_set(`test`.`tab`.`j1`,'$[1]',concat('Setredu',(@`chars128`)))
273 Table Op Msg_type Msg_text
274 test.tab analyze status OK
275 # Show Setredu
276 json_extract(j1, '$[1]')
277 "Setreduxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
278 EXPLAIN
279 {
280 "query_block": {
281 "select_id": 1,
282 "table": {
283 "update": true,
284 "table_name": "tab",
285 "access_type": "ALL",
286 "rows_examined_per_scan": 1,
287 "filtered": "100.00",
288 "partial_update_columns": [
289 "j1"
290 ]
291 }
292 }
293 }
294 Warnings:
295 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_replace(`test`.`tab`.`j1`,'$[1]',concat('Repredu',(@`chars128`)))
296 # Show Repredu
297 json_extract(j1, '$[1]')
298 "Repreduxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
299 REDUNDANT to COMPACT
300 Table Create Table
301 tab CREATE TABLE `tab` (
302 `j1` json DEFAULT NULL
303 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT
304 Table Op Msg_type Msg_text
305 test.tab analyze status OK
306 EXPLAIN
307 {
308 "query_block": {
309 "select_id": 1,
310 "table": {
311 "update": true,
312 "table_name": "tab",
313 "access_type": "ALL",
314 "rows_examined_per_scan": 1,
315 "filtered": "100.00",
316 "partial_update_columns": [
317 "j1"
318 ]
319 }
320 }
321 }
322 Warnings:
323 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_set(`test`.`tab`.`j1`,'$[1]',concat('Setcomp',(@`chars128`)))
324 Table Op Msg_type Msg_text
325 test.tab analyze status OK
326 # Show Setcomp
327 json_extract(j1, '$[1]')
328 "Setcompxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
329 EXPLAIN
330 {
331 "query_block": {
332 "select_id": 1,
333 "table": {
334 "update": true,
335 "table_name": "tab",
336 "access_type": "ALL",
337 "rows_examined_per_scan": 1,
338 "filtered": "100.00",
339 "partial_update_columns": [
340 "j1"
341 ]
342 }
343 }
344 }
345 Warnings:
346 Note 1003 update `test`.`tab` set `test`.`tab`.`j1` = json_replace(`test`.`tab`.`j1`,'$[1]',concat('Repcomp',(@`chars128`)))
347 # Show Repcomp
348 json_extract(j1, '$[1]')
349 "Repcompxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
350 # Create a view on JSON column
351 EXPLAIN
352 {
353 "query_block": {
354 "select_id": 1,
355 "table": {
356 "update": true,
357 "table_name": "tab",
358 "access_type": "ALL",
359 "rows_examined_per_scan": 1,
360 "filtered": "100.00",
361 "partial_update_columns": [
362 "j1"
363 ]
364 }
365 }
366 }
367 Warnings:
368 Note 1003 update (`test`.`tab`) set `test`.`tab`.`j1` = json_set(`test`.`tab`.`j1`,'$[1]',concat('Setview',(@`chars128`)))
369 Table Op Msg_type Msg_text
370 test.tab analyze status OK
371 # Check JSON functions works on views
372 JSON_STORAGE_SIZE(j1)
373 360531
374 JSON_STORAGE_FREE(j1)
375 4
376 # Show Setview
377 json_extract(j1, '$[1]')
378 "Setviewxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
379 EXPLAIN
380 {
381 "query_block": {
382 "select_id": 1,
383 "table": {
384 "update": true,
385 "table_name": "tab",
386 "access_type": "ALL",
387 "rows_examined_per_scan": 1,
388 "filtered": "100.00",
389 "partial_update_columns": [
390 "j1"
391 ]
392 }
393 }
394 }
395 Warnings:
396 Note 1003 update (`test`.`tab`) set `test`.`tab`.`j1` = json_replace(`test`.`tab`.`j1`,'$[1]',concat('Repview',(@`chars128`)))
397 # Show Repview
398 json_extract(j1, '$[1]')
399 "Repviewxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
400 Table Op Msg_type Msg_text
401 test.tab analyze status OK
402 # Check JSON functions works on views
403 JSON_STORAGE_SIZE(j1)
404 360531
405 JSON_STORAGE_FREE(j1)
406 4
407 # Modify Compression to ZLIB
408 Table Create Table
409 tab CREATE TABLE `tab` (
410 `j1` json DEFAULT NULL
411 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMPRESSION='ZLIB'
412 # Check partial update through procedure
413 Table Op Msg_type Msg_text
414 test.tab analyze status OK
415 # Show Reppro
416 json_extract(j1, '$[1]')
417 "Repproxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
418 # Check JSON functions on views
419 JSON_STORAGE_SIZE(j1)
420 360531
421 JSON_STORAGE_FREE(j1)
422 5
423 # Modify Compression to 'LZ4'
424 Table Create Table
425 tab CREATE TABLE `tab` (
426 `j1` json DEFAULT NULL
427 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMPRESSION='LZ4'
428 # Check partial update through procedure
429 Table Op Msg_type Msg_text
430 test.tab analyze status OK
431 # Show SetLZ
432 json_extract(j1, '$[1]')
433 "SetLZxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"
434 # Check pattern for LOB partial update exist
435 Pattern "LOB partial update" found
436 # Check JSON functions does not work on BLOB type
437 Table Create Table
438 tab1 CREATE TABLE `tab1` (
439 `id` int NOT NULL,
440 `j1` blob,
441 PRIMARY KEY (`id`)
442 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
443 ERROR 22032: Cannot create a JSON value from a string with CHARACTER SET 'binary'.
444 ERROR 22032: Cannot create a JSON value from a string with CHARACTER SET 'binary'.
445 ERROR 22032: Cannot create a JSON value from a string with CHARACTER SET 'binary'.
446 # Check partial update with Generated columns
447 Table Op Msg_type Msg_text
448 test.tab2 analyze status OK
449 ERROR HY000: The value specified for generated column 'c2' in table 'tab2' is not allowed.
450 # Check partial update with partition table
451 Table Create Table
452 tab3 CREATE TABLE `tab3` (
453 `a` int DEFAULT NULL,
454 `j1` json DEFAULT NULL,
455 `j2` json DEFAULT NULL
456 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
457 /*!50100 PARTITION BY LINEAR HASH (`a`)
458 PARTITIONS 3 */
459 a j1 j2
460 1 {"a": "a", "b": "b"} {"a": "a", "b": "b"}
461 1 {"a": "aa", "b": "bb"} {"a": "aa", "b": "bb"}
462 2 NULL NULL
463 2 ["Sachin", "Tendulkar"] ["Virat", "Kohili"]
464 3 [100, {"A1": "Amarnath", "B1": "Binni"}] [200, {"A2": "Azar", "S1": "Srikanth"}]
465 3 {"Sasri": [500, 600], "Chetan": [300, 400]} {"Dhoni": [700, 800], "Sidhu": [900, 100]}
466 Check with JSON_SET
467 EXPLAIN
468 {
469 "query_block": {
470 "select_id": 1,
471 "table": {
472 "update": true,
473 "table_name": "tab3",
474 "partitions": [
475 "p0",
476 "p1",
477 "p2"
478 ],
479 "access_type": "ALL",
480 "rows_examined_per_scan": 6,
481 "filtered": "100.00",
482 "partial_update_columns": [
483 "j1",
484 "j2"
485 ]
486 }
487 }
488 }
489 Warnings:
490 Note 1003 update `test`.`tab3` set `test`.`tab3`.`j1` = json_set(`test`.`tab3`.`j1`,'$.a','x'),`test`.`tab3`.`j2` = json_set(`test`.`tab3`.`j2`,'$.a','y'),`test`.`tab3`.`j1` = json_set(`test`.`tab3`.`j1`,'$.b','z')
491 a j1 j2
492 1 {"a": "x", "b": "z"} {"a": "y", "b": "b"}
493 1 {"a": "x", "b": "z"} {"a": "y", "b": "bb"}
494 2 NULL NULL
495 2 ["Sachin", "Tendulkar"] ["Virat", "Kohili"]
496 3 [100, {"A1": "Amarnath", "B1": "Binni"}] [200, {"A2": "Azar", "S1": "Srikanth"}]
497 3 {"a": "x", "b": "z", "Sasri": [500, 600], "Chetan": [300, 400]} {"a": "y", "Dhoni": [700, 800], "Sidhu": [900, 100]}
498 Check with JSON_REPLACE
499 EXPLAIN
500 {
501 "query_block": {
502 "select_id": 1,
503 "table": {
504 "update": true,
505 "table_name": "tab3",
506 "partitions": [
507 "p0",
508 "p1",
509 "p2"
510 ],
511 "access_type": "ALL",
512 "rows_examined_per_scan": 6,
513 "filtered": "100.00",
514 "partial_update_columns": [
515 "j1"
516 ]
517 }
518 }
519 }
520 Warnings:
521 Note 1003 update `test`.`tab3` set `test`.`tab3`.`j1` = json_replace(`test`.`tab3`.`j1`,'$[1].A1','PartRe')
522 # show PartRe
523 json_extract(j1, '$[1].A1')
524 NULL
525 NULL
526 "PartRe"
527 NULL
528 NULL
529 NULL
530 a j1 j2
531 1 {"a": "x", "b": "z"} {"a": "y", "b": "b"}
532 1 {"a": "x", "b": "z"} {"a": "y", "b": "bb"}
533 2 NULL NULL
534 2 ["Sachin", "Tendulkar"] ["Virat", "Kohili"]
535 3 [100, {"A1": "PartRe", "B1": "Binni"}] [200, {"A2": "Azar", "S1": "Srikanth"}]
536 3 {"a": "x", "b": "z", "Sasri": [500, 600], "Chetan": [300, 400]} {"a": "y", "Dhoni": [700, 800], "Sidhu": [900, 100]}