Lines Matching refs:tbl
69 {CREATE TABLE tbl (a INTEGER PRIMARY KEY, b) WITHOUT rowid;} \
70 {CREATE TABLE tbl (a, b PRIMARY KEY) WITHOUT rowid;} \
71 {CREATE TABLE tbl (a PRIMARY KEY, b) WITHOUT rowid;
72 CREATE INDEX tbl_idx ON tbl(b);} \
76 {CREATE TEMP TABLE tbl (a PRIMARY KEY, b) WITHOUT rowid;
77 CREATE INDEX tbl_idx ON tbl(b);}
79 {CREATE TEMP TABLE tbl (a PRIMARY KEY, b) WITHOUT rowid}
81 {CREATE TEMPORARY TABLE tbl (a INTEGER PRIMARY KEY, b) WITHOUT rowid;}
89 DROP TABLE tbl;
96 INSERT INTO tbl VALUES(1, 2);
97 INSERT INTO tbl VALUES(3, 4);
102 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
106 (SELECT coalesce(sum(a),0) FROM tbl),
107 (SELECT coalesce(sum(b),0) FROM tbl),
111 CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW
115 (SELECT coalesce(sum(a),0) FROM tbl),
116 (SELECT coalesce(sum(b),0) FROM tbl),
120 CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
125 (SELECT coalesce(sum(a),0) FROM tbl),
126 (SELECT coalesce(sum(b),0) FROM tbl),
134 UPDATE tbl SET a = a * 10, b = b * 10;
149 DELETE FROM tbl;
150 INSERT INTO tbl VALUES (100, 100);
151 INSERT INTO tbl VALUES (300, 200);
152 CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
156 (SELECT coalesce(sum(a),0) FROM tbl),
157 (SELECT coalesce(sum(b),0) FROM tbl),
161 CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW
165 (SELECT coalesce(sum(a),0) FROM tbl),
166 (SELECT coalesce(sum(b),0) FROM tbl),
173 DELETE FROM tbl;
186 CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
190 (SELECT coalesce(sum(a),0) FROM tbl),
191 (SELECT coalesce(sum(b),0) FROM tbl),
195 CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW
199 (SELECT coalesce(sum(a),0) FROM tbl),
200 (SELECT coalesce(sum(b),0) FROM tbl),
210 -- INSERT INTO tbl SELECT * FROM other_tbl;
211 INSERT INTO tbl VALUES(5, 6);
224 DROP TABLE tbl;
232 {UPDATE tbl SET b = old.b;}
235 {INSERT INTO tbl VALUES(500, new.b * 10, 700);
236 UPDATE tbl SET c = old.c;
238 {INSERT INTO log select * from tbl;}
242 set statement {UPDATE tbl SET c = 10 WHERE a = 1;}
243 set prep {INSERT INTO tbl VALUES(1, 2, 3);}
252 set statement {DELETE FROM tbl WHERE a = 1;}
253 set prep {INSERT INTO tbl VALUES(1, 2, 3);}
259 set statement {INSERT INTO tbl VALUES(1, 2, 3);}
302 DROP TABLE tbl;
307 CREATE TABLE tbl(a PRIMARY KEY, b, c) WITHOUT rowid;
311 set query {SELECT * FROM tbl; SELECT * FROM log;}
319 execsql "DELETE FROM tbl; DELETE FROM log; $prep";
321 ON tbl BEGIN $tr_program_fixed END;"
326 execsql "DELETE FROM tbl; DELETE FROM log;"
331 execsql "DELETE FROM tbl; DELETE FROM log; $prep";
333 ON tbl BEGIN $tr_program_fixed END;"
342 DROP TABLE tbl;
350 CREATE TABLE tbl (a, b, c, d, PRIMARY KEY(a,b,c,d)) WITHOUT rowid;
353 INSERT INTO tbl VALUES (0, 0, 0, 0);
354 INSERT INTO tbl VALUES (1, 0, 0, 0);
355 CREATE TRIGGER tbl_after_update_cd BEFORE UPDATE OF c, d ON tbl
362 UPDATE tbl SET b = 1, c = 10; -- 2
363 UPDATE tbl SET b = 10; -- 0
364 UPDATE tbl SET d = 4 WHERE a = 0; --1
365 UPDATE tbl SET a = 4, b = 10; --0
370 DROP TABLE tbl;
375 set when_triggers [list {t1 BEFORE INSERT ON tbl WHEN new.a > 20}]
378 {t2 BEFORE INSERT ON tbl WHEN (SELECT count(*) FROM tbl) = 0}
382 CREATE TABLE tbl (a, b, c, d);
399 INSERT INTO tbl VALUES(0, 0, 0, 0); -- 1 (ifcapable subquery)
403 INSERT INTO tbl VALUES(0, 0, 0, 0); -- 0
407 INSERT INTO tbl VALUES(200, 0, 0, 0); -- 1
413 DROP TABLE tbl;
448 CREATE TABLE tbl(a, b, c, PRIMARY KEY(c,a,b)) WITHOUT rowid;
449 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
451 INSERT INTO tbl VALUES (new.a, new.b, new.c+1);
456 INSERT INTO tbl VALUES (1, 2, 3);
457 select * from tbl;
461 DROP TABLE tbl;
466 CREATE TABLE tbl(a, b, c, PRIMARY KEY(c,a,b)) WITHOUT rowid;
467 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
469 INSERT INTO tbl VALUES (1, 2, 3);
470 INSERT INTO tbl VALUES (2, 2, 3);
471 UPDATE tbl set b = 10 WHERE a = 1;
472 DELETE FROM tbl WHERE a = 1;
473 DELETE FROM tbl;
478 INSERT INTO tbl VALUES(100, 200, 300);
483 DROP TABLE tbl;
489 CREATE TABLE tbl (a PRIMARY KEY, b, c) WITHOUT rowid;
490 CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
491 INSERT OR IGNORE INTO tbl values (new.a, 0, 0);
497 INSERT INTO tbl values (1, 2, 3);
498 SELECT * from tbl;
503 INSERT OR ABORT INTO tbl values (2, 2, 3);
505 } {1 {UNIQUE constraint failed: tbl.a}}
508 SELECT * from tbl;
513 INSERT OR FAIL INTO tbl values (2, 2, 3);
515 } {1 {UNIQUE constraint failed: tbl.a}}
518 SELECT * from tbl;
523 INSERT OR REPLACE INTO tbl values (2, 2, 3);
524 SELECT * from tbl;
529 INSERT OR ROLLBACK INTO tbl values (3, 2, 3);
531 } {1 {UNIQUE constraint failed: tbl.a}}
534 SELECT * from tbl;
537 execsql {DELETE FROM tbl}
542 INSERT INTO tbl values (4, 2, 3);
543 INSERT INTO tbl values (6, 3, 4);
544 CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
545 UPDATE OR IGNORE tbl SET a = new.a, c = 10;
551 UPDATE tbl SET a = 1 WHERE a = 4;
552 SELECT * from tbl;
557 UPDATE OR ABORT tbl SET a = 4 WHERE a = 1;
559 } {1 {UNIQUE constraint failed: tbl.a}}
562 SELECT * from tbl;
567 UPDATE OR FAIL tbl SET a = 4 WHERE a = 1;
569 } {1 {UNIQUE constraint failed: tbl.a}}
572 SELECT * from tbl;
577 UPDATE OR REPLACE tbl SET a = 1 WHERE a = 4;
578 SELECT * from tbl;
583 INSERT INTO tbl VALUES (2, 3, 4);
584 SELECT * FROM tbl;
589 UPDATE OR ROLLBACK tbl SET a = 4 WHERE a = 1;
591 } {1 {UNIQUE constraint failed: tbl.a}}
594 SELECT * from tbl;
598 DROP TABLE tbl;