Lines Matching refs:k

31         create table t1 (k integer primary key);
44         create table t1w (k integer primary key) WITHOUT ROWID;
53         update t1 set k=4 where k=2;
61         delete from t1 where k=4;
69         create table t2 (k integer primary key, val1, val2, val3);
98             insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
99             update t2 set k=k+10, val2=100+last_insert_rowid();
107 # LIRID equals NEW.k upon entry into after insert trigger
137             insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
138             update t2 set k=k+10, val2=100+last_insert_rowid();
141         update t1 set k=14 where k=3;
179             insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
180             update t2 set k=k+10, val2=100+last_insert_rowid();
222             update t2 set k=k+10, val2=100+last_insert_rowid();
225         delete from t1 where k=1;
262             insert into t2 values (NEW.k*2, last_insert_rowid(), NULL, NULL);
263             update t2 set k=k+10, val2=100+last_insert_rowid();
266         update v set k=16 where k=14;
301         create temp table t1 (k integer primary key);
302         create temp table t2 (k integer primary key);
305         create temp table rid (k integer primary key, rin, rout);
309             update rid set rin=last_insert_rowid() where k=1;
310             insert into t1 values (100+NEW.k);
312             update rid set rout=last_insert_rowid() where k=1;
315             update rid set rin=last_insert_rowid() where k=2;
316             insert into t2 values (1000+NEW.k);
317             update rid set rout=last_insert_rowid() where k=2;
333         select rin from rid where k=1;
339         select rout from rid where k=1;
345         select rin from rid where k=2;
351         select rout from rid where k=2;