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,201 Commits 1,570 Branches 184 Tags
wasm-build-parallel
Commit Graph

5163 Commits

Author SHA1 Message Date
dan
06c9722564 Fix the error messages returned by ota if an update violates a unique constraint. 
FossilOrigin-Name: c4845a3b591723ff60b7b1da198f44908c12bdfc
 2015-02-04 19:20:42 +00:00
dan
738a3b2fcb Avoid a linear scan of the entire table when ota updates or deletes a row from a table with an external primary key index. 
FossilOrigin-Name: 1db198ccca1e5c5a922cefe3daeff8d2e5d3a7f7
 2015-02-04 16:32:47 +00:00
dan
1e35850229 Fix a memory leak that could follow an OOM error in ota. 
FossilOrigin-Name: 0d5415f26427d0af89663c5a3e944e488143b648
 2015-02-04 11:08:47 +00:00
dan
e2863b6074 Fix some problems surrounding WITHOUT ROWID tables with DESC primary key indexes 
.

FossilOrigin-Name: a21fefb79a161e6bb057ae4f6ba554f659706ac1
 2015-02-03 18:43:42 +00:00
dan
75fda9b395 Remove "PRAGMA ota_mode". 
FossilOrigin-Name: 1c111447a07687c30ed4ad5a6c27a169c85b7ea6
 2015-02-03 15:56:08 +00:00
dan
57fec54b53 Fix some problems with building fts5 and fts3 together using the amalgamation. 
FossilOrigin-Name: fb10bbb9f9c4481e6043d323a3018a4ec68eb0ff
 2015-02-02 11:32:20 +00:00
dan
32348f7bd2 Merge latest trunk changes with this branch. 
FossilOrigin-Name: 76212f2c9a3c3ff0e238d6dad776938c6af674e6
 2015-02-02 09:40:36 +00:00
dan
3b660d7da3 Have ota use imposter tables to write to indexes instead of the sqlite3_index_writer() interface. The error handling in this version is broken in a few small ways. 
FossilOrigin-Name: cdaeab467f6aa3217be161377a9b78a4eec37093
 2015-01-31 20:42:04 +00:00
dan
5082140311 Minor optimizations to fts5 writes. 
FossilOrigin-Name: 1fffe51fa92f1784365140d5b163ab6c690981ae
 2015-01-31 15:23:44 +00:00
drh
3102aa01fd Merge all recent trunk changes, and especially the SQLITE_TESTCTRL_INITMODE 
enhancement.

FossilOrigin-Name: 36436dde74ce2536a9a430b4458216499ad113bf
 2015-01-30 16:36:17 +00:00
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