Documentation Source Text

All files named "pages/fts3.in"
Login

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

History for pages/fts3.in

2020-04-06
18:59
[9bab4c7067] 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: 144298)
2020-01-29
23:04
[077c35d796] part of check-in [4d11f30804] Enhancements to the FTS3/4 documentation about the limitations of BOMs in string literals with the simple tokenizer in a UTF16 database. (check-in: [4d11f30804] user: drh branch: trunk, size: 144296)
20:19
[77a33421b1] part of check-in [7e55864b0a] Document the byte-order-mark limitation of fts3/4. (check-in: [7e55864b0a] user: dan branch: trunk, size: 143787)
2019-04-02
01:06
[bc313ce269] part of check-in [30e7de5540] Update the fts3_tokenizer() documentation to describe how it now wants parameters to be bound. (check-in: [30e7de5540] user: drh branch: trunk, size: 142371)
2019-02-11
13:21
[a5d6f236e4] part of check-in [34f973966a] Add documentation for the fts3/4/5 remove_diacritic options. (check-in: [34f973966a] user: dan branch: trunk, size: 142774)
2018-11-12
15:24
[1ea1c5a6fd] part of check-in [7b6b7a791b] Enhancements to the documentation regarding security and shadow tables. (check-in: [7b6b7a791b] user: drh branch: trunk, size: 142042)
2018-07-02
08:00
[134696837f] part of check-in [ea0f0b4c4a] Add a sentence to the FTS3/4 documentation to make it clear that only columns that are part of the FTS3/4 table declaration exist, even if an external content table with more columns is in use. (check-in: [ea0f0b4c4a] user: dan branch: trunk, size: 142058)
2018-06-08
13:21
[af9deacb24] part of check-in [59e5f9e3da] Use https for all internal hyperlinks. (check-in: [59e5f9e3da] user: drh branch: branch-3.24-https, size: 141864)
2017-10-06
20:00
[683671c28e] part of check-in [47132abeb4] Fix minor problems in fts3.html. (check-in: [47132abeb4] user: dan branch: trunk, size: 141863)
17:54
[e896a4a28d] part of check-in [a95efd5bb8] Improve the error handling in the example rank function in fts3.html. (check-in: [a95efd5bb8] user: dan branch: trunk, size: 141858)
2017-01-29
11:39
[a07dda6ac8] part of check-in [c90c7a1015] Fix an obsolete example in the FTS3 documentation. (check-in: [c90c7a1015] user: drh branch: trunk, size: 141063)
2016-11-25
21:47
[39c12f03b9] part of check-in [71a72a66ff] Fix typo in the FTS3/4 documentation. (check-in: [71a72a66ff] user: drh branch: trunk, size: 141062)
2016-09-14
18:40
[d50f8075aa] 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: 141063)
2016-08-25
17:29
[b049283d13] part of check-in [c7628dcb37] Change the way sub-sections are selected by the search script. (check-in: [c7628dcb37] user: dan branch: experimental, size: 140939)
2016-08-10
12:01
[87c7c3578d] part of check-in [58a14bf9e1] Fix typo in FTS3 docs. (check-in: [58a14bf9e1] user: drh branch: trunk, size: 140927)
2016-07-28
16:04
[1ad61aa51b] part of check-in [d2cba16a38] Fix a typo in a snippet() example in the FTS3 documentation. (check-in: [d2cba16a38] user: drh branch: trunk, size: 140921)
2016-03-22
17:23
[d57f469894] part of check-in [ad0172e592] Merge fixes off of the 3.11 branch. (check-in: [ad0172e592] user: drh branch: trunk, size: 140919)
2016-03-21
20:02
[0fc647fcec] part of check-in [37a01760c6] Fix the description of the case folding performed by the unicode61 tokenizer in FTS3. (check-in: [37a01760c6] user: drh branch: branch-3.11, size: 140815)
2016-02-26
15:54
[7186df65e8] part of check-in [1483127f32] Updated documentation related to fts3_tokenizer() and the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER. (check-in: [1483127f32] user: drh branch: trunk, size: 140917)
2016-02-09
14:43
[cda72d764e] part of check-in [0dc9452382] Update the 3.11.0 change log. (check-in: [0dc9452382] user: drh branch: trunk, size: 140813)
2016-02-08
19:55
[864d859077] part of check-in [27ee6d0233] Update fts3 documentation to mention that fts3_tokenzer(x,y) is only available if SQLITE_ENABLE_FTS3_TOKENIZER is defined at compile time. (check-in: [27ee6d0233] user: dan branch: trunk, size: 140558)
2015-12-30
15:10
[b16ddadefa] part of check-in [4648330f75] Fix a problem in an SQL example in fts3.html. (check-in: [4648330f75] user: dan branch: trunk, size: 140115)
2015-10-10
09:36
[d33f12d854] part of check-in [e68ac068e8] Add a new example for external-content tables to fts3.html. (check-in: [e68ac068e8] user: dan branch: trunk, size: 140118)
2015-09-02
11:30
[bb9df9f0b1] part of check-in [d366268bab] Add missing parenthesis to an expression in fts3.html. (check-in: [d366268bab] user: dan branch: trunk, size: 139062)
2015-08-01
18:13
[2175e32626] part of check-in [95c97dad08] Update rbu.in with more details on using RBU with FTS tables and the sqldiff tool. (check-in: [95c97dad08] user: dan branch: trunk, size: 139058)
2015-06-17
16:05
[2c09533166] part of check-in [d0b390051e] Further tweaks to the matchinfo() documentation. (check-in: [d0b390051e] user: drh branch: trunk, size: 138986)
15:59
[91658c267b] part of check-in [dcccfa67e1] Update the change log. Better fragments for matchinfo() flags. (check-in: [dcccfa67e1] user: drh branch: trunk, size: 139019)
2015-05-11
19:12
[1198f0846e] part of check-in [2dad241898] Update fts3.html with a description of the matchinfo 'b' option. (check-in: [2dad241898] user: dan branch: trunk, size: 138889)
2015-05-07
11:32
[acafd318ea] part of check-in [73e4989d49] Fix typos. (check-in: [73e4989d49] user: drh branch: trunk, size: 137317)
2015-05-05
19:59
[2ead832db1] part of check-in [9dff844fd9] Fix a typo in the documentation for fts3 matchinfo option 'y'. (check-in: [9dff844fd9] user: dan branch: trunk, size: 137318)
2015-05-04
12:16
[e36f15af26] part of check-in [0cd02758ec] Add the matchinfo(..,'y') option addition to the change log. (check-in: [0cd02758ec] user: drh branch: trunk, size: 137328)
2015-05-02
09:40
[fee1d3a662] part of check-in [e6b9763fab] Update fts3 documentation with docs for the matchinfo 'y' flag. (check-in: [e6b9763fab] user: dan branch: trunk, size: 137296)
2014-08-14
13:06
[e9b4598acd] part of check-in [09088d9a21] Fix typos. (check-in: [09088d9a21] user: drh branch: trunk, size: 135544)
2014-07-07
13:13
[f73deeab4c] part of check-in [a8e5cf50a0] Clarification of the automerge documentation in FTS3. (check-in: [a8e5cf50a0] user: drh branch: trunk, size: 135544)
10:39
[c1cf272ffb] part of check-in [6a74a13c86] Add documentation for the "^" qualifier to fts3.html. (check-in: [6a74a13c86] user: dan branch: trunk, size: 135505)
2014-06-27
20:49
[7e18b7b3d9] part of check-in [0a22af73df] Clarifications to the FTS4 languageid documentation. (check-in: [0a22af73df] user: drh branch: trunk, size: 134898)
2014-05-27
10:31
[d032299aab] part of check-in [84efe9e646] Fix documentation typos reported on the mailing list. (check-in: [84efe9e646] user: drh branch: trunk, size: 134747)
2014-05-16
11:28
[3ea2465811] part of check-in [ae994ce63a] Update fts3.html for recent changes to FTS. (check-in: [ae994ce63a] user: dan branch: trunk, size: 134819)
2014-01-29
17:47
[4749bd347b] part of check-in [ea6e1d11de] Update News and the change log. Bring the release date forward to 2014-02-03. Fix typos. Move older news entries out to oldnews.in. (check-in: [ea6e1d11de] user: drh branch: trunk, size: 132998)
2013-10-16
23:58
[813afa7279] part of check-in [df95e4e1ec] Fix typos in documentation. (check-in: [df95e4e1ec] user: drh branch: trunk, size: 132997)
2013-10-15
19:08
[020c503ea4] part of check-in [cd0e9d17ed] Added the fts4aux languageid column. Fix typos in famous.html (check-in: [cd0e9d17ed] user: drh branch: trunk, size: 132998)
2013-09-18
11:31
[9b29c9d8f3] part of check-in [23c364befb] Add examples of creating fts3tokenize tables that use tokenizers declared with multiple arguments to fts3.in. (check-in: [23c364befb] user: dan branch: trunk, size: 132443)
2013-09-13
14:52
[f4ff1b8046] part of check-in [00c7833d65] Add documentation for the fts4 unicode61 "tokenchars" and "separators" options. (check-in: [00c7833d65] user: dan branch: trunk, size: 131803)
2013-08-31
14:32
[8ea77ec102] part of check-in [f5d1d7106f] Add documentation for the fts4 unicode61 tokenizer option "remove_diacritics=0". (check-in: [f5d1d7106f] user: dan branch: trunk, size: 129566)
2013-07-12
20:03
[98ece71c67] part of check-in [2eb277d7fc] Add the isolation.in document. Other changes for 3.8.0. (check-in: [2eb277d7fc] user: drh branch: trunk, size: 128866)
2013-07-01
20:52
[b29c59fd19] part of check-in [6743aed594] Fix a typo in an example in the fts4aux virtual table documentation. (check-in: [6743aed594] user: drh branch: trunk, size: 128776)
2013-06-21
19:06
[bc69ab5c71] part of check-in [968222aa1c] Add documentation for the fts4 notindexed option. (check-in: [968222aa1c] user: dan branch: trunk, size: 128776)
2013-04-26
14:47
[dea32d4de1] part of check-in [aee1b746ba] Fix typos and add clarification in the fts3tokenize documentation. (check-in: [aee1b746ba] user: drh branch: trunk, size: 127439)
14:38
[5a73a5fe9f] part of check-in [a6e655aa62] Add documentation for the fts3tokenize table. (check-in: [a6e655aa62] user: drh branch: trunk, size: 127142)
2013-04-25
11:35
[a7303adeea] part of check-in [35441559aa] Update the FTS3 documentation to make it clearer that external content tables must be in the same database as the FTS virtual table. (check-in: [35441559aa] user: drh branch: trunk, size: 125268)
2013-04-19
14:32
[fa44cc6375] part of check-in [2966921d57] Replace some instances of < and > in the text of fts3.html with < and >. (check-in: [2966921d57] user: dan branch: trunk, size: 124934)
2013-04-15
13:16
[e8d00a624a] part of check-in [ba14e1152f] Update the FTS4 document to describe the two-argument form of fts4aux. (check-in: [ba14e1152f] user: drh branch: trunk, size: 124910)
2012-12-11
19:11
[4866c4cc62] part of check-in [5d8312cd94] Documentation typos fixed. (check-in: [5d8312cd94] user: drh branch: trunk, size: 124288)
2012-08-22
22:50
[b730c5466d] part of check-in [851c7d53b7] Improved names for triggers in the FTS documentation. (check-in: [851c7d53b7] user: drh branch: trunk, size: 124293)
2012-05-28
17:05
[40b26c21ab] part of check-in [2ed85cc08c] Documentation on the unicode61 tokenizer and the ability to use shared-cache with in-memory databases. (check-in: [2ed85cc08c] user: drh branch: trunk, size: 124293)
2012-05-15
16:46
[d83a4496da] part of check-in [89c68b1e44] Fix typos in FTS3 documentation. (check-in: [89c68b1e44] user: drh branch: trunk, size: 123788)
2012-04-02
15:00
[459c44e7d6] part of check-in [f1d54965d0] Enforce the 80-character line limit on the new documentation source text for FTS4 commands. (check-in: [f1d54965d0] user: drh branch: trunk, size: 123781)
14:47
[de91dc8c9b] part of check-in [2c33993bdc] Updates to the FTS4 document to describe recent merge=X,Y, automerge=B, and integrity-check commands. Updates to the change log for the same and for other recent changes. (check-in: [2c33993bdc] user: drh branch: trunk, size: 123568)
2012-03-06
13:11
[852a60ee89] part of check-in [39b1d19256] Tweaks to the FTS4 documentation. Add Bentley to the sponsor list on the front page. (check-in: [39b1d19256] user: drh branch: trunk, size: 116308)
2012-03-05
19:40
[45d5d7f32b] part of check-in [eb26f05574] Fix typos in the FTS4 languageid option documentation. Add entries to the 3.7.11 change log. (check-in: [eb26f05574] user: drh branch: trunk, size: 116305)
19:14
[39c29217ac] part of check-in [16b58c9eb4] Documentation for the content= and langaugeid= options for FTS4. (check-in: [16b58c9eb4] user: drh branch: trunk, size: 116305)
2012-02-27
07:06
[cfce6d2753] part of check-in [73a0dac584] Fix a bug in the description of the 'simple' FTS tokenizer. Underscores (codepoint 95) are divider characters not token characters. (check-in: [73a0dac584] user: dan branch: trunk, size: 105211)
2012-02-05
05:19
[32b3945f78] part of check-in [4a7f0dacc7] Fix an error in the FTS matchinfo documentation. (check-in: [4a7f0dacc7] user: dan branch: trunk, size: 105231)
2012-01-09
13:40
[e9b18521b8] part of check-in [8fadbd41ce] Add a note about data types and the compress/uncompress functions to the FTS documentation. (check-in: [8fadbd41ce] user: dan branch: trunk, size: 105231)
2011-06-20
21:48
[785c26b723] part of check-in [b503d1f516] Documentation typos. (check-in: [b503d1f516] user: drh branch: trunk, size: 104656)
19:49
[a89233647d] part of check-in [be9ae0b604] Updates in preparation for the 3.7.7 release. (check-in: [be9ae0b604] user: drh branch: trunk, size: 104663)
2011-06-14
19:38
[005ee39344] part of check-in [074255f9eb] Update fts3.html with the new "order" and "prefix" options. (check-in: [074255f9eb] user: dan branch: trunk, size: 104496)
2011-04-13
18:37
[7efc438f82] part of check-in [0a742ee49a] Update documentation for the 3.7.6.1 patch release. Fix a typos in the FTS4 documentation. (check-in: [0a742ee49a] user: drh branch: trunk, size: 101687)
2011-04-05
14:31
[dcf3469244] part of check-in [4fb953fec0] Updates to the ANALYZE and FTS4 documentation to describe the latest changes. Updates to the changes.html file as we move closer to the 3.7.6 release. Added amalgamation32k to the download.html page. (check-in: [4fb953fec0] user: drh branch: trunk, size: 101699)
2011-03-16
07:03
[6feb93a720] part of check-in [c605c75c11] Fix a typo in fts3.in. (check-in: [c605c75c11] user: dan branch: trunk, size: 101633)
2011-03-07
13:40
[07d09c0293] part of check-in [b3c69199b5] Fix typos in Appendix A of fts3.html. (check-in: [b3c69199b5] user: dan branch: trunk, size: 101632)
2011-02-05
17:00
[a06879118c] part of check-in [8e18201f14] Update the description of fts4aux in fts3.in to account for recent changes. (check-in: [8e18201f14] user: dan branch: trunk, size: 101628)
2011-02-03
19:06
[b640978beb] part of check-in [ead2cc60ef] Update fts3.html to describe the fts4aux module and the fts4 compress/uncompress options. (check-in: [ead2cc60ef] user: dan branch: trunk, size: 100058)
2010-12-29
04:52
[1f7f5abd31] part of check-in [d3fc079ba8] Fix the order of the LIMIT and OFFSET clauses in some examples on fts3.html (LIMIT comes before OFFSET). (check-in: [d3fc079ba8] user: dan branch: trunk, size: 93984)
2010-11-27
15:55
[da39893139] part of check-in [5ab479563e] Add some extra details to fts3.in. (check-in: [5ab479563e] user: dan branch: trunk, size: 93984)
11:46
[4802103463] part of check-in [bead827e51] Fix typos in fts3.in. (check-in: [bead827e51] user: dan branch: trunk, size: 89934)
2010-11-26
21:06
[c9e02e71a0] part of check-in [b8865a0011] Updates to the FTS3 documentation to include additional discussion and links to FTS4 concepts. (check-in: [b8865a0011] user: drh branch: trunk, size: 90006)
18:23
[dd27e3373b] part of check-in [4deb70dd76] Update documentation for fts3 matchinfo function. (check-in: [4deb70dd76] user: dan branch: trunk, size: 87694)
2010-11-15
13:15
[8e57b2c8ae] part of check-in [c547f4b6c1] Fix a typo from the fts3.html document. (check-in: [c547f4b6c1] user: drh branch: trunk, size: 84562)
2010-09-02
04:20
[ec341b6af8] part of check-in [db66d3a1d4] More typo fixes. (check-in: [db66d3a1d4] user: shaneh branch: trunk, size: 84566)
2010-09-01
11:49
[c6c2750001] part of check-in [ddcf89bab0] New hyperlinks to FTS and RTree. New requirement that automatically generated rowids must be positive. (check-in: [ddcf89bab0] user: drh branch: trunk, size: 84573)
2010-08-31
16:49
[e695cdc553] part of check-in [8873618014] Fix typo in fts3.html pointed out on the mailing list. (check-in: [8873618014] user: dan branch: trunk, size: 84554)
2010-08-30
15:10
[4d1039a7fc] part of check-in [d7a2085524] More typo and spelling fixes. (check-in: [d7a2085524] user: shaneh branch: trunk, size: 84554)
2010-08-09
15:45
[b6b3c02cbf] part of check-in [d9e242f92a] Fix a bunch of documentation typos reported on the mailing list. (check-in: [d9e242f92a] user: drh branch: trunk, size: 84550)
2010-06-08
14:21
[731ffcfa2b] part of check-in [1bbbb8afd0] Fix problem in fts3.html - snippet() takes between 1 and 6 arguments, not between 1 and 4. (check-in: [1bbbb8afd0] user: dan branch: trunk, size: 84542)
2010-02-09
23:25
[4a5960d3e9] part of check-in [58746651dd] Add an evidence mark to a statement in fts3.in. Add an evidence mark to a statement in fts3.in. (check-in: [58746651dd] user: dan branch: trunk, size: 84543)
2010-02-01
16:18
[d62dad43b5] part of check-in [f0a07e571f] Fix a typo in the FTS3 documentation. (check-in: [f0a07e571f] user: drh branch: trunk, size: 84542)
2010-01-20
18:32
[8e3e263fba] part of check-in [e3ae335670] Change the way the fts3.html document is generated to be more similar to most of the other documents. (check-in: [e3ae335670] user: dan branch: trunk, size: 84541)
05:52
[fd6dbd5656] part of check-in [897b36953b] Fix typo in fts3.html. (check-in: [897b36953b] user: dan branch: trunk, size: 83771)
2010-01-18
14:12
[818449fad3] part of check-in [0917dec067] Add a section to fts3.in to explain how to use the matchinfo() function efficiently. (check-in: [0917dec067] user: dan branch: trunk, size: 83771)
2010-01-14
11:43
[8a53f90dce] part of check-in [ceff4c1d37] Fix an error in the matchinfo example in fts3.html. (check-in: [ceff4c1d37] user: dan branch: trunk, size: 71100)
2010-01-13
18:09
[29e8c621cc] part of check-in [c31f4ab8b8] Add a description of matchinfo() and update the description of snippet() in fts3.html. (check-in: [c31f4ab8b8] user: dan branch: trunk, size: 71100)
2010-01-09
07:34
[27d0a9625b] part of check-in [d8f53c98a9] Fix a couple of snippet related examples in fts3.html. (check-in: [d8f53c98a9] user: dan branch: trunk, size: 62960)
2009-12-11
14:46
[a562892db5] part of check-in [f6c99b3cc3] Change fts3.html to present the new INSERT syntax used to optimize the full-text index. (check-in: [f6c99b3cc3] user: dan branch: trunk, size: 62933)
2009-12-05
19:07
[24ae2a096b] part of check-in [a92e1357cb] Fix a minor typo in fts3.html. (check-in: [a92e1357cb] user: dan branch: trunk, size: 62981)
2009-12-04
07:50
[371ef6a555] part of check-in [39d5f660c5] Clarify that the values stored in the rowid of an FTS3 table do not change when the database is VACUUMed. (check-in: [39d5f660c5] user: dan branch: trunk, size: 62981)
2009-12-03
18:14
[43c7713f72] part of check-in [c922c8ef50] Change 3.6.21 release date. Fix typos reported by internet reviewers. (check-in: [c922c8ef50] user: drh branch: trunk, size: 62871)
2009-12-01
15:30
[0068b01b80] part of check-in [d075300786] Fix two more typos in examples in fts3.in. (check-in: [d075300786] user: dan branch: trunk, size: 62893)
14:27
[bc9cbe4ede] part of check-in [9bd28d637b] Fix a couple of bugs in the examples in fts3.in. (check-in: [9bd28d637b] user: dan branch: trunk, size: 62894)
2009-11-30
15:37
[bc1b874775] part of check-in [daf96c0053] Clarify authorship of the original FTS3 code in fts3.html. (check-in: [daf96c0053] user: dan branch: trunk, size: 62911)
15:27
[251ff90f94] part of check-in [54090fd49f] Update indicative performance numbers for populating a large database in fts3.html. (check-in: [54090fd49f] user: dan branch: trunk, size: 62890)
11:52
[af9e9dfd21] part of check-in [0b949f6763] Fix some problems with fts3.html. (check-in: [0b949f6763] user: dan branch: trunk, size: 62975)
08:41
[2ed30110a1] part of check-in [d91a4c7249] Add text to fts3.html describing the snippet and offsets functions. (check-in: [d91a4c7249] user: dan branch: trunk, size: 60222)
2009-11-28
19:17
[ed32c844d9] part of check-in [f1940858bf] Add a description of tokenizers to fts3.in. (check-in: [f1940858bf] user: dan branch: trunk, size: 52518)
2009-11-27
17:03
[7c99a73275] part of check-in [6a28d79533] Change things so that fts3.html and foreignkeys.html do not use an external stylesheet. (check-in: [6a28d79533] user: dan branch: trunk, size: 44252)
2009-11-26
18:43
[1999c8ed8a] part of check-in [3031615e43] Expand on the description of fts3 query syntax in fts3.in. (check-in: [3031615e43] user: dan branch: trunk, size: 44112)
2009-11-25
18:44
[a1304595ea] part of check-in [6f60a71678] Describe fts3 query syntax. (check-in: [6f60a71678] user: dan branch: trunk, size: 37231)
2009-11-24
18:45
[e42ea2fb49] part of check-in [8d529e9fc1] Add some text to fts3.html. (check-in: [8d529e9fc1] user: dan branch: trunk, size: 30799)
2009-11-23
13:57
[4bda585fb7] part of check-in [442afaf708] Begin making changes in preparation for 3.6.21. (check-in: [442afaf708] user: drh branch: trunk, size: 16318)
03:59
[dec0ccb040] part of check-in [cf42334a68] Add instructions for building an FTS3-enabled SQLite to fts3.html. (check-in: [cf42334a68] user: dan branch: trunk, size: 16314)
2009-11-17
19:06
[d0c4a758d5] part of check-in [146d003fc9] Improvements to the description of data structures in fts3.html. (check-in: [146d003fc9] user: dan branch: trunk, size: 14921)
2009-11-15
03:59
Added: [22d0d0d323] part of check-in [8c18d00b27] Add start of html fts3 documentation. This is very much a work in progress. (check-in: [8c18d00b27] user: dan branch: trunk, size: 9377)