Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix typos. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
73e4989d499db5e650864cae054758b3 |
User & Date: | drh 2015-05-07 11:32:03.041 |
Context
2015-05-07
| ||
11:46 | Update test statistics. (check-in: 3aebfb2618 user: drh tags: trunk) | |
11:32 | Fix typos. (check-in: 73e4989d49 user: drh tags: trunk) | |
2015-05-06
| ||
17:25 | Add news and adjust the date for the 3.8.10 release. (check-in: 854c6fc854 user: drh tags: trunk) | |
Changes
Changes to pages/fts3.in.
︙ | ︙ | |||
1150 1151 1152 1153 1154 1155 1156 | <pre> "a c d" </pre> The 'x' directive would report a single hit for the phrases "a" and "c". However, the 'y' directive reports the number of hits for "c" as zero, as it is part of a sub-expression that does not match the document - (b AND c). For queries that do not contain AND operators descended from OR | | | 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 | <pre> "a c d" </pre> The 'x' directive would report a single hit for the phrases "a" and "c". However, the 'y' directive reports the number of hits for "c" as zero, as it is part of a sub-expression that does not match the document - (b AND c). For queries that do not contain AND operators descended from OR operators, the result values returned by 'y' are always the same as those returned by 'x'. <p style="margin-left:0;margin-right:0"> The first value in the array of integer values corresponds to the leftmost column of the table (column 0) and the first phrase in the query (phrase 0). The values corresponding to other column/phrase combinations may be located using the following formula: |
︙ | ︙ |
Changes to pages/fts5.in.
︙ | ︙ | |||
81 82 83 84 85 86 87 | <p>A description of the available auxiliary functions, and more details regarding configuration of the special "rank" column, are [FTS5 auxiliary functions | available below]. [FTS5 custom auxiliary functions| Custom auxiliary functions] may also be implemented in C and registered with FTS5, just as custom SQL functions may be registered with the SQLite core. | | | 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 | <p>A description of the available auxiliary functions, and more details regarding configuration of the special "rank" column, are [FTS5 auxiliary functions | available below]. [FTS5 custom auxiliary functions| Custom auxiliary functions] may also be implemented in C and registered with FTS5, just as custom SQL functions may be registered with the SQLite core. <p> As well as searching for all rows that contain a term, FTS5 allows the user to search for rows that contain: <ul> <li> any terms that begin with a specified prefix, <li> "phrases" - sequences of terms or prefix terms that must feature in a document for it to match the query, <li> sets of terms, prefix terms or phrases that appear within a specified |
︙ | ︙ | |||
1011 1012 1013 1014 1015 1016 1017 | INSERT used to invoke the integrity-check command succeeds. Or, if any discrepancy is found, it fails with an [SQLITE_CORRUPT_VTAB] error. <h2 tags="FTS5 optimize command">The 'optimize' Command</h2> <p>This command merges all individual b-trees that currently make up the full-text index into a single large b-tree structure. This ensures that the | | | 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 | INSERT used to invoke the integrity-check command succeeds. Or, if any discrepancy is found, it fails with an [SQLITE_CORRUPT_VTAB] error. <h2 tags="FTS5 optimize command">The 'optimize' Command</h2> <p>This command merges all individual b-trees that currently make up the full-text index into a single large b-tree structure. This ensures that the full-text index consumes the minimum space within the database and is in the fastest form to query. <p>Refer to the documentation for the [FTS5 automerge option] for more details regarding the relationship between the full-text index and its component b-trees. <codeblock> |
︙ | ︙ |
Changes to pages/news.in.
︙ | ︙ | |||
95 96 97 98 99 100 101 | } newsitem {2014-12-09} {Release 3.8.7.4} { <p>SQLite [version 3.8.7.4] an unscheduled bug-fix release. Changes from the previous release and from [version 3.8.7] are minimal. <p>This release fixes adds in a mutex that is required by the changes of | | | 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 | } newsitem {2014-12-09} {Release 3.8.7.4} { <p>SQLite [version 3.8.7.4] an unscheduled bug-fix release. Changes from the previous release and from [version 3.8.7] are minimal. <p>This release fixes adds in a mutex that is required by the changes of the 3.8.7.3 patch but was accidentally omitted. The mutex was not required by any of the internal SQLite tests, but Firefox crashes without it. Test cases have been added to ensure that mutex is never again missed. } newsitem {2014-12-06} {Release 3.8.7.3} { <p>SQLite [version 3.8.7.3] an unscheduled bug-fix release. Changes from the previous release and from [version 3.8.7] are minimal. |
︙ | ︙ |