database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
32,669 Commits 1,785 Branches 392 Tags
static-sql
Commit Graph

6146 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
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
dan
7ca1d07aff Allow the ota extension to write to tables with no PRIMARY KEY declaration. 
FossilOrigin-Name: ba59a7e2ba97244492cbca9247456df0f3f19248
 2014-12-06 19:30:41 +00:00
drh
c0d33d20f7 Import from trunk the fix the "test" target on the autoconf and MSVC makefiles 
and some minor compiler warning fixes.

FossilOrigin-Name: c9f20eb2fbba0868df85ebb98877f9bb969be8a4
 2014-12-05 00:41:17 +00:00
drh
2c3abeb8c3 Fix compiler warnings. 
FossilOrigin-Name: e9955c0e14d13ba1411f013acb4979958dae2516
 2014-12-05 00:32:09 +00:00
drh
34794c3d0c Incorporate the SQLITE_CHECKPOINT_TRUNCATE enhancement and a couple of 
obscure bug fixes from trunk.

FossilOrigin-Name: 34ffa3b3c002b0e87d8382ad76e87dbaec0b2bc6
 2014-12-04 23:35:08 +00:00
drh
063970a15f Fix comment typos reported on the mailing list. No changes to code. 
FossilOrigin-Name: 93a71c9f058b58d11187293a1e8d5324d0911880
 2014-12-04 14:01:39 +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