Lines Matching refs:obj
130 CREATE TABLE obj(x);
131 INSERT INTO obj VALUES('{"a":1,"b":2}');
132 SELECT * FROM obj;
135 UPDATE obj SET x = json_insert(x, '$.c', 3);
136 SELECT * FROM obj;
139 SELECT json_extract(x, '$.b') FROM obj;
140 SELECT json_extract(x, '$."b"') FROM obj;
143 UPDATE obj SET x = json_set(x, '$."b"', 555);
144 SELECT json_extract(x, '$.b') FROM obj;
145 SELECT json_extract(x, '$."b"') FROM obj;
148 UPDATE obj SET x = json_set(x, '$."d"', 4);
149 SELECT json_extract(x, '$."d"') FROM obj;