Lines Matching refs:json
25 SELECT json_object('ex',json('[52,3.14159]'));
31 SELECT json(' { "this" : "is", "a": [ "test" ] } ');
46 SELECT json_array(1,null,'3',json('[4,5]'),json('{"six":7.7}'));
109 SELECT json_set('{"a":2,"c":4}', '$.c', json('[97,96]'));
211 CREATE TABLE big(json JSON);
212 INSERT INTO big(json) VALUES('{
223 INSERT INTO big(json) VALUES('{
249 FROM big, json_tree(big.json)
255 FROM big, json_tree(big.json)
261 SELECT DISTINCT json_extract(big.json,'$.id')
262 FROM big, json_tree(big.json,'$.partlist')
267 SELECT DISTINCT json_extract(big.json,'$.id')
268 FROM big, json_tree(big.json,'$')
273 SELECT DISTINCT json_extract(big.json,'$.id')
274 FROM big, json_tree(big.json)
351 CASE WHEN subtype(x->'a') THEN 'json' ELSE typeof(x->'a') END AS 'type',
353 CASE WHEN subtype(x->>'a') THEN 'json' ELSE typeof(x->>'a') END AS 'type',
356 THEN 'json' ELSE typeof(json_extract(x,'$.a')) END AS 'type'
359 1 null json {} null {} null \
360 2 123 json 123 integer 123 integer \
361 3 4.5 json 4.5 real 4.5 real \
362 4 {"six"} json six text six text \
363 5 {[7,8]} json {[7,8]} text {[7,8]} json \
364 6 {{"b":9}} json {{"b":9}} text {{"b":9}} json \
374 CASE WHEN subtype(x->y) THEN 'json' ELSE typeof(x->y) END AS 'type',
376 CASE WHEN subtype(x->>y) THEN 'json' ELSE typeof(x->>y) END AS 'type',
379 THEN 'json' ELSE typeof(json_extract(x,format('$[%d]',y))) END AS 'type'
382 0 null json {} null {} null \
383 1 123 json 123 integer 123 integer \
384 2 4.5 json 4.5 real 4.5 real \
385 3 {"six"} json six text six text \
386 4 {[7,8]} json {[7,8]} text {[7,8]} json \
387 5 {{"b":9}} json {{"b":9}} text {{"b":9}} json \