| /external/chromium_org/third_party/sqlite/src/test/ |
| boundary4.tcl | 152 maketest 1.3 {SELECT rowid, a, x FROM t1 ORDER BY +rowid} $ans
153 maketest 1.4 {SELECT rowid, a, x FROM t1 ORDER BY rowid} $ans
159 maketest 1.5 {SELECT rowid, a, x FROM t1 ORDER BY +rowid DESC} $ans
160 maketest 1.6 {SELECT rowid, a, x FROM t1 ORDER BY rowid DESC} $ans
167 maketest 1.7 {SELECT rowid, a, x FROM t1 ORDER BY +a} $ans
168 maketest 1.8 {SELECT rowid, a, x FROM t1 ORDER BY a} $an
[all...] |
| colmeta.test | 57 13 {main abc rowid} {0 {INTEGER BINARY 0 1 0}}
58 14 {main abc3 rowid} {0 {INTEGER BINARY 0 1 0}}
64 15 {main abc4 rowid} {0 {INTEGER BINARY 0 1 1}}
72 12 {main v1 rowid} {1 {no such table column: v1.rowid}}
|
| collate8.test | 33 SELECT rowid FROM t1 WHERE a<'ccc' ORDER BY 1
38 SELECT rowid FROM t1 WHERE a<'ccc' COLLATE binary ORDER BY 1
43 SELECT rowid FROM t1 WHERE +a<'ccc' ORDER BY 1
|
| /external/chromium_org/third_party/sqlite/src/src/ |
| test8.c | 764 ** SELECT rowid, * FROM <real-table> ?<where-clause>? ?<order-by-clause>?
819 zQuery = sqlite3_mprintf("SELECT rowid, * FROM %Q", pVtab->zTableName);
839 zCol = "rowid";
878 zCol = "rowid";
916 ** INTEGER NULL (nCol args) UPDATE (do not set rowid)
917 ** INTEGER INTEGER (nCol args) UPDATE (with SET rowid = <arg1>)
919 ** NULL NULL (nCol args) INSERT INTO (automatic rowid value)
920 ** NULL INTEGER (nCol args) INSERT (incl. rowid value)
961 string_concat(&z, " SET rowid=?1 ", 0, &rc);
970 string_concat(&z, sqlite3_mprintf(" WHERE rowid=?%d", nData), 1, &rc)
[all...] |
| test_schema.c | 64 int rowid; member in struct:schema_cursor
150 ** Retrieve the current rowid.
154 *pRowid = pCur->rowid;
233 pCur->rowid++;
251 pCur->rowid = 0;
|
| rowset.c | 17 ** can be intermixed with tests to see if a given rowid has been
81 i64 v; /* ROWID value for this entry */
167 void sqlite3RowSetInsert(RowSet *p, i64 rowid){
184 pEntry->v = rowid;
188 if( p->isSorted && rowid<=pLast->v ){
|
| shell.c | [all...] |
| vdbe.c | 4397 i64 rowid; local
5772 sqlite_int64 rowid; local
[all...] |
| tclsqlite.c | 657 sqlite_int64 rowid
671 Tcl_ListObjAppendElement(0, pCmd, Tcl_NewWideIntObj(rowid));
2387 Tcl_WideInt rowid; local
[all...] |
| vdbeaux.c | [all...] |
| sqliteInt.h | 777 ** The sqlite.lastRowid records the last insert rowid generated by an
817 i64 lastRowid; /* ROWID of most recent insert (see above) */
1430 i64 rowid; \/* Used by UNPACKED_PREFIX_SEARCH *\/ member in struct:UnpackedRecord
[all...] |
| /external/chromium_org/third_party/sqlite/src/tool/ |
| mkspeedsql.tcl | 125 # 100000 random SELECTs against rowid.
129 puts "SELECT c FROM t1 WHERE rowid=$id;"
220 SELECT rowid FROM t1 ORDER BY random() LIMIT 20000;
226 DELETE FROM t1 WHERE rowid IN
227 (SELECT rowid FROM t1 ORDER BY random() LIMIT 20000);
234 DELETE FROM t1 WHERE rowid IN
235 (SELECT rowid FROM t1 ORDER BY random() LIMIT 20000);
|
| showwal.c | 209 i64 rowid; local
227 i = decodeVarint(a, &rowid);
230 sprintf(&zDesc[nDesc], "rowid: %lld ", rowid);
|
| showdb.c | 296 i64 rowid; local
318 i = decodeVarint(a, &rowid);
321 sprintf(&zDesc[nDesc], "r: %lld ", rowid);
382 printf(" key: lx=left-child n=payload-size r=rowid\n");
|
| spaceanal.tcl | 116 SELECT pageno FROM temp.dbstat WHERE name = $name ORDER BY rowid
562 This is the number of pages in a table B-tree that hold only key (rowid)
|
| /external/chromium_org/third_party/sqlite/src/ext/rtree/ |
| viewrtree.tcl | 106 foreach {rowid xmin xmax ymin ymax} [lindex $data 0] break
108 foreach {rowid x1 x2 y1 y2} $cell break
143 foreach {rowid x1 x2 y1 y2} $cell break
152 lappend ::O(listbox_captions) "Node $rowid"
168 foreach {rowid x1 x2 y1 y2} $cell break
177 foreach {rowid x1 x2 y1 y2} $cell break
|
| rtree_util.tcl | 139 set mapping_sql "SELECT parentnode FROM $mapping_table WHERE rowid = \$rowid"
142 set mapping_sql "SELECT nodeno FROM $mapping_table WHERE rowid = \$rowid"
145 set rowid [lindex $cell 0]
148 puts "Node $iNode: $mapping_table entry for cell $rowid is $mapping"
|
| /external/chromium_org/third_party/sqlite/src/ext/fts1/ |
| fulltext.c | 548 /* CONTENT_INSERT */ "insert into %_content (rowid, content) values (?, ?)",
549 /* CONTENT_SELECT */ "select content from %_content where rowid = ?",
550 /* CONTENT_DELETE */ "delete from %_content where rowid = ?",
553 "select rowid, doclist from %_term where term = ? and first = ?",
558 /* TERM_UPDATE */ "update %_term set doclist = ? where rowid = ?",
559 /* TERM_DELETE */ "delete from %_term where rowid = ?",
663 /* insert into %_content (rowid, content) values ([rowid], [zContent]) */
664 static int content_insert(fulltext_vtab *v, sqlite3_value *rowid,
670 rc = sqlite3_bind_value(s, 1, rowid);
[all...] |
| fts1.c | 10 /* The flaw is that fts1 uses the content table's unaliased rowid as
11 ** the unique docid. fts1 embeds the rowid in the index it builds,
12 ** and expects the rowid to not change. The SQLite VACUUM operation
1023 QUERY_ROWID, /* lookup by rowid */
1063 /* CONTENT_SELECT */ "select * from %_content where rowid = ?",
1065 /* CONTENT_DELETE */ "delete from %_content where rowid = ?",
1068 "select rowid, doclist from %_term where term = ? and segment = ?"
3171 sqlite_int64 rowid = sqlite3_value_int64(ppArg[0]); local
[all...] |
| /external/chromium_org/chrome/browser/extensions/activity_log/ |
| counting_policy.cc | 115 " activitylog_compressed.rowid AS activity_id\n"
259 // 2a. If found, increment the count using update_str and the rowid found in
263 "SELECT rowid FROM " + std::string(kTableName) +
270 " WHERE rowid = ?";
378 int64 rowid = locate_statement.ColumnInt64(0); local
383 update_statement.BindInt64(2, rowid);
542 base::StringPrintf("DELETE FROM %s WHERE rowid = ?", kTableName);
|
| /external/chromium_org/third_party/sqlite/src/ext/fts2/ |
| fts2.c | 10 /* The flaw is that fts2 uses the content table's unaliased rowid as
11 ** the unique docid. fts2 embeds the rowid in the index it builds,
12 ** and expects the rowid to not change. The SQLite VACUUM operation
6284 sqlite_int64 rowid = sqlite3_value_int64(ppArg[0]); local
[all...] |
| /external/chromium_org/third_party/sqlite/amalgamation/ |
| sqlite3.c | 9775 i64 rowid; \/* Used by UNPACKED_PREFIX_SEARCH *\/ member in struct:UnpackedRecord
62745 i64 rowid; member in struct:vdbeExecUnion::OP_IdxRowid_stack_vars
62874 sqlite_int64 rowid; member in struct:vdbeExecUnion::OP_VUpdate_stack_vars
[all...] |
