Lines Matching refs:TRIGGER

13 # 1. CREATE and DROP TRIGGER tests
17 # trigger1-1.4: DROP TRIGGER removes trigger
39      CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
48        CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
60      CREATE TRIGGER trig UPDATE ON t1 FOR EACH STATEMENT BEGIN
66         CREATE TRIGGER tr1 INSERT ON t1 BEGIN
72         CREATE TRIGGER IF NOT EXISTS tr1 DELETE ON t1 BEGIN
79         CREATE TRIGGER tr1 DELETE ON t1 BEGIN
86         CREATE TRIGGER "tr1" DELETE ON t1 BEGIN
93         CREATE TRIGGER [tr1] DELETE ON t1 BEGIN
102         CREATE TRIGGER tr2 INSERT ON t1 BEGIN
105         CREATE TRIGGER tr2 INSERT ON t1 BEGIN
112         DROP TRIGGER IF EXISTS tr1;
113         CREATE TRIGGER tr1 DELETE ON t1 BEGIN
122         DROP TRIGGER tr2;
124         DROP TRIGGER tr2;
130         DROP TRIGGER IF EXISTS biggles;
136         DROP TRIGGER biggles;
143         DROP TRIGGER tr1;
153           CREATE TRIGGER temp_trig UPDATE ON temp_table BEGIN
163     CREATE TRIGGER tr1 AFTER UPDATE ON sqlite_master BEGIN
241     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
248     CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
263       CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
295       DROP TRIGGER r1;
296       CREATE TEMP TRIGGER r1 AFTER INSERT ON t1 BEGIN
305       DROP TRIGGER r1;
308       CREATE TEMP TRIGGER r1 AFTER INSERT ON t1 BEGIN
362       CREATE TEMP TRIGGER r1 BEFORE INSERT ON t1 BEGIN
417     CREATE TRIGGER t2 BEFORE DELETE ON t2 BEGIN
437     DROP TRIGGER t2;
457     CREATE TRIGGER 'trigger' AFTER INSERT ON t2 BEGIN SELECT 1; END;
463     DROP TRIGGER 'trigger';
469     CREATE TRIGGER "trigger" AFTER INSERT ON t2 BEGIN SELECT 1; END;
475     DROP TRIGGER "trigger";
481     CREATE TRIGGER [trigger] AFTER INSERT ON t2 BEGIN SELECT 1; END;
487     DROP TRIGGER [trigger];
502         CREATE TRIGGER r34 AFTER INSERT ON t3 BEGIN
520         CREATE TRIGGER r34 AFTER INSERT ON t3 BEGIN
566       CREATE TEMP TRIGGER trig1 AFTER INSERT ON main.t4 BEGIN 
569       CREATE TEMP TRIGGER trig2 AFTER INSERT ON temp.t4 BEGIN 
572       CREATE TEMP TRIGGER trig3 AFTER INSERT ON aux.t4 BEGIN 
646     CREATE TRIGGER tA_trigger BEFORE UPDATE ON "tA" BEGIN SELECT 1; END;
667     CREATE TRIGGER main.t16err1 AFTER INSERT ON tA BEGIN
674     CREATE TRIGGER main.t16err2 AFTER INSERT ON tA BEGIN
681     CREATE TRIGGER main.t16err3 AFTER INSERT ON tA BEGIN
688     CREATE TRIGGER main.t16err4 AFTER INSERT ON tA BEGIN
695     CREATE TRIGGER main.t16err5 AFTER INSERT ON tA BEGIN
702     CREATE TRIGGER main.t16err6 AFTER INSERT ON tA BEGIN
709     CREATE TRIGGER main.t16err7 AFTER INSERT ON tA BEGIN
721   CREATE TRIGGER t17a_ai AFTER INSERT ON t17a BEGIN
724   CREATE TRIGGER t17b_ai AFTER INSERT ON t17b BEGIN
741   CREATE TRIGGER t18r1 BEFORE UPDATE ON t18 BEGIN
760   CREATE TRIGGER t19r3 BEFORE UPDATE ON t19 BEGIN SELECT new.b; END;
780   CREATE TEMP TRIGGER r20_3 AFTER INSERT ON t20_2 BEGIN UPDATE t20_3 SET z=z+1; END;
782   DROP TRIGGER r20_3;
793   CREATE TRIGGER tr0 AFTER DELETE ON t0 BEGIN
813   CREATE TRIGGER x AFTER UPDATE ON t1 BEGIN
820   CREATE TEMP TRIGGER x BEFORE INSERT ON t1 BEGIN
836   CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN