SQLite

All files named ”ext/fts5/fts5_index.c”
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for ext/fts5/fts5_index.c

2025-06-23
19:38
[1906bb292b] 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: 298760)
2025-03-15
12:22
[d171f2a507] part of check-in [16dfc415b6] Use flexible arrays whereever appropriate in FTS5. (check-in: [16dfc415b6] user: drh branch: flex-array, size: 297182)
2025-02-27
21:17
[2f35dd8408] part of check-in [f50c21484d] Approximately 100 typo corrections spanning the whole tree, submitted via forum post 0db9827f0464bc33 and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. (check-in: [f50c21484d] user: stephan branch: trunk, size: 296446)
2025-02-25
20:55
[d6f62cc0dc] part of check-in [af928818a0] Approximately 50 typo fixes, spanning the whole tree, contributed via forum post 006c8fa165083ac3 and individually checked for correctness. Affects only code comments, docs, and a single line of debug output in a test app. (check-in: [af928818a0] user: stephan branch: trunk, size: 296446)
2025-02-17
18:09
[b7827b32e0] part of check-in [e846743a87] Additional changes making it easier to prove that integer overflow does not occur. No problems found. (check-in: [e846743a87] user: drh branch: trunk, size: 296446)
2025-02-03
18:05
[f1eec09315] part of check-in [e33f2fedda] Fix for a potential UAF in FTS5. (check-in: [e33f2fedda] user: drh branch: trunk, size: 296387)
17:54
[3f04b9bbcb] part of check-in [a4962df665] Fix a use-after-free case in fts5 provoked by fuzzdata8.db. Tcl test case pending. (check-in: [a4962df665] user: dan branch: fuzz-data, size: 296073)
2025-01-26
23:34
[a59ccd06af] part of check-in [9b11bed044] Make two private routines in FTS "static" so that they are not callable from outside of SQLite itself. (check-in: [9b11bed044] user: drh branch: trunk, size: 296189)
2025-01-21
14:34
[1ce1e2b43f] part of check-in [f418350f3f] Have fts5 better handle OOM errors from sqlite3_blob_close(). (check-in: [f418350f3f] user: dan branch: trunk, size: 296175)
2025-01-09
20:41
[db0bf9954d] part of check-in [c25dd2dec5] Run tests with SQLITE_TESTCTRL_SCHEMACOPY for mdevtest and sdevtest on this branch. (check-in: [c25dd2dec5] user: dan branch: schema-copy, size: 283865)
14:10
[f1f6da5938] 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: 295875)
2025-01-08
15:54
[1a450035b9] part of check-in [c0b691095a] Fix a crash in fts5 that could occur if shadow tables are modified or removed. (check-in: [c0b691095a] user: dan branch: trunk, size: 295225)
2024-12-29
11:54
[1a7312b7bb] part of check-in [e7f7c9d22b] Four new assert() statements to help with static analysis. (check-in: [e7f7c9d22b] user: drh branch: trunk, size: 294998)
2024-11-20
20:39
[cef6791bd9] part of check-in [211b305791] Fix compiler warnings caused by variable shadowing. (check-in: [211b305791] user: dan branch: fts5-tokendata-prefix, size: 294838)
2024-11-02
19:10
[2cef40d6fd] 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: 294887)
2024-10-27
14:41
[ee650a838f] part of check-in [740a37c5d5] Merge latest trunk into this branch. (check-in: [740a37c5d5] user: dan branch: fts5-tokendata-prefix, size: 294281)
2024-10-01
20:38
[9b2b9636cc] part of check-in [0ca002a4ab] Rationalize code further. And add tests. (check-in: [0ca002a4ab] user: dan branch: fts5-tokendata-prefix, size: 294054)
2024-09-30
17:28
[368a968570] part of check-in [350c6e75ce] In fts5, avoid starting a new merge of level L if there exists already an ongoing merge of a level less than L. (check-in: [350c6e75ce] user: dan branch: trunk, size: 284138)
2024-09-28
20:45
[c100592019] part of check-in [66f209ba40] Rationalize some of the new code on this branch. (check-in: [66f209ba40] user: dan branch: fts5-tokendata-prefix, size: 289792)
2024-09-25
18:55
[8dfb22c5e4] part of check-in [204ddf4e72] Change the way tokendata indexes are collected for prefix queries. (check-in: [204ddf4e72] user: dan branch: fts5-tokendata-prefix, size: 289371)
2024-09-14
20:30
[aadd271f3c] part of check-in [97c2824f47] Fix the fts5 xInstToken() API for prefix queries that do not use prefix-indexes. This is experimental. (check-in: [97c2824f47] user: dan branch: fts5-tokendata-prefix, size: 284258)
2024-09-02
18:41
[5714838231] part of check-in [e6bec37ea1] Fix a technically undefined signed integer overflow in fts5. (check-in: [e6bec37ea1] user: dan branch: trunk, size: 283911)
2024-07-17
16:27
[eb9a0dda3b] part of check-in [81b6360050] Add extra assert() statements to the fixes on this branch. (check-in: [81b6360050] user: dan branch: alignment-fixes, size: 283911)
2024-07-13
16:53
[7c674d147d] part of check-in [2212d7488e] Fixes for platforms with 32-bit pointers that require 64-bit values to be aligned. (check-in: [2212d7488e] user: dan branch: alignment-fixes, size: 283855)
2024-03-20
12:19
[47a121697c] part of check-in [a1a5c427c2] Back port various minor patches (check-in: [a1a5c427c2] user: drh branch: branch-3.44, size: 263326)
2024-02-16
11:41
[ee0f4d50bc] part of check-in [01222d96b9] Handle an OOM case in fts5 code to query tokendata=1 tables. (check-in: [01222d96b9] user: dan branch: trunk, size: 283812)
2024-01-12
16:33
[679b7d2be7] part of check-in [16aa729774] Fix a usan complaint about signed integer overflow. (check-in: [16aa729774] user: drh branch: branch-3.43, size: 260190)
15:38
[96b6cd9998] part of check-in [4b2d02f260] Fix a signed integer overflow usan complaint in fts5. This is fixed on trunk by [a76a636b23], but that is a large commit that adds new features. (check-in: [4b2d02f260] user: dan branch: branch-3.43, size: 260196)
2023-12-24
11:31
[bb1965c396] part of check-in [5937df3b25] Avoid signed integer overflow during integrity_check of FTS5. (check-in: [5937df3b25] user: drh branch: trunk, size: 283747)
2023-12-22
14:47
[cf00132cf9] part of check-in [e65907e027] Fix a usan complaint about signed integer overflow. (check-in: [e65907e027] user: dan branch: trunk, size: 283747)
2023-12-11
13:48
[d202c077fc] 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: 263326)
2023-12-08
12:04
[ed206045ff] part of check-in [a66596e33d] Avoid dropping an error code in new fts5 tokendata=1 code. (check-in: [a66596e33d] user: dan branch: trunk, size: 283753)
2023-12-07
20:46
[3b9f7245d5] part of check-in [386ba9e204] Avoid an assert() failure when querying an fts5vocab table that accesses a tokendata=1 fts5 table with corrupt %_data records. (check-in: [386ba9e204] user: dan branch: trunk, size: 283726)
19:08
[1193379f19] part of check-in [d69fa8f050] Fix a null-pointer dereference in fts5 tokendata=1 code. (check-in: [d69fa8f050] user: dan branch: trunk, size: 283689)
18:41
[7a459f96b2] part of check-in [bc911ab595] Fix a problem with handling OOM and other errors in fts5 when querying tokendata=1 tables. (check-in: [bc911ab595] user: dan branch: trunk, size: 283680)
14:41
[6d3571d6bc] 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: 283665)
2023-12-06
18:34
[111fdb22e4] part of check-in [ee70e4c1c9] Fix compiler warning about shadowed variable in fts5_index.c. (check-in: [ee70e4c1c9] user: dan branch: trunk, size: 283418)
2023-12-05
18:36
[be39b44ff8] part of check-in [59d008b6c2] Further tests for the new code on this branch. (check-in: [59d008b6c2] user: dan branch: fts5-token-data, size: 283433)
2023-12-04
17:58
[7111fed6c0] part of check-in [ebc160b9a0] Fix memory leak in new code on this branch. (check-in: [ebc160b9a0] user: dan branch: fts5-token-data, size: 283931)
17:05
[072666814b] part of check-in [da78d07e77] Fix bug in xInstToken() causing the wrong token to be returned. (check-in: [da78d07e77] user: dan branch: fts5-token-data, size: 283972)
2023-12-02
20:35
[b31bf4f0fb] part of check-in [3a623cfa17] Fix various compiler warnings and other problems with the new code on this branch. (check-in: [3a623cfa17] user: dan branch: fts5-token-data, size: 283755)
18:14
[21f8f44966] part of check-in [e0175d07e4] When tokendata=1 queries require multiple segment-cursors, allow those cursors to share a single array of in-memory tombstone pages. (check-in: [e0175d07e4] user: dan branch: fts5-token-data, size: 280915)
17:32
[a02b6ff2d3] 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: 280011)
2023-12-01
20:37
[2296bcd673] part of check-in [b0a489e8e1] Remove old code for tokendata=1 queries. (check-in: [b0a489e8e1] user: dan branch: fts5-token-data, size: 277317)
20:09
[b6012920df] 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: 285919)
2023-11-29
16:22
[bafdef8be4] part of check-in [60e46c7ec6] Fix signed integer overflow in fts5. (check-in: [60e46c7ec6] user: dan branch: fts5-token-data, size: 274322)
2023-11-28
19:43
[de7bc351d9] part of check-in [554fc13f2c] Merge latest trunk updates into this branch. (check-in: [554fc13f2c] user: dan branch: fts5-token-data, size: 274312)
2023-11-23
11:18
[458cbed8a3] part of check-in [8eb3f40021] Fix an fts5 problem that could occur when mixing regular and secure delete operations on a single table. (check-in: [8eb3f40021] user: dan branch: trunk, size: 263139)
2023-11-22
20:02
[710b022dcd] part of check-in [9b005085ff] Defer building xInstToken() hash-table until it is to be used. (check-in: [9b005085ff] user: dan branch: fts5-token-data, size: 274038)
19:02
[7b87808d78] part of check-in [37b271c19d] Fix tokendata=1 and xInstToken() APIs for detail=none and detail=column tables. (check-in: [37b271c19d] user: dan branch: fts5-token-data, size: 274096)
2023-11-20
11:50
[b3a89f8b0a] part of check-in [80a0bd7a69] Fix an assert() in fts5 that could be true following an OOM or IO error in contentless-delete mode. (check-in: [80a0bd7a69] user: drh branch: branch-3.44, size: 262929)
11:40
[809407c520] part of check-in [3fe89238c3] Fix an assert() in fts5 that could be true following an OOM or IO error in contentless-delete mode. (check-in: [3fe89238c3] user: dan branch: trunk, size: 262949)
2023-11-18
12:06
[4a44705a7e] part of check-in [257cdbab90] Adjust an assert() in fts5WritePoslistData() so that it only applies if there have been no prior errors. dbsqlfuzz 25dca9b2568f67dc78a0e32ff280133fe71994bd. (check-in: [257cdbab90] user: drh branch: trunk, size: 262885)
2023-11-16
21:11
[70fa4a6d8a] part of check-in [d711c96ba8] When querying a tokendata=1 fts5 table, do not use a prefix cursor for the case where the term has only one variant. (check-in: [d711c96ba8] user: dan branch: fts5-token-data, size: 272133)
2023-11-15
11:45
[3b51c2f055] part of check-in [a34b26fe7f] Add implementation of xInstToken() API. (check-in: [a34b26fe7f] user: dan branch: fts5-token-data, size: 268840)
2023-11-06
19:16
[145723e22f] part of check-in [3a869cf1f8] Merge latest trunk into this branch. (check-in: [3a869cf1f8] user: dan branch: fts5-token-data, size: 263856)
18:40
[01b671fedd] part of check-in [c2058a045b] Fix an fts5 problem where a transaction consisting of (a) a DELETE on rowid X, (b) a prefix query, and (c) an INSERT on rowid X, could corrupt the index. (check-in: [c2058a045b] user: dan branch: trunk, size: 262865)
16:32
[20f31401b1] part of check-in [ac5570614e] Merge trunk changes into this branch. (check-in: [ac5570614e] user: dan branch: fts5-token-data, size: 263434)
2023-10-20
19:59
[730c9c32ad] 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: 262443)
2023-10-12
20:03
[d4258687c8] part of check-in [f5913e7632] Fix a problem with an fts5 secure-delete on a rowid/term pair that follows a legacy delete of the same pair. (check-in: [f5913e7632] user: dan branch: branch-3.42, size: 227435)
19:46
[a0f8e58e1c] part of check-in [579aea0c28] Fix a problem with an fts5 secure-delete on a rowid/term pair that follows a legacy delete of the same pair. (check-in: [579aea0c28] user: dan branch: trunk, size: 262398)
2023-10-11
21:08
[79a8e45771] part of check-in [122935182a] Add the tokendata=1 option to ignore trailing token-data when querying an fts5 table. (check-in: [122935182a] user: dan branch: fts5-token-data, size: 262649)
2023-10-06
12:51
[5c3872a01a] part of check-in [f3b3d712d6] Ensure that all fields of static sqlite3_module objects are explicitly initialized, in order to hush-up nuisance compiler warnings. (check-in: [f3b3d712d6] user: drh branch: trunk, size: 261713)
2023-10-03
17:07
[e472083d37] part of check-in [e051120067] Update fts5_decode() to allow for embedded 0x00 bytes in tokens. (check-in: [e051120067] user: dan branch: fts5-token-data, size: 262089)
2023-09-30
18:13
[16d775ecbc] part of check-in [c027c092c4] Changes so that fts5 can handle tokens with embedded '\0' bytes. (check-in: [c027c092c4] user: dan branch: fts5-token-data, size: 261600)
2023-09-11
15:35
[bf9c3b2fc1] part of check-in [958d62c777] Remove a harmlessly unused variable from FTS5. (check-in: [958d62c777] user: drh branch: branch-3.43, size: 260186)
2023-09-08
19:35
[bb405cb68f] part of check-in [fb24ca17fa] Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. (check-in: [fb24ca17fa] user: drh branch: branch-3.43, size: 260209)
19:32
[b69a5ab71b] part of check-in [cc0f82a480] Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. (check-in: [cc0f82a480] user: dan branch: branch-3.42, size: 227098)
18:34
[a86bcd5637] part of check-in [4b60a1c358] Fix a problem with fts5 secure-delete mode causing fts5 to corrupt its records. (check-in: [4b60a1c358] user: dan branch: trunk, size: 261658)
2023-09-05
15:43
[df64d8f5cc] part of check-in [da4b7385a0] Add debugging routines to check each page for corruption after it it is manipulated by the fts5 secure-delete code, and to log said page via sqlite3_log() if it is found to be corrupt. (check-in: [da4b7385a0] user: dan branch: fts5-secure-delete-debug, size: 265649)
2023-09-04
16:48
[47c290589f] part of check-in [b12afff4ef] Add tests for, and source code comments to, fts5. No changes to code. (check-in: [b12afff4ef] user: dan branch: trunk, size: 261688)
2023-08-29
10:50
[77bd70d50c] part of check-in [00a8b3a263] Change a variable from "int" to "i64" to make it easier to prove that it cannot overflow. (check-in: [00a8b3a263] user: dan branch: trunk, size: 260303)
2023-08-24
12:01
[b484322421] part of check-in [3f5bec9a68] Change a variable name in fts5FlushOneHash() to avoid shadowing another. (check-in: [3f5bec9a68] user: dan branch: trunk, size: 260303)
2023-08-21
16:14
[7990b39f68] part of check-in [f5c50349b1] Fix an undefined integer overflow in fts5. (check-in: [f5c50349b1] user: dan branch: trunk, size: 260293)
2023-08-15
14:53
[002d674561] part of check-in [c16ed3b1cc] Fix problems in fts5 test code. (check-in: [c16ed3b1cc] user: dan branch: trunk, size: 260246)
2023-08-01
11:03
[93b4cd116b] part of check-in [aa55c83f35] Fix an assert() in fts5_index.c that might fail when dealing with corrupt records. (check-in: [aa55c83f35] user: dan branch: trunk, size: 260151)
2023-07-29
20:13
[9f7a24e206] part of check-in [b837aff79c] Fix a buffer overread in the fts5_structure virtual table (test code). (check-in: [b837aff79c] user: dan branch: trunk, size: 260148)
2023-07-27
20:08
[a4e35cd126] part of check-in [bf71faa2a1] Fix a couple of compiler warnings in fts5_index.c. (check-in: [bf71faa2a1] user: dan branch: trunk, size: 260110)
2023-07-25
15:48
[182cf576ba] part of check-in [1079300db2] Change the name of the fts5 'delete-automerge' option to 'deletemerge'. And add tests for it. (check-in: [1079300db2] user: dan branch: fts5-contentless-delete, size: 260132)
2023-07-24
19:13
[f5d50e218d] part of check-in [b314be66b9] Add the fts5 'delete-automerge' integer option. A level is eligible for auto-merging if it has a greater than or equal percentage of its entries deleted by tombstones than the 'delete-automerge' option. Default value is 10. (check-in: [b314be66b9] user: dan branch: fts5-contentless-delete, size: 260145)
2023-07-22
19:47
[31b8c8dd69] part of check-in [85c1589ab1] Integrate contentless delete with auto-merge. (check-in: [85c1589ab1] user: dan branch: fts5-contentless-delete, size: 258390)
2023-07-21
21:10
[e500a5d33a] part of check-in [e61c9b083f] Fix fts5 incremental optimization so that it too can handle an index that consists of a single segment with one or more tombstone hash pages. (check-in: [e61c9b083f] user: dan branch: fts5-contentless-delete, size: 256889)
19:33
[3817749456] part of check-in [f4926006b3] Ensure the fts5 'optimize' command correctly rewrites any index that consists of a single segment and one or more tombstone hash pages. (check-in: [f4926006b3] user: dan branch: fts5-contentless-delete, size: 256702)
2023-07-20
20:29
[db653198e9] part of check-in [7567ca0676] Fix some divide-by-zero errors that could occur when handling corrupt tombstone hash records. (check-in: [7567ca0676] user: dan branch: fts5-contentless-delete, size: 256512)
20:09
[5b5b9944ef] part of check-in [69ce2ce035] Avoid an infinite loop that could be entered when dealing with corrupt fts5 tombstone hash pages. (check-in: [69ce2ce035] user: dan branch: fts5-contentless-delete, size: 256416)
16:07
[69d44e0358] part of check-in [5aac50e92e] Add tests and fixes for the new code on this branch. (check-in: [5aac50e92e] user: dan branch: fts5-contentless-delete, size: 256174)
2023-07-19
18:47
[67f3a9fc32] part of check-in [8d09011fa2] Fix various issues with code added to this branch. (check-in: [8d09011fa2] user: dan branch: fts5-contentless-delete, size: 256244)
2023-07-18
19:52
[a2e081dcff] part of check-in [0d005112b8] Fix various problems with fts5 contentless_delete=1 tables. (check-in: [0d005112b8] user: dan branch: fts5-contentless-delete, size: 250265)
17:43
[78c234c47a] part of check-in [fb65cb73d7] Merge the FTS5 memory leak fix from trunk. (check-in: [fb65cb73d7] user: drh branch: fts5-contentless-delete, size: 249360)
16:29
[430d3edfc5] part of check-in [4dcad2db74] Fix memory leak in fts5 introduced by [def41225]. (check-in: [4dcad2db74] user: dan branch: trunk, size: 227207)
13:55
[109d8a75ee] part of check-in [5f66eb4e26] Merge trunk changes with this branch. (check-in: [5f66eb4e26] user: dan branch: fts5-contentless-delete, size: 249360)
13:55
[ab6809cdee] part of check-in [def41225b2] Fix a buffer overrun in fts5 that could occur in 'secure-delete' mode when dealing with corrupt database records. (check-in: [def41225b2] user: dan branch: trunk, size: 227207)
2023-07-17
17:59
[8e5fd1f1eb] 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: 249273)
2023-07-15
18:57
[c38e889290] part of check-in [4410e60d0c] Store large tombstone hash tables in multiple database records. Ensure the same hash tables handle rowid 0. (check-in: [4410e60d0c] user: dan branch: fts5-contentless-delete, size: 249267)
2023-07-12
20:24
[7b9dd92330] part of check-in [0e801f11cd] Avoid a case of an infinite loop in fts5 when dealing with corrupt records. (check-in: [0e801f11cd] user: dan branch: fts5-contentless-delete, size: 243868)
19:34
[508abd2340] part of check-in [74d7610a8e] Fix a crash that may occur when handling corrupt records in contentless_delete=1 mode. (check-in: [74d7610a8e] user: dan branch: fts5-contentless-delete, size: 243830)
18:38
[05415638e4] part of check-in [383de8e225] Get access to SQL functions and virtual tables used for debugging and analysis of FTS5 using SQLITE_FTS5_DEBUG and without the need for SQLITE_TEST. (check-in: [383de8e225] user: drh branch: fts5-contentless-delete, size: 243829)
2023-07-11
18:55
[60c8158595] part of check-in [948267b066] Use a hash-table instead of a flat list to store tombstone rowids. (check-in: [948267b066] user: dan branch: fts5-contentless-delete, size: 243166)
2023-07-10
20:44
[80fdc17d42] 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: 240052)
2023-06-12
14:16
[f1ed9aed21] part of check-in [44fdc798de] Fix a buffer over-read that could occur as part of an fts5 secure-delete operation on a database containing corrupt fts5 records. dbsqlfuzz a463eac437783bcd246cc675b87842618a569cae (check-in: [44fdc798de] user: drh branch: branch-3.42, size: 227093)
11:06
[fe98ebd883] part of check-in [a35c50eca9] Fix a buffer over-read that could occur as part of an fts5 secure-delete operation on a database containing corrupt fts5 records. dbsqlfuzz a463eac437783bcd246cc675b87842618a569cae (check-in: [a35c50eca9] user: dan branch: trunk, size: 227120)
2023-05-22
11:02
[b7c9d81b12] part of check-in [4891dbd938] Fix a buffer overrun that could occur in fts5 when processing corrupt records. dbsqlfuzz 0c6d3451d115974bc27ebed9b14b7a8e13ea05f3. (check-in: [4891dbd938] user: dan branch: trunk, size: 227045)
2023-05-03
14:10
[de3cdae2e0] part of check-in [b8a84a1bf5] Add another assert() to FTS5 to demonstrate that a pointer is never NULL. (check-in: [b8a84a1bf5] user: drh branch: trunk, size: 227018)
2023-05-01
20:42
[d1eaca422c] part of check-in [342af5b4fa] Fix harmless compiler warnings. (check-in: [342af5b4fa] user: drh branch: trunk, size: 226989)
19:59
[9fdb195bac] part of check-in [f6210017b3] Fix harmless compiler warnings in FTS5. (check-in: [f6210017b3] user: drh branch: trunk, size: 227024)
18:52
[a626b7838f] part of check-in [0a92699469] Fix harmless compiler warnings. (check-in: [0a92699469] user: drh branch: trunk, size: 226978)
2023-04-29
18:31
[a84273c6dd] part of check-in [2e85b0e3dc] Fix a crash that could occur in fts5 'secure-delete' mode when operating on corrupt records. (check-in: [2e85b0e3dc] user: dan branch: trunk, size: 226968)
2023-04-18
11:33
[17dca8e874] part of check-in [49595083ba] Fix an assert() in fts5 that could fail following an OOM or IO error. (check-in: [49595083ba] user: dan branch: trunk, size: 226878)
2023-04-17
18:32
[2a59602a7e] part of check-in [4d3f27ba90] Fix some problems with using fts5 options 'secure-delete' and detail=none together. (check-in: [4d3f27ba90] user: dan branch: trunk, size: 226858)
11:41
[13c4ea17f9] part of check-in [2f63d4a8ba] Fix problems handling corrupt records in new fts5 code. (check-in: [2f63d4a8ba] user: dan branch: trunk, size: 226194)
10:39
[0fe4bf689b] part of check-in [e8de277446] Fix an assert() in fts5 that may be true when dealing with corrupt records. (check-in: [e8de277446] user: dan branch: trunk, size: 225935)
2023-04-15
21:00
[3d50e647b8] part of check-in [8de4542553] Change a memcpy() to memmove() in new fts5 code. (check-in: [8de4542553] user: dan branch: trunk, size: 225932)
19:58
[50c0e72697] part of check-in [904be83d9f] Fix a use-after-free that could follow an OOM or IO error in fts5 when using 'secure-delete' mode. (check-in: [904be83d9f] user: dan branch: trunk, size: 225931)
19:13
[185d989a3c] part of check-in [9ee24a499c] Avoid dropping the error code following an OOM in fts5 when using 'secure-delete' mode. (check-in: [9ee24a499c] user: dan branch: trunk, size: 225911)
2023-04-14
16:11
[2e7829ffae] part of check-in [0268d1a593] Add tests for the new feature on this branch. (check-in: [0268d1a593] user: dan branch: fts5-secure-delete, size: 225891)
2023-04-12
18:06
[4dc0f8b79a] part of check-in [0a0f64870f] Remove temporary debugging code accidentally left on this branch. (check-in: [0a0f64870f] user: dan branch: fts5-secure-delete, size: 225935)
17:40
[111da0b322] 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: 226047)
2023-02-08
17:28
[df5b29576a] part of check-in [459d986d38] Better fix the problem where optimizing an fts5 table too often causes it to become unreadable (first attempt was [35bed981]). (check-in: [459d986d38] user: dan branch: trunk, size: 212835)
2023-02-03
19:28
[8a78d6c57a] part of check-in [35bed98141] Fix a problem where optimizing an fts5 table too often might cause it to become unreadable. (check-in: [35bed98141] user: dan branch: trunk, size: 212838)
2022-12-23
14:49
[e879315306] part of check-in [c14bbe1606] Fix lots of harmless, nuisance compiler warnings, mostly unused parameter warnings in extensions. (check-in: [c14bbe1606] user: drh branch: trunk, size: 212788)
2022-11-09
11:17
[a8ee270724] part of check-in [ae43e97087] Better handle an error in the fts5 integrity-check code. dbsqlfuzz e87c62f9b67ea21aebdc36ab71cab7cc3eda8dc3. (check-in: [ae43e97087] user: dan branch: trunk, size: 212781)
2022-08-08
19:29
[4b1ac44c66] part of check-in [46a78c8c0e] Avoid some cases of signed integer overflow in fts5 by casting to unsigned values. (check-in: [46a78c8c0e] user: dan branch: trunk, size: 212758)
2022-04-29
12:09
[3e47d9c56e] part of check-in [680ccecbc8] Minor typo fix in a comment, for the benefit of broken IDE syntax highlighters. (check-in: [680ccecbc8] user: drh branch: trunk, size: 212670)
2022-01-01
19:55
[fdfbc8a628] part of check-in [8e619c21e2] Attempt to fix a harmless compiler warning in FTS5. (check-in: [8e619c21e2] user: drh branch: trunk, size: 212669)
2021-12-06
18:57
[b1b2e5d4a9] part of check-in [bb9b1a15f7] Fix an OOB read that could occur in fts5 when processing corrupt records. (check-in: [bb9b1a15f7] user: dan branch: trunk, size: 212667)
2021-11-26
17:10
[a3ada4897c] part of check-in [eb878c01f3] Improved defenses against integer overflow when computing the size of a memory allocations. No bugs were fixed here. But perhaps future bugs will be prevented. (check-in: [eb878c01f3] user: drh branch: trunk, size: 212559)
2021-10-16
19:50
[037b12ca0a] part of check-in [0bf42bb561] Fix a harmless scan-build warning in FTS5. (check-in: [0bf42bb561] user: drh branch: trunk, size: 212559)
2021-10-14
21:13
[0eb48ac735] part of check-in [69a3ff0cc1] Fix a signed integer overflow in fts5 leading to a segfault that could occur when processing corrupt records. (check-in: [69a3ff0cc1] user: dan branch: trunk, size: 212477)
2021-10-05
18:33
[9f4f6e2c49] part of check-in [a7835bead8] Fix more harmless static-analyzer warnings. As of this check-in, no warnings are generated by scan-build for clang-6 or clang-10. (check-in: [a7835bead8] user: drh branch: trunk, size: 212475)
17:41
[10be19396b] part of check-in [36177a62fe] Fixes for harmless static-analyzer warnings. This also makes the code easier for humans to understand. (check-in: [36177a62fe] user: drh branch: trunk, size: 212170)
2021-10-04
18:21
[7d38db1d89] part of check-in [1c67f957fc] Fix harmless static analyzer warnings in sessions, rtree, fts3 and fts5. Add the -DSQLITE_OMIT_AUXILIARY_SAFETY_CHECKS compile-time option to cause ALWAYS() and NEVER() macros to be omitted from the build. (check-in: [1c67f957fc] user: drh branch: fix-warnings, size: 211923)
2021-10-01
15:05
[b5df80b2f2] part of check-in [fe098a9334] Fix a buffer overread in fts5 that could occur when processing an "ORDER BY rowid DESC" query against corrupt database records. (check-in: [fe098a9334] user: dan branch: trunk, size: 211819)
2021-09-29
13:36
[48ab70b8d6] part of check-in [9bbc01fb23] Fix an out-of-bounds read in fts5 that could occur when processing corrupt records. (check-in: [9bbc01fb23] user: dan branch: trunk, size: 211818)
2021-09-22
14:43
[3cdcb62ef0] part of check-in [d678ecca02] Fix harmless compiler warnings. (check-in: [d678ecca02] user: drh branch: trunk, size: 211741)
2021-09-07
16:05
[742ba7ecfb] part of check-in [1183552de1] Fix a memory leak in fts5 that could occur when writing to an fts5 table that is being scanned by an fts5vocab cursor. (check-in: [1183552de1] user: dan branch: trunk, size: 211745)
2021-09-06
16:15
[99d3242d84] part of check-in [e751c2ec78] Fix a use-after-free error that could occur if an fts5 table is written while scanning it using an fts5vocab cursor. (check-in: [e751c2ec78] user: dan branch: trunk, size: 211706)
2021-07-07
11:51
[75249b8218] part of check-in [9dbdc9001e] Instead of disallowing writes to fts5 tables if there are fts5vocab cursors open on them (commit [c49a6ed7]), abort any fts5vocab queries if the on-disk structure of the fts5 table changes. (check-in: [9dbdc9001e] user: dan branch: trunk, size: 210432)
2021-06-09
13:39
[eb1864c6ab] part of check-in [a99c29b5ef] Add defensive code to better handle corrupt records in fts5. (check-in: [a99c29b5ef] user: dan branch: trunk, size: 210064)
2021-06-08
23:46
[104ba1088f] part of check-in [f3f82967b2] Remove two assert()s in FTS5 that checks for database corruption right before actual code does the same check. dbsqlfuzz 9680db8f5338cb9b6060eb3a02d984555d4472e3. (check-in: [f3f82967b2] user: drh branch: trunk, size: 209982)
2021-06-07
17:36
[a2ce620e1f] part of check-in [078962a216] Fix a buffer overread that could occur in fts5 when handling corrupt records. (check-in: [078962a216] user: dan branch: trunk, size: 210065)
2021-05-06
13:45
[222b5e56f5] part of check-in [5f12f89154] Remove an assert() in FTS5 that can (rarely) be false in the event of an OOM while processing a corrupt database file. (check-in: [5f12f89154] user: drh branch: trunk, size: 210065)
2021-04-27
11:28
[3e81816a45] part of check-in [cbedfa0550] Fix a segfault that could occur when querying a corrupt data structures with an fts5token table. (check-in: [cbedfa0550] user: dan branch: trunk, size: 210099)
2021-04-23
11:37
[345824b780] part of check-in [dfadb96edf] Fix an assert() in fts5_index.c that may fail if the database records are corrupt. (check-in: [dfadb96edf] user: dan branch: trunk, size: 210099)
2021-04-22
19:34
[a45f0d7ada] part of check-in [1427391597] Fix harmless compiler warnings of unused function parameters in FTS5. (check-in: [1427391597] user: drh branch: trunk, size: 210051)
2021-04-13
17:45
[a2ee224783] part of check-in [e6f0adb00d] Fix an undefined signed integer overflow in fts5. (check-in: [e6f0adb00d] user: dan branch: trunk, size: 210031)
2021-04-06
17:51
[27c83f0ca4] part of check-in [e7491acc0c] Fix issue with failing --enable-debug --enable-fts5 build. (check-in: [e7491acc0c] user: dan branch: trunk, size: 210037)
14:46
[39e026ac85] part of check-in [3088bf15ca] Remove some test routines from release builds of fts5. (check-in: [3088bf15ca] user: dan branch: trunk, size: 209905)
2021-03-10
19:32
[df5e18b705] part of check-in [4cb00b9d40] Fix further sanitizer complaints in the fts5 code. (check-in: [4cb00b9d40] user: dan branch: trunk, size: 209544)
14:57
[423a771a52] part of check-in [4fe4fee00e] Fix a few sanitizer complaints in fts5. (check-in: [4fe4fee00e] user: dan branch: trunk, size: 209508)
2021-03-03
19:36
[4a8ec31cf0] part of check-in [4da40620ac] Fix a buffer overrun that could occur in fts5 when running a prefix query against a corrupt db. (check-in: [4da40620ac] user: dan branch: trunk, size: 209479)
2020-12-19
15:39
[acbe3ccd36] part of check-in [b79f59f9ad] Fix a broken assert() in fts5 that could be triggered by corrupt database records. (check-in: [b79f59f9ad] user: dan branch: trunk, size: 209389)
2020-12-04
17:05
[7be3a7dcf4] part of check-in [1db7c75191] Fix harmless compiler warnings associated with the recent FTS5 enhancements. (check-in: [1db7c75191] user: drh branch: trunk, size: 209514)
2020-12-03
21:22
[3f00c98894] part of check-in [026a93508e] When merging prefix lists in fts5, use 16-way merges instead of 2-way merges. This faster. (check-in: [026a93508e] user: dan branch: trunk, size: 209515)
2020-12-02
19:08
[e4650549c7] part of check-in [78a7801d8f] Allow a search for an N character prefix in fts5 to use a prefix index of size N+1, if no prefix index of size N exists. (check-in: [78a7801d8f] user: dan branch: trunk, size: 208569)
16:23
[728cb3b5dd] part of check-in [d8de2f236d] Improve performance for fts5 column filters that filter for more than one column. e.g. "{col1 col2 col3}:phrase". (check-in: [d8de2f236d] user: dan branch: trunk, size: 207699)
2020-11-27
15:28
[9f152a596d] part of check-in [a32b4f650d] Fix a case in the FTS5 integrity check where a corrupt database could cause a buffer overread. (check-in: [a32b4f650d] user: dan branch: trunk, size: 207974)
2020-10-12
18:09
[fb8ed13cb8] part of check-in [7e17c2f4b7] Fix some fts5 problems with signed integer overflow causing segfaults in -ftrapv builds. (check-in: [7e17c2f4b7] user: dan branch: trunk, size: 207902)
2020-09-21
14:53
[255d3ce3fe] 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: 207914)
2020-09-17
14:16
[203a8db4c3] part of check-in [66f94d623c] Fix a "jump depends on unitialized value" valgrind/asan error in fts5. (check-in: [66f94d623c] user: dan branch: trunk, size: 207886)
2020-07-29
16:18
[e52291d536] 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: 207819)
2020-07-13
11:06
[de14c9a30f] part of check-in [49da8bdce1] Fix an integer overflow bug in fts5 triggered by a corrupt record. (check-in: [49da8bdce1] user: dan branch: trunk, size: 207817)
2020-01-23
00:08
[f25bec3c00] part of check-in [8a6fe3066c] Fix variable declaration issue seen with MSVC. (check-in: [8a6fe3066c] user: mistachkin branch: trunk, size: 207821)
2019-12-24
20:51
[e3573c88ce] part of check-in [bae060f382] Fix a problem causing fts5 integrity-check failures if numeric values are inserted into a table within a utf-16 database. Fix for [752fdbf6]. (check-in: [bae060f382] user: dan branch: trunk, size: 207821)
16:20
[f704b61e13] part of check-in [1c0a05b09a] Fix another case where malformed utf-8 was being mishandled in fts5. Fix for [df46a6f3]. (check-in: [1c0a05b09a] user: dan branch: trunk, size: 207821)
15:35
[784559cf78] part of check-in [4630c1ec01] Fix an assert() added as part of commit [a11b393dc] that can fail if fts5 database records are corrupt. (check-in: [4630c1ec01] user: dan branch: trunk, size: 207760)
14:27
[d0b7e5e79c] part of check-in [a11b393dc2] Fix a spurious report of corruption that could be made by the fts5 integrity-check in SQLITE_DEBUG builds if the fts5 index contains malformed utf text. Ticket [d62981b76de521e3] (check-in: [a11b393dc2] user: dan branch: trunk, size: 207757)
2019-10-24
20:35
[99b77ae1f5] part of check-in [8d964e1c21] In fts5, fix a case of overreading a buffer by 1 byte when counting characters in malformed utf-8. Fix for [dd1f67bf]. (check-in: [8d964e1c21] user: dan branch: trunk, size: 206605)
2019-10-20
08:26
[d1bfebebe8] 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: 206577)
2019-10-09
18:36
[ce199410b2] part of check-in [86e4972092] Do not allow users to effectively disable fts5 crisismerge operations by setting the crisismerge threshold to higher than the maximum allowable segment b-trees on a single level. Fix for [d392017c]. (check-in: [86e4972092] user: dan branch: trunk, size: 206512)
2019-10-08
13:34
[7fca0f89a9] part of check-in [238e083571] Fix problems with using the fts5 'rebuild' command inside a transaction that contains other updates of the same table. Fix for [e258f008]. (check-in: [238e083571] user: dan branch: trunk, size: 206598)
2019-10-07
20:36
[e35f72fb9a] part of check-in [8ab0aebdb3] Disallow page-sizes smaller than 32 bytes in fts5. Also ensure the fts5 integrity-check works even when "PRAGMA reverse_unordered_selects" is true. Fix for [265e935b26]. (check-in: [8ab0aebdb3] user: dan branch: trunk, size: 206571)
2019-09-18
11:46
[6601d085d8] part of check-in [6b6751cd90] Fix a "jump depends on unititialized value" valgrind error in fts5 triggered by corrupt database records. (check-in: [6b6751cd90] user: dan branch: trunk, size: 206548)
2019-08-29
14:25
[b062bdb836] part of check-in [c465d0eb47] Fix a potential buffer overrun in fts5 caused by corrupted database records. (check-in: [c465d0eb47] user: dan branch: trunk, size: 206534)
2019-08-24
17:11
[ada7661078] part of check-in [156d612800] Fix a potential buffer overrun in fts5 caused by corrupt database records. (check-in: [156d612800] user: dan branch: trunk, size: 206298)
2019-07-25
19:29
[cd363c2fa3] part of check-in [16472112b6] Fix a potential buffer overread in fts5 triggered by a corrupt database record. (check-in: [16472112b6] user: dan branch: trunk, size: 206084)
2019-05-24
11:55
[5a89e03412] part of check-in [600daa9c27] Fix an fts5 segfault that could occur after parsing a corrupt structure record. (check-in: [600daa9c27] user: dan branch: trunk, size: 206051)
2019-05-14
11:33
[f417615c65] part of check-in [8be8bd0d56] Fix an assert() and potential buffer overrun in fts5 that could occur if the database was corrupt. (check-in: [8be8bd0d56] user: dan branch: trunk, size: 206029)
2019-05-13
11:52
[eb6064265d] part of check-in [f158c048be] Fix an assert() failure in fts5 that could occur when processing a corrupt database. (check-in: [f158c048be] user: dan branch: trunk, size: 205659)
2019-04-13
14:07
[9146da94d0] part of check-in [c28c973ad6] Fixes for harmless compiler warnings. (check-in: [c28c973ad6] user: drh branch: trunk, size: 205425)
2019-04-06
15:38
[8a3ef6f2dc] part of check-in [edb095a9a6] Fix two assert() statements in fts5 that are only true if the database is not corrupt. (check-in: [edb095a9a6] user: dan branch: trunk, size: 205422)
2019-03-19
20:13
[865302c41a] part of check-in [d5acf3af65] Fix a compiler warning in FTS5. (check-in: [d5acf3af65] user: drh branch: trunk, size: 205416)
2019-03-18
15:23
[39b59af941] part of check-in [45c73deb44] Fix an fts5 problem with interleaving reads and writes in a single transaction. (check-in: [45c73deb44] user: dan branch: trunk, size: 205411)
2019-02-11
16:12
[6589ccacba] part of check-in [09e337386b] Fix another segfault that could occur in fts5 with a corrupted database. (check-in: [09e337386b] user: dan branch: trunk, size: 205278)
2019-02-04
14:00
[ffff7e8d41] part of check-in [14fba4cc5d] Fix another potential buffer overread in fts5. (check-in: [14fba4cc5d] user: dan branch: trunk, size: 205247)
11:54
[688b61d543] part of check-in [e608085d3f] Fix another corruption case in fts5. (check-in: [e608085d3f] user: dan branch: trunk, size: 205139)
2019-02-02
13:47
[2e8d2ff004] part of check-in [54f2399fb2] Fix a buffer overread in fts5 debugging scalar function fts5_decode(). (check-in: [54f2399fb2] user: dan branch: trunk, size: 205097)
2019-02-01
14:40
[7e8e678f24] part of check-in [55f06aa3f8] Fix an assert() in fts5 that could fail if the database is corrupt. (check-in: [55f06aa3f8] user: dan branch: trunk, size: 205016)
13:34
[9e9607d921] part of check-in [9876ae1b80] Fix another corrupt-database-handling problem in fts5. (check-in: [9876ae1b80] user: dan branch: trunk, size: 205013)
2019-01-31
14:37
[a5cc612c8b] part of check-in [b80119bd60] Fix another buffer overrun that could occur when quering a corrupt database using an fts5vocab table. (check-in: [b80119bd60] user: dan branch: trunk, size: 205003)
2019-01-30
12:15
[97d84ca8ed] part of check-in [760d14374d] Fix another buffer overread in fts5 that may occur when accessing a corrupt database. (check-in: [760d14374d] user: dan branch: trunk, size: 204992)
2019-01-29
11:42
[091a8474bc] part of check-in [7ee3cd5b2c] Fix a buffer overrun triggered by a merge operation on a corrupt fts5 database. (check-in: [7ee3cd5b2c] user: dan branch: trunk, size: 204900)
2019-01-25
16:54
[ae9b5af68f] part of check-in [93f8ec146d] Fix asan warnings in fts5 triggered by corrupt databases - passing NULL to memcmp, out-of-range left-shift values and signed integer overflow. (check-in: [93f8ec146d] user: dan branch: trunk, size: 204900)
2019-01-23
19:17
[9f2eaae470] part of check-in [44ce8baa47] Fix another fts5 crash that can occur if the database is corrupted. (check-in: [44ce8baa47] user: dan branch: trunk, size: 204875)
12:19
[13e7ef5686] part of check-in [1d8172a94b] Fix a buffer overwrite triggered by a prefix query on a corrupt fts5 table. (check-in: [1d8172a94b] user: dan branch: trunk, size: 204428)
2019-01-22
21:17
[ae896f5994] 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: 204386)
2019-01-17
20:06
[53e064ad16] part of check-in [4538d9afe4] Fix another corruption related crash in fts5. (check-in: [4538d9afe4] user: dan branch: trunk, size: 204365)
19:11
[21aec48189] part of check-in [3910b5639d] Fix a buffer overwrite that could occur when running an fts5 prefix query against a corrupt database. (check-in: [3910b5639d] user: dan branch: trunk, size: 204361)
2019-01-12
20:55
[ba68cfbd78] part of check-in [726e398b9d] Fix another problem with handling corrupt records in fts5_decode(). (check-in: [726e398b9d] user: dan branch: trunk, size: 204242)
00:45
[d1d037dc23] part of check-in [b74e5f3f30] Improved detection of shadow table corruption in the fts5_decode() SQL function. (check-in: [b74e5f3f30] user: drh branch: trunk, size: 204159)
2019-01-10
19:26
[7e617122cd] part of check-in [240f1c0c92] Fix a memory leak in fts5 that could occur if scalar function fts5_decode() was passed a corrupt record. (check-in: [240f1c0c92] user: dan branch: trunk, size: 204011)
18:35
[89ebc3ca91] part of check-in [ff3b011f17] Fix a memory leak in fts5. (check-in: [ff3b011f17] user: dan branch: trunk, size: 204031)
17:08
[ec0ca720bf] part of check-in [3291b2a6fe] Avoid use-after-free and double-free errors that could occur if an fts5 table is modified in certain ways while there are active cursors. (check-in: [3291b2a6fe] user: dan branch: trunk, size: 204060)
15:17
[8663717e84] part of check-in [83c467d7af] Fix further problems with fts5 handling corrupt databases. (check-in: [83c467d7af] user: dan branch: trunk, size: 204206)
2019-01-09
21:12
[a84ed47b00] part of check-in [931278b257] Fix an out-of-bounds read in SQL function fts5_decode() that could occur if it was passed a corrupt record. (check-in: [931278b257] user: dan branch: trunk, size: 204121)
2019-01-08
20:02
[8e734f8592] 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: 204010)
08:02
[7788ae02cd] part of check-in [673a7dd698] Fix further problems with fts5 and corrupt databases causing integer overflow. (check-in: [673a7dd698] user: dan branch: trunk, size: 203919)
2019-01-05
07:17
[7d93b9503e] part of check-in [444c7c99be] Fix two more problems with corrupt database handling in fts5. (check-in: [444c7c99be] user: dan branch: trunk, size: 203919)
2019-01-04
11:20
[70b147a2c4] part of check-in [0888fc2e88] Fix another fts5 assert() that may fail if the database is corrupt. (check-in: [0888fc2e88] user: dan branch: trunk, size: 203919)
2019-01-03
19:12
[6694a1ee02] part of check-in [c0eb839a3c] Fix some problems with sqlite3_interrupt() handling in fts5. (check-in: [c0eb839a3c] user: dan branch: trunk, size: 203916)
2019-01-01
19:17
[d4b950baf4] part of check-in [911342f751] Fix another fts5 problem caused by a corrupt database. (check-in: [911342f751] user: dan branch: trunk, size: 203749)
13:59
[2a0d5da39d] part of check-in [f7e6cdc562] Fix another case in fts5 where a corrupt database could cause a buffer overread. (check-in: [f7e6cdc562] user: dan branch: trunk, size: 203613)
2018-12-28
18:09
[2fdfbf4194] part of check-in [c4d44542d2] Fix another problem with loading the structure record from a corrupt fts5 database. (check-in: [c4d44542d2] user: dan branch: trunk, size: 203524)
13:57
[44d6829cac] part of check-in [a385298df2] Fix a buffer overwrite in fts5 triggered by a corrupt database. (check-in: [a385298df2] user: dan branch: trunk, size: 203491)
07:37
[c67a3bf1c1] part of check-in [c564bf8701] Fix problems in fts5 found by ASAN. (check-in: [c564bf8701] user: dan branch: trunk, size: 203469)
2018-12-27
20:12
[f3601579ef] part of check-in [fb0d7fba07] Fix another problem with corrupt database handling in fts5. (check-in: [fb0d7fba07] user: dan branch: trunk, size: 203450)
15:36
[4b824be439] part of check-in [ff45f9dd69] Fix another problem in fts5 caused by a corrupt schema record. (check-in: [ff45f9dd69] user: dan branch: trunk, size: 203380)
07:46
[fb67df508c] part of check-in [b0a49d5e6d] Fix a null-pointer dereference that could occur in fts5 with a corrupt database. (check-in: [b0a49d5e6d] user: dan branch: trunk, size: 203289)
2018-12-26
16:57
[d98210603b] part of check-in [6cae81cd1f] Avoid an "uninitialized value read" problem in fts5 that can occur with a corrupt database. (check-in: [6cae81cd1f] user: dan branch: trunk, size: 203154)
16:04
[d6a771cf74] part of check-in [9bad745d37] Fix a problem with handling corrupt databases in the fts5 integrity-check function. (check-in: [9bad745d37] user: dan branch: trunk, size: 203154)
2018-12-24
19:59
[3db9acb1d4] part of check-in [d9653380c4] Change another fts5 assert() that may fail with a corrupt database to an assert_nc(). (check-in: [d9653380c4] user: dan branch: trunk, size: 203131)
2018-12-22
19:54
[bcf2ef1365] part of check-in [fb17fea4b9] Catch another case of a corrupted structure record in fts5. (check-in: [fb17fea4b9] user: dan branch: trunk, size: 203128)
19:09
[49857e5600] part of check-in [1daaba9fb4] Change a faulty assert() in fts5 that could fail on a corrupt db to an if() statement. (check-in: [1daaba9fb4] user: dan branch: trunk, size: 203041)
15:21
[c8b07a5326] part of check-in [83935b9506] Fix an assert() in fts5 that could fail with a corrupt database. (check-in: [83935b9506] user: dan branch: trunk, size: 203028)
13:34
[4c85ce5e90] part of check-in [3518c09b94] Fix a "jump or move depends on uninitialized value" valgrind error that could occur in fts5 when dealing with a corrupt database. (check-in: [3518c09b94] user: dan branch: trunk, size: 203019)
2018-12-21
19:29
[f1f6365a88] part of check-in [25666e3d03] Add new sqlite3_prepare_v3() flag SQLITE_PREPARE_NO_VTAB, for preparing statements that are not allowed to use any virtual tables. Use this to prevent circular references in triggers on virtual table shadow tables from causing resource leaks. (check-in: [25666e3d03] user: dan branch: prepare-no-vtab, size: 202988)
2018-11-12
13:20
[baf3ad4451] part of check-in [ac69d169c6] Fix a use-after-free problem in the fts5vocab virtual table. (check-in: [ac69d169c6] user: dan branch: trunk, size: 203206)
2018-11-05
23:01
[ddaea9e164] 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: 203302)
2018-07-25
15:25
[d1b2d7d92c] part of check-in [0e3de8abbb] Fix a buffer overread in fts5. (check-in: [0e3de8abbb] user: dan branch: trunk, size: 203197)
2018-02-07
18:02
[22b71d0e9e] part of check-in [2a5f813bc6] In extensions rtree, fts3 and fts5, ensure that when dynamic buffers are bound to persistent SQL statements using SQLITE_STATIC, the binding is replaced with an SQL NULL before the buffer is freed. Otherwise, a user may obtain a pointer to the persistent statement using sqlite3_next_stmt() and attempt to access the freed buffer using sqlite3_expanded_sql() or similar. (check-in: [2a5f813bc6] user: dan branch: trunk, size: 203150)
2017-12-11
17:20
[5fe14375a2] part of check-in [92fc146bc2] Fix a buffer overwrite in fts5 that could occur when processing a prefix query. (check-in: [92fc146bc2] user: dan branch: trunk, size: 202993)
2017-06-28
17:29
[93ecfc0dfb] 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: 202715)
2017-06-01
00:54
[2ce9d50ec5] 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: 202573)
2017-05-19
12:32
[cdceac4728] part of check-in [35f721045d] Fix some problems in fts5 code detected by -fsanitize=undefined. (check-in: [35f721045d] user: dan branch: trunk, size: 202456)
2017-05-11
18:14
[9ce10106f4] part of check-in [9a2de4f05f] Do not save the state of an fts5 merge operation mid-way through an input term, even if no previous entry for that term has caused any output. Doing so may corrupt the FTS index. (check-in: [9a2de4f05f] user: dan branch: trunk, size: 202418)
2017-04-21
16:04
[dc25123df2] part of check-in [840042cb2b] Fix an FTS5 bug that could cause a prefix-query without a prefix-index on a database that contains delete-markers to return extra, non-matching, rows. (check-in: [840042cb2b] user: dan branch: trunk, size: 202242)
2017-04-12
17:50
[551add2b77] part of check-in [c847543f8b] Update fts5 to support "<colset> : ( <expr> )" for column filtering, as well as "<colset> : NEAR(...)" and "<colset> : <phrase>". (check-in: [c847543f8b] user: dan branch: trunk, size: 202292)
2017-04-08
09:12
[a3a9ae1c6f] 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: 202227)
2017-01-06
11:55
[f67032a9a5] part of check-in [609ac1c73f] Improve handling of corrupt data in fts5. (check-in: [609ac1c73f] user: dan branch: trunk, size: 202255)
2016-11-14
08:19
[fdbe46da11] part of check-in [e78f6f3bbf] Fix an fts5 problem causing a crash in phrase queries where the first token of the phrase matches one or more rows but some other token within the phrase matches zero. (check-in: [e78f6f3bbf] user: dan branch: trunk, size: 202205)
2016-08-13
10:34
[2d146d5c54] part of check-in [e22252e1da] Fix an fts5 problem with corrupt database handling found by address-sanitizer. (check-in: [e22252e1da] user: dan branch: trunk, size: 202172)
2016-08-11
01:24
[0538673260] part of check-in [2ea0c8b46e] Fix a harmless compiler warning in FTS5. (check-in: [2ea0c8b46e] user: drh branch: trunk, size: 201861)
2016-08-09
19:26
[e25ac419fc] part of check-in [e517545650] Have fts5 interpret column lists that begin with a "-" character as "match any column except" lists. (check-in: [e517545650] user: dan branch: trunk, size: 201839)
2016-04-12
20:05
[b429e23fab] part of check-in [ab69527c16] More harmless compiler warning fixes. (check-in: [ab69527c16] user: mistachkin branch: warnings, size: 201515)
2016-03-29
21:19
[870fa81c7d] part of check-in [7635c68018] Fix some code and test coverage issues in fts5_index.c. (check-in: [7635c68018] user: dan branch: fts5, size: 205236)
2016-03-28
20:13
[48fed29450] part of check-in [a805c6f7ea] Add further tests for savepoint rollback. Fix various code issues and add missing comments in fts5_index.c. (check-in: [a805c6f7ea] user: dan branch: fts5, size: 205180)
2016-03-26
20:11
[9019595c2d] 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: 201661)
2016-03-23
15:53
[fdd82bb421] part of check-in [0ed693c29f] Remove an unused local variable from FTS5. (check-in: [0ed693c29f] user: drh branch: trunk, size: 201509)
15:04
[b271b19dd2] part of check-in [70fc69eed9] Explicitly limit the size of fts5 tokens to 32768 bytes. (check-in: [70fc69eed9] user: dan branch: trunk, size: 201527)
2016-03-22
15:01
[19df86d29d] part of check-in [e1ab2d376a] Fix some errors in fts5 test scripts. (check-in: [e1ab2d376a] user: dan branch: trunk, size: 200965)
2016-03-21
22:28
[0fe734b1e2] part of check-in [25d776e452] Fix harmless compiler warnings. (check-in: [25d776e452] user: drh branch: trunk, size: 200979)
15:30
[40fde2538d] part of check-in [902f221754] Have fts5 cache the structure of its index in main memory. Use "PRAGMA data_version" to figure out when this cache should be invalidated. (check-in: [902f221754] user: dan branch: trunk, size: 200983)
15:18
[39939320ee] part of check-in [89296a46c3] Rearrange code so that tests pass whether SQLITE_DEBUG is defined or not. (check-in: [89296a46c3] user: dan branch: fts5-data-version, size: 200373)
09:56
[d3759c2f7d] part of check-in [d6e2637df1] Change the way fts5 internally allocates segment ids in order to eliminated non-determinism from the module. (check-in: [d6e2637df1] user: dan branch: trunk, size: 198558)
2016-03-17
12:39
[afac2ffe31] part of check-in [020a0bda59] Fix some OOM-handling issues in the fts5 changes on this branch. (check-in: [020a0bda59] user: dan branch: fts5-data-version, size: 200451)
2016-03-16
19:48
[317040cb17] 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: 200303)
2016-03-10
15:12
[d4f0c12e4f] part of check-in [fa0033edf6] Add tests to cover untested branches in recent fts5 changes. (check-in: [fa0033edf6] user: dan branch: trunk, size: 197948)
14:22
[8def6f0ac6] part of check-in [3c343c3d01] Remove an unused local variable. (check-in: [3c343c3d01] user: drh branch: trunk, size: 197966)
2016-03-09
20:54
[f7f3c042ed] 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: 197982)
2016-03-01
14:51
[ecc7036861] part of check-in [daef5869f4] Fix a problem in fts5 where a corrupt db could lead to a (huge) buffer overread. Cherrypick of [c9a30e117f]. (check-in: [daef5869f4] user: dan branch: branch-3.11-matchinfo, size: 196510)
14:50
[a32f4059b4] part of check-in [5b1b7ab5d6] Fix an fts5 problem causing 'optimize' to corrupt the fts index under some circumstances. Cherrypick of [251d6473f7]. (check-in: [5b1b7ab5d6] user: dan branch: branch-3.11-matchinfo, size: 196451)
2016-02-29
17:34
[26a4a61128] part of check-in [c9a30e117f] Fix a problem in fts5 where a corrupt db could lead to a (huge) buffer overread. (check-in: [c9a30e117f] user: dan branch: trunk, size: 196514)
17:16
[745bc6f0e0] part of check-in [251d6473f7] Fix an fts5 problem causing 'optimize' to corrupt the fts index under some circumstances. (check-in: [251d6473f7] user: dan branch: trunk, size: 196455)
2016-02-15
23:46
[78069efb54] part of check-in [e52c90758c] Fix a harmless compiler warning in FTS5. (check-in: [e52c90758c] user: drh branch: trunk, size: 196264)
2016-02-11
21:53
[c6cd5190c7] part of check-in [defc762dd1] Remove the unused fts5BlobCompare() routine. (check-in: [defc762dd1] user: drh branch: trunk, size: 196260)
18:08
[f8afd5cc07] part of check-in [facbc424e5] Avoid a buffer overread when reading a corrupt fts5 structure record. (check-in: [facbc424e5] user: dan branch: trunk, size: 196501)
17:01
[12354c3871] 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: 196239)
2016-02-05
21:09
[28f7213040] part of check-in [22589018ac] Add tests for and remove unreachable branches from fts5 in order to restore test coverage. (check-in: [22589018ac] user: dan branch: trunk, size: 196299)
19:18
[9706959f21] part of check-in [ca91bd8ac7] Further streamlining of fts5 prefix query code. (check-in: [ca91bd8ac7] user: dan branch: trunk, size: 196893)
2016-02-04
19:45
[614c54544f] part of check-in [c9c6457d8e] Further improve performance of unindexed fts5 prefix queries. (check-in: [c9c6457d8e] user: dan branch: trunk, size: 195979)
2016-02-03
20:04
[e634a4a05b] part of check-in [ca11f46db0] Improve performance of fts5 prefix queries on detail=col tables. (check-in: [ca11f46db0] user: dan branch: trunk, size: 195415)
2016-02-02
17:40
[471ff69350] part of check-in [62ea9e5ab8] Enhance the performance of fts5 AND and OR queries. (check-in: [62ea9e5ab8] user: dan branch: trunk, size: 196623)
2016-01-30
19:16
[cd1e4faca8] part of check-in [13fb4aa6a8] Performance enhancement for fts5 column filter queries on detail=full tables. (check-in: [13fb4aa6a8] user: dan branch: trunk, size: 196941)
2016-01-26
20:08
[5558bfbeaf] part of check-in [b4ac61aeee] Further minor performance improvements and code-size reductions related to fts5 column filters on detail=col tables. (check-in: [b4ac61aeee] user: dan branch: fts5-perf, size: 196723)
19:30
[b34b7257f7] part of check-in [249a2d070c] Improve the performance of fts5 column filters on detail=col tables. (check-in: [249a2d070c] user: dan branch: fts5-perf, size: 197675)
2016-01-23
18:51
[722d8717e3] 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: 196264)
14:45
[bd5476edd4] part of check-in [7558a0ad22] Fix a problem involving detail=col and column filters. (check-in: [7558a0ad22] user: dan branch: fts5-perf, size: 198908)
2016-01-22
19:48
[19062d1f40] part of check-in [b5a57b812f] Experimental performance enhancements for fts5. (check-in: [b5a57b812f] user: dan branch: fts5-perf, size: 198729)
2016-01-18
17:48
[716c301835] part of check-in [acaf426449] Add tests for fts5. Fix a crash that can occur in fts5 if the database content is corrupted. (check-in: [acaf426449] user: dan branch: trunk, size: 193017)
09:08
[5ba2a5efcd] part of check-in [8358af3658] Add a debugging function to print human-readable versions of fts5 detail=none leaf pages. (check-in: [8358af3658] user: dan branch: trunk, size: 192987)
2016-01-15
05:39
[cd036089b2] part of check-in [584848d439] Fix a couple C99-isms in FTS5 that cause compile errors on MSVC. (check-in: [584848d439] user: mistachkin branch: trunk, size: 190298)
2016-01-14
14:33
[aa798d3a83] part of check-in [8dedff3b9a] Yet another change to FTS5 trying to get it to merge successfully into sessions. (check-in: [8dedff3b9a] user: drh branch: trunk, size: 190288)
14:19
[140617e34c] part of check-in [d17bc2c92f] Fix another compiler warning in fts5 code. (check-in: [d17bc2c92f] user: dan branch: trunk, size: 190296)
14:15
[11e2b566b8] part of check-in [5a343cc033] Fix compiler warnings in fts5. (check-in: [5a343cc033] user: dan branch: trunk, size: 190463)
2016-01-12
19:28
[5ab044a679] part of check-in [bc5118f40a] Improve performance of fts5 low level iterators. (check-in: [bc5118f40a] user: dan branch: fts5-offsets, size: 190487)
2016-01-06
18:53
[04fe098ffa] part of check-in [8d05cfd48d] Fix an fts5 problem involving detail=none, "ORDER BY rowid DESC" and deleted items. Also add tests to verify that the documented operator precedences are correct. (check-in: [8d05cfd48d] user: dan branch: fts5-offsets, size: 188010)
2016-01-02
19:01
[8665393f8b] 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: 188039)
2015-12-31
18:39
[a7cfe8e886] part of check-in [3a1df69e58] Fix the fts5 integrity-check code so that it works with detail=none tables. (check-in: [3a1df69e58] user: dan branch: fts5-offsets, size: 186756)
17:36
[40eac312bd] part of check-in [6a6f7bc40d] Fix some problems with fts5 detail=none tables. Some still remain. (check-in: [6a6f7bc40d] user: dan branch: fts5-offsets, size: 186366)
2015-12-30
19:58
[94dec3c322] part of check-in [ac8f4cf0ce] Updates to fts5 to support detail=none mode. As of this commit, many cases are still broken. (check-in: [ac8f4cf0ce] user: dan branch: fts5-offsets, size: 185633)
2015-12-29
19:35
[ca8310eaa2] 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: 182929)
2015-12-28
19:55
[24e81d8f2c] 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: 182581)
2015-12-21
18:45
[1d1939afbc] part of check-in [609a0bc7f3] Fix an fts5 integrity-check problem that affects offsets=0 tables with prefix indexes. (check-in: [609a0bc7f3] user: dan branch: fts5-offsets, size: 182468)
2015-12-18
19:07
[d862dc84c5] part of check-in [ad0987d83c] Fix a problem with prefix queries on fts5 offsets=0 tables. (check-in: [ad0987d83c] user: dan branch: fts5-offsets, size: 183288)
2015-12-17
20:36
[53b3a8f1c9] part of check-in [40b5bbf02a] Add the "offsets=0" option to fts5, to create a smaller index without term offset information. A few things are currently broken on this branch. (check-in: [40b5bbf02a] user: dan branch: fts5-offsets, size: 183199)
2015-12-16
23:30
[578f466970] part of check-in [1d0e6aa119] Fix even more harmless compiler warnings. (check-in: [1d0e6aa119] user: mistachkin branch: msvcWarn, size: 182077)
2015-11-06
12:50
[b622a0a70f] 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: 182019)
2015-11-05
18:09
[967d797282] part of check-in [445480095e] Add the 'hashsize' configuration option to fts5, for configuring the amount of memory allocated to the in-memory hash table while writing. (check-in: [445480095e] user: dan branch: trunk, size: 182115)
2015-10-27
17:48
[356481ce02] part of check-in [3b5758c647] Fix problems with prefix queries in fts5. (check-in: [3b5758c647] user: dan branch: trunk, size: 182130)
2015-10-21
22:08
[2bd3cb65b3] part of check-in [aa4e01ea1a] Fix harmless compiler warnings in FTS5. (check-in: [aa4e01ea1a] user: mistachkin branch: trunk, size: 181842)
20:56
[ffb95101ca] part of check-in [ae350bfbfd] Remove some branches made unreachable by recent changes from fts5. (check-in: [ae350bfbfd] user: dan branch: trunk, size: 181788)
20:07
[47ef0002b4] part of check-in [363b36d50b] Minor optimization for fts5 queries. (check-in: [363b36d50b] user: dan branch: trunk, size: 181601)
2015-10-20
23:27
[d3503c75d3] part of check-in [0a903ec26b] Fix harmless compiler warnings in FTS5. (check-in: [0a903ec26b] user: mistachkin branch: trunk, size: 181252)
21:05
[4585692224] part of check-in [b8fb263ed1] More optimizations for fts5 prefix queries. (check-in: [b8fb263ed1] user: dan branch: trunk, size: 181248)
19:55
[903ca7a882] part of check-in [1f5f5804cd] Fix #line directives added to generated file fts5.c. (check-in: [1f5f5804cd] user: dan branch: trunk, size: 180440)
2015-10-19
20:49
[38d7ddd4d5] part of check-in [60a8bde055] Another optimization for fts5 prefix (and other) queries. (check-in: [60a8bde055] user: dan branch: trunk, size: 180444)
17:43
[8468e41855] part of check-in [69be427c86] Another tweak to improve performance of fts5 prefix queries. (check-in: [69be427c86] user: dan branch: trunk, size: 180450)
2015-10-17
19:49
[632fdcb197] 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: 180250)
2015-10-14
21:08
[c76d636d6c] part of check-in [f4de6d450e] Tests and minor fixes to improve coverage of FTS5 code. (check-in: [f4de6d450e] user: dan branch: trunk, size: 180284)
20:34
[3e5582dbe9] part of check-in [1c46c194a2] Fix harmless compiler warnings. (check-in: [1c46c194a2] user: mistachkin branch: trunk, size: 180245)
2015-10-12
19:12
[f739683578] part of check-in [1c20c1c28b] Further tweaks to improve fts5 prefix query performance. (check-in: [1c20c1c28b] user: dan branch: trunk, size: 180216)
2015-10-07
19:06
[e03217c37f] part of check-in [83dc1ff7fa] Further optimizations for fts5 prefix queries without a prefix index. (check-in: [83dc1ff7fa] user: dan branch: trunk, size: 177193)
17:01
[6b818dd5b6] part of check-in [baec1b96cb] Allow the subsitute character (codepoint 26 - 0x1A) to appear in fts5 barewords. (check-in: [baec1b96cb] user: dan branch: trunk, size: 177358)
13:24
[3bc8a522f2] part of check-in [f20f9f813f] Add tests for fts5 phrase queries with column filters. (check-in: [f20f9f813f] user: dan branch: trunk, size: 177302)
09:02
[f1465ed954] part of check-in [accdc98b12] Add further tests for fts5 prefix queries. (check-in: [accdc98b12] user: dan branch: trunk, size: 177621)
2015-10-06
20:53
[11687c4890] part of check-in [bf1607ac15] Optimizations for fts5 expressions that filter on column. More still to come. (check-in: [bf1607ac15] user: dan branch: trunk, size: 177633)
2015-10-05
19:41
[ca3912a44e] part of check-in [f2f0184e9e] Improve performance of prefix queries without a prefix index on fts5 tables. (check-in: [f2f0184e9e] user: dan branch: trunk, size: 174628)
2015-10-02
20:04
[00d2593f94] 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: 173805)
2015-09-29
12:19
[c77882ab38] part of check-in [3a9f076250] Fix an off-by-one error in test function fts5_decode(). (check-in: [3a9f076250] user: dan branch: trunk, size: 173010)
2015-09-15
14:39
[4fdbc0a321] part of check-in [1d018c35b9] Add test cases to cover fts5 integrity-check code. (check-in: [1d018c35b9] user: dan branch: trunk, size: 173010)
11:58
[437c907fec] part of check-in [b26d8f79c6] Fix a problem with fts5 "ORDER BY rowid DESC" queries and large terms. (check-in: [b26d8f79c6] user: dan branch: trunk, size: 173037)
2015-09-14
19:51
[fae675f4d6] part of check-in [c1f76686ce] Improve test coverage of fts5_index.c. (check-in: [c1f76686ce] user: dan branch: trunk, size: 172763)
2015-09-11
18:05
[62a682a70e] part of check-in [bfc7b84b76] Fix harmless compiler warnings. (check-in: [bfc7b84b76] user: mistachkin branch: trunk, size: 173009)
14:15
[c07522cc56] part of check-in [0dc436116e] Fix some compiler warnings in fts5 code. (check-in: [0dc436116e] user: dan branch: trunk, size: 173005)
2015-09-10
16:19
[093e2e5936] part of check-in [4931e37da4] Fix a segfault in fts5 that could occur if the database contents were corrupt. (check-in: [4931e37da4] user: dan branch: fts5-incompatible, size: 173897)
15:49
[bd2b6e63c1] part of check-in [85aac7b8b6] Update description of on-disk format in fts5_index.c. (check-in: [85aac7b8b6] user: dan branch: fts5-incompatible, size: 173847)
10:01
[5d59a136b7] part of check-in [ffe2796ac9] Fix an fts5 problem that could occur if a term and the first associated rowid are on different leaf pages. (check-in: [ffe2796ac9] user: dan branch: fts5-incompatible, size: 175751)
05:40
[a13a652f04] part of check-in [fab245bea4] Change the array of 16-bit offsets at the end of each page to an array of varints. (check-in: [fab245bea4] user: dan branch: fts5-incompatible, size: 175645)
2015-09-08
19:55
[677c859b20] 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: 175718)
2015-09-07
08:14
[213e5aea27] part of check-in [67ff5ae813] Use macros to make the code in fts5_index.c easier to read. (check-in: [67ff5ae813] user: dan branch: fts5-incompatible, size: 175218)
2015-09-05
19:52
[c34a64666c] part of check-in [a1f4c3b543] Experiment with a different fts5 leaf page format that allows faster seeks. (check-in: [a1f4c3b543] user: dan branch: fts5-incompatible, size: 175127)
2015-09-04
11:13
[950e37028c] part of check-in [d648ddd93d] Enhance showfts5.tcl so that it can optionally display the number of terms in each segment. (check-in: [d648ddd93d] user: dan branch: trunk, size: 169800)
2015-09-03
14:22
[febb681733] part of check-in [59ae30b97b] Remove some more code from fts5_index.c by consolidating similar functions. (check-in: [59ae30b97b] user: dan branch: fts5-incompatible, size: 169800)
11:17
[df98f39c0f] part of check-in [8a0a9b01e7] Remove dead code from fts5_index.c. (check-in: [8a0a9b01e7] user: dan branch: fts5-incompatible, size: 170843)
2015-08-06
03:19
[076c4995bf] part of check-in [0ddb2532b2] Fix harmless compiler warnings in FTS5 code. (check-in: [0ddb2532b2] user: mistachkin branch: fts5NoWarn, size: 176824)
2015-08-05
19:35
[28718af591] 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: 176901)
07:43
[67def0a695] 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: 176888)
2015-07-27
12:19
[f5b25da3a2] part of check-in [9f1dcdc3e1] Merge the fts5-btree-index branch with this one. FTS5 changes only. (check-in: [9f1dcdc3e1] user: dan branch: trunk, size: 176890)
11:43
[02b4d8b0ca] part of check-in [427bf09ba4] Minor tweak to the SQL schema used by fts5. (check-in: [427bf09ba4] user: dan branch: fts5-btree-index, size: 176839)
10:46
[e0580e54ce] part of check-in [5ec933c257] Merge latest trunk changes with this branch. (check-in: [5ec933c257] user: dan branch: fts5-btree-index, size: 176876)
2015-07-24
20:34
[892c13a7f4] part of check-in [bd4f156d07] Fix warnings in fts5 code. (check-in: [bd4f156d07] user: dan branch: trunk, size: 180535)
2015-07-16
20:24
[60c688801c] part of check-in [7190d79ba4] Merge trunk changes, including fixes for compiler warnings in fts5 code, with this branch. (check-in: [7190d79ba4] user: dan branch: fts5-btree-index, size: 176852)
20:17
[d6ad929328] part of check-in [e9bf275cd9] Fix compiler warnings in fts5 code. (check-in: [e9bf275cd9] user: dan branch: trunk, size: 180511)
2015-07-15
19:46
[7fe8e8afdb] part of check-in [862418e350] Use a WITHOUT ROWID table to index fts5 btree leaves. This is faster to query and only slightly larger than storing btree nodes within an intkey table. (check-in: [862418e350] user: dan branch: fts5-btree-index, size: 176910)
2015-07-14
17:18
[cfd41d4959] part of check-in [3de030c904] Fix some harmless compiler warnings. (check-in: [3de030c904] user: mistachkin branch: trunk, size: 180569)
2015-07-09
20:46
[1a1fd996df] part of check-in [b2de77a01c] Improve the performance of docid merges in fts5. (check-in: [b2de77a01c] user: dan branch: trunk, size: 180595)
19:02
[ba397fe86f] part of check-in [898618ccf6] Reduce the number of calls to malloc() made by fts5. (check-in: [898618ccf6] user: dan branch: trunk, size: 179670)
2015-07-07
19:35
[ab14b8a273] part of check-in [6ace73541a] Merge the Fts5MultiSegIter and Fts5IndexIter objects. (check-in: [6ace73541a] user: dan branch: trunk, size: 178098)
08:29
[19f6db2a43] part of check-in [f37899686c] Further optimizations for fts5 b-tree seeks. (check-in: [f37899686c] user: dan branch: trunk, size: 178040)
2015-07-06
20:27
[d81cada836] part of check-in [7b7da1eb43] Speed up seek operations on fts5 b-tree structures. (check-in: [7b7da1eb43] user: dan branch: trunk, size: 177218)
2015-07-04
18:44
[6224454702] part of check-in [8cf02090ce] Optimize seek operations on fts5 b-trees. (check-in: [8cf02090ce] user: dan branch: trunk, size: 174644)
15:35
[6564c10314] part of check-in [4e473559c9] Fix a problem in the fts5 integrity-check. (check-in: [4e473559c9] user: dan branch: trunk, size: 171810)
2015-07-03
20:47
[50f137bc97] part of check-in [0778825d0e] Rework the Fts5MultiSegIter structure a bit to make it more efficient. (check-in: [0778825d0e] user: dan branch: trunk, size: 171822)
19:13
[84c8aa1c22] part of check-in [3df4af5d8c] Speed up eof checks on fts5 cursors. (check-in: [3df4af5d8c] user: dan branch: trunk, size: 171877)
2015-07-02
15:52
[fb1f0de6b4] 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: 170890)
2015-06-26
18:50
[ad32235180] part of check-in [360c57bbb8] Fix some cases in the fts5 code where a corrupt database could cause a buffer overread. (check-in: [360c57bbb8] user: dan branch: fts5, size: 170948)
16:55
[0c5a5218eb] part of check-in [bfcd16089c] Merge upstream changes. Get the test fixture working with FTS5. Fix compiler warnings. (check-in: [bfcd16089c] user: mistachkin branch: fts5Msvc, size: 170574)
04:34
[11dbb41cd9] part of check-in [ef2052f81e] Initial changes to get FTS5 working with MSVC. (check-in: [ef2052f81e] user: mistachkin branch: fts5Msvc, size: 170574)
2015-06-25
20:10
[438b245e9e] 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: 170560)
2015-06-23
18:47
[707bbc0c30] part of check-in [df5ccea80e] Improve test coverage of fts5. (check-in: [df5ccea80e] user: dan branch: fts5, size: 170553)
2015-05-30
11:49
[7cea402924] part of check-in [e008c3c8e2] Remove the "#include sqlite3Int.h" from fts5Int.h. (check-in: [e008c3c8e2] user: dan branch: fts5, size: 170607)
2015-05-29
15:55
[59b8a3dfde] part of check-in [0fc0ea2092] Add syntax to fts5 used to specify that a phrase or NEAR group should match a subset of columns. For example "[col1 col2 ...] : <phrase>". (check-in: [0fc0ea2092] user: dan branch: fts5, size: 172114)
2015-05-28
14:37
[a693ba741b] part of check-in [0f9df202cc] Remove some dead code from fts5. Add auxiliary function api tests to the same. (check-in: [0f9df202cc] user: dan branch: fts5, size: 172184)
2015-05-26
18:22
[c41e4f9087] part of check-in [aef89d9f6a] Simplifications and minor optimizations to fts5 prefix queries that cannot use a prefix index. (check-in: [aef89d9f6a] user: dan branch: fts5, size: 174561)
2015-05-25
11:46
[79b8fcf40b] part of check-in [02069782f8] Avoid redundant loads from the %_data table in the fts5 code. (check-in: [02069782f8] user: dan branch: fts5, size: 175639)
2015-05-23
15:43
[985bfa5ab2] part of check-in [5165de548b] Avoid making redundant copies of position-lists within the fts5 code. (check-in: [5165de548b] user: dan branch: fts5, size: 176556)
2015-05-18
17:50
[2c4500c350] part of check-in [47dbfadb99] Improve test coverage of fts5_config.c. (check-in: [47dbfadb99] user: dan branch: fts5, size: 175380)
2015-05-15
18:13
[6e0ac5835a] part of check-in [7aea8c6d99] Improve test coverage of fts5_index.c. (check-in: [7aea8c6d99] user: dan branch: fts5, size: 175776)
12:18
[71d5ce4746] part of check-in [adee788586] Add test cases. And some fixes. (check-in: [adee788586] user: dan branch: fts5, size: 175295)
2015-05-13
17:15
[b9a3382af3] part of check-in [aa34bf666c] Change fts5 doclist-index structures to be trees instead of flat lists. This only makes a difference for databases that contain millions of instances of the same token. (check-in: [aa34bf666c] user: dan branch: fts5, size: 175310)
2015-05-08
20:21
[6a4fed2d64] part of check-in [6bf93e3b56] Add the fts5vocab module, for direct access to the fts5 index. (check-in: [6bf93e3b56] user: dan branch: fts5, size: 166889)
2015-05-07
19:29
[aa8d73d043] part of check-in [a684b5e2d9] Change to storing all keys in a single merge-tree structure instead of one main structure and a separate one for each prefix index. This is a file-format change. Also introduce a mechanism for managing file-format changes. (check-in: [a684b5e2d9] user: dan branch: fts5, size: 165906)
2015-04-28
18:35
[de588982b0] part of check-in [8e8136f2dc] Improve coverage of fts5 tests. (check-in: [8e8136f2dc] user: dan branch: fts5, size: 168804)
2015-04-27
16:21
[65d5a75b1b] part of check-in [e38e2bb637] Change the fts5 content= option so that it matches fts5 columns with the underlying table columns by name, not by their position within the CREATE TABLE statement. (check-in: [e38e2bb637] user: dan branch: fts5, size: 169045)
11:31
[5f969f5b6f] part of check-in [ffeb3ef3cf] Further tests for fts5. (check-in: [ffeb3ef3cf] user: dan branch: fts5, size: 169091)
2015-04-25
20:29
[699b716f1b] part of check-in [e5aaa01306] Improve coverage of fts5_index.c slightly. (check-in: [e5aaa01306] user: dan branch: fts5, size: 168217)
18:56
[c87369d112] part of check-in [e748651c94] Add tests for fts5. (check-in: [e748651c94] user: dan branch: fts5, size: 168040)
2015-04-24
19:41
[39810b25a0] part of check-in [8630996134] Add the "unindexed" column option to fts5. (check-in: [8630996134] user: dan branch: fts5, size: 168763)
15:56
[1663ad6a9a] part of check-in [41449f7a0b] Add extra tests for corrupt database handling in fts5. (check-in: [41449f7a0b] user: dan branch: fts5, size: 168819)
2015-04-22
20:58
[7c9615a83e] part of check-in [2dd59b5762] Add extra OOM tests for fts5. (check-in: [2dd59b5762] user: dan branch: fts5, size: 167586)
20:14
[446f70d131] part of check-in [1e5994097e] Fix problems with doclist-indexes involving very large rowids. (check-in: [1e5994097e] user: dan branch: fts5, size: 167805)
2015-04-21
20:13
[6ae86ef3f2] part of check-in [a21d60cb2a] Fix a problem in fts5fault1.test. (check-in: [a21d60cb2a] user: dan branch: fts5, size: 167939)
19:07
[abf74b5e0d] part of check-in [e50e8031d6] Fix an fts5 problem with large deletes. (check-in: [e50e8031d6] user: dan branch: fts5, size: 168537)
2015-04-20
18:48
[f840e35cce] part of check-in [2ea8f9cbe6] Fix some fts5 problems with very large position lists. (check-in: [2ea8f9cbe6] user: dan branch: fts5, size: 168365)
2015-04-15
18:49
[28f1bfadf3] part of check-in [50fae1f000] Logically store updates as (insert+delete) within the FTS tree. This allows keys to be annihilated more quickly under some circumstances. (check-in: [50fae1f000] user: dan branch: fts5, size: 167654)
16:01
[9556d405a1] part of check-in [b29109a083] Fix a problem preventing doclist indexes from being loaded. (check-in: [b29109a083] user: dan branch: fts5, size: 168229)
2015-04-14
20:15
[ba7680d0c6] part of check-in [9341c070bb] Begin changing fts5 to use a delete flag so that delete markers may be annihilated more quickly. (check-in: [9341c070bb] user: dan branch: fts5, size: 168291)
2015-04-11
18:25
[670a428c51] part of check-in [bdb8e82ab6] Have fts5 integrity check verify that prefix indexes contain the same values as returned by prefix queries on the main terms index. (check-in: [bdb8e82ab6] user: dan branch: fts5, size: 165974)
16:23
[5eea88e464] part of check-in [49c1e74522] Improve fts5 integrity-check so that it checks that DESC queries return the same as ASC. Change the poslist format slightly to make room for a delete-flag. (check-in: [49c1e74522] user: dan branch: fts5, size: 165278)
2015-03-21
15:37
[4adc5e18ab] part of check-in [ce972f6aab] When scanning the full-text index as part of the fts5 integrity-check, also run a point query for every term and verify that these results are consistent with those found by the linear scan. (check-in: [ce972f6aab] user: dan branch: fts5, size: 164104)
2015-03-10
19:24
[b00f7147f9] part of check-in [5c46820d9b] Avoid redundant string comparisons while merging fts5 segment b-trees. (check-in: [5c46820d9b] user: dan branch: fts5, size: 162217)
2015-03-07
15:46
[3eb8db82d0] part of check-in [cccee7b5b1] Fix some compiler warnings caused by signed/unsigned pointer conversions. (check-in: [cccee7b5b1] user: dan branch: fts5, size: 158430)
2015-03-04
08:29
[db8dc4cf90] part of check-in [a5d5468c05] Fix a couple of build problems. (check-in: [a5d5468c05] user: dan branch: fts5, size: 158420)
2015-02-27
09:41
[deb7a5b73c] part of check-in [a07dcca9ef] Further minor optimizations to flushing fts5 data to disk. (check-in: [a07dcca9ef] user: dan branch: fts5, size: 158361)
07:23
[1454957255] part of check-in [bb104b3646] Fix suffix and prefix compression of terms in top-level fts5 segments. And a crash that could follow an OOM condition. (check-in: [bb104b3646] user: dan branch: fts5, size: 158135)
2015-02-26
20:49
[7a9de0c033] part of check-in [8e3ca6323a] Optimize copying data from fts5 in-memory hash tables to top level segments. (check-in: [8e3ca6323a] user: dan branch: fts5, size: 157694)
14:54
[97ce5c919b] part of check-in [208e3cb6b6] Fix an fts5 bug in large incremental merges. (check-in: [208e3cb6b6] user: dan branch: fts5, size: 154413)
2015-02-25
19:24
[220321d06a] part of check-in [7eb022d7e5] Instead of the 4-byte fields, use regular varints for the poslist-size field in fts5_hash.c. (check-in: [7eb022d7e5] user: dan branch: fts5, size: 154286)
2015-02-02
11:32
[beced7a9f3] part of check-in [fb10bbb9f9] Fix some problems with building fts5 and fts3 together using the amalgamation. (check-in: [fb10bbb9f9] user: dan branch: fts5, size: 154098)
2015-01-31
15:23
[3239fa41b0] part of check-in [1fffe51fa9] Minor optimizations to fts5 writes. (check-in: [1fffe51fa9] user: dan branch: fts5, size: 154101)
2015-01-29
20:59
[1550befd96] part of check-in [0e225b1535] Fix some problems with transactions that both read and write an fts5 table. (check-in: [0e225b1535] user: dan branch: fts5, size: 153979)
2015-01-27
20:41
[ef6c7764a9] part of check-in [f704bc059e] Fix a problem with fts5 doclist-indexes that occured if the first rowid of the first non-term page of a doclist is zero. (check-in: [f704bc059e] user: dan branch: fts5, size: 150820)
2015-01-24
19:57
[b3e8e38c70] part of check-in [5206ca6005] 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. (check-in: [5206ca6005] user: dan branch: fts5, size: 149489)
2015-01-23
17:43
[dda2ed8dab] part of check-in [51444f67c0] Fix compression of keys stored on internal segment b-tree nodes by fts5. (check-in: [51444f67c0] user: dan branch: fts5, size: 149334)
06:50
[604e346f7a] part of check-in [939b7a5de2] Remove some redundant code from fts5. (check-in: [939b7a5de2] user: dan branch: fts5, size: 148167)
2015-01-22
19:13
[ee7b141add] part of check-in [5b29589715] Add further tests and fixes for fts5. (check-in: [5b29589715] user: dan branch: fts5, size: 148817)
2015-01-21
20:30
[baf26bfee5] part of check-in [c020a291ed] Further tests and fixes for fts5. (check-in: [c020a291ed] user: dan branch: fts5, size: 147650)
18:23
[7decfde653] part of check-in [e0d614425f] Fix an fts5 issue with loading doclist-indexes for a term that is the last thing on its leaf page. (check-in: [e0d614425f] user: dan branch: fts5, size: 147681)
16:10
[49e470a638] part of check-in [09dabb3b9e] Add further tests for fts5 backend. (check-in: [09dabb3b9e] user: dan branch: fts5, size: 147607)
2015-01-20
20:34
[8c34dd95f7] part of check-in [f45a0dc0a8] Add extra fault injection tests to fts5. (check-in: [f45a0dc0a8] user: dan branch: fts5, size: 146975)
2015-01-17
20:01
[33473b527b] part of check-in [f30afd209a] Ensure an up to date copy of the fts5 configuration has been loaded into memory before attempting to modify the same configuration. (check-in: [f30afd209a] user: dan branch: fts5, size: 146924)
2015-01-13
17:25
[6f9f98875b] part of check-in [af8d43a4a0] Fix prefix indexes so that they work in characters, not bytes. (check-in: [af8d43a4a0] user: dan branch: fts5, size: 146750)
2015-01-07
19:33
[ea36c1e42a] part of check-in [e749be563d] Add the fts5 'optimize' command. (check-in: [e749be563d] user: dan branch: fts5, size: 143964)
17:11
[4e612b2c91] part of check-in [0cb2fed525] Add the 'rebuild' and 'delete-all' commands. (check-in: [0cb2fed525] user: dan branch: fts5, size: 142262)
2015-01-06
19:08
[b58bcfba3f] part of check-in [65f0262fb8] Remove the iPos parameter from the tokenizer callback. Fix the "tokenchars" and "separators" options on the simple tokenizer. (check-in: [65f0262fb8] user: dan branch: fts5, size: 141954)
14:38
[a0f370b784] part of check-in [ce6a899baf] Further fixes and test cases related to external content tables. (check-in: [ce6a899baf] user: dan branch: fts5, size: 141941)
2014-12-18
20:01
[4a8e8535b4] part of check-in [38b3c65e3e] Fix a problem with prefix queries and the AND operator. (check-in: [38b3c65e3e] user: dan branch: fts5, size: 140725)
18:25
[13b6d002e1] part of check-in [e358c3de5c] Fix various problems in fts5 revealed by fault-injection tests. (check-in: [e358c3de5c] user: dan branch: fts5, size: 140252)
2014-12-03
17:27
[9233b8b1f5] part of check-in [2037dba62f] Begin testing fts5 OOM and IO error handling. (check-in: [2037dba62f] user: dan branch: fts5, size: 139398)
2014-11-28
20:01
[7e7023f3a2] part of check-in [bb4a37b53d] Add a cookie mechanism to ensure that the %_config table is re-read as required. (check-in: [bb4a37b53d] user: dan branch: fts5, size: 138805)
2014-11-27
20:03
[5cb71b3922] part of check-in [83491c5666] Add a %_config table to fts5. (check-in: [83491c5666] user: dan branch: fts5, size: 137436)
2014-11-24
16:24
[998c4aa0f0] part of check-in [059092379f] Add the auxiliary highlight() function to fts5. (check-in: [059092379f] user: dan branch: fts5, size: 137556)
2014-08-18
19:30
[3f4d84a176] part of check-in [2397404e15] Add an "automerge=0" mode that disables auto-merging and falls back to fts4-style crisis merges. (check-in: [2397404e15] user: dan branch: fts5, size: 137542)
2014-08-12
08:36
[0453bb593f] part of check-in [f1cb48f412] Automatically resize the hash table used by fts5. (check-in: [f1cb48f412] user: dan branch: fts5, size: 136054)
2014-08-11
20:26
[687736cba9] part of check-in [9f8d678a0e] Simplify the way position lists are copied when merging data. (check-in: [9f8d678a0e] user: dan branch: fts5, size: 136012)
19:44
[ccef8703b6] part of check-in [617e2fac1c] Replace the hash table borrowed from fts3. (check-in: [617e2fac1c] user: dan branch: fts5, size: 135560)
2014-08-09
18:02
[75b2ebfa97] part of check-in [2821825f7a] Use multiple memory allocations for a single Fts5Structure object. This is probably less efficient but much easier to get right. (check-in: [2821825f7a] user: dan branch: fts5, size: 141698)
2014-08-07
18:47
[1e001ed7dd] part of check-in [ba359d78e1] Add "segment promotion" to fts5. This prevents the FTS index from growing indefinitely as data is added and deleted. (check-in: [ba359d78e1] user: dan branch: fts5, size: 141150)
2014-08-06
20:04
[dab399c67c] part of check-in [1baeb1cee6] Avoid writing delete markers to the oldest segment in an FTS index. (check-in: [1baeb1cee6] user: dan branch: fts5, size: 135263)
16:30
[6a9f851490] part of check-in [3b19eba042] Add support for savepoints to fts5. (check-in: [3b19eba042] user: dan branch: fts5, size: 134079)
2014-08-05
19:00
[40d9086948] part of check-in [d028ba6589] Use doclist-indexes with "ORDER BY rowid ASC" fts5 queries as well. (check-in: [d028ba6589] user: dan branch: fts5, size: 133232)
2014-08-04
20:07
[3578823a9a] part of check-in [90b82d3ef6] Fix fts5_index.c to use doclist-indexes when possible. Only some cases work so far. (check-in: [90b82d3ef6] user: dan branch: fts5, size: 131006)
2014-08-02
20:49
[20c905c323] part of check-in [b8864da95d] Start changing things to use doclist indexes as required. code is not activated yet. (check-in: [b8864da95d] user: dan branch: fts5, size: 122993)
2014-08-01
20:13
[13f9dd9788] part of check-in [c98934155c] Add a special case to the integrity-check code to check that the final integer in a doclist index is as expected. (check-in: [c98934155c] user: dan branch: fts5, size: 121837)
19:27
[3e33e3b86f] part of check-in [37a7d3035e] Have the fts5 integrity-check verify that doclist indexes match the contents of the leaf pages that they index. (check-in: [37a7d3035e] user: dan branch: fts5, size: 120760)
11:16
[618d54ecf4] part of check-in [89377421ff] Add "doclist index" records to the database. These are to make navigating within very large doclists faster. They are not yet used by queries. (check-in: [89377421ff] user: dan branch: fts5, size: 118387)
2014-07-21
11:44
[68d2d41b5c] part of check-in [19504c4108] Fix the xColumnSize() extension API. (check-in: [19504c4108] user: dan branch: fts5, size: 115330)
2014-07-10
20:21
[9ff3008e90] part of check-in [b96b5e1669] Support "ORDER BY rowid ASC". (check-in: [b96b5e1669] user: dan branch: fts5, size: 114699)
2014-07-08
16:27
[a3084168a3] part of check-in [75ebd3cd59] Add support for prefix queries to fts5. (check-in: [75ebd3cd59] user: dan branch: fts5, size: 106903)
2014-07-03
20:39
[d8ab9712e3] part of check-in [250ae8d401] Add support for NEAR expressions to fts5. (check-in: [250ae8d401] user: dan branch: fts5, size: 99449)
2014-07-02
20:18
[6bb95f6a1e] part of check-in [2e5652e652] Add support for phrase queries to fts5. (check-in: [2e5652e652] user: dan branch: fts5, size: 99450)
2014-07-01
20:45
[ea3dfe56a1] part of check-in [62f2ff2041] Change the position list format so that its size in bytes is stored at the start of the list itself. (check-in: [62f2ff2041] user: dan branch: fts5, size: 101891)
2014-06-26
12:31
[c8b21d12f1] part of check-in [94eeb077d0] Fix minor problems in term matching. (check-in: [94eeb077d0] user: dan branch: fts5, size: 99190)
2014-06-25
20:28
[3e6fbae93e] part of check-in [47a9f3cc92] Begin adding query support to fts5. (check-in: [47a9f3cc92] user: dan branch: fts5, size: 98640)
2014-06-23
11:33
Added: [0548e8925a] part of check-in [1e0648dcf2] Add some code for an experimental fts5 module. Does not work yet. (check-in: [1e0648dcf2] user: dan branch: fts5, size: 93328)