Lines Matching defs:rowid
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
1943 QUERY_ROWID, /* lookup by rowid */
1979 /* CONTENT_SELECT */ "select * from %_content where rowid = ?",
1981 /* CONTENT_DELETE */ "delete from %_content where rowid = ?",
1982 /* CONTENT_EXISTS */ "select rowid from %_content limit 1",
1985 /* BLOCK_SELECT */ "select block from %_segments where rowid = ?",
1986 /* BLOCK_DELETE */ "delete from %_segments where rowid between ? and ?",
2040 "select block from %_segments where rowid between ? and ? order by rowid"
2082 * insert into %_content (rowid, ...) values (?, ...)
2089 append(&sb, "insert into %_content (rowid, ");
2100 * where rowid = ?
2115 append(&sb, " where rowid = ?");
2184 /* insert into %_content (rowid, ...) values ([rowid], [pValues]) */
2185 static int content_insert(fulltext_vtab *v, sqlite3_value *rowid,
2192 rc = sqlite3_bind_value(s, 1, rowid);
2204 * where rowid = [iRowid] */
2232 /* select * from %_content where rowid = [iRow]
2277 /* delete from %_content where rowid = [iRow ] */
2309 ** returns assigned rowid in *piBlockid
2329 ** where rowid between [iStartBlockid] and [iEndBlockid]
3077 ** the rowid
3135 pInfo->idxNum = QUERY_ROWID; /* lookup by rowid */
3148 * TODO: Perhaps rowid matches should be considered cheaper than
3975 ** If idxNum==QUERY_ROWID then do a rowid lookup for a single entry
4017 char *zSql = sqlite3_mprintf("select rowid, * from %%_content %s",
4018 idxNum==QUERY_GENERIC ? "" : "where rowid=?");
4096 ** retrive the rowid for the current row of the result set. The
4097 ** rowid should be written to *pRowid.
6279 * ppArg[0] = old rowid
6280 * ppArg[1] = new rowid
6284 sqlite_int64 rowid = sqlite3_value_int64(ppArg[0]);
6286 sqlite3_value_int64(ppArg[1]) != rowid ){
6287 rc = SQLITE_ERROR; /* we don't allow changing the rowid */
6290 rc = index_update(v, rowid, &ppArg[2]);
6294 * ppArg[1] = requested rowid
