Lines Matching refs:last_insert_rowid

10 # Tests to make sure that value returned by last_insert_rowid() (LIRID)
35         select last_insert_rowid();
46         select last_insert_rowid(); -- returns 3 from above.
54         select last_insert_rowid();
62         select last_insert_rowid();
70         select last_insert_rowid();
77         select last_insert_rowid();
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();
100             update t2 set val3=1000+last_insert_rowid();
103         select last_insert_rowid();
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();
139             update t2 set val3=1000+last_insert_rowid();
142         select last_insert_rowid();
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();
181             update t2 set val3=1000+last_insert_rowid();
184         select last_insert_rowid();
221             insert into t2 values (77, last_insert_rowid(), NULL, NULL);
222             update t2 set k=k+10, val2=100+last_insert_rowid();
223             update t2 set val3=1000+last_insert_rowid();
226         select last_insert_rowid();
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();
264             update t2 set val3=1000+last_insert_rowid();
267         select last_insert_rowid();
309             update rid set rin=last_insert_rowid() where k=1;
311             insert into v2 values (100+last_insert_rowid());
312             update rid set rout=last_insert_rowid() where k=1;
315             update rid set rin=last_insert_rowid() where k=2;
317             update rid set rout=last_insert_rowid() where k=2;
320         select last_insert_rowid();
327         select last_insert_rowid();
365     SELECT last_insert_rowid();
371   db last_insert_rowid