Lines Matching refs:trigger

18 # trig-1.2: Error if trigger already exists
20 # trig-1.4: DROP TRIGGER removes trigger
22 # trig-1.6: Error if dropped trigger doesn't exist
24 # trig-1.8: A trigger created on a TEMP table is not inserted into sqlite_master
25 # trig-1.9: Ensure that we cannot create a trigger on sqlite_master
65 } {1 {trigger tr1 already exists}}
100 } {1 {no such trigger: biggles}}
107 } {1 {no such trigger: tr1}}
127 } {1 {cannot create trigger on system table}}
130 # a trigger does not mess up the DELETE that caused the trigger to
140     create trigger r1 after delete on t1 for each row begin
155     create trigger r1 after update on t1 for each row begin
168     create trigger t1t instead of update on t1 for each row begin
172 } {1 {cannot create INSTEAD OF trigger on table: t1}}
177     create trigger v1t before update on v1 for each row begin
181 } {1 {cannot create BEFORE trigger on view: v1}}
187     create trigger v1t AFTER update on v1 for each row begin
191 } {1 {cannot create AFTER trigger on view: v1}}
193 # Check for memory leaks in the trigger parser
211 # Create a trigger that refers to a table that might not exist.
223 do_test trigger-3.2 {
229 do_test trigger-3.3 {
235 do_test trigger-3.4 {
241 do_test trigger-3.5 {
248 do_test trigger-3.6 {
258 do_test trigger-3.7 {
265 do_test trigger-3.8 {
271 do_test trigger-3.9 {
280 do_test trigger-4.1 {
289 do_test trigger-4.2 {
299 do_test trigger-4.3 {
305 do_test trigger-4.4 {
313 integrity_check trigger-5.1
315 # Create a trigger with the same name as a table.  Make sure the
316 # trigger works.  Then drop the trigger.  Make sure the table is
319 do_test trigger-6.1 {
322 do_test trigger-6.2 {
329 } {view v1 table t2 trigger t2}
330 do_test trigger-6.3 {
333 do_test trigger-6.4 {
336 do_test trigger-6.5 {
340 } {view v1 table t2 trigger t2}
341 do_test trigger-6.6 {
347 do_test trigger-6.7 {
350 do_test trigger-6.8 {
356 integrity_check trigger-7.1
358 # Check to make sure the name of a trigger can be quoted so that keywords
359 # can be used as trigger names.  Ticket #468
361 do_test trigger-8.1 {
363     CREATE TRIGGER 'trigger' AFTER INSERT ON t2 BEGIN SELECT 1; END;
364     SELECT name FROM sqlite_master WHERE type='trigger';
366 } {trigger}
367 do_test trigger-8.2 {
369     DROP TRIGGER 'trigger';
370     SELECT name FROM sqlite_master WHERE type='trigger';
373 do_test trigger-8.3 {
375     CREATE TRIGGER "trigger" AFTER INSERT ON t2 BEGIN SELECT 1; END;
376     SELECT name FROM sqlite_master WHERE type='trigger';
378 } {trigger}
379 do_test trigger-8.4 {
381     DROP TRIGGER "trigger";
382     SELECT name FROM sqlite_master WHERE type='trigger';
385 do_test trigger-8.5 {
387     CREATE TRIGGER [trigger] AFTER INSERT ON t2 BEGIN SELECT 1; END;
388     SELECT name FROM sqlite_master WHERE type='trigger';
390 } {trigger}
391 do_test trigger-8.6 {
393     DROP TRIGGER [trigger];
394     SELECT name FROM sqlite_master WHERE type='trigger';
400 do_test trigger-9.1 {
411 do_test trigger-9.2 {
428 # Also verify that references within trigger programs are resolved at
429 # statement compile time, not trigger installation time. This means, for
431 do_test trigger-10.0 {
441 do_test trigger-10.1 {
448 do_test trigger-10.2 {
461 do_test trigger-10.3 {
468 do_test trigger-10.4 {
473 do_test trigger-10.5 {
482 do_test trigger-10.6 {
487 do_test trigger-10.7 {
495 do_test trigger-10.8 {
500 do_test trigger-10.8 {
502 # that we can change the column names because the trigger programs don't
509 do_test trigger-10.10 {
516 do_test trigger-10.11 {