Lines Matching refs:insert
31 # changes() set properly after insert
35 insert into t0 values (1);
36 insert into t0 values (1);
37 insert into t0 values (2);
38 insert into t0 values (2);
39 insert into t0 values (1);
40 insert into t0 values (1);
41 insert into t0 values (1);
42 insert into t0 values (2);
100 # 2.x - tests with after insert trigger
102 # changes() changed properly after insert into table containing after trigger
108 create trigger r1 after insert on t1 for each row begin
109 insert into t2 values (NULL, changes(), NULL);
113 insert into t1 values (77);
118 # changes() unchanged upon entry into after insert trigger
125 # changes() changed properly by update within context of after insert trigger
134 # 1 from "insert into t1 values(77)" +
135 # 1 from "insert into t2 values (NULL, changes(), NULL);" +
152 insert into t2 values (NULL, changes(), NULL);
184 insert into t2 values (NULL, changes(), NULL);
185 insert into t0 values (5);
200 # changes() changed properly by insert within context of before delete trigger
223 insert into t0 values (1);
224 insert into t0 values (2);
225 insert into t0 values (1);
226 insert into t0 values (1);
227 insert into t0 values (1);
228 insert into t0 values (2);
229 insert into t0 values (2);
230 insert into t0 values (1);
231 create temp trigger r1 instead of insert on v1 for each row begin
232 insert into n1 values (NULL, changes());
234 insert into n1 values (NULL, changes());
235 insert into t1 values (NEW.k);
236 insert into n1 values (NULL, changes());
238 insert into v2 values (100+NEW.k);
239 insert into n1 values (NULL, changes());
241 create temp trigger r2 instead of insert on v2 for each row begin
242 insert into n2 values (NULL, changes());
243 insert into t2 values (1000+NEW.k);
244 insert into n2 values (NULL, changes());
246 insert into n2 values (NULL, changes());
248 insert into n2 values (NULL, changes());
250 insert into t1 values (77);
264 insert into v1 values (5);