Lines Matching refs:trigger
16 # trig-1.2: Error if trigger already exists
18 # trig-1.4: DROP TRIGGER removes trigger
20 # trig-1.6: Error if dropped trigger doesn't exist
22 # trig-1.8: A trigger created on a TEMP table is not inserted into sqlite_master
23 # trig-1.9: Ensure that we cannot create a trigger on sqlite_master
63 } {1 {trigger tr1 already exists}}
98 } {1 {no such trigger: biggles}}
105 } {1 {no such trigger: tr1}}
125 } {1 {cannot create trigger on system table}}
128 # a trigger does not mess up the DELETE that caused the trigger to
138 create trigger r1 after delete on t1 for each row begin
153 create trigger r1 after update on t1 for each row begin
166 create trigger t1t instead of update on t1 for each row begin
170 } {1 {cannot create INSTEAD OF trigger on table: t1}}
175 create trigger v1t before update on v1 for each row begin
179 } {1 {cannot create BEFORE trigger on view: v1}}
185 create trigger v1t AFTER update on v1 for each row begin
189 } {1 {cannot create AFTER trigger on view: v1}}
191 # Check for memory leaks in the trigger parser
209 # Create a trigger that refers to a table that might not exist.
221 do_test trigger-3.2 {
227 do_test trigger-3.3 {
233 do_test trigger-3.4 {
239 do_test trigger-3.5 {
246 do_test trigger-3.6 {
256 do_test trigger-3.7 {
263 do_test trigger-3.8 {
269 do_test trigger-3.9 {
278 do_test trigger-4.1 {
287 do_test trigger-4.2 {
297 do_test trigger-4.3 {
303 do_test trigger-4.4 {
311 integrity_check trigger-5.1
313 # Create a trigger with the same name as a table. Make sure the
314 # trigger works. Then drop the trigger. Make sure the table is
317 do_test trigger-6.1 {
320 do_test trigger-6.2 {
327 } {view v1 table t2 trigger t2}
328 do_test trigger-6.3 {
331 do_test trigger-6.4 {
334 do_test trigger-6.5 {
338 } {view v1 table t2 trigger t2}
339 do_test trigger-6.6 {
345 do_test trigger-6.7 {
348 do_test trigger-6.8 {
354 integrity_check trigger-7.1
356 # Check to make sure the name of a trigger can be quoted so that keywords
357 # can be used as trigger names. Ticket #468
359 do_test trigger-8.1 {
361 CREATE TRIGGER 'trigger' AFTER INSERT ON t2 BEGIN SELECT 1; END;
362 SELECT name FROM sqlite_master WHERE type='trigger';
364 } {trigger}
365 do_test trigger-8.2 {
367 DROP TRIGGER 'trigger';
368 SELECT name FROM sqlite_master WHERE type='trigger';
371 do_test trigger-8.3 {
373 CREATE TRIGGER "trigger" AFTER INSERT ON t2 BEGIN SELECT 1; END;
374 SELECT name FROM sqlite_master WHERE type='trigger';
376 } {trigger}
377 do_test trigger-8.4 {
379 DROP TRIGGER "trigger";
380 SELECT name FROM sqlite_master WHERE type='trigger';
383 do_test trigger-8.5 {
385 CREATE TRIGGER [trigger] AFTER INSERT ON t2 BEGIN SELECT 1; END;
386 SELECT name FROM sqlite_master WHERE type='trigger';
388 } {trigger}
389 do_test trigger-8.6 {
391 DROP TRIGGER [trigger];
392 SELECT name FROM sqlite_master WHERE type='trigger';
398 do_test trigger-9.1 {
409 do_test trigger-9.2 {
426 # Also verify that references within trigger programs are resolved at
427 # statement compile time, not trigger installation time. This means, for
429 do_test trigger-10.0 {
439 do_test trigger-10.1 {
446 do_test trigger-10.2 {
459 do_test trigger-10.3 {
466 do_test trigger-10.4 {
471 do_test trigger-10.5 {
480 do_test trigger-10.6 {
485 do_test trigger-10.7 {
493 do_test trigger-10.8 {
498 do_test trigger-10.8 {
500 # that we can change the column names because the trigger programs don't
507 do_test trigger-10.10 {
514 do_test trigger-10.11 {