9_json.sql

SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', `col_jsonvalue`, '\\' ) != NULL LIMIT 0 /* QNO 36 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.medium**[4]', '[NULL,NULL,0,"ijcszxwbj",NULL,true,true,true,0,true,NULL,"jcszxwbjjvvkymalukqukkoeiwsgpm",true,0,true]' ) )= 6 LIMIT 3 /* QNO 40 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$[6]', '$[6].tight' ) = 1 LIMIT 4 /* QNO 44 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 7 /* QNO 46 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 1 /* QNO 52 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[0]', 'false' ) ) = 2 LIMIT 2 /* QNO 57 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[1]', '"ygxqxnvg"', '$."wine"', '0', '$', '0' ) ) = 1 LIMIT 6 /* QNO 58 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 9 /* QNO 60 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$.receive' ) ) = 1 LIMIT 9 /* QNO 61 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'substantially', '\\', '$**.liquid', NULL ) != NULL LIMIT 2 /* QNO 62 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', '"gxqxnvgqm"', '$', 'NULL' ), '$' ) = 1 LIMIT 3 /* QNO 63 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$.when."sign"**' ) = 'reasonable' LIMIT 7 /* QNO 66 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'accuse', 'NULL' ) LIMIT 0 /* QNO 67 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 3 LIMIT 9 /* QNO 72 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$[8]**[5]', '$**.union**', '$[6]' ) = 8 LIMIT 3 /* QNO 74 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$**' ) = 0 LIMIT 4 /* QNO 75 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[7]******', 'false', '$.cap[*]', '"o"', '$."shopping"."violence"****', '0', '$****.especially[1]', '"lpujdnozrhhcxsxwujul"', '$[*][7][0][1]', 'false' ) )= 3 LIMIT 7 /* QNO 78 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$**' ) = 'bulb' LIMIT 9 /* QNO 86 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 0 LIMIT 8 /* QNO 89 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', 'true' ) ) = 4 LIMIT 5 /* QNO 96 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 0 LIMIT 4 /* QNO 110 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 9 /* QNO 120 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'account' LIMIT 3 /* QNO 122 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 0 LIMIT 7 /* QNO 134 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'religion', '0' ) LIMIT 1 /* QNO 137 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 2 LIMIT 0 /* QNO 139 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$' ) ) = 0 LIMIT 3 /* QNO 145 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[0][3][7]**' ) ) = 1 LIMIT 8 /* QNO 147 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 1 LIMIT 1 /* QNO 153 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$."unprecedented"**[8]', '"qqjwasf"', '$**[6][0]', '0', '$**.*', 'false' ) )= 2 LIMIT 9 /* QNO 154 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$[1]' ) ) = 8 LIMIT 3 /* QNO 156 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'die', '0', 'shed', '"qjwasfkvetfoboc"', 'discussion', '0' ) LIMIT 9 /* QNO 159 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 8 LIMIT 0 /* QNO 160 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$', '$', '$[4]' )) = 5 LIMIT 8 /* QNO 36 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 6 LIMIT 6 /* QNO 39 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 6, '\\' ) != NULL LIMIT 0 /* QNO 41 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 1 LIMIT 5 /* QNO 165 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'hv' ) != NULL LIMIT 9 /* QNO 43 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$.*', '$', '$******', '$**.***' ) = 0 LIMIT 0 /* QNO 44 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$**[7]**' ) = 'shadow' LIMIT 6 /* QNO 169 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 9 LIMIT 3 /* QNO 170 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 1 LIMIT 5 /* QNO 171 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 5 LIMIT 9 /* QNO 49 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$**[2][5]' )) = 6 LIMIT 2 /* QNO 51 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$[4]', '$', '$[4]**.seventh' ) = 3 LIMIT 2 /* QNO 175 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 0 LIMIT 8 /* QNO 55 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'career' ) = 1 LIMIT 3 /* QNO 56 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[8]', '$' )) = 3 LIMIT 5 /* QNO 60 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 4 /* QNO 61 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 4 LIMIT 8 /* QNO 181 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 8 LIMIT 4 /* QNO 182 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$****' ) = 0 LIMIT 5 /* QNO 183 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$[8][5]' ) = 0 LIMIT 0 /* QNO 184 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$."automatically"[8]."experienced"**', '$****', '$**[4]**' )) = 5 LIMIT 5 /* QNO 185 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[1].level**[5]' ) ) = 3 LIMIT 0 /* QNO 65 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$' ) ) = 7 LIMIT 9 /* QNO 188 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.ritual[*]."cold"[7]', '"qoeujfhnpgthomsfusbhugmvurbryqq"', '$.musical[5]', 'NULL', '$', 'true' ) )= 2 LIMIT 2 /* QNO 191 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.soil**' )) = 8 LIMIT 8 /* QNO 72 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$**.while', '$**', '$**' )) = 1 LIMIT 4 /* QNO 195 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.warn' ) ) = 8 LIMIT 5 /* QNO 75 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$', '$[3]**[*][8]' )) = 8 LIMIT 2 /* QNO 78 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 7 LIMIT 6 /* QNO 83 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 0 /* QNO 204 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'true', 'false', 'ski', '0', 'whom', '["ryaruryawwlwsbqfcvz",0,NULL,"yarury",0,"aruryawwlwsbqfcvzoyj",NULL,0,true,"ruryawwlwsbqfcvzoyjwzubxoshpnkozayxv",0]', 'both', '"uryawwlwsbqfc"', 'upon', '0', 'type', '0' ) LIMIT 5 /* QNO 85 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'dream' ) = 1 LIMIT 9 /* QNO 86 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 4 LIMIT 7 /* QNO 87 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 9 LIMIT 9 /* QNO 89 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '$[5][3].leap' ) = 1 LIMIT 7 /* QNO 94 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$**[2][*]' )) = 5 LIMIT 1 /* QNO 215 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', 'true' ) ) = 3 LIMIT 0 /* QNO 216 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '$[0]."transformation"****' ) = 1 LIMIT 3 /* QNO 97 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[0]' ) ) = 0 LIMIT 1 /* QNO 104 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**.mild."stack"."prediction"' ) ) = 8 LIMIT 5 /* QNO 222 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 1 LIMIT 9 /* QNO 229 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 8 LIMIT 2 /* QNO 232 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 9 LIMIT 4 /* QNO 233 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 5 LIMIT 6 /* QNO 234 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[5]**', '$**' ) ) = 7 LIMIT 5 /* QNO 118 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 2 LIMIT 9 /* QNO 119 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**."equally"', 'NULL' ) )= 0 LIMIT 6 /* QNO 120 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.image.risk****', '$.refuse', '$', '$**."controversy".perceive**', '$.chain', '$[1].*."plot"', '$[5][1]', '$[7]****.resident', '$' ) ) = 0 LIMIT 5 /* QNO 240 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[1]' ) = 'letter' LIMIT 8 /* QNO 241 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'yard', 'false' ) LIMIT 5 /* QNO 124 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'retailer' ) = 0 LIMIT 2 /* QNO 243 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$."although"**.iron**', '$**[5].ocean', '$."manufacturer"', '$.fighting[6]**' ) = 0 LIMIT 9 /* QNO 245 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 4 /* QNO 247 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$', '$**."taxpayer"', '$.*.*' ) = 7 LIMIT 2 /* QNO 132 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$."appreciation".*[5].conference' ) ) = 7 LIMIT 2 /* QNO 248 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[7]', 'false' ) )= 9 LIMIT 6 /* QNO 250 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$****' ) ) = 0 LIMIT 1 /* QNO 135 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$."long"[1][4]."requirement"' ) ) = 3 LIMIT 1 /* QNO 136 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[4][6][8]**', '$[*].recruit**', '$[0]' ) ) = 9 LIMIT 2 /* QNO 140 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 0 /* QNO 141 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 6 LIMIT 3 /* QNO 257 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$******' ) ) = 6 LIMIT 4 /* QNO 144 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$**.discipline', '$', '$****.*' ) = 0 LIMIT 2 /* QNO 147 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.*[5]', 'true', '$****', '"fwdyawjapjisdwkyabcpchyq"' ) )= 8 LIMIT 4 /* QNO 265 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 7 LIMIT 6 /* QNO 152 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 4 LIMIT 2 /* QNO 36 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$.disturb**.stupid', 'NULL' ) ) = 6 LIMIT 9 /* QNO 153 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$****[8]**' ) = 8 LIMIT 5 /* QNO 37 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$."confident"[8][2][2]', 'NULL', '$**[8].house', 'true', '$**.*.try[4]', 'false', '$[5]', 'NULL', '$.twist****[3]', 'true' ) ) = 6 LIMIT 3 /* QNO 154 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$[3]' ) = 0 LIMIT 9 /* QNO 155 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 4 LIMIT 3 /* QNO 269 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$[5]' ) ) = 1 LIMIT 7 /* QNO 156 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$."solid"**' ) ) = 5 LIMIT 3 /* QNO 41 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'convey', '0' ) LIMIT 8 /* QNO 158 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$[2]' ) ) = 2 LIMIT 2 /* QNO 162 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'workshop', '0' ) LIMIT 0 /* QNO 47 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 0 /* QNO 276 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 9 LIMIT 3 /* QNO 49 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'traffic' LIMIT 8 /* QNO 277 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$', '$.street', '$****' )) = 8 LIMIT 7 /* QNO 167 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 7 LIMIT 3 /* QNO 279 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 8 /* QNO 52 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'bishop', 'true' ) LIMIT 1 /* QNO 169 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '"curtain": NULL' ) = 1 LIMIT 4 /* QNO 57 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[2][3]**', '0', '$[6][5]', 'false' ) ) = 0 LIMIT 9 /* QNO 174 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[4]****' ) = 0 LIMIT 4 /* QNO 58 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$**[6]."anyway"[6]' ) ) = 3 LIMIT 6 /* QNO 288 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$****', '$.***."equal"[6]', '$**.processing****', '$', '$' ) ) = 8 LIMIT 0 /* QNO 60 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', '0' ) ) = 8 LIMIT 9 /* QNO 295 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$' ) ) = 2 LIMIT 0 /* QNO 300 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 2 /* QNO 68 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 2 /* QNO 186 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'dead' ) = 1 LIMIT 4 /* QNO 302 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 8 LIMIT 8 /* QNO 188 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 5 /* QNO 189 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$.twin.client' ) ) = 8 LIMIT 9 /* QNO 305 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$.veteran[1]' ) = 0 LIMIT 3 /* QNO 73 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$.*', '"ywbl"' ) ) = 1 LIMIT 0 /* QNO 307 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'advise', 'false' ) LIMIT 6 /* QNO 195 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 0 LIMIT 3 /* QNO 311 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$******', '$[5].adjust' ) = 0 LIMIT 6 /* QNO 197 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[7]', '"myipugri"', '$******[6]', 'true' ) ) = 6 LIMIT 7 /* QNO 200 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'learn', 'false' ) LIMIT 6 /* QNO 82 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 4 LIMIT 2 /* QNO 314 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 7 LIMIT 9 /* QNO 201 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '"path": 0' ) = 0 LIMIT 7 /* QNO 83 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$' ) ) = 7 LIMIT 4 /* QNO 317 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 8 LIMIT 5 /* QNO 87 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', '', '/', '$[*]**[1]**' ) != NULL LIMIT 2 /* QNO 320 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 2 /* QNO 322 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 8 LIMIT 1 /* QNO 90 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 5 LIMIT 0 /* QNO 210 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$."motive"**' )) = 6 LIMIT 2 /* QNO 211 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 2 /* QNO 327 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', NULL ) != NULL LIMIT 8 /* QNO 329 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'yes', '0', 'cultural', '"rzuqfnwgkszttbtrptyhslmuirbelr"' ) LIMIT 4 /* QNO 332 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$****.*', '$**' ) = 0 LIMIT 6 /* QNO 98 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'formerly' ) = 0 LIMIT 2 /* QNO 220 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.billion.productivity**', '0', '$[4]', 'true', '$****[8]', 'false' ), '$**.*[2]', '$**[8]' ) = 3 LIMIT 5 /* QNO 100 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$**' ) ) = 6 LIMIT 5 /* QNO 102 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '[true,false,NULL,true,true]' ) = 1 LIMIT 5 /* QNO 337 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**[7]' ) ) = 8 LIMIT 6 /* QNO 103 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 3 /* QNO 223 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 6 LIMIT 4 /* QNO 225 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 6 LIMIT 4 /* QNO 339 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$[1]' ) = 8 LIMIT 6 /* QNO 226 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 6 LIMIT 9 /* QNO 111 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 6 /* QNO 227 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[6][7]**' ) = 'silence' LIMIT 7 /* QNO 112 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 5 LIMIT 7 /* QNO 228 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$.empty' ) = 'fragment' LIMIT 1 /* QNO 114 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 5 LIMIT 9 /* QNO 344 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', '', '%', '$**[*]', '\\', '$**."discovery"' ) != NULL LIMIT 6 /* QNO 117 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 3 /* QNO 346 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$**."wheat"[7]' ) = 'quit' LIMIT 9 /* QNO 37 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.whole[*].remaining', '0', '$', '0', '$****.actual', 'NULL', '$.leap', '"adz"' ) )= 4 LIMIT 9 /* QNO 120 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '"kzkvwxijvjcemccmjpud"' ) = 0 LIMIT 2 /* QNO 39 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 0 LIMIT 2 /* QNO 40 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$****' ) = 'holy' LIMIT 2 /* QNO 125 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 2 /* QNO 43 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'northwest', '"vhlsgppxvcfsgj"', 'very', 'NULL' ) LIMIT 1 /* QNO 240 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 3 /* QNO 356 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**."two-thirds"**.technology' ) ) = 6 LIMIT 8 /* QNO 358 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 0 LIMIT 4 /* QNO 243 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$**[0]' )) = 9 LIMIT 3 /* QNO 129 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'fairly', '"bkqeol"' ) LIMIT 1 /* QNO 245 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.vision**.*."budget"', '{"reluctant": false,"reveal": false}', '$.***[3][3]', '0', '$.financial', '"hdfozygwrigsn"', '$', 'true', '$**.but', '0', '$[5]', 'false', '$.*.just**', '0' ), '$**' ) = 4 LIMIT 0 /* QNO 362 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$****' ) ) = 5 LIMIT 4 /* QNO 51 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 6 LIMIT 6 /* QNO 366 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 5 LIMIT 0 /* QNO 249 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$', '"rcxjhglkeshjllblirkodmmuydhquvjy"', '$[5].secondary.*', 'false', '$**[0]', 'true' ) )= 3 LIMIT 6 /* QNO 136 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'deal', '0', 'civilian', '""' ) LIMIT 9 /* QNO 250 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 8 LIMIT 0 /* QNO 137 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'g', '%' ) != NULL LIMIT 4 /* QNO 55 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$**.virus****' ) = 3 LIMIT 4 /* QNO 252 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$.***[6]', '$[3].oral' ) = 0 LIMIT 6 /* QNO 56 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'muscle', 'true', 'organ', 'NULL', 'except', '"lbz"' ) LIMIT 7 /* QNO 370 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$****.*[1]', '$', '$[3].*[5].loyalty' ) = 1 LIMIT 6 /* QNO 141 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 3 LIMIT 2 /* QNO 254 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 1 LIMIT 1 /* QNO 57 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[7]**.assessment', '$' )) = 5 LIMIT 3 /* QNO 255 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 0 LIMIT 4 /* QNO 144 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$', '"bzjdbwlgqivqfexatmnguplgcawnolumpzbqo"' ) )= 5 LIMIT 4 /* QNO 372 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$.lots.reflect' ) = 4 LIMIT 0 /* QNO 61 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 1 LIMIT 5 /* QNO 62 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[2][7]."mother"' ) ) = 1 LIMIT 1 /* QNO 373 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 0 LIMIT 2 /* QNO 258 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 0 LIMIT 5 /* QNO 64 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$."publicity"[4]', 'NULL', '$[7][2]', 'NULL' ) ) = 2 LIMIT 6 /* QNO 148 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 9 LIMIT 9 /* QNO 65 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 6 /* QNO 377 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.trigger[2].furthermore[5]', '$', '$.spare[1][6]', '$[7]."educational"**', '$[6].adolescent', '$."temple".basis.*[4]', '$."a".*."advice"[4]' )) = 4 LIMIT 1 /* QNO 149 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[2]', '"exatmnguplgcawnolumpzbqow"' ) ) = 4 LIMIT 3 /* QNO 379 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**', 'true' ) )= 1 LIMIT 1 /* QNO 150 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[7]' ) = 'bless' LIMIT 2 /* QNO 69 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 0 /* QNO 152 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$' ) = 1 LIMIT 9 /* QNO 155 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$****', 'true', '$', 'false', '$[*]**', 'NULL' ), '$**[1]**', '$**[5][2]' ) = 5 LIMIT 0 /* QNO 71 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 0 /* QNO 158 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 7 /* QNO 268 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[0]."yours".***' ) ) = 4 LIMIT 1 /* QNO 384 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 9 LIMIT 0 /* QNO 385 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 8 LIMIT 8 /* QNO 386 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[7]', 'NULL' ) )= 1 LIMIT 6 /* QNO 160 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'pastor' ) = 0 LIMIT 3 /* QNO 387 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 1 ) != NULL LIMIT 8 /* QNO 161 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[1].route' ) = 0 LIMIT 0 /* QNO 162 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$**' ) = 1 LIMIT 1 /* QNO 271 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**[*]' ) ) = 7 LIMIT 7 /* QNO 163 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0', '$.marketplace.***' ) = 0 LIMIT 9 /* QNO 164 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[2]', '0', '$**[2].forth', '"wserbagjcbdqlounyrwjdssmninfppitmxrnj"', '$[*].*[5]**', '"serbagjc"' ) )= 5 LIMIT 5 /* QNO 272 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 9 /* QNO 78 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 7 LIMIT 6 /* QNO 79 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 6 /* QNO 274 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"ecmafaphqpxdaeigembhbqxxilftdzowxktyud"', '$' ) = 0 LIMIT 0 /* QNO 82 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 5 LIMIT 7 /* QNO 84 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$****[6]**', 'NULL' ) )= 5 LIMIT 6 /* QNO 278 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'false' ) = 0 LIMIT 2 /* QNO 398 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$[2][0]**' ) = 4 LIMIT 6 /* QNO 175 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 7 /* QNO 177 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"jxkwgzzc"', '$' ) = 1 LIMIT 8 /* QNO 282 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 7 LIMIT 2 /* QNO 284 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$**.sweet' ) ) = 3 LIMIT 7 /* QNO 181 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$', '"hcdhjlcvspdwvsstqp"', '$[8]**.british."funding"', 'false' ) )= 8 LIMIT 9 /* QNO 91 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', '', '"', '$."suit"[8].tighten', '/', '$**."yes"' ) != NULL LIMIT 9 /* QNO 404 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$', '"diuv"' ) )= 2 LIMIT 0 /* QNO 182 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 8 /* QNO 406 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 8 LIMIT 2 /* QNO 289 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 8 LIMIT 5 /* QNO 409 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 8 LIMIT 3 /* QNO 96 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 6 LIMIT 1 /* QNO 97 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 8 /* QNO 189 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$****.juror.*', '"y"' ) )= 9 LIMIT 3 /* QNO 411 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 4 LIMIT 0 /* QNO 293 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'faint', 'NULL', 'governor', 'false' ) LIMIT 1 /* QNO 190 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[4].policy', '0', '$."attraction".*[8].work', 'NULL', '$**.*."autonomy"', 'NULL', '$.*.*', '"l"' ) )= 1 LIMIT 4 /* QNO 99 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 6 LIMIT 1 /* QNO 413 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[1]."pot"[8]' ) ) = 2 LIMIT 9 /* QNO 193 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$' ) = 2 LIMIT 6 /* QNO 104 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 4 LIMIT 0 /* QNO 417 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[*]' ) = 1 LIMIT 5 /* QNO 197 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', '', '%', '$' ) != NULL LIMIT 9 /* QNO 300 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$."texture"[5]."where"[5]', '$.excited**' ) = 2 LIMIT 5 /* QNO 301 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'era', 'NULL', 'interact', 'true', 'two', 'NULL', 'until', 'false', 'compliance', 'NULL', 'immediately', 'NULL' ) LIMIT 6 /* QNO 108 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '$.nowhere[1]' ) = 0 LIMIT 6 /* QNO 303 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'dot' LIMIT 5 /* QNO 110 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 9 LIMIT 1 /* QNO 203 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[2][4]' ) ) = 1 LIMIT 9 /* QNO 425 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$.terrorist[8]' ) ) = 9 LIMIT 5 /* QNO 204 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$."shot".coin**.*' ) ) = 3 LIMIT 9 /* QNO 205 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$[6]****', '$**[7].bold' ) = 9 LIMIT 4 /* QNO 112 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$****[5]' ) = 'sack' LIMIT 2 /* QNO 427 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 1 LIMIT 9 /* QNO 428 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'hockey' LIMIT 5 /* QNO 114 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 9 /* QNO 430 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'brave', 'true', 'equally', '0', 'improvement', '"hjjpwye"' ) LIMIT 8 /* QNO 310 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 9 /* QNO 313 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 4 /* QNO 121 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 6, 'u' ) != NULL LIMIT 3 /* QNO 316 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '$[7]' ) = 1 LIMIT 8 /* QNO 122 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.*[*][8]**' ) ) = 9 LIMIT 5 /* QNO 214 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 2 /* QNO 317 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 5 LIMIT 5 /* QNO 216 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', NULL, '"' ) != NULL LIMIT 7 /* QNO 126 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$[7]**', '$********' ) = 1 LIMIT 3 /* QNO 440 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'laugh', 'y' ) != NULL LIMIT 4 /* QNO 218 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$' ) = 1 LIMIT 1 /* QNO 321 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 9 LIMIT 2 /* QNO 220 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 2 LIMIT 4 /* QNO 326 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '"steam": "bvs"' ) = 0 LIMIT 5 /* QNO 223 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**' ) ) = 5 LIMIT 2 /* QNO 135 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$' ) ) = 7 LIMIT 2 /* QNO 224 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '"period": 0' ) = 1 LIMIT 3 /* QNO 136 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 2 LIMIT 3 /* QNO 226 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$.*' ) = 1 LIMIT 9 /* QNO 139 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 0, '"', '$******' ) != NULL LIMIT 4 /* QNO 140 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[8]', '0', '$.speaker**."balloon"[8]', 'true', '$', '"udpyzyjkgahycahabnphdcaslvchxhbxlurcswa"' ), '$**.*.divine', '$[2]."face"[7]', '$.nothing', '$' ) = 0 LIMIT 7 /* QNO 448 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$.arrest[0]', '$.behind[7]**', '$', '$.wrap**.***', '$.*.city.*', '$[8]', '$."expansion"**', '$**[0].whip', '$[7]' ) = 3 LIMIT 2 /* QNO 330 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$.freeze', 'true' ) ) = 0 LIMIT 9 /* QNO 450 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**', 'NULL', '$**."typically"**.nor', 'NULL' ) )= 6 LIMIT 3 /* QNO 142 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.defendant', 'true', '$', 'true', '$**', '"drtjctatqmhdpnsjznruanrsabcrrxx"' ) )= 5 LIMIT 1 /* QNO 144 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 5 LIMIT 4 /* QNO 454 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 0 LIMIT 5 /* QNO 339 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 5 LIMIT 2 /* QNO 457 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 0 /* QNO 459 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 4 /* QNO 240 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 5 LIMIT 4 /* QNO 342 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'true', '$**[5].*.sale' ) = 1 LIMIT 0 /* QNO 343 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 9 LIMIT 8 /* QNO 242 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', 'false' ) ) = 9 LIMIT 0 /* QNO 244 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$**[7][7][4]' ) ) = 5 LIMIT 5 /* QNO 149 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$.government**[5]**' ) = 'god' LIMIT 3 /* QNO 463 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 4 LIMIT 2 /* QNO 245 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.precisely[*]', '$[0]', '$[7][0][5][7]' ) ) = 4 LIMIT 9 /* QNO 246 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$****', '$' ) = 0 LIMIT 5 /* QNO 153 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 5, 'n', '$****.*[4]', '%', '$[6]**[4]**' ) != NULL LIMIT 5 /* QNO 247 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.procedure' ) ) = 6 LIMIT 9 /* QNO 468 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$**[5][2][7]', '"xzaktyctxfbmdairlzzoekszns"' ) ) = 6 LIMIT 0 /* QNO 154 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 5 /* QNO 156 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$.electric' ) ) = 0 LIMIT 0 /* QNO 352 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[2]' )) = 7 LIMIT 4 /* QNO 471 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[0]' ) ) = 9 LIMIT 7 /* QNO 158 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$.locate[5][8]', '$[1]**[7]**', '$**."exception"****', '$.***[5][4]', '$' ) = 1 LIMIT 9 /* QNO 251 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 9 /* QNO 354 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$', '$**' ) = 0 LIMIT 7 /* QNO 355 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$**[*]**', 'false', '$', '"qizihulkfseopxaiqqlgwivyynbva"' ) ) = 8 LIMIT 5 /* QNO 253 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 4 LIMIT 4 /* QNO 356 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 8 /* QNO 163 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$[5]', '$', '$[6].favorable', '$[3].*' ) = 5 LIMIT 0 /* QNO 477 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 3 LIMIT 9 /* QNO 166 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$.like**[2].*' ) ) = 9 LIMIT 8 /* QNO 361 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'totally', 'NULL' ) LIMIT 3 /* QNO 481 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 6 /* QNO 364 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0' ) = 0 LIMIT 8 /* QNO 171 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'want' ) != NULL LIMIT 9 /* QNO 486 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.*[8].definition' )) = 2 LIMIT 8 /* QNO 172 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 5 LIMIT 3 /* QNO 488 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 8 LIMIT 1 /* QNO 264 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 1 LIMIT 1 /* QNO 265 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'false' ) = 0 LIMIT 8 /* QNO 489 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$.poster[6]**."icon"' ) = 1 LIMIT 2 /* QNO 266 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$' ) ) = 3 LIMIT 5 /* QNO 372 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$', '$**' )) = 8 LIMIT 6 /* QNO 491 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$**[5]' ) ) = 6 LIMIT 2 /* QNO 178 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 8 /* QNO 374 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$**', '$.*.body****' ) = 0 LIMIT 5 /* QNO 268 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$.***[7][8]', '0', '$****.quiet', '0' ) ) = 9 LIMIT 0 /* QNO 495 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'suppose', '"', '$' ) != NULL LIMIT 5 /* QNO 496 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$."political"******' ) ) = 6 LIMIT 8 /* QNO 184 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[2][4]' ) = 'relative' LIMIT 1 /* QNO 274 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'everyone' ) = 0 LIMIT 5 /* QNO 498 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 1 LIMIT 7 /* QNO 501 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$**' ) ) = 8 LIMIT 2 /* QNO 190 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[5][7]****' ) = 0 LIMIT 6 /* QNO 388 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[8][8][5].reaction' ) = 'suburb' LIMIT 3 /* QNO 194 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.*', '0', '$**', 'false', '$[1]', 'NULL' ) )= 5 LIMIT 4 /* QNO 285 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 3 LIMIT 3 /* QNO 508 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 5 /* QNO 286 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 9 LIMIT 8 /* QNO 197 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'bless', '0' ) LIMIT 8 /* QNO 287 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[5][1]**' ) = 1 LIMIT 6 /* QNO 198 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 6 LIMIT 9 /* QNO 511 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'computer', "'", '$**.privilege."rain"**', NULL ) != NULL LIMIT 7 /* QNO 290 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0' ) = 1 LIMIT 4 /* QNO 200 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$[5].*' ) = 0 LIMIT 3 /* QNO 393 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.about', '"vcr"' ) ) = 0 LIMIT 3 /* QNO 291 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 8 LIMIT 8 /* QNO 203 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 7 LIMIT 1 /* QNO 397 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.disturb.neighbor**', '$.gasoline[7].***' )) = 8 LIMIT 7 /* QNO 515 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 3 /* QNO 204 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$[0][0]' ) = 0 LIMIT 0 /* QNO 294 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'little', '"', '$' ) != NULL LIMIT 2 /* QNO 516 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 2 /* QNO 517 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 2 LIMIT 1 /* QNO 206 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'dj', 'w', '$' ) != NULL LIMIT 1 /* QNO 399 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 8 LIMIT 4 /* QNO 207 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 7 /* QNO 208 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$**[2][6][*]' ) = 0 LIMIT 1 /* QNO 209 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 3 /* QNO 401 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', 'false', '$', 'true' ) ) = 2 LIMIT 9 /* QNO 212 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"ls"', '$**' ) = 0 LIMIT 2 /* QNO 300 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 9 LIMIT 3 /* QNO 524 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 7 /* QNO 214 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 2 LIMIT 4 /* QNO 525 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$' ) ) = 2 LIMIT 5 /* QNO 526 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 7 LIMIT 8 /* QNO 302 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[2][7]', '$[4][1]****', '$[2]' )) = 5 LIMIT 2 /* QNO 406 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 2 LIMIT 1 /* QNO 217 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[7]', 'false' ) ) = 8 LIMIT 4 /* QNO 218 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**.cholesterol[4]**' ) = 0 LIMIT 8 /* QNO 529 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$."react"' ) = 0 LIMIT 5 /* QNO 409 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 4 /* QNO 531 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$.lunch.***' ) = 1 LIMIT 0 /* QNO 410 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"lakthpp"', '$[8][3]**' ) = 0 LIMIT 2 /* QNO 307 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$', '$[4].soar[6][7]', '$.*' ) = 0 LIMIT 6 /* QNO 411 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.*', '$.vehicle."banking".church**' ) ) = 6 LIMIT 2 /* QNO 412 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 3 LIMIT 2 /* QNO 309 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.neither[4][0]', '"ccmxmolqrjuc"' ) )= 5 LIMIT 7 /* QNO 413 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$' ) ) = 9 LIMIT 9 /* QNO 534 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 9 LIMIT 3 /* QNO 311 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '$******' ) = 1 LIMIT 3 /* QNO 224 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'oh' ) != NULL LIMIT 3 /* QNO 225 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.*[3]."joke"**', '"pzsupoviiazrsvrdreike"', '$', 'false', '$****', 'true' ) )= 1 LIMIT 1 /* QNO 312 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[1]', '0', '$', 'true' ) ) = 1 LIMIT 0 /* QNO 416 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 2 /* QNO 538 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$."effort"."tour"', '$' )) = 2 LIMIT 0 /* QNO 313 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[7]' ) ) = 6 LIMIT 3 /* QNO 315 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$[7].***' ) = 1 LIMIT 3 /* QNO 419 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 1 /* QNO 228 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 4 LIMIT 4 /* QNO 316 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 1 LIMIT 2 /* QNO 542 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$****[1]', '[false]', '$[3]****', '{"volunteer": 0,"african": 0,"tender": NULL,"player": {"cup": true,"other": "ivucnzmowjt","climate": false,"street": true,"guest": "vucn"}}' ) ) = 9 LIMIT 3 /* QNO 229 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'press', '[0,"suzx",0,"uzx",true]', 'anybody', '0' ) LIMIT 0 /* QNO 421 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 0 /* QNO 230 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', '"zxqlifekfpgtnyaiv"', '$.cell[7][7]**', '0', '$."shelter"[5]**', '0', '$[*].faster', '"xqlifekfpgtnyaivpnuqbjm"' ), '$[2]', '$.sort' ) = 0 LIMIT 7 /* QNO 422 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**.wipe.scenario[8]' ) = 0 LIMIT 5 /* QNO 231 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0' ) = 1 LIMIT 2 /* QNO 318 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'dealer', '"w"', 'unknown', '0' ) LIMIT 5 /* QNO 546 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 6 LIMIT 5 /* QNO 235 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 5 ) != NULL LIMIT 6 /* QNO 236 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.african-american' )) = 5 LIMIT 0 /* QNO 549 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$' ) = 1 LIMIT 7 /* QNO 428 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$**', '$[5]**[3].*' ) = 6 LIMIT 8 /* QNO 550 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 8 /* QNO 323 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 8 LIMIT 4 /* QNO 237 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$[3][8][7]**', '$.tile' ) = 5 LIMIT 8 /* QNO 553 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 7 LIMIT 1 /* QNO 242 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 8 LIMIT 6 /* QNO 432 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.companion[4].artistic', 'true', '$**[0][6]', '0', '$****', 'true', '$****', '"kbxwhnftphzrxcssotowzehot"' ) ) = 3 LIMIT 8 /* QNO 329 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[1].performer', 'true' ), '$.***' ) = 5 LIMIT 2 /* QNO 243 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0', '$' ) = 0 LIMIT 3 /* QNO 244 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"otircyngxo"' ) = 1 LIMIT 3 /* QNO 435 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[6]', '0' ) ) = 2 LIMIT 9 /* QNO 557 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.stem."agree"' ) ) = 2 LIMIT 1 /* QNO 246 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[6][4].it[*]' ) = 'preliminary' LIMIT 6 /* QNO 437 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 0 /* QNO 334 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$' ) ) = 4 LIMIT 1 /* QNO 559 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.***', 'NULL' ) )= 1 LIMIT 3 /* QNO 560 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[3]**[0][2]' ) ) = 9 LIMIT 1 /* QNO 336 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 2 LIMIT 2 /* QNO 337 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$[6].*[5]."divide"' ) ) = 3 LIMIT 7 /* QNO 250 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'commercial', '0' ) LIMIT 6 /* QNO 338 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 1 LIMIT 3 /* QNO 340 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '$[8][2][5]**' ) = 0 LIMIT 3 /* QNO 343 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$' ) = 5 LIMIT 1 /* QNO 570 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[*]**.mr[1]', '$**.*[3]**', '$.*' )) = 5 LIMIT 0 /* QNO 571 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'gear' ) = 1 LIMIT 0 /* QNO 574 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 0 LIMIT 4 /* QNO 575 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$**.*', '$' ) ) = 5 LIMIT 8 /* QNO 351 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'collaboration' ) = 0 LIMIT 1 /* QNO 577 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$**[6].*', '$.gut', '$.*', '$', '$.secure' )) = 4 LIMIT 3 /* QNO 260 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'yellow' LIMIT 6 /* QNO 261 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', '', 'u', '$**' ) != NULL LIMIT 5 /* QNO 354 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$' )) = 8 LIMIT 1 /* QNO 265 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$.like[3]."passage"' ) ) = 4 LIMIT 8 /* QNO 457 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"lvggcheofvxjrtmaxcunwulhu"', '$' ) = 0 LIMIT 1 /* QNO 266 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**[0]', '0', '$[0]**', 'true' ) )= 6 LIMIT 1 /* QNO 458 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$**.desperate.area**', '$[1]****."what"', '$.*.passing.fraud.*', '$', '$[3].*.jaw[0]', '$**[5][3]' ) ) = 2 LIMIT 3 /* QNO 358 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$.***."badly"' ) = 0 LIMIT 1 /* QNO 267 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$' ) = 0 LIMIT 1 /* QNO 268 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'false' ) = 1 LIMIT 4 /* QNO 360 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 3 LIMIT 9 /* QNO 269 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$.tube' ) ) = 8 LIMIT 8 /* QNO 362 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 9 LIMIT 9 /* QNO 588 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[5][3]', '"jdinvmzaptyxea"' ) )= 2 LIMIT 8 /* QNO 463 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$' ) = 1 LIMIT 8 /* QNO 365 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 4 LIMIT 4 /* QNO 275 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$[2]."enact"[7].*', '$[7].*****' ) = 3 LIMIT 3 /* QNO 591 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$' ) = 1 LIMIT 1 /* QNO 466 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 5 LIMIT 8 /* QNO 467 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$**.rice', 'true' ) ) = 4 LIMIT 5 /* QNO 277 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$', '"bhthfojsfapfedizckcdnvqjeqrkqcyn"', '$', '"hthfojsfapfedizckcd"' ) )= 8 LIMIT 4 /* QNO 594 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 9 LIMIT 6 /* QNO 370 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**' ) ) = 8 LIMIT 7 /* QNO 280 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'vital', 'NULL', 'kind', 'true' ) LIMIT 1 /* QNO 472 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', NULL ) != NULL LIMIT 0 /* QNO 372 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', '"thfojsfa"', '$', 'NULL' ) ) = 0 LIMIT 5 /* QNO 600 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$**.hurricane[5]' ) = 0 LIMIT 2 /* QNO 283 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[3]."appeal"' ) ) = 7 LIMIT 8 /* QNO 374 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 7 LIMIT 4 /* QNO 603 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[0].*[1][5]', '"asxqgu"' ) )= 6 LIMIT 9 /* QNO 477 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$', '$[3]' )) = 4 LIMIT 2 /* QNO 376 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'lot', '0', 'alone', '0' ) LIMIT 6 /* QNO 606 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$."stroke".customer' ) = 0 LIMIT 2 /* QNO 377 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', '"izckcdnv"', '$.*[*]', 'false', '$.*[7].*[2]', '0' ) ) = 5 LIMIT 2 /* QNO 610 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$."glance"[4]', '"if"', '$."pain"**', 'true' ) )= 2 LIMIT 0 /* QNO 290 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 1 LIMIT 0 /* QNO 484 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**' ) ) = 0 LIMIT 7 /* QNO 292 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$**' ) = 'ecosystem' LIMIT 1 /* QNO 382 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[7]**' ) ) = 9 LIMIT 5 /* QNO 614 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 3 LIMIT 5 /* QNO 615 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 6 LIMIT 6 /* QNO 385 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 1 LIMIT 1 /* QNO 297 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[3]."tribe"' )) = 3 LIMIT 7 /* QNO 386 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 5, '\\' ) != NULL LIMIT 8 /* QNO 490 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$', '$******' )) = 5 LIMIT 2 /* QNO 388 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 0 LIMIT 7 /* QNO 299 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$.flexibility' ) = 6 LIMIT 0 /* QNO 619 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$.overcome.*.talent[6]' ) = 9 LIMIT 6 /* QNO 491 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 6 /* QNO 300 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$[7]**[6][7]' ) ) = 8 LIMIT 3 /* QNO 492 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[4]."bury"[3]' ) ) = 2 LIMIT 4 /* QNO 302 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$[0]' ) = 1 LIMIT 9 /* QNO 623 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0', '$' ) = 1 LIMIT 6 /* QNO 391 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$****' ) = 0 LIMIT 9 /* QNO 305 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 3 LIMIT 4 /* QNO 394 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 2 LIMIT 9 /* QNO 625 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$****' ) = 0 LIMIT 3 /* QNO 306 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'true' ) = 0 LIMIT 6 /* QNO 395 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[6]******' ) = 'album' LIMIT 7 /* QNO 307 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'assignment', 'NULL', 'reveal', 'NULL' ) LIMIT 2 /* QNO 308 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[4]', '$******', '$.*[8]."involvement".shape' ) ) = 3 LIMIT 7 /* QNO 396 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 9 LIMIT 0 /* QNO 309 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0' ) = 0 LIMIT 3 /* QNO 498 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$**."french"[7][2]', 'NULL', '$', '"wxojcvbwmolptxulqoxe"', '$', 'NULL', '$', '0' ) ) = 9 LIMIT 5 /* QNO 397 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'true' ) = 0 LIMIT 3 /* QNO 500 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$', '$[5]' ) = 8 LIMIT 4 /* QNO 398 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 6 LIMIT 4 /* QNO 630 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0' ) = 1 LIMIT 8 /* QNO 312 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'b', '%', '$."flood"', NULL, '$' ) != NULL LIMIT 3 /* QNO 631 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$', '$**.aid[1]' ) ) = 7 LIMIT 4 /* QNO 316 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[2]', 'NULL', '$****', 'NULL', '$', '"olptxulq"' ) ) = 2 LIMIT 3 /* QNO 403 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$."score"**', '$', '$**[7]**' )) = 7 LIMIT 9 /* QNO 636 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 7 LIMIT 4 /* QNO 405 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '$' ) = 1 LIMIT 7 /* QNO 637 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 1 LIMIT 1 /* QNO 638 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$****', '$[4]."lots"', '$.grace[*]' ) = 1 LIMIT 0 /* QNO 510 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 6 LIMIT 2 /* QNO 407 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'quietly', '"', '$', '"' ) != NULL LIMIT 7 /* QNO 641 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$.*.to**' ) = 'doctrine' LIMIT 4 /* QNO 322 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '[]' ) = 0 LIMIT 0 /* QNO 644 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 3 /* QNO 514 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'bw', '"', '$.*****' ) != NULL LIMIT 5 /* QNO 327 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$**[2]**' ) ) = 6 LIMIT 6 /* QNO 646 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$[*]', '$.its**[7]', '$**' ) = 0 LIMIT 3 /* QNO 328 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$."interact"**' ) = 1 LIMIT 9 /* QNO 412 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$.*[3][7]' ) = 0 LIMIT 5 /* QNO 516 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$**' ) = 'weapon' LIMIT 1 /* QNO 517 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 6 /* QNO 648 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 3 LIMIT 1 /* QNO 330 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**."reach"' ) ) = 4 LIMIT 9 /* QNO 650 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$**[2][4]' ) = 'exhibit' LIMIT 7 /* QNO 332 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**.builder[8]' ) = 0 LIMIT 2 /* QNO 651 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'bite', '%', '$**[4]' ) != NULL LIMIT 7 /* QNO 521 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0', '$.strengthen****.manufacturer' ) = 0 LIMIT 4 /* QNO 418 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 0 LIMIT 4 /* QNO 419 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$', '$', '$."measure"', '$' ) = 1 LIMIT 1 /* QNO 652 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 2 LIMIT 8 /* QNO 336 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"oqlnmrmwfbifbiudrhgxcphzdpxpnx"' ) = 1 LIMIT 6 /* QNO 655 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$****."birth".region' ) = 0 LIMIT 2 /* QNO 656 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 4 /* QNO 339 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', '"cqqaisdjeukpvdjlcjmbomehbmug"' ) ) = 7 LIMIT 5 /* QNO 526 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 5 /* QNO 424 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 4 LIMIT 0 /* QNO 340 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[4]' ) = 1 LIMIT 0 /* QNO 341 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[0][8][4]' ) = 0 LIMIT 6 /* QNO 660 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$.*.*[5]' ) = 0 LIMIT 9 /* QNO 528 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[5]' ) ) = 5 LIMIT 2 /* QNO 343 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$**' )) = 5 LIMIT 0 /* QNO 344 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$[4]**.send**' ) = 1 LIMIT 5 /* QNO 663 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$', '$', '$**' ) = 0 LIMIT 1 /* QNO 531 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.*[7]', 'false', '$[1]', '"gqtufpvynmgtolym"' ) ) = 0 LIMIT 7 /* QNO 429 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$' ) = 3 LIMIT 0 /* QNO 345 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 9 ) != NULL LIMIT 4 /* QNO 430 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 6 LIMIT 0 /* QNO 533 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 1 LIMIT 1 /* QNO 665 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 1 LIMIT 3 /* QNO 431 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$.immigration**[2]' ) = 'chicken' LIMIT 3 /* QNO 432 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$**.personal', '[NULL,"ljtlhyvd",0,0,false,true,"j","tlh","lh",NULL,true,0,NULL,0,true]', '$[7]', '"hyvdmdlzxeevxtzfptjsvrbunsakivbucwdvxbxyirfxlyd"', '$.***."parade"', 'true', '$', 'false', '$[8]', '0', '$', '0' ) ) = 5 LIMIT 1 /* QNO 667 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.*[3].merit**' ) ) = 9 LIMIT 4 /* QNO 537 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$[3]**', '$**."favor"[*]."franchise"', '$**[4].television[3]', '$****' ) = 0 LIMIT 2 /* QNO 670 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$' ) = 1 LIMIT 1 /* QNO 538 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$."living"[0]', '$**[5][3]', '$[3]."working"[1]', '$' ) ) = 1 LIMIT 3 /* QNO 436 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$****[1]' )) = 7 LIMIT 4 /* QNO 437 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[*]**', '"ptjsvr"', '$****', '0' ), '$**[8]**[7]', '$**', '$.boundary**[0]' ) = 8 LIMIT 1 /* QNO 671 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[8][6]' ) = 'park' LIMIT 2 /* QNO 353 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.*[0].supreme**', 'NULL', '$**.*.*', '"yufapzhzzhxwuduwdv"', '$**.orange[4].ecological', '"ufapzhzzhxwuduwdvapuqjqctvptnud"' ) ) = 0 LIMIT 5 /* QNO 542 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 3 /* QNO 673 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 5 LIMIT 1 /* QNO 674 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.security', '$.manner.option**' ) ) = 9 LIMIT 0 /* QNO 676 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 0 /* QNO 443 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 0 /* QNO 547 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 2 /* QNO 361 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[5]' ) = 1 LIMIT 4 /* QNO 678 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.afraid', '$.beg', '$', '$**' )) = 1 LIMIT 5 /* QNO 444 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', '"ivbucw"' ) ) = 0 LIMIT 2 /* QNO 679 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$**[*]', 'true', '$**', '0' ) ) = 7 LIMIT 7 /* QNO 446 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '$[3]' ) = 1 LIMIT 0 /* QNO 550 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 8 /* QNO 364 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$[7].orbit**' ) = 0 LIMIT 7 /* QNO 685 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 1 LIMIT 4 /* QNO 552 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'true' ) = 0 LIMIT 3 /* QNO 452 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[*].champion', '0', '$[7][4]**', 'false' ) ) = 7 LIMIT 5 /* QNO 687 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.iraqi**."forgive"', '$.grief', '$."boast"**.*.*' )) = 4 LIMIT 8 /* QNO 557 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', NULL, '\\', '$[1]."cruel"', '%' ) != NULL LIMIT 5 /* QNO 370 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 1 LIMIT 0 /* QNO 456 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$[4]', '$**."tackle"' ) = 9 LIMIT 3 /* QNO 371 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[4][1][*]**' )) = 6 LIMIT 6 /* QNO 561 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 6 LIMIT 0 /* QNO 374 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 8 LIMIT 7 /* QNO 377 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 5 LIMIT 2 /* QNO 462 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 4 LIMIT 2 /* QNO 566 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$."day"**' ) = 0 LIMIT 1 /* QNO 702 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$' ) ) = 4 LIMIT 1 /* QNO 466 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$.working', 'false' ) ) = 5 LIMIT 8 /* QNO 569 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 0 /* QNO 382 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 2 /* QNO 467 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 7 LIMIT 7 /* QNO 570 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'NULL', '$**."shine"' ) = 0 LIMIT 1 /* QNO 384 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[5]**' )) = 9 LIMIT 5 /* QNO 385 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 0 LIMIT 1 /* QNO 471 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[8]', 'true', '$[*]**[5][5]', '[NULL,true,0,"jefdvgeikgujfi",0]' ) ) = 7 LIMIT 4 /* QNO 573 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$[0]**.sixth', '$.intellectual.*[0]."next"' ) = 0 LIMIT 7 /* QNO 707 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', `col_jsonvalue` ) != NULL LIMIT 8 /* QNO 574 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 6 LIMIT 9 /* QNO 388 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[2]**', '"xs"' ) ) = 7 LIMIT 7 /* QNO 389 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 0 LIMIT 4 /* QNO 475 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 6 LIMIT 0 /* QNO 476 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', `col_jsonvalue` ) != NULL LIMIT 8 /* QNO 392 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[6][7]', '$.*[6].*' ) ) = 1 LIMIT 2 /* QNO 715 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[*]."adapt".*' ) = 1 LIMIT 9 /* QNO 582 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 6 LIMIT 1 /* QNO 719 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$' ) ) = 2 LIMIT 9 /* QNO 720 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[0]', '["wkiqwkdwafjs","kiqwkdwafjsgacxkylimvrgwx",0,"iqwkdw",false]' ) )= 8 LIMIT 6 /* QNO 395 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 4 LIMIT 8 /* QNO 484 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'population', 'NULL' ) LIMIT 5 /* QNO 486 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**[6].testify' ) = 1 LIMIT 6 /* QNO 588 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$' ) ) = 5 LIMIT 9 /* QNO 400 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$**' ) = 6 LIMIT 7 /* QNO 592 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$.lung' ) = 0 LIMIT 3 /* QNO 489 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'false' ) = 0 LIMIT 6 /* QNO 401 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'NULL' ) = 0 LIMIT 7 /* QNO 490 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$**', '$."river"**.behavioral[6]' ) = 5 LIMIT 7 /* QNO 593 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 7 LIMIT 9 /* QNO 727 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$."front".entity' ) ) = 0 LIMIT 4 /* QNO 594 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$."suspect"' )) = 4 LIMIT 1 /* QNO 728 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$.telescope.chase' ) = 0 LIMIT 8 /* QNO 595 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'terror' LIMIT 6 /* QNO 596 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**', 'NULL' ) )= 3 LIMIT 3 /* QNO 494 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0', '$' ) = 0 LIMIT 2 /* QNO 598 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$' ) = 1 LIMIT 6 /* QNO 407 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 8 /* QNO 599 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$****' ) ) = 7 LIMIT 2 /* QNO 496 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 4 /* QNO 601 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 4 /* QNO 409 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 9 LIMIT 1 /* QNO 733 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[3][0]', '"c"' ) ) = 2 LIMIT 7 /* QNO 604 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$.*."acceptance"."bank".private', '$.keep[*]**[7]' ) = 1 LIMIT 2 /* QNO 500 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$' ) ) = 2 LIMIT 9 /* QNO 739 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 7 LIMIT 7 /* QNO 502 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$.unable[0]**' ) = 0 LIMIT 3 /* QNO 608 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 0 LIMIT 7 /* QNO 503 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$[7].surgery' ) ) = 4 LIMIT 7 /* QNO 743 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 1 LIMIT 0 /* QNO 744 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', NULL ) != NULL LIMIT 8 /* QNO 418 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[7]', '0' ) ) = 0 LIMIT 8 /* QNO 508 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[0]**' ) ) = 6 LIMIT 1 /* QNO 614 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$**' ) ) = 4 LIMIT 1 /* QNO 509 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[8].ring**' ) = 'newly' LIMIT 9 /* QNO 615 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**.*.uncertainty**' ) ) = 9 LIMIT 0 /* QNO 747 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 5 /* QNO 510 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 5 LIMIT 4 /* QNO 423 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', NULL ) != NULL LIMIT 8 /* QNO 511 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', 'NULL', '$.scholar******', '"aklyw"', '$[1]', 'true' ) ) = 7 LIMIT 5 /* QNO 424 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 1 /* QNO 751 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 5 /* QNO 620 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'f' ) != NULL LIMIT 7 /* QNO 754 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 4 /* QNO 515 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 1 LIMIT 2 /* QNO 624 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'retain', NULL, '$**[7]' ) != NULL LIMIT 8 /* QNO 428 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[8]**."chicken"' ) ) = 6 LIMIT 9 /* QNO 625 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 5 LIMIT 1 /* QNO 626 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**[8]**.powder', '0' ) )= 1 LIMIT 0 /* QNO 429 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**."lay"[5].fare' ) = 1 LIMIT 7 /* QNO 759 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$' ) = 3 LIMIT 8 /* QNO 519 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '$[0].retailer[1]' ) = 0 LIMIT 1 /* QNO 431 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$**[2]**[4]', '$**' ) = 0 LIMIT 3 /* QNO 520 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 1 LIMIT 9 /* QNO 433 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.connection****' )) = 0 LIMIT 9 /* QNO 631 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 3 /* QNO 435 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$[6][2]' ) = 0 LIMIT 0 /* QNO 525 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$.retain[2]**' ) = 1 LIMIT 4 /* QNO 438 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 6 LIMIT 8 /* QNO 526 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', '0' ) ) = 7 LIMIT 1 /* QNO 440 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 8 LIMIT 0 /* QNO 635 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$**.accompany', '0' ) ) = 8 LIMIT 8 /* QNO 767 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 1 LIMIT 5 /* QNO 527 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$' ) ) = 2 LIMIT 9 /* QNO 769 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 0 LIMIT 3 /* QNO 529 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$', '0', '$[4].department[4]."flying"', '"zqnugkpkcnvkqtg"' ) )= 7 LIMIT 6 /* QNO 638 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 0 LIMIT 6 /* QNO 639 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.suggest[2]', '"sjrimtpvmhbbexrfefhyiwofwmlqheucbfnuksiedzuvkqksftznrty"', '$[*]', '"jrimtpvmhbbexr"' ), '$.graduation[1]', '$.*', '$**."suddenly"**[8]', '$[3]**[4]', '$' ) = 3 LIMIT 6 /* QNO 444 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$**' ) = 7 LIMIT 5 /* QNO 532 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$.voting."disturbing"', '$[5]****' ) = 0 LIMIT 9 /* QNO 533 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', 'true', '$.kit**', 'NULL', '$[5]', '{"soup": 0}', '$[0]', 'NULL', '$**', '"rimtpvmhbbexrfefhyiwo"' ) ) = 4 LIMIT 3 /* QNO 445 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$**."widow"**' ) = 2 LIMIT 7 /* QNO 774 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 0 /* QNO 535 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', '"cferuphvkxyfhntxqmdcyjkhqpfphdimfcaktyv"', '$', 'true', '$', 'false', '$****.*[4]', '"feruphvkxyfhntxqmd"' ) ) = 2 LIMIT 4 /* QNO 776 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'any', 'true', 'honestly', 'false', 'plenty', '"ocddwgcilxzrphreq"' ) LIMIT 7 /* QNO 645 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$**.racism[1]', 'true', '$[2].*', '0' ) ) = 0 LIMIT 7 /* QNO 778 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$****."excuse"' ) = 1 LIMIT 6 /* QNO 646 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[4]**.confrontation', '0', '$**[2]."collector"[4]', 'false' ) ) = 4 LIMIT 3 /* QNO 538 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$[7][1]**', '$**', '$**.crawl****', '$', '$.*.lip**."coalition"', '$[2][5][4]', '$[4]**', '$' ) = 1 LIMIT 3 /* QNO 453 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$' ) ) = 1 LIMIT 3 /* QNO 779 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"q"', '$' ) = 1 LIMIT 6 /* QNO 648 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$."bread"', '$[7]' )) = 4 LIMIT 7 /* QNO 784 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'fly' LIMIT 4 /* QNO 785 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 9 LIMIT 1 /* QNO 460 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 0 LIMIT 1 /* QNO 653 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 4 /* QNO 654 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[*][8]', '[0,0,true,false,false,false,NULL,false,{"blow": "ntxqmdcyjkhqpfphdi","auction": true,"present": NULL,"rehabilitation": 0,"against": 0,"destroy": true,"glory": false,"least": "txqmdcyjkhqpfphdimfcaktyvccyagjlepcabpaswcmrxldtvcz"},false]' ) )= 6 LIMIT 1 /* QNO 787 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[0].*."self-esteem"**', 'false' ) )= 3 LIMIT 9 /* QNO 789 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 9 LIMIT 9 /* QNO 466 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[1]**' ) ) = 8 LIMIT 3 /* QNO 660 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$.liberty' ) = 0 LIMIT 2 /* QNO 792 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 7 LIMIT 9 /* QNO 662 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**' ) = 0 LIMIT 7 /* QNO 555 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 3 LIMIT 8 /* QNO 796 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[2].hormone', '0' ), '$[0]', '$[4]**[*].*' ) = 6 LIMIT 0 /* QNO 664 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$' ) = 1 LIMIT 0 /* QNO 665 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$[0]**', '$.sharply**.commissioner[2]', '$**[8]."short-term"', '$.blade[8]' ) = 1 LIMIT 5 /* QNO 797 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$.choose[7]', '$' ) = 6 LIMIT 7 /* QNO 666 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 6 LIMIT 3 /* QNO 475 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$**[8][7]' ) ) = 1 LIMIT 1 /* QNO 559 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', '0', '$.beneath**[7]**', '"odmmsrskxwwisamllwad"', '$[8][4][4]', '0', '$[5]', '"dmmsr"', '$**', 'true', '$[6].due**."beside"', '"mmsrskx"' ) ) = 7 LIMIT 6 /* QNO 560 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[2][3].***', '0' ) ) = 1 LIMIT 0 /* QNO 478 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', '', "'", '$."blow"**', '"', '$[3]**."magnitude"' ) != NULL LIMIT 8 /* QNO 799 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$' ) ) = 4 LIMIT 7 /* QNO 800 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 8 LIMIT 5 /* QNO 669 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$.supportive**.agenda', '"zgeyvtiajrvfuyvjpwcmmupova"', '$[2]', 'true' ) ) = 4 LIMIT 7 /* QNO 562 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$[3].match' ) = 1 LIMIT 9 /* QNO 801 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[2][2].catch**' ) = 1 LIMIT 7 /* QNO 482 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$.wrap.*.flying', '$.*.infant.facility.edition', '$', '$[4][8]**[0]', '$', '$' ) = 1 LIMIT 6 /* QNO 564 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 0 LIMIT 3 /* QNO 483 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$**[4][4]', '0', '$**[2]**', '0' ) ) = 4 LIMIT 1 /* QNO 802 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 0 LIMIT 5 /* QNO 484 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[4][2].*' ) ) = 1 LIMIT 1 /* QNO 674 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 8 LIMIT 3 /* QNO 805 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 2 /* QNO 675 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$', 'NULL', '$."net".meeting."cocaine"."input"', '0' ) )= 1 LIMIT 9 /* QNO 566 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$**.*', 'true' ) ) = 1 LIMIT 4 /* QNO 677 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$[1].*[2]', '$[*]', '$[0].owe**[0]', '$[5][7]' ) = 2 LIMIT 4 /* QNO 488 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 8 LIMIT 2 /* QNO 809 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 5 LIMIT 1 /* QNO 810 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.appropriate[1].required', 'NULL', '$."cancer".*[7]**', 'NULL', '$', 'false' ) ) = 9 LIMIT 5 /* QNO 490 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0' ) = 0 LIMIT 7 /* QNO 681 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**' ) ) = 8 LIMIT 5 /* QNO 492 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$.junior', '0', '$.layer**[4]', 'true' ) ) = 8 LIMIT 8 /* QNO 573 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$**.plead' )) = 0 LIMIT 0 /* QNO 494 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 1 /* QNO 574 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.million**[1].each' )) = 4 LIMIT 6 /* QNO 814 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 6 /* QNO 815 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$****.*[4]' )) = 6 LIMIT 0 /* QNO 687 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[6][6][0]' ) ) = 6 LIMIT 1 /* QNO 577 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$.*[8]' ) = 1 LIMIT 5 /* QNO 688 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 0 LIMIT 0 /* QNO 578 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '"hkolqmqkcxkv"' ) = 0 LIMIT 7 /* QNO 498 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'diagnose' ) != NULL LIMIT 1 /* QNO 580 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'blink' ) != NULL LIMIT 8 /* QNO 500 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$', '$**[5].water.crystal' ) ) = 8 LIMIT 7 /* QNO 582 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'response' ) = 0 LIMIT 0 /* QNO 501 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$****[*].*', '$.where' )) = 6 LIMIT 7 /* QNO 502 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.motivate.*', '"daepompnl"', '$**.*', '"aepompnlrpvtvevamrllabswtqwnltvq"' ) )= 8 LIMIT 7 /* QNO 583 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 1 LIMIT 7 /* QNO 503 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 2 /* QNO 698 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'ol', '%', '$.***', 's' ) != NULL LIMIT 9 /* QNO 828 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$**', '$[*].banker.afraid**' ) = 0 LIMIT 7 /* QNO 700 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[*]****.snake' ) ) = 6 LIMIT 1 /* QNO 701 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[5][1]**' ) ) = 5 LIMIT 0 /* QNO 703 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 0 LIMIT 1 /* QNO 511 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 9 /* QNO 706 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$****' ) = 1 LIMIT 7 /* QNO 512 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 9 LIMIT 1 /* QNO 594 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[8][1].*[3]', '"tusptfrniyalqjasmpkxbyha"' ) )= 9 LIMIT 6 /* QNO 514 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$', '$' ) = 0 LIMIT 0 /* QNO 595 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$' ) ) = 1 LIMIT 3 /* QNO 835 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$.associated**' ) = 7 LIMIT 1 /* QNO 712 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$.***' ) ) = 1 LIMIT 6 /* QNO 839 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '0' ) = 1 LIMIT 9 /* QNO 715 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'collection' LIMIT 9 /* QNO 521 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$******' ) = 'red' LIMIT 1 /* QNO 603 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'documentary' ) = 0 LIMIT 1 /* QNO 842 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$******' ) ) = 9 LIMIT 6 /* QNO 844 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'seize', 'NULL' ) LIMIT 9 /* QNO 524 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', 'true', '$.***', '"gkpfxpcejfuvbvbbeoksbcwnpnaoiy"', '$', '"kpfxpcejfuvbvbbeoksbcwnpnaoiykyjjlkccmyzmraoflmovlgajbiojp"', '$**', '0', '$[6][6]**', 'true', '$.a[0].*', 'false' ) ) = 6 LIMIT 0 /* QNO 719 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 6 LIMIT 0 /* QNO 526 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$."step"[6]**[8]' ) = 'beef' LIMIT 5 /* QNO 847 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[7]**', '"pfxpcejfuvbvbbeoksbcwnpnaoiykyjjlkccmyzmraoflmovlgajbiojpfq"' ) )= 5 LIMIT 8 /* QNO 722 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'p', 'q' ) != NULL LIMIT 4 /* QNO 851 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$.*[8][2]' ) = 'resemble' LIMIT 5 /* QNO 532 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 4 LIMIT 8 /* QNO 612 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'tumor', 'NULL', 'onto', '"fvssqtypcunxmvsyqkrrkselhebamvztvljbntdwm"', 'control', 'NULL' ) LIMIT 6 /* QNO 852 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '[]' ) = 0 LIMIT 0 /* QNO 615 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'german', '0' ) LIMIT 8 /* QNO 855 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$.attract' ) = 0 LIMIT 2 /* QNO 728 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$****', 'false' ) ) = 4 LIMIT 9 /* QNO 856 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'turkey', 'true', 'foundation', '0' ) LIMIT 6 /* QNO 617 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**[8]**."motivate"', '0' ) )= 9 LIMIT 6 /* QNO 729 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[5][5]****', '0', '$[1]****', '"ziybagabiigqyvwcxbhbqxysddtdmurvediea"', '$[*]', 'NULL', '$[7]**.***', '"iybagabiigqyvwcxbhbqx"' ) ) = 8 LIMIT 0 /* QNO 618 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$**' ) = 6 LIMIT 8 /* QNO 730 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 9 LIMIT 9 /* QNO 859 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0' ) = 1 LIMIT 5 /* QNO 543 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$."rapid".*', '$**[8]**[0]', '$**' ) = 2 LIMIT 8 /* QNO 621 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$.*[4]' ) = 'smell' LIMIT 8 /* QNO 861 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$****.despite."security"', '0', '$******[2]', 'false', '$**', '0' ) ) = 8 LIMIT 0 /* QNO 733 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[3].*', '0' ) ) = 3 LIMIT 0 /* QNO 865 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 4 /* QNO 866 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 8 /* QNO 627 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0' ) = 0 LIMIT 7 /* QNO 739 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[7]' ) = 1 LIMIT 5 /* QNO 867 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**.nurse', 'false', '$**.dessert[*]', '0' ) )= 2 LIMIT 9 /* QNO 742 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 8 /* QNO 632 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 0 /* QNO 744 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'mad', 'true' ) LIMIT 9 /* QNO 873 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**' ) = 0 LIMIT 2 /* QNO 635 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**[7].bright' ) ) = 3 LIMIT 9 /* QNO 746 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$.encourage.*[7]**' ) = 'process' LIMIT 4 /* QNO 557 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"lv"' ) = 1 LIMIT 1 /* QNO 636 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[*].ribbon[2]' ) = 'dense' LIMIT 9 /* QNO 558 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0' ) = 1 LIMIT 1 /* QNO 562 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[1][1]' ) ) = 7 LIMIT 7 /* QNO 750 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$', '$.*.punch****', '$[8]', '$[*]', '$**[6][1].added', '$[1]', '$', '$**', '$.operating[7]****', '$****[1]."psychology"' ) ) = 4 LIMIT 9 /* QNO 879 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$.noon', 'NULL', '$**.hill.cuban**', 'NULL', '$**', '"e"' ) ) = 4 LIMIT 6 /* QNO 642 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 5 LIMIT 8 /* QNO 752 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$**.usually', '$' )) = 7 LIMIT 0 /* QNO 884 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$**.scared', '"hwsnhuxmycsgzoklxbpov"', '$', '"wsnhuxmycsgzoklxbpo"', '$[0][*].eventually[0]', '"snhuxmycsgzoklxbpovcqjeirdrgvntcqzwfijrkwunocepihai"' ) ) = 4 LIMIT 4 /* QNO 646 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$[6][5]**' ) = 9 LIMIT 5 /* QNO 756 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.*', '"emhosvmqzsbksjodfxpcrevkninz"' ) ) = 2 LIMIT 2 /* QNO 885 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$.*.nut[5]**' ) = 'flexibility' LIMIT 4 /* QNO 647 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**[1][8]**' ) ) = 7 LIMIT 6 /* QNO 886 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$' ) ) = 4 LIMIT 8 /* QNO 758 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 5 /* QNO 570 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', '0' ) ) = 5 LIMIT 6 /* QNO 760 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**', 'NULL' ) )= 3 LIMIT 5 /* QNO 761 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'false' ) = 1 LIMIT 3 /* QNO 574 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 9, NULL, '$[*]', "'", '$[7]**' ) != NULL LIMIT 6 /* QNO 762 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 7 LIMIT 1 /* QNO 653 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[2]."written"[5].safety', '$', '$' ) ) = 7 LIMIT 8 /* QNO 763 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 6 LIMIT 7 /* QNO 764 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 6 /* QNO 655 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0', '$.importantly[0]' ) = 0 LIMIT 7 /* QNO 765 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$**.president****' ) = 0 LIMIT 0 /* QNO 657 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.needle.throw' )) = 3 LIMIT 4 /* QNO 767 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$**.remember**' ) = 9 LIMIT 5 /* QNO 579 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$.boost' ) ) = 8 LIMIT 6 /* QNO 659 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 3 /* QNO 898 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[7]' ) = 'quickly' LIMIT 1 /* QNO 660 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$.trainer**' ) ) = 8 LIMIT 5 /* QNO 661 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 0 /* QNO 662 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[*]' ) ) = 7 LIMIT 5 /* QNO 771 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0', '$****.*.*' ) = 0 LIMIT 3 /* QNO 664 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$**[1]**', '$********' ) = 1 LIMIT 7 /* QNO 772 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 1 /* QNO 902 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 5 /* QNO 665 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$.*[5][5][6]' ) = 'temperature' LIMIT 1 /* QNO 773 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$**', '0', '$**[5]', 'true', '$.purple.remain."plenty"', '"kfivlaqyjhfajdgwztbg"' ), '$."recovery"', '$."lost"."besides".*', '$[1]****', '$.escape' ) = 3 LIMIT 7 /* QNO 668 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 4 LIMIT 2 /* QNO 589 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 3 LIMIT 2 /* QNO 777 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$****', 'NULL', '$.civilization[7]', 'NULL', '$****[2]', '"iufhrqtucaxyuh"', '$', 'false', '$', '"ufhrqtucaxyuhjmikjcjkehek"', '$[6]**[2]', 'NULL', '$[4]**.concerned', '0', '$[8]', '0', '$.tongue**', '{}' ) )= 8 LIMIT 4 /* QNO 590 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$[1]', '$**' ) = 8 LIMIT 7 /* QNO 592 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[0][3].device' ) ) = 7 LIMIT 2 /* QNO 593 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', '' ) != NULL LIMIT 6 /* QNO 672 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '"veokljcfxhqkhtanrbsphuabikydspdoqi"' ) = 0 LIMIT 0 /* QNO 781 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[1][*].teaspoon.*' ) = 1 LIMIT 0 /* QNO 673 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$', '$**[*]**', '$**', '$[7][5].freeze[0]', '$****[4]' ) = 1 LIMIT 4 /* QNO 674 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[7]', '$[8][4]**' )) = 3 LIMIT 9 /* QNO 911 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$' ) = 1 LIMIT 5 /* QNO 597 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 7 /* QNO 913 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.*', '$**.stiff.*' ) ) = 0 LIMIT 7 /* QNO 915 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 6 /* QNO 681 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$****', 'NULL' ) ) = 8 LIMIT 8 /* QNO 682 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 6 LIMIT 6 /* QNO 787 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 2 LIMIT 6 /* QNO 602 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0', '$[4]**' ) = 1 LIMIT 6 /* QNO 917 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$' ) ) = 7 LIMIT 7 /* QNO 684 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 0 /* QNO 790 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', NULL, 'g', '$.freeze[0][1]', 't' ) != NULL LIMIT 4 /* QNO 918 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$**', '$.***[2]', '$.***' ) = 4 LIMIT 0 /* QNO 685 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$******.*' ) = 0 LIMIT 6 /* QNO 791 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**[4]**', '0', '$**."amid"', '0' ) )= 8 LIMIT 4 /* QNO 919 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'productive' ) != NULL LIMIT 1 /* QNO 606 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 8 LIMIT 3 /* QNO 687 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'NULL' ) = 0 LIMIT 5 /* QNO 607 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'prosecution', '["xvcutj"]', 'sail', '"v"', 'appreciation', '"cutj"', 'channel', '"utjigikratovemhqblyzalkifu"' ) LIMIT 0 /* QNO 792 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 8 /* QNO 689 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 5 /* QNO 922 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$****' )) = 5 LIMIT 2 /* QNO 690 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', '0' ), '$', '$**[6]' ) = 2 LIMIT 9 /* QNO 923 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 0 /* QNO 796 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 4 /* QNO 801 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[6]."slam"."lay"' ) = 1 LIMIT 8 /* QNO 613 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[7][2]' ) = 'overwhelming' LIMIT 1 /* QNO 698 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 1 /* QNO 930 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 2 LIMIT 9 /* QNO 699 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$."job".organic.cholesterol' ) ) = 4 LIMIT 6 /* QNO 803 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 7 /* QNO 804 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$.*."speech".others', '$', '$[8]', '$****' ) = 1 LIMIT 5 /* QNO 805 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '[]' ) = 0 LIMIT 6 /* QNO 701 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'false' ) = 1 LIMIT 2 /* QNO 702 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[3]**' ) ) = 7 LIMIT 5 /* QNO 807 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 2 LIMIT 2 /* QNO 623 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 7 /* QNO 808 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$[4]."palm"[*]' ) ) = 5 LIMIT 1 /* QNO 809 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$**.immigration.***' ) = 'dealer' LIMIT 3 /* QNO 937 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 1 /* QNO 938 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$[3].*' ) ) = 7 LIMIT 1 /* QNO 811 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$**[3]' ) = 1 LIMIT 2 /* QNO 628 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 2 /* QNO 812 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 2 /* QNO 710 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 8 LIMIT 2 /* QNO 944 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 8 LIMIT 9 /* QNO 632 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 8 LIMIT 9 /* QNO 945 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$****' ) = 1 LIMIT 7 /* QNO 633 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$."oven"', '$.outcome[4].*' )) = 9 LIMIT 1 /* QNO 946 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$.rise[1][6]' ) ) = 9 LIMIT 9 /* QNO 948 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 9 /* QNO 818 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 9 LIMIT 1 /* QNO 638 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$' ) ) = 2 LIMIT 9 /* QNO 953 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$."chin"."encounter"**[5]' ) ) = 6 LIMIT 4 /* QNO 954 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.nevertheless.dessert**', '"yhvjgkzs"', '$**[4].credit', '0' ) ) = 6 LIMIT 1 /* QNO 823 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 7 LIMIT 1 /* QNO 824 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 8 LIMIT 7 /* QNO 724 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 0 LIMIT 5 /* QNO 826 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$********', 'false', '$******', '"ivdkyhkqmz"', '$."investigation"."enjoy"[1].selected', 'true', '$**.*', '0' ), '$**[4][5]', '$.*.*', '$[*]' ) = 3 LIMIT 3 /* QNO 727 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$******[8]', '"vdkyhkqmzkfeutxfynklnjvflblqurdjpxsmd"' ), '$.variety', '$', '$' ) = 4 LIMIT 5 /* QNO 728 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**.necessity.ah**' ) = 1 LIMIT 3 /* QNO 649 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.normally', 'false', '$[0][6]**[7]', '"g"' ) ) = 6 LIMIT 2 /* QNO 831 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[0]' ) ) = 4 LIMIT 0 /* QNO 650 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 9 LIMIT 5 /* QNO 730 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$', '$**[8][6]**', '$**[*]', '$', '$', '$**.host' )) = 2 LIMIT 7 /* QNO 651 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 5 LIMIT 6 /* QNO 833 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$**', '$[*]****."ranch"' ) ) = 0 LIMIT 6 /* QNO 654 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 1 LIMIT 0 /* QNO 835 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'NULL', '$**' ) = 1 LIMIT 4 /* QNO 738 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 0 LIMIT 0 /* QNO 973 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 0 /* QNO 656 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 0 LIMIT 0 /* QNO 658 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 2 /* QNO 837 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$**.*' ) = 'sleeve' LIMIT 9 /* QNO 659 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 2 LIMIT 1 /* QNO 977 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$**[0].***', '0' ) ) = 0 LIMIT 6 /* QNO 662 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'yt', '%', '$**' ) != NULL LIMIT 8 /* QNO 978 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'false', '$**' ) = 0 LIMIT 1 /* QNO 663 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 0 LIMIT 4 /* QNO 664 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'i', "'" ) != NULL LIMIT 4 /* QNO 747 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[7][7]****' )) = 6 LIMIT 5 /* QNO 984 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[1]**' ) = 'suit' LIMIT 7 /* QNO 669 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[5]**.makeup' ) = 'discourage' LIMIT 7 /* QNO 749 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'degree' LIMIT 7 /* QNO 986 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'NULL' ) = 1 LIMIT 1 /* QNO 751 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '[]' ) = 1 LIMIT 1 /* QNO 848 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[1].*.perfect', '"djcsxlomukqj"' ) ) = 2 LIMIT 3 /* QNO 673 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$."partner"[7]**' ) = 'desperately' LIMIT 0 /* QNO 851 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 4 LIMIT 5 /* QNO 989 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 3 /* QNO 675 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 8 /* QNO 853 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 5 /* QNO 991 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[3][3]', '$[*][3]' ) ) = 9 LIMIT 2 /* QNO 676 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 5 LIMIT 3 /* QNO 854 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 1 /* QNO 678 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 2 LIMIT 7 /* QNO 994 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[4][4][0]', '$.survive.layer.pretty.example', '$**', '$[1].***' )) = 5 LIMIT 5 /* QNO 857 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 6 LIMIT 1 /* QNO 681 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 7 LIMIT 2 /* QNO 858 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 1 LIMIT 2 /* QNO 859 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$**', '"ckqtpzlopcuxbevcbj"' ) ) = 5 LIMIT 9 /* QNO 861 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$' ) ) = 9 LIMIT 5 /* QNO 765 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 0 LIMIT 6 /* QNO 999 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 2 /* QNO 863 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 4 /* QNO 864 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$[4]**' ) = 1 LIMIT 6 /* QNO 685 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.leather**', '$**[3].jump**' ) ) = 7 LIMIT 3 /* QNO 1000 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 2, '"', '$.*."pale".pillow' ) != NULL LIMIT 0 /* QNO 1001 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**.communicate.***' ) ) = 0 LIMIT 3 /* QNO 1004 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$', '$[8]**.*[2]', '$****', '$', '$**."alarm"', '$****[3]', '$**' )) = 8 LIMIT 6 /* QNO 769 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 4 LIMIT 4 /* QNO 870 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**.equal.*', '"koap"', '$', 'NULL', '$**[5][7][3]', '"o"' ) )= 5 LIMIT 5 /* QNO 770 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$[2]', '$' ) = 0 LIMIT 2 /* QNO 1006 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$' ) = 1 LIMIT 9 /* QNO 871 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 3 LIMIT 3 /* QNO 694 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 1 LIMIT 4 /* QNO 772 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 2 /* QNO 1010 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$', '$[6][*]' )) = 8 LIMIT 7 /* QNO 697 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$[5]."recession"' ) = 1 LIMIT 4 /* QNO 1012 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[6][2]**' ) ) = 3 LIMIT 1 /* QNO 775 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', `col_jsonvalue`, '"', '$.south**."education"', NULL ) != NULL LIMIT 4 /* QNO 776 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 8 LIMIT 8 /* QNO 876 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 6 /* QNO 777 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[5]****', '$**' ) ) = 5 LIMIT 0 /* QNO 1015 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'military' ) = 0 LIMIT 8 /* QNO 877 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 0 /* QNO 701 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'cultural', '"lupknxztniicdqilwjujvblqvcc"' ) LIMIT 7 /* QNO 1017 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.speculate', '$[2]', '$.early' )) = 8 LIMIT 0 /* QNO 779 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 7 LIMIT 2 /* QNO 702 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 0 LIMIT 1 /* QNO 879 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$' ) ) = 9 LIMIT 7 /* QNO 780 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$**[1][1]', '"upknxztn"' ) ) = 8 LIMIT 0 /* QNO 1019 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'isolated', '0', 'plea', '"fkddnvhzqnkbnrpsxjc"', 'marketing', '0' ) LIMIT 4 /* QNO 880 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[6][7].evident[1]', '$****' )) = 6 LIMIT 1 /* QNO 1020 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 4 LIMIT 4 /* QNO 705 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**[1]', '0' ) )= 3 LIMIT 8 /* QNO 783 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 6 LIMIT 9 /* QNO 708 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'disagree' LIMIT 4 /* QNO 887 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.brother**', 'NULL', '$.ago****.companion', 'true', '$', '0', '$.sector', 'true' ) )= 3 LIMIT 1 /* QNO 1027 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$**."comprise".gift' ) ) = 8 LIMIT 9 /* QNO 1028 CON_ID 14 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**[*]**' ) = 1 LIMIT 2 /* QNO 787 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 8 LIMIT 0 /* QNO 889 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 6 LIMIT 7 /* QNO 788 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', NULL, '%', '$.abortion.midst**', 'e', '$', '/', '$[3].donation.section.initiative', '/', '$[*]', 's', '$[7]."enormous"**[3]' ) != NULL LIMIT 7 /* QNO 790 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 9 LIMIT 6 /* QNO 713 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 0 LIMIT 4 /* QNO 714 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.individual', '$[5][8].could**', '$[*].***[6]' )) = 1 LIMIT 8 /* QNO 893 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 7 LIMIT 7 /* QNO 793 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 6 /* QNO 716 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$******.disease', '$[1]' ) = 3 LIMIT 0 /* QNO 794 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'distinguish', 'true' ) LIMIT 9 /* QNO 795 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$[3]' ) = 1 LIMIT 1 /* QNO 799 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'considerably', '%', '$' ) != NULL LIMIT 2 /* QNO 901 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$', '$[4]."learning"', '$[5]**[2]' )) = 8 LIMIT 9 /* QNO 802 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$**', '0', '$.ship', 'NULL' ) ) = 4 LIMIT 9 /* QNO 902 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$."write".ski**' ) = 4 LIMIT 8 /* QNO 723 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 8 /* QNO 725 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 8 LIMIT 4 /* QNO 726 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[2]' ) = 'money' LIMIT 5 /* QNO 905 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$' ) ) = 6 LIMIT 6 /* QNO 906 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[7][0].*' )) = 7 LIMIT 9 /* QNO 727 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 5 LIMIT 2 /* QNO 728 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[8][*][3]**' ) ) = 6 LIMIT 3 /* QNO 808 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '[]' ) = 1 LIMIT 5 /* QNO 729 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 3 /* QNO 732 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0' ) = 1 LIMIT 7 /* QNO 911 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$.accessible******', '$.remark**.myself' ) = 0 LIMIT 4 /* QNO 812 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 1 LIMIT 5 /* QNO 734 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[8].***' ) ) = 8 LIMIT 0 /* QNO 813 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'true', '$**[4].identity[5]' ) = 0 LIMIT 4 /* QNO 735 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', '"pgqxwtnxvflbpzzcljakfczceolqlmw"', '$', 'NULL', '$****.participant[7]', 'true', '$', '0', '$**[5]**.*', 'true', '$."candidate"**[*].*', '{"division": "gqx","wonder": 0,"huh": "qxwtnxvflbpzzcljakfczc","magnitude": 0}' ) ) = 8 LIMIT 1 /* QNO 736 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**.fifty.*' ) = 0 LIMIT 8 /* QNO 916 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**.curious****' ) = 0 LIMIT 0 /* QNO 818 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.copy[2]**', '0', '$."wise"[7]."extend"."degree"', '"bchzhwuhybjlwagfwwqb"', '$', '0', '$**[5].harm.sixth', '0', '$."southwest"', '0' ) )= 4 LIMIT 5 /* QNO 918 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$."temporary"**.valuable' )) = 1 LIMIT 2 /* QNO 739 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$."let"**."sheep"' ) ) = 5 LIMIT 2 /* QNO 819 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0', '$' ) = 0 LIMIT 2 /* QNO 820 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"pvtopdgiyknixyrur"' ) = 1 LIMIT 2 /* QNO 921 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[*]' ) = 'excessive' LIMIT 7 /* QNO 922 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.*', '$.filter[4][0]' ) ) = 3 LIMIT 9 /* QNO 823 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 5 /* QNO 824 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'trailer', '"mrtozzld"', 'balance', '[0,"rtozzldqivtksgwtgo",true,true,0,false,"tozzldqivtksgwtg",0,true,false,false,{"controversy": "ozzldqivtk","unlikely": 0,"recover": "zzldqivtksgwtgowpg"},0,true,false]', 'utility', 'true' ) LIMIT 3 /* QNO 825 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'juror', 'true' ) LIMIT 1 /* QNO 747 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$."driver"****' ) ) = 6 LIMIT 9 /* QNO 748 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 0 LIMIT 4 /* QNO 751 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', '0', '$[1]**', '0' ), '$."steady"[8][1]**' ) = 4 LIMIT 2 /* QNO 829 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 4 /* QNO 931 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$.*[4].surgeon' ) ) = 5 LIMIT 4 /* QNO 753 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 1 /* QNO 932 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', 'qn' ) != NULL LIMIT 1 /* QNO 755 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '0', '$.merely[4]' ) = 1 LIMIT 2 /* QNO 833 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 1 LIMIT 3 /* QNO 835 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$.conspiracy**[*]', '$.*.*.*.shoulder', '$[7].circle."survey"', '$**', '$[*].ranch[7][5]', '$.affect[3]**' ) = 8 LIMIT 9 /* QNO 759 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 6 /* QNO 937 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'busy', NULL, '$**.***.disk' ) != NULL LIMIT 7 /* QNO 838 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**[8]**[7]', '0', '$[7][7]**', 'NULL' ) )= 5 LIMIT 1 /* QNO 939 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$' )) = 8 LIMIT 7 /* QNO 941 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[4]."fraud"**', '[0,{"trait": 0,"useful": "cxm"},"xmlfhkuxtrppo","mlfhkuxtrppoghec",0,"lfhkuxtrppoghecauhfpjjzm",true]', '$[0]', 'NULL' ) )= 8 LIMIT 7 /* QNO 842 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 1 /* QNO 843 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 1 /* QNO 943 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 7 LIMIT 6 /* QNO 765 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 3 LIMIT 0 /* QNO 844 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'true' ) = 0 LIMIT 1 /* QNO 945 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$', '$."translation".ruling' ) ) = 8 LIMIT 4 /* QNO 846 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$[6]' ) = 7 LIMIT 1 /* QNO 948 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$**', '[true,NULL,"yqczpmkdtyuv",0,0]' ) ) = 7 LIMIT 1 /* QNO 771 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$**.rapidly."planet"', 'NULL' ) ) = 9 LIMIT 8 /* QNO 854 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 'know' ) != NULL LIMIT 4 /* QNO 955 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 1 LIMIT 4 /* QNO 777 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'peanut' LIMIT 7 /* QNO 956 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.*******', '"icjlstwjkjmgkycsbtynsebsshmmvjjyjdqeeh"' ) )= 7 LIMIT 6 /* QNO 778 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', '', NULL, '$**."birth"**.unit', '%', '$.rail**."discover"**', "'", '$[5][3].considerably**' ) != NULL LIMIT 9 /* QNO 781 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$[6][4]' ) ) = 1 LIMIT 7 /* QNO 960 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', '"ogxebhmxcykppuwobrouwsidebykahf"' ) ) = 2 LIMIT 8 /* QNO 864 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'true', '$' ) = 0 LIMIT 7 /* QNO 865 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[1]', '$' )) = 0 LIMIT 1 /* QNO 783 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[4][7]**."others"', '0' ) ) = 1 LIMIT 2 /* QNO 785 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '$' ) = 1 LIMIT 6 /* QNO 786 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 0 /* QNO 968 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$.*' ) = 1 LIMIT 5 /* QNO 873 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', NULL, '\\', '$' ) != NULL LIMIT 0 /* QNO 791 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'reject', 'true' ) LIMIT 3 /* QNO 797 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$' ) ) = 5 LIMIT 3 /* QNO 975 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 3 LIMIT 5 /* QNO 881 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[3]."flour"', 'true', '$[1]', 'false', '$[*][*][*]', '"jkupuxzwgqhed"', '$[4]', 'true' ) )= 1 LIMIT 3 /* QNO 883 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[0]**."suffering"', 'false', '$', 'true' ) )= 3 LIMIT 4 /* QNO 802 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 0 /* QNO 804 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 1 LIMIT 1 /* QNO 805 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'false' ) = 0 LIMIT 2 /* QNO 886 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 3 LIMIT 7 /* QNO 887 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**.recommend', 'true', '$', 'true', '$******.various', 'NULL' ) )= 6 LIMIT 7 /* QNO 889 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$."versus"****[3]' ) ) = 8 LIMIT 9 /* QNO 989 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**' ) = 1 LIMIT 1 /* QNO 813 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[*]**' ) = 'finally' LIMIT 8 /* QNO 990 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 8 LIMIT 4 /* QNO 814 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$."crowd"**[8]', '0' ) )= 3 LIMIT 1 /* QNO 894 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', '', '"', '$**' ) != NULL LIMIT 1 /* QNO 815 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$[3][6]', '$', '$' ) = 1 LIMIT 3 /* QNO 896 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 7 LIMIT 2 /* QNO 818 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$' ) ) = 1 LIMIT 7 /* QNO 994 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.demographic', '$**' ) ) = 9 LIMIT 2 /* QNO 900 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', 'true' ) ) = 0 LIMIT 3 /* QNO 821 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 2 LIMIT 2 /* QNO 999 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$.*' ) ) = 6 LIMIT 8 /* QNO 1000 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 2 /* QNO 904 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 6 LIMIT 5 /* QNO 1001 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$**[2][4].trouble' ) = 'stress' LIMIT 0 /* QNO 826 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$**[3].sector' ) = 'proper' LIMIT 4 /* QNO 905 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[6].inmate**."whose"', 'NULL' ) ) = 6 LIMIT 6 /* QNO 827 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$.*[8][6]' ) = 1 LIMIT 4 /* QNO 1002 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'sexy' LIMIT 1 /* QNO 829 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[2].fiber****' ) = 'division' LIMIT 4 /* QNO 1005 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 6 LIMIT 5 /* QNO 831 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 9 LIMIT 4 /* QNO 1007 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$."wide".purse**.*', '$**' ) ) = 7 LIMIT 6 /* QNO 832 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '"communication": 0' ) = 1 LIMIT 9 /* QNO 911 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$', '$.experiment' ) ) = 4 LIMIT 9 /* QNO 1009 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[1]', '$' ) ) = 4 LIMIT 6 /* QNO 1010 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$[6][1][0]**', 'NULL', '$****', 'NULL' ) )= 1 LIMIT 0 /* QNO 916 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$**', 'false' ) ) = 8 LIMIT 8 /* QNO 837 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 6 LIMIT 9 /* QNO 917 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 7 LIMIT 2 /* QNO 1013 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"ovdwdmiazixazffxqmvc"', '$."transfer"[4].*[1]' ) = 0 LIMIT 0 /* QNO 840 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[*].lie.*', '"axptuafvqxdipmq"', '$', '0', '$.badly.message', '"xptuafvqxdipm"', '$**.sport', '0', '$****.end', 'true' ) ) = 1 LIMIT 1 /* QNO 1014 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**.elaborate**', '"pt"', '$', '0' ) )= 8 LIMIT 7 /* QNO 1017 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', 'false' ) ) = 7 LIMIT 2 /* QNO 843 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 2 LIMIT 2 /* QNO 846 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$."pink".***', '$[4]', '$**.*.***' ) = 8 LIMIT 8 /* QNO 1021 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 5 /* QNO 848 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '[]' ) = 1 LIMIT 0 /* QNO 927 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue` ) = 2 LIMIT 8 /* QNO 1024 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.lane."doorway"[8]' ) ) = 8 LIMIT 9 /* QNO 929 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 8 LIMIT 1 /* QNO 1025 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 4 LIMIT 0 /* QNO 930 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 0 LIMIT 5 /* QNO 1026 CON_ID 15 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 8 LIMIT 4 /* QNO 854 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', '', '/', '$[0][2]' ) != NULL LIMIT 0 /* QNO 933 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$', '$[0][*]', '$."sound".influential**[4]' ) ) = 3 LIMIT 0 /* QNO 934 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 6 LIMIT 1 /* QNO 859 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 4 LIMIT 8 /* QNO 937 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$', '"ibzweegzzehojsy"', '$[2].each****', 'true' ), '$.*[*].super."ultimate"', '$', '$**[1].fat**', '$[7][1]' ) = 9 LIMIT 9 /* QNO 861 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, 'false', '$[7][5].adjust[8]' ) = 1 LIMIT 4 /* QNO 944 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 6 LIMIT 5 /* QNO 945 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$."mixed"**', 'false', '$', '"gzzehoj"' ) ) = 5 LIMIT 6 /* QNO 869 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'store' LIMIT 2 /* QNO 870 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 9 /* QNO 948 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$' )) = 1 LIMIT 7 /* QNO 949 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$.sentence[*]' ) = 1 LIMIT 8 /* QNO 950 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 0 LIMIT 8 /* QNO 873 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$**.shine[5]' )) = 7 LIMIT 3 /* QNO 874 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[6][*].approximately**', '$**.*****', '$[*]', '$' ) ) = 7 LIMIT 1 /* QNO 953 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 9 LIMIT 2 /* QNO 875 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$', '$' ) = 0 LIMIT 6 /* QNO 876 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( 'true' ) = 1 LIMIT 9 /* QNO 956 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$' ) = 'six' LIMIT 0 /* QNO 957 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[2]**', '$**', '$.intellectual**[0]' ) ) = 3 LIMIT 3 /* QNO 878 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 4 LIMIT 2 /* QNO 958 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$**[2]**[3]', '"lnpy"', '$', '"npyfmwubezmamfvgyuhdewnogkoiyuigdwegmbyhbuinwhxrj"', '$**.suck', '"pyfmwubezmamfv"' ) )= 8 LIMIT 5 /* QNO 885 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$', 'false' ) )= 8 LIMIT 8 /* QNO 888 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$.male' )) = 6 LIMIT 7 /* QNO 967 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 4, '/', '$.carpet' ) != NULL LIMIT 5 /* QNO 889 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$.distract****', 'true', '$.*', '"y"' ), '$', '$.ie.*' ) = 5 LIMIT 6 /* QNO 969 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 1, '%', '$[3][6]' ) != NULL LIMIT 8 /* QNO 891 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_ARRAY_APPEND( `col_jsonvalue`, '$[3]****[6]', 'NULL' ) ) = 1 LIMIT 2 /* QNO 971 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( '"stream": "bqchjekbrs"' ) = 1 LIMIT 0 /* QNO 975 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '["qchjekbrseimkhs","chjek",NULL,"hjekbrseimkhshe",false,false,false,false,NULL,NULL,false,[],"je","ekbrseimkhsheuu",NULL,"kbrseimkh"]', '$."become"**' ) = 1 LIMIT 2 /* QNO 979 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 0 /* QNO 902 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 1 /* QNO 903 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( `col_jsonvalue`, '$', '$' ) = 6 LIMIT 9 /* QNO 906 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 0 LIMIT 7 /* QNO 984 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_VALID( `col_jsonvalue` ) = 0 LIMIT 1 /* QNO 908 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 0 LIMIT 5 /* QNO 914 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$', '$[2].sexual[4]', '$."impact"**', '$', '$**' )) = 2 LIMIT 0 /* QNO 916 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS( `col_jsonvalue`, '"jvylfkmbcaticjdf"' ) = 1 LIMIT 4 /* QNO 995 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[6].yellow**' ) = 1 LIMIT 4 /* QNO 919 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 6 LIMIT 3 /* QNO 998 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$[8]**', 'NULL' ) ) = 8 LIMIT 4 /* QNO 999 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 5 LIMIT 2 /* QNO 923 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$', 'true' ) )= 6 LIMIT 1 /* QNO 928 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'one', '$' ) = 1 LIMIT 1 /* QNO 929 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_VALUE( `col_jsonvalue`, '$[*][4].accent' ) = 'suburb' LIMIT 4 /* QNO 930 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$."west"[7]**."hold"', '0', '$**', '{"idea": 0,"jury": NULL,"powder": "sehgw","say": 0,"mild": "ehgwuptjrulmvnxueujvntaxiuzezicibtmivq","manufacturing": 0,"motivation": {"rely": true,"describe": 0,"dock": false,"artistic": {"aluminum": NULL,"learn": false,"interact": false},"envelope": 0,"aircraft": false,"principal": NULL,"pocket": 0}}', '$.schedule**', '0' ) ) = 4 LIMIT 3 /* QNO 1008 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$.own[6]**.appointment', '$.hers' ) ) = 7 LIMIT 2 /* QNO 1011 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$[8]**[1]' ) = 0 LIMIT 3 /* QNO 1013 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REPLACE( `col_jsonvalue`, '$', 'NULL' ) ) = 2 LIMIT 6 /* QNO 937 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 9 /* QNO 938 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$**[5]' ) ) = 5 LIMIT 9 /* QNO 939 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue` ) ) = 4 LIMIT 0 /* QNO 942 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$**' ) ) = 3 LIMIT 6 /* QNO 944 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', NULL ) != NULL LIMIT 7 /* QNO 1022 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$."equation"**' ) ) = 8 LIMIT 5 /* QNO 1024 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 6 /* QNO 1025 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_SET( `col_jsonvalue`, '$.*****', 'true', '$**.camera', '"xodwntgflagyzxekwnivtnruyhwgx"', '$[6][*]', 'false' ) )= 3 LIMIT 6 /* QNO 948 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'corn', '"n"', 'delicate', '0' ) LIMIT 3 /* QNO 1026 CON_ID 16 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue` ) ) = 8 LIMIT 2 /* QNO 950 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$' ) ) = 0 LIMIT 5 /* QNO 953 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'liquid', '"odwntgflagyzxekwnivtnruyhw"' ) LIMIT 1 /* QNO 954 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_KEYS( `col_jsonvalue`, '$' ) ) = 6 LIMIT 5 /* QNO 960 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_MERGE( `col_jsonvalue`, `col_jsonvalue`, `col_jsonvalue` ) ) = 6 LIMIT 9 /* QNO 963 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( `col_jsonvalue` ) = 8 LIMIT 6 /* QNO 966 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 3 LIMIT 8 /* QNO 971 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'one', 7 ) != NULL LIMIT 4 /* QNO 976 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 6 LIMIT 6 /* QNO 982 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[2]', '$**."metaphor"' ) ) = 0 LIMIT 3 /* QNO 984 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_UNQUOTE( `col_jsonvalue` ) = `col_jsonvalue` LIMIT 7 /* QNO 986 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', '', 'f', '$.fifteen' ) != NULL LIMIT 0 /* QNO 987 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_EXISTS( `col_jsonvalue`, '$**' ) = 0 LIMIT 1 /* QNO 990 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'social', '"czdvjariiqmqpajvwjuct"' ) LIMIT 4 /* QNO 992 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE `col_jsonvalue` = JSON_OBJECT( 'sensation', 'false' ) LIMIT 2 /* QNO 997 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_TYPE( `col_jsonvalue` ) != NULL LIMIT 0 /* QNO 999 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ), '$.*', '$."skin".*.ratio' ) = 4 LIMIT 9 /* QNO 1002 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_SEARCH( `col_jsonvalue`, 'all', '', '%', '$' ) != NULL LIMIT 4 /* QNO 1005 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_COMPACT( `col_jsonvalue` ) ) = 1 LIMIT 6 /* QNO 1008 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_CONTAINS_PATH( `col_jsonvalue`, 'all', '$[8].unfortunately', '$.*' ) = 1 LIMIT 3 /* QNO 1014 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_DEPTH( JSON_EXTRACT( `col_jsonvalue`, '$[3]', '$[7][8][5]' ) ) = 7 LIMIT 9 /* QNO 1024 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_REMOVE( `col_jsonvalue`, '$[6].reserve' )) = 5 LIMIT 6 /* QNO 1026 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUERY( `col_jsonvalue`, '$' ) ) = 9 LIMIT 5 /* QNO 1028 CON_ID 17 */ ;
SELECT * FROM `json_test` WHERE JSON_LENGTH( JSON_QUOTE( `col_jsonvalue` ) ) = 8 LIMIT 9 /* QNO 1030 CON_ID 17 */ ;