database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-08 14:02:16 +03:00
Code Activity
30,189 Commits 1,570 Branches 184 Tags
column-text-blob-v2
Commit Graph

5153 Commits

Author SHA1 Message Date
dan
719b0f66e5 Fix some problems with transactions that both read and write an fts5 table. 
FossilOrigin-Name: 0e225b15357765f132c3364b222f9931a608a5b2
 2015-01-29 20:59:34 +00:00
dan
88392bf3ce Optimize range constraints on the rowid column of fts3/4 tables even if there is no MATCH clause in the query. 
FossilOrigin-Name: 85dc12625d300fe48f3c096f54ebcb8b6ef4e30a
 2015-01-29 11:52:22 +00:00
drh
120b3a4f61 Merge in all changes from trunk. 
FossilOrigin-Name: 17c69be80542c5f84e21d60df3edc49422b087d9
 2015-01-28 12:00:40 +00:00
mistachkin
e4a0d79b8a Fix harmless compiler warnings. 
FossilOrigin-Name: e7d2ec048c88237c124fbe598f8f7e950d43d90f
 2015-01-27 21:24:33 +00:00
dan
900f1922ac Fix a problem with fts5 doclist-indexes that occured if the first rowid of the first non-term page of a doclist is zero. 
FossilOrigin-Name: f704bc059e06b01f1d68fa7dad89e33eace6c389
 2015-01-27 20:41:00 +00:00
dan
6f0138e89e Fix a bug in the fts3 snippet() function causing it to omit leading separator characters from snippets that begin with the first token in a column. 
FossilOrigin-Name: adc9283dd9bc3a6463f8c4fe23dd58a3712c349d
 2015-01-27 19:01:26 +00:00
dan
18f6ff9eb7 Improve the performance of fts3/4 queries that use the OR operator and at least one auxiliary fts function. 
FossilOrigin-Name: 245e8730451fbdc1c729beff7295c452df604009
 2015-01-27 18:43:02 +00:00
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
4c2871bead Further tests and fixes for fts5. 
FossilOrigin-Name: c020a291ed293a66d21c5885e50a7fee04aa6366
 2015-01-21 20:30:14 +00:00
dan
dd8a501019 Fix an fts5 issue with loading doclist-indexes for a term that is the last thing on its leaf page. 
FossilOrigin-Name: e0d614425f7f5ffe266fdc03642931b1ec19ad25
 2015-01-21 18:23:25 +00:00
dan
b461380333 Add further tests for fts5 backend. 
FossilOrigin-Name: 09dabb3b9e140eec6cfda83bcb86b6b9f5cf54b6
 2015-01-21 16:10:59 +00:00
dan
997d798d92 Merge latest trunk changes with this branch. 
FossilOrigin-Name: b3348b1e07e168b156636a29fc8c6d6afb3129c2
 2015-01-21 06:36:07 +00:00
dan
fd0b436e10 Add extra fault injection tests to fts5. 
FossilOrigin-Name: f45a0dc0a8911c8aac5a1028ac4f543a709656e7
 2015-01-20 20:34:17 +00:00
dan
aa4d380a42 Handle the case where a tokenizer determines that there are zero tokens in an fts5 query term. 
FossilOrigin-Name: 75f3d17f864072dfa2caee182b86cc4b9972d691
 2015-01-19 11:15:36 +00:00
drh
65545b5993 Eliminate all use of sprintf(), strcpy() and strcat() from test logic because 
OpenBSD hates those functions.

FossilOrigin-Name: 10321910990195878c0af1e94b34ae0cdc0cb31b
 2015-01-19 00:35:53 +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
2656167f6e Improve the performance of the fts5 porter tokenizer implementation. 
FossilOrigin-Name: 96ea600440de05ee663e71c3f0d0de2c64108bf9
 2015-01-17 17:48:10 +00:00
drh
7a20f698df Merge trunk 3.8.8 beta changes into the sessions branch 
FossilOrigin-Name: 0ba124540b5b2a9ceda0f4f4a46e6be54edad813
 2015-01-14 17:16:23 +00:00
drh
068a251d99 Simplify some code in rtree, to avoid confusing the optimizer in GCC on 
some macs:
gcc version 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00).
Prior to these changes, compiling with -O3 would cause incorrect code to
be generated.  The change to the nodeGetCell() routine is key.  The other
changes are merely cosmetic details discovered while bug hunting.

FossilOrigin-Name: 882181ff9dd75f32db266db6e476671021fc567b
 2015-01-13 21:26:17 +00:00
dan
851ca6e715 Fix prefix indexes so that they work in characters, not bytes. 
FossilOrigin-Name: af8d43a4a08528bbae25ee38fe25de8a86f8a21c
 2015-01-13 17:25:08 +00:00
mistachkin
7bb22ac7ff Silence some harmless uninitialized local variable warnings. 
FossilOrigin-Name: 44375a34e59d1b0f0d765a99dcc7e6f30a4be7f7
 2015-01-12 19:59:12 +00:00
mistachkin
7bb6e8e169 Get things compiling cleanly with MSVC and W4. 
FossilOrigin-Name: c8725fa5fa361959b0f0a3fb36f204905d6f0ae9
 2015-01-12 18:52:41 +00:00
mistachkin
1a51ce78ba Fix some harmless compiler warnings. 
FossilOrigin-Name: 2b8eecbfe7935d3d9826fbcd473dd3a49138ad11
 2015-01-12 18:38:02 +00:00
dan
73f7d6ed75 Optimize the unicode61 tokenizer so that it handles ascii text faster. Make it the default tokenizer. Change the name of the simple tokenizer to "ascii". 
FossilOrigin-Name: f22dbccad9499624880ddd48df1b07fb42b1ad66
 2015-01-12 17:58:04 +00:00
dan
27277c4e3c Fix some documentation issues in fts5. 
FossilOrigin-Name: 512e1bdb4093b59d1494dfc63391476eadd52aea
 2015-01-10 20:34:27 +00:00
drh
f7af7a17b9 Merge recent enhancements from trunk, including test scripts enhancements and 
the removal of limits on the number of terms in a VALUES clause.

FossilOrigin-Name: 5a2dec55bfadc328b430a5231a037b37831a5530
 2015-01-08 20:06:06 +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
2a28e507f7 Further fixes and test cases related to external content tables. 
FossilOrigin-Name: ce6a899baff7265a60c880098a9a57ea352b5415
 2015-01-06 14:38:34 +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
drh
4081d5da3b Add logic to releasetest.tcl that detects -fsanitize=undefined errors. 
Fix a few false-positivies that come up when running the sanitize=undefined
test.

FossilOrigin-Name: 2835e79a0afec6e4d449ac9340afec068c2d4c11
 2015-01-01 23:02:01 +00:00
dan
37db72f1f7 Merge latest trunk changes with this branch. 
FossilOrigin-Name: 4b3651677e7132c4c45605bc1f216fc08ef31198
 2015-01-01 18:03:49 +00:00
drh
f0a88279bd Fix a harmless compiler warning in rtree. 
FossilOrigin-Name: 30891c6b8ebe9dfc939f9695bb45a159fbaaf262
 2015-01-01 16:47:43 +00:00
dan
6024772ba2 Add a version of the unicode61 tokenizer to fts5. 
FossilOrigin-Name: d09f7800cf14f73ea86d037107ef80295b2c173a
 2015-01-01 16:46:10 +00:00
dan
e716aca24b Move all fts5 test files to new directory "ext/fts5/test". 
FossilOrigin-Name: 7f148edb30103c5f4fee20cd08e38537f9615bf2
 2014-12-29 15:59:36 +00:00
dan
5fa3acabf4 Fixes to built-in tokenizers. 
FossilOrigin-Name: b33fe0dd89f3180c209fa1f9e75d0a7acab12b8e
 2014-12-29 11:24:46 +00:00
dan
2a615fa627 Fix the fts5 bm25() function so that it matches the documentation. 
FossilOrigin-Name: 1ac7a8d0af9a71ddf6a1421033dcb9fa67c6120c
 2014-12-23 19:18:34 +00:00
dan
005e10e39a Fixes and simplifications for the snippet() and highlight() functions. 
FossilOrigin-Name: ca5d44042aa7461dcc8b700b0763df4df9d4a891
 2014-12-22 21:01:52 +00:00
dan
1616d55153 Remove the fts5_test() aux function. Test aux functions using the tcl interface instead. 
FossilOrigin-Name: 67e3ffd950c5347d219a06b33ad51949cffa7d90
 2014-12-19 20:53:51 +00:00
dan
2ae0f4c931 Fix a problem with prefix queries and the AND operator. 
FossilOrigin-Name: 38b3c65e3ee95eb7afadb76e0110570fbbc41e1b
 2014-12-18 20:01:15 +00:00
dan
e4bec37900 Fix various problems in fts5 revealed by fault-injection tests. 
FossilOrigin-Name: e358c3de5c916f2c851ab9324ceaae4e4e7a0fbd
 2014-12-18 18:25:48 +00:00
dan
0a99e9fb01 Update this branch with latest trunk changes. 
FossilOrigin-Name: 69a312ad3fe5b39bc394b9ce958cb63d734518c7
 2014-12-08 07:50:31 +00:00
dan
fdf3a8970d Update comments in sqlite3ota.h to remove the "must have PRIMARY KEY" restriction. 
FossilOrigin-Name: 088a41eb8c18886a260cf53fa0cca3bd1958dc05
 2014-12-08 07:28:26 +00:00
dan
61826cdb6c Extra tests for the ota_rowid column. 
FossilOrigin-Name: 46069393b3141ab198f0fcc4f6c05229f06bf1e8
 2014-12-08 07:22:34 +00:00