Lines Matching refs:to

4   Normally, in order to create a full-text index on a dataset, the FTS4 
9   designed to extend FTS4 to support the creation of full-text indexes where:
18   the full-text index, the content option can sometimes be used to achieve 
23   In order to create an FTS4 table that does not store a copy of the indexed
24   documents at all, the content option should be set to an empty string.
40   It is not possible to UPDATE or DELETE a row stored in a contentless FTS4
41   table. Attempting to do so is an error.
44   an error to attempt to retrieve the value of any table column other than
54     -- other than docid are required to evaluate them.
60   Errors related to attempting to retrieve column values other than docid
63   may be no error at all even if a statement does refer to column values 
68   An "external content" FTS4 table is similar to a contentless table, except
70   docid, FTS4 attempts to retrieve that value from a table (or view, or 
71   virtual table) nominated by the user (hereafter referred to as the "content
72   table"). The FTS4 module never writes to the content table, and writing
73   to the content table does not affect the full-text index. It is the
74   responsibility of the user to ensure that the content table and the 
78   to the name of a table (or view, or virtual table) that may be queried by
79   FTS4 to retrieve column values when required. If the nominated table does
90   docid, FTS attempts to read this value from the corresponding column of
91   the row in the content table with a rowid value equal to the current FTS
105     -- The query uses the full-text index to discover that the MATCH 
108     -- to return.
122     -- NULL values. NULL values are returned because FTS is unable to find
128   When a row is deleted from an external content FTS4 table, FTS4 needs to
131   that occurs within the deleted row to indicate that that row has been 
134   to predict. The FTS index may be left containing entries corresponding to the
135   deleted row, which can lead to seemingly nonsensical results being returned
139   Instead of writing separately to the full-text index and the content table,
140   some users may wish to use database triggers to keep the full-text index
141   up to date with respect to the set of documents stored in the content table.
160   values in order to update the full-text index. And the INSERT trigger must
161   be fired after the new row is inserted, so as to handle the case where the
166   FTS4 features a special command similar to the 'optimize' command that
175   error to attempt to rebuild the full-text index maintained by a contentless