Lines Matching refs:id
133 CREATE TABLE j2(id INTEGER PRIMARY KEY, json, src);
134 INSERT INTO j2(id,json,src)
159 INSERT INTO j2(id,json,src)
161 "id": "0001",
169 { "id": "1001", "type": "Regular" },
170 { "id": "1002", "type": "Chocolate" },
171 { "id": "1003", "type": "Blueberry" },
172 { "id": "1004", "type": "Devil''s Food" }
177 { "id": "5001", "type": "None" },
178 { "id": "5002", "type": "Glazed" },
179 { "id": "5005", "type": "Sugar" },
180 { "id": "5007", "type": "Powdered Sugar" },
181 { "id": "5006", "type": "Chocolate with Sprinkles" },
182 { "id": "5003", "type": "Chocolate" },
183 { "id": "5004", "type": "Maple" }
186 INSERT INTO j2(id,json,src)
189 "id": "0001",
197 { "id": "1001", "type": "Regular" },
198 { "id": "1002", "type": "Chocolate" },
199 { "id": "1003", "type": "Blueberry" },
200 { "id": "1004", "type": "Devil''s Food" }
205 { "id": "5001", "type": "None" },
206 { "id": "5002", "type": "Glazed" },
207 { "id": "5005", "type": "Sugar" },
208 { "id": "5007", "type": "Powdered Sugar" },
209 { "id": "5006", "type": "Chocolate with Sprinkles" },
210 { "id": "5003", "type": "Chocolate" },
211 { "id": "5004", "type": "Maple" }
215 "id": "0002",
223 { "id": "1001", "type": "Regular" }
228 { "id": "5001", "type": "None" },
229 { "id": "5002", "type": "Glazed" },
230 { "id": "5005", "type": "Sugar" },
231 { "id": "5003", "type": "Chocolate" },
232 { "id": "5004", "type": "Maple" }
236 "id": "0003",
244 { "id": "1001", "type": "Regular" },
245 { "id": "1002", "type": "Chocolate" }
250 { "id": "5001", "type": "None" },
251 { "id": "5002", "type": "Glazed" },
252 { "id": "5003", "type": "Chocolate" },
253 { "id": "5004", "type": "Maple" }
261 SELECT id, json_valid(json), json_type(json), '|' FROM j2 ORDER BY id;
764 CREATE TABLE t1(id, json);
765 INSERT INTO t1(id,json) VALUES(1,'{"items":[3,5]}');
766 CREATE TABLE t2(id, json);
767 INSERT INTO t2(id,json) VALUES(2,'{"value":2}');
768 INSERT INTO t2(id,json) VALUES(3,'{"value":3}');
769 INSERT INTO t2(id,json) VALUES(4,'{"value":4}');
770 INSERT INTO t2(id,json) VALUES(5,'{"value":5}');
771 INSERT INTO t2(id,json) VALUES(6,'{"value":6}');
774 WHERE Z.value==t2.id);
779 WHERE Z.value==t2.id);