Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update the FTS4 document to describe the two-argument form of fts4aux. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
ba14e1152fd911e60b1a7e86a056e8e6 |
User & Date: | drh 2013-04-15 13:16:07.548 |
Context
2013-04-15
| ||
17:13 | Merge in the changes for 3.7.16.2. Update documentation for the mmap_size refactoring. (check-in: 1e3f82a26e user: drh tags: trunk) | |
13:16 | Update the FTS4 document to describe the two-argument form of fts4aux. (check-in: ba14e1152f user: drh tags: trunk) | |
2013-04-14
| ||
20:55 | Fix a typo in the ON CONFLICT clause documentation. (check-in: 0042260937 user: drh tags: trunk) | |
Changes
Changes to pages/fts3.in.
︙ | ︙ | |||
1212 1213 1214 1215 1216 1217 1218 | FTS table directly. Despite its name, fts4aux works just as well with FTS3 tables as it does with FTS4 tables. Fts4aux tables are read-only. The only way to modify the contents of an fts4aux table is by modifying the contents of the associated FTS table. The fts4aux module is automatically included in all [compile fts|builds that include FTS]. <p> | | > | > > > > > > > > > | 1212 1213 1214 1215 1216 1217 1218 1219 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 | FTS table directly. Despite its name, fts4aux works just as well with FTS3 tables as it does with FTS4 tables. Fts4aux tables are read-only. The only way to modify the contents of an fts4aux table is by modifying the contents of the associated FTS table. The fts4aux module is automatically included in all [compile fts|builds that include FTS]. <p> An fts4aux virtual table is constructed with one or two arguments. When used with a single argument, that argument is the unqualified name of the FTS table that it will be used to access. To access a table in a different database (for example, to create a TEMP fts4aux table that will access an FTS3 table in the MAIN database) use the two-argument form and give the name of the target database (ex: "main") in the first argument and the name of the FTS3/4 table as the second argument. (The two-argument form of fts4aux was added for SQLite version 3.7.17 and will throw an error in prior releases.) For example: <codeblock> <i>-- Create an FTS4 table</i> CREATE VIRTUAL TABLE ft USING fts4(x, y); <i>-- Create an fts4aux table to access the full-text index for table "ft"</i> CREATE VIRTUAL TABLE ft_terms USING fts4aux(ft); <i>-- Create a TEMP fts4aux table accessing the "ft" table in "main"</i> CREATE VIRTUAL TABLE temp.ft_terms_2 USING fts4aux(main,ft); </codeblock> <p> For each term present in the FTS table, there are between 2 and N+1 rows in the fts4aux table, where N is the number of user-defined columns in the associated FTS table. An fts4aux table always has the same four columns, as follows, from left to right: |
︙ | ︙ |