Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for ext/fts3/fts3Int.h
|
2025-05-30
| ||
| 15:43 | [d0f70d602b] part of check-in [22441955e0] Use a more robust backup definition for offsetof(). (check-in: [22441955e0] user: drh branch: trunk, size: 26375) | |
|
2025-03-27
| ||
| 18:22 | [53f00a0d03] part of check-in [c5206cee83] Rearrange #includes in FTS3 to avoid a harmless compiler warning. (check-in: [c5206cee83] user: drh branch: trunk, size: 26386) | |
|
2025-03-14
| ||
| 21:15 | [ad51347fa5] part of check-in [ddfa87c179] Fix one of two flexible arrays in FTS3. (check-in: [ddfa87c179] user: drh branch: flex-array, size: 26266) | |
|
2025-02-27
| ||
| 21:17 | [75b9cf37c9] 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: 25812) | |
|
2025-02-25
| ||
| 20:55 | [adcbaa6d99] part of check-in [af928818a0] Approximately 50 typo fixes, spanning the whole tree, contributed via forum post 006c8fa165083ac3 and individually checked for correctness. Affects only code comments, docs, and a single line of debug output in a test app. (check-in: [af928818a0] user: stephan branch: trunk, size: 25811) | |
|
2025-02-03
| ||
| 23:19 | [2fe7c76dfd] part of check-in [75f3d87448] Fix a potential UAF in FTS3. (check-in: [75f3d87448] user: drh branch: trunk, size: 25810) | |
|
2024-01-16
| ||
| 16:05 | [968f7d7cae] 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: 25760) | |
|
2023-10-21
| ||
| 18:12 | [be68858070] 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: 25703) | |
|
2023-01-25
| ||
| 13:42 | [e573c6d881] part of check-in [a8c91c132f] Fix another problem with fts3/4 auxiliary functions and NEAR expressions that consist entirely of deferred tokens. (check-in: [a8c91c132f] user: dan branch: trunk, size: 25685) | |
|
2022-09-27
| ||
| 01:53 | [ae2a44b04c] 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: 25607) | |
|
2021-12-16
| ||
| 15:29 | [dafdc371f9] part of check-in [a0a8d6c9f0] Fix fts3 and fts4 so that they can still be used even if the other is dropped by a call to sqlite3_drop_modules(). (check-in: [a0a8d6c9f0] user: dan branch: trunk, size: 25607) | |
|
2021-10-20
| ||
| 11:40 | [cff59b8b13] part of check-in [7b7d31a615] Fix a case in the fts3 offsets() function where a corrupt database record could lead to dereferencing an uninitialized pointer. (check-in: [7b7d31a615] user: dan branch: trunk, size: 25583) | |
|
2021-10-04
| ||
| 18:21 | [07cf1abc14] part of check-in [1c67f957fc] Fix harmless static analyzer warnings in sessions, rtree, fts3 and fts5. Add the -DSQLITE_OMIT_AUXILIARY_SAFETY_CHECKS compile-time option to cause ALWAYS() and NEVER() macros to be omitted from the build. (check-in: [1c67f957fc] user: drh branch: fix-warnings, size: 25543) | |
|
2021-03-29
| ||
| 20:04 | [bde280294d] part of check-in [004559544e] Add "#ifdef SQLITE_DEBUG" blocks around test variables sqlite3_fts5_may_be_corrupt and sqlite3_fts3_may_be_corrupt. (check-in: [004559544e] user: dan branch: trunk, size: 25441) | |
|
2020-08-10
| ||
| 19:30 | [045179f538] part of check-in [2a167cfbb2] Fix a problem building fts3 separately from the amalgamation. (check-in: [2a167cfbb2] user: dan branch: trunk, size: 25471) | |
|
2020-07-29
| ||
| 16:18 | [7bb30197de] 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: 25439) | |
|
2020-04-22
| ||
| 11:11 | [2c59cc46ae] part of check-in [e256f85289] Fix an integer overflow in fts3 causing a usan error. (check-in: [e256f85289] user: dan branch: trunk, size: 25438) | |
|
2019-12-14
| ||
| 14:15 | [f091030b97] 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: 25387) | |
|
2019-11-21
| ||
| 14:20 | [ba4e5445a0] part of check-in [2eb997327c] Prevent direct and indirect recursive content= options in fts3/4 and fts5. (check-in: [2eb997327c] user: dan branch: trunk, size: 25217) | |
|
2019-11-17
| ||
| 02:41 | [7201d41971] 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: 25137) | |
|
2019-11-16
| ||
| 23:47 | [31f2ceee08] part of check-in [51525f9c32] More improvements to shadow table corruption detection in FTS3. (check-in: [51525f9c32] user: drh branch: trunk, size: 25064) | |
| 21:40 | [b879664f54] 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: 24808) | |
|
2019-01-25
| ||
| 18:17 | [74384e28b7] part of check-in [b10df2b569] Fix the assert_fts3_nc() macro so that it works for test builds that omit SQLITE_DEBUG. (check-in: [b10df2b569] user: drh branch: trunk, size: 24777) | |
| 14:48 | [24ecc6a79a] 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: 24747) | |
|
2019-01-15
| ||
| 16:14 | [6c666f314c] part of check-in [e54efd60c2] Fix a buffer overread in fts3 caused by a corrupt record. (check-in: [e54efd60c2] user: dan branch: trunk, size: 24366) | |
|
2018-04-27
| ||
| 18:05 | [3378157f38] part of check-in [576a8f69ae] Update test script fts3expr4.test so that it always creates fts3 tokenizers in the "en_US" locality. (check-in: [576a8f69ae] user: dan branch: trunk, size: 24335) | |
|
2017-07-27
| ||
| 14:04 | [f4ee63932f] part of check-in [49cf31da82] A demonstration of how FTS3 cursor pointers can be passed from the MATCH operator to the snippet() function securely and opaquely without having to use the sqlite3_result_pointer() and sqlite3_value_pointer() interfaces. (check-in: [49cf31da82] user: drh branch: pass-pointer-as-blob, size: 24468) | |
|
2017-07-17
| ||
| 09:30 | [6e503a752e] part of check-in [f4f7196b87] Use integer handles for fts3 cursors for a small performance improvement. (check-in: [f4f7196b87] user: dan branch: fts3-int-cursor, size: 24664) | |
|
2017-02-08
| ||
| 19:10 | [eb25020001] part of check-in [9962c10a5c] Avoid preparing a SELECT statement each time an UPDATE or DELETE by docid is executed against an fts3 table. (check-in: [9962c10a5c] user: dan branch: fts3-seekstmt-cache, size: 24324) | |
|
2016-02-11
| ||
| 22:41 | [89d0bd4595] part of check-in [0beb32d20d] Automatically disable FTS3 and FTS4 when building with SQLITE_OMIT_VIRTUALTABLE. (check-in: [0beb32d20d] user: drh branch: trunk, size: 24189) | |
|
2015-09-28
| ||
| 15:23 | [c84125c666] part of check-in [fffab4f70f] Update fts3 to use the onepass strategy for delete operations. (check-in: [fffab4f70f] user: dan branch: vtab-onepass, size: 24056) | |
|
2015-05-25
| ||
| 10:57 | [601743955a] part of check-in [f1e942a1dd] Fix an fts4 matchinf() problem triggered by deferred tokens that are part of phrases that are part of AND expressions. (check-in: [f1e942a1dd] user: dan branch: trunk, size: 23980) | |
|
2015-05-06
| ||
| 17:41 | [142837a754] part of check-in [8c5b9fedfc] More optimization for the 'y' and 'b' matchinfo directives. (check-in: [8c5b9fedfc] user: dan branch: fts3-matchinfo-y, size: 23919) | |
|
2015-05-05
| ||
| 19:37 | [bf61766eeb] part of check-in [dddd7e1829] Optimizations for the matchinfo() function, particularly the 'y' flag. (check-in: [dddd7e1829] user: dan branch: fts3-matchinfo-y, size: 23746) | |
|
2015-05-01
| ||
| 14:07 | [59ecaa2d7a] part of check-in [605347e087] Use the sqlite3Fts3ErrMsg() function to set error message text in FTS3, and to ensure that error messages are not overwritten and thus leaked. (check-in: [605347e087] user: drh branch: trunk, size: 23796) | |
|
2015-04-15
| ||
| 09:16 | [3626655d6b] part of check-in [bd06eeb8d0] Remove an incorrect assert() statement from sqlite3Fts3Dequote(). (check-in: [bd06eeb8d0] user: dan branch: trunk, size: 23748) | |
|
2015-01-27
| ||
| 18:43 | [394858c12a] part of check-in [245e873045] Improve the performance of fts3/4 queries that use the OR operator and at least one auxiliary fts function. (check-in: [245e873045] user: dan branch: trunk, size: 23573) | |
|
2014-07-03
| ||
| 12:18 | [53d4eca1fb] part of check-in [0cc0230ae9] Change fts3/4 so that the "unicode61" is included in builds by default. It may now be excluded by defining SQLITE_DISABLE_FTS3_UNICODE. (check-in: [0cc0230ae9] user: dan branch: trunk, size: 23439) | |
|
2014-05-14
| ||
| 15:58 | [16cddf2d7b] 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: 23439) | |
|
2014-05-12
| ||
| 20:04 | [b250b15476] 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: 23427) | |
|
2014-03-12
| ||
| 19:20 | [bdeb901540] 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: 23427) | |
|
2013-11-12
| ||
| 17:46 | [eb5f802958] 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: 23414) | |
|
2013-10-02
| ||
| 08:04 | [8689f7cf85] 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: 23251) | |
|
2013-09-30
| ||
| 11:42 | [0634f768e7] part of check-in [6622424a3a] Have fts4 full-text queries consider "docid<?" and similar constraints. (check-in: [6622424a3a] user: dan branch: fts4-docid-range-constraints, size: 23066) | |
|
2013-07-04
| ||
| 23:53 | [c7a451661c] part of check-in [f2ab874782] Modify several extensions to use the new exported function naming. Fix some shared library compilation issues. (check-in: [f2ab874782] user: mistachkin branch: extRefactor, size: 22476) | |
|
2013-06-21
| ||
| 18:36 | [a50cd231e9] part of check-in [096ae1d8f9] Remove an unused function declaration from the FTS3 source code. (check-in: [096ae1d8f9] user: drh branch: trunk, size: 22501) | |
| 17:30 | [2659cdfc8c] part of check-in [8ff2b8f594] Add the "notindexed" option to fts4. (check-in: [8ff2b8f594] user: dan branch: fts4-notindexed, size: 22539) | |
|
2013-06-19
| ||
| 20:13 | [9bef3710aa] 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: 22662) | |
|
2013-06-11
| ||
| 14:22 | [cb4df04cf8] part of check-in [24fc9d4438] Add the SQLITE_FTS3_MAX_EXPR_DEPTH compile time option. (check-in: [24fc9d4438] user: dan branch: trunk, size: 22469) | |
|
2013-05-07
| ||
| 12:16 | [0b167bed9e] part of check-in [0ba67b64de] Modify the fts3tokenize table implementation so that it does not use the SQL function fts3_tokenizer. The user may have installed an authorizer callback that prohibits this. (check-in: [0ba67b64de] user: dan branch: trunk, size: 22040) | |
|
2013-04-29
| ||
| 18:07 | [23ea0a2bb7] part of check-in [f480b1fe60] Improve the error message issued when an FTS query exceeds the maximum allowable tree depth. (check-in: [f480b1fe60] user: dan branch: trunk, size: 22028) | |
|
2013-04-22
| ||
| 17:07 | [352c8a83ee] part of check-in [2b3fed09eb] Update MSVC makefile for the fts3tokenize virtual table. Clear some harmless compiler warnings in the fts3tokenize code. (check-in: [2b3fed09eb] user: drh branch: trunk, size: 22019) | |
|
2012-08-20
| ||
| 17:24 | [1e58825246] part of check-in [e799222f3b] Add the SQLITE_DISABLE_FTS4_DEFERRED compile time option. (check-in: [e799222f3b] user: dan branch: trunk, size: 21957) | |
|
2012-06-06
| ||
| 19:51 | [81115435f7] part of check-in [eccd6b6580] Disable FTS unicode61 by default. It is enabled by specifying compile time option SQLITE_ENABLE_FTS4_UNICODE61. (check-in: [eccd6b6580] user: dan branch: trunk, size: 21663) | |
| 19:30 | [11c7110684] part of check-in [790f76a589] Have the FTS unicode61 strip out diacritics when tokenizing text. This can be disabled by specifying the tokenizer option "remove_diacritics=0". (check-in: [790f76a589] user: dan branch: trunk, size: 21663) | |
|
2012-05-25
| ||
| 17:50 | [7b163fa22e] part of check-in [0c13570ec7] Add an experimental tokenizer to fts4 - "unicode". This tokenizer works in the same way except that it understands unicode "simple case folding" and recognizes all characters not classified as "Letters" or "Numbers" by unicode as token separators. (check-in: [0c13570ec7] user: dan branch: fts4-unicode, size: 21579) | |
|
2012-05-10
| ||
| 17:43 | [aca752b99c] part of check-in [4d3e1673b3] Have the FTS auxiliary functions correctly handle terms that appear in non-matching branches of the FTS expression. Fix for [bdc6bbbb38]. (check-in: [4d3e1673b3] user: dan branch: trunk, size: 21434) | |
|
2012-03-28
| ||
| 18:08 | [d03b8cf010] 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: 21426) | |
|
2012-03-27
| ||
| 15:00 | [5fd2ec4e47] 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: 21427) | |
|
2012-03-26
| ||
| 10:36 | [133e5c613a] part of check-in [40fc880474] Add an experimental integrity-check function to FTS. (check-in: [40fc880474] user: dan branch: fts4-incr-merge, size: 21357) | |
|
2012-03-24
| ||
| 17:29 | [eb749124db] 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: 21295) | |
| 16:11 | [6d4ffaca18] part of check-in [67a0cffc9d] Remove the Fts3Table.mxLevel variable. (check-in: [67a0cffc9d] user: dan branch: fts4-incr-merge, size: 21244) | |
| 14:45 | [f65df0fd76] 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: 21323) | |
| 02:20 | [1e635c9ba3] part of check-in [ed69434cd8] An attempt at automatic incremental merging for FTS4. (check-in: [ed69434cd8] user: drh branch: fts4-auto-incr-merge, size: 21278) | |
|
2012-03-23
| ||
| 18:26 | [5fe1651db8] 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: 21013) | |
|
2012-03-17
| ||
| 16:56 | [caa745f804] 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: 20935) | |
|
2012-03-14
| ||
| 20:01 | [1da6d2af6b] part of check-in [570473729d] Add tests for incremental merge code. (check-in: [570473729d] user: dan branch: fts4-incr-merge, size: 20769) | |
|
2012-03-08
| ||
| 18:39 | [cc8991daf6] 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: 20769) | |
|
2012-03-03
| ||
| 18:46 | [d1d7f964dd] 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: 20714) | |
|
2012-03-02
| ||
| 12:26 | [521d300f2a] part of check-in [65fa693729] Fix the FTS 'optimize' command on multi-lingual databases. (check-in: [65fa693729] user: dan branch: fts4-languageid, size: 20602) | |
|
2012-03-01
| ||
| 19:44 | [8ba2d8ce5d] 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: 20602) | |
|
2012-01-25
| ||
| 16:29 | [ce958a6fa9] 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: 20346) | |
|
2011-10-19
| ||
| 16:20 | [def7a900f9] part of check-in [8a4077057d] Merge the fts4-content branch with the trunk. (check-in: [8a4077057d] user: dan branch: trunk, size: 20341) | |
| 15:52 | [74afec8005] part of check-in [df36ac9481] Have FTS3 ignore ^ prefixes. The ^ syntax is only supported on FTS4 tables. (check-in: [df36ac9481] user: dan branch: fts4-content, size: 20184) | |
| 11:57 | [7a0deb2193] 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: 20179) | |
|
2011-10-18
| ||
| 19:39 | [bc27eebe2c] 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: 20070) | |
|
2011-10-13
| ||
| 17:16 | [59c5a9475f] 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: 20046) | |
|
2011-10-04
| ||
| 16:37 | [06f442ce09] part of check-in [be86c7061b] Add tests to check that modifying the schema of an FTS content table does not cause a crash in the FTS module. Also disable the deferred token optimization for content=xxx FTS tables. (check-in: [be86c7061b] user: dan branch: fts4-content, size: 19990) | |
| 11:22 | [a335d671d4] part of check-in [1d27ea741f] Add experimental 'content' option to FTS4. (check-in: [1d27ea741f] user: dan branch: fts4-content, size: 20021) | |
|
2011-07-09
| ||
| 16:17 | [30063fdd0b] part of check-in [90b1aea174] Fix harmless compiler warnings on unix. (check-in: [90b1aea174] user: drh branch: trunk, size: 19889) | |
|
2011-07-07
| ||
| 07:37 | [d18022edfa] part of check-in [f244b2f395] Remove accidental global variable "doclist" from fts3Int.h. (check-in: [f244b2f395] user: dan branch: trunk, size: 20256) | |
|
2011-06-28
| ||
| 09:51 | [e670e2c58b] part of check-in [226686475c] Merge latest trunk changes with fts3-changes branch. (check-in: [226686475c] user: dan branch: fts3-changes, size: 20264) | |
| 07:15 | [61c90f512b] part of check-in [29e69f389c] Changes to allow FTS to be compiled as a loadable module again. (check-in: [29e69f389c] user: dan branch: trunk, size: 20365) | |
|
2011-06-23
| ||
| 17:09 | [7b452eeb59] part of check-in [8230d83120] Fix some of the code issues (missing comments etc.) in the new FTS code. (check-in: [8230d83120] user: dan branch: fts3-changes, size: 20049) | |
|
2011-06-20
| ||
| 19:00 | [fa493ccbad] part of check-in [ed2dda9329] More compiler warning fixes. (check-in: [ed2dda9329] user: drh branch: trunk, size: 20150) | |
|
2011-06-17
| ||
| 17:37 | [8ece4390eb] part of check-in [8f939723f7] Avoid loading doclists for infrequent terms that are part of phrases twice. (check-in: [8f939723f7] user: dan branch: trunk, size: 20150) | |
| 16:04 | [974cf471fa] part of check-in [3bfd4466f5] Add a missing declaration to fts3Int.h. (check-in: [3bfd4466f5] user: dan branch: trunk, size: 20202) | |
|
2011-06-16
| ||
| 16:06 | [df761492ae] 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: 20145) | |
| 00:54 | [27b0b75c4d] 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: 20129) | |
|
2011-06-08
| ||
| 18:39 | [a999cfbf60] 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: 19758) | |
|
2011-06-04
| ||
| 20:04 | [d76b021d5b] 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: 19775) | |
|
2011-06-03
| ||
| 18:00 | [ba6f831fcd] 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: 19621) | |
|
2011-06-02
| ||
| 19:57 | [ab1489076e] 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: 19973) | |
|
2011-05-28
| ||
| 15:57 | [832f4d421f] part of check-in [84097a4c75] Minor changes made while planning a larger change. (check-in: [84097a4c75] user: dan branch: fts3-prefix-search, size: 17572) | |
|
2011-05-25
| ||
| 18:34 | [deeeac21d1] 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: 17813) | |
|
2011-05-24
| ||
| 18:49 | [02699211c0] 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: 17033) | |
| 15:36 | [c8c0011c5e] part of check-in [651ef24249] Do not invoke the xRollbackTo or xRelease methods of a virtual table without having first invoked an appropriate xSavepoint method. Add assert() statements to FTS3/4 to verify that this is happening in all cases. (check-in: [651ef24249] user: drh branch: trunk, size: 16114) | |
|
2011-05-17
| ||
| 14:41 | [05d1451526] part of check-in [f392b7ae02] Avoid including fts3_term.c in the amalgamation, as it contains test code only. (check-in: [f392b7ae02] user: dan branch: trunk, size: 15227) | |
|
2011-05-04
| ||
| 12:52 | [8c2ac39ee1] part of check-in [13395121e3] Optimize "ORDER BY rowid/docid DESC/ASC" clauses on FTS tables. (check-in: [13395121e3] user: dan branch: vtab-conflict, size: 15189) | |
|
2011-02-02
| ||
| 17:30 | [945926ea4b] 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: 15102) | |
|
2011-02-01
| ||
| 16:34 | [d833c1df0d] 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: 15051) | |
|
2010-11-26
| ||
| 16:49 | [a6c69c1c5e] part of check-in [c412f61229] Fix various compiler warnings. (check-in: [c412f61229] user: drh branch: trunk, size: 13800) | |
|
2010-11-24
| ||
| 11:51 | [52c818623c] 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: 13825) | |
|
2010-11-23
| ||
| 19:16 | [0f7b9f189b] part of check-in [9cf0f2b76b] Experimental changes to fts3 function matchinfo(). (check-in: [9cf0f2b76b] user: dan branch: fts3-experimental, size: 13940) | |
|
2010-11-02
| ||
| 17:41 | [bbcd6d6712] 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: 13572) | |
|
2010-10-26
| ||
| 07:14 | [819bc2661c] part of check-in [7a2f286400] More coverage tests for fts3.c. (check-in: [7a2f286400] user: dan branch: experimental, size: 13557) | |
|
2010-10-23
| ||
| 19:07 | [11fa12ce04] part of check-in [deb80eac91] Fixes for the matchinfo() function related to FTS4 common token handling. (check-in: [deb80eac91] user: dan branch: experimental, size: 13469) | |
|
2010-10-22
| ||
| 16:44 | [068d80157c] 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: 12800) | |
|
2010-10-21
| ||
| 15:49 | [f80be5abfb] part of check-in [fd1e5cade0] Merge trunk changes into experimental branch. (check-in: [fd1e5cade0] user: dan branch: experimental, size: 12843) | |
|
2010-10-20
| ||
| 18:56 | [9fbe422f7d] 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: 12844) | |
|
2010-10-19
| ||
| 14:08 | [a640e4fbdb] 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: 12721) | |
|
2010-09-17
| ||
| 15:28 | [b4f0b05cca] 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: 12332) | |
|
2010-03-23
| ||
| 18:24 | [70528ba8c3] part of check-in [892e286709] More commenting and documentation enhancements in FTS3. (check-in: [892e286709] user: drh branch: trunk, size: 12294) | |
|
2010-02-03
| ||
| 19:55 | [df812ef35f] 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: 11967) | |
|
2010-01-06
| ||
| 17:19 | [45bc7e2848] part of check-in [8a208223a7] Change the fts3 snippet function to return (hopefully) more relevant snippets in less time. (check-in: [8a208223a7] user: dan branch: trunk, size: 11652) | |
|
2010-01-02
| ||
| 19:02 | [9326800fa1] part of check-in [51f7ee8440] Add experimental implementation of FTS3 functions matchinfo() and snippet() (not enabled by default). (check-in: [51f7ee8440] user: dan branch: trunk, size: 11697) | |
|
2009-12-22
| ||
| 18:56 | [0d7c8d66ff] part of check-in [37a1de02d1] Add the experimental FTS3 matchinfo() function. Provides details of the match that may be used for result ranking and other purposes. (check-in: [37a1de02d1] user: dan branch: trunk, size: 11045) | |
|
2009-12-12
| ||
| 09:51 | [6fdd41b4f2] part of check-in [8fcb0478c8] Add coverage test cases for fts3. (check-in: [8fcb0478c8] user: dan branch: trunk, size: 10364) | |
|
2009-12-10
| ||
| 16:04 | [1419e2973b] 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: 10347) | |
|
2009-12-08
| ||
| 19:05 | [36f8e6d6fa] part of check-in [f0eac4175a] Add tests to improve coverage of fts3. Associated bugfixes. (check-in: [f0eac4175a] user: dan branch: trunk, size: 10266) | |
|
2009-12-03
| ||
| 17:36 | [cc716c74af] part of check-in [75863c2d55] Fix an incorrect assert() in fts3.c. Add further fts3 tests. (check-in: [75863c2d55] user: dan branch: trunk, size: 10267) | |
| 06:26 | [515132f0ae] part of check-in [37495b55ff] Updates to FTS3 to correct compiler warnings under MSVC. (check-in: [37495b55ff] user: shaneh branch: trunk, size: 10201) | |
|
2009-12-01
| ||
| 17:08 | [7bc65d9ada] part of check-in [7737db490c] Use #include "sqlite3.h" instead of <sqlite3.h> in fts3Int.h. (check-in: [7737db490c] user: dan branch: trunk, size: 9928) | |
| 17:05 | [2d5dab9279] part of check-in [fa56c1c472] Add typedefs for i16 and u8 to fts3Int.h when not building via the amalgamation method. (check-in: [fa56c1c472] user: dan branch: trunk, size: 9928) | |
| 13:57 | [58698ec42a] part of check-in [58113932d9] Changes to the TCL interface header to allow it to be compiled independently from the amalgamation. (check-in: [58113932d9] user: drh branch: trunk, size: 9778) | |
|
2009-11-30
| ||
| 19:48 | [cc08454bc8] part of check-in [6d112bfd53] Test coverage improvements in the FTS3 porter stemmer. (check-in: [6d112bfd53] user: drh branch: trunk, size: 8870) | |
|
2009-11-20
| ||
| 02:24 | [74b21db1c4] part of check-in [b456eacbbb] Minor optimizations to fts3 code. (check-in: [b456eacbbb] user: dan branch: trunk, size: 8703) | |
|
2009-11-18
| ||
| 15:35 | [f7488bbc9f] 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: 8318) | |
|
2009-11-17
| ||
| 12:52 | [5c040c0fb4] part of check-in [45c051e786] Improvements to the way fts3 reads the full-text index. (check-in: [45c051e786] user: dan branch: fts3-refactor, size: 8327) | |
|
2009-11-14
| ||
| 18:41 | [f8419da445] part of check-in [c27d46b33e] Further OOM testing for fts3 code. Add Tcl code implementing an integrity-check for fts3. (check-in: [c27d46b33e] user: dan branch: fts3-refactor, size: 8111) | |
|
2009-11-13
| ||
| 17:36 | Added: [a6aa1a4ad2] 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: 8037) | |