Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for ext/fts5/fts5_main.c
|
2025-06-28
| ||
| 14:30 | [52e6b6fda9] part of check-in [a6f6fbe617] Merge the latest trunk fixes and enhancements into the bedrock branch. (check-in: [a6f6fbe617] user: drh branch: bedrock, size: 119675) | |
|
2025-06-23
| ||
| 19:38 | [e558225168] part of check-in [48044a6b57] Improve some of the error messages emitted by fts5 when it encounters corruption. (check-in: [48044a6b57] user: dan branch: trunk, size: 119628) | |
|
2025-03-15
| ||
| 20:32 | [db236e7e9a] part of check-in [b1860b6372] Merge the latest trunk enhancements into the bedrock branch via the wal2 intermediary. (check-in: [b1860b6372] user: drh branch: bedrock, size: 119615) | |
| 00:11 | [57933c18ef] part of check-in [28ac776a23] Convert the Fts5Sorter.aIdx field to a flexible array. (check-in: [28ac776a23] user: drh branch: flex-array, size: 119568) | |
|
2025-03-03
| ||
| 16:01 | [931e59db9c] part of check-in [2033763007] Merge the latest trunk enhancements into the bedrock branch through the wal2 intermediary. (check-in: [2033763007] user: drh branch: bedrock, size: 119502) | |
|
2025-02-18
| ||
| 15:11 | [b0e95a793f] part of check-in [15dc524fd4] Have SQLITE_FTS5_ENABLE_TEST_MI builds avoid reading the database schema from within sqlite3_open(). (check-in: [15dc524fd4] user: dan branch: trunk, size: 119455) | |
|
2025-01-14
| ||
| 12:28 | [47e7a63a93] part of check-in [fab341c829] Version 3.48.0 for the bedrock branch (check-in: [fab341c829] user: drh branch: bedrock, size: 119484) | |
|
2025-01-09
| ||
| 14:10 | [9a1daef724] part of check-in [c359e555ce] When removing an fts5 in secure-delete mode, defer setting the table version to SECUREDELETE until flushing data to disk. This prevents problems that can occur if there is a rollback or statement rollback operation. (check-in: [c359e555ce] user: dan branch: trunk, size: 119437) | |
|
2025-01-08
| ||
| 20:43 | [9ba1871ee9] part of check-in [6da37893f5] Fix another assert() failure in fts5. (check-in: [6da37893f5] user: dan branch: trunk, size: 119925) | |
|
2024-12-07
| ||
| 23:29 | [ed7923e06d] part of check-in [08cfa7e8b3] Merge the latest trunk fixes and enhancements into the bedrock branch. (check-in: [08cfa7e8b3] user: drh branch: bedrock, size: 119921) | |
| 17:08 | [72527efa1d] part of check-in [f5b8fd7763] Fix more harmless compiler warnings. (check-in: [f5b8fd7763] user: drh branch: trunk, size: 119874) | |
|
2024-11-26
| ||
| 20:46 | [a4f6a46e5e] part of check-in [41b79bde4a] Update fts5 so that the xInstToken() extension API works with prefix queries. (check-in: [41b79bde4a] user: dan branch: trunk, size: 119860) | |
|
2024-11-18
| ||
| 15:34 | [2920988c74] part of check-in [59a7eb297c] Merge the latest trunk changes into the bedrock branch. (check-in: [59a7eb297c] user: drh branch: bedrock, size: 119041) | |
|
2024-11-12
| ||
| 13:37 | [0b60324001] part of check-in [a4e976a030] Ensure that the sqlite3_index_info.idxStr string coming back from FTS5 is always zero-terminated, even if the xBestIndex call fails with an SQLITE_CONSTRAINT error. (check-in: [a4e976a030] user: drh branch: trunk, size: 118994) | |
|
2024-11-02
| ||
| 19:10 | [b2ec6bf97f] part of check-in [46929ae92b] Allow an fts5 table or query to be configured to collect xInstToken data for any prefix terms as part of the first parse of the main index, if any. (check-in: [46929ae92b] user: dan branch: fts5-tokendata-prefix, size: 119831) | |
|
2024-10-16
| ||
| 15:09 | [673d2dafc7] part of check-in [d5289de411] Merge the latest trunk enhancements into the bedrock branch. (check-in: [d5289de411] user: drh branch: bedrock, size: 119012) | |
|
2024-09-30
| ||
| 17:57 | [2f78042381] part of check-in [fd6ff55141] Merge the latest trunk enhancements, via the wal2 branch, into the bedrock branch. (check-in: [fd6ff55141] user: dan branch: bedrock, size: 116289) | |
|
2024-09-27
| ||
| 19:10 | [50eb059e51] part of check-in [d69abca821] Fix a problem with UPDATE statements that modify the rowid of contentless_delete=1 tables. (check-in: [d69abca821] user: dan branch: fts5-contentless-unindexed, size: 118965) | |
| 18:32 | [4e4a23b76b] part of check-in [b6b1db8d34] Fix a problem with UPDATEs that do not modify all UNINDEXED columns of a contentless_delete=1, contentless_unindexed=1 table. (check-in: [b6b1db8d34] user: dan branch: fts5-contentless-unindexed, size: 118964) | |
| 10:57 | [853d44c804] part of check-in [cd36d66c88] Allow UPDATEs of unindexed columns in fts5 contentless_unindexed=1 tables. Testing to come. (check-in: [cd36d66c88] user: dan branch: fts5-contentless-unindexed, size: 117869) | |
|
2024-09-25
| ||
| 12:03 | [0d2013bd03] part of check-in [21539e9d0d] Prevent regular DELETE and UPDATE statements from running against contentless_unindexed=1 tables that are not also contentless_delete=1. (check-in: [21539e9d0d] user: dan branch: fts5-contentless-unindexed, size: 116585) | |
|
2024-09-13
| ||
| 15:37 | [be195e918c] part of check-in [d2f0d19936] Merge latest trunk changes, including the changes to the fts5 locale=1 feature, into this branch. (check-in: [d2f0d19936] user: dan branch: fts5-contentless-unindexed, size: 116340) | |
|
2024-09-10
| ||
| 20:32 | [4503498d34] part of check-in [198305de92] Alternative implementation of fts5 locale=1 feature that allows blobs to be stored in indexed columns of fts5 locale=1 tables. (check-in: [198305de92] user: dan branch: trunk, size: 116242) | |
| 18:38 | [774a4e6edd] part of check-in [7d87a27a01] Remove a stray "breakpoint" from a test script. (check-in: [7d87a27a01] user: dan branch: fts5-locale-alternate, size: 116199) | |
| 16:19 | [68b8fd96b0] part of check-in [55c5c119a0] Alternative implementation of fts5 locale=1 feature that allows blobs to be stored in indexed columns of fts5 locale=1 tables. (check-in: [55c5c119a0] user: dan branch: fts5-locale-alternate, size: 114976) | |
|
2024-09-09
| ||
| 19:12 | [9124eba418] part of check-in [d8103684f6] Fix an OOM-handling problem affecting locale=1 fts5 tables. (check-in: [d8103684f6] user: dan branch: trunk, size: 119920) | |
| 15:12 | [c75bf34528] part of check-in [aa75e701de] Fix harmless compiler warnings in FTS5. (check-in: [aa75e701de] user: drh branch: trunk, size: 119444) | |
|
2024-09-07
| ||
| 16:22 | [c9c5fcce73] part of check-in [70e42f941c] Fix a problem with fts5 locale=1 tables and UPDATE statements that may affect more than one row. (check-in: [70e42f941c] user: dan branch: trunk, size: 119434) | |
|
2024-09-03
| ||
| 18:55 | [402a65b6d9] part of check-in [dcacb1a8ef] Store the values of any UNINDEXED columns of a contentless fts5 table persistently in the database. Warning: This currently creates a (technically) incompatible file-format for contentless fts5 tables that have UNINDEXED columns. (check-in: [dcacb1a8ef] user: dan branch: fts5-contentless-unindexed, size: 118773) | |
|
2024-08-29
| ||
| 23:43 | [43990841e0] part of check-in [ff94464cec] Merge the latest trunk enhancement into the bedrock branch through the wal2 intermediary. (check-in: [ff94464cec] user: drh branch: bedrock, size: 118765) | |
|
2024-08-28
| ||
| 15:54 | [1fddb53f49] part of check-in [df55502e4f] Fix a dropped error code in fts5. (check-in: [df55502e4f] user: dan branch: trunk, size: 118718) | |
|
2024-08-27
| ||
| 20:37 | [bd41fc8175] part of check-in [6a6ce343b2] Avoid reading the structure record from within the fts5 xConnect method. (check-in: [6a6ce343b2] user: dan branch: trunk, size: 118687) | |
| 19:27 | [0dbe241c50] part of check-in [7c0001d6eb] Modify the implementation of "wrapper" tokenizers to make them more robust in the case where the database connection is closed before the tokenizers are deleted. (check-in: [7c0001d6eb] user: dan branch: trunk, size: 118709) | |
|
2024-08-24
| ||
| 20:05 | [3d8b778f65] part of check-in [df65d00f10] Fix harmless compiler warnings in fts5V2toV1Tokenize(). (check-in: [df65d00f10] user: drh branch: trunk, size: 118621) | |
|
2024-08-18
| ||
| 14:46 | [5ea7ab0c99] part of check-in [4b8070816a] Fix a problem with detail=none, content='' tables. (check-in: [4b8070816a] user: dan branch: fts5-locale, size: 118587) | |
|
2024-08-16
| ||
| 19:04 | [3bef3f3d59] part of check-in [d0591db3bb] Merge all the latest trunk enhancements, and especially the order-by-subquery optimization, into the bedrock branch, via wal2. (check-in: [d0591db3bb] user: drh branch: bedrock, size: 96349) | |
|
2024-08-15
| ||
| 20:33 | [2302922902] part of check-in [fb257540d3] Extra tests. (check-in: [fb257540d3] user: dan branch: fts5-locale, size: 118435) | |
| 18:50 | [21160a392a] part of check-in [d27985245a] Further tests and fixes for this branch. (check-in: [d27985245a] user: dan branch: fts5-locale, size: 118418) | |
|
2024-08-13
| ||
| 21:15 | [f8eae223ce] part of check-in [00792e807f] More tests for the new code on this branch. (check-in: [00792e807f] user: dan branch: fts5-locale, size: 118527) | |
| 15:04 | [42860180de] part of check-in [def5243a7b] Add tests and fix minor issues with the code on this branch. (check-in: [def5243a7b] user: dan branch: fts5-locale, size: 118498) | |
|
2024-08-12
| ||
| 18:39 | [93468b6f48] part of check-in [1a7a9bd3f6] Add extra documentation comments to fts5_main.c. (check-in: [1a7a9bd3f6] user: dan branch: fts5-locale, size: 118569) | |
| 17:28 | [b3194ee180] part of check-in [bf116dec6f] Fix problem with some fts5 aux function APIs with (locale=, detail=none/column) tables. (check-in: [bf116dec6f] user: dan branch: fts5-locale, size: 117425) | |
| 17:03 | [4fe8349b81] part of check-in [e626123580] Fix further issues to do with fts5 locale support. (check-in: [e626123580] user: dan branch: fts5-locale, size: 117178) | |
| 11:13 | [cd61abbfd0] part of check-in [f7d56a1f21] Update the auxiliary function API to include xTokenize_x2() instead of xSetLocale(). (check-in: [f7d56a1f21] user: dan branch: fts5-locale, size: 114835) | |
|
2024-08-10
| ||
| 20:16 | [18b7415999] part of check-in [cfb334dc53] Merge all the latest branch-3.46 changes into the bedrock-3.46 branch via the wal2-3.46 intermediary. (check-in: [cfb334dc53] user: drh branch: bedrock-3.46, size: 95467) | |
| 20:03 | [d6afe9ddaa] part of check-in [b243007525] Merge trunk changes into this branch. (check-in: [b243007525] user: dan branch: fts5-locale, size: 115101) | |
| 19:57 | [6ec7a7d005] part of check-in [d4014c87ba] Prevent the fts5 xPhraseNext() or xPhraseFirst() APIs from returning an out-of-range column number, even if the database is corrupt. (check-in: [d4014c87ba] user: dan branch: trunk, size: 96302) | |
| 18:59 | [6248ba625b] part of check-in [03e63ed24e] Update the fts5_tokenizer_v2 API so that the locale is passed as parameter to xTokenize(), instead of via a separate call to xSetLocale(). (check-in: [03e63ed24e] user: dan branch: fts5-locale, size: 114851) | |
| 11:02 | [0a8fc88585] part of check-in [6047b18ee3] Cherrypick various minor fixes from trunk into branch-3.46. (check-in: [6047b18ee3] user: drh branch: branch-3.46, size: 95420) | |
|
2024-08-02
| ||
| 21:06 | [79b1d6099d] part of check-in [c98ccc1216] Change things so that locale=1 is required to write fts5_locale() values to an fts5 table, and so that blobs may not be stored in indexed (i.e. not UNINDEXED) columns of these tables. (check-in: [c98ccc1216] user: dan branch: fts5-locale, size: 111137) | |
|
2024-08-01
| ||
| 00:47 | [c4c3971bdc] part of check-in [c1f616ce80] Merge the latest trunk enhancements into the bedrock branch. (check-in: [c1f616ce80] user: drh branch: bedrock, size: 96099) | |
|
2024-07-31
| ||
| 20:49 | [bda8d42102] part of check-in [8bd4ae7e95] Fix various problems with the code on this branch. (check-in: [8bd4ae7e95] user: dan branch: fts5-locale, size: 112747) | |
|
2024-07-30
| ||
| 20:39 | [d9a3fef868] part of check-in [ae435aff17] Fix cases surrounding blob values being stored in locale=1 fts5 tables. (check-in: [ae435aff17] user: dan branch: fts5-locale, size: 107104) | |
|
2024-07-29
| ||
| 20:31 | [ee4bba42d8] part of check-in [14006711d8] Fix xColumnText() and xColumnSize() APIs. Add xColumnLocale() and xTokenizeSetLocale(). (check-in: [14006711d8] user: dan branch: fts5-locale, size: 105842) | |
| 15:00 | [71ea9fe3ab] part of check-in [4e3e529313] Fix a couple of asan problems on this branch. (check-in: [4e3e529313] user: dan branch: fts5-locale, size: 103402) | |
|
2024-07-27
| ||
| 19:46 | [f08525b337] part of check-in [69205264de] Ensure that an fts5 UPDATE does not strip the locale from columns that it does not write to. (check-in: [69205264de] user: dan branch: fts5-locale, size: 103354) | |
|
2024-07-26
| ||
| 20:50 | [5b6f85aae5] part of check-in [8839ef7cfb] Add the fts5_locale() function, and begin adding the related functionality to fts5. (check-in: [8839ef7cfb] user: dan branch: fts5-locale, size: 102772) | |
|
2024-07-08
| ||
| 16:01 | [77fefb37e7] part of check-in [9b1afd4acb] Improve the error message returned when fts5 finds a row is missing from its content table. (check-in: [9b1afd4acb] user: dan branch: trunk, size: 96052) | |
|
2024-06-24
| ||
| 16:08 | [1d8bd88240] part of check-in [56d265f956] Fix some problems with calling fts5 api functions from within non-full-text queries. (check-in: [56d265f956] user: dan branch: trunk, size: 95711) | |
|
2024-06-05
| ||
| 16:50 | [981551daf6] part of check-in [0a7fa0a434] Fix an fts5 problem with secure-delete mode causing integrity-check to erroneously report a corrupt index. (check-in: [0a7fa0a434] user: drh branch: branch-3.46, size: 95258) | |
| 14:47 | [21ddeb331a] part of check-in [80bef4d60b] Fix an fts5 problem with secure-delete mode causing integrity-check to erroneously report a corrupt index. (check-in: [80bef4d60b] user: dan branch: trunk, size: 95689) | |
|
2024-06-01
| ||
| 17:56 | [b1538b3918] part of check-in [7c47094537] Have fts5.xBestIndex return SQLITE_CONSTRAINT, instead of a large cost, when no usable plan can be found. (check-in: [7c47094537] user: dan branch: xbestindex-or-terms, size: 95660) | |
|
2024-05-28
| ||
| 10:57 | [ac3aaf0c88] part of check-in [c7aaa28f78] Fix a problem with the error message reported by fts5 in some OOM cases. (check-in: [c7aaa28f78] user: dan branch: trunk, size: 95742) | |
|
2024-05-24
| ||
| 21:38 | [6b39f263b1] part of check-in [e78b778304] Fix another fts5 problem related to unknown tokenizer modules. (check-in: [e78b778304] user: dan branch: trunk, size: 95705) | |
| 21:23 | [c44064d5f6] part of check-in [061d7b69e6] Fix a crash in fts5 that could occur within "PRAGMA integrity_check" if the specified tokenizer was unknown. (check-in: [061d7b69e6] user: dan branch: trunk, size: 95693) | |
|
2024-05-14
| ||
| 17:16 | [dc6938b723] part of check-in [ca4fdcb8ae] Have fts5 tables delay initializing the tokenizer until it is first used in all cases where the tokenizer is not "trigram". (check-in: [ca4fdcb8ae] user: dan branch: fts5-delay-tokenizer, size: 95580) | |
|
2024-05-13
| ||
| 20:06 | [942fea921d] part of check-in [69ef47eeee] Allow existing fts5 tables to be dropped even if the associated tokenizer is not available. (check-in: [69ef47eeee] user: dan branch: fts5-delay-tokenizer, size: 95728) | |
|
2024-04-17
| ||
| 19:48 | [86b2c80771] part of check-in [6a640ea4d8] Prevent tokenize-blobs from being used with non-contentless tables. Fix some other issues with the new code on this branch. (check-in: [6a640ea4d8] user: dan branch: fts5-tokenize-blob, size: 97235) | |
|
2024-04-16
| ||
| 14:23 | [b2dfe719a0] part of check-in [c2f9d1259c] Add some tests for the fts5 tokenize-blob functionality on this branch. (check-in: [c2f9d1259c] user: dan branch: fts5-tokenize-blob, size: 97162) | |
|
2024-04-15
| ||
| 20:24 | [49111d5d88] part of check-in [6c51c9c6a8] Add experimental way to specify an alternative tokenizer when writing to or querying an fts5 table. (check-in: [6c51c9c6a8] user: dan branch: fts5-tokenize-blob, size: 97111) | |
|
2024-03-20
| ||
| 12:19 | [a08a7d0799] part of check-in [a1a5c427c2] Back port various minor patches (check-in: [a1a5c427c2] user: drh branch: branch-3.44, size: 93681) | |
|
2024-03-13
| ||
| 18:00 | [b275b2810a] part of check-in [5c8e80f435] Merge the latest trunk enhancements into the bedrock branch. (check-in: [5c8e80f435] user: drh branch: bedrock, size: 95276) | |
|
2024-02-01
| ||
| 15:42 | [d68bd9533d] part of check-in [d18d9a05c2] Ensure the fts5 xIntegrity method correctly returns error codes unrelated to corruption or missing SQL elements. (check-in: [d18d9a05c2] user: dan branch: trunk, size: 95229) | |
|
2024-01-30
| ||
| 16:56 | [4d93fd6b5b] part of check-in [5955853a86] Merge the 3.45.1 patch release changes into the bedrock branch. (check-in: [5955853a86] user: drh branch: bedrock-3.45, size: 95236) | |
|
2024-01-16
| ||
| 16:05 | [cd56ed9619] part of check-in [b855886c4c] Ensure that the xIntegrity methods of fts3 and fts5 work on read-only databases. (check-in: [b855886c4c] user: dan branch: trunk, size: 95189) | |
|
2024-01-13
| ||
| 20:36 | [67ee70a2ab] part of check-in [c39f658522] Merge latest wal2 changes into this branch. (check-in: [c39f658522] user: dan branch: bedrock, size: 95475) | |
|
2024-01-11
| ||
| 14:03 | [94a03dd431] part of check-in [ccf552319a] In fts5, flush the contents of the in-memory hash table whenever the secure-delete option is toggled. This prevents spurious corruption reports under some circumstances. (check-in: [ccf552319a] user: dan branch: trunk, size: 95428) | |
|
2024-01-04
| ||
| 16:28 | [a508be9e9b] part of check-in [707f79c70c] Merge the latest trunk enhancements into the bedrock branch. (check-in: [707f79c70c] user: drh branch: bedrock, size: 95399) | |
|
2024-01-02
| ||
| 21:08 | [1c6c7df07f] part of check-in [55c61f6a8d] Fix a problem in fts5 caused by a COMMIT involving fts5 data that immediately follows a ROLLBACK TO that does not. (check-in: [55c61f6a8d] user: dan branch: trunk, size: 95352) | |
|
2023-12-28
| ||
| 14:01 | [78c1a7eda0] part of check-in [5a17b972ed] Merge the latest trunk changes into the bedrock branch. (check-in: [5a17b972ed] user: drh branch: bedrock, size: 95397) | |
|
2023-12-26
| ||
| 15:52 | [93e5bc8676] part of check-in [1a8a9b1c89] Ensure that the xColumnText(), xQueryPhrase() and xPhraseFirstColumn() APIs all return SQLITE_RANGE if they are passed a bad column or phrase number. (check-in: [1a8a9b1c89] user: dan branch: trunk, size: 95350) | |
|
2023-12-11
| ||
| 13:48 | [ae75805a7a] part of check-in [67da596d82] Different fix for the fts5 COMMIT-following-OOM problem first fixed by [fba3129d]. This one does not cause problems if an fts5 table is renamed and then dropped within the same transaction. (check-in: [67da596d82] user: dan branch: branch-3.44, size: 93603) | |
|
2023-12-07
| ||
| 14:41 | [b908696c52] part of check-in [d8c6b24694] Different fix for the fts5 COMMIT-following-OOM problem first fixed by [fba3129d]. This one does not cause problems if an fts5 table is renamed and then dropped within the same transaction. (check-in: [d8c6b24694] user: dan branch: trunk, size: 95046) | |
|
2023-12-06
| ||
| 21:18 | [61d0c97916] part of check-in [c2e53000f4] Merge the latest trunk changes into the bedrock branch. (check-in: [c2e53000f4] user: drh branch: bedrock, size: 95517) | |
|
2023-12-04
| ||
| 18:45 | [fb7ec495d6] part of check-in [78fbb71598] Fixes for xInstToken() with tokendata=0 tables. And with prefix queries. (check-in: [78fbb71598] user: dan branch: fts5-token-data, size: 95470) | |
| 17:45 | [1fbadf63a7] part of check-in [317a50563d] Fix a problem with the xInstCount() API and "ORDER BY rank" queries. (check-in: [317a50563d] user: dan branch: fts5-token-data, size: 95471) | |
|
2023-12-02
| ||
| 17:32 | [0759953021] part of check-in [7bda09ab40] Ensure that tokendata=1 queries avoid loading large doclists for queries like "common AND uncommon", just as tokendata=0 queries do. (check-in: [7bda09ab40] user: dan branch: fts5-token-data, size: 95421) | |
|
2023-12-01
| ||
| 20:09 | [20596de592] part of check-in [c523f40895] Different approach to querying a tokendata=1 table. Saves cpu and memory. (check-in: [c523f40895] user: dan branch: fts5-token-data, size: 94989) | |
|
2023-11-22
| ||
| 21:15 | [55b53085db] part of check-in [9be8969edd] Add documentation for new fts5 auxiliary function APIs. (check-in: [9be8969edd] user: dan branch: fts5-token-data, size: 94847) | |
|
2023-11-15
| ||
| 11:45 | [f151eb2c6d] part of check-in [a34b26fe7f] Add implementation of xInstToken() API. (check-in: [a34b26fe7f] user: dan branch: fts5-token-data, size: 95069) | |
|
2023-11-13
| ||
| 14:29 | [ddac85dbd2] part of check-in [828566392b] Add new fts5 API xQueryToken(). (check-in: [828566392b] user: dan branch: fts5-token-data, size: 94302) | |
|
2023-10-30
| ||
| 22:57 | [ceffea70ce] part of check-in [956b03a462] Merge the latest 3.44.0 release candidate patches into the bedrock branch. (check-in: [956b03a462] user: drh branch: bedrock, size: 94074) | |
|
2023-10-25
| ||
| 10:37 | [a07ed863b8] part of check-in [bc8afa3f15] Enhance the new xIntegrity method of the sqlite3_module object with new parameters that provide the name of the table being checked and a flag to indicate a "quick_check". Based on feedback in forum post 965c0d02ea. (check-in: [bc8afa3f15] user: drh branch: trunk, size: 94027) | |
|
2023-10-23
| ||
| 16:08 | [068894667a] part of check-in [c9c9bc097a] Merge latest changes from wal2 into this branch. (check-in: [c9c9bc097a] user: dan branch: bedrock, size: 93766) | |
| 13:46 | [0a0ddd6c6d] part of check-in [df69abc082] Improved error messages for the xIntegrity method in FTS3/4 and FTS5. (check-in: [df69abc082] user: drh branch: trunk, size: 93719) | |
|
2023-10-21
| ||
| 18:12 | [1ce6c8f446] part of check-in [7f41d7006d] Fix a problem allowing a COMMIT following an OOM to cause fts3/4 corruption. (check-in: [7f41d7006d] user: dan branch: trunk, size: 93443) | |
|
2023-10-20
| ||
| 19:59 | [e345282be4] part of check-in [fba3129d13] Fix a problem allowing a COMMIT following an OOM to cause fts5 corruption. (check-in: [fba3129d13] user: dan branch: trunk, size: 93668) | |
|
2023-10-13
| ||
| 15:59 | [95b479e4cc] part of check-in [18be505c62] Fix an fts5 problem caused by a 'rebuild' followed by a DELETE in secure-delete mode. (check-in: [18be505c62] user: dan branch: trunk, size: 92672) | |
|
2023-10-12
| ||
| 18:46 | [1ea6636a1f] part of check-in [f34c533b6c] Enable SQLITE_VTAB_INNOCUOUS for FTS3, FTS5, and RTREE. (check-in: [f34c533b6c] user: drh branch: trunk, size: 92478) | |
|
2023-09-16
| ||
| 17:11 | [799ec88d23] part of check-in [c362bde4f4] Enable "OR IGNORE" support via SQLITE_VTAB_CONSTRAINT_SUPPORT for internal-content (not contentless or external-content) fts5 tables. (check-in: [c362bde4f4] user: dan branch: trunk, size: 92394) | |
|
2023-09-13
| ||
| 11:24 | [2249d21bb3] part of check-in [2170312c8d] Replace an if() condition in fts5 that is always true with an assert(). (check-in: [2170312c8d] user: dan branch: trunk, size: 92202) | |
|
2023-09-12
| ||
| 23:11 | [8a16865b16] part of check-in [dfc42411e6] Fix a use-after-free error in fts5 that could occur when querying the "rank" column immediately after another connection changes its definition. (check-in: [dfc42411e6] user: drh branch: branch-3.43, size: 91405) | |
| 18:36 | [48dbb08b1f] part of check-in [cb54c2da52] Fix a use-after-free error in fts5 that could occur when querying the "rank" column immediately after another connection changes its definition. forum post a2dd636330. (check-in: [cb54c2da52] user: dan branch: trunk, size: 92206) | |
|
2023-09-06
| ||
| 14:00 | [5a0ba13131] part of check-in [f1d4024a8c] Change the xIntegrity virtual table method signature so that it returns an integer error code and writes the error message into a parameter. (check-in: [f1d4024a8c] user: drh branch: vtab-integrity-check, size: 92082) | |
| 12:52 | [a216991603] part of check-in [17bede8cde] Add the xIntegrity method to the sqlite3_module object. Implement this method in RTREE, FTS3/4, and FTS5 so that "PRAGMA integrity_check" also verifies the correctness of shadow tables associated with those virtual tables. (check-in: [17bede8cde] user: drh branch: vtab-integrity-check, size: 92044) | |
|
2023-08-11
| ||
| 11:46 | [4df36d3e7e] part of check-in [859932ebce] Merge all the latest trunk enhancements into the bedrock branch. (check-in: [859932ebce] user: drh branch: bedrock, size: 91328) | |
|
2023-08-07
| ||
| 16:15 | [7070031993] part of check-in [16cd2161e3] Changes so that sqlite3_vtab_nochange() works with "UPDATE ... FROM...". Use this to allow UPDATE on a contentless fts5 table if new values are supplied for all indexed columns. (check-in: [16cd2161e3] user: dan branch: fts5-contentless-delete, size: 91281) | |
|
2023-07-28
| ||
| 18:52 | [08a60103dd] part of check-in [1d6ded3234] Merge the latest trunk enhancements into the bedrock branch. (check-in: [1d6ded3234] user: drh branch: bedrock, size: 91060) | |
|
2023-07-22
| ||
| 19:47 | [2f87ee44fd] part of check-in [85c1589ab1] Integrate contentless delete with auto-merge. (check-in: [85c1589ab1] user: dan branch: fts5-contentless-delete, size: 91013) | |
|
2023-07-17
| ||
| 17:59 | [ede405f0f1] part of check-in [cc694b8340] Do not allow the 'delete' command to be used on contentless_delete=1 fts5 tables. (check-in: [cc694b8340] user: dan branch: fts5-contentless-delete, size: 91044) | |
|
2023-07-11
| ||
| 20:57 | [c036530bbd] part of check-in [2f553a660e] Have contentless_delete=1 tables support REPLACE statements. (check-in: [2f553a660e] user: dan branch: fts5-contentless-delete, size: 90837) | |
| 20:19 | [843a622339] part of check-in [fffb861690] Have contentless_delete=1 tables support regular DELETE statements, instead of just the special INSERT syntax. (check-in: [fffb861690] user: dan branch: fts5-contentless-delete, size: 90806) | |
|
2023-07-10
| ||
| 20:44 | [0f4d21152f] part of check-in [e513bea84d] Begin adding support for deleting rows from contentless fts5 tables. (check-in: [e513bea84d] user: dan branch: fts5-contentless-delete, size: 90624) | |
|
2023-05-04
| ||
| 14:41 | [b49be6efe6] part of check-in [b2e0800b24] Merge latest wal2 changes into this branch. (check-in: [b2e0800b24] user: dan branch: bedrock, size: 90674) | |
|
2023-04-12
| ||
| 17:40 | [b4dba04a36] part of check-in [4240fd09b7] Add the 'secure-delete' option to fts5. Used to configure fts5 to aggressively remove old full-text-index entries belonging to deleted or updated rows. (check-in: [4240fd09b7] user: dan branch: fts5-secure-delete, size: 90627) | |
|
2023-02-02
| ||
| 14:27 | [fa213e1b89] part of check-in [5a22010c35] Merge latest enhancments into this branch from branch wal2. (check-in: [5a22010c35] user: dan branch: begin-concurrent-pnu-wal2, size: 90067) | |
|
2023-01-20
| ||
| 13:34 | [fe67b6fb2e] part of check-in [edcb83fa0d] The json_group_array(), json_group_object(), and fts5_source_id() functions should all be deterministic and innocuous. (check-in: [edcb83fa0d] user: drh branch: trunk, size: 90020) | |
|
2022-12-27
| ||
| 13:52 | [2bf44b9efd] part of check-in [ff5a9b054f] Fix a broken assert() in fts5. (check-in: [ff5a9b054f] user: dan branch: trunk, size: 89961) | |
|
2022-12-21
| ||
| 20:43 | [c571172b4c] part of check-in [bcab19d21b] Merge the latest trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: [bcab19d21b] user: drh branch: begin-concurrent-pnu-wal2, size: 89986) | |
|
2022-12-19
| ||
| 20:14 | [3fd46be6a7] part of check-in [569018170b] Fix a faulty assert() in fts5. (check-in: [569018170b] user: dan branch: trunk, size: 89939) | |
| 14:06 | [726c5ef6d1] part of check-in [7fe158aa80] Fix an assert() in fts5. Simplify memdb xLock/xUnlock some. (check-in: [7fe158aa80] user: dan branch: trunk, size: 89939) | |
|
2022-07-22
| ||
| 20:24 | [9db1c09e69] part of check-in [57beb700c0] Add experimental 'xShadowName2' method for virtual table modules. (check-in: [57beb700c0] user: mistachkin branch: xShadowName2, size: 90091) | |
|
2022-05-09
| ||
| 14:22 | [82687a852c] part of check-in [093b60846c] Ensure that fts5 closes the read-only blob handle used to read the fts index at the end of each xUpdate operation. This doesn't matter for stock SQLite, as the handle will be closed in the subsequent xRollback or xSync call, but prevents "BEGIN CONCURRENT" transactions from being committed on this branch. (check-in: [093b60846c] user: dan branch: begin-concurrent-pnu-wal2, size: 89967) | |
|
2022-03-11
| ||
| 12:02 | [6078ae86d3] part of check-in [5e95df261c] Fix a case in fts5 where a corrupt database could cause a crash. (check-in: [5e95df261c] user: dan branch: trunk, size: 89920) | |
|
2021-10-05
| ||
| 13:00 | [7c6092a53e] part of check-in [0d853df1b1] Small change to FTS5 to help static analyzers understand that it is not dereferencing a NULL pointer. (check-in: [0d853df1b1] user: drh branch: trunk, size: 89896) | |
|
2021-07-05
| ||
| 19:01 | [3c9d42bef0] part of check-in [c49a6ed78a] Do not allow writes to an fts5 table if there are any open fts5vocab cursors. (check-in: [c49a6ed78a] user: dan branch: trunk, size: 90450) | |
|
2021-05-22
| ||
| 11:00 | [35ebbcae68] part of check-in [57087ab2f2] The fix in the previous check-in was only correct if the OOM occurs on the initial allocation. This changes should make it correct for a resize as well. (check-in: [57087ab2f2] user: drh branch: trunk, size: 89865) | |
| 01:30 | [ff58907c51] part of check-in [4ae5e5b5ec] If an FTS5 Cursor fails to enlarge the space for the aInst array, set the size of the aInst array to zero. dbsqlfuzz 294254b8105cca409f27a711f1eb2e9e63cbcac5. (check-in: [4ae5e5b5ec] user: drh branch: trunk, size: 89857) | |
|
2021-03-29
| ||
| 20:04 | [f497ca97cb] part of check-in [004559544e] Add "#ifdef SQLITE_DEBUG" blocks around test variables sqlite3_fts5_may_be_corrupt and sqlite3_fts3_may_be_corrupt. (check-in: [004559544e] user: dan branch: trunk, size: 89815) | |
|
2021-03-10
| ||
| 19:32 | [d77648a52b] part of check-in [4cb00b9d40] Fix further sanitizer complaints in the fts5 code. (check-in: [4cb00b9d40] user: dan branch: trunk, size: 89788) | |
|
2020-10-05
| ||
| 16:41 | [b4e4931c7f] part of check-in [64782463be] Allow fts5 trigram tables created with detail=column or detail=none to optimize LIKE and GLOB queries. Allow case-insensitive tables to optimize GLOB as well as LIKE. (check-in: [64782463be] user: dan branch: trunk, size: 89627) | |
|
2020-10-03
| ||
| 17:06 | [8b99e0ba99] part of check-in [6e72a08de7] Fix a segfault caused by running "column LIKE NULL" against an fts5 table using the trigram tokenizer. Fix for [e33ee62575fc22]. (check-in: [6e72a08de7] user: dan branch: trunk, size: 89111) | |
|
2020-09-30
| ||
| 20:35 | [65c5d579ca] part of check-in [0d7810c1ae] Add experimental unicode-aware trigram tokenizer to fts5. And support for LIKE and GLOB optimizations for fts5 tables that use said tokenizer. (check-in: [0d7810c1ae] user: dan branch: fts5-trigram, size: 89078) | |
|
2020-09-21
| ||
| 14:53 | [30969e4e14] part of check-in [782163693f] In fts5 integrity checks, do not compare the contents of the index against an external content table unless specifically requested. (check-in: [782163693f] user: dan branch: trunk, size: 88044) | |
|
2020-07-29
| ||
| 16:18 | [3bffd3ce65] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 87999) | |
|
2019-12-26
| ||
| 14:36 | [e881a2ea0b] part of check-in [a5d7f5d24a] Fix an assert() in fts5 that could fail if an xSavepoint() call on another vtab fails. Fix for [167b2aac] . (check-in: [a5d7f5d24a] user: dan branch: trunk, size: 87998) | |
|
2019-11-23
| ||
| 08:36 | [9db1f173d2] part of check-in [de6637e15d] Fix a memory leak in fts5 error handling code. (check-in: [de6637e15d] user: dan branch: trunk, size: 87785) | |
|
2019-11-21
| ||
| 14:20 | [dad126d1de] part of check-in [2eb997327c] Prevent direct and indirect recursive content= options in fts3/4 and fts5. (check-in: [2eb997327c] user: dan branch: trunk, size: 87675) | |
|
2019-10-20
| ||
| 08:26 | [1b2d41fd7c] part of check-in [b528bdcd45] Fix a resource leak in fts5 that could occur if an auxiliary function is called from within a query that does not use the full-text index. (check-in: [b528bdcd45] user: dan branch: trunk, size: 86995) | |
|
2019-09-13
| ||
| 13:23 | [bf63703072] part of check-in [090cd07d37] Ensure that the idxStr for FTS5 is always zero-terminated. Fix for check-in [9d418a7a491761ee] (check-in: [090cd07d37] user: drh branch: trunk, size: 86948) | |
| 12:24 | [c589c81760] part of check-in [a8927d14f8] Fix harmless compiler warnings. (check-in: [a8927d14f8] user: drh branch: trunk, size: 86865) | |
|
2019-09-12
| ||
| 19:38 | [e6db945454] part of check-in [9d418a7a49] Allow fts5 to filter on multiple MATCH clauses in a single scan. (check-in: [9d418a7a49] user: dan branch: trunk, size: 86934) | |
|
2019-09-02
| ||
| 14:46 | [15dc14ea59] part of check-in [9490683ae8] Fix a potential crash in fts5 caused by using an auxiliary function on a "special" query like '*id' or '*reads'. (check-in: [9490683ae8] user: dan branch: trunk, size: 86159) | |
|
2019-08-20
| ||
| 19:11 | [b2c42f1cef] part of check-in [00e9a8f273] Fix a problem with fts5 "ORDER BY rank" queries when the fts5 table name requires quoting. (check-in: [00e9a8f273] user: dan branch: trunk, size: 86125) | |
|
2019-08-05
| ||
| 12:55 | [346a1ec08c] part of check-in [b6d52c9364] Prevent an fts5 table from being its own content table, or part of a view that is the content table. (check-in: [b6d52c9364] user: dan branch: trunk, size: 86121) | |
|
2019-04-13
| ||
| 14:07 | [abd04720e2] part of check-in [c28c973ad6] Fixes for harmless compiler warnings. (check-in: [c28c973ad6] user: drh branch: trunk, size: 85969) | |
|
2019-03-20
| ||
| 05:45 | [de317d9890] part of check-in [1c0fe5b576] Fix various harmless compiler warnings seen with MSVC. (check-in: [1c0fe5b576] user: mistachkin branch: noWarnings, size: 85959) | |
|
2019-02-04
| ||
| 16:25 | [95d63bbe60] part of check-in [b0da6e0dd1] Fix problems with SAVEPOINT and related commands within transactions on a corrupt database that include fts5 or some other virtual tables. (check-in: [b0da6e0dd1] user: dan branch: trunk, size: 85943) | |
|
2019-01-29
| ||
| 15:30 | [2395658479] part of check-in [9d58a15737] Avoid a crash when the fts5 snippet() function (or similar) is used with a special query pattern, like '*id' or '*reads'. (check-in: [9d58a15737] user: dan branch: trunk, size: 85942) | |
|
2019-01-22
| ||
| 21:17 | [df4ba0a9d8] part of check-in [1abc441564] Fix a buffer overrun that could occur in fts5 if a prefix query is made on a corrupt database. (check-in: [1abc441564] user: dan branch: trunk, size: 85901) | |
|
2019-01-17
| ||
| 17:39 | [4a7ebaa5a2] part of check-in [49956395e1] Fix problems with joining two or more fts5_vocab tables that access the same underlying fts5 table. (check-in: [49956395e1] user: dan branch: trunk, size: 85741) | |
|
2019-01-15
| ||
| 15:18 | [55236fb775] part of check-in [4a9483f81e] Have fts5 reject attempts to insert a non-integer, non-null value into a rowid column with SQLITE_MISMATCH. (check-in: [4a9483f81e] user: dan branch: trunk, size: 85726) | |
|
2019-01-14
| ||
| 15:35 | [ea863c2847] part of check-in [9cd64ce453] Fix a problem causing a crash if an fts5vocab table was created to query an fts3/4 FTS index. (check-in: [9cd64ce453] user: dan branch: trunk, size: 85507) | |
|
2019-01-08
| ||
| 20:02 | [90062ccfc5] part of check-in [ca67f2ec0e] Use 64-bit math to compute the sizes of memory allocations in extensions. (check-in: [ca67f2ec0e] user: drh branch: trunk, size: 85481) | |
|
2018-11-06
| ||
| 14:03 | [287a1a5658] part of check-in [d890c65825] Only allow shadow table to be written from within a recursive SQL call. Omit the SQLITE_PREPARE_SHADOW flag. Some tests are failing because the tests depend on being able to write to shadow tables. (check-in: [d890c65825] user: drh branch: read-only-shadow, size: 85445) | |
|
2018-11-05
| ||
| 23:01 | [5318b20598] part of check-in [31942b3dd3] Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. (check-in: [31942b3dd3] user: drh branch: read-only-shadow, size: 85496) | |
|
2018-09-05
| ||
| 17:45 | [7e52868e6b] part of check-in [f804336f08] Fix some test script errors. And an incorrect assert() in fts5. (check-in: [f804336f08] user: dan branch: alter-table-rename-column, size: 85025) | |
|
2018-09-03
| ||
| 17:11 | [2ee492d773] part of check-in [f1138a38bd] Ensure that FTS5 queries of the form "WHERE rowid BETWEEN ? AND ? AND tbl MATCH ? ORDER BY rank" do rowid filtering before sorting. (check-in: [f1138a38bd] user: dan branch: trunk, size: 85024) | |
|
2018-04-09
| ||
| 14:26 | [da46761a7e] part of check-in [a0ca4ddbbf] Fix the fts5 xBestIndex method so that it is not confused by "IS", "!=", "REGEXP", "GLOB" or "LIKE" operators. Fix for ticket [2b8aed9f]. (check-in: [a0ca4ddbbf] user: dan branch: trunk, size: 84758) | |
|
2017-07-17
| ||
| 15:38 | [24868f88ab] part of check-in [bc78235f54] Improved the interface to the fts5() extension mechanism for enhanced security. (check-in: [bc78235f54] user: drh branch: branch-3.20, size: 84362) | |
|
2017-06-28
| ||
| 17:29 | [c6412f30cc] part of check-in [942c3ef8cd] Instead of the new sqlite3_prepare_v3() interface, provide the SQLITE_DBCONFIG_PREPARE_FLAGS interface which sets the flags on the single next call to sqlite3_prepare_v2() or its cousins. (check-in: [942c3ef8cd] user: drh branch: dbconfig-prepare-flags, size: 84542) | |
|
2017-06-01
| ||
| 00:54 | [f32b3b878c] part of check-in [4a25c58833] Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. (check-in: [4a25c58833] user: drh branch: prepare_v3, size: 84419) | |
|
2017-04-13
| ||
| 09:45 | [1ba0e78068] part of check-in [6f54ffd151] Allow a user column name to be used on the LHS of a MATCH operator in FTS5. (check-in: [6f54ffd151] user: dan branch: trunk, size: 84306) | |
|
2017-04-08
| ||
| 09:12 | [24cafdc44c] part of check-in [a921ada890] Have fts5 close any open blob-handle when a new savepoint is opened. This ensures that fts5 does not prevent DROP TABLE statements (which always open a savepoint) from succeeding. (check-in: [a921ada890] user: dan branch: trunk, size: 83816) | |
|
2016-05-30
| ||
| 08:28 | [f85281445d] part of check-in [64ca1a835a] Fix an FTS5 problem (segfault or incorrect query results) with "... MATCH 'x OR y' ORDER BY rank" queries when either token 'x' or 'y' is completely absent from the dataset. (check-in: [64ca1a835a] user: dan branch: trunk, size: 83825) | |
|
2016-03-26
| ||
| 20:11 | [1e1e6e2d6d] part of check-in [53b80a6d05] Fix a problem with OOM handling when setting an fts5 configuration option. (check-in: [53b80a6d05] user: dan branch: fts5, size: 84207) | |
|
2016-03-16
| ||
| 19:48 | [b4a0fc5bf1] part of check-in [33ef2210ef] Have fts5 cache the decoded structure of fts5 indexes in memory. Use "PRAGMA data_version" to detect stale caches. (check-in: [33ef2210ef] user: dan branch: fts5-data-version, size: 83867) | |
|
2016-03-09
| ||
| 20:54 | [b8501e1a6a] part of check-in [556671444c] Add an incremental optimize capability to fts5. Make the 'merge' command independent of the 'automerge' settings. (check-in: [556671444c] user: dan branch: trunk, size: 83564) | |
|
2016-02-17
| ||
| 14:48 | [db24ac714c] part of check-in [87e6e225ae] Remove the "#ifdef SQLITE_TEST" condition from fts5_test_mi.c. Update fts5_main.c so that if SQLITE_FTS5_TEST_MI is defined when it is built the fts5_test_mi.c entry point is automatically called. This makes it easier to build versions of fts5 that include the matchinfo() demo by default. (check-in: [87e6e225ae] user: dan branch: trunk, size: 83588) | |
|
2016-02-11
| ||
| 17:01 | [0e01ead4e8] part of check-in [bc3f7900d5] Handle parser stack overflow when parsing fts5 query expressions. Fix some compiler warnings in fts5 code. (check-in: [bc3f7900d5] user: dan branch: trunk, size: 83214) | |
|
2016-02-05
| ||
| 19:18 | [6e23df9040] part of check-in [ca91bd8ac7] Further streamlining of fts5 prefix query code. (check-in: [ca91bd8ac7] user: dan branch: trunk, size: 82691) | |
|
2016-02-01
| ||
| 20:12 | [7e8a5f27d5] part of check-in [2334e88244] Improve performance of fts5 queries. (check-in: [2334e88244] user: dan branch: trunk, size: 82679) | |
|
2016-01-23
| ||
| 18:51 | [3886bbfc5a] part of check-in [72d53699bf] Fix an fts5 problem with using both xPhraseFirst() and xPhraseFirstColumn() within a single statement in detail=col mode. (check-in: [72d53699bf] user: dan branch: fts5-perf, size: 82645) | |
|
2016-01-16
| ||
| 18:58 | [833db0a3df] part of check-in [de77d6026e] Add further tests for fts5. Fix some problems with detail=col mode and auxiliary functions. (check-in: [de77d6026e] user: dan branch: trunk, size: 82655) | |
|
2016-01-15
| ||
| 19:54 | [1d116f5c44] part of check-in [3b72df405a] Rationalize some code in fts5_storage.c. Add tests to cover recently added branches in fts5. (check-in: [3b72df405a] user: dan branch: trunk, size: 82487) | |
|
2016-01-14
| ||
| 14:15 | [488ceecdb4] part of check-in [5a343cc033] Fix compiler warnings in fts5. (check-in: [5a343cc033] user: dan branch: trunk, size: 82439) | |
|
2016-01-06
| ||
| 19:35 | [03bd44e4bd] part of check-in [e7dcd01351] Merge latest trunk changes into this branch. (check-in: [e7dcd01351] user: dan branch: fts5-offsets, size: 82592) | |
|
2016-01-05
| ||
| 21:04 | [cd5f6f0bf8] part of check-in [fd217fdb39] Rationalize and extend some fts5 test code. Fix bugs revealed by the same. (check-in: [fd217fdb39] user: dan branch: fts5-offsets, size: 82622) | |
|
2016-01-04
| ||
| 19:12 | [15c8b702e2] part of check-in [ee38f9dff5] Fix an OOM handling problem in fts5 detail=none and detail=col modes. Also a bug in the xInst() API when used with detail=col and column filtering expressions. Update the matchinfo() test function so that 'b' is fast with detail=col tables. (check-in: [ee38f9dff5] user: dan branch: fts5-offsets, size: 82538) | |
|
2016-01-02
| ||
| 19:01 | [f33439bde2] part of check-in [6322a1d984] Changes to run many fts5 tests with detail=none and detail=col tables as well as the default detail=full. Also fixes for the bugs uncovered by running said tests. (check-in: [6322a1d984] user: dan branch: fts5-offsets, size: 82243) | |
|
2015-12-29
| ||
| 19:35 | [23f3912ff4] part of check-in [8c30605bcd] Add the xPhraseFirstColumn() and xPhraseNextColumn() API functions to fts5. For iterating through the set of columns that contain intances of a phrase. (check-in: [8c30605bcd] user: dan branch: fts5-offsets, size: 81262) | |
|
2015-12-28
| ||
| 19:55 | [a71db65929] part of check-in [228b4d10e3] Change the name of the offsets=0 option to "detail=column". Have the xInst, xPhraseFirst and other API functions work by parsing the original text for detail=column tables. (check-in: [228b4d10e3] user: dan branch: fts5-offsets, size: 79910) | |
|
2015-12-23
| ||
| 16:42 | [e11b525778] part of check-in [5d44d4a6cf] Fix some harmless gcc compiler warnings. Mostly in fts5, but also two in the core code. (check-in: [5d44d4a6cf] user: dan branch: trunk, size: 78452) | |
|
2015-12-22
| ||
| 18:54 | [b7d6540c63] part of check-in [69bffc1632] Updates so that fts5 API functions xInst, xPhraseFirst and xPhraseNext work with the offsets=0 option. (check-in: [69bffc1632] user: dan branch: fts5-offsets, size: 78966) | |
|
2015-12-16
| ||
| 23:30 | [ef04699949] part of check-in [1d0e6aa119] Fix even more harmless compiler warnings. (check-in: [1d0e6aa119] user: mistachkin branch: msvcWarn, size: 78482) | |
|
2015-11-07
| ||
| 01:33 | [7581280ee2] part of check-in [78bc42e664] Merge recent enhancements and bug fixes from trunk. (check-in: [78bc42e664] user: drh branch: sessions, size: 78467) | |
|
2015-11-06
| ||
| 12:50 | [0569cd9fc1] part of check-in [33e6606f5e] Have fts5 load its configuration from the xConnect() method is invoked. This ensures that the very first query run uses the correct value of the 'rank' option. (check-in: [33e6606f5e] user: dan branch: trunk, size: 78481) | |
|
2015-10-27
| ||
| 20:04 | [39358d3d8f] part of check-in [a85c2a4758] Have contentless and external content fts5 tables ignore "OR REPLACE" conflict handling. (check-in: [a85c2a4758] user: dan branch: trunk, size: 77744) | |
|
2015-10-17
| ||
| 19:49 | [520a29136b] part of check-in [6020d96ab4] Handle equality and range constraints on the "term" column of fts5vocab tables. Also have the same module report columns using names instead of indexes. (check-in: [6020d96ab4] user: dan branch: trunk, size: 77656) | |
|
2015-10-14
| ||
| 21:08 | [d3fde32e1f] part of check-in [f4de6d450e] Tests and minor fixes to improve coverage of FTS5 code. (check-in: [f4de6d450e] user: dan branch: trunk, size: 77511) | |
|
2015-10-12
| ||
| 19:12 | [bf43550b8e] part of check-in [1c20c1c28b] Further tweaks to improve fts5 prefix query performance. (check-in: [1c20c1c28b] user: dan branch: trunk, size: 77481) | |
|
2015-10-10
| ||
| 15:57 | [36fa4fe8b8] part of check-in [35e6248abb] Remove another instance of strcpy() from FTS5, to mollify OpenBSD. (check-in: [35e6248abb] user: drh branch: trunk, size: 77485) | |
| 15:11 | [8331503683] part of check-in [bc24a5bbfd] Omit the use of strcpy() in FTS5 since OpenBSD hates strcpy(). (check-in: [bc24a5bbfd] user: drh branch: trunk, size: 77380) | |
|
2015-10-09
| ||
| 11:09 | [5125711e80] part of check-in [6ebac32d83] Makefile and fts5 changes so that fts5 works with main.mk. Still does not work with Makefile.in. (check-in: [6ebac32d83] user: dan branch: amalg-json1-fts5, size: 77271) | |
|
2015-10-08
| ||
| 20:40 | [d159079e61] part of check-in [0d7f301fb0] Fix further fts5 compilation issues. (check-in: [0d7f301fb0] user: dan branch: amalg-json1-fts5, size: 76799) | |
| 20:11 | [77721fed36] part of check-in [e9e76e1281] Fix a couple of errors in fts5 compilation. This branch still does not build with -Wall -Werror. (check-in: [e9e76e1281] user: dan branch: amalg-json1-fts5, size: 76772) | |
| 19:29 | [1ae4d7ecfc] part of check-in [d820a1bd1b] First attempt to add json1 and fts5 to the amalgamation. This check-in does not compile. (check-in: [d820a1bd1b] user: drh branch: amalg-json1-fts5, size: 76770) | |
|
2015-10-07
| ||
| 17:06 | [aa96828990] part of check-in [13adcd038f] Fix harmless compiler warning in FTS5. (check-in: [13adcd038f] user: mistachkin branch: trunk, size: 76610) | |
|
2015-10-03
| ||
| 15:38 | [fe5243d6bb] part of check-in [41d17d9e24] Update fts5 to support the table function syntax. "... FROM fts5_tbl WHERE fts5_tbl MATCH ?1 AND rank MATCH ?1" can now be written "FROM fts5_tbl(?1, ?2)". (check-in: [41d17d9e24] user: dan branch: trunk, size: 76630) | |
|
2015-10-02
| ||
| 20:04 | [fd9ab88096] part of check-in [5c83b9db46] Update fts5 to avoid using a statement journal for UPDATE and DELETE operations that affect at most a single row. (check-in: [5c83b9db46] user: dan branch: trunk, size: 76502) | |
|
2015-09-17
| ||
| 09:48 | [53116cffeb] part of check-in [e8ed62f82e] Fix a crash in FTS5 caused by specifying NULL as the rhs of a MATCH operator. (check-in: [e8ed62f82e] user: dan branch: trunk, size: 73765) | |
|
2015-09-11
| ||
| 14:15 | [3fa906f6c0] part of check-in [0dc436116e] Fix some compiler warnings in fts5 code. (check-in: [0dc436116e] user: dan branch: trunk, size: 73734) | |
|
2015-09-09
| ||
| 08:15 | [4b04c93408] part of check-in [0eb2b9521f] Fix a bug in preprocessor macros within fts5_main.c. (check-in: [0eb2b9521f] user: dan branch: fts5-incompatible, size: 73697) | |
|
2015-09-08
| ||
| 19:55 | [3ec19f2369] part of check-in [00d990061d] Remove the 0x00 terminators from the end of fts5 doclists stored on disk. (check-in: [00d990061d] user: dan branch: fts5-incompatible, size: 73696) | |
|
2015-09-02
| ||
| 08:22 | [e9d0892424] part of check-in [cf3e45e76d] Fix a problem with fts5 synonyms and the xQueryPhrase() auxiliary function API. (check-in: [cf3e45e76d] user: dan branch: fts5-incompatible, size: 73564) | |
|
2015-08-29
| ||
| 15:44 | [b00834ac54] part of check-in [fc71868496] Another change to the fts5 tokenizer API. (check-in: [fc71868496] user: dan branch: fts5-incompatible, size: 73563) | |
|
2015-08-28
| ||
| 19:56 | [7afdb84ac4] part of check-in [90b85b42f2] Change the fts5 tokenizer API to allow more than one token to occupy a single position within a document. (check-in: [90b85b42f2] user: dan branch: fts5-incompatible, size: 73515) | |
|
2015-08-12
| ||
| 15:36 | [fc47ad734d] part of check-in [efb7c9c5d0] Minor optimization for fts5 API xInst(). (check-in: [efb7c9c5d0] user: dan branch: trunk, size: 73424) | |
| 12:11 | [c5ff6eb7de] part of check-in [f768243527] Add the xPhraseFirst() and xPhraseNext() fts5 APIs, for faster iteration through a single phrases position list. Also optimize xInst() and xInstCount() a bit. (check-in: [f768243527] user: dan branch: trunk, size: 73446) | |
|
2015-08-05
| ||
| 19:35 | [4c8af0015a] part of check-in [9e3aafe44a] Add tests for the matchinfo-like test function. Fix problems found in test and fts5 code by doing so. (check-in: [9e3aafe44a] user: dan branch: trunk, size: 72272) | |
| 07:43 | [dbf7a80c01] part of check-in [dffd358f6c] Remove all references to "docid" within fts5 source code and comments. Replace with "rowid". (check-in: [dffd358f6c] user: dan branch: trunk, size: 71911) | |
|
2015-07-31
| ||
| 17:48 | [4518fa1094] part of check-in [54a771fe2c] Remove a duplicate "typedef struct Fts5Global Fts5Global;" from fts5_main.c (duplicate is in fts5Int.h). (check-in: [54a771fe2c] user: dan branch: trunk, size: 71911) | |
|
2015-07-16
| ||
| 20:17 | [0de7ba8148] part of check-in [e9bf275cd9] Fix compiler warnings in fts5 code. (check-in: [e9bf275cd9] user: dan branch: trunk, size: 71949) | |
|
2015-07-14
| ||
| 17:18 | [8f279999de] part of check-in [3de030c904] Fix some harmless compiler warnings. (check-in: [3de030c904] user: mistachkin branch: trunk, size: 71945) | |
|
2015-07-09
| ||
| 20:46 | [2e43726b3e] part of check-in [b2de77a01c] Improve the performance of docid merges in fts5. (check-in: [b2de77a01c] user: dan branch: trunk, size: 71933) | |
|
2015-07-03
| ||
| 19:13 | [37b0055cb4] part of check-in [3df4af5d8c] Speed up eof checks on fts5 cursors. (check-in: [3df4af5d8c] user: dan branch: trunk, size: 72200) | |
| 17:14 | [f35f445dfe] part of check-in [b9b0c1e50d] Avoid freeing the array of instance matches each time the fts5 xNext() method is called. (check-in: [b9b0c1e50d] user: dan branch: trunk, size: 72108) | |
|
2015-07-02
| ||
| 18:16 | [3390a45510] part of check-in [ec2573487c] Add fts5_source_id() SQL function, similar to sqlite_source_id(). (check-in: [ec2573487c] user: dan branch: trunk, size: 71986) | |
| 15:52 | [c24ee96e7b] part of check-in [7819002ed8] Remove "#ifdef SQLITE_ENABLE_FTS5" from individual fts5 source files. Add a single "#if !defined(SQLITE_CORE) || defined(SQLITE_ENABLE_FTS5)" to fts5.c. (check-in: [7819002ed8] user: dan branch: trunk, size: 71476) | |
|
2015-06-26
| ||
| 04:34 | [c5b2a219d6] part of check-in [ef2052f81e] Initial changes to get FTS5 working with MSVC. (check-in: [ef2052f81e] user: mistachkin branch: fts5Msvc, size: 71361) | |
|
2015-06-25
| ||
| 20:10 | Renamed and modified ext/fts5/fts5.c → ext/fts5/fts5_main.c. [35e90d3d8f] part of check-in [46e86b0637] Add a script to combine all fts5 code into a single file - fts5.c - that can be used to build an SQLite loadable extension. (check-in: [46e86b0637] user: dan branch: fts5, size: 71362) | |