database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-07-23 11:22:09 +03:00
Code Activity
30,154 Commits 1,566 Branches 181 Tags
empty-table-optimizations
Commit Graph

187 Commits

Author SHA1 Message Date
dan
8ac3025419 Have fts5 store rowids in ascending order. Query speed is virtually the same regardless of rowid order, and ascending order makes some insert optimizations easier. 
FossilOrigin-Name: 5206ca6005bfa9dfc7346d4b89430c9748d32c10
 2015-01-24 19:57:03 +00:00
dan
641cb4360a Fix compression of keys stored on internal segment b-tree nodes by fts5. 
FossilOrigin-Name: 51444f67c0cc58a3023eb1cd78e7cf889da6c80f
 2015-01-23 17:43:21 +00:00
dan
626d9e3062 Remove some redundant code from fts5. 
FossilOrigin-Name: 939b7a5de25e064bdf08e03864c35ab718da6f6f
 2015-01-23 06:50:33 +00:00
dan
0b520cc5f9 Add further tests and fixes for fts5. 
FossilOrigin-Name: 5b295897153e9b26cd0d2e7ea112a4d461d0a665
 2015-01-22 19:13:08 +00:00
dan
d8736bc3b8 Ensure an up to date copy of the fts5 configuration has been loaded into memory before attempting to modify the same configuration. 
FossilOrigin-Name: f30afd209aa4ce42766b1493750c4f5b5f1e9502
 2015-01-17 20:01:52 +00:00
dan
d6b1c880d2 Add the fts5 'optimize' command. 
FossilOrigin-Name: e749be563d8e738af113bd301770e2f22763ab77
 2015-01-07 19:33:11 +00:00
dan
96a32bb51c Add the 'rebuild' and 'delete-all' commands. 
FossilOrigin-Name: 0cb2fed525778d96237b5b0943047665e1f636d1
 2015-01-07 17:11:11 +00:00
dan
aacf3d1a3b Remove the iPos parameter from the tokenizer callback. Fix the "tokenchars" and "separators" options on the simple tokenizer. 
FossilOrigin-Name: 65f0262fb82dbfd9f80233ac7c3108e2f2716c0a
 2015-01-06 19:08:26 +00:00
dan
ded4f41d1a Tests and fixes for fts5 external content tables. 
FossilOrigin-Name: 047aaf830d1e72f0fdad3832a0b617e769d66468
 2015-01-05 20:41:39 +00:00
dan
0fbc269fef Add support for external content tables to fts5. 
FossilOrigin-Name: 17ef5b59f789e9fa35c4f053246d819987fd06f8
 2015-01-03 20:44:58 +00:00
dan
ade921c3ad Allow the rank column to be remapped on a per-query basis by including a term similar to "rank match 'bm25(10,2)'" in a where clause. 
FossilOrigin-Name: 1cd15a1759004d5d321056905dbb6acff20dc7d9
 2015-01-02 14:55:22 +00:00
dan
5fa3acabf4 Fixes to built-in tokenizers. 
FossilOrigin-Name: b33fe0dd89f3180c209fa1f9e75d0a7acab12b8e
 2014-12-29 11:24:46 +00:00
dan
845d0ab323 Begin testing fts5 OOM and IO error handling. 
FossilOrigin-Name: 2037dba62fdd995ad15b642abe499a790f5ffe5c
 2014-12-03 17:27:35 +00:00
dan
615a9ae5db Add a configuration option to remap the "rank" column to an auxiliary fts5 function. 
FossilOrigin-Name: b5f5971283b9b2f60c16f9675099855af95012cd
 2014-12-02 20:18:11 +00:00
dan
89a89560d6 Add code to parse a rank() function specification. And a tcl interface to add auxiliary functions to fts5. 
FossilOrigin-Name: 9c1697a2aa1f601e6eb11704abe63a73c8105447
 2014-12-01 20:05:00 +00:00
dan
ca7fad3d2c Add a cookie mechanism to ensure that the %_config table is re-read as required. 
FossilOrigin-Name: bb4a37b53de60da9ec8b9317eec14afa99690828
 2014-11-28 20:01:13 +00:00
dan
cb11e73fc2 Add a %_config table to fts5. 
FossilOrigin-Name: 83491c56661ca78f96020ba68184bb3fb19e674f
 2014-11-27 20:03:45 +00:00
dan
cb62aae034 Add the auxiliary highlight() function to fts5. 
FossilOrigin-Name: 059092379f981eb919b500ce447006f9e645fc5a
 2014-11-24 16:24:33 +00:00
dan
48d7014067 Fix the customization interfaces so that they match the documentation. 
FossilOrigin-Name: fba0b5fc7eead07a4853e78e02d788e7c714f6cd
 2014-11-15 20:07:31 +00:00
dan
6885bbc713 Add an "automerge=0" mode that disables auto-merging and falls back to fts4-style crisis merges. 
FossilOrigin-Name: 2397404e152b908d838e6491294b263b05943b3f
 2014-08-18 19:30:01 +00:00
dan
0bbd9c27c2 Cache the value of the "totals" record in memory during transactions. 
FossilOrigin-Name: 05dfdad445b22f375b71abe0b1fa1bf7ca331be7
 2014-08-12 16:07:35 +00:00
dan
c7fe7a969b Replace the hash table borrowed from fts3. 
FossilOrigin-Name: 617e2fac1c128212254f71b1a8fddaf0d1d90262
 2014-08-11 19:44:52 +00:00
dan
7b71fbaf93 Add support for savepoints to fts5. 
FossilOrigin-Name: 3b19eba042bb2eeb1be60f8d58ebaa0a045d6a5c
 2014-08-06 16:30:21 +00:00
dan
9af0705e84 Start changing things to use doclist indexes as required. code is not activated yet. 
FossilOrigin-Name: b8864da95db2c0e611116304d607e35a86c9247d
 2014-08-02 20:49:36 +00:00
dan
fdb4a30af2 Add hidden column "rank". Currently this always returns the same value as the bm25() function. 
FossilOrigin-Name: 4cc048c3651e830a6aeded924c7f3a60b634e133
 2014-07-30 19:41:58 +00:00
dan
700b33d7a5 Add extension apis xRowCount, xQueryPhrase, xSetAuxdata and xGetAuxdata. And a ranking function that uses all of the above. 
FossilOrigin-Name: c4d50428ab97f77e6721c4f8d03eaaf3ea91f3eb
 2014-07-25 20:30:47 +00:00
dan
84d6fb394f Fix the xColumnSize() extension API. 
FossilOrigin-Name: 19504c4108472d2ad1281221642b8bd06eb69f4e
 2014-07-21 11:44:47 +00:00
dan
e1c77bcfcd Add simple tests for the xColumnText() extension api. 
FossilOrigin-Name: 1e9053abdaf5e128d44504ee00dfd909dc25f378
 2014-07-19 20:27:54 +00:00
dan
4a165c0af4 Fixes for the xColumnSize() fts5 extension API. 
FossilOrigin-Name: 43fcb844726cfeeb1c8a0dbfaa0d2ca22e6ac16c
 2014-07-19 15:35:09 +00:00
dan
30b650e2f4 Fix issues with position lists and NEAR constraints. 
FossilOrigin-Name: 16352d3654d5672cd0251db51dbe19f779373feb
 2014-07-18 19:59:00 +00:00
dan
9cfd51f587 Begin adding interface for auxiliary functions. 
FossilOrigin-Name: 1e2a7ba0889093416455f488fca893eaeb195d45
 2014-07-16 19:15:57 +00:00
dan
a2b569f955 Add support for prefix queries to fts5. 
FossilOrigin-Name: 75ebd3cd5904a4f89f7f3a9b25d32b2a42a31310
 2014-07-08 16:27:37 +00:00
dan
1dfacb4675 Add support for phrase queries to fts5. 
FossilOrigin-Name: 2e5652e6526b8fb3f5c163168d95bc0bb4c93686
 2014-07-02 20:18:49 +00:00
dan
acf6642819 Change the position list format so that its size in bytes is stored at the start of the list itself. 
FossilOrigin-Name: 62f2ff20418702ed0fbf708369edf5638445b51b
 2014-07-01 20:45:18 +00:00
dan
22d43ec4e8 Begin adding query support to fts5. 
FossilOrigin-Name: 47a9f3cc92deefe163108e3507bd4614bf1f5da7
 2014-06-25 20:28:38 +00:00
dan
d0bfb36a08 Add simple full-table-scan and rowid lookup support to fts5. 
FossilOrigin-Name: 3515da85d09220c464979467b476c611da4a6a7a
 2014-06-24 16:59:06 +00:00
dan
e0fa4107c2 Add some code for an experimental fts5 module. Does not work yet. 
FossilOrigin-Name: 1e0648dcf283d4f1f6159db4d2433b6cc635992e
 2014-06-23 11:33:22 +00:00