Lines Matching refs:node

287   CREATE TABLE node(
289     parent REFERENCES node DEFERRABLE INITIALLY DEFERRED
293     parent REFERENCES node DEFERRABLE INITIALLY DEFERRED
297 fkey2-2-test 1  0 "INSERT INTO node VALUES(1, 0)"       FKV
299 fkey2-2-test 3  1   "INSERT INTO node VALUES(1, 0)"
300 fkey2-2-test 4  0   "UPDATE node SET parent = NULL"
302 fkey2-2-test 6  0 "SELECT * FROM node" {1 {}}
306 fkey2-2-test 9  1   "INSERT INTO node VALUES(2, 0)"
307 fkey2-2-test 10 0   "UPDATE node SET parent = 1 WHERE nodeid = 2"
309 fkey2-2-test 12 0 "SELECT * FROM node" {1 {} 2 1}
313 fkey2-2-test 15 1   "DELETE FROM node WHERE nodeid = 2"
314 fkey2-2-test 16 0   "INSERT INTO node VALUES(2, NULL)"
316 fkey2-2-test 18 0 "SELECT * FROM node" {1 {} 2 {}}
322 fkey2-2-test 23 0     "DELETE FROM node WHERE nodeid = 1"
325 fkey2-2-test 26 0 "SELECT * FROM node" {1 {} 2 {}}
331 fkey2-2-test 31 0     "DELETE FROM node WHERE nodeid = 1"
336 fkey2-2-test 36 0 "SELECT * FROM node" {2 {}} 
343 fkey2-2-test 42 0   "INSERT INTO node VALUES(3, 2)"
347 fkey2-2-test 45 1   "DELETE FROM node WHERE nodeid=3"
348 fkey2-2-test 47 0   "INSERT INTO node VALUES(3, 2)"
359 fkey2-2-test 57 0   "INSERT INTO node VALUES(4, NULL)"
361 fkey2-2-test 59 0 "SELECT * FROM node" {2 {} 3 2 4 {}}
372 fkey2-2-test 63 0   "DELETE FROM node"
377   catchsql          "INSERT INTO node SELECT parent, 3 FROM leaf"
378 } {1 {UNIQUE constraint failed: node.nodeid}}
380 fkey2-2-test 69 1   "INSERT INTO node VALUES(1, NULL)"
381 fkey2-2-test 70 0   "INSERT INTO node VALUES(2, NULL)"
385 fkey2-2-test 73 1   "DELETE FROM node"
386 fkey2-2-test 74 0   "INSERT INTO node(nodeid) SELECT DISTINCT parent FROM leaf"
450       node PRIMARY KEY, 
453     CREATE TABLE t2(node PRIMARY KEY, parent);
455       DELETE FROM t2 WHERE parent = old.node;
471       DELETE FROM t1 WHERE node = 1;
472       SELECT node FROM t1;
477       DELETE FROM t2 WHERE node = 1;
478       SELECT node FROM t2;
486       DELETE FROM t1 WHERE node = 1;
487       SELECT node FROM t1;
492       DELETE FROM t2 WHERE node = 1;
493       SELECT node FROM t2;