Lines Matching refs:b
21 INSERT INTO t1(j) VALUES('{"a":1,"b":[1,[2,3],4],"c":99}');
26 json_extract_test 10 {'$.b[#]'} NULL
27 json_extract_test 20 {'$.b[#-1]'} 4
28 json_extract_test 30 {'$.b[#-2]'} {'[2,3]'}
29 json_extract_test 31 {'$.b[#-02]'} {'[2,3]'}
30 json_extract_test 40 {'$.b[#-3]'} 1
31 json_extract_test 50 {'$.b[#-4]'} NULL
32 json_extract_test 60 {'$.b[#-2][#-1]'} 3
33 json_extract_test 70 {'$.b[0]','$.b[#-1]'} {'[1,4]'}
36 json_extract_test 110 {'$.b[#-000001]'} 4
41 json_remove_test 10 {'$.b[#]'} {'{"a":1,"b":[1,[2,3],4],"c":99}'}
42 json_remove_test 20 {'$.b[#-0]'} {'{"a":1,"b":[1,[2,3],4],"c":99}'}
43 json_remove_test 30 {'$.b[#-1]'} {'{"a":1,"b":[1,[2,3]],"c":99}'}
44 json_remove_test 40 {'$.b[#-2]'} {'{"a":1,"b":[1,4],"c":99}'}
45 json_remove_test 50 {'$.b[#-3]'} {'{"a":1,"b":[[2,3],4],"c":99}'}
46 json_remove_test 60 {'$.b[#-4]'} {'{"a":1,"b":[1,[2,3],4],"c":99}'}
47 json_remove_test 70 {'$.b[#-2][#-1]'} {'{"a":1,"b":[1,[2],4],"c":99}'}
49 json_remove_test 100 {'$.b[0]','$.b[#-1]'} {'{"a":1,"b":[[2,3]],"c":99}'}
50 json_remove_test 110 {'$.b[#-1]','$.b[0]'} {'{"a":1,"b":[[2,3]],"c":99}'}
51 json_remove_test 120 {'$.b[#-1]','$.b[#-2]'} {'{"a":1,"b":[[2,3]],"c":99}'}
52 json_remove_test 130 {'$.b[#-1]','$.b[#-1]'} {'{"a":1,"b":[1],"c":99}'}
53 json_remove_test 140 {'$.b[#-2]','$.b[#-1]'} {'{"a":1,"b":[1],"c":99}'}
58 json_insert_test 10 {'$.b[#]','AAA'} {'{"a":1,"b":[1,[2,3],4,"AAA"],"c":99}'}
59 json_insert_test 20 {'$.b[1][#]','AAA'} {'{"a":1,"b":[1,[2,3,"AAA"],4],"c":99}'}
60 json_insert_test 30 {'$.b[1][#]','AAA','$.b[#]','BBB'} \
61 {'{"a":1,"b":[1,[2,3,"AAA"],4,"BBB"],"c":99}'}
62 json_insert_test 40 {'$.b[#]','AAA','$.b[#]','BBB'} \
63 {'{"a":1,"b":[1,[2,3],4,"AAA","BBB"],"c":99}'}
68 json_set_test 10 {'$.b[#]','AAA'} {'{"a":1,"b":[1,[2,3],4,"AAA"],"c":99}'}
69 json_set_test 20 {'$.b[1][#]','AAA'} {'{"a":1,"b":[1,[2,3,"AAA"],4],"c":99}'}
70 json_set_test 30 {'$.b[1][#]','AAA','$.b[#]','BBB'} \
71 {'{"a":1,"b":[1,[2,3,"AAA"],4,"BBB"],"c":99}'}
72 json_set_test 40 {'$.b[#]','AAA','$.b[#]','BBB'} \
73 {'{"a":1,"b":[1,[2,3],4,"AAA","BBB"],"c":99}'}
74 json_set_test 50 {'$.b[#-1]','AAA'} {'{"a":1,"b":[1,[2,3],"AAA"],"c":99}'}
75 json_set_test 60 {'$.b[1][#-1]','AAA'} {'{"a":1,"b":[1,[2,"AAA"],4],"c":99}'}
76 json_set_test 70 {'$.b[1][#-1]','AAA','$.b[#-1]','BBB'} \
77 {'{"a":1,"b":[1,[2,"AAA"],"BBB"],"c":99}'}
78 json_set_test 80 {'$.b[#-1]','AAA','$.b[#-1]','BBB'} \
79 {'{"a":1,"b":[1,[2,3],"BBB"],"c":99}'}
84 json_replace_test 10 {'$.b[#]','AAA'} {'{"a":1,"b":[1,[2,3],4],"c":99}'}
85 json_replace_test 20 {'$.b[1][#]','AAA'} {'{"a":1,"b":[1,[2,3],4],"c":99}'}
86 json_replace_test 30 {'$.b[1][#]','AAA','$.b[#]','BBB'} \
87 {'{"a":1,"b":[1,[2,3],4],"c":99}'}
88 json_replace_test 40 {'$.b[#]','AAA','$.b[#]','BBB'} \
89 {'{"a":1,"b":[1,[2,3],4],"c":99}'}
90 json_replace_test 50 {'$.b[#-1]','AAA'} {'{"a":1,"b":[1,[2,3],"AAA"],"c":99}'}
91 json_replace_test 60 {'$.b[1][#-1]','AAA'} {'{"a":1,"b":[1,[2,"AAA"],4],"c":99}'}
92 json_replace_test 70 {'$.b[1][#-1]','AAA','$.b[#-1]','BBB'} \
93 {'{"a":1,"b":[1,[2,"AAA"],"BBB"],"c":99}'}
94 json_replace_test 80 {'$.b[#-1]','AAA','$.b[#-1]','BBB'} \
95 {'{"a":1,"b":[1,[2,3],"BBB"],"c":99}'}
98 SELECT json_extract(j, '$.b[#-]') FROM t1;
101 SELECT json_extract(j, '$.b[#9]') FROM t1;
104 SELECT json_extract(j, '$.b[#+2]') FROM t1;
107 SELECT json_extract(j, '$.b[#-1') FROM t1;
110 SELECT json_extract(j, '$.b[#-1x]') FROM t1;