Lines Matching full:t2
59 create table t2 (k integer primary key, val1, val2, val3);
71 delete from t2;
73 insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
74 update t2 set k=k+10, val2=100+last_insert_rowid();
75 update t2 set val3=1000+last_insert_rowid();
85 select val1 from t2;
92 select val2 from t2;
99 select val3 from t2;
109 delete from t2;
112 insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
113 update t2 set k=k+10, val2=100+last_insert_rowid();
114 update t2 set val3=1000+last_insert_rowid();
124 select val1 from t2;
131 select val2 from t2;
138 select val3 from t2;
148 delete from t2;
151 insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
152 update t2 set k=k+10, val2=100+last_insert_rowid();
153 update t2 set val3=1000+last_insert_rowid();
163 select val1 from t2;
170 select val2 from t2;
177 select val3 from t2;
187 delete from t2;
190 insert into t2 values (77, last_insert_rowid(), NULL, NULL);
191 update t2 set k=k+10, val2=100+last_insert_rowid();
192 update t2 set val3=1000+last_insert_rowid();
202 select val1 from t2;
209 select val2 from t2;
216 select val3 from t2;
226 delete from t2;
229 insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
230 update t2 set k=k+10, val2=100+last_insert_rowid();
231 update t2 set val3=1000+last_insert_rowid();
241 select val1 from t2;
248 select val2 from t2;
255 select val3 from t2;
264 drop table t1; drop table t2; drop trigger r1;
266 create temp table t2 (k integer primary key);
268 create temp view v2 as select * from t2;
280 insert into t2 values (1000+NEW.k);