json/inc/sql_vs_json_equalto.inc

1 echo "Test for SQL vs JSON";
7 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tin as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
10 JSON_TYPE(CAST(a._tin as JSON)) as side1_json_type,
11 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
12 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tin as JSON))) as side1_json_weightage,
13 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
15 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tin as JSON))) =
16 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
20 and JSON_TYPE(CAST(a._tin as JSON))!='BLOB'
21 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
23 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tin as JSON)))
25 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
32 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._boo as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
35 JSON_TYPE(CAST(a._boo as JSON)) as side1_json_type,
36 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
37 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._boo as JSON))) as side1_json_weightage,
38 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
40 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._boo as JSON))) =
41 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
45 and JSON_TYPE(CAST(a._boo as JSON))!='BLOB'
46 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
48 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._boo as JSON)))
50 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
56 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._sms as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
59 JSON_TYPE(CAST(a._sms as JSON)) as side1_json_type,
60 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
61 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._sms as JSON))) as side1_json_weightage,
62 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
64 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._sms as JSON))) =
65 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
69 and JSON_TYPE(CAST(a._sms as JSON))!='BLOB'
70 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
72 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._sms as JSON)))
74 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
82 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mes as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
85 JSON_TYPE(CAST(a._mes as JSON)) as side1_json_type,
86 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
87 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mes as JSON))) as side1_json_weightage,
88 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
90 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mes as JSON))) =
91 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
95 and JSON_TYPE(CAST(a._mes as JSON))!='BLOB'
96 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
98 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mes as JSON)))
100 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
107 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._meu as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
110 JSON_TYPE(CAST(a._meu as JSON)) as side1_json_type,
111 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
112 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._meu as JSON))) as side1_json_weightage,
113 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
115 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._meu as JSON))) =
116 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
120 and JSON_TYPE(CAST(a._meu as JSON))!='BLOB'
121 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
123 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._meu as JSON)))
125 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
131 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ins as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
134 JSON_TYPE(CAST(a._ins as JSON)) as side1_json_type,
135 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
136 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ins as JSON))) as side1_json_weightage,
137 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
139 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ins as JSON))) =
140 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
145 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ins as JSON)))
147 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
153 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._inu as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
156 JSON_TYPE(CAST(a._inu as JSON)) as side1_json_type,
157 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
158 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._inu as JSON))) as side1_json_weightage,
159 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
161 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._inu as JSON))) =
162 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
166 and JSON_TYPE(CAST(a._inu as JSON))!='BLOB'
167 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
169 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._inu as JSON)))
171 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
178 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bis as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
181 JSON_TYPE(CAST(a._bis as JSON)) as side1_json_type,
182 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
183 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bis as JSON))) as side1_json_weightage,
184 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
186 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bis as JSON))) =
187 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
191 and JSON_TYPE(CAST(a._bis as JSON))!='BLOB'
192 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
194 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bis as JSON)))
196 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
202 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._biu as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
205 JSON_TYPE(CAST(a._biu as JSON)) as side1_json_type,
206 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
207 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._biu as JSON))) as side1_json_weightage,
208 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
210 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._biu as JSON))) =
211 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
215 and JSON_TYPE(CAST(a._biu as JSON))!='BLOB'
216 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
218 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._biu as JSON)))
220 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
226 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dec as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
229 JSON_TYPE(CAST(a._dec as JSON)) as side1_json_type,
230 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
231 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dec as JSON))) as side1_json_weightage,
232 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
234 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dec as JSON))) =
235 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
239 and JSON_TYPE(CAST(a._dec as JSON))!='BLOB'
240 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
242 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dec as JSON)))
244 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
250 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dou as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
253 JSON_TYPE(CAST(a._dou as JSON)) as side1_json_type,
254 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
255 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dou as JSON))) as side1_json_weightage,
256 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
258 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dou as JSON))) =
259 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
263 and JSON_TYPE(CAST(a._dou as JSON))!='BLOB'
264 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
266 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dou as JSON)))
268 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
275 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
278 JSON_TYPE(CAST(a._chr as JSON)) as side1_json_type,
279 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
280 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON))) as side1_json_weightage,
281 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
283 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON))) =
284 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
288 and JSON_TYPE(CAST(a._chr as JSON))!='BLOB'
289 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
291 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON)))
293 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
300 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
303 JSON_TYPE(CAST(a._vch as JSON)) as side1_json_type,
304 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
305 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON))) as side1_json_weightage,
306 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
308 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON))) =
309 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
313 and JSON_TYPE(CAST(a._vch as JSON))!='BLOB'
314 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
316 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON)))
318 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
325 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
328 JSON_TYPE(CAST(a._bin as JSON)) as side1_json_type,
329 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
330 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON))) as side1_json_weightage,
331 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
333 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON))) =
334 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
338 and JSON_TYPE(CAST(a._bin as JSON))!='BLOB'
339 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
341 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON)))
343 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
350 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
353 JSON_TYPE(CAST(a._vbn as JSON)) as side1_json_type,
354 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
355 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON))) as side1_json_weightage,
356 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
358 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON))) =
359 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
363 and JSON_TYPE(CAST(a._vbn as JSON))!='BLOB'
364 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
366 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON)))
368 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
374 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
377 JSON_TYPE(CAST(a._tbl as JSON)) as side1_json_type,
378 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
379 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON))) as side1_json_weightage,
380 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
382 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON))) =
383 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
387 and JSON_TYPE(CAST(a._tbl as JSON))!='BLOB'
388 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
390 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON)))
392 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
398 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
401 JSON_TYPE(CAST(a._ttx as JSON)) as side1_json_type,
402 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
403 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON))) as side1_json_weightage,
404 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
406 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON))) =
407 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
411 and JSON_TYPE(CAST(a._ttx as JSON))!='BLOB'
412 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
414 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON)))
416 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
422 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
425 JSON_TYPE(CAST(a._blb as JSON)) as side1_json_type,
426 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
427 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON))) as side1_json_weightage,
428 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
430 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON))) =
431 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
435 and JSON_TYPE(CAST(a._blb as JSON))!='BLOB'
436 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
438 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON)))
440 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
447 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
450 JSON_TYPE(CAST(a._txt as JSON)) as side1_json_type,
451 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
452 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON))) as side1_json_weightage,
453 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
455 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON))) =
456 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
460 and JSON_TYPE(CAST(a._txt as JSON))!='BLOB'
461 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
463 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON)))
465 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
471 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
474 JSON_TYPE(CAST(a._mbb as JSON)) as side1_json_type,
475 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
476 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON))) as side1_json_weightage,
477 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
479 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON))) =
480 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
484 and JSON_TYPE(CAST(a._mbb as JSON))!='BLOB'
485 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
487 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON)))
489 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
495 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
498 JSON_TYPE(CAST(a._mtx as JSON)) as side1_json_type,
499 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
500 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON))) as side1_json_weightage,
501 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
503 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON))) =
504 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
508 and JSON_TYPE(CAST(a._mtx as JSON))!='BLOB'
509 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
511 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON)))
513 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
519 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
522 JSON_TYPE(CAST(a._lbb as JSON)) as side1_json_type,
523 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
524 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON))) as side1_json_weightage,
525 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
527 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON))) =
528 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
532 and JSON_TYPE(CAST(a._lbb as JSON))!='BLOB'
533 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
535 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON)))
537 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
543 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
546 JSON_TYPE(CAST(a._ltx as JSON)) as side1_json_type,
547 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
548 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON))) as side1_json_weightage,
549 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
551 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON))) =
552 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
556 and JSON_TYPE(CAST(a._ltx as JSON))!='BLOB'
557 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
559 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON)))
561 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
567 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
570 JSON_TYPE(CAST(a._enu as JSON)) as side1_json_type,
571 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
572 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON))) as side1_json_weightage,
573 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
575 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON))) =
576 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
580 and JSON_TYPE(CAST(a._enu as JSON))!='BLOB'
581 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
583 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON)))
585 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
591 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._set as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
594 JSON_TYPE(CAST(a._set as JSON)) as side1_json_type,
595 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
596 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._set as JSON))) as side1_json_weightage,
597 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
599 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._set as JSON))) =
600 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
604 and JSON_TYPE(CAST(a._set as JSON))!='BLOB'
605 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
607 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._set as JSON)))
609 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))