Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add mention of the FTS5-initial-token-syntax in the change log. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
668e39014a8dbca9b08fcdb9b810ba85 |
User & Date: | drh 2018-01-09 21:05:57.507 |
Context
2018-01-10
| ||
17:06 | Update zipfile docs to match the implementation. (check-in: 469ec4c63f user: dan tags: trunk) | |
2018-01-09
| ||
21:05 | Add mention of the FTS5-initial-token-syntax in the change log. (check-in: 668e39014a user: drh tags: trunk) | |
20:05 | Remove colloquialism to make the docs more understandable to non-native speakers. (check-in: 82f8d029ed user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
24 25 26 27 28 29 30 31 32 33 34 35 36 37 | chng {2018-02-00 (3.22.0)} { <li> The output of [sqlite3_trace_v2()] now shows each individual SQL statements run within a trigger. <li> Add the ability to read from [WAL mode] databases even if the application lacks write permission on the database and its containing directory, as long as the -shm and -wal files exist in that directory. <li> Added the [rtreecheck()] scalar SQL function to the [R-Tree extension]. <li> New extensions: <ol type='a'> <li> The [Zipfile virtual table] can read and write a [https://en.wikipedia.org/wiki/Zip_(file_format)|ZIP Archive]. <li> Added the fsdir(PATH) [table-valued function] to the [https://sqlite.org/src/file/ext/misc/fileio.c|fileio.c] extension, for listing the files in a directory. | > | 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | chng {2018-02-00 (3.22.0)} { <li> The output of [sqlite3_trace_v2()] now shows each individual SQL statements run within a trigger. <li> Add the ability to read from [WAL mode] databases even if the application lacks write permission on the database and its containing directory, as long as the -shm and -wal files exist in that directory. <li> Added the [rtreecheck()] scalar SQL function to the [R-Tree extension]. <li> Added support for the [FTS5 initial token|"^" initial token syntax] in FTS5. <li> New extensions: <ol type='a'> <li> The [Zipfile virtual table] can read and write a [https://en.wikipedia.org/wiki/Zip_(file_format)|ZIP Archive]. <li> Added the fsdir(PATH) [table-valued function] to the [https://sqlite.org/src/file/ext/misc/fileio.c|fileio.c] extension, for listing the files in a directory. |
︙ | ︙ |
Changes to pages/fts5.in.
︙ | ︙ | |||
251 252 253 254 255 256 257 258 259 260 261 262 263 264 | <p>The final query in the block above may not work as expected. Because the "*" character is inside the double-quotes, it will be passed to the tokenizer, which will likely discard it (or perhaps, depending on the specific tokenizer in use, include it as part of the final token) instead of recognizing it as a special FTS character. <h2 tags="FTS5 initial token queries">FTS5 Initial Token Queries</h2> <p> If a "^" character appears immediately before a phrase that is not part of a NEAR query, then that phrase only matches a document only if it starts at the first token in a column. The "^" syntax may be combined with a [FTS5 column filters|column filter], but may not be inserted into the middle of a phrase. | > | 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 | <p>The final query in the block above may not work as expected. Because the "*" character is inside the double-quotes, it will be passed to the tokenizer, which will likely discard it (or perhaps, depending on the specific tokenizer in use, include it as part of the final token) instead of recognizing it as a special FTS character. <tcl>hd_fragment carrotq {FTS5 initial token}</tcl> <h2 tags="FTS5 initial token queries">FTS5 Initial Token Queries</h2> <p> If a "^" character appears immediately before a phrase that is not part of a NEAR query, then that phrase only matches a document only if it starts at the first token in a column. The "^" syntax may be combined with a [FTS5 column filters|column filter], but may not be inserted into the middle of a phrase. |
︙ | ︙ |