json/inc/sql_vs_json_notequal.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)))
274 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
277 JSON_TYPE(CAST(a._chr as JSON)) as side1_json_type,
278 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
279 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON))) as side1_json_weightage,
280 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
282 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON))) <>
283 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
287 and JSON_TYPE(CAST(a._chr as JSON))!='BLOB'
288 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
290 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._chr as JSON)))
292 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
299 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
302 JSON_TYPE(CAST(a._vch as JSON)) as side1_json_type,
303 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
304 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON))) as side1_json_weightage,
305 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
307 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON))) <>
308 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
312 and JSON_TYPE(CAST(a._vch as JSON))!='BLOB'
313 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
315 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vch as JSON)))
317 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
324 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
327 JSON_TYPE(CAST(a._bin as JSON)) as side1_json_type,
328 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
329 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON))) as side1_json_weightage,
330 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
332 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON))) <>
333 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
337 and JSON_TYPE(CAST(a._bin as JSON))!='BLOB'
338 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
340 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._bin as JSON)))
342 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
349 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
352 JSON_TYPE(CAST(a._vbn as JSON)) as side1_json_type,
353 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
354 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON))) as side1_json_weightage,
355 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
357 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON))) <>
358 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
362 and JSON_TYPE(CAST(a._vbn as JSON))!='BLOB'
363 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
365 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._vbn as JSON)))
367 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
373 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
376 JSON_TYPE(CAST(a._tbl as JSON)) as side1_json_type,
377 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
378 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON))) as side1_json_weightage,
379 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
381 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON))) <>
382 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
386 and JSON_TYPE(CAST(a._tbl as JSON))!='BLOB'
387 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
389 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._tbl as JSON)))
391 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
397 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
400 JSON_TYPE(CAST(a._ttx as JSON)) as side1_json_type,
401 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
402 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON))) as side1_json_weightage,
403 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
405 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON))) <>
406 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
410 and JSON_TYPE(CAST(a._ttx as JSON))!='BLOB'
411 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
413 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ttx as JSON)))
415 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
421 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
424 JSON_TYPE(CAST(a._blb as JSON)) as side1_json_type,
425 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
426 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON))) as side1_json_weightage,
427 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
429 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON))) <>
430 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
434 and JSON_TYPE(CAST(a._blb as JSON))!='BLOB'
435 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
437 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._blb as JSON)))
439 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
446 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
449 JSON_TYPE(CAST(a._txt as JSON)) as side1_json_type,
450 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
451 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON))) as side1_json_weightage,
452 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
454 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON))) <>
455 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
459 and JSON_TYPE(CAST(a._txt as JSON))!='BLOB'
460 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
462 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._txt as JSON)))
464 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
470 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
473 JSON_TYPE(CAST(a._mbb as JSON)) as side1_json_type,
474 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
475 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON))) as side1_json_weightage,
476 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
478 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON))) <>
479 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
483 and JSON_TYPE(CAST(a._mbb as JSON))!='BLOB'
484 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
486 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mbb as JSON)))
488 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
494 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
497 JSON_TYPE(CAST(a._mtx as JSON)) as side1_json_type,
498 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
499 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON))) as side1_json_weightage,
500 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
502 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON))) <>
503 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
507 and JSON_TYPE(CAST(a._mtx as JSON))!='BLOB'
508 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
510 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._mtx as JSON)))
512 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
518 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
521 JSON_TYPE(CAST(a._lbb as JSON)) as side1_json_type,
522 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
523 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON))) as side1_json_weightage,
524 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
526 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON))) <>
527 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
531 and JSON_TYPE(CAST(a._lbb as JSON))!='BLOB'
532 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
534 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._lbb as JSON)))
536 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
542 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
545 JSON_TYPE(CAST(a._ltx as JSON)) as side1_json_type,
546 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
547 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON))) as side1_json_weightage,
548 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
550 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON))) <>
551 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
555 and JSON_TYPE(CAST(a._ltx as JSON))!='BLOB'
556 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
558 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._ltx as JSON)))
560 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
566 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
569 JSON_TYPE(CAST(a._enu as JSON)) as side1_json_type,
570 JSON_TYPE(CAST(b.col as JSON)) as side2_json_type,
571 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON))) as side1_json_weightage,
572 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as side2_json_weightage,
574 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON))) <>
575 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
579 and JSON_TYPE(CAST(a._enu as JSON))!='BLOB'
580 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
582 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._enu as JSON)))
584 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))
590 IF(GET_JSON_WEIGHT(JSON_TYPE(CAST(a._set as JSON)))=GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))…
593 JSON_TYPE(CAST(a._set 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._set 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._set as JSON))) <>
599 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON))) as first_level_validation
603 and JSON_TYPE(CAST(a._set as JSON))!='BLOB'
604 and JSON_TYPE(CAST(b.col as JSON))!='BLOB'
606 GET_JSON_WEIGHT(JSON_TYPE(CAST(a._set as JSON)))
608 GET_JSON_WEIGHT(JSON_TYPE(CAST(b.col as JSON)))