Lines Matching refs:last_insert_rowid

11 # Tests to make sure that value returned by last_insert_rowid() (LIRID)
36         select last_insert_rowid();
44         select last_insert_rowid();
52         select last_insert_rowid();
61         select last_insert_rowid();
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();
78         select last_insert_rowid();
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();
117         select last_insert_rowid();
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();
156         select last_insert_rowid();
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();
195         select last_insert_rowid();
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();
234         select last_insert_rowid();
273             update rid set rin=last_insert_rowid() where k=1;
275             insert into v2 values (100+last_insert_rowid());
276             update rid set rout=last_insert_rowid() where k=1;
279             update rid set rin=last_insert_rowid() where k=2;
281             update rid set rout=last_insert_rowid() where k=2;
284         select last_insert_rowid();
291         select last_insert_rowid();