Documentation Source Text

Check-in [668e39014a]
Login

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: 668e39014a8dbca9b08fcdb9b810ba856e53044c5fa7e473052c2a8931ff2098
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
Unified Diff Ignore Whitespace Patch
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|"&#94;" 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 "&#94;" 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 "&#94;" 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 "&#94;" 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 "&#94;" syntax may be combined with a 
[FTS5 column filters|column filter], but may not be inserted into the middle of
a phrase.