Lines Matching refs:AFTER

29 # trig-1.13: Ensure that AFTER triggers cannot be created on views
123     CREATE TRIGGER tr1 AFTER UPDATE ON sqlite_master BEGIN
182 # Ensure that we cannot create AFTER triggers on views
187     create trigger v1t AFTER update on v1 for each row begin
191 } {1 {cannot create AFTER trigger on view: v1}}
197     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
204     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
218     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
251     CREATE TEMP TRIGGER r1 AFTER INSERT ON t1 BEGIN
363     CREATE TRIGGER 'trigger' AFTER INSERT ON t2 BEGIN SELECT 1; END;
375     CREATE TRIGGER "trigger" AFTER INSERT ON t2 BEGIN SELECT 1; END;
387     CREATE TRIGGER [trigger] AFTER INSERT ON t2 BEGIN SELECT 1; END;
404     CREATE TRIGGER r34 AFTER INSERT ON t3 BEGIN
450     CREATE TEMP TRIGGER trig1 AFTER INSERT ON t1 BEGIN 
453     CREATE TEMP TRIGGER trig2 AFTER INSERT ON t2 BEGIN 
456     CREATE TEMP TRIGGER trig3 AFTER INSERT ON t3 BEGIN