Documentation Source Text

All files named "pages/fts5.in"
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for pages/fts5.in

2024-09-23
20:14
[8773cdbbee] part of check-in [1ba7deca30] Add documentation for the contentless_unindexed=1 option. (check-in: [1ba7deca30] user: dan branch: trunk, size: 141356)
2024-09-20
18:41
[83bb56eaa4] part of check-in [a840cb7322] Use example table names more consistently in fts5.html. (check-in: [a840cb7322] user: dan branch: trunk, size: 139456)
2024-09-10
20:23
[07b337a3f4] part of check-in [698c28c207] Update documentation for fts5 locale feature. (check-in: [698c28c207] user: dan branch: trunk, size: 139416)
2024-09-09
20:11
[1edc914592] part of check-in [e7cc42743d] Update fts5 file-format documentation to account for locale=1 tables. (check-in: [e7cc42743d] user: dan branch: trunk, size: 139429)
2024-08-26
17:33
[6d51060f7f] part of check-in [05370894c9] Add a missing apostrophe - "tokenizers" -> "tokenizer's". (check-in: [05370894c9] user: dan branch: trunk, size: 138327)
2024-08-24
15:10
[09becb5188] part of check-in [f3d82c828d] Fix typo in fts5.html. (check-in: [f3d82c828d] user: dan branch: trunk, size: 138326)
2024-08-23
17:45
[cdc2a4261c] part of check-in [837177e558] Update fts5.html with docs for the fts5_get_locale() function. (check-in: [837177e558] user: dan branch: trunk, size: 138325)
2024-08-19
20:35
[ce656b59c2] part of check-in [e1a817e1d4] Update fts5.in to docuement the locale=1/fts5_locale() functionality. (check-in: [e1a817e1d4] user: dan branch: trunk, size: 136833)
2024-07-24
12:26
[36e82d9638] part of check-in [13c6e984c0] Typo fix and add a mention of an OPFS corruption fix in the 3.47 change log. (check-in: [13c6e984c0] user: stephan branch: trunk, size: 133708)
2024-05-22
18:42
[39d9a3b727] part of check-in [ef9e4d6a27] Fix minor typos. (check-in: [ef9e4d6a27] user: drh branch: trunk, size: 133707)
2024-05-21
18:18
[04459fa28e] part of check-in [6b6114406d] Fix some inaccuracies in fts5.html. (check-in: [6b6114406d] user: dan branch: trunk, size: 133706)
2024-05-08
15:03
[e88d0173fe] part of check-in [0252f3c8d0] Correct the rowids of the structure and averages records in fts5.in. (check-in: [0252f3c8d0] user: dan branch: trunk, size: 133328)
2024-05-07
11:21
[671ec5197b] part of check-in [8361d1fd9f] Document that the trigram index cannot be used to optimize LIKE expressions if there is an ESCAPE clause. (check-in: [8361d1fd9f] user: dan branch: trunk, size: 133328)
2024-04-16
17:29
[c41d59c572] part of check-in [98b0894622] Add documentation for the fts5-tokenize-blob feature. (check-in: [98b0894622] user: dan branch: fts5-tokenize-blob, size: 135923)
2024-03-27
20:33
[386eeb4c00] part of check-in [37e33a83a0] Add "Custom Auxiliary Functions API Overview" section to fts5.in. (check-in: [37e33a83a0] user: dan branch: trunk, size: 133219)
2023-12-06
18:07
[5e45ee928f] part of check-in [baeaef00b7] Update fts5 docs with description of tokendata=1 option. (check-in: [baeaef00b7] user: dan branch: trunk, size: 124853)
2023-11-04
17:47
[2ca782d406] part of check-in [8820f9fbb7] Update fts5 documentation with the new trigram tokenizer remove_diacritics option. (check-in: [8820f9fbb7] user: dan branch: trunk, size: 123139)
2023-08-28
13:50
[2c7bc4aa3e] part of check-in [99a9efae59] Fix fts5 docs to correctly say that the structure record has id=10 and the averages record id=1. (check-in: [99a9efae59] user: dan branch: trunk, size: 122622)
2023-08-08
16:52
[23bde87777] part of check-in [1444addab4] Update documentation of fts5 contentless-delete tables. (check-in: [1444addab4] user: dan branch: trunk, size: 122622)
02:07
[3455ad4af2] part of check-in [74762ee361] Replace some http:// with https://. (check-in: [74762ee361] user: stephan branch: trunk, size: 122217)
2023-08-07
09:44
[70a5c7a030] part of check-in [fc20f99c7f] Rename pContext to pUserData in the fts5 docs, to match the same change in [src:2ca064d8eb37252e16b]. (check-in: [fc20f99c7f] user: stephan branch: trunk, size: 122210)
2023-07-30
10:48
[1886a2aad5] part of check-in [80512efd52] Updates to the change log for 3.43.0 (check-in: [80512efd52] user: drh branch: trunk, size: 122208)
2023-07-27
18:01
[0f05c91c9d] part of check-in [73ab6b2b65] Add documentation for the fts5 contentless_delete=1 and 'deletemerge' options. (check-in: [73ab6b2b65] user: dan branch: trunk, size: 122153)
2023-07-26
17:26
[bf97536ac4] part of check-in [f39548c42e] Fix another typo in fts5.html. (check-in: [f39548c42e] user: dan branch: trunk, size: 119674)
11:14
[1b16e03c9b] part of check-in [025d350331] Fix problems in fts5 documentation. (check-in: [025d350331] user: dan branch: trunk, size: 119671)
2023-07-10
11:52
[af9e80d046] part of check-in [e5af001918] Attempt to improve the wording of the Contentless Table documentation for FTS5. (check-in: [e5af001918] user: drh branch: trunk, size: 119091)
2023-05-29
17:38
[16f093cdd5] part of check-in [e043cdf1a1] Add examples to fts5.html. (check-in: [e043cdf1a1] user: dan branch: trunk, size: 119123)
2023-04-19
10:53
[db66401e22] part of check-in [747cdcee0f] Update fts5.in so that the trigram tokenizer is no longer described as "experimental". (check-in: [747cdcee0f] user: dan branch: trunk, size: 114016)
2023-04-15
15:42
[ba8c9ca6cb] part of check-in [887ff60b31] Add documentation for 'secure-delete' to fts5.html. (check-in: [887ff60b31] user: dan branch: fts5-secure-delete, size: 114049)
2023-03-01
14:07
[2dc9877988] part of check-in [1d3b0b821c] Fix typos in fts5.in. (check-in: [1d3b0b821c] user: dan branch: trunk, size: 111953)
2023-01-06
00:45
[a3593d2068] part of check-in [6ea20767ad] Clear most missing page fragment link issues, and add tally of those to linkcheck make target. Defer Tcl interface doc improvement for separate check-in, so it now shows missing page fragments. (check-in: [6ea20767ad] user: larrybr branch: trunk, size: 111949)
2022-09-24
16:31
[13ff6fb4a9] part of check-in [43d12ec89b] Fix a broken hyperlink reported by forum post aec0c9cb6d. (check-in: [43d12ec89b] user: drh branch: trunk, size: 112115)
2022-08-10
18:45
[e6a94eb76c] part of check-in [436f0088f9] Fix duplicate words reported by forum post 54abbe9ccd. (check-in: [436f0088f9] user: drh branch: trunk, size: 112104)
2021-11-26
21:13
[21cb4048eb] part of check-in [89f61d3ed7] Minor spelling corrections. (check-in: [89f61d3ed7] user: drh branch: trunk, size: 112112)
2021-08-12
10:50
[0638a756c9] part of check-in [053c63ecc5] Fix some grammar issues in fts5.in. (check-in: [053c63ecc5] user: dan branch: trunk, size: 112112)
2021-08-11
16:12
[249141449a] part of check-in [c5d7ec9a1d] Further enhancements to fts5 shadow table data format documentation. (check-in: [c5d7ec9a1d] user: dan branch: trunk, size: 112038)
2021-08-10
21:18
[1618bdf45f] part of check-in [05ad966e28] Further enhancements for fts5 documentation. (check-in: [05ad966e28] user: dan branch: trunk, size: 107754)
2021-08-09
22:00
[0b54212e7f] part of check-in [018ff48a67] Begin documenting the fts5 on-disk format. (check-in: [018ff48a67] user: dan branch: trunk, size: 100500)
2020-10-14
19:14
[4bbef2a261] part of check-in [ecc48e8715] Update the change log for 3.34.0 (check-in: [ecc48e8715] user: drh branch: trunk, size: 89602)
2020-10-05
16:42
[8c7517919a] part of check-in [a1963591a6] Add documentation for the new experimental fts5 tokenizer "trigram". (check-in: [a1963591a6] user: dan branch: trunk, size: 89530)
2020-09-21
15:02
[b656dc8e2d] part of check-in [179ade5492] Update documentation for fts5 integrity-check command. (check-in: [179ade5492] user: dan branch: trunk, size: 87426)
2020-05-06
13:17
[7fb08ab961] part of check-in [d9ed737ccf] Correct a misstatement about the default value of --enable-fts5 in the FTS5 documentation. (check-in: [d9ed737ccf] user: drh branch: branch-3.31, size: 86945)
2020-04-06
18:59
[ccb25c54fb] part of check-in [de7905fcbb] Fix various minor HTML coding errors pointed out by Gisbert on the forum. (check-in: [de7905fcbb] user: drh branch: branch-3.31, size: 86778)
2019-02-18
15:33
[a9d5b3219b] part of check-in [b5b65a3c13] Change "the following three queries" to "the following four queries" in fts5.in. (check-in: [b5b65a3c13] user: dan branch: trunk, size: 86777)
2019-02-11
13:24
[adbb1efd5a] part of check-in [569262e571] Fix "asterix" typo in fts5.in. (check-in: [569262e571] user: dan branch: trunk, size: 86778)
13:21
[d298a96918] part of check-in [34f973966a] Add documentation for the fts3/4/5 remove_diacritic options. (check-in: [34f973966a] user: dan branch: trunk, size: 86777)
2018-11-12
15:24
[79ad85863f] part of check-in [7b6b7a791b] Enhancements to the documentation regarding security and shadow tables. (check-in: [7b6b7a791b] user: drh branch: trunk, size: 86267)
2018-09-14
17:42
[ce1121348a] part of check-in [c68e153fc6] Fix minor typos detected by the spell checker. (check-in: [c68e153fc6] user: drh branch: trunk, size: 86265)
2018-07-13
20:31
[3bf6cd39a3] part of check-in [e32e877119] Add docs for fts5 unicode61 tokenizer option "categories". (check-in: [e32e877119] user: dan branch: trunk, size: 86265)
2018-06-08
13:21
[0285e14160] part of check-in [59e5f9e3da] Use https for all internal hyperlinks. (check-in: [59e5f9e3da] user: drh branch: branch-3.24-https, size: 85211)
2018-02-19
10:46
[8be3e2c25d] part of check-in [1225bcc93d] Add a list of shadow tables to the fts5 documentation. (check-in: [1225bcc93d] user: dan branch: trunk, size: 85215)
2018-01-09
21:05
[05708e7ebf] part of check-in [668e39014a] Add mention of the FTS5-initial-token-syntax in the change log. (check-in: [668e39014a] user: drh branch: trunk, size: 83651)
2017-11-25
15:22
[07e05d774d] part of check-in [820de7c995] Update the fts5 documentation to make it clear that the xDestroy function is not invoked if either xCreateFunction or xCreateTokenizer fails. (check-in: [820de7c995] user: dan branch: trunk, size: 83599)
14:02
[283638d028] part of check-in [58bbcf8b2f] Add a description of the "^" syntax to fts5.in. (check-in: [58bbcf8b2f] user: dan branch: trunk, size: 82871)
2017-08-25
17:22
[b17e2eb026] part of check-in [6c382d50b9] Merge changes from branch-3.20. Updated the makefile so that it works with recent changes to the core SQLite. The makefile now expects the BLD variable to be set to point to the directory in which has been run "./configure; make sqlite3.c" for the core source code. (check-in: [6c382d50b9] user: drh branch: trunk, size: 81915)
2017-08-12
16:44
[896431b68e] part of check-in [2ba9202168] Add a description of new fts5vocab table type "instance" to the the fts5 documentation. (check-in: [2ba9202168] user: dan branch: trunk, size: 81909)
2017-08-11
01:11
[70f3e599c1] part of check-in [2d4dd1d10c] Fix an error in the FTS5 extension mechanism documentation. (check-in: [2d4dd1d10c] user: drh branch: branch-3.20, size: 79785)
2017-07-17
16:00
[165b36a82a] part of check-in [0585b3df1c] Update the FTS5 extension documentation to show the new fts5_api access technique. Update the change log to talk about the backwards incompatible changes in extensions flowing out of sqlite3_bind_pointer(). Update the search extension to use the new FTS5 extensions technique. (check-in: [0585b3df1c] user: drh branch: trunk, size: 79779)
2017-04-13
09:59
[406a32f607] part of check-in [ab263df2e6] Update fts5 docs to reflect support for a user column on the LHS of a MATCH operator. (check-in: [ab263df2e6] user: dan branch: trunk, size: 79575)
2017-04-12
20:00
[011b17d904] part of check-in [27ba2d2d59] Update fts5 documentation to reflect new column filter capability. (check-in: [27ba2d2d59] user: dan branch: trunk, size: 78321)
2016-09-14
18:40
[1ec0cb808e] part of check-in [858d993381] Add and use the "[dateof:3.X.Y]" hyperlink target for automatically inserting release dates into the text. (check-in: [858d993381] user: drh branch: trunk, size: 77778)
2016-08-25
12:18
[3a8460af14] part of check-in [066e5931ce] Add <fancy_format> or <table_of_contents> markup to a few more documents. To ensure that there are enough anchors in the longer documents for the search script to use. (check-in: [066e5931ce] user: dan branch: experimental, size: 77760)
2016-08-09
19:48
[319a18ec29] part of check-in [e79e555f14] Update fts5.html to document negative column filters. (check-in: [e79e555f14] user: dan branch: trunk, size: 77813)
2016-06-04
17:25
[4890be9ffb] part of check-in [627d913e58] Fix an error in fts5.html. (check-in: [627d913e58] user: dan branch: trunk, size: 77366)
2016-03-19
19:33
[e7b844b912] part of check-in [c959b23a38] Fix a minor formatting issue in FTS5 documentation. (check-in: [c959b23a38] user: drh branch: trunk, size: 77272)
2016-03-10
18:52
[bf358389c3] part of check-in [b4fa1baa79] Add extra documentation for fts5 incremental optimize. (check-in: [b4fa1baa79] user: dan branch: trunk, size: 77271)
2016-03-09
20:54
[c16021d291] part of check-in [9ed173645f] Update the fts5 documentation for the 'usermerge' option and 'merge' command. (check-in: [9ed173645f] user: dan branch: trunk, size: 76343)
2016-02-15
15:45
[cff0ba5489] part of check-in [26245406d3] Add a news item for the 3.11.0 release. Fix a typo in the FTS5 documentation. (check-in: [26245406d3] user: drh branch: trunk, size: 73927)
2016-01-15
08:33
[6d0af3f069] part of check-in [3cc1ff72a4] Update fts5.html to node that the unicode61 tokenizer is compatible with the fts3 tokenizer of the same name. (check-in: [3cc1ff72a4] user: dan branch: trunk, size: 73928)
2016-01-13
20:52
[d7f31ce19d] part of check-in [08f6990b8a] Add documentation for the fts5 detail= option. (check-in: [08f6990b8a] user: dan branch: trunk, size: 73829)
2016-01-06
16:09
[1ac4fd746f] part of check-in [a44bb18833] Fix an error regarding operator precedence in fts5.html. (check-in: [a44bb18833] user: dan branch: trunk, size: 70864)
2015-10-27
19:18
[fb19cd3798] part of check-in [8885fffc21] Update documentation to note that fts5 contentless and external content tables do not support REPLACE. (check-in: [8885fffc21] user: dan branch: trunk, size: 70825)
2015-10-19
12:30
[44e8d37b73] part of check-in [004403f6f5] Add documentation for the fts5vocab module to fts5.in. (check-in: [004403f6f5] user: dan branch: trunk, size: 70505)
2015-10-13
16:08
[d2a022ff08] part of check-in [d6de4c860f] Update fts5.in to note that FTS5 is now included in the amalgamation. And that it supports the table-valued function syntax. (check-in: [d6de4c860f] user: dan branch: trunk, size: 66662)
2015-10-12
18:04
[c6fda84b6d] part of check-in [63898e2980] Fix typos. (check-in: [63898e2980] user: drh branch: trunk, size: 64948)
2015-10-09
12:10
[b915b84c3e] part of check-in [1bbbec6248] Fix one more typo in fts5.in. (check-in: [1bbbec6248] user: dan branch: trunk, size: 64947)
12:09
[279ef2ee36] part of check-in [cc68da99a4] Fix typos in fts5.in. (check-in: [cc68da99a4] user: dan branch: trunk, size: 64947)
2015-10-07
16:44
[c10d3e46e8] part of check-in [0b83b3cde9] Update fts5 documentation to allow the subsitute character (codepoint 26) in unquoted query terms. (check-in: [0b83b3cde9] user: dan branch: trunk, size: 64939)
2015-08-20
08:58
[daa84408ff] part of check-in [3c56514778] Fix an error in the previous commit. (check-in: [3c56514778] user: dan branch: trunk, size: 64394)
05:47
[b27b2b1bf1] part of check-in [2ff6a32555] Fix an error in an example in the FTS5 documentation. (check-in: [2ff6a32555] user: dan branch: trunk, size: 64394)
2015-07-16
00:01
[9eca0ea509] part of check-in [79a7fb1e3f] Fix typos. (check-in: [79a7fb1e3f] user: drh branch: trunk, size: 64384)
2015-07-10
17:04
[2a41bebcda] part of check-in [f650ee44b0] Add an "application porting guide" describing the steps required to port fts3/4 applciations to fts5. Fix some other deficiencies in fts5.html. (check-in: [f650ee44b0] user: dan branch: trunk, size: 64385)
2015-07-02
20:03
[8a903e120f] part of check-in [59ff0eaf28] Add "Compiling and Using FTS5" section to fts5.html. (check-in: [59ff0eaf28] user: dan branch: trunk, size: 59976)
17:59
[9cd2ff569c] part of check-in [b7f67421b7] Fix a missing comma in fts5.in. (check-in: [b7f67421b7] user: dan branch: trunk, size: 58638)
2015-06-19
18:57
[6d197144a9] part of check-in [8f8e1e988f] Fix an error in fts5.in. (check-in: [8f8e1e988f] user: dan branch: trunk, size: 58637)
2015-06-10
16:28
[5d6a22647c] part of check-in [22655b73bd] Update the "Differences from FTS3/4" section of fts5.html. (check-in: [22655b73bd] user: dan branch: trunk, size: 58624)
13:01
[969f2e6e9f] part of check-in [e30da64703] Add documentation for the columnsize=0 option to fts5.html. (check-in: [e30da64703] user: dan branch: trunk, size: 56461)
2015-06-02
19:27
[c5e5055444] part of check-in [ec116c4004] Add syntax for multi-column matches to fts5.in. (check-in: [ec116c4004] user: dan branch: trunk, size: 53679)
2015-05-20
18:20
[3bb2b91bc6] part of check-in [d2210cd43b] Update the list of reserved characters in fts5.html. (check-in: [d2210cd43b] user: dan branch: trunk, size: 53313)
2015-05-07
11:32
[4d37da4d0d] part of check-in [73e4989d49] Fix typos. (check-in: [73e4989d49] user: drh branch: trunk, size: 53132)
2015-05-01
19:49
[8e834c33ec] part of check-in [807c985334] Fix an error in the fts5 documentation for the NEAR operator. (check-in: [807c985334] user: dan branch: trunk, size: 53131)
2015-04-27
16:42
[372a01f40d] part of check-in [47550c82de] Update the description of the content= option in fts5.html. (check-in: [47550c82de] user: dan branch: trunk, size: 53119)
2015-04-24
20:09
[30ccbe6df8] part of check-in [0742089777] Update fts5.in with the UNINDEXED option. (check-in: [0742089777] user: dan branch: trunk, size: 52868)
2015-03-07
11:16
[8c6767bbf2] part of check-in [a358d9babf] Improve the documentation of fts5 auxiliary functions. (check-in: [a358d9babf] user: dan branch: trunk, size: 52304)
2015-03-06
19:29
[8192e51de2] part of check-in [984c3483df] Further enhancements to fts5.in. (check-in: [984c3483df] user: dan branch: trunk, size: 49576)
2015-03-05
21:00
[6dae72ec4a] part of check-in [23989471bd] Add a couple of details to fts5.in. (check-in: [23989471bd] user: dan branch: trunk, size: 42937)
01:22
[b66cefb8ff] part of check-in [f61b2a7935] Fix a bug in matrix generation. Relax a restriction on the use of VALUES clauses - a restriction that did not actually apply. Fix a formatting problem in the FTS5 docs. (check-in: [f61b2a7935] user: drh branch: trunk, size: 42250)
2015-03-04
20:19
Added: [817bddf0c6] part of check-in [519916c18a] Add fts5.html. (check-in: [519916c18a] user: dan branch: trunk, size: 42244)