Lines Matching refs:tbl
67 {CREATE TABLE tbl (a, b);} \
68 {CREATE TABLE tbl (a INTEGER PRIMARY KEY, b);} \
69 {CREATE TABLE tbl (a, b PRIMARY KEY);} \
70 {CREATE TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);} \
74 {CREATE TEMP TABLE tbl (a, b); CREATE INDEX tbl_idx ON tbl(b);}
75 lappend tbl_definitions {CREATE TEMP TABLE tbl (a, b);}
77 {CREATE TEMPORARY TABLE tbl (a INTEGER PRIMARY KEY, b);}
85 DROP TABLE tbl;
92 INSERT INTO tbl VALUES(1, 2);
93 INSERT INTO tbl VALUES(3, 4);
98 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
102 (SELECT coalesce(sum(a),0) FROM tbl),
103 (SELECT coalesce(sum(b),0) FROM tbl),
107 CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW
111 (SELECT coalesce(sum(a),0) FROM tbl),
112 (SELECT coalesce(sum(b),0) FROM tbl),
116 CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
121 (SELECT coalesce(sum(a),0) FROM tbl),
122 (SELECT coalesce(sum(b),0) FROM tbl),
130 UPDATE tbl SET a = a * 10, b = b * 10;
145 DELETE FROM tbl;
146 INSERT INTO tbl VALUES (100, 100);
147 INSERT INTO tbl VALUES (300, 200);
148 CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
152 (SELECT coalesce(sum(a),0) FROM tbl),
153 (SELECT coalesce(sum(b),0) FROM tbl),
157 CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW
161 (SELECT coalesce(sum(a),0) FROM tbl),
162 (SELECT coalesce(sum(b),0) FROM tbl),
169 DELETE FROM tbl;
182 CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
186 (SELECT coalesce(sum(a),0) FROM tbl),
187 (SELECT coalesce(sum(b),0) FROM tbl),
191 CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW
195 (SELECT coalesce(sum(a),0) FROM tbl),
196 (SELECT coalesce(sum(b),0) FROM tbl),
206 -- INSERT INTO tbl SELECT * FROM other_tbl;
207 INSERT INTO tbl VALUES(5, 6);
220 DROP TABLE tbl;
228 {UPDATE tbl SET b = old.b;}
231 {INSERT INTO tbl VALUES(500, new.b * 10, 700);
232 UPDATE tbl SET c = old.c;
234 {INSERT INTO log select * from tbl;}
238 set statement {UPDATE tbl SET c = 10 WHERE a = 1;}
239 set prep {INSERT INTO tbl VALUES(1, 2, 3);}
248 set statement {DELETE FROM tbl WHERE a = 1;}
249 set prep {INSERT INTO tbl VALUES(1, 2, 3);}
255 set statement {INSERT INTO tbl VALUES(1, 2, 3);}
298 DROP TABLE tbl;
303 CREATE TABLE tbl(a PRIMARY KEY, b, c);
307 set query {SELECT * FROM tbl; SELECT * FROM log;}
315 execsql "DELETE FROM tbl; DELETE FROM log; $prep";
317 ON tbl BEGIN $tr_program_fixed END;"
322 execsql "DELETE FROM tbl; DELETE FROM log;"
327 execsql "DELETE FROM tbl; DELETE FROM log; $prep";
329 ON tbl BEGIN $tr_program_fixed END;"
338 DROP TABLE tbl;
346 CREATE TABLE tbl (a, b, c, d);
349 INSERT INTO tbl VALUES (0, 0, 0, 0);
350 INSERT INTO tbl VALUES (1, 0, 0, 0);
351 CREATE TRIGGER tbl_after_update_cd BEFORE UPDATE OF c, d ON tbl
358 UPDATE tbl SET b = 1, c = 10; -- 2
359 UPDATE tbl SET b = 10; -- 0
360 UPDATE tbl SET d = 4 WHERE a = 0; --1
361 UPDATE tbl SET a = 4, b = 10; --0
366 DROP TABLE tbl;
371 set when_triggers [list {t1 BEFORE INSERT ON tbl WHEN new.a > 20}]
374 {t2 BEFORE INSERT ON tbl WHEN (SELECT count(*) FROM tbl) = 0}
378 CREATE TABLE tbl (a, b, c, d);
395 INSERT INTO tbl VALUES(0, 0, 0, 0); -- 1 (ifcapable subquery)
399 INSERT INTO tbl VALUES(0, 0, 0, 0); -- 0
403 INSERT INTO tbl VALUES(200, 0, 0, 0); -- 1
409 DROP TABLE tbl;
444 CREATE TABLE tbl(a, b, c);
445 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
447 INSERT INTO tbl VALUES (new.a, new.b, new.c);
452 INSERT INTO tbl VALUES (1, 2, 3);
453 select * from tbl;
457 DROP TABLE tbl;
462 CREATE TABLE tbl(a, b, c);
463 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
465 INSERT INTO tbl VALUES (1, 2, 3);
466 INSERT INTO tbl VALUES (2, 2, 3);
467 UPDATE tbl set b = 10 WHERE a = 1;
468 DELETE FROM tbl WHERE a = 1;
469 DELETE FROM tbl;
474 INSERT INTO tbl VALUES(100, 200, 300);
479 DROP TABLE tbl;
485 CREATE TABLE tbl (a primary key, b, c);
486 CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
487 INSERT OR IGNORE INTO tbl values (new.a, 0, 0);
493 INSERT INTO tbl values (1, 2, 3);
494 SELECT * from tbl;
499 INSERT OR ABORT INTO tbl values (2, 2, 3);
501 } {1 {UNIQUE constraint failed: tbl.a}}
504 SELECT * from tbl;
509 INSERT OR FAIL INTO tbl values (2, 2, 3);
511 } {1 {UNIQUE constraint failed: tbl.a}}
514 SELECT * from tbl;
519 INSERT OR REPLACE INTO tbl values (2, 2, 3);
520 SELECT * from tbl;
525 INSERT OR ROLLBACK INTO tbl values (3, 2, 3);
527 } {1 {UNIQUE constraint failed: tbl.a}}
530 SELECT * from tbl;
533 execsql {DELETE FROM tbl}
538 INSERT INTO tbl values (4, 2, 3);
539 INSERT INTO tbl values (6, 3, 4);
540 CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
541 UPDATE OR IGNORE tbl SET a = new.a, c = 10;
547 UPDATE tbl SET a = 1 WHERE a = 4;
548 SELECT * from tbl;
553 UPDATE OR ABORT tbl SET a = 4 WHERE a = 1;
555 } {1 {UNIQUE constraint failed: tbl.a}}
558 SELECT * from tbl;
563 UPDATE OR FAIL tbl SET a = 4 WHERE a = 1;
565 } {1 {UNIQUE constraint failed: tbl.a}}
568 SELECT * from tbl;
573 UPDATE OR REPLACE tbl SET a = 1 WHERE a = 4;
574 SELECT * from tbl;
579 INSERT INTO tbl VALUES (2, 3, 4);
580 SELECT * FROM tbl;
585 UPDATE OR ROLLBACK tbl SET a = 4 WHERE a = 1;
587 } {1 {UNIQUE constraint failed: tbl.a}}
590 SELECT * from tbl;
594 DROP TABLE tbl;