Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add documentation for the fts4 notindexed option. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
968222aa1cb08ad9c694421a48db3830 |
User & Date: | dan 2013-06-21 19:06:35.402 |
Context
2013-06-24
| ||
19:23 | Work toward documenting the NGQP changes. (check-in: e1646aea15 user: drh tags: trunk) | |
2013-06-21
| ||
19:06 | Add documentation for the fts4 notindexed option. (check-in: 968222aa1c user: dan tags: trunk) | |
08:00 | Fix another minor typo in the vtable docs. (check-in: a93d66e412 user: mistachkin tags: trunk) | |
Changes
Changes to pages/fts3.in.
︙ | ︙ | |||
1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 | to hold text in multiple languages or scripts, each with different tokenizer rules, and to query each language independently of the others. <tr><td>matchinfo<td> When set to the value "fts3", the matchinfo option reduces the amount of information stored by FTS4 with the consequence that the "l" option of [matchinfo()] is no longer available. <tr><td>order<td> <tcl>hd_fragment fts4order {FTS4 order option}</tcl> ^The "order" option may be set to either "DESC" or "ASC" (in upper or lower case). ^If it is set to "DESC", then FTS4 stores its data in such a way as to optimize returning results in descending order by docid. ^If it is set to "ASC" (the default), then the data structures are | > > > > > > > | 1359 1360 1361 1362 1363 1364 1365 1366 1367 1368 1369 1370 1371 1372 1373 1374 1375 1376 1377 1378 1379 | to hold text in multiple languages or scripts, each with different tokenizer rules, and to query each language independently of the others. <tr><td>matchinfo<td> When set to the value "fts3", the matchinfo option reduces the amount of information stored by FTS4 with the consequence that the "l" option of [matchinfo()] is no longer available. <tr><td>notindexed<td> This option is used to specify the name of a column for which data is not indexed. Values stored in columns that are not indexed are not matched by MATCH queries. Nor are they recognized by auxilliary functions. A single CREATE VIRTUAL TABLE statement may have any number of notindexed options. <tr><td>order<td> <tcl>hd_fragment fts4order {FTS4 order option}</tcl> ^The "order" option may be set to either "DESC" or "ASC" (in upper or lower case). ^If it is set to "DESC", then FTS4 stores its data in such a way as to optimize returning results in descending order by docid. ^If it is set to "ASC" (the default), then the data structures are |
︙ | ︙ | |||
1729 1730 1731 1732 1733 1734 1735 1736 1737 1738 1739 1740 1741 1742 | Attempting to set matchinfo to anything other than "fts3" is an error. If this option is specified, then some of the extra information stored by FTS4 is omitted. This reduces the amount of disk space consumed by an FTS4 table until it is almost the same as the amount that would be used by the equivalent FTS3 table, but also means that the data accessed by passing the 'l' flag to the [matchinfo()] function is not available. <tcl>hd_fragment fts4prefix {FTS4 prefix option}</tcl> <h2 tags="fts4 prefix option">The prefix= option</h2> <p> ^The FTS4 prefix option causes FTS to index term prefixes of specified lengths in the same way that it always indexes complete terms. ^The prefix option | > > > > > > > > > > > > > > > > > > > > > > | 1736 1737 1738 1739 1740 1741 1742 1743 1744 1745 1746 1747 1748 1749 1750 1751 1752 1753 1754 1755 1756 1757 1758 1759 1760 1761 1762 1763 1764 1765 1766 1767 1768 1769 1770 1771 | Attempting to set matchinfo to anything other than "fts3" is an error. If this option is specified, then some of the extra information stored by FTS4 is omitted. This reduces the amount of disk space consumed by an FTS4 table until it is almost the same as the amount that would be used by the equivalent FTS3 table, but also means that the data accessed by passing the 'l' flag to the [matchinfo()] function is not available. <tcl>hd_fragment fts4notindexed {FTS4 notindexed option}</tcl> <h2 tags="fts4 notindexed option">The notindexed= option</h2> <p> Normally, the FTS module maintains an inverted index of all terms in all columns of the table. This option is used to specify the name of a column for which entries should not be added to the index. Multiple "notindexed" options may be used to specify that multiple columns should be omitted from the index. For example: <codeblock> <i>-- Create an FTS4 table for which only the contents of columns c2 and c4</i> <i>-- are tokenized and added to the inverted index.</i> CREATE VIRTUAL TABLE t1 USING fts4(c1, c2, c3, c4, notindexed=c1, notindexed=c3); </codeblock> <p> Values stored in unindexed columns are not eligible to match MATCH operators. The do not influence the results of the offsets() or matchinfo() auxilliary functions. Nor will the snippet() function ever return a snippet based on a value stored in an unindexed column. <tcl>hd_fragment fts4prefix {FTS4 prefix option}</tcl> <h2 tags="fts4 prefix option">The prefix= option</h2> <p> ^The FTS4 prefix option causes FTS to index term prefixes of specified lengths in the same way that it always indexes complete terms. ^The prefix option |
︙ | ︙ |