/ File History
Login

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

History of ext/fts5/fts5_index.c

2020-01-23
00:08
[f25bec3c] part of check-in [8a6fe306] Fix variable declaration issue seen with MSVC. (check-in: [8a6fe306] user: mistachkin branch: trunk, size: 207821)
2019-12-24
20:51
[e3573c88] part of check-in [bae060f3] 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: [bae060f3] user: dan branch: trunk, size: 207821)
16:20
[f704b61e] part of check-in [1c0a05b0] Fix another case where malformed utf-8 was being mishandled in fts5. Fix for [df46a6f3]. (check-in: [1c0a05b0] user: dan branch: trunk, size: 207821)
15:35
[784559cf] part of check-in [4630c1ec] Fix an assert() added as part of commit [a11b393dc] that can fail if fts5 database records are corrupt. (check-in: [4630c1ec] user: dan branch: trunk, size: 207760)
14:27
[d0b7e5e7] part of check-in [a11b393d] 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: [a11b393d] user: dan branch: trunk, size: 207757)
2019-10-24
20:35
[99b77ae1] part of check-in [8d964e1c] In fts5, fix a case of overreading a buffer by 1 byte when counting characters in malformed utf-8. Fix for [dd1f67bf]. (check-in: [8d964e1c] user: dan branch: trunk, size: 206605)
2019-10-20
08:26
[d1bfebeb] part of check-in [b528bdcd] 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: [b528bdcd] user: dan branch: trunk, size: 206577)
2019-10-09
18:36
[ce199410] part of check-in [86e49720] 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: [86e49720] user: dan branch: trunk, size: 206512)
2019-10-08
13:34
[7fca0f89] part of check-in [238e0835] Fix problems with using the fts5 'rebuild' command inside a transaction that contains other updates of the same table. Fix for [e258f008]. (check-in: [238e0835] user: dan branch: trunk, size: 206598)
2019-10-07
20:36
[e35f72fb] part of check-in [8ab0aebd] 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: [8ab0aebd] user: dan branch: trunk, size: 206571)
2019-09-18
11:46
[6601d085] part of check-in [6b6751cd] Fix a "jump depends on unititialized value" valgrind error in fts5 triggered by corrupt database records. (check-in: [6b6751cd] user: dan branch: trunk, size: 206548)
2019-08-29
14:25
[b062bdb8] part of check-in [c465d0eb] Fix a potential buffer overrun in fts5 caused by corrupted database records. (check-in: [c465d0eb] user: dan branch: trunk, size: 206534)
2019-08-24
17:11
[ada76610] part of check-in [156d6128] Fix a potential buffer overrun in fts5 caused by corrupt database records. (check-in: [156d6128] user: dan branch: trunk, size: 206298)
2019-07-25
19:29
[cd363c2f] part of check-in [16472112] Fix a potential buffer overread in fts5 triggered by a corrupt database record. (check-in: [16472112] user: dan branch: trunk, size: 206084)
2019-05-24
11:55
[5a89e034] part of check-in [600daa9c] Fix an fts5 segfault that could occur after parsing a corrupt structure record. (check-in: [600daa9c] user: dan branch: trunk, size: 206051)
2019-05-14
11:33
[f417615c] part of check-in [8be8bd0d] Fix an assert() and potential buffer overrun in fts5 that could occur if the database was corrupt. (check-in: [8be8bd0d] user: dan branch: trunk, size: 206029)
2019-05-13
11:52
[eb606426] part of check-in [f158c048] Fix an assert() failure in fts5 that could occur when processing a corrupt database. (check-in: [f158c048] user: dan branch: trunk, size: 205659)
2019-04-13
14:07
[9146da94] part of check-in [c28c973a] Fixes for harmless compiler warnings. (check-in: [c28c973a] user: drh branch: trunk, size: 205425)
2019-04-06
15:38
[8a3ef6f2] part of check-in [edb095a9] Fix two assert() statements in fts5 that are only true if the database is not corrupt. (check-in: [edb095a9] user: dan branch: trunk, size: 205422)
2019-03-19
20:13
[865302c4] part of check-in [d5acf3af] Fix a compiler warning in FTS5. (check-in: [d5acf3af] user: drh branch: trunk, size: 205416)
2019-03-18
15:23
[39b59af9] part of check-in [45c73deb] Fix an fts5 problem with interleaving reads and writes in a single transaction. (check-in: [45c73deb] user: dan branch: trunk, size: 205411)
2019-02-11
16:12
[6589ccac] part of check-in [09e33738] Fix another segfault that could occur in fts5 with a corrupted database. (check-in: [09e33738] user: dan branch: trunk, size: 205278)
2019-02-04
14:00
[ffff7e8d] part of check-in [14fba4cc] Fix another potential buffer overread in fts5. (check-in: [14fba4cc] user: dan branch: trunk, size: 205247)
11:54
[688b61d5] part of check-in [e608085d] Fix another corruption case in fts5. (check-in: [e608085d] user: dan branch: trunk, size: 205139)
2019-02-02
13:47
[2e8d2ff0] part of check-in [54f2399f] Fix a buffer overread in fts5 debugging scalar function fts5_decode(). (check-in: [54f2399f] user: dan branch: trunk, size: 205097)
2019-02-01
14:40
[7e8e678f] part of check-in [55f06aa3] Fix an assert() in fts5 that could fail if the database is corrupt. (check-in: [55f06aa3] user: dan branch: trunk, size: 205016)
13:34
[9e9607d9] part of check-in [9876ae1b] Fix another corrupt-database-handling problem in fts5. (check-in: [9876ae1b] user: dan branch: trunk, size: 205013)
2019-01-31
14:37
[a5cc612c] part of check-in [b80119bd] Fix another buffer overrun that could occur when quering a corrupt database using an fts5vocab table. (check-in: [b80119bd] user: dan branch: trunk, size: 205003)
2019-01-30
12:15
[97d84ca8] part of check-in [760d1437] Fix another buffer overread in fts5 that may occur when accessing a corrupt database. (check-in: [760d1437] user: dan branch: trunk, size: 204992)
2019-01-29
11:42
[091a8474] part of check-in [7ee3cd5b] Fix a buffer overrun triggered by a merge operation on a corrupt fts5 database. (check-in: [7ee3cd5b] user: dan branch: trunk, size: 204900)
2019-01-25
16:54
[ae9b5af6] part of check-in [93f8ec14] 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: [93f8ec14] user: dan branch: trunk, size: 204900)
2019-01-23
19:17
[9f2eaae4] part of check-in [44ce8baa] Fix another fts5 crash that can occur if the database is corrupted. (check-in: [44ce8baa] user: dan branch: trunk, size: 204875)
12:19
[13e7ef56] part of check-in [1d8172a9] Fix a buffer overwrite triggered by a prefix query on a corrupt fts5 table. (check-in: [1d8172a9] user: dan branch: trunk, size: 204428)
2019-01-22
21:17
[ae896f59] part of check-in [1abc4415] Fix a buffer overrun that could occur in fts5 if a prefix query is made on a corrupt database. (check-in: [1abc4415] user: dan branch: trunk, size: 204386)
2019-01-17
20:06
[53e064ad] part of check-in [4538d9af] Fix another corruption related crash in fts5. (check-in: [4538d9af] user: dan branch: trunk, size: 204365)
19:11
[21aec481] part of check-in [3910b563] Fix a buffer overwrite that could occur when running an fts5 prefix query against a corrupt database. (check-in: [3910b563] user: dan branch: trunk, size: 204361)
2019-01-12
20:55
[ba68cfbd] part of check-in [726e398b] Fix another problem with handling corrupt records in fts5_decode(). (check-in: [726e398b] user: dan branch: trunk, size: 204242)
00:45
[d1d037dc] part of check-in [b74e5f3f] Improved detection of shadow table corruption in the fts5_decode() SQL function. (check-in: [b74e5f3f] user: drh branch: trunk, size: 204159)
2019-01-10
19:26
[7e617122] part of check-in [240f1c0c] Fix a memory leak in fts5 that could occur if scalar function fts5_decode() was passed a corrupt record. (check-in: [240f1c0c] user: dan branch: trunk, size: 204011)
18:35
[89ebc3ca] part of check-in [ff3b011f] Fix a memory leak in fts5. (check-in: [ff3b011f] user: dan branch: trunk, size: 204031)
17:08
[ec0ca720] part of check-in [3291b2a6] 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: [3291b2a6] user: dan branch: trunk, size: 204060)
15:17
[8663717e] part of check-in [83c467d7] Fix further problems with fts5 handling corrupt databases. (check-in: [83c467d7] user: dan branch: trunk, size: 204206)
2019-01-09
21:12
[a84ed47b] part of check-in [931278b2] Fix an out-of-bounds read in SQL function fts5_decode() that could occur if it was passed a corrupt record. (check-in: [931278b2] user: dan branch: trunk, size: 204121)
2019-01-08
20:02
[8e734f85] part of check-in [ca67f2ec] Use 64-bit math to compute the sizes of memory allocations in extensions. (check-in: [ca67f2ec] user: drh branch: trunk, size: 204010)
08:02
[7788ae02] part of check-in [673a7dd6] Fix further problems with fts5 and corrupt databases causing integer overflow. (check-in: [673a7dd6] user: dan branch: trunk, size: 203919)
2019-01-05
07:17
[7d93b950] part of check-in [444c7c99] Fix two more problems with corrupt database handling in fts5. (check-in: [444c7c99] user: dan branch: trunk, size: 203919)
2019-01-04
11:20
[70b147a2] part of check-in [0888fc2e] Fix another fts5 assert() that may fail if the database is corrupt. (check-in: [0888fc2e] user: dan branch: trunk, size: 203919)
2019-01-03
19:12
[6694a1ee] part of check-in [c0eb839a] Fix some problems with sqlite3_interrupt() handling in fts5. (check-in: [c0eb839a] user: dan branch: trunk, size: 203916)
2019-01-01
19:17
[d4b950ba] part of check-in [911342f7] Fix another fts5 problem caused by a corrupt database. (check-in: [911342f7] user: dan branch: trunk, size: 203749)
13:59
[2a0d5da3] part of check-in [f7e6cdc5] Fix another case in fts5 where a corrupt database could cause a buffer overread. (check-in: [f7e6cdc5] user: dan branch: trunk, size: 203613)
2018-12-28
18:09
[2fdfbf41] part of check-in [c4d44542] Fix another problem with loading the structure record from a corrupt fts5 database. (check-in: [c4d44542] user: dan branch: trunk, size: 203524)
13:57
[44d6829c] part of check-in [a385298d] Fix a buffer overwrite in fts5 triggered by a corrupt database. (check-in: [a385298d] user: dan branch: trunk, size: 203491)
07:37
[c67a3bf1] part of check-in [c564bf87] Fix problems in fts5 found by ASAN. (check-in: [c564bf87] user: dan branch: trunk, size: 203469)
2018-12-27
20:12
[f3601579] part of check-in [fb0d7fba] Fix another problem with corrupt database handling in fts5. (check-in: [fb0d7fba] user: dan branch: trunk, size: 203450)
15:36
[4b824be4] part of check-in [ff45f9dd] Fix another problem in fts5 caused by a corrupt schema record. (check-in: [ff45f9dd] user: dan branch: trunk, size: 203380)
07:46
[fb67df50] part of check-in [b0a49d5e] Fix a null-pointer dereference that could occur in fts5 with a corrupt database. (check-in: [b0a49d5e] user: dan branch: trunk, size: 203289)
2018-12-26
16:57
[d9821060] part of check-in [6cae81cd] Avoid an "uninitialized value read" problem in fts5 that can occur with a corrupt database. (check-in: [6cae81cd] user: dan branch: trunk, size: 203154)
16:04
[d6a771cf] part of check-in [9bad745d] Fix a problem with handling corrupt databases in the fts5 integrity-check function. (check-in: [9bad745d] user: dan branch: trunk, size: 203154)
2018-12-24
19:59
[3db9acb1] part of check-in [d9653380] Change another fts5 assert() that may fail with a corrupt database to an assert_nc(). (check-in: [d9653380] user: dan branch: trunk, size: 203131)
2018-12-22
19:54
[bcf2ef13] part of check-in [fb17fea4] Catch another case of a corrupted structure record in fts5. (check-in: [fb17fea4] user: dan branch: trunk, size: 203128)
19:09
[49857e56] part of check-in [1daaba9f] Change a faulty assert() in fts5 that could fail on a corrupt db to an if() statement. (check-in: [1daaba9f] user: dan branch: trunk, size: 203041)
15:21
[c8b07a53] part of check-in [83935b95] Fix an assert() in fts5 that could fail with a corrupt database. (check-in: [83935b95] user: dan branch: trunk, size: 203028)
13:34
[4c85ce5e] part of check-in [3518c09b] Fix a "jump or move depends on uninitialized value" valgrind error that could occur in fts5 when dealing with a corrupt database. (check-in: [3518c09b] user: dan branch: trunk, size: 203019)
2018-12-21
19:29
[f1f6365a] part of check-in [25666e3d] 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: [25666e3d] user: dan branch: prepare-no-vtab, size: 202988)
2018-11-12
13:20
[baf3ad44] part of check-in [ac69d169] Fix a use-after-free problem in the fts5vocab virtual table. (check-in: [ac69d169] user: dan branch: trunk, size: 203206)
2018-11-05
23:01
[ddaea9e1] part of check-in [31942b3d] 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: [31942b3d] user: drh branch: read-only-shadow, size: 203302)
2018-07-25
15:25
[d1b2d7d9] part of check-in [0e3de8ab] Fix a buffer overread in fts5. (check-in: [0e3de8ab] user: dan branch: trunk, size: 203197)
2018-02-07
18:02
[22b71d0e] part of check-in [2a5f813b] 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: [2a5f813b] user: dan branch: trunk, size: 203150)
2017-12-11
17:20
[5fe14375] part of check-in [92fc146b] Fix a buffer overwrite in fts5 that could occur when processing a prefix query. (check-in: [92fc146b] user: dan branch: trunk, size: 202993)
2017-06-28
17:29
[93ecfc0d] part of check-in [942c3ef8] 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: [942c3ef8] user: drh branch: dbconfig-prepare-flags, size: 202715)
2017-06-01
00:54
[2ce9d50e] part of check-in [4a25c588] 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: [4a25c588] user: drh branch: prepare_v3, size: 202573)
2017-05-19
12:32
[cdceac47] part of check-in [35f72104] Fix some problems in fts5 code detected by -fsanitize=undefined. (check-in: [35f72104] user: dan branch: trunk, size: 202456)
2017-05-11
18:14
[9ce10106] part of check-in [9a2de4f0] 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: [9a2de4f0] user: dan branch: trunk, size: 202418)
2017-04-21
16:04
[dc25123d] part of check-in [840042cb] 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: [840042cb] user: dan branch: trunk, size: 202242)
2017-04-12
17:50
[551add2b] part of check-in [c847543f] Update fts5 to support "<colset> : ( <expr> )" for column filtering, as well as "<colset> : NEAR(...)" and "<colset> : <phrase>". (check-in: [c847543f] user: dan branch: trunk, size: 202292)
2017-04-08
09:12
[a3a9ae1c] part of check-in [a921ada8] 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: [a921ada8] user: dan branch: trunk, size: 202227)
2017-01-06
11:55
[f67032a9] part of check-in [609ac1c7] Improve handling of corrupt data in fts5. (check-in: [609ac1c7] user: dan branch: trunk, size: 202255)
2016-11-14
08:19
[fdbe46da] part of check-in [e78f6f3b] 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: [e78f6f3b] user: dan branch: trunk, size: 202205)
2016-08-13
10:34
[2d146d5c] part of check-in [e22252e1] Fix an fts5 problem with corrupt database handling found by address-sanitizer. (check-in: [e22252e1] user: dan branch: trunk, size: 202172)
2016-08-11
01:24
[05386732] part of check-in [2ea0c8b4] Fix a harmless compiler warning in FTS5. (check-in: [2ea0c8b4] user: drh branch: trunk, size: 201861)
2016-08-09
19:26
[e25ac419] part of check-in [e5175456] Have fts5 interpret column lists that begin with a "-" character as "match any column except" lists. (check-in: [e5175456] user: dan branch: trunk, size: 201839)
2016-04-12
20:05
[b429e23f] part of check-in [ab69527c] More harmless compiler warning fixes. (check-in: [ab69527c] user: mistachkin branch: warnings, size: 201515)
2016-03-29
21:19
[870fa81c] part of check-in [7635c680] Fix some code and test coverage issues in fts5_index.c. (check-in: [7635c680] user: dan branch: fts5, size: 205236)
2016-03-28
20:13
[48fed294] part of check-in [a805c6f7] Add further tests for savepoint rollback. Fix various code issues and add missing comments in fts5_index.c. (check-in: [a805c6f7] user: dan branch: fts5, size: 205180)
2016-03-26
20:11
[9019595c] part of check-in [53b80a6d] Fix a problem with OOM handling when setting an fts5 configuration option. (check-in: [53b80a6d] user: dan branch: fts5, size: 201661)
2016-03-23
15:53
[fdd82bb4] part of check-in [0ed693c2] Remove an unused local variable from FTS5. (check-in: [0ed693c2] user: drh branch: trunk, size: 201509)
15:04
[b271b19d] part of check-in [70fc69ee] Explicitly limit the size of fts5 tokens to 32768 bytes. (check-in: [70fc69ee] user: dan branch: trunk, size: 201527)
2016-03-22
15:01
[19df86d2] part of check-in [e1ab2d37] Fix some errors in fts5 test scripts. (check-in: [e1ab2d37] user: dan branch: trunk, size: 200965)
2016-03-21
22:28
[0fe734b1] part of check-in [25d776e4] Fix harmless compiler warnings. (check-in: [25d776e4] user: drh branch: trunk, size: 200979)
15:30
[40fde253] part of check-in [902f2217] 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: [902f2217] user: dan branch: trunk, size: 200983)
15:18
[39939320] part of check-in [89296a46] Rearrange code so that tests pass whether SQLITE_DEBUG is defined or not. (check-in: [89296a46] user: dan branch: fts5-data-version, size: 200373)
09:56
[d3759c2f] part of check-in [d6e2637d] Change the way fts5 internally allocates segment ids in order to eliminated non-determinism from the module. (check-in: [d6e2637d] user: dan branch: trunk, size: 198558)
2016-03-17
12:39
[afac2ffe] part of check-in [020a0bda] Fix some OOM-handling issues in the fts5 changes on this branch. (check-in: [020a0bda] user: dan branch: fts5-data-version, size: 200451)
2016-03-16
19:48
[317040cb] part of check-in [33ef2210] Have fts5 cache the decoded structure of fts5 indexes in memory. Use "PRAGMA data_version" to detect stale caches. (check-in: [33ef2210] user: dan branch: fts5-data-version, size: 200303)
2016-03-10
15:12
[d4f0c12e] part of check-in [fa0033ed] Add tests to cover untested branches in recent fts5 changes. (check-in: [fa0033ed] user: dan branch: trunk, size: 197948)
14:22
[8def6f0a] part of check-in [3c343c3d] Remove an unused local variable. (check-in: [3c343c3d] user: drh branch: trunk, size: 197966)
2016-03-09
20:54
[f7f3c042] part of check-in [55667144] Add an incremental optimize capability to fts5. Make the 'merge' command independent of the 'automerge' settings. (check-in: [55667144] user: dan branch: trunk, size: 197982)
2016-03-01
14:51
[ecc70368] part of check-in [daef5869] Fix a problem in fts5 where a corrupt db could lead to a (huge) buffer overread. Cherrypick of [c9a30e117f]. (check-in: [daef5869] user: dan branch: branch-3.11-matchinfo, size: 196510)
14:50
[a32f4059] part of check-in [5b1b7ab5] Fix an fts5 problem causing 'optimize' to corrupt the fts index under some circumstances. Cherrypick of [251d6473f7]. (check-in: [5b1b7ab5] user: dan branch: branch-3.11-matchinfo, size: 196451)
2016-02-29
17:34
[26a4a611] part of check-in [c9a30e11] Fix a problem in fts5 where a corrupt db could lead to a (huge) buffer overread. (check-in: [c9a30e11] user: dan branch: trunk, size: 196514)
17:16
[745bc6f0] part of check-in [251d6473] Fix an fts5 problem causing 'optimize' to corrupt the fts index under some circumstances. (check-in: [251d6473] user: dan branch: trunk, size: 196455)
2016-02-15
23:46
[78069efb] part of check-in [e52c9075] Fix a harmless compiler warning in FTS5. (check-in: [e52c9075] user: drh branch: trunk, size: 196264)
2016-02-11
21:53
[c6cd5190] part of check-in [defc762d] Remove the unused fts5BlobCompare() routine. (check-in: [defc762d] user: drh branch: trunk, size: 196260)
18:08
[f8afd5cc] part of check-in [facbc424] Avoid a buffer overread when reading a corrupt fts5 structure record. (check-in: [facbc424] user: dan branch: trunk, size: 196501)
17:01
[12354c38] part of check-in [bc3f7900] Handle parser stack overflow when parsing fts5 query expressions. Fix some compiler warnings in fts5 code. (check-in: [bc3f7900] user: dan branch: trunk, size: 196239)
2016-02-05
21:09
[28f72130] part of check-in [22589018] Add tests for and remove unreachable branches from fts5 in order to restore test coverage. (check-in: [22589018] user: dan branch: trunk, size: 196299)
19:18
[9706959f] part of check-in [ca91bd8a] Further streamlining of fts5 prefix query code. (check-in: [ca91bd8a] user: dan branch: trunk, size: 196893)
2016-02-04
19:45
[614c5454] part of check-in [c9c6457d] Further improve performance of unindexed fts5 prefix queries. (check-in: [c9c6457d] user: dan branch: trunk, size: 195979)
2016-02-03
20:04
[e634a4a0] part of check-in [ca11f46d] Improve performance of fts5 prefix queries on detail=col tables. (check-in: [ca11f46d] user: dan branch: trunk, size: 195415)
2016-02-02
17:40
[471ff693] part of check-in [62ea9e5a] Enhance the performance of fts5 AND and OR queries. (check-in: [62ea9e5a] user: dan branch: trunk, size: 196623)
2016-01-30
19:16
[cd1e4fac] part of check-in [13fb4aa6] Performance enhancement for fts5 column filter queries on detail=full tables. (check-in: [13fb4aa6] user: dan branch: trunk, size: 196941)
2016-01-26
20:08
[5558bfbe] part of check-in [b4ac61ae] Further minor performance improvements and code-size reductions related to fts5 column filters on detail=col tables. (check-in: [b4ac61ae] user: dan branch: fts5-perf, size: 196723)
19:30
[b34b7257] part of check-in [249a2d07] Improve the performance of fts5 column filters on detail=col tables. (check-in: [249a2d07] user: dan branch: fts5-perf, size: 197675)
2016-01-23
18:51
[722d8717] part of check-in [72d53699] Fix an fts5 problem with using both xPhraseFirst() and xPhraseFirstColumn() within a single statement in detail=col mode. (check-in: [72d53699] user: dan branch: fts5-perf, size: 196264)
14:45
[bd5476ed] part of check-in [7558a0ad] Fix a problem involving detail=col and column filters. (check-in: [7558a0ad] user: dan branch: fts5-perf, size: 198908)
2016-01-22
19:48
[19062d1f] part of check-in [b5a57b81] Experimental performance enhancements for fts5. (check-in: [b5a57b81] user: dan branch: fts5-perf, size: 198729)
2016-01-18
17:48
[716c3018] part of check-in [acaf4264] Add tests for fts5. Fix a crash that can occur in fts5 if the database content is corrupted. (check-in: [acaf4264] user: dan branch: trunk, size: 193017)
09:08
[5ba2a5ef] part of check-in [8358af36] Add a debugging function to print human-readable versions of fts5 detail=none leaf pages. (check-in: [8358af36] user: dan branch: trunk, size: 192987)
2016-01-15
05:39
[cd036089] part of check-in [584848d4] Fix a couple C99-isms in FTS5 that cause compile errors on MSVC. (check-in: [584848d4] user: mistachkin branch: trunk, size: 190298)
2016-01-14
14:33
[aa798d3a] part of check-in [8dedff3b] Yet another change to FTS5 trying to get it to merge successfully into sessions. (check-in: [8dedff3b] user: drh branch: trunk, size: 190288)
14:19
[140617e3] part of check-in [d17bc2c9] Fix another compiler warning in fts5 code. (check-in: [d17bc2c9] user: dan branch: trunk, size: 190296)
14:15
[11e2b566] part of check-in [5a343cc0] Fix compiler warnings in fts5. (check-in: [5a343cc0] user: dan branch: trunk, size: 190463)
2016-01-12
19:28
[5ab044a6] part of check-in [bc5118f4] Improve performance of fts5 low level iterators. (check-in: [bc5118f4] user: dan branch: fts5-offsets, size: 190487)
2016-01-06
18:53
[04fe098f] part of check-in [8d05cfd4] 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: [8d05cfd4] user: dan branch: fts5-offsets, size: 188010)
2016-01-02
19:01
[8665393f] part of check-in [6322a1d9] 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: [6322a1d9] user: dan branch: fts5-offsets, size: 188039)
2015-12-31
18:39
[a7cfe8e8] part of check-in [3a1df69e] Fix the fts5 integrity-check code so that it works with detail=none tables. (check-in: [3a1df69e] user: dan branch: fts5-offsets, size: 186756)
17:36
[40eac312] part of check-in [6a6f7bc4] Fix some problems with fts5 detail=none tables. Some still remain. (check-in: [6a6f7bc4] user: dan branch: fts5-offsets, size: 186366)
2015-12-30
19:58
[94dec3c3] part of check-in [ac8f4cf0] Updates to fts5 to support detail=none mode. As of this commit, many cases are still broken. (check-in: [ac8f4cf0] user: dan branch: fts5-offsets, size: 185633)
2015-12-29
19:35
[ca8310ea] part of check-in [8c30605b] Add the xPhraseFirstColumn() and xPhraseNextColumn() API functions to fts5. For iterating through the set of columns that contain intances of a phrase. (check-in: [8c30605b] user: dan branch: fts5-offsets, size: 182929)
2015-12-28
19:55
[24e81d8f] part of check-in [228b4d10] 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: [228b4d10] user: dan branch: fts5-offsets, size: 182581)
2015-12-21
18:45
[1d1939af] part of check-in [609a0bc7] Fix an fts5 integrity-check problem that affects offsets=0 tables with prefix indexes. (check-in: [609a0bc7] user: dan branch: fts5-offsets, size: 182468)
2015-12-18
19:07
[d862dc84] part of check-in [ad0987d8] Fix a problem with prefix queries on fts5 offsets=0 tables. (check-in: [ad0987d8] user: dan branch: fts5-offsets, size: 183288)
2015-12-17
20:36
[53b3a8f1] part of check-in [40b5bbf0] 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: [40b5bbf0] user: dan branch: fts5-offsets, size: 183199)
2015-12-16
23:30
[578f4669] part of check-in [1d0e6aa1] Fix even more harmless compiler warnings. (check-in: [1d0e6aa1] user: mistachkin branch: msvcWarn, size: 182077)
2015-11-06
12:50
[b622a0a7] part of check-in [33e6606f] 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: [33e6606f] user: dan branch: trunk, size: 182019)
2015-11-05
18:09
[967d7972] part of check-in [44548009] Add the 'hashsize' configuration option to fts5, for configuring the amount of memory allocated to the in-memory hash table while writing. (check-in: [44548009] user: dan branch: trunk, size: 182115)
2015-10-27
17:48
[356481ce] part of check-in [3b5758c6] Fix problems with prefix queries in fts5. (check-in: [3b5758c6] user: dan branch: trunk, size: 182130)
2015-10-21
22:08
[2bd3cb65] part of check-in [aa4e01ea] Fix harmless compiler warnings in FTS5. (check-in: [aa4e01ea] user: mistachkin branch: trunk, size: 181842)
20:56
[ffb95101] part of check-in [ae350bfb] Remove some branches made unreachable by recent changes from fts5. (check-in: [ae350bfb] user: dan branch: trunk, size: 181788)
20:07
[47ef0002] part of check-in [363b36d5] Minor optimization for fts5 queries. (check-in: [363b36d5] user: dan branch: trunk, size: 181601)
2015-10-20
23:27
[d3503c75] part of check-in [0a903ec2] Fix harmless compiler warnings in FTS5. (check-in: [0a903ec2] user: mistachkin branch: trunk, size: 181252)
21:05
[45856922] part of check-in [b8fb263e] More optimizations for fts5 prefix queries. (check-in: [b8fb263e] user: dan branch: trunk, size: 181248)
19:55
[903ca7a8] part of check-in [1f5f5804] Fix #line directives added to generated file fts5.c. (check-in: [1f5f5804] user: dan branch: trunk, size: 180440)
2015-10-19
20:49
[38d7ddd4] part of check-in [60a8bde0] Another optimization for fts5 prefix (and other) queries. (check-in: [60a8bde0] user: dan branch: trunk, size: 180444)
17:43
[8468e418] part of check-in [69be427c] Another tweak to improve performance of fts5 prefix queries. (check-in: [69be427c] user: dan branch: trunk, size: 180450)
2015-10-17
19:49
[632fdcb1] part of check-in [6020d96a] 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: [6020d96a] user: dan branch: trunk, size: 180250)
2015-10-14
21:08
[c76d636d] part of check-in [f4de6d45] Tests and minor fixes to improve coverage of FTS5 code. (check-in: [f4de6d45] user: dan branch: trunk, size: 180284)
20:34
[3e5582db] part of check-in [1c46c194] Fix harmless compiler warnings. (check-in: [1c46c194] user: mistachkin branch: trunk, size: 180245)
2015-10-12
19:12
[f7396835] part of check-in [1c20c1c2] Further tweaks to improve fts5 prefix query performance. (check-in: [1c20c1c2] user: dan branch: trunk, size: 180216)
2015-10-07
19:06
[e03217c3] part of check-in [83dc1ff7] Further optimizations for fts5 prefix queries without a prefix index. (check-in: [83dc1ff7] user: dan branch: trunk, size: 177193)
17:01
[6b818dd5] part of check-in [baec1b96] Allow the subsitute character (codepoint 26 - 0x1A) to appear in fts5 barewords. (check-in: [baec1b96] user: dan branch: trunk, size: 177358)
13:24
[3bc8a522] part of check-in [f20f9f81] Add tests for fts5 phrase queries with column filters. (check-in: [f20f9f81] user: dan branch: trunk, size: 177302)
09:02
[f1465ed9] part of check-in [accdc98b] Add further tests for fts5 prefix queries. (check-in: [accdc98b] user: dan branch: trunk, size: 177621)
2015-10-06
20:53
[11687c48] part of check-in [bf1607ac] Optimizations for fts5 expressions that filter on column. More still to come. (check-in: [bf1607ac] user: dan branch: trunk, size: 177633)
2015-10-05
19:41
[ca3912a4] part of check-in [f2f0184e] Improve performance of prefix queries without a prefix index on fts5 tables. (check-in: [f2f0184e] user: dan branch: trunk, size: 174628)
2015-10-02
20:04
[00d2593f] part of check-in [5c83b9db] Update fts5 to avoid using a statement journal for UPDATE and DELETE operations that affect at most a single row. (check-in: [5c83b9db] user: dan branch: trunk, size: 173805)
2015-09-29
12:19
[c77882ab] part of check-in [3a9f0762] Fix an off-by-one error in test function fts5_decode(). (check-in: [3a9f0762] user: dan branch: trunk, size: 173010)
2015-09-15
14:39
[4fdbc0a3] part of check-in [1d018c35] Add test cases to cover fts5 integrity-check code. (check-in: [1d018c35] user: dan branch: trunk, size: 173010)
11:58
[437c907f] part of check-in [b26d8f79] Fix a problem with fts5 "ORDER BY rowid DESC" queries and large terms. (check-in: [b26d8f79] user: dan branch: trunk, size: 173037)
2015-09-14
19:51
[fae675f4] part of check-in [c1f76686] Improve test coverage of fts5_index.c. (check-in: [c1f76686] user: dan branch: trunk, size: 172763)
2015-09-11
18:05
[62a682a7] part of check-in [bfc7b84b] Fix harmless compiler warnings. (check-in: [bfc7b84b] user: mistachkin branch: trunk, size: 173009)
14:15
[c07522cc] part of check-in [0dc43611] Fix some compiler warnings in fts5 code. (check-in: [0dc43611] user: dan branch: trunk, size: 173005)
2015-09-10
16:19
[093e2e59] part of check-in [4931e37d] Fix a segfault in fts5 that could occur if the database contents were corrupt. (check-in: [4931e37d] user: dan branch: fts5-incompatible, size: 173897)
15:49
[bd2b6e63] part of check-in [85aac7b8] Update description of on-disk format in fts5_index.c. (check-in: [85aac7b8] user: dan branch: fts5-incompatible, size: 173847)
10:01
[5d59a136] part of check-in [ffe2796a] Fix an fts5 problem that could occur if a term and the first associated rowid are on different leaf pages. (check-in: [ffe2796a] user: dan branch: fts5-incompatible, size: 175751)
05:40
[a13a652f] part of check-in [fab245be] Change the array of 16-bit offsets at the end of each page to an array of varints. (check-in: [fab245be] user: dan branch: fts5-incompatible, size: 175645)
2015-09-08
19:55
[677c859b] part of check-in [00d99006] Remove the 0x00 terminators from the end of fts5 doclists stored on disk. (check-in: [00d99006] user: dan branch: fts5-incompatible, size: 175718)
2015-09-07
08:14
[213e5aea] part of check-in [67ff5ae8] Use macros to make the code in fts5_index.c easier to read. (check-in: [67ff5ae8] user: dan branch: fts5-incompatible, size: 175218)
2015-09-05
19:52
[c34a6466] part of check-in [a1f4c3b5] Experiment with a different fts5 leaf page format that allows faster seeks. (check-in: [a1f4c3b5] user: dan branch: fts5-incompatible, size: 175127)
2015-09-04
11:13
[950e3702] part of check-in [d648ddd9] Enhance showfts5.tcl so that it can optionally display the number of terms in each segment. (check-in: [d648ddd9] user: dan branch: trunk, size: 169800)
2015-09-03
14:22
[febb6817] part of check-in [59ae30b9] Remove some more code from fts5_index.c by consolidating similar functions. (check-in: [59ae30b9] user: dan branch: fts5-incompatible, size: 169800)
11:17
[df98f39c] part of check-in [8a0a9b01] Remove dead code from fts5_index.c. (check-in: [8a0a9b01] user: dan branch: fts5-incompatible, size: 170843)
2015-08-06
03:19
[076c4995] part of check-in [0ddb2532] Fix harmless compiler warnings in FTS5 code. (check-in: [0ddb2532] user: mistachkin branch: fts5NoWarn, size: 176824)
2015-08-05
19:35
[28718af5] part of check-in [9e3aafe4] Add tests for the matchinfo-like test function. Fix problems found in test and fts5 code by doing so. (check-in: [9e3aafe4] user: dan branch: trunk, size: 176901)
07:43
[67def0a6] part of check-in [dffd358f] Remove all references to "docid" within fts5 source code and comments. Replace with "rowid". (check-in: [dffd358f] user: dan branch: trunk, size: 176888)
2015-07-27
12:19
[f5b25da3] part of check-in [9f1dcdc3] Merge the fts5-btree-index branch with this one. FTS5 changes only. (check-in: [9f1dcdc3] user: dan branch: trunk, size: 176890)
11:43
[02b4d8b0] part of check-in [427bf09b] Minor tweak to the SQL schema used by fts5. (check-in: [427bf09b] user: dan branch: fts5-btree-index, size: 176839)
10:46
[e0580e54] part of check-in [5ec933c2] Merge latest trunk changes with this branch. (check-in: [5ec933c2] user: dan branch: fts5-btree-index, size: 176876)
2015-07-24
20:34
[892c13a7] part of check-in [bd4f156d] Fix warnings in fts5 code. (check-in: [bd4f156d] user: dan branch: trunk, size: 180535)
2015-07-16
20:24
[60c68880] part of check-in [7190d79b] Merge trunk changes, including fixes for compiler warnings in fts5 code, with this branch. (check-in: [7190d79b] user: dan branch: fts5-btree-index, size: 176852)
20:17
[d6ad9293] part of check-in [e9bf275c] Fix compiler warnings in fts5 code. (check-in: [e9bf275c] user: dan branch: trunk, size: 180511)
2015-07-15
19:46
[7fe8e8af] part of check-in [862418e3] 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: [862418e3] user: dan branch: fts5-btree-index, size: 176910)
2015-07-14
17:18
[cfd41d49] part of check-in [3de030c9] Fix some harmless compiler warnings. (check-in: [3de030c9] user: mistachkin branch: trunk, size: 180569)
2015-07-09
20:46
[1a1fd996] part of check-in [b2de77a0] Improve the performance of docid merges in fts5. (check-in: [b2de77a0] user: dan branch: trunk, size: 180595)
19:02
[ba397fe8] part of check-in [898618cc] Reduce the number of calls to malloc() made by fts5. (check-in: [898618cc] user: dan branch: trunk, size: 179670)
2015-07-07
19:35
[ab14b8a2] part of check-in [6ace7354] Merge the Fts5MultiSegIter and Fts5IndexIter objects. (check-in: [6ace7354] user: dan branch: trunk, size: 178098)
08:29
[19f6db2a] part of check-in [f3789968] Further optimizations for fts5 b-tree seeks. (check-in: [f3789968] user: dan branch: trunk, size: 178040)
2015-07-06
20:27
[d81cada8] part of check-in [7b7da1eb] Speed up seek operations on fts5 b-tree structures. (check-in: [7b7da1eb] user: dan branch: trunk, size: 177218)
2015-07-04
18:44
[62244547] part of check-in [8cf02090] Optimize seek operations on fts5 b-trees. (check-in: [8cf02090] user: dan branch: trunk, size: 174644)
15:35
[6564c103] part of check-in [4e473559] Fix a problem in the fts5 integrity-check. (check-in: [4e473559] user: dan branch: trunk, size: 171810)
2015-07-03
20:47
[50f137bc] part of check-in [0778825d] Rework the Fts5MultiSegIter structure a bit to make it more efficient. (check-in: [0778825d] user: dan branch: trunk, size: 171822)
19:13
[84c8aa1c] part of check-in [3df4af5d] Speed up eof checks on fts5 cursors. (check-in: [3df4af5d] user: dan branch: trunk, size: 171877)
2015-07-02
15:52
[fb1f0de6] part of check-in [7819002e] 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: [7819002e] user: dan branch: trunk, size: 170890)
2015-06-26
18:50
[ad322351] part of check-in [360c57bb] Fix some cases in the fts5 code where a corrupt database could cause a buffer overread. (check-in: [360c57bb] user: dan branch: fts5, size: 170948)
16:55
[0c5a5218] part of check-in [bfcd1608] Merge upstream changes. Get the test fixture working with FTS5. Fix compiler warnings. (check-in: [bfcd1608] user: mistachkin branch: fts5Msvc, size: 170574)
04:34
[11dbb41c] part of check-in [ef2052f8] Initial changes to get FTS5 working with MSVC. (check-in: [ef2052f8] user: mistachkin branch: fts5Msvc, size: 170574)
2015-06-25
20:10
[438b245e] part of check-in [46e86b06] 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: [46e86b06] user: dan branch: fts5, size: 170560)
2015-06-23
18:47
[707bbc0c] part of check-in [df5ccea8] Improve test coverage of fts5. (check-in: [df5ccea8] user: dan branch: fts5, size: 170553)
2015-05-30
11:49
[7cea4029] part of check-in [e008c3c8] Remove the "#include sqlite3Int.h" from fts5Int.h. (check-in: [e008c3c8] user: dan branch: fts5, size: 170607)
2015-05-29
15:55
[59b8a3df] part of check-in [0fc0ea20] 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: [0fc0ea20] user: dan branch: fts5, size: 172114)
2015-05-28
14:37
[a693ba74] part of check-in [0f9df202] Remove some dead code from fts5. Add auxiliary function api tests to the same. (check-in: [0f9df202] user: dan branch: fts5, size: 172184)
2015-05-26
18:22
[c41e4f90] part of check-in [aef89d9f] Simplifications and minor optimizations to fts5 prefix queries that cannot use a prefix index. (check-in: [aef89d9f] user: dan branch: fts5, size: 174561)
2015-05-25
11:46
[79b8fcf4] part of check-in [02069782] Avoid redundant loads from the %_data table in the fts5 code. (check-in: [02069782] user: dan branch: fts5, size: 175639)
2015-05-23
15:43
[985bfa5a] part of check-in [5165de54] Avoid making redundant copies of position-lists within the fts5 code. (check-in: [5165de54] user: dan branch: fts5, size: 176556)
2015-05-18
17:50
[2c4500c3] part of check-in [47dbfadb] Improve test coverage of fts5_config.c. (check-in: [47dbfadb] user: dan branch: fts5, size: 175380)
2015-05-15
18:13
[6e0ac583] part of check-in [7aea8c6d] Improve test coverage of fts5_index.c. (check-in: [7aea8c6d] user: dan branch: fts5, size: 175776)
12:18
[71d5ce47] part of check-in [adee7885] Add test cases. And some fixes. (check-in: [adee7885] user: dan branch: fts5, size: 175295)
2015-05-13
17:15
[b9a3382a] part of check-in [aa34bf66] 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: [aa34bf66] user: dan branch: fts5, size: 175310)
2015-05-08
20:21
[6a4fed2d] part of check-in [6bf93e3b] Add the fts5vocab module, for direct access to the fts5 index. (check-in: [6bf93e3b] user: dan branch: fts5, size: 166889)
2015-05-07
19:29
[aa8d73d0] part of check-in [a684b5e2] 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: [a684b5e2] user: dan branch: fts5, size: 165906)
2015-04-28
18:35
[de588982] part of check-in [8e8136f2] Improve coverage of fts5 tests. (check-in: [8e8136f2] user: dan branch: fts5, size: 168804)
2015-04-27
16:21
[65d5a75b] part of check-in [e38e2bb6] 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: [e38e2bb6] user: dan branch: fts5, size: 169045)
11:31
[5f969f5b] part of check-in [ffeb3ef3] Further tests for fts5. (check-in: [ffeb3ef3] user: dan branch: fts5, size: 169091)
2015-04-25
20:29
[699b716f] part of check-in [e5aaa013] Improve coverage of fts5_index.c slightly. (check-in: [e5aaa013] user: dan branch: fts5, size: 168217)
18:56
[c87369d1] part of check-in [e748651c] Add tests for fts5. (check-in: [e748651c] user: dan branch: fts5, size: 168040)
2015-04-24
19:41
[39810b25] part of check-in [86309961] Add the "unindexed" column option to fts5. (check-in: [86309961] user: dan branch: fts5, size: 168763)
15:56
[1663ad6a] part of check-in [41449f7a] Add extra tests for corrupt database handling in fts5. (check-in: [41449f7a] user: dan branch: fts5, size: 168819)
2015-04-22
20:58
[7c9615a8] part of check-in [2dd59b57] Add extra OOM tests for fts5. (check-in: [2dd59b57] user: dan branch: fts5, size: 167586)
20:14
[446f70d1] part of check-in [1e599409] Fix problems with doclist-indexes involving very large rowids. (check-in: [1e599409] user: dan branch: fts5, size: 167805)
2015-04-21
20:13
[6ae86ef3] part of check-in [a21d60cb] Fix a problem in fts5fault1.test. (check-in: [a21d60cb] user: dan branch: fts5, size: 167939)
19:07
[abf74b5e] part of check-in [e50e8031] Fix an fts5 problem with large deletes. (check-in: [e50e8031] user: dan branch: fts5, size: 168537)
2015-04-20
18:48
[f840e35c] part of check-in [2ea8f9cb] Fix some fts5 problems with very large position lists. (check-in: [2ea8f9cb] user: dan branch: fts5, size: 168365)
2015-04-15
18:49
[28f1bfad] part of check-in [50fae1f0] Logically store updates as (insert+delete) within the FTS tree. This allows keys to be annihilated more quickly under some circumstances. (check-in: [50fae1f0] user: dan branch: fts5, size: 167654)
16:01
[9556d405] part of check-in [b29109a0] Fix a problem preventing doclist indexes from being loaded. (check-in: [b29109a0] user: dan branch: fts5, size: 168229)
2015-04-14
20:15
[ba7680d0] part of check-in [9341c070] Begin changing fts5 to use a delete flag so that delete markers may be annihilated more quickly. (check-in: [9341c070] user: dan branch: fts5, size: 168291)
2015-04-11
18:25
[670a428c] part of check-in [bdb8e82a] Have fts5 integrity check verify that prefix indexes contain the same values as returned by prefix queries on the main terms index. (check-in: [bdb8e82a] user: dan branch: fts5, size: 165974)
16:23
[5eea88e4] part of check-in [49c1e745] 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: [49c1e745] user: dan branch: fts5, size: 165278)
2015-03-21
15:37
[4adc5e18] part of check-in [ce972f6a] 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: [ce972f6a] user: dan branch: fts5, size: 164104)
2015-03-10
19:24
[b00f7147] part of check-in [5c46820d] Avoid redundant string comparisons while merging fts5 segment b-trees. (check-in: [5c46820d] user: dan branch: fts5, size: 162217)
2015-03-07
15:46
[3eb8db82] part of check-in [cccee7b5] Fix some compiler warnings caused by signed/unsigned pointer conversions. (check-in: [cccee7b5] user: dan branch: fts5, size: 158430)
2015-03-04
08:29
[db8dc4cf] part of check-in [a5d5468c] Fix a couple of build problems. (check-in: [a5d5468c] user: dan branch: fts5, size: 158420)
2015-02-27
09:41
[deb7a5b7] part of check-in [a07dcca9] Further minor optimizations to flushing fts5 data to disk. (check-in: [a07dcca9] user: dan branch: fts5, size: 158361)
07:23
[14549572] part of check-in [bb104b36] Fix suffix and prefix compression of terms in top-level fts5 segments. And a crash that could follow an OOM condition. (check-in: [bb104b36] user: dan branch: fts5, size: 158135)
2015-02-26
20:49
[7a9de0c0] part of check-in [8e3ca632] Optimize copying data from fts5 in-memory hash tables to top level segments. (check-in: [8e3ca632] user: dan branch: fts5, size: 157694)
14:54
[97ce5c91] part of check-in [208e3cb6] Fix an fts5 bug in large incremental merges. (check-in: [208e3cb6] user: dan branch: fts5, size: 154413)
2015-02-25
19:24
[220321d0] part of check-in [7eb022d7] Instead of the 4-byte fields, use regular varints for the poslist-size field in fts5_hash.c. (check-in: [7eb022d7] user: dan branch: fts5, size: 154286)
2015-02-02
11:32
[beced7a9] part of check-in [fb10bbb9] Fix some problems with building fts5 and fts3 together using the amalgamation. (check-in: [fb10bbb9] user: dan branch: fts5, size: 154098)
2015-01-31
15:23
[3239fa41] part of check-in [1fffe51f] Minor optimizations to fts5 writes. (check-in: [1fffe51f] user: dan branch: fts5, size: 154101)
2015-01-29
20:59
[1550befd] part of check-in [0e225b15] Fix some problems with transactions that both read and write an fts5 table. (check-in: [0e225b15] user: dan branch: fts5, size: 153979)
2015-01-27
20:41
[ef6c7764] part of check-in [f704bc05] 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: [f704bc05] user: dan branch: fts5, size: 150820)
2015-01-24
19:57
[b3e8e38c] part of check-in [5206ca60] 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: [5206ca60] user: dan branch: fts5, size: 149489)
2015-01-23
17:43
[dda2ed8d] part of check-in [51444f67] Fix compression of keys stored on internal segment b-tree nodes by fts5. (check-in: [51444f67] user: dan branch: fts5, size: 149334)
06:50
[604e346f] part of check-in [939b7a5d] Remove some redundant code from fts5. (check-in: [939b7a5d] user: dan branch: fts5, size: 148167)
2015-01-22
19:13
[ee7b141a] part of check-in [5b295897] Add further tests and fixes for fts5. (check-in: [5b295897] user: dan branch: fts5, size: 148817)
2015-01-21
20:30
[baf26bfe] part of check-in [c020a291] Further tests and fixes for fts5. (check-in: [c020a291] user: dan branch: fts5, size: 147650)
18:23
[7decfde6] part of check-in [e0d61442] Fix an fts5 issue with loading doclist-indexes for a term that is the last thing on its leaf page. (check-in: [e0d61442] user: dan branch: fts5, size: 147681)
16:10
[49e470a6] part of check-in [09dabb3b] Add further tests for fts5 backend. (check-in: [09dabb3b] user: dan branch: fts5, size: 147607)
2015-01-20
20:34
[8c34dd95] part of check-in [f45a0dc0] Add extra fault injection tests to fts5. (check-in: [f45a0dc0] user: dan branch: fts5, size: 146975)
2015-01-17
20:01
[33473b52] part of check-in [f30afd20] Ensure an up to date copy of the fts5 configuration has been loaded into memory before attempting to modify the same configuration. (check-in: [f30afd20] user: dan branch: fts5, size: 146924)
2015-01-13
17:25
[6f9f9887] part of check-in [af8d43a4] Fix prefix indexes so that they work in characters, not bytes. (check-in: [af8d43a4] user: dan branch: fts5, size: 146750)
2015-01-07
19:33
[ea36c1e4] part of check-in [e749be56] Add the fts5 'optimize' command. (check-in: [e749be56] user: dan branch: fts5, size: 143964)
17:11
[4e612b2c] part of check-in [0cb2fed5] Add the 'rebuild' and 'delete-all' commands. (check-in: [0cb2fed5] user: dan branch: fts5, size: 142262)
2015-01-06
19:08
[b58bcfba] part of check-in [65f0262f] Remove the iPos parameter from the tokenizer callback. Fix the "tokenchars" and "separators" options on the simple tokenizer. (check-in: [65f0262f] user: dan branch: fts5, size: 141954)
14:38
[a0f370b7] part of check-in [ce6a899b] Further fixes and test cases related to external content tables. (check-in: [ce6a899b] user: dan branch: fts5, size: 141941)
2014-12-18
20:01
[4a8e8535] part of check-in [38b3c65e] Fix a problem with prefix queries and the AND operator. (check-in: [38b3c65e] user: dan branch: fts5, size: 140725)
18:25
[13b6d002] part of check-in [e358c3de] Fix various problems in fts5 revealed by fault-injection tests. (check-in: [e358c3de] user: dan branch: fts5, size: 140252)
2014-12-03
17:27
[9233b8b1] part of check-in [2037dba6] Begin testing fts5 OOM and IO error handling. (check-in: [2037dba6] user: dan branch: fts5, size: 139398)
2014-11-28
20:01
[7e7023f3] part of check-in [bb4a37b5] Add a cookie mechanism to ensure that the %_config table is re-read as required. (check-in: [bb4a37b5] user: dan branch: fts5, size: 138805)
2014-11-27
20:03
[5cb71b39] part of check-in [83491c56] Add a %_config table to fts5. (check-in: [83491c56] user: dan branch: fts5, size: 137436)
2014-11-24
16:24
[998c4aa0] part of check-in [05909237] Add the auxiliary highlight() function to fts5. (check-in: [05909237] user: dan branch: fts5, size: 137556)
2014-08-18
19:30
[3f4d84a1] part of check-in [2397404e] Add an "automerge=0" mode that disables auto-merging and falls back to fts4-style crisis merges. (check-in: [2397404e] user: dan branch: fts5, size: 137542)
2014-08-12
08:36
[0453bb59] part of check-in [f1cb48f4] Automatically resize the hash table used by fts5. (check-in: [f1cb48f4] user: dan branch: fts5, size: 136054)
2014-08-11
20:26
[687736cb] part of check-in [9f8d678a] Simplify the way position lists are copied when merging data. (check-in: [9f8d678a] user: dan branch: fts5, size: 136012)
19:44
[ccef8703] part of check-in [617e2fac] Replace the hash table borrowed from fts3. (check-in: [617e2fac] user: dan branch: fts5, size: 135560)
2014-08-09
18:02
[75b2ebfa] part of check-in [2821825f] Use multiple memory allocations for a single Fts5Structure object. This is probably less efficient but much easier to get right. (check-in: [2821825f] user: dan branch: fts5, size: 141698)
2014-08-07
18:47
[1e001ed7] part of check-in [ba359d78] Add "segment promotion" to fts5. This prevents the FTS index from growing indefinitely as data is added and deleted. (check-in: [ba359d78] user: dan branch: fts5, size: 141150)
2014-08-06
20:04
[dab399c6] part of check-in [1baeb1ce] Avoid writing delete markers to the oldest segment in an FTS index. (check-in: [1baeb1ce] user: dan branch: fts5, size: 135263)
16:30
[6a9f8514] part of check-in [3b19eba0] Add support for savepoints to fts5. (check-in: [3b19eba0] user: dan branch: fts5, size: 134079)
2014-08-05
19:00
[40d90869] part of check-in [d028ba65] Use doclist-indexes with "ORDER BY rowid ASC" fts5 queries as well. (check-in: [d028ba65] user: dan branch: fts5, size: 133232)
2014-08-04
20:07
[3578823a] part of check-in [90b82d3e] Fix fts5_index.c to use doclist-indexes when possible. Only some cases work so far. (check-in: [90b82d3e] user: dan branch: fts5, size: 131006)
2014-08-02
20:49
[20c905c3] part of check-in [b8864da9] Start changing things to use doclist indexes as required. code is not activated yet. (check-in: [b8864da9] user: dan branch: fts5, size: 122993)
2014-08-01
20:13
[13f9dd97] part of check-in [c9893415] Add a special case to the integrity-check code to check that the final integer in a doclist index is as expected. (check-in: [c9893415] user: dan branch: fts5, size: 121837)
19:27
[3e33e3b8] part of check-in [37a7d303] Have the fts5 integrity-check verify that doclist indexes match the contents of the leaf pages that they index. (check-in: [37a7d303] user: dan branch: fts5, size: 120760)
11:16
[618d54ec] part of check-in [89377421] 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: [89377421] user: dan branch: fts5, size: 118387)
2014-07-21
11:44
[68d2d41b] part of check-in [19504c41] Fix the xColumnSize() extension API. (check-in: [19504c41] user: dan branch: fts5, size: 115330)
2014-07-10
20:21
[9ff3008e] part of check-in [b96b5e16] Support "ORDER BY rowid ASC". (check-in: [b96b5e16] user: dan branch: fts5, size: 114699)
2014-07-08
16:27
[a3084168] part of check-in [75ebd3cd] Add support for prefix queries to fts5. (check-in: [75ebd3cd] user: dan branch: fts5, size: 106903)
2014-07-03
20:39
[d8ab9712] part of check-in [250ae8d4] Add support for NEAR expressions to fts5. (check-in: [250ae8d4] user: dan branch: fts5, size: 99449)
2014-07-02
20:18
[6bb95f6a] part of check-in [2e5652e6] Add support for phrase queries to fts5. (check-in: [2e5652e6] user: dan branch: fts5, size: 99450)
2014-07-01
20:45
[ea3dfe56] part of check-in [62f2ff20] Change the position list format so that its size in bytes is stored at the start of the list itself. (check-in: [62f2ff20] user: dan branch: fts5, size: 101891)
2014-06-26
12:31
[c8b21d12] part of check-in [94eeb077] Fix minor problems in term matching. (check-in: [94eeb077] user: dan branch: fts5, size: 99190)
2014-06-25
20:28
[3e6fbae9] part of check-in [47a9f3cc] Begin adding query support to fts5. (check-in: [47a9f3cc] user: dan branch: fts5, size: 98640)
2014-06-23
11:33
[0548e892] part of check-in [1e0648dc] Add some code for an experimental fts5 module. Does not work yet. (check-in: [1e0648dc] user: dan branch: fts5, size: 93328) Added