SQLite

All files named ”ext/fts3/fts3_write.c”
Login

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

History for ext/fts3/fts3_write.c

2025-02-27
21:17
[4e967e31f3] part of check-in [f50c21484d] Approximately 100 typo corrections spanning the whole tree, submitted via forum post 0db9827f0464bc33 and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. (check-in: [f50c21484d] user: stephan branch: trunk, size: 197755)
2024-02-01
15:21
[81cd8f7e80] part of check-in [1bdb8cbaf7] Ensure the fts3 xIntegrity method correctly returns error codes unrelated to corruption or missing SQL elements. (check-in: [1bdb8cbaf7] user: dan branch: trunk, size: 197756)
2024-01-16
16:05
[c2d7a8dfb6] part of check-in [b855886c4c] Ensure that the xIntegrity methods of fts3 and fts5 work on read-only databases. (check-in: [b855886c4c] user: dan branch: trunk, size: 197673)
2023-10-24
11:06
[5bb4721330] part of check-in [54be9af446] Fix various harmless scan-build warnings. (check-in: [54be9af446] user: drh branch: trunk, size: 197649)
2023-10-21
18:12
[16df5ea9ff] part of check-in [7f41d7006d] Fix a problem allowing a COMMIT following an OOM to cause fts3/4 corruption. (check-in: [7f41d7006d] user: dan branch: trunk, size: 197602)
2023-10-19
18:23
[3a0043bb52] part of check-in [2875dcb1ac] Fix an fts3 problem caused by reducing the page size using the undocumented "nodesize" option, then running an incremental-merge. (check-in: [2875dcb1ac] user: dan branch: trunk, size: 197463)
2023-09-07
02:13
[b28f4cde90] part of check-in [52bbf44f2d] Fix a problem with the new xIntegrity method for virtual tables, and also fix a bad assert() in FTS3 that was found by the new xIntegrity method. (check-in: [52bbf44f2d] user: drh branch: trunk, size: 197345)
2023-06-12
18:22
[d28d9ef383] part of check-in [7ec4ab327d] Initialize a local variable in FTS3 to avoid a GCC compiler warning. (check-in: [7ec4ab327d] user: drh branch: trunk, size: 197351)
2023-03-18
16:12
[33d2d0db4d] part of check-in [02ac2297ab] Avoid a buffer overread in fts3 that could occur when processing a corrupt record. (check-in: [02ac2297ab] user: dan branch: trunk, size: 197307)
2022-09-27
01:53
[4fb644df0f] part of check-in [5517bc5098] Make the legacy FTS3 code more robust against integer overflow during memory allocation. (check-in: [5517bc5098] user: drh branch: trunk, size: 197200)
2022-06-03
13:52
[85279b980f] part of check-in [f1dfbc4f74] Fix a 1-byte overread in fts3 that could occur when processing corrupt records. (check-in: [f1dfbc4f74] user: dan branch: trunk, size: 197046)
2021-10-12
11:30
[3109c1a232] part of check-in [8124b2ceb7] Fix a use-after-free in fts3 that could follow an optimize() in the middle of a SELECT statement when the hash table is non-empty. (check-in: [8124b2ceb7] user: dan branch: trunk, size: 196931)
2021-10-04
22:34
[c93b128772] part of check-in [32f33f3569] Fix harmless static-analyzer warnings. (check-in: [32f33f3569] user: drh branch: trunk, size: 196654)
2021-06-08
12:15
[98edfd77ae] part of check-in [45f459d2fa] Avoid a buffer overread in fts3 that could occur when handling corrupt data structures. (check-in: [45f459d2fa] user: dan branch: trunk, size: 196543)
2021-06-07
15:28
[b0441839fd] part of check-in [9d0b6b0f42] Fix a buffer overrun in fts3 that could occur when handling corrupt records and '^' queries. (check-in: [9d0b6b0f42] user: dan branch: trunk, size: 196530)
2021-04-16
11:25
[aa751c4559] part of check-in [d0e2d6742f] Fix an assert() in fts3 that might fail when handing corrupt records. (check-in: [d0e2d6742f] user: dan branch: trunk, size: 196512)
2021-03-03
16:00
[a5159accfd] part of check-in [e6c7683c75] Fix a case where fts3 was erroneously reporting corruption. (check-in: [e6c7683c75] user: dan branch: trunk, size: 196504)
2021-02-20
19:22
[3b5df74d65] part of check-in [68bb541a39] Fix a case where FTS3/4 could pass a NULL pointer to memcpy() when handling a corrupt db. (check-in: [68bb541a39] user: dan branch: trunk, size: 196525)
2020-07-29
16:18
[1827b87fbe] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 196384)
2020-07-09
21:29
[723ed1b11e] part of check-in [ccff8cb826] Fix handling of another corrupt database case in fts3. (check-in: [ccff8cb826] user: dan branch: trunk, size: 196384)
2020-06-30
15:32
[d1258a4ec1] part of check-in [4d0cfb1236] Avoid a potential buffer overread in fts3 when processing corrupt records. (check-in: [4d0cfb1236] user: dan branch: trunk, size: 196383)
2020-06-26
20:41
[78a447d9f2] part of check-in [be545f85a6] Fix a problem that could cause an infinite loop in the fts3 'merge' command. (check-in: [be545f85a6] user: dan branch: trunk, size: 196125)
2020-04-22
11:11
[ed869b24d0] part of check-in [e256f85289] Fix an integer overflow in fts3 causing a usan error. (check-in: [e256f85289] user: dan branch: trunk, size: 196062)
2020-04-16
11:35
[d5da5f010b] part of check-in [a9ec8c8f80] Improve corruption detection in fts3 shadow tables earlier in order to prevent an assert() from failing. (check-in: [a9ec8c8f80] user: dan branch: trunk, size: 196052)
2020-03-20
20:18
[eb5c018476] part of check-in [86e98ddc19] Avoid an undefined integer overflow in fts3 by detecting data structure corruption earlier. (check-in: [86e98ddc19] user: dan branch: trunk, size: 196025)
2020-02-06
10:55
[ddf34315b6] part of check-in [fb7ccf61be] Fix some fts3 problems found by usan. (check-in: [fb7ccf61be] user: dan branch: trunk, size: 195897)
2020-01-03
20:16
[6f9dd5d774] part of check-in [9add58fe96] In fts3, avoid making a very large memory allocation if the merge-hint record is corrupt. (check-in: [9add58fe96] user: dan branch: trunk, size: 195892)
2019-12-14
14:15
[51e0a4e378] part of check-in [3b873029ef] Fix problems in fts3 with processing corrupt records and undefined integer overflows. (check-in: [3b873029ef] user: dan branch: trunk, size: 195467)
2019-12-04
03:46
[fa971df91b] part of check-in [e01fdbf9f7] Fix a buffer overread that could occur in fts3 with corrupt %_stat records. (check-in: [e01fdbf9f7] user: dan branch: trunk, size: 195276)
2019-11-26
11:10
[5b9c8870a8] part of check-in [fefe2d0467] Fix to check-in [5d9a369301a65f32] so that it compiles without SQLITE_DEBUG. (check-in: [fefe2d0467] user: drh branch: trunk, size: 195155)
02:03
[7d590628ea] part of check-in [5d9a369301] Fix an assert() in fts3 that could fail due to corrupt database records. (check-in: [5d9a369301] user: dan branch: trunk, size: 195159)
2019-11-20
13:31
[411364eec2] part of check-in [a0f6d526ba] Further improve detection of corrupt records in fts3. Also fix an error with check-in [dfcf081d842629a0] (check-in: [a0f6d526ba] user: dan branch: trunk, size: 195096)
2019-11-18
12:04
[4adce92958] part of check-in [e35d8c76aa] Further improvements to shadow table corruption detection in FTS3. (check-in: [e35d8c76aa] user: drh branch: trunk, size: 195101)
2019-11-17
02:41
[a96fd13026] part of check-in [1e44968788] Better detection of corruption in the %_stat and %_docsize shadow tables of FTS3. (check-in: [1e44968788] user: drh branch: trunk, size: 194983)
00:08
[f31351fc04] part of check-in [8bd75bf636] Remove a reachable NEVER() in FTS3. (check-in: [8bd75bf636] user: drh branch: trunk, size: 194987)
2019-11-16
23:47
[84f7b1390b] part of check-in [51525f9c32] More improvements to shadow table corruption detection in FTS3. (check-in: [51525f9c32] user: drh branch: trunk, size: 194995)
21:40
[f7d443ebe2] part of check-in [04b2873be5] Improved detection of corrupt shadow tables in FTS3. Enable the debugging special-inserts for FTS3 for both SQLITE_DEBUG and SQLITE_TEST. (check-in: [04b2873be5] user: drh branch: trunk, size: 194679)
2019-10-28
13:54
[bf724ff69d] part of check-in [0b0a3048f9] Fix a problem in fts3 causing it to report corruption if a doclist contains consectutive rowid entries that differ by more than 2^63. (check-in: [0b0a3048f9] user: dan branch: trunk, size: 194118)
2019-10-17
15:41
[aef9398265] part of check-in [35beaee059] Avoid an infinite loop in fts3/4 incremental-merge in the case where the lowest level in the database contains segments but no data (because there is a delete-marker for each valid entry). Fix for [bf1aab89]. (check-in: [35beaee059] user: dan branch: trunk, size: 194150)
2019-10-11
15:33
[5e35b79077] part of check-in [4ed905b188] Ensure fts3/4 prefix indexes are flushed to disk before an 'optimize' command. Fix for [745f1abc]. (check-in: [4ed905b188] user: dan branch: trunk, size: 193952)
14:27
[2fd47cef0e] part of check-in [5863546df9] Fix the fts3/4 integrity-check command so that it works with "ORDER=DESC" tables. Fix for [8a6fa2bb]. (check-in: [5863546df9] user: dan branch: trunk, size: 193918)
2019-10-10
16:41
[9b5ae495b3] part of check-in [629e20c988] Fix a problem in the fts3 integrity-check routine causing it to report as corrupt tables that contain values with embedded 0x00 bytes. Ticket [278ac142625e3dcd] (check-in: [629e20c988] user: dan branch: trunk, size: 193814)
2019-10-02
19:33
[13582783ab] part of check-in [67da31e24e] Fix a long-standing problem in fts4 incrmental merge. (check-in: [67da31e24e] user: dan branch: trunk, size: 193875)
2019-09-30
19:13
[4c759137f3] part of check-in [361eb2f682] The nodeReaderInit() function in FTS3 may not assume that the node is non-empty. (check-in: [361eb2f682] user: drh branch: trunk, size: 193872)
2019-07-29
16:53
[6efc4cd7dc] part of check-in [11f7f94f1c] Fix a crash in fts3 caused by corrupt database records. (check-in: [11f7f94f1c] user: dan branch: trunk, size: 193846)
2019-07-05
15:16
[9e88111ca9] part of check-in [cb3dec427e] Fix a valgrind problem in fts3corrupt4.test. (check-in: [cb3dec427e] user: dan branch: trunk, size: 193802)
2019-06-04
13:11
[b4c2e8fc90] part of check-in [dff24c6c7a] Fix a segfault in fts3 that could occur when processing corrupt fts records. (check-in: [dff24c6c7a] user: dan branch: trunk, size: 193581)
2019-05-28
14:42
[35f13d6f50] part of check-in [c736c40aab] Fix an assert() in fts3 that could fail when processing corrupt records. Also some minor sanitizer warnings. (check-in: [c736c40aab] user: dan branch: trunk, size: 193512)
2019-05-22
14:22
[05fd879124] part of check-in [1660d7733e] Fix a buffer overread that could in fts3 when dealing with corrupt records. (check-in: [1660d7733e] user: dan branch: trunk, size: 193415)
2019-04-24
16:13
[766cfc4140] part of check-in [e1724f1d61] Fix another instance in fts3 where a corrupt record can cause a buffer overflow. (check-in: [e1724f1d61] user: dan branch: trunk, size: 193411)
15:13
[23b9328798] part of check-in [6e4a5f2281] Fix an error in fts3_write.c allowing a corrupt database to cause a crash. (check-in: [6e4a5f2281] user: dan branch: trunk, size: 193397)
2019-04-13
04:38
[1d814248a4] part of check-in [07ee06fd39] Use the 64-bit memory allocator interfaces in extensions, whenever possible. (check-in: [07ee06fd39] user: drh branch: trunk, size: 193387)
2019-02-18
12:16
[8174c14b10] part of check-in [a6509ca3dc] Fix an assert() that might not be true if the %_segdir table of FTS3 contains corrupt entries. (check-in: [a6509ca3dc] user: drh branch: trunk, size: 193286)
2019-02-09
19:23
[3732d0495b] part of check-in [db74a56af7] Change a few assert() statements in fts3 that might fail if the database is corrupt. (check-in: [db74a56af7] user: dan branch: trunk, size: 193247)
2019-01-25
14:48
[45cbe0b062] part of check-in [3498908cd7] Add an assert_fts3_nc() macro to fts3 - for assert() conditions that are only true when it is guaranteed that the fts3 database is not corrupt. (check-in: [3498908cd7] user: dan branch: trunk, size: 193223)
2019-01-22
12:21
[4f9d51326e] part of check-in [ba3b841272] Fix another segfault caused by a corrupt fts3 database. (check-in: [ba3b841272] user: dan branch: trunk, size: 193215)
2019-01-16
11:38
[f33df1670b] part of check-in [65cebb06a0] Fix a memory leak that could occur in fts3 when handling a corrupt database. (check-in: [65cebb06a0] user: dan branch: trunk, size: 192955)
2019-01-14
15:09
[9d9c77ee98] part of check-in [65e50706a0] Fix a problem with querying a corrupt fts3 database. (check-in: [65e50706a0] user: dan branch: trunk, size: 192914)
2019-01-10
01:12
[18726fbd2a] part of check-in [666cf8f6b3] Fix the fts3DecodeIntArray() function so that it will not read off the end of the buffer it is handed. Any unread integers are set to zero. (check-in: [666cf8f6b3] user: drh branch: trunk, size: 192869)
2018-12-26
14:23
[d8c64541a9] part of check-in [ceeb4fba84] Fix a problem with corrupt fts3 database detection introduced by [27199380]. (check-in: [ceeb4fba84] user: dan branch: branch-3.22, size: 192655)
14:15
[e36d2f7e8f] part of check-in [c80bb15b44] Fix a problem with corrupt fts3 database detection introduced by [95a9a39f]. (check-in: [c80bb15b44] user: dan branch: trunk, size: 192813)
2018-12-24
13:39
[3618c00987] part of check-in [271993803c] Change the way a comparison used to detect corrupt databases in fts3 is done to avoid potential pointer overflow in 32-bit builds. Cherrypick of [95a9a39ff7]. (check-in: [271993803c] user: dan branch: branch-3.22, size: 192655)
13:34
[6b00abe4d4] part of check-in [95a9a39ff7] Change the way a comparison used to detect corrupt databases in fts3 is done to avoid potential pointer overflow in 32-bit builds. (check-in: [95a9a39ff7] user: dan branch: trunk, size: 192813)
2018-12-21
19:29
[8e67961f44] part of check-in [25666e3d03] Add new sqlite3_prepare_v3() flag SQLITE_PREPARE_NO_VTAB, for preparing statements that are not allowed to use any virtual tables. Use this to prevent circular references in triggers on virtual table shadow tables from causing resource leaks. (check-in: [25666e3d03] user: dan branch: prepare-no-vtab, size: 192815)
18:51
[6e50b0cfa4] part of check-in [1abb83d29a] In FTS3, avoid calling memcpy() with a NULL source pointer, even if the transfer amount is zero bytes. (check-in: [1abb83d29a] user: drh branch: trunk, size: 192771)
11:53
[02764f1294] part of check-in [4cdcda408a] Remove an assert() that could fail on a corrupt db from fts3_write.c. (check-in: [4cdcda408a] user: dan branch: trunk, size: 192663)
2018-12-19
01:57
[cdead22665] part of check-in [882ef4e39b] Add extra defenses against strategically corrupt databases to fts3/4. (check-in: [882ef4e39b] user: drh branch: branch-3.9, size: 192371)
01:38
[0559fca377] part of check-in [4bb21d8205] Add extra defenses against strategically corrupt databases to fts3/4. (check-in: [4bb21d8205] user: drh branch: branch-3.18, size: 192600)
01:30
[b1c2129cce] part of check-in [c255889bd9] Add extra defenses against strategically corrupt databases to fts3/4. (check-in: [c255889bd9] user: drh branch: branch-3.22, size: 192657)
2018-11-05
23:01
[0031c455dd] part of check-in [31942b3dd3] Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. (check-in: [31942b3dd3] user: drh branch: read-only-shadow, size: 192751)
2018-11-03
16:51
[a85bc4885f] part of check-in [d44318f590] Add extra defenses against strategically corrupt databases to fts3/4. (check-in: [d44318f590] user: dan branch: trunk, size: 192697)
2018-02-13
16:30
[b583dede85] part of check-in [27ea783b28] Remove an unused variable from FTS4. (check-in: [27ea783b28] user: drh branch: trunk, size: 192282)
16:21
[434fe5eaf6] part of check-in [d2a81a3752] Ensure that multiple updates of the same FTS4 row (i.e. the row with the same rowid) within a single transaction are written to separate segments. Fix for [d6ec09ec]. (check-in: [d2a81a3752] user: dan branch: trunk, size: 192369)
2018-02-07
18:02
[7a7cf93c02] part of check-in [2a5f813bc6] In extensions rtree, fts3 and fts5, ensure that when dynamic buffers are bound to persistent SQL statements using SQLITE_STATIC, the binding is replaced with an SQL NULL before the buffer is freed. Otherwise, a user may obtain a pointer to the persistent statement using sqlite3_next_stmt() and attempt to access the freed buffer using sqlite3_expanded_sql() or similar. (check-in: [2a5f813bc6] user: dan branch: trunk, size: 192411)
2017-06-28
17:29
[6422e0ef76] part of check-in [942c3ef8cd] Instead of the new sqlite3_prepare_v3() interface, provide the SQLITE_DBCONFIG_PREPARE_FLAGS interface which sets the flags on the single next call to sqlite3_prepare_v2() or its cousins. (check-in: [942c3ef8cd] user: drh branch: dbconfig-prepare-flags, size: 192299)
2017-06-01
00:54
[a3f7bf8696] part of check-in [4a25c58833] Add interfaces sqlite3_prepare_v3() and sqlite3_prepare16_v3() with the extra prepFlags argument. Add the SQLITE_PREPARE_PERSISTENT option as one bit in that argument. (check-in: [4a25c58833] user: drh branch: prepare_v3, size: 192242)
2017-03-20
18:53
[a51d48d646] part of check-in [16a8e84fa7] Fix some problems in fts3 found by address-sanitizer. (check-in: [16a8e84fa7] user: dan branch: trunk, size: 192185)
2016-03-09
18:17
[c3863f23b6] part of check-in [79338b991b] Fix a problem in fts3/4 that was causing it to discard data cached in-memory if an 'optimize' command is run when there is no data on disk. The usual way this would happen is if the very first transaction that writes to the fts3/4 table also includes an 'optimize' command. (check-in: [79338b991b] user: dan branch: trunk, size: 192091)
2016-03-08
15:37
[fb0456fa14] part of check-in [64b3cb2915] Update fts3/4 so that the 'merge=X,Y' command merges at least, instead of exactly, Y segments from a single level. This matches the documentation. 'merge=X,0' is, as it was in 3.11, an error. (check-in: [64b3cb2915] user: dan branch: trunk, size: 192044)
2016-03-07
20:14
[f56345c643] part of check-in [cddf69dbc4] Update fts3/4 so that the 'merge=X,0' command merges X pages from all segments of the first level in the fts index that contains 2 or more segments. (check-in: [cddf69dbc4] user: dan branch: trunk, size: 192094)
2015-10-01
18:31
[f442223e4a] part of check-in [6f90839e91] Fix an fts3 bug causing NEAR queries on uncommitted data to malfunction. (check-in: [6f90839e91] user: dan branch: trunk, size: 191956)
2015-09-28
20:03
[6f7233a06d] part of check-in [1aa27d706d] Also allow UPDATE on virtual tables to use the onepass strategy. (check-in: [1aa27d706d] user: dan branch: vtab-onepass, size: 191753)
15:23
[5d7857a6a4] part of check-in [fffab4f70f] Update fts3 to use the onepass strategy for delete operations. (check-in: [fffab4f70f] user: dan branch: vtab-onepass, size: 191754)
2015-05-20
20:34
[9d1f42ecc5] part of check-in [7d7d633c71] Fix a problem causing the fts3 integrity-check to fail if run inside a transaction. Cherrypick of [3b925189a75e]. (check-in: [7d7d633c71] user: dan branch: branch-3.8.6, size: 191506)
2015-04-23
11:52
[4f005f7859] part of check-in [3b925189a7] Fix a problem causing the fts3 integrity-check to fail if run inside a transaction. (check-in: [3b925189a7] user: dan branch: trunk, size: 191533)
2015-03-25
00:09
[5dc59cb435] part of check-in [cbb93d1aa1] Backport the 'stdcall' related enhancements from trunk. (check-in: [cbb93d1aa1] user: mistachkin branch: stdcall-3.8.8, size: 191483)
2015-03-21
02:22
[7104ec0154] part of check-in [737630b873] Improvements to the MSVC build. Fix harmless compiler warnings. Enable use of 'stdcall'. (check-in: [737630b873] user: mistachkin branch: trunk, size: 191489)
2015-01-12
18:38
[9b3a32cbec] part of check-in [2b8eecbfe7] Fix some harmless compiler warnings. (check-in: [2b8eecbfe7] user: mistachkin branch: msvcW4, size: 191470)
2014-10-02
09:27
[d06519da31] part of check-in [b21746ac11] Fix a segfault that could occur if an 'optimize' command was issued on an FTS table that contained at least one row but zero terms. (check-in: [b21746ac11] user: dan branch: branch-3.7.14, size: 182163)
2014-06-05
11:15
[8260388626] part of check-in [7123bb2605] Fix a problem that was causing the FTS4 integrity-check command to fail if the table had one or more "notindexed" columns. (check-in: [7123bb2605] user: dan branch: trunk, size: 191462)
2014-05-27
19:18
[5ee9d894da] part of check-in [20b75460c0] Fix harmless compiler warnings. (check-in: [20b75460c0] user: drh branch: trunk, size: 191359)
2014-05-16
23:38
[9e4e8579ad] part of check-in [7e60347e21] Fix harmless compiler warnings. (check-in: [7e60347e21] user: mistachkin branch: ftsWarnings, size: 191351)
10:30
[6681e4855b] part of check-in [a9a2aeab29] Fix a bug causing an incorrect segment size value to be stored if both an old and new FTS version performed work on the same incremental merge operation. (check-in: [a9a2aeab29] user: dan branch: fts4-experimental, size: 191343)
2014-05-15
18:36
[b90173c624] part of check-in [2b09bd17eb] Fix a problem with the handling of delete markers by automerge on large databases. (check-in: [2b09bd17eb] user: dan branch: fts4-experimental, size: 191170)
2014-05-14
19:49
[e58c8df149] part of check-in [34f6b4b8e4] Do not search for promotable segments following an FTS 'optimize' operation or creation of a new segment on the oldest existing level. (check-in: [34f6b4b8e4] user: dan branch: fts4-experimental, size: 189921)
18:45
[6cb17b13b0] part of check-in [7268119f74] Fix a problem to do with loading the value of the FTS automerge setting from the database. (check-in: [7268119f74] user: dan branch: fts4-experimental, size: 189777)
15:58
[5e13a15dad] part of check-in [21491a9bc6] Fix various problems to do with segment promotion. Add test file fts4growth2.test, containing tests to check that the FTS index does not grow indefinitely as the table is updated. Allow the user to configure the number of segments merged simultaneously by the automerge option. (check-in: [21491a9bc6] user: dan branch: fts4-experimental, size: 189757)
2014-05-13
20:11
[283b244777] part of check-in [7f47ae5c5d] Fix a problem preventing delete markers from ever being removed from the FTS index. (check-in: [7f47ae5c5d] user: dan branch: fts4-experimental, size: 187584)
2014-05-12
20:04
[5fd2aa9d18] part of check-in [b3b505a4dd] Experimental code to prevent FTS indexes from growing indefinitely as the table is updated. (check-in: [b3b505a4dd] user: dan branch: fts4-experimental, size: 187259)
2014-03-12
19:20
[74c0032900] part of check-in [c67a52c356] Changes to FTS to ensure that it does not access the database from within the xConnect method. (check-in: [c67a52c356] user: dan branch: trunk, size: 183182)
2013-11-12
17:46
[cdebe72171] part of check-in [aa7ba302ed] When possible, have FTS use 32-bit operations to read varints from the database. (check-in: [aa7ba302ed] user: dan branch: trunk, size: 183029)
2013-10-07
21:49
[17817f0cb6] part of check-in [36d64dc36f] Fix compilation issue with MSVC. (check-in: [36d64dc36f] user: mistachkin branch: trunk, size: 183085)
2013-10-02
08:04
[851e65f413] part of check-in [bc3a2ed5fb] Add a test to check that the new multi-token phrase optimization is actually helping. (check-in: [bc3a2ed5fb] user: dan branch: fts4-docid-range-constraints, size: 183086)
2013-08-21
15:45
[ce45c3ea57] part of check-in [5f35c8cb8f] Fix an FTS4 problem introduced by [361084e1eb]. (check-in: [5f35c8cb8f] user: dan branch: trunk, size: 182944)
2013-08-19
19:29
[edf39aea5d] part of check-in [d6c4d48a00] Initialize a variable in fts3_write.c on the grounds that the argument required to show that it does not require initialization with is complicated. Add an assert() to where.c to silence a clang scan-build warning. (check-in: [d6c4d48a00] user: dan branch: trunk, size: 182954)
18:17
[24a8e41cb9] part of check-in [1c63e9515b] Add some extra assert() statements to silence a few clang warnings. (check-in: [1c63e9515b] user: dan branch: trunk, size: 182950)
2013-06-21
17:30
[cd264daa4f] part of check-in [8ff2b8f594] Add the "notindexed" option to fts4. (check-in: [8ff2b8f594] user: dan branch: fts4-notindexed, size: 182948)
2013-06-20
18:32
[af8d9e5709] part of check-in [81527768ef] Fix some issues related to ORDER BY and fts tables with a non-zero languageid_bits setting. (check-in: [81527768ef] user: dan branch: fts-languageid-bits, size: 186625)
11:48
[2ec89b8349] part of check-in [8dc261b765] Add tests (and a fix) for large and small fts docid values with various languageid_bits settings. (check-in: [8dc261b765] user: dan branch: fts-languageid-bits, size: 185668)
11:01
[dda9bec5da] part of check-in [610e7e9612] Fix fts handling of the case where both a rowid and docid are specified as part of an insert statement. (check-in: [610e7e9612] user: dan branch: fts-languageid-bits, size: 185610)
2013-06-19
20:13
[b057e0f72a] part of check-in [d36d7e6833] Add the languageid_bits= option to fts. Still some problems to work out. (check-in: [d36d7e6833] user: dan branch: fts-languageid-bits, size: 185617)
2013-05-27
10:11
[6a1fc0e922] part of check-in [3cd2da42e9] When writing to an FTS table, take an exclusive shared-cache lock on the %_segdir table before writing. Otherwise, an xCommit() call may report an SQLITE_LOCKED error. (check-in: [3cd2da42e9] user: dan branch: trunk, size: 182633)
2013-03-25
11:38
[d92c6cbe07] part of check-in [f85f9103cf] In fts3, when filtering lists for hits in a specific column, edit the list in place in the same way as it is for NEAR filtering. Fix for [38b1ae018f]. (check-in: [f85f9103cf] user: dan branch: trunk, size: 182967)
2012-12-04
00:53
[c2166f7148] part of check-in [ffd1e51490] Fix an uninitialized variable detected by valgrind. (check-in: [ffd1e51490] user: drh branch: trunk, size: 182608)
2012-11-27
15:56
[a432433a70] part of check-in [e38fb02d5e] Fix a problem causing the "number-of-documents" field maintained by FTS4 to be set incorrectly by REPLACE queries. (check-in: [e38fb02d5e] user: dan branch: trunk, size: 182608)
2012-10-17
20:15
[ba0bb0a91c] part of check-in [514505a84b] Initialize variables used as outputs of custom tokenizer method calls in fts4. (check-in: [514505a84b] user: dan branch: trunk, size: 182140)
2012-08-25
10:01
[c30c49f3de] part of check-in [9b19b84753] Fix all known instances of 'repeated the' style typos in comments. No changes to code. (check-in: [9b19b84753] user: mistachkin branch: trunk, size: 182124)
2012-08-20
17:24
[f40042ba56] part of check-in [e799222f3b] Add the SQLITE_DISABLE_FTS4_DEFERRED compile time option. (check-in: [e799222f3b] user: dan branch: trunk, size: 182133)
2012-06-08
14:01
[794438f904] part of check-in [025227be54] Fix an obscure memory leak in FTS3 that can come about when two memory allocations are immediately adjacent to one another. (check-in: [025227be54] user: drh branch: trunk, size: 182089)
2012-05-26
15:44
[6a6391d6b0] part of check-in [ed28c48a3d] Add fault-injection tests that use the unicode61 tokenizer. Fix a problem revealed by the same. (check-in: [ed28c48a3d] user: dan branch: fts4-unicode, size: 182002)
2012-04-11
11:38
[cd4af00b3b] part of check-in [93a0f452a7] Fix harmless static-analysis warnings, mosting having to do with memory leaks in the command-line shell. Add a clang analysis of the command-line shell to the "warnings-clang.sh" script. Other minor cleanups to the command-line shell code. (check-in: [93a0f452a7] user: drh branch: trunk, size: 181922)
2012-03-30
00:00
[545c3e2add] part of check-in [b451c0f97f] Fix compiler warnings on GCC and MSVC and fix a C89-ism that broke the build for MSVC. (check-in: [b451c0f97f] user: drh branch: trunk, size: 181939)
2012-03-28
18:08
[bd0d354b51] part of check-in [83037d5844] Do the accounting for incr-merge work in pages instead of blocks. (check-in: [83037d5844] user: dan branch: fts4-incr-merge-exp, size: 182017)
2012-03-27
15:00
[ceb65d6a85] part of check-in [5c447e226a] Remove the fts3merge.test script in favour of changing the fts4merge.test script so that it runs tests using both fts4 and fts3. Fix some problems with incr-merge and FTS3 tables. (check-in: [5c447e226a] user: dan branch: fts4-incr-merge, size: 181910)
11:48
[a9990753ba] part of check-in [7ed9d2f24a] Allow multiple incremental merges to proceed concurrently. This is required to prevent a large crisis-merge from occuring while an even larger incremental-merge is underway. (check-in: [7ed9d2f24a] user: dan branch: fts4-incr-merge-exp, size: 181850)
2012-03-26
10:57
[6014014cf0] part of check-in [f907fc3fb3] Modify the FTS integrity-check so that the checksums do not depend on the results of signed integer overflow, which is undefined in C. (check-in: [f907fc3fb3] user: dan branch: fts4-incr-merge, size: 179525)
10:47
[554368a941] part of check-in [64e8a116f3] Add a comment to explain how the FTS integrity-check works. (check-in: [64e8a116f3] user: dan branch: fts4-incr-merge, size: 179508)
10:36
[a95e0f29a4] part of check-in [40fc880474] Add an experimental integrity-check function to FTS. (check-in: [40fc880474] user: dan branch: fts4-incr-merge, size: 178574)
2012-03-24
17:29
[6a092ee271] part of check-in [cc051fc0b2] Enable fts3 tables to use incremental merge by automatically creating the %_stat table when it is needed. (check-in: [cc051fc0b2] user: drh branch: fts4-incr-merge, size: 171718)
17:09
[ee3aeaa51a] part of check-in [4220d52cb3] Fix a failing assert() in the FTS3_LOG_MERGES related code. (check-in: [4220d52cb3] user: dan branch: fts4-incr-merge, size: 171504)
16:18
[d96bd53e22] part of check-in [2e06babf49] Fix a bug in debugging code enabled when FTS3_LOG_MERGES is defined. (check-in: [2e06babf49] user: drh branch: fts4-incr-merge, size: 171504)
16:11
[9c9d3062f5] part of check-in [67a0cffc9d] Remove the Fts3Table.mxLevel variable. (check-in: [67a0cffc9d] user: dan branch: fts4-incr-merge, size: 171501)
14:45
[c71f84711f] part of check-in [0d841c957c] Modify the way the number of leaves written and the maximum relative level are calculated in the auto-incr-merge code. (check-in: [0d841c957c] user: dan branch: fts4-auto-incr-merge, size: 171783)
02:20
[663f2fa51e] part of check-in [ed69434cd8] An attempt at automatic incremental merging for FTS4. (check-in: [ed69434cd8] user: drh branch: fts4-auto-incr-merge, size: 171054)
2012-03-23
18:26
[e3b7505301] part of check-in [ed7c17ea16] Fix a spurious SQLITE_CONSTRAINT error that may be returned by an incr-merge operation. (check-in: [ed7c17ea16] user: dan branch: fts4-incr-merge, size: 169104)
14:38
[8791a3dae9] part of check-in [96ed47493b] Remove an incorrect assert() statement. Fix a const-related warning. (check-in: [96ed47493b] user: dan branch: fts4-incr-merge, size: 167244)
2012-03-22
16:48
[62ada731e3] part of check-in [ab0a4f44fb] Following an incr-merge operation that does not completely consume its input segments, store context in the rowid==1 row of the %_stat table that allows the next incr-merge to pick up where the previous left off. (check-in: [ab0a4f44fb] user: dan branch: fts4-incr-merge, size: 167259)
2012-03-17
16:56
[a78deea7b5] part of check-in [7aabb62c8c] Fix various incorrect and missing comments and other style issues in and around the FTS incremental merge code. (check-in: [7aabb62c8c] user: dan branch: fts4-incr-merge, size: 163144)
2012-03-16
16:52
[8eedfeb2e6] part of check-in [2755edc7f1] Cherrypick the [3475092cff] fix for 32-bit overflow with large language-ids into trunk. (check-in: [2755edc7f1] user: drh branch: trunk, size: 117191)
15:54
[548d034e16] part of check-in [3475092cff] Fix some integer overflow problems that can occur when using large langauge id values. (check-in: [3475092cff] user: dan branch: fts4-incr-merge, size: 156038)
14:54
[fab92bcc6d] part of check-in [7e0f861bed] Add a comment to the FTS getAbsoluteLevel() function. No actual code changes. (check-in: [7e0f861bed] user: dan branch: fts4-incr-merge, size: 155843)
2012-03-15
17:45
[be60aaf4a8] part of check-in [cd34bc1af4] Modify incremental merge code to merge nMin segments at a time. (check-in: [cd34bc1af4] user: dan branch: fts4-incr-merge, size: 154439)
2012-03-14
20:01
[3551216660] part of check-in [570473729d] Add tests for incremental merge code. (check-in: [570473729d] user: dan branch: fts4-incr-merge, size: 153803)
12:17
[772b8c32b9] part of check-in [36ae510de4] Avoid allocating a large object on the stack in the incremental merge code. Use sqlite3_malloc() instead. (check-in: [36ae510de4] user: dan branch: fts4-incr-merge, size: 153318)
11:51
[828b639566] part of check-in [f97b12e095] Fix another bug in the incremental merge code. (check-in: [f97b12e095] user: dan branch: fts4-incr-merge, size: 153097)
2012-03-13
19:56
[d26ef19833] part of check-in [bff2168370] Fix some bugs in the incremental merge code. Some remain. (check-in: [bff2168370] user: dan branch: fts4-incr-merge, size: 153119)
2012-03-09
12:52
[80863b8ef7] part of check-in [a1747086c5] Minor commenting and stylistic changes only. (check-in: [a1747086c5] user: drh branch: fts4-incr-merge, size: 152595)
2012-03-08
18:39
[81b885ef5d] part of check-in [741b8f8977] Add the 'merge=?,?' command to fts4. This still needs some work. (check-in: [741b8f8977] user: dan branch: fts4-incr-merge, size: 151903)
2012-03-03
18:46
[f87bb2d27d] part of check-in [f8e9c445dd] Add the xLanguageid method to sqlite3_fts3_tokenizer versions 1 and greater. (check-in: [f8e9c445dd] user: dan branch: fts4-languageid, size: 115762)
2012-03-02
12:26
[35b98a42f9] part of check-in [65fa693729] Fix the FTS 'optimize' command on multi-lingual databases. (check-in: [65fa693729] user: dan branch: fts4-languageid, size: 115650)
11:48
[36fc2e3a28] part of check-in [d281cb8984] Fix a bug in merging FTS language tables for languages other than language 0. (check-in: [d281cb8984] user: dan branch: fts4-languageid, size: 115067)
2012-03-01
19:44
[489d262b1e] part of check-in [bea257f70f] Add the "languageid=" option to fts4. This code is still largely untested and alsmost certainly buggy. (check-in: [bea257f70f] user: dan branch: fts4-languageid, size: 115057)
2012-01-31
23:34
[1721187a4d] part of check-in [b4cad1ce78] Fix a compiler warning in FTS4. (check-in: [b4cad1ce78] user: drh branch: trunk, size: 112743)
2012-01-25
22:08
[cfb96f850c] part of check-in [2a7170f03c] Cherrypick the FTS fix in [c05c3fd20d9] into the nx-devkit branch. Ticket [edb497982c]. (check-in: [2a7170f03c] user: drh branch: nx-devkit, size: 112644)
16:29
[632fe0afc5] part of check-in [c05c3fd20d] Fix an FTS problem triggered by querying for an N character prefix using an N+1 character prefix index after rows have been deleted from the FTS table. Fix for [edb497982c]. (check-in: [c05c3fd20d] user: dan branch: trunk, size: 112739)
2011-12-23
11:07
[1041f612d3] part of check-in [e6a04bf9f1] Fix a problem with [f9c4a7c8f4] as applied to this branch. (check-in: [e6a04bf9f1] user: dan branch: branch-3.7.6, size: 91487)
2011-12-22
18:44
[d0a3a60e73] part of check-in [a61786e760] Backport the fixes for Coverity-discovered problems in [1c27d84216], [676acce274], and [f9c4a7c8f4] from trunk to the 3.7.6 branch. (check-in: [a61786e760] user: drh branch: branch-3.7.6, size: 91501)
17:31
[fdf0c99830] part of check-in [1c27d84216] Fix minor issues with FTS and RTREE discovered by coverity. (check-in: [1c27d84216] user: drh branch: trunk, size: 112250)
15:30
[fb1998be65] part of check-in [f9c4a7c8f4] Fix a problem in fts3_write.c causing stack memory to be referenced after it is out of scope. (check-in: [f9c4a7c8f4] user: dan branch: trunk, size: 112373)
2011-10-19
18:21
[c097228bff] part of check-in [1af4a25631] Fix harmless compiler warnings in FTS4. (check-in: [1af4a25631] user: drh branch: trunk, size: 112155)
16:20
[f2545f59a4] part of check-in [8a4077057d] Merge the fts4-content branch with the trunk. (check-in: [8a4077057d] user: dan branch: trunk, size: 112147)
11:57
[aaf0885fd5] part of check-in [9b58c59eb4] Change the way ^ tokens work in FTS so that the filtering is done as part of reading the FTS index instead of waiting until an entire doclist has been retrieved and then filtering it. (check-in: [9b58c59eb4] user: dan branch: fts4-content, size: 112231)
2011-10-18
19:39
[567380f2d6] part of check-in [63ac33c860] If a token within an FTS query is prefixed with a '^' character, it must be the first token in a column of data to match. (check-in: [63ac33c860] user: dan branch: fts4-content, size: 111818)
2011-10-13
17:16
[ffe13acc38] part of check-in [7e24645be2] Handle updating the only row of an FTS table correctly. Fix for [9fd058691]. (check-in: [7e24645be2] user: dan branch: trunk, size: 108502)
2011-10-05
15:11
[06520aa8a0] part of check-in [289ee43179] Change FTS4 so that if both the content=xxx option and column names are specified, the virtual table assumes that the named columns correspond to columns of table xxx. (check-in: [289ee43179] user: dan branch: fts4-content, size: 111776)
06:07
[16fba93fc8] part of check-in [c6ba81fcad] Fix a problem with IO error handling in the rebuild-index code. (check-in: [c6ba81fcad] user: dan branch: fts4-content, size: 111643)
2011-10-04
11:22
[9e14eb5431] part of check-in [1d27ea741f] Add experimental 'content' option to FTS4. (check-in: [1d27ea741f] user: dan branch: fts4-content, size: 111616)
2011-06-20
19:00
[194829c8fd] part of check-in [ed2dda9329] More compiler warning fixes. (check-in: [ed2dda9329] user: drh branch: trunk, size: 108586)
2011-06-16
16:06
[5774a7ee96] part of check-in [051c756c36] Fix a problem with NEAR queries executed inside a transaction that writes the FTS table. (check-in: [051c756c36] user: dan branch: trunk, size: 108576)
00:54
[b0df39416b] part of check-in [a0b43a320e] Changes to #ifdefs so that the build goes correctly if the only FTS macro defined is SQLITE_ENABLE_FTS4. (check-in: [a0b43a320e] user: drh branch: trunk, size: 106410)
2011-06-15
08:30
[4c00845066] part of check-in [7a3813138d] Add an interface to better test incremental loading of doclists by FTS4. Also some tests for this and term prefix queries. (check-in: [7a3813138d] user: dan branch: broken-build, size: 106410)
2011-06-08
18:39
[bc24cec303] part of check-in [3972a787df] Fix various issues to do with deferred tokens, NEAR expressions and matchinfo(). (check-in: [3972a787df] user: dan branch: fts3-prefix-search, size: 106133)
2011-06-06
14:51
[ed525afd52] part of check-in [89f2f482e0] Modify fts3rnd.test to run tests for both "ORDER BY docid ASC" and "ORDER BY docid DESC" with both order=ASC and order=DESC FTS tables. Fixes for some bugs found. (check-in: [89f2f482e0] user: dan branch: fts3-prefix-search, size: 109780)
2011-06-04
20:04
[d7eded6f5e] part of check-in [f6a0193f5a] Allow the "order=DESC" and "order=ASC" parameters in FTS4 "CREATE VIRTUAL TABLE" statements. Tables created with "order=DESC" store all doclists in descending order, which allows optimizations normally applied to "ORDER BY docid ASC" queries to be used with "ORDER BY docid DESC" queries instead. (check-in: [f6a0193f5a] user: dan branch: fts3-prefix-search, size: 109740)
2011-06-03
18:00
[c2f041d74f] part of check-in [a4c7e28208] FTS changes: Remove unreachable code. Fix bugs. When processing a large doclist incrementally, read from disk incrementally too. (check-in: [a4c7e28208] user: dan branch: fts3-prefix-search, size: 106886)
2011-06-02
19:57
[b145547430] part of check-in [28149a7882] Changes to improve performance and support LIMIT clauses on fts3 tables. This branch is unstable for now. (check-in: [28149a7882] user: dan branch: fts3-prefix-search, size: 103494)
2011-05-28
15:57
[ed58c53fbc] part of check-in [84097a4c75] Minor changes made while planning a larger change. (check-in: [84097a4c75] user: dan branch: fts3-prefix-search, size: 99497)
2011-05-25
19:17
[beaa93bcbe] part of check-in [cc83991caa] If a prefix index of size N is not present, use a prefix index of size N+1 along with the terms index for queries for prefixes of length N. (check-in: [cc83991caa] user: dan branch: fts3-prefix-search, size: 99404)
18:34
[416b367f56] part of check-in [be59bf4940] Change fts4 so that the prefix= parameter is passes a comma-separated list of integers. For each integer N, a separate index of all prefixes of length N bytes is created. (check-in: [be59bf4940] user: dan branch: fts3-prefix-search, size: 99422)
2011-05-24
18:49
[0fd6a55c77] part of check-in [b5bdc63989] If the fts4 option prefix=1 is specified, have the fts4 module maintain an index of prefixes as well as terms. (check-in: [b5bdc63989] user: dan branch: fts3-prefix-search, size: 99254)
2011-05-17
15:56
[b50181e5ec] part of check-in [8844e8bfb8] Add extended return code SQLITE_CORRUPT_VTAB. Returned when the tcontents of the sqlite tables used internally by a virtual table module are invalid or inconsistent. (check-in: [8844e8bfb8] user: dan branch: trunk, size: 94817)
2011-05-04
16:30
[7d6d904b89] part of check-in [1a11335970] Fix a couple of compiler warnings in the FTS code. (check-in: [1a11335970] user: dan branch: vtab-conflict, size: 94792)
2011-04-27
16:02
[21ddcc4790] part of check-in [abdd70ae04] Add documentation for the newly introduced sqlite3_vtab_config() and on_conflict() API functions. Test that encountering an SQLITE_MISMATCH in fts3 does not corrupt the full text index. (check-in: [abdd70ae04] user: dan branch: vtab-conflict, size: 94846)
2011-04-26
19:21
[b4dfd76d61] part of check-in [fb4a355871] Extra tests for fts3. And fixes for conflict-handling related problems in fts3. (check-in: [fb4a355871] user: dan branch: vtab-conflict, size: 94688)
2011-04-25
18:49
[388a7c7119] part of check-in [6d2633a6d0] Add support for on conflict clauses to fts3/fts4. (check-in: [6d2633a6d0] user: dan branch: vtab-conflict, size: 93798)
2011-04-19
06:43
[c0af09a040] part of check-in [0dd09fc034] Avoid passing NULL to the xOpen method of an FTS3/4 tokenizer. (check-in: [0dd09fc034] user: dan branch: trunk, size: 91829)
2011-02-04
18:56
[813495ed10] part of check-in [3996f92a9a] Change fts4aux to (additionally) report on term frequency in individual columns of an fts table. (check-in: [3996f92a9a] user: dan branch: trunk, size: 91624)
2011-02-02
17:30
[8cf14b0e1e] part of check-in [386701ded2] Optimize handling of equality and range constraints on the "term" column of an fts4aux table. (check-in: [386701ded2] user: dan branch: trunk, size: 91638)
2011-02-01
17:55
[58a4d891bd] part of check-in [4ade96ce97] Fix a case in fts4 where a corrupt %_stat table could lead to a crash. (check-in: [4ade96ce97] user: dan branch: fts4aux, size: 91557)
16:34
[ae896d78e4] part of check-in [b010ddcc52] Add virtual table module "fts4aux", used to inspect the full-text index of an fts4 table directly. Also add the "compress" and "uncompress" fts4 options. (check-in: [b010ddcc52] user: dan branch: fts4aux, size: 91500)
2011-01-13
11:20
[3eea26b9ca] part of check-in [811e12cddf] Fix a couple of crashes in fts3 that can occur if the database contents are inconsistent. (check-in: [811e12cddf] user: dan branch: trunk, size: 98343)
10:58
[9f3545ae27] part of check-in [fe9047668e] Fix a segfault that can occur in matchinfo if an fts4 table contains mostly zero-length documents. Specifically, if the table contains more rows than it does bytes of text. (check-in: [fe9047668e] user: dan branch: trunk, size: 98368)
2010-12-24
15:49
[1fd0988538] part of check-in [7088d9450f] Reduce the number of calls to sqlite3_realloc() made by fts3 when querying for position information of a term prefix. (check-in: [7088d9450f] user: dan branch: trunk, size: 98307)
2010-12-01
15:36
[13012755d5] part of check-in [c7771c0b22] Fix some warnings under MSVC in fts3 module. (check-in: [c7771c0b22] user: shaneh branch: trunk, size: 98305)
2010-11-26
16:49
[9d254e1baf] part of check-in [c412f61229] Fix various compiler warnings. (check-in: [c412f61229] user: drh branch: trunk, size: 98300)
2010-11-24
19:26
[b4e5b4c74f] part of check-in [71011a4f9b] Add code for the matchinfo 'longest common substring' feature. (check-in: [71011a4f9b] user: dan branch: fts3-experimental, size: 98515)
11:51
[9b2db92b81] part of check-in [ae40b34cf7] Remove some unused code from fts3. Add tests to fts3matchinfo.test. (check-in: [ae40b34cf7] user: dan branch: fts3-experimental, size: 98454)
2010-11-23
19:16
[f5e7db7905] part of check-in [9cf0f2b76b] Experimental changes to fts3 function matchinfo(). (check-in: [9cf0f2b76b] user: dan branch: fts3-experimental, size: 101014)
2010-11-02
17:41
[3d12dad6cb] part of check-in [31989b18f5] Changes to allow FTS4 tables to be created without the underlying %_docsize table (in order to save space). (check-in: [31989b18f5] user: dan branch: trunk, size: 99601)
2010-10-30
15:21
[01478ee63b] part of check-in [b770290561] Test cases and minor changes to make fts3 more robust in the face of a corrupt database. (check-in: [b770290561] user: dan branch: trunk, size: 99586)
2010-10-29
18:45
[f2f5caed5e] part of check-in [252f0e457d] Add extra test cases and changes to fts3 to avoid crashing on a corrupt database. (check-in: [252f0e457d] user: dan branch: trunk, size: 99475)
2010-10-27
16:52
[a9189fa871] part of check-in [84194c4195] Fix a buffer overread in fts3 that can occur if the database is corrupt. (check-in: [84194c4195] user: dan branch: experimental, size: 98778)
10:55
[943216b144] part of check-in [941647d121] In fts4, store the total number of bytes of for all records in the table in the %_stat table. (check-in: [941647d121] user: dan branch: experimental, size: 98408)
2010-10-23
19:07
[1b9211904f] part of check-in [deb80eac91] Fixes for the matchinfo() function related to FTS4 common token handling. (check-in: [deb80eac91] user: dan branch: experimental, size: 97854)
2010-10-22
16:44
[54ddeed732] part of check-in [1c9c70fec3] Add missing comments and fix compiler warnings in new FTS3/4 code. Other minor fixes too. (check-in: [1c9c70fec3] user: dan branch: experimental, size: 97843)
2010-10-20
18:56
[be47d30cf8] part of check-in [d0a450ce78] Updates to FTS4 to improve performance and make more accurate cost estimates for prefix terms. (check-in: [d0a450ce78] user: dan branch: experimental, size: 97281)
2010-10-19
14:08
[29b63a98de] part of check-in [5ae0ba447a] Experimental changes to fts4 to try to selectively avoid loading very large doclists. (check-in: [5ae0ba447a] user: dan branch: experimental, size: 97351)
2010-09-17
15:28
[97a583b9e1] part of check-in [018e82c775] Have all FTS3 queries obtain a read or write table-lock at the shared-cache level before doing anything else. (check-in: [018e82c775] user: dan branch: trunk, size: 88824)
2010-03-19
13:59
[4b21a0c6f2] part of check-in [b7e42ae774] Rewrite a couple of queries used internally by FTS3 to take advantage of the "SELECT max(x) FROM ..." optimization. (check-in: [b7e42ae774] user: dan branch: trunk, size: 87494)
2010-02-26
01:46
[bff9bea026] part of check-in [4927c62d62] Minor changes to silence some compiler warnings with MSVC. (check-in: [4927c62d62] user: shaneh branch: trunk, size: 87483)
2010-02-03
19:55
[26b1151e60] part of check-in [1b6e6094c8] Add a new full-text search variant that tracks the total number of documents and document sizes, to make ranking search results easier. Currently called FTS4. (check-in: [1b6e6094c8] user: drh branch: trunk, size: 87429)
2009-12-29
10:32
[ccb9222660] part of check-in [a3b50e4f80] Fix a bug triggered by optimizing an FTS3 table when there are no segments on disk but pending terms in the hash table. (check-in: [a3b50e4f80] user: dan branch: trunk, size: 78808)
2009-12-14
14:49
[2847b13da9] part of check-in [a730a05b39] Fix a broken assert() in fts3_write.c. Also fix a couple of compiler warnings in fts3 code. (check-in: [a730a05b39] user: dan branch: trunk, size: 78814)
2009-12-12
16:04
[c2e0ef39df] part of check-in [d2a8c0f683] Further fts3 coverage tests. (check-in: [d2a8c0f683] user: dan branch: trunk, size: 78805)
13:16
[8fa7390699] part of check-in [eee921a99e] Extra tests for coverage of fts3 code. (check-in: [eee921a99e] user: dan branch: trunk, size: 78649)
09:51
[a8f2eb04ac] part of check-in [8fcb0478c8] Add coverage test cases for fts3. (check-in: [8fcb0478c8] user: dan branch: trunk, size: 77708)
2009-12-11
16:03
[3f49f2cde3] part of check-in [87fc0ce151] Change the fts3 test interface used to configure the advisory node size parameter. (check-in: [87fc0ce151] user: dan branch: trunk, size: 77544)
12:29
[883db71624] part of check-in [29476da353] Rationalize some code in fts3 used by optimize operations, queries of the pending-terms hash table and segment merges. Add the "INSERT INTO tbl(tbl) VALUES('optimize')" syntax. (check-in: [29476da353] user: dan branch: trunk, size: 77396)
2009-12-10
16:04
[ee50b8feb7] part of check-in [48c0db0eb2] Changes to fts3 to avoid flushing data to disk within a SELECT statement. (check-in: [48c0db0eb2] user: dan branch: trunk, size: 75993)
2009-12-09
14:39
[c7d549ac5a] part of check-in [56b6432f86] Improve test coverage of fts3.c. (check-in: [56b6432f86] user: dan branch: trunk, size: 72821)
2009-12-08
19:05
[643be9c7b0] part of check-in [f0eac4175a] Add tests to improve coverage of fts3. Associated bugfixes. (check-in: [f0eac4175a] user: dan branch: trunk, size: 72796)
2009-12-03
17:36
[ec51fb6886] part of check-in [75863c2d55] Fix an incorrect assert() in fts3.c. Add further fts3 tests. (check-in: [75863c2d55] user: dan branch: trunk, size: 72759)
06:26
[6c59b1d6ee] part of check-in [37495b55ff] Updates to FTS3 to correct compiler warnings under MSVC. (check-in: [37495b55ff] user: shaneh branch: trunk, size: 72851)
2009-12-02
14:44
[5d38494437] part of check-in [d17ec16b7c] Clear the Pager.dbModified flag when unlocking the database. Assert that it is clear when locking the database. (check-in: [d17ec16b7c] user: dan branch: trunk, size: 72809)
2009-12-01
13:48
[1d75e1be89] part of check-in [4924fbb244] Open a savepoint within the FTS3 optimize() function. (check-in: [4924fbb244] user: dan branch: trunk, size: 72893)
12:00
[3ca5d8b24c] part of check-in [c022f66b5a] Fix a segfault that can occur when querying an empty FTS3 table. Also restore the rowid/docid conflict handling to work as it did in version 3.6.20. (check-in: [c022f66b5a] user: dan branch: trunk, size: 72627)
2009-11-28
21:33
[9b35ff9666] part of check-in [b939a37a8c] Updates to snippet() and offsets() functions of FTS3 so that they work sanely following an OOM fault. (check-in: [b939a37a8c] user: drh branch: trunk, size: 72277)
12:40
[f1bffadc00] part of check-in [eada284bc1] Fix a bug introduced by the fts3 refactoring (segfault when creating a table with zero module args). Also a fix to handle an OOM error. (check-in: [eada284bc1] user: dan branch: trunk, size: 72228)
2009-11-21
03:03
[ac1c03d0df] part of check-in [b6402b2065] Add some missing comments to fts3 files. No source code changes. (check-in: [b6402b2065] user: dan branch: trunk, size: 72195)
2009-11-20
17:23
[69e6fb5a38] part of check-in [cae949ce97] Merge leaf accidentally created by [1c4984c62f]. (check-in: [cae949ce97] user: dan branch: trunk, size: 70960)
05:05
[6b9b4fd998] part of check-in [1cf0e3cc14] Improve comments and other things in fts3_write.c. (check-in: [1cf0e3cc14] user: dan branch: trunk, size: 66144)
02:24
[3c8a5d912a] part of check-in [b456eacbbb] Minor optimizations to fts3 code. (check-in: [b456eacbbb] user: dan branch: trunk, size: 63472)
2009-11-19
15:25
[9048d3c1d5] part of check-in [3b17924754] Fix some fts3 related issues with the autoconf and amalgamation build systems. (check-in: [3b17924754] user: dan branch: fts3-refactor, size: 62781)
00:15
[041f6c4dda] part of check-in [fa0998e19d] Fix problems introduced into fts3 as part of the refactoring. (check-in: [fa0998e19d] user: dan branch: fts3-refactor, size: 62716)
2009-11-18
15:35
[ec6bbf26bf] part of check-in [2fe579e778] Add some missing comments and fix some other issues in fts3 code. (check-in: [2fe579e778] user: dan branch: fts3-refactor, size: 62376)
2009-11-17
12:52
[edf123f978] part of check-in [45c051e786] Improvements to the way fts3 reads the full-text index. (check-in: [45c051e786] user: dan branch: fts3-refactor, size: 59981)
2009-11-13
17:36
Added: [4285a2804e] part of check-in [30a92f1132] Start reworking fts3 code to match the rest of SQLite (code conventions, malloc-failure handling etc.). (check-in: [30a92f1132] user: dan branch: fts3-refactor, size: 57405)