Lines Matching refs:leaf

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