Home
last modified time | relevance | path

Searched refs:TRIGGER (Results 1 – 25 of 163) sorted by relevance

1234567

/sqlite-3.40.0/test/
H A De_droptrigger.test79 1 "DROP TRIGGER main.tr1"
81 2 "DROP TRIGGER IF EXISTS main.tr1"
83 3 "DROP TRIGGER tr1"
85 4 "DROP TRIGGER IF EXISTS tr1"
88 5 "DROP TRIGGER aux.tr1"
90 6 "DROP TRIGGER IF EXISTS aux.tr1"
93 7 "DROP TRIGGER IF EXISTS aux.xxx"
95 8 "DROP TRIGGER IF EXISTS aux.xxx"
100 # trigger created by the CREATE TRIGGER statement.
103 1 t1 "DROP TRIGGER tr1" {temp.tr1} {}
[all …]
H A Dtrigger1.test13 # 1. CREATE and DROP TRIGGER tests
122 DROP TRIGGER tr2;
124 DROP TRIGGER tr2;
136 DROP TRIGGER biggles;
143 DROP TRIGGER tr1;
295 DROP TRIGGER r1;
305 DROP TRIGGER r1;
437 DROP TRIGGER t2;
463 DROP TRIGGER 'trigger';
475 DROP TRIGGER "trigger";
[all …]
H A Dtrigger7.test31 CREATE TEMP TRIGGER main.r1 AFTER INSERT ON t1 BEGIN
38 CREATE TRIGGER not_a_db.r1 AFTER INSERT ON t1 BEGIN
51 CREATE TRIGGER r1 AFTER UPDATE OF x ON t1 BEGIN
54 CREATE TRIGGER r2 AFTER UPDATE OF y ON t1 BEGIN
89 CREATE TRIGGER t2r1 AFTER INSERT ON t2 BEGIN SELECT 1; END;
91 CREATE TRIGGER t2r3 AFTER UPDATE ON t2 BEGIN SELECT 1; END;
93 CREATE TRIGGER t2r5 AFTER DELETE ON t2 BEGIN SELECT 1; END;
95 CREATE TRIGGER t2r7 AFTER INSERT ON t2 BEGIN SELECT 1; END;
97 CREATE TRIGGER t2r9 AFTER UPDATE ON t2 BEGIN SELECT 1; END;
101 DROP TRIGGER t2r6;
[all …]
H A DtriggerC.test59 CREATE TRIGGER trig1 BEFORE INSERT ON t1 BEGIN
62 CREATE TRIGGER trig2 AFTER INSERT ON t1 BEGIN
68 CREATE TRIGGER trig4 AFTER UPDATE ON t1 BEGIN
75 CREATE TRIGGER trig6 AFTER DELETE ON t1 BEGIN
112 CREATE TRIGGER t4t AFTER DELETE ON t4 BEGIN
221 catchsql { DROP TRIGGER t2_trig }
596 DROP TRIGGER t5t;
708 DROP TRIGGER t7t;
736 DROP TRIGGER t7t;
737 DROP TRIGGER t7ta;
[all …]
H A DtriggerD.test38 CREATE TRIGGER r1 BEFORE INSERT ON t1 BEGIN
41 CREATE TRIGGER r2 AFTER INSERT ON t1 BEGIN
44 CREATE TRIGGER r3 BEFORE UPDATE ON t1 BEGIN
48 CREATE TRIGGER r4 AFTER UPDATE ON t1 BEGIN
52 CREATE TRIGGER r5 BEFORE DELETE ON t1 BEGIN
55 CREATE TRIGGER r6 AFTER DELETE ON t1 BEGIN
88 CREATE TRIGGER r1 BEFORE INSERT ON t1 BEGIN
91 CREATE TRIGGER r2 AFTER INSERT ON t1 BEGIN
94 CREATE TRIGGER r3 BEFORE UPDATE ON t1 BEGIN
98 CREATE TRIGGER r4 AFTER UPDATE ON t1 BEGIN
[all …]
H A Dexists.test70 # TRIGGER objects.
73 sql2 { CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN SELECT 1; END }
75 sql2 { DROP TRIGGER tr1 }
114 # TRIGGER objects.
117 sql1 { DROP TRIGGER IF EXISTS tr1 }
119 sql1 { DROP TRIGGER IF EXISTS tr1 }
181 # TRIGGER objects.
184 sql1 { DROP TRIGGER IF EXISTS aux.tr1 }
186 sql1 { DROP TRIGGER IF EXISTS aux.tr1 }
190 sql1 { DROP TRIGGER IF EXISTS tr1 }
[all …]
H A Daltertab3.test26 CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
149 CREATE TRIGGER AFTER INSERT ON t1 BEGIN
167 DROP TRIGGER after;
259 DROP TRIGGER b;
324 CREATE TRIGGER r1 INSERT ON t1 BEGIN
572 DROP TRIGGER x;
612 CREATE TRIGGER tr1 INSERT ON t3 BEGIN
616 CREATE TRIGGER tr2 INSERT ON t3 BEGIN
632 {CREATE TRIGGER tr2 INSERT ON t3 BEGIN
642 CREATE TRIGGER xx INSERT ON t1 BEGIN
[all …]
H A Dtrigger9.test55 CREATE TRIGGER trig1 BEFORE DELETE ON t1 BEGIN
70 CREATE TRIGGER trig1 BEFORE DELETE ON t1 BEGIN
100 CREATE TRIGGER trig1 BEFORE UPDATE ON t1 BEGIN
115 CREATE TRIGGER trig1 BEFORE UPDATE ON t1 BEGIN
154 CREATE TRIGGER trig1 INSTEAD OF UPDATE ON v1 BEGIN
171 CREATE TRIGGER trig1 INSTEAD OF UPDATE ON v1 BEGIN
185 CREATE TRIGGER trig1 INSTEAD OF UPDATE ON v1 BEGIN
200 CREATE TRIGGER trig1 INSTEAD OF UPDATE ON v1 BEGIN
232 CREATE TRIGGER tr1 INSTEAD OF DELETE ON v1 BEGIN
236 CREATE TRIGGER tr2 INSTEAD OF UPDATE ON v1 BEGIN
[all …]
H A Dtrigger2.test321 execsql "DROP TRIGGER the_trigger;"
332 execsql "DROP TRIGGER the_trigger;"
420 CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
424 CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
445 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
463 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
486 CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
540 CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
702 CREATE TRIGGER r1 INSTEAD OF DELETE ON v1 BEGIN
725 CREATE TRIGGER r2 INSTEAD OF INSERT ON v1 BEGIN
[all …]
H A Dwithout_rowid4.test325 execsql "DROP TRIGGER the_trigger;"
336 execsql "DROP TRIGGER the_trigger;"
424 CREATE TRIGGER tr1 BEFORE INSERT ON tblA BEGIN
428 CREATE TRIGGER tr2 BEFORE INSERT ON tblB BEGIN
449 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
467 CREATE TRIGGER tbl_trig BEFORE INSERT ON tbl
490 CREATE TRIGGER ai_tbl AFTER INSERT ON tbl BEGIN
544 CREATE TRIGGER au_tbl AFTER UPDATE ON tbl BEGIN
706 CREATE TRIGGER r1 INSTEAD OF DELETE ON v1 BEGIN
729 CREATE TRIGGER r2 INSTEAD OF INSERT ON v1 BEGIN
[all …]
H A Dmain.test104 CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr;
124 CREATE TRIGGER xyz AFTER DELETE abc BEGIN
131 CREATE TRIGGER xyz AFTER DELETE backend BEGIN
137 CREATE TRIGGER xyz AFTER DELETE end BEGIN
143 CREATE TRIGGER xyz AFTER DELETE end BEGIN
150 CREATE TRIGGER xyz AFTER DELETE end BEGIN
158 CREATE TRIGGER xyz AFTER DELETE [;end;] BEGIN
164 CREATE TRIGGER xyz AFTER DELETE backend BEGIN
171 TRIGGER exy AFTER DELETE backend BEGIN
200 CREATE TRIGGER xyz AFTER DELETE backend BEGIN
[all …]
H A Daltertab2.test27 CREATE TRIGGER tr1 AFTER INSERT ON rr BEGIN
101 CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
110 CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
149 CREATE TRIGGER r1 AFTER INSERT ON t1 WHEN new.a NOT NULL BEGIN
158 {CREATE TRIGGER r1 AFTER INSERT ON "t1x" WHEN new.a NOT NULL BEGIN
185 CREATE TRIGGER r2 AFTER INSERT ON t2 WHEN new.a NOT NULL BEGIN
245 CREATE TRIGGER r3 AFTER INSERT ON t3 WHEN new.a NOT NULL BEGIN
285 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
297 {CREATE TRIGGER r1 AFTER INSERT ON "xyzzy" BEGIN
307 {CREATE TRIGGER r1 AFTER INSERT ON "xyzzy" BEGIN
[all …]
H A Dhook.test223 DROP TRIGGER r1;
235 CREATE TRIGGER t1_trigger AFTER INSERT ON t1 BEGIN
289 DROP TRIGGER t1_trigger;
631 CREATE TRIGGER t4t BEFORE DELETE ON t4 BEGIN
659 CREATE TRIGGER t5t BEFORE UPDATE ON t5 BEGIN
779 CREATE TRIGGER g AFTER DELETE ON t1 BEGIN DELETE FROM t2 WHERE 1; END;
780 CREATE TRIGGER h AFTER DELETE ON t2 BEGIN DELETE FROM t3 WHERE 1; END;
781 CREATE TRIGGER i AFTER DELETE ON t3 BEGIN DELETE FROM t4 WHERE 1; END;
810 DROP TRIGGER a; DROP TRIGGER b; DROP TRIGGER c;
811 DROP TRIGGER d; DROP TRIGGER e; DROP TRIGGER f;
[all …]
H A Dtemptrigger.test61 CREATE TEMP TRIGGER tr1 AFTER INSERT ON t1 BEGIN
94 # Before the bug was fixed, the following 'DROP TRIGGER' hit an
96 #execsql { DROP TRIGGER tr1 }
112 CREATE TEMP TRIGGER tr1 AFTER INSERT ON t1 BEGIN
134 #execsql { DROP TRIGGER tr1 }
169 CREATE TEMP TRIGGER tr2 AFTER INSERT ON aux.t2 BEGIN
197 # Before the bug was fixed, the following 'DROP TRIGGER' hit an
199 #execsql { DROP TRIGGER tr2 }
213 CREATE TEMP TRIGGER tr1 BEFORE INSERT ON t1 BEGIN
242 {CREATE TRIGGER tr1 BEFORE INSERT ON t1 BEGIN SELECT 1,2,3; END}
[all …]
H A Dalterlegacy.test145 CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
173 CREATE TRIGGER tr1 AFTER INSERT ON "t1" BEGIN
187 CREATE TRIGGER temp.t9t AFTER INSERT ON temp.t9 BEGIN
303 CREATE TRIGGER tr AFTER INSERT ON t1 BEGIN
314 DROP TRIGGER tr;
329 {CREATE TRIGGER tr AFTER INSERT ON aux.t1 BEGIN SELECT 1, 2, 3; END}
366 CREATE TEMP TRIGGER tr AFTER INSERT ON aux.t1 BEGIN
402 CREATE TRIGGER temp.r1 AFTER INSERT ON main.t2 BEGIN
428 CREATE TRIGGER tr1 AFTER UPDATE OF "geom" ON "mytable"
445 CREATE TRIGGER tr2 AFTER INSERT ON mytable_renamed BEGIN
[all …]
H A Daltertab.test137 CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
158 CREATE TRIGGER tr1 AFTER INSERT ON "t11" BEGIN
286 CREATE TRIGGER tr AFTER INSERT ON t1 BEGIN
296 DROP TRIGGER tr;
403 CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
456 CREATE TRIGGER xyz AFTER INSERT ON t1 BEGIN
720 CREATE TRIGGER AFTER INSERT ON t1 BEGIN
731 CREATE TRIGGER AFTER INSERT ON t1 BEGIN
762 CREATE TRIGGER r2 AFTER INSERT ON t1 BEGIN
784 CREATE TRIGGER trig AFTER DELETE ON t_sa
[all …]
H A Dschema3.test62 CREATE TRIGGER tr1 AFTER UPDATE OF d ON t6 BEGIN
72 16 { CREATE TRIGGER tr2 AFTER INSERT ON t3 BEGIN SELECT 1 ; END } {
73 DROP TRIGGER tr2
85 21 { CREATE TRIGGER tr3 BEFORE DELETE ON t7 BEGIN SELECT 1, 2, 3 ; END } {
86 DROP TRIGGER IF EXISTS tr3;
87 CREATE TRIGGER tr3 AFTER INSERT ON t7 BEGIN SELECT 1, 2, 3 ; END
91 CREATE TRIGGER tr4 AFTER UPDATE OF a ON t8 BEGIN
H A DtriggerA.test90 CREATE TRIGGER r1d INSTEAD OF DELETE ON v1 BEGIN
100 CREATE TRIGGER r1u INSTEAD OF UPDATE ON v1 BEGIN
112 CREATE TRIGGER r2d INSTEAD OF DELETE ON v2 BEGIN
122 CREATE TRIGGER r2u INSTEAD OF UPDATE ON v2 BEGIN
134 CREATE TRIGGER r3d INSTEAD OF DELETE ON v3 BEGIN
144 CREATE TRIGGER r3u INSTEAD OF UPDATE ON v3 BEGIN
156 CREATE TRIGGER r4d INSTEAD OF DELETE ON v4 BEGIN
166 CREATE TRIGGER r4u INSTEAD OF UPDATE ON v4 BEGIN
178 CREATE TRIGGER r5d INSTEAD OF DELETE ON v5 BEGIN
188 CREATE TRIGGER r5u INSTEAD OF UPDATE ON v5 BEGIN
H A Dalter.test345 set ::TRIGGER $args
362 set ::TRIGGER
369 set ::TRIGGER
383 set ::TRIGGER
390 set ::TRIGGER
404 set ::TRIGGER
411 set ::TRIGGER
490 set ::TRIGGER
497 set ::TRIGGER
511 set ::TRIGGER
[all …]
H A De_changes.test146 CREATE TRIGGER tr_ai AFTER INSERT ON p1 BEGIN
149 CREATE TRIGGER tr_bd BEFORE DELETE ON p1 BEGIN
152 CREATE TRIGGER tr_au AFTER UPDATE ON p1 BEGIN
287 CREATE TRIGGER AFTER UPDATE ON t1 BEGIN
312 CREATE TRIGGER t1_a_u AFTER UPDATE ON t1 BEGIN
342 CREATE TRIGGER t1_i BEFORE INSERT ON t1 BEGIN
347 CREATE TRIGGER t2_i AFTER INSERT ON t2 BEGIN
352 CREATE TRIGGER t1_u AFTER UPDATE ON t1 BEGIN
357 CREATE TRIGGER t2_u BEFORE UPDATE ON t2 BEGIN
362 CREATE TRIGGER t1_d AFTER DELETE ON t1 BEGIN
[all …]
H A Daltertrig.test43 CREATE TRIGGER r1 INSERT ON t1 BEGIN
52 CREATE TRIGGER r1 INSERT ON t1 BEGIN
58 DROP TRIGGER r1;
59 CREATE TRIGGER r1 INSERT ON t1 BEGIN
68 CREATE TRIGGER r1 INSERT ON t1 BEGIN
147 CREATE TRIGGER r1 INSERT ON t1 BEGIN
156 CREATE TRIGGER r1 INSERT ON t1 BEGIN
H A De_delete.test130 CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
142 CREATE TRIGGER tr1 AFTER UPDATE ON t8 BEGIN
174 DROP TRIGGER main.tr1;
175 DROP TRIGGER aux.tr2;
214 DROP TRIGGER aux.tr1;
215 DROP TRIGGER main.tr1;
263 CREATE TRIGGER tr3 AFTER INSERT ON t8 BEGIN
268 CREATE TRIGGER tr3 AFTER INSERT ON t8 BEGIN
281 CREATE TRIGGER tr3 AFTER INSERT ON t8 BEGIN
286 CREATE TRIGGER tr3 AFTER INSERT ON t8 BEGIN
[all …]
H A Dupfromfault.test35 CREATE TRIGGER t1_insert INSTEAD OF INSERT ON t1 BEGIN
38 CREATE TRIGGER t1_update INSTEAD OF UPDATE ON t1 BEGIN
60 CREATE TRIGGER tr1 BEFORE UPDATE ON t1 BEGIN
63 CREATE TRIGGER tr2 AFTER UPDATE ON t1 BEGIN
102 CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
112 CREATE TRIGGER tr1 AFTER INSERT ON t1 BEGIN
/sqlite-3.40.0/tool/
H A Dmkkeywordhash.c117 # define TRIGGER 0 macro
119 # define TRIGGER 0x00002000 macro
173 { "ABORT", "TK_ABORT", CONFLICT|TRIGGER, 0 },
176 { "AFTER", "TK_AFTER", TRIGGER, 0 },
186 { "BEFORE", "TK_BEFORE", TRIGGER, 0 },
216 { "EACH", "TK_EACH", TRIGGER, 1 },
224 { "FAIL", "TK_FAIL", CONFLICT|TRIGGER, 1 },
228 { "FOR", "TK_FOR", TRIGGER, 2 },
238 { "IGNORE", "TK_IGNORE", CONFLICT|TRIGGER, 1 },
246 { "INSTEAD", "TK_INSTEAD", TRIGGER, 1 },
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5circref.test34 CREATE TRIGGER tr1 AFTER INSERT ON tt_config BEGIN
42 CREATE TRIGGER tr1 AFTER INSERT ON tt_docsize BEGIN
50 CREATE TRIGGER tr1 AFTER INSERT ON tt_content BEGIN
58 CREATE TRIGGER tr1 AFTER INSERT ON tt_data BEGIN
66 CREATE TRIGGER tr1 AFTER INSERT ON tt_idx BEGIN

1234567