Home
last modified time | relevance | path

Searched refs:last_insert_rowid (Results 1 – 22 of 22) sorted by relevance

/sqlite-3.40.0/test/
H A Dlastinsert.test35 select last_insert_rowid();
54 select last_insert_rowid();
62 select last_insert_rowid();
70 select last_insert_rowid();
77 select last_insert_rowid();
103 select last_insert_rowid();
142 select last_insert_rowid();
184 select last_insert_rowid();
226 select last_insert_rowid();
365 SELECT last_insert_rowid();
[all …]
H A Dfts4lastrowid.test12 # Tests of the last_insert_rowid functionality with fts4.
32 SELECT last_insert_rowid();
41 SELECT last_insert_rowid();
46 SELECT last_insert_rowid();
54 SELECT last_insert_rowid();
56 SELECT last_insert_rowid();
63 SELECT last_insert_rowid();
68 SELECT last_insert_rowid();
H A Dfts2r.test64 INSERT INTO t1 (rowid, c) VALUES (last_insert_rowid(), 'This is a test');
66 INSERT INTO t1 (rowid, c) VALUES (last_insert_rowid(), 'That was a test');
68 INSERT INTO t1 (rowid, c) VALUES (last_insert_rowid(), 'This is a test');
101 INSERT INTO t1 (rowid, c) VALUES (last_insert_rowid(), 'This is a test');
103 INSERT INTO t1 (rowid, c) VALUES (last_insert_rowid(), 'That was a test');
105 INSERT INTO t1 (rowid, c) VALUES (last_insert_rowid(), 'This is a test');
H A Dfts3e.test64 INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'This is a test');
66 INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'That was a test');
68 INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'This is a test');
105 INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'This is a test');
107 INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'That was a test');
109 INSERT INTO t1 (docid, c) VALUES (last_insert_rowid(), 'This is a test');
H A Drowid.test389 # Make sure AFTER triggers that do INSERTs do not change the last_insert_rowid.
411 SELECT last_insert_rowid();
427 SELECT last_insert_rowid();
735 # by last_insert_rowid.
739 return [db last_insert_rowid]
746 SELECT last_insert_rowid();
H A Dvtab1.test802 SELECT last_insert_rowid();
808 SELECT last_insert_rowid();
814 SELECT last_insert_rowid();
831 SELECT last_insert_rowid();
837 SELECT last_insert_rowid();
843 SELECT last_insert_rowid();
856 SELECT last_insert_rowid();
869 SELECT last_insert_rowid();
H A De_insert.test185 1b "SELECT * FROM a2 WHERE oid=last_insert_rowid()" {1 2 3}
188 2b "SELECT * FROM a2 WHERE oid=last_insert_rowid()" {abc {} 10}
191 3b "SELECT * FROM a2 WHERE oid=last_insert_rowid()" {2 x y}
H A Dtclsqlite.test45 …rrorcode, erroroffset, eval, exists, function, incrblob, interrupt, last_insert_rowid, nullvalue, …
130 set v [catch {db last_insert_rowid xyz} msg]
132 } {1 {wrong # args: should be "db last_insert_rowid "}}
H A Dintpkey.test58 db last_insert_rowid
92 db last_insert_rowid
H A Dioerr5.test102 set channel [db incrblob -readonly a Name [db last_insert_rowid]]
H A Dfts1a.test177 set rowid [db last_insert_rowid]
H A Dfts2a.test177 set rowid [db last_insert_rowid]
H A Dfunc.test362 # Test the last_insert_rowid() function
365 execsql {SELECT last_insert_rowid()}
366 } [db last_insert_rowid]
H A Dlaststmtchanges.test18 # last_insert_rowid() (see lastinsert.test), but is restored once
H A Dfts3aa.test178 set rowid [db last_insert_rowid]
H A Dwith1.test507 set parentid [db last_insert_rowid]
H A DcorruptL.test1138 INSERT INTO t1(b,c) SELECT last_insert_rowid(), x FROM c;
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5lastrowid.test12 # Tests of the last_insert_rowid functionality with fts5.
32 SELECT last_insert_rowid();
41 SELECT last_insert_rowid();
46 SELECT last_insert_rowid();
54 SELECT last_insert_rowid();
56 SELECT last_insert_rowid();
63 SELECT last_insert_rowid();
68 SELECT last_insert_rowid();
/sqlite-3.40.0/src/
H A Dsqlite3ext.h108 sqlite_int64 (*last_insert_rowid)(sqlite3*); member
458 #define sqlite3_last_insert_rowid sqlite3_api->last_insert_rowid
H A Dfunc.c570 static void last_insert_rowid( in last_insert_rowid() function
2296 VFUNCTION(last_insert_rowid, 0, 0, 0, last_insert_rowid), in sqlite3RegisterBuiltinFunctions()
H A Dsqlite.h.in2511 ** [last_insert_rowid() SQL function].
/sqlite-3.40.0/ext/rtree/
H A Drtree1.test463 # Test last_insert_rowid().
469 SELECT last_insert_rowid();
475 SELECT last_insert_rowid();