/ History for ext/fts5/fts5_index.c
Login

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

History for ext/fts5/fts5_index.c

2020-09-21
14:53
[255d3ce3] part of check-in [78216369] In fts5 integrity checks, do not compare the contents of the index against an external content table unless specifically requested. (check-in: [78216369] user: dan branch: trunk, size: 207914)
2020-09-17
14:16
[203a8db4] part of check-in [66f94d62] Fix a "jump depends on unitialized value" valgrind/asan error in fts5. (check-in: [66f94d62] user: dan branch: trunk, size: 207886)
2020-07-29
16:18
[e52291d5] part of check-in [a80ae2c9] 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: [a80ae2c9] user: drh branch: typos, size: 207819)
2020-07-13
11:06
[de14c9a3] part of check-in [49da8bdc] Fix an integer overflow bug in fts5 triggered by a corrupt record. (check-in: [49da8bdc] user: dan branch: trunk, size: 207817)
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