Searched refs:rowid (Results 1 - 25 of 30) sorted by relevance

12

/external/chromium_org/third_party/sqlite/src/test/
H A Dboundary4.tcl152 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,
[all...]
H A Dcolmeta.test57 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}}
H A Dcollate8.test33 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/
H A Dtest8.c764 ** 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
[all...]
H A Dtest_schema.c64 int rowid; member in struct:schema_cursor
150 ** Retrieve the current rowid.
154 *pRowid = pCur->rowid;
233 pCur->rowid++;
251 pCur->rowid = 0;
H A Drowset.c17 ** can be intermixed with tests to see if a given rowid has been
167 void sqlite3RowSetInsert(RowSet *p, i64 rowid){ argument
184 pEntry->v = rowid;
188 if( p->isSorted && rowid<=pLast->v ){
H A Dshell.c1273 zSelect = appendText(zSelect, " ORDER BY rowid DESC", 0);
1286 ** "ORDER BY rowid DESC" to the end.
1301 sqlite3_snprintf(sizeof(zQ2), zQ2, "%s ORDER BY rowid DESC", zQuery);
H A Dvdbe.c3269 i64 iKey; /* The rowid we are to seek to */
3414 ** P1 is an open table cursor and P2 is a rowid integer. Arrange
3415 ** for P1 to move so that it points to the rowid given by P2.
3533 ** The value of N can be inferred from the cursor. N includes the rowid
3534 ** value appended to the end of the index record. This rowid value may
3541 ** where the first (N-1) fields match but the rowid value at the end
3543 ** to instruction P2. Otherwise, the rowid of the conflicting index
3598 ** to P2. Otherwise, copy the rowid of the conflicting record to
3601 if( (r.flags & UNPACKED_PREFIX_SEARCH) || r.rowid==R ){
3604 pIn3->u.i = r.rowid;
4397 i64 rowid; local
5772 sqlite_int64 rowid; local
[all...]
H A Dtclsqlite.c657 sqlite_int64 rowid
671 Tcl_ListObjAppendElement(0, pCmd, Tcl_NewWideIntObj(rowid));
2387 Tcl_WideInt rowid; local
2392 rowid = sqlite3_last_insert_rowid(pDb->db);
2394 Tcl_SetWideIntObj(pResult, rowid);
H A Dvdbeaux.c2903 ** an index key, and thus ends with a rowid value. The last byte
2904 ** of the header will therefore be the serial type of the rowid:
2906 ** The serial type of the final rowid will always be a single byte.
2908 ** to ignore the rowid at the end of key1.
2969 ** rowid field were equal, then clear the PREFIX_SEARCH flag and set
2970 ** pPKey2->rowid to the value of the rowid field in (pKey1, nKey1).
2977 pPKey2->rowid = mem1.u.i;
3013 ** Read the rowid (the last field in the record) and store it in *rowid
3019 sqlite3VdbeIdxRowid(sqlite3 *db, BtCursor *pCur, i64 *rowid) argument
[all...]
/external/wpa_supplicant_8/hs20/server/www/
H A Dcert-enroll.php17 $row = $db->query("SELECT rowid,* FROM sessions WHERE id='$id'")->fetch();
23 $rowid = $row['rowid']; variable
28 if (!$db->exec("UPDATE sessions SET user='$user', type='cert' WHERE rowid=$rowid")) {
H A Dadd-free.php17 $row = $db->query("SELECT rowid,* FROM sessions WHERE id='$id'")->fetch();
23 $rowid = $row['rowid']; variable
39 if (!$db->exec("UPDATE sessions SET user='$user', password='$pw', realm='$realm', machine_managed='1' WHERE rowid=$rowid")) {
H A Dadd-mo.php28 $row = $db->query("SELECT rowid,* FROM sessions WHERE id='$id'")->fetch();
43 $rowid = $row['rowid']; variable
45 if (!$db->exec("UPDATE sessions SET user='$user', password='$pw', realm='$realm', type='password' WHERE rowid=$rowid")) {
H A Dest.php11 unset($rowid);
40 $sql = "SELECT rowid,password,operation FROM sessions " .
52 $rowid = $row['rowid']; variable
180 if (!$db->exec("UPDATE sessions SET user='$user', cert='$fingerprint', cert_pem='$cert' WHERE rowid=$rowid")) {
/external/chromium_org/third_party/sqlite/src/tool/
H A Dmkspeedsql.tcl125 # 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);
H A Dshowwal.c209 i64 rowid; local
227 i = decodeVarint(a, &rowid);
230 sprintf(&zDesc[nDesc], "rowid: %lld ", rowid);
H A Dshowdb.c296 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");
H A Dspaceanal.tcl116 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/
H A Dviewrtree.tcl106 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
H A Drtree_util.tcl139 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/
H A Dfulltext.c548 /* 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, argument
670 rc = sqlite3_bind_value(s, 1, rowid);
719 term_select(fulltext_vtab *v, const char *zTerm, int nTerm, sqlite_int64 iFirst, sqlite_int64 *rowid, DocList *out) argument
802 term_update(fulltext_vtab *v, sqlite_int64 rowid, DocList *doclist) argument
818 term_delete(fulltext_vtab *v, sqlite_int64 rowid) argument
[all...]
H A Dfts1.c10 /* 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 = ?",
1072 "insert into %_term (rowid, term, segment, doclist) values (?, ?, ?, ?)",
1073 /* TERM_UPDATE */ "update %_term set doclist = ? where rowid = ?",
1074 /* TERM_DELETE */ "delete from %_term where rowid
1245 content_insert(fulltext_vtab *v, sqlite3_value *rowid, sqlite3_value **pValues) argument
1353 term_select(fulltext_vtab *v, const char *pTerm, int nTerm, int iSegment, sqlite_int64 *rowid, DocList *out) argument
1475 term_update(fulltext_vtab *v, sqlite_int64 rowid, DocList *doclist) argument
1490 term_delete(fulltext_vtab *v, sqlite_int64 rowid) argument
3171 sqlite_int64 rowid = sqlite3_value_int64(ppArg[0]); local
[all...]
/external/chromium_org/chrome/browser/extensions/activity_log/
H A Dcounting_policy.cc115 " 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/sqlite/dist/orig/
H A Dshell.c1536 zSelect = appendText(zSelect, " ORDER BY rowid DESC", 0);
1549 ** "ORDER BY rowid DESC" to the end.
1569 sqlite3_snprintf(len+100, zQ2, "%s ORDER BY rowid DESC", zQuery);
2106 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\" ORDER BY rowid DESC;",
2170 " WHERE %s ORDER BY rowid DESC", zWhere);
2508 " (SELECT sql sql, type type, tbl_name tbl_name, name name, rowid x"
2510 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
2512 "ORDER BY rowid",
2518 "SELECT rowid FROM sqlite_master"
3050 " (SELECT sql sql, type type, tbl_name tbl_name, name name, rowid
[all...]
/external/sqlite/dist/
H A Dshell.c1541 zSelect = appendText(zSelect, " ORDER BY rowid DESC", 0);
1554 ** "ORDER BY rowid DESC" to the end.
1574 sqlite3_snprintf(len+100, zQ2, "%s ORDER BY rowid DESC", zQuery);
2126 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\" ORDER BY rowid DESC;",
2190 " WHERE %s ORDER BY rowid DESC", zWhere);
2528 " (SELECT sql sql, type type, tbl_name tbl_name, name name, rowid x"
2530 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
2532 "ORDER BY rowid",
2538 "SELECT rowid FROM sqlite_master"
3070 " (SELECT sql sql, type type, tbl_name tbl_name, name name, rowid
[all...]

Completed in 420 milliseconds

12