Lines Matching refs:j2
133 CREATE TABLE j2(id INTEGER PRIMARY KEY, json, src);
134 INSERT INTO j2(id,json,src)
159 INSERT INTO j2(id,json,src)
186 INSERT INTO j2(id,json,src)
257 SELECT count(*) FROM j2;
261 SELECT id, json_valid(json), json_type(json), '|' FROM j2 ORDER BY id;
272 SELECT j2.rowid, jx.rowid, fullkey, path, key
273 FROM j2, json_tree(j2.json) AS jx
278 SELECT j2.rowid, jx.rowid, fullkey, path, key
279 FROM j2, json_each(j2.json) AS jx
289 SELECT j2.rowid, jx.rowid, fullkey, path, key
290 FROM j2, json_each(j2.json) AS jx
291 WHERE jx.json<>j2.json;
294 SELECT j2.rowid, jx.rowid, fullkey, path, key
295 FROM j2, json_tree(j2.json) AS jx
296 WHERE jx.json<>j2.json;
299 SELECT j2.rowid, jx.rowid, fullkey, path, key
300 FROM j2, json_each(j2.json) AS jx
304 SELECT j2.rowid, jx.rowid, fullkey, path, key
305 FROM j2, json_tree(j2.json) AS jx