Lines Matching refs:t2
61 create table t2 (k integer primary key, val1, val2, val3);
73 delete from t2;
75 insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
76 update t2 set k=k+10, val2=100+last_insert_rowid();
77 update t2 set val3=1000+last_insert_rowid();
87 select val1 from t2;
94 select val2 from t2;
101 select val3 from t2;
111 delete from t2;
114 insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
115 update t2 set k=k+10, val2=100+last_insert_rowid();
116 update t2 set val3=1000+last_insert_rowid();
126 select val1 from t2;
133 select val2 from t2;
140 select val3 from t2;
150 delete from t2;
153 insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
154 update t2 set k=k+10, val2=100+last_insert_rowid();
155 update t2 set val3=1000+last_insert_rowid();
165 select val1 from t2;
172 select val2 from t2;
179 select val3 from t2;
189 delete from t2;
192 insert into t2 values (77, last_insert_rowid(), NULL, NULL);
193 update t2 set k=k+10, val2=100+last_insert_rowid();
194 update t2 set val3=1000+last_insert_rowid();
204 select val1 from t2;
211 select val2 from t2;
218 select val3 from t2;
228 delete from t2;
231 insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
232 update t2 set k=k+10, val2=100+last_insert_rowid();
233 update t2 set val3=1000+last_insert_rowid();
243 select val1 from t2;
250 select val2 from t2;
257 select val3 from t2;
266 drop table t1; drop table t2; drop trigger r1;
268 create temp table t2 (k integer primary key);
270 create temp view v2 as select * from t2;
282 insert into t2 values (1000+NEW.k);