json/inc/sql_vs_json_notequal.inc

1 echo "Test for SQL vs JSON";
8 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tin as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
11 JSON_TYPE(CAST(a._tin as JSON)) as side1_json_type,
12 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
13 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tin as JSON))) as side1_json_weightage,
14 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
16 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tin as JSON))) <>
17 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
21 and JSON_TYPE(CAST(a._tin as JSON))!='BLOB'
22 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
24 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tin as JSON)))
26 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
34 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._boo as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
37 JSON_TYPE(CAST(a._boo as JSON)) as side1_json_type,
38 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
39 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._boo as JSON))) as side1_json_weightage,
40 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
42 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._boo as JSON))) <>
43 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
47 and JSON_TYPE(CAST(a._boo as JSON))!='BLOB'
48 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
50 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._boo as JSON)))
52 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
59 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._sms as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
62 JSON_TYPE(CAST(a._sms as JSON)) as side1_json_type,
63 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
64 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._sms as JSON))) as side1_json_weightage,
65 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
67 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._sms as JSON))) <>
68 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
72 and JSON_TYPE(CAST(a._sms as JSON))!='BLOB'
73 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
75 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._sms as JSON)))
77 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
86 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mes as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
89 JSON_TYPE(CAST(a._mes as JSON)) as side1_json_type,
90 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
91 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mes as JSON))) as side1_json_weightage,
92 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
94 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mes as JSON))) <>
95 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
99 and JSON_TYPE(CAST(a._mes as JSON))!='BLOB'
100 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
102 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mes as JSON)))
104 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
112 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._meu as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
115 JSON_TYPE(CAST(a._meu as JSON)) as side1_json_type,
116 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
117 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._meu as JSON))) as side1_json_weightage,
118 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
120 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._meu as JSON))) <>
121 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
125 and JSON_TYPE(CAST(a._meu as JSON))!='BLOB'
126 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
128 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._meu as JSON)))
130 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
137 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ins as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
140 JSON_TYPE(CAST(a._ins as JSON)) as side1_json_type,
141 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
142 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ins as JSON))) as side1_json_weightage,
143 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
145 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ins as JSON))) <>
146 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
151 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ins as JSON)))
153 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
160 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._inu as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
163 JSON_TYPE(CAST(a._inu as JSON)) as side1_json_type,
164 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
165 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._inu as JSON))) as side1_json_weightage,
166 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
168 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._inu as JSON))) <>
169 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
173 and JSON_TYPE(CAST(a._inu as JSON))!='BLOB'
174 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
176 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._inu as JSON)))
178 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
186 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bis as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
189 JSON_TYPE(CAST(a._bis as JSON)) as side1_json_type,
190 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
191 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bis as JSON))) as side1_json_weightage,
192 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
194 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bis as JSON))) <>
195 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
199 and JSON_TYPE(CAST(a._bis as JSON))!='BLOB'
200 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
202 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bis as JSON)))
204 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
211 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._biu as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
214 JSON_TYPE(CAST(a._biu as JSON)) as side1_json_type,
215 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
216 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._biu as JSON))) as side1_json_weightage,
217 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
219 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._biu as JSON))) <>
220 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
224 and JSON_TYPE(CAST(a._biu as JSON))!='BLOB'
225 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
227 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._biu as JSON)))
229 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
236 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dec as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
239 JSON_TYPE(CAST(a._dec as JSON)) as side1_json_type,
240 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
241 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dec as JSON))) as side1_json_weightage,
242 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
244 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dec as JSON))) <>
245 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
249 and JSON_TYPE(CAST(a._dec as JSON))!='BLOB'
250 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
252 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dec as JSON)))
254 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
261 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dou as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
264 JSON_TYPE(CAST(a._dou as JSON)) as side1_json_type,
265 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
266 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dou as JSON))) as side1_json_weightage,
267 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
269 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dou as JSON))) <>
270 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
274 and JSON_TYPE(CAST(a._dou as JSON))!='BLOB'
275 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
277 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._dou as JSON)))
279 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
286 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
289 JSON_TYPE(CAST(a._chr as JSON)) as side1_json_type,
290 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
291 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON))) as side1_json_weightage,
292 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
294 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON))) <>
295 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
299 and JSON_TYPE(CAST(a._chr as JSON))!='BLOB'
300 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
302 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON)))
304 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
312 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
315 JSON_TYPE(CAST(a._vch as JSON)) as side1_json_type,
316 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
317 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON))) as side1_json_weightage,
318 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
320 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON))) <>
321 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
325 and JSON_TYPE(CAST(a._vch as JSON))!='BLOB'
326 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
328 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON)))
330 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
338 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
341 JSON_TYPE(CAST(a._bin as JSON)) as side1_json_type,
342 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
343 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON))) as side1_json_weightage,
344 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
346 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON))) <>
347 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
351 and JSON_TYPE(CAST(a._bin as JSON))!='BLOB'
352 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
354 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON)))
356 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
364 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
367 JSON_TYPE(CAST(a._vbn as JSON)) as side1_json_type,
368 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
369 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON))) as side1_json_weightage,
370 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
372 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON))) <>
373 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
377 and JSON_TYPE(CAST(a._vbn as JSON))!='BLOB'
378 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
380 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON)))
382 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
389 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
392 JSON_TYPE(CAST(a._tbl as JSON)) as side1_json_type,
393 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
394 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON))) as side1_json_weightage,
395 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
397 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON))) <>
398 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
402 and JSON_TYPE(CAST(a._tbl as JSON))!='BLOB'
403 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
405 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON)))
407 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
414 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
417 JSON_TYPE(CAST(a._ttx as JSON)) as side1_json_type,
418 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
419 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON))) as side1_json_weightage,
420 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
422 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON))) <>
423 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
427 and JSON_TYPE(CAST(a._ttx as JSON))!='BLOB'
428 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
430 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON)))
432 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
439 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
442 JSON_TYPE(CAST(a._blb as JSON)) as side1_json_type,
443 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
444 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON))) as side1_json_weightage,
445 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
447 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON))) <>
448 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
452 and JSON_TYPE(CAST(a._blb as JSON))!='BLOB'
453 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
455 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON)))
457 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
465 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
468 JSON_TYPE(CAST(a._txt as JSON)) as side1_json_type,
469 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
470 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON))) as side1_json_weightage,
471 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
473 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON))) <>
474 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
478 and JSON_TYPE(CAST(a._txt as JSON))!='BLOB'
479 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
481 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON)))
483 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
490 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
493 JSON_TYPE(CAST(a._mbb as JSON)) as side1_json_type,
494 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
495 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON))) as side1_json_weightage,
496 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
498 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON))) <>
499 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
503 and JSON_TYPE(CAST(a._mbb as JSON))!='BLOB'
504 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
506 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON)))
508 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
515 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
518 JSON_TYPE(CAST(a._mtx as JSON)) as side1_json_type,
519 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
520 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON))) as side1_json_weightage,
521 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
523 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON))) <>
524 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
528 and JSON_TYPE(CAST(a._mtx as JSON))!='BLOB'
529 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
531 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON)))
533 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
540 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
543 JSON_TYPE(CAST(a._lbb as JSON)) as side1_json_type,
544 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
545 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON))) as side1_json_weightage,
546 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
548 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON))) <>
549 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
553 and JSON_TYPE(CAST(a._lbb as JSON))!='BLOB'
554 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
556 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON)))
558 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
565 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
568 JSON_TYPE(CAST(a._ltx as JSON)) as side1_json_type,
569 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
570 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON))) as side1_json_weightage,
571 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
573 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON))) <>
574 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
578 and JSON_TYPE(CAST(a._ltx as JSON))!='BLOB'
579 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
581 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON)))
583 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
590 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
593 JSON_TYPE(CAST(a._enu as JSON)) as side1_json_type,
594 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
595 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON))) as side1_json_weightage,
596 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
598 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON))) <>
599 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
603 and JSON_TYPE(CAST(a._enu as JSON))!='BLOB'
604 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
606 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON)))
608 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
615 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._set as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
618 JSON_TYPE(CAST(a._set as JSON)) as side1_json_type,
619 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
620 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._set as JSON))) as side1_json_weightage,
621 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
623 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._set as JSON))) <>
624 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
628 and JSON_TYPE(CAST(a._set as JSON))!='BLOB'
629 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
631 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._set as JSON)))
633 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))