Lines Matching refs:leaf

291   CREATE TABLE leaf(
305 without_rowid3-2-test 8  1   "INSERT INTO leaf VALUES('a', 2)"
310 without_rowid3-2-test 13 0 "SELECT * FROM leaf" {a 2}
317 without_rowid3-2-test 19 0 "SELECT * FROM leaf" {a 2}
320 without_rowid3-2-test 21 0   "INSERT INTO leaf VALUES('b', 1)"
326 without_rowid3-2-test 27 0 "SELECT * FROM leaf" {a 2 b 1}
329 without_rowid3-2-test 29 0   "INSERT INTO leaf VALUES('c', 1)"
333 without_rowid3-2-test 33 1   "DELETE FROM leaf WHERE cellid = 'b'"
334 without_rowid3-2-test 34 0   "DELETE FROM leaf WHERE cellid = 'c'"
337 without_rowid3-2-test 37 0 "SELECT * FROM leaf" {a 2}
340 without_rowid3-2-test 39 1   "INSERT INTO leaf VALUES('d', 3)"
342 without_rowid3-2-test 41 1   "INSERT INTO leaf VALUES('e', 3)"
353 without_rowid3-2-test 51 1   "INSERT INTO leaf VALUES('f', 4)"
355 without_rowid3-2-test 53 1     "INSERT INTO leaf VALUES('g', 4)"
362 without_rowid3-2-test 60 0 "SELECT * FROM leaf" {a 2 d 3 e 3 f 4}
371 without_rowid3-2-test 62 0   "DELETE FROM leaf"
373 without_rowid3-2-test 64 1   "INSERT INTO leaf VALUES('a', 1)"
374 without_rowid3-2-test 65 1   "INSERT INTO leaf VALUES('b', 2)"
375 without_rowid3-2-test 66 1   "INSERT INTO leaf VALUES('c', 1)"
377   catchsql          "INSERT INTO node SELECT parent, 3 FROM leaf"
386 without_rowid3-2-test 74 0   "INSERT INTO node(nodeid) SELECT DISTINCT parent FROM leaf"