Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for ext/fts5/fts5_expr.c
|
2025-03-17
| ||
| 15:13 | [be9e5f7f11] part of check-in [1a5283d7da] Prevent integer overflow when parsing NEAR queries in FTS5. (check-in: [1a5283d7da] user: drh branch: trunk, size: 93691) | |
|
2025-03-15
| ||
| 12:22 | [887a611b34] part of check-in [16dfc415b6] Use flexible arrays whereever appropriate in FTS5. (check-in: [16dfc415b6] user: drh branch: flex-array, size: 93609) | |
|
2025-03-14
| ||
| 23:57 | [390502c995] part of check-in [0c4d9c7474] Turn Fts5Colset.aiCol into a flexible array. (check-in: [0c4d9c7474] user: drh branch: flex-array, size: 93236) | |
|
2025-02-27
| ||
| 21:17 | [4a35c6edc4] 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: 93318) | |
|
2024-09-25
| ||
| 18:55 | [69b8d97605] part of check-in [204ddf4e72] Change the way tokendata indexes are collected for prefix queries. (check-in: [204ddf4e72] user: dan branch: fts5-tokendata-prefix, size: 93319) | |
|
2024-09-14
| ||
| 20:30 | [1f60d81aa4] part of check-in [97c2824f47] Fix the fts5 xInstToken() API for prefix queries that do not use prefix-indexes. This is experimental. (check-in: [97c2824f47] user: dan branch: fts5-tokendata-prefix, size: 93277) | |
|
2024-08-17
| ||
| 19:11 | [9a56f53700] part of check-in [6a8ff9ba5e] Merge trunk changes into this branch. (check-in: [6a8ff9ba5e] user: dan branch: fts5-locale, size: 93305) | |
| 19:07 | [2667e822e9] part of check-in [f4b839e526] Tests to improve coverage of fts5_expr.c. (check-in: [f4b839e526] user: dan branch: fts5-locale, size: 93125) | |
|
2024-08-14
| ||
| 14:26 | [4b7734db98] part of check-in [317c91edfc] Fix an assert() in fts5 that might fail with an expression like "... NOT ''". (check-in: [317c91edfc] user: dan branch: trunk, size: 93581) | |
|
2024-08-10
| ||
| 20:03 | [ee1949c5c2] part of check-in [b243007525] Merge trunk changes into this branch. (check-in: [b243007525] user: dan branch: fts5-locale, size: 93400) | |
| 18:59 | [16fdd35ebf] part of check-in [03e63ed24e] Update the fts5_tokenizer_v2 API so that the locale is passed as parameter to xTokenize(), instead of via a separate call to xSetLocale(). (check-in: [03e63ed24e] user: dan branch: fts5-locale, size: 93147) | |
| 11:02 | [d6a48d81aa] part of check-in [6047b18ee3] Cherrypick various minor fixes from trunk into branch-3.46. (check-in: [6047b18ee3] user: drh branch: branch-3.46, size: 93093) | |
|
2024-08-08
| ||
| 15:07 | [3a24c6ab5b] part of check-in [797b0a13fd] Add assert() statements and reorganize code slightly in fts3 and fts5 to make it easier to follow. (check-in: [797b0a13fd] user: dan branch: trunk, size: 93401) | |
|
2024-08-07
| ||
| 21:20 | [29558460f1] part of check-in [08cc548840] Fix a broken assert in fts5_expr.c. (check-in: [08cc548840] user: dan branch: trunk, size: 93210) | |
|
2024-07-02
| ||
| 13:54 | [c7336d5f9e] part of check-in [77a76654e6] Add assert() statements to FTS5 to hush-up warnings from scan-build. (check-in: [77a76654e6] user: drh branch: trunk, size: 93148) | |
|
2024-06-24
| ||
| 16:08 | [fb26894f8d] part of check-in [56d265f956] Fix some problems with calling fts5 api functions from within non-full-text queries. (check-in: [56d265f956] user: dan branch: trunk, size: 93041) | |
|
2024-05-24
| ||
| 21:23 | [85789f6fb0] part of check-in [061d7b69e6] Fix a crash in fts5 that could occur within "PRAGMA integrity_check" if the specified tokenizer was unknown. (check-in: [061d7b69e6] user: dan branch: trunk, size: 93031) | |
|
2024-05-14
| ||
| 17:16 | [a84df51a1d] part of check-in [ca4fdcb8ae] Have fts5 tables delay initializing the tokenizer until it is first used in all cases where the tokenizer is not "trigram". (check-in: [ca4fdcb8ae] user: dan branch: fts5-delay-tokenizer, size: 92982) | |
|
2024-04-16
| ||
| 14:23 | [f1e9110062] part of check-in [c2f9d1259c] Add some tests for the fts5 tokenize-blob functionality on this branch. (check-in: [c2f9d1259c] user: dan branch: fts5-tokenize-blob, size: 93175) | |
|
2023-12-28
| ||
| 16:25 | [e91156ebdc] part of check-in [3cd5ef44e4] Fix harmless compiler warnings in FTS5. (check-in: [3cd5ef44e4] user: drh branch: trunk, size: 92966) | |
|
2023-12-26
| ||
| 15:52 | [e5fb9dd9e3] part of check-in [1a8a9b1c89] Ensure that the xColumnText(), xQueryPhrase() and xPhraseFirstColumn() APIs all return SQLITE_RANGE if they are passed a bad column or phrase number. (check-in: [1a8a9b1c89] user: dan branch: trunk, size: 92946) | |
|
2023-12-14
| ||
| 15:38 | [248ecadbac] part of check-in [90135efccf] Fix harmless compiler warnings in JSON and FTS5. (check-in: [90135efccf] user: drh branch: trunk, size: 92795) | |
|
2023-12-05
| ||
| 18:36 | [b1ec526371] part of check-in [59d008b6c2] Further tests for the new code on this branch. (check-in: [59d008b6c2] user: dan branch: fts5-token-data, size: 92769) | |
|
2023-12-04
| ||
| 18:45 | [920516be4a] part of check-in [78fbb71598] Fixes for xInstToken() with tokendata=0 tables. And with prefix queries. (check-in: [78fbb71598] user: dan branch: fts5-token-data, size: 92718) | |
| 17:45 | [aec893108d] part of check-in [317a50563d] Fix a problem with the xInstCount() API and "ORDER BY rank" queries. (check-in: [317a50563d] user: dan branch: fts5-token-data, size: 92515) | |
|
2023-12-02
| ||
| 20:35 | [5619c3fab4] part of check-in [3a623cfa17] Fix various compiler warnings and other problems with the new code on this branch. (check-in: [3a623cfa17] user: dan branch: fts5-token-data, size: 92538) | |
| 17:32 | [f83259b52b] part of check-in [7bda09ab40] Ensure that tokendata=1 queries avoid loading large doclists for queries like "common AND uncommon", just as tokendata=0 queries do. (check-in: [7bda09ab40] user: dan branch: fts5-token-data, size: 92267) | |
|
2023-12-01
| ||
| 20:09 | [aac8026aed] part of check-in [c523f40895] Different approach to querying a tokendata=1 table. Saves cpu and memory. (check-in: [c523f40895] user: dan branch: fts5-token-data, size: 92209) | |
|
2023-11-22
| ||
| 20:02 | [5d557c7ebe] part of check-in [9b005085ff] Defer building xInstToken() hash-table until it is to be used. (check-in: [9b005085ff] user: dan branch: fts5-token-data, size: 92119) | |
| 19:02 | [0d846134ea] part of check-in [37b271c19d] Fix tokendata=1 and xInstToken() APIs for detail=none and detail=column tables. (check-in: [37b271c19d] user: dan branch: fts5-token-data, size: 92389) | |
|
2023-11-15
| ||
| 11:45 | [4b50ed0c72] part of check-in [a34b26fe7f] Add implementation of xInstToken() API. (check-in: [a34b26fe7f] user: dan branch: fts5-token-data, size: 91291) | |
|
2023-11-13
| ||
| 14:29 | [69c81af515] part of check-in [828566392b] Add new fts5 API xQueryToken(). (check-in: [828566392b] user: dan branch: fts5-token-data, size: 90780) | |
|
2023-10-11
| ||
| 21:08 | [fd091d0558] part of check-in [122935182a] Add the tokendata=1 option to ignore trailing token-data when querying an fts5 table. (check-in: [122935182a] user: dan branch: fts5-token-data, size: 90261) | |
|
2023-10-03
| ||
| 19:06 | [cc215d3971] part of check-in [342c8d0783] Fixes for fts5 expression parser module to allow embedded 0x00 bytes in tokens. (check-in: [342c8d0783] user: dan branch: fts5-token-data, size: 89829) | |
|
2023-08-15
| ||
| 14:53 | [bd3b81ce66] part of check-in [c16ed3b1cc] Fix problems in fts5 test code. (check-in: [c16ed3b1cc] user: dan branch: trunk, size: 89667) | |
|
2023-07-12
| ||
| 18:38 | [2473c13542] part of check-in [383de8e225] Get access to SQL functions and virtual tables used for debugging and analysis of FTS5 using SQLITE_FTS5_DEBUG and without the need for SQLITE_TEST. (check-in: [383de8e225] user: drh branch: fts5-contentless-delete, size: 89602) | |
|
2023-05-15
| ||
| 17:14 | [58fb8ceddf] part of check-in [0e5c1ee40a] Limit the number of nested NOT nodes in an fts5 expression to 256. (check-in: [0e5c1ee40a] user: dan branch: fts5-expr-limit, size: 89512) | |
|
2023-04-22
| ||
| 20:47 | [7d298d76ea] part of check-in [33681ff3d2] Avoid a crash in fts5 when combining an empty expression with another. (check-in: [33681ff3d2] user: dan branch: trunk, size: 87993) | |
|
2023-02-10
| ||
| 17:17 | [48e8e45261] part of check-in [00714b39b3] Fix a problem with the fts5 trigram tokenizer and LIKE or GLOB patterns for which contain runs of 2 or fewer non-wildcard characters that are 3 or more bytes when encoded as utf-8. (check-in: [00714b39b3] user: dan branch: trunk, size: 87978) | |
|
2022-04-07
| ||
| 10:11 | [40174a6482] part of check-in [61095b5bcb] Fix harmless compiler warnings. (check-in: [61095b5bcb] user: drh branch: trunk, size: 87621) | |
|
2021-11-02
| ||
| 07:32 | [fcd0770d53] part of check-in [0a5b94b99c] Fix a broken assert() in fts5 that could fail if the snippet() function were used with a query phrase containing 0 tokens on a detail=none or detail=col table. (check-in: [0a5b94b99c] user: dan branch: trunk, size: 87521) | |
|
2021-10-05
| ||
| 17:41 | [cd20586681] part of check-in [36177a62fe] Fixes for harmless static-analyzer warnings. This also makes the code easier for humans to understand. (check-in: [36177a62fe] user: drh branch: trunk, size: 87081) | |
|
2021-10-04
| ||
| 18:21 | [11cc2acd3d] 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: 87057) | |
|
2021-06-30
| ||
| 14:04 | [6ea447b0cb] part of check-in [7c279670f5] Fix a memory leak in fts5 that could occur when processing a query containing multiple classes of error. (check-in: [7c279670f5] user: dan branch: trunk, size: 87038) | |
|
2021-04-22
| ||
| 19:34 | [9462249a3b] part of check-in [1427391597] Fix harmless compiler warnings of unused function parameters in FTS5. (check-in: [1427391597] user: drh branch: trunk, size: 87171) | |
|
2021-04-19
| ||
| 16:45 | [5d0ab73f08] part of check-in [c68a6c6c89] Remove fts5 test functions fts5_expr(), fts5_expr_tcl(), fts5_isalnum() and fts5_fold() from release builds. (check-in: [c68a6c6c89] user: dan branch: trunk, size: 87142) | |
|
2020-12-15
| ||
| 13:55 | [016bd06030] part of check-in [ea0a7f103a] Change an fts5 assert() that can be triggered by a corrupt database to an if() condition. (check-in: [ea0a7f103a] user: dan branch: trunk, size: 87038) | |
|
2020-10-05
| ||
| 16:41 | [e527e3a741] part of check-in [64782463be] Allow fts5 trigram tables created with detail=column or detail=none to optimize LIKE and GLOB queries. Allow case-insensitive tables to optimize GLOB as well as LIKE. (check-in: [64782463be] user: dan branch: trunk, size: 87038) | |
|
2020-10-01
| ||
| 16:10 | [7eba8fed2a] part of check-in [897ced99b4] Add tests for the trigram tokenizer. Fix minor issues. (check-in: [897ced99b4] user: dan branch: fts5-trigram, size: 84757) | |
|
2020-09-30
| ||
| 20:35 | [e1f548de5e] part of check-in [0d7810c1ae] Add experimental unicode-aware trigram tokenizer to fts5. And support for LIKE and GLOB optimizations for fts5 tables that use said tokenizer. (check-in: [0d7810c1ae] user: dan branch: fts5-trigram, size: 84373) | |
|
2020-09-11
| ||
| 15:01 | [b7b28ed203] part of check-in [b79f19edfd] Catch fts5 index corruption caused by issuing 'delete' commands with incorrect data earlier in some cases. Also fix a couple of test script problems. (check-in: [b79f19edfd] user: dan branch: trunk, size: 83041) | |
|
2020-08-28
| ||
| 11:19 | [6393974bd3] part of check-in [1a04920998] Add fts5 test to confirm that for a table with columns a, b, c and d, "{a b}" and "-{c d}" are handled similarly. (check-in: [1a04920998] user: dan branch: trunk, size: 83013) | |
|
2020-07-29
| ||
| 16:18 | [c1cc78909d] 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: 82743) | |
|
2019-12-09
| ||
| 02:20 | [2be4564847] part of check-in [c5d4414359] Fix possible null pointer dereferences in the fts5_expr() scalar function. (check-in: [c5d4414359] user: dan branch: trunk, size: 82742) | |
|
2019-09-12
| ||
| 19:38 | [5661fe64f4] part of check-in [9d418a7a49] Allow fts5 to filter on multiple MATCH clauses in a single scan. (check-in: [9d418a7a49] user: dan branch: trunk, size: 82679) | |
|
2019-03-20
| ||
| 05:45 | [840c88d55e] part of check-in [1c0fe5b576] Fix various harmless compiler warnings seen with MSVC. (check-in: [1c0fe5b576] user: mistachkin branch: noWarnings, size: 81784) | |
|
2019-01-08
| ||
| 20:02 | [188d1dca5a] part of check-in [ca67f2ec0e] Use 64-bit math to compute the sizes of memory allocations in extensions. (check-in: [ca67f2ec0e] user: drh branch: trunk, size: 81752) | |
|
2018-12-28
| ||
| 07:37 | [0eff5bad90] part of check-in [c564bf8701] Fix problems in fts5 found by ASAN. (check-in: [c564bf8701] user: dan branch: trunk, size: 81566) | |
|
2018-07-13
| ||
| 19:52 | [5aef080ba3] part of check-in [80d2b9e635] Add the "categories" option to the unicode61 tokenizer in fts5. (check-in: [80d2b9e635] user: dan branch: trunk, size: 81561) | |
|
2018-06-30
| ||
| 20:26 | [4ff8203769] part of check-in [65ff5144a5] Avoid a warning in fts5.c due to not using generated routine sqlite3Fts5ParserFallback(). (check-in: [65ff5144a5] user: dan branch: trunk, size: 81380) | |
|
2018-03-07
| ||
| 14:49 | [c23a2e4c14] part of check-in [2d544711c7] Fix harmless compiler warning in FTS5. (check-in: [2d544711c7] user: mistachkin branch: msvcFixes, size: 81272) | |
|
2017-11-24
| ||
| 19:24 | [01048018d2] part of check-in [24d7058e27] Add the "^" syntax from fts3/4 to fts5. (check-in: [24d7058e27] user: dan branch: trunk, size: 81268) | |
|
2017-04-13
| ||
| 09:45 | [f2825f714d] part of check-in [6f54ffd151] Allow a user column name to be used on the LHS of a MATCH operator in FTS5. (check-in: [6f54ffd151] user: dan branch: trunk, size: 80420) | |
|
2017-04-12
| ||
| 17:50 | [e5522f89e5] part of check-in [c847543f8b] Update fts5 to support "<colset> : ( <expr> )" for column filtering, as well as "<colset> : NEAR(...)" and "<colset> : <phrase>". (check-in: [c847543f8b] user: dan branch: trunk, size: 79962) | |
|
2017-02-21
| ||
| 17:52 | [c6ecc22801] part of check-in [e400909f31] Fix an FTS5 problem that could cause a crash when certain queries were interrupted using sqlite3_interrupt(). (check-in: [e400909f31] user: dan branch: trunk, size: 77252) | |
|
2017-01-23
| ||
| 07:06 | [33f0e8063a] part of check-in [03c601344e] Fix a problem preventing FTS5 from correctly passing the FTS5_TOKENIZE_PREFIX flag to custom tokenizer implementations. (check-in: [03c601344e] user: dan branch: trunk, size: 77063) | |
|
2016-12-09
| ||
| 16:12 | [dc2cee9f56] part of check-in [0ea3ece988] Fix an fts5 bug that could cause a crash following an OOM error or sqlite3_interrupt() interrupt. (check-in: [0ea3ece988] user: dan branch: trunk, size: 77062) | |
|
2016-11-28
| ||
| 14:52 | [34ece379a8] part of check-in [7cc2d60dce] Simplify some code in fts5_expr.c. Add some extra test cases for the same. (check-in: [7cc2d60dce] user: dan branch: trunk, size: 77034) | |
|
2016-11-14
| ||
| 08:19 | [e124219467] part of check-in [e78f6f3bbf] Fix an fts5 problem causing a crash in phrase queries where the first token of the phrase matches one or more rows but some other token within the phrase matches zero. (check-in: [e78f6f3bbf] user: dan branch: trunk, size: 76687) | |
|
2016-09-21
| ||
| 19:43 | [c65c5629f4] part of check-in [0741812d7f] Fix a problem with the fts5 auxiliary function API causing a crash when a query contained a phrase of zero terms. (check-in: [0741812d7f] user: dan branch: trunk, size: 76672) | |
|
2016-08-13
| ||
| 06:38 | [1ee9715642] part of check-in [fcfbee6c7d] Fix a buffer overread in fts5. (check-in: [fcfbee6c7d] user: dan branch: trunk, size: 76412) | |
|
2016-08-09
| ||
| 19:48 | [df0004b5bf] part of check-in [14864f2b84] Minor update to the way fts5 column filters are parsed. (check-in: [14864f2b84] user: dan branch: trunk, size: 76408) | |
| 19:26 | [8e975ae07d] part of check-in [e517545650] Have fts5 interpret column lists that begin with a "-" character as "match any column except" lists. (check-in: [e517545650] user: dan branch: trunk, size: 77734) | |
|
2016-05-30
| ||
| 08:28 | [bcb238ee4a] part of check-in [64ca1a835a] Fix an FTS5 problem (segfault or incorrect query results) with "... MATCH 'x OR y' ORDER BY rank" queries when either token 'x' or 'y' is completely absent from the dataset. (check-in: [64ca1a835a] user: dan branch: trunk, size: 75698) | |
|
2016-05-09
| ||
| 18:05 | [da2b33c2aa] part of check-in [48505cde05] Fix the FTS5 xQueryPhrase() API function so that it recognizes column filters. (check-in: [48505cde05] user: dan branch: trunk, size: 75942) | |
|
2016-03-23
| ||
| 15:04 | [5ca4bafe29] part of check-in [70fc69eed9] Explicitly limit the size of fts5 tokens to 32768 bytes. (check-in: [70fc69eed9] user: dan branch: trunk, size: 75558) | |
|
2016-03-16
| ||
| 19:53 | [35e9d92c89] part of check-in [d9b5ff7aba] Add a cast to an implict (size_t -> int) conversion in fts5_expr.c. (check-in: [d9b5ff7aba] user: dan branch: trunk, size: 75428) | |
|
2016-03-14
| ||
| 12:16 | [be309fb227] part of check-in [54b8968e33] Fix a memory leak in fts5 that could occur following a syntax error in a query expression. (check-in: [54b8968e33] user: dan branch: trunk, size: 75423) | |
|
2016-03-12
| ||
| 19:33 | [f11757a251] part of check-in [10a827ae5f] Fix a problem handling 'NEAR("" token)' in fts5 found by fuzzing. (check-in: [10a827ae5f] user: dan branch: trunk, size: 75370) | |
| 16:32 | [c4166ba0de] part of check-in [72b3ff0f0d] Fix handling of strings that contain zero tokens in fts5. And other problems found by fuzzing. (check-in: [72b3ff0f0d] user: dan branch: trunk, size: 74884) | |
|
2016-02-11
| ||
| 17:01 | [8e8e4635f6] part of check-in [bc3f7900d5] Handle parser stack overflow when parsing fts5 query expressions. Fix some compiler warnings in fts5 code. (check-in: [bc3f7900d5] user: dan branch: trunk, size: 72679) | |
|
2016-02-02
| ||
| 21:19 | [ff5c451a6d] part of check-in [063755c815] Add tests to restore full coverage of fts5 code. (check-in: [063755c815] user: dan branch: trunk, size: 72796) | |
| 17:40 | [304b22448e] part of check-in [62ea9e5ab8] Enhance the performance of fts5 AND and OR queries. (check-in: [62ea9e5ab8] user: dan branch: trunk, size: 72782) | |
|
2016-02-01
| ||
| 20:12 | [768d221e59] part of check-in [2334e88244] Improve performance of fts5 queries. (check-in: [2334e88244] user: dan branch: trunk, size: 73720) | |
|
2016-01-23
| ||
| 18:51 | [a66b969451] part of check-in [72d53699bf] Fix an fts5 problem with using both xPhraseFirst() and xPhraseFirstColumn() within a single statement in detail=col mode. (check-in: [72d53699bf] user: dan branch: fts5-perf, size: 72156) | |
|
2016-01-22
| ||
| 19:48 | [48b9131b74] part of check-in [b5a57b812f] Experimental performance enhancements for fts5. (check-in: [b5a57b812f] user: dan branch: fts5-perf, size: 72636) | |
|
2016-01-18
| ||
| 17:48 | [4ab4504c54] part of check-in [acaf426449] Add tests for fts5. Fix a crash that can occur in fts5 if the database content is corrupted. (check-in: [acaf426449] user: dan branch: trunk, size: 72149) | |
|
2016-01-16
| ||
| 18:58 | [3ba4c9588e] part of check-in [de77d6026e] Add further tests for fts5. Fix some problems with detail=col mode and auxiliary functions. (check-in: [de77d6026e] user: dan branch: trunk, size: 72143) | |
|
2016-01-14
| ||
| 14:15 | [510db45967] part of check-in [5a343cc033] Fix compiler warnings in fts5. (check-in: [5a343cc033] user: dan branch: trunk, size: 72299) | |
|
2016-01-11
| ||
| 17:30 | [6eba222074] part of check-in [0e3c545423] Fix bugs in fts5 synonym processing for detail=col and other modes. (check-in: [0e3c545423] user: dan branch: fts5-offsets, size: 72293) | |
|
2016-01-06
| ||
| 19:35 | [913ab9f9a7] part of check-in [e7dcd01351] Merge latest trunk changes into this branch. (check-in: [e7dcd01351] user: dan branch: fts5-offsets, size: 70943) | |
| 10:17 | [5d5dd3044c] part of check-in [a4e55f73b3] Fix a problem with the xPhraseFirstColumn() API in detail=col mode. Remove some unused test code from fts5ac.test. (check-in: [a4e55f73b3] user: dan branch: fts5-offsets, size: 70986) | |
|
2016-01-05
| ||
| 21:04 | [1aa0f5d597] part of check-in [fd217fdb39] Rationalize and extend some fts5 test code. Fix bugs revealed by the same. (check-in: [fd217fdb39] user: dan branch: fts5-offsets, size: 70952) | |
|
2016-01-04
| ||
| 19:12 | [3fe372518c] part of check-in [ee38f9dff5] Fix an OOM handling problem in fts5 detail=none and detail=col modes. Also a bug in the xInst() API when used with detail=col and column filtering expressions. Update the matchinfo() test function so that 'b' is fast with detail=col tables. (check-in: [ee38f9dff5] user: dan branch: fts5-offsets, size: 70327) | |
|
2016-01-02
| ||
| 19:01 | [898e0bb532] part of check-in [6322a1d984] Changes to run many fts5 tests with detail=none and detail=col tables as well as the default detail=full. Also fixes for the bugs uncovered by running said tests. (check-in: [6322a1d984] user: dan branch: fts5-offsets, size: 69641) | |
|
2015-12-29
| ||
| 19:35 | [08ee4f342a] part of check-in [8c30605bcd] Add the xPhraseFirstColumn() and xPhraseNextColumn() API functions to fts5. For iterating through the set of columns that contain intances of a phrase. (check-in: [8c30605bcd] user: dan branch: fts5-offsets, size: 68105) | |
|
2015-12-28
| ||
| 19:55 | [c9522ae99f] part of check-in [228b4d10e3] Change the name of the offsets=0 option to "detail=column". Have the xInst, xPhraseFirst and other API functions work by parsing the original text for detail=column tables. (check-in: [228b4d10e3] user: dan branch: fts5-offsets, size: 67561) | |
|
2015-12-23
| ||
| 16:42 | [8228aca3e9] part of check-in [5d44d4a6cf] Fix some harmless gcc compiler warnings. Mostly in fts5, but also two in the core code. (check-in: [5d44d4a6cf] user: dan branch: trunk, size: 64744) | |
|
2015-12-18
| ||
| 19:07 | [3b2c7ac54e] part of check-in [ad0987d83c] Fix a problem with prefix queries on fts5 offsets=0 tables. (check-in: [ad0987d83c] user: dan branch: fts5-offsets, size: 65175) | |
|
2015-12-16
| ||
| 23:30 | [80075fa450] part of check-in [1d0e6aa119] Fix even more harmless compiler warnings. (check-in: [1d0e6aa119] user: mistachkin branch: msvcWarn, size: 64787) | |
|
2015-10-14
| ||
| 20:34 | [28b15c9ae2] part of check-in [1c46c194a2] Fix harmless compiler warnings. (check-in: [1c46c194a2] user: mistachkin branch: trunk, size: 64783) | |
|
2015-10-12
| ||
| 22:31 | [bc31478fd0] part of check-in [9ecafc0c94] Remove the unused fts5ExprColsetTest() routine. (check-in: [9ecafc0c94] user: drh branch: trunk, size: 64753) | |
| 19:12 | [17a945210c] part of check-in [1c20c1c28b] Further tweaks to improve fts5 prefix query performance. (check-in: [1c20c1c28b] user: dan branch: trunk, size: 64922) | |
|
2015-10-08
| ||
| 21:00 | [1df899afed] part of check-in [97e11b79a5] Further tweaks to main.mk so that fts5 builds as part of testfixture. (check-in: [97e11b79a5] user: dan branch: amalg-json1-fts5, size: 67502) | |
| 20:40 | [d3a56928f8] part of check-in [0d7f301fb0] Fix further fts5 compilation issues. (check-in: [0d7f301fb0] user: dan branch: amalg-json1-fts5, size: 67483) | |
|
2015-10-07
| ||
| 09:02 | [2054e550e7] part of check-in [accdc98b12] Add further tests for fts5 prefix queries. (check-in: [accdc98b12] user: dan branch: trunk, size: 67287) | |
|
2015-10-06
| ||
| 20:53 | [bd2618ceaa] part of check-in [bf1607ac15] Optimizations for fts5 expressions that filter on column. More still to come. (check-in: [bf1607ac15] user: dan branch: trunk, size: 67319) | |
|
2015-09-11
| ||
| 14:15 | [667faaf14a] part of check-in [0dc436116e] Fix some compiler warnings in fts5 code. (check-in: [0dc436116e] user: dan branch: trunk, size: 67526) | |
|
2015-09-09
| ||
| 23:54 | [a7726fe704] part of check-in [86146a731d] Fix harmless compiler warning in FTS5. (check-in: [86146a731d] user: mistachkin branch: trunk, size: 67550) | |
| 17:17 | [3f10e630dc] part of check-in [2cdb18778f] Fix harmless compiler warnings in FTS5. (check-in: [2cdb18778f] user: mistachkin branch: trunk, size: 67584) | |
|
2015-09-03
| ||
| 19:48 | [1c24e1a2ff] part of check-in [801882817f] Rearrange code in fts5_expr.c so that synonym support does not slow down the common case. (check-in: [801882817f] user: dan branch: fts5-incompatible, size: 67819) | |
| 10:27 | [0c36c1db8e] part of check-in [399932a181] Fix a memory leak in fts5_expr.c. (check-in: [399932a181] user: dan branch: fts5-incompatible, size: 67596) | |
|
2015-09-02
| ||
| 19:48 | [45a1d1865b] part of check-in [bdedd838bb] Further tests to raise coverage of fts5 synonym code to 100%. Fix a dropped error code in the same. (check-in: [bdedd838bb] user: dan branch: fts5-incompatible, size: 67546) | |
| 18:56 | [1a6dbdab7a] part of check-in [f2e590700d] Fix an issue with fts5 synonyms and NEAR(...) queries. (check-in: [f2e590700d] user: dan branch: fts5-incompatible, size: 67548) | |
| 17:34 | [408384b2f5] part of check-in [a4c35fa2c9] Fix a problem with fts5 synonyms and phrase queries. Also fix an OOM handling bug in fts5. (check-in: [a4c35fa2c9] user: dan branch: fts5-incompatible, size: 67564) | |
| 14:17 | [5ae9bae1a3] part of check-in [11fa980897] Fix a problem handling OOM conditions within fts5 queries that feature synonyms. (check-in: [11fa980897] user: dan branch: fts5-incompatible, size: 66903) | |
| 08:22 | [d92beea335] part of check-in [cf3e45e76d] Fix a problem with fts5 synonyms and the xQueryPhrase() auxiliary function API. (check-in: [cf3e45e76d] user: dan branch: fts5-incompatible, size: 66650) | |
|
2015-09-01
| ||
| 18:44 | [44caa0ccd7] part of check-in [cd359550bd] Fix a problem that occurs when more than 4 synonyms for a term appear within a single row. (check-in: [cd359550bd] user: dan branch: fts5-incompatible, size: 66525) | |
| 18:08 | [99560f2833] part of check-in [dbcb73802b] Add tests for fts5 synonyms implemented by adding extra terms to queries. And fixes for the same. (check-in: [dbcb73802b] user: dan branch: fts5-incompatible, size: 66043) | |
|
2015-08-31
| ||
| 20:06 | [1458c3e33c] part of check-in [ad7feaed4c] Begin changes to allow synonym support by adding multiple terms to a query (an alternative to adding multiple terms to the FTS index). (check-in: [ad7feaed4c] user: dan branch: fts5-incompatible, size: 64280) | |
|
2015-08-29
| ||
| 15:44 | [7ea46f6764] part of check-in [fc71868496] Another change to the fts5 tokenizer API. (check-in: [fc71868496] user: dan branch: fts5-incompatible, size: 59938) | |
|
2015-08-28
| ||
| 19:56 | [f53917b6e6] part of check-in [90b85b42f2] Change the fts5 tokenizer API to allow more than one token to occupy a single position within a document. (check-in: [90b85b42f2] user: dan branch: fts5-incompatible, size: 59832) | |
|
2015-08-18
| ||
| 16:32 | [d075d36c84] part of check-in [02448a9fcc] Fix harmless compiler warning in FTS5. (check-in: [02448a9fcc] user: mistachkin branch: trunk, size: 59717) | |
|
2015-08-05
| ||
| 19:35 | [495b24f47f] part of check-in [9e3aafe44a] Add tests for the matchinfo-like test function. Fix problems found in test and fts5 code by doing so. (check-in: [9e3aafe44a] user: dan branch: trunk, size: 59723) | |
| 07:43 | [31c175602c] part of check-in [dffd358f6c] Remove all references to "docid" within fts5 source code and comments. Replace with "rowid". (check-in: [dffd358f6c] user: dan branch: trunk, size: 59709) | |
|
2015-07-30
| ||
| 11:26 | [59bea726ff] part of check-in [8e818b8985] Return an error message (instead of segfaulting) if test function fts5_expr() is invoked with no arguments. (check-in: [8e818b8985] user: dan branch: trunk, size: 59709) | |
|
2015-07-24
| ||
| 20:34 | [56dcbcbdc9] part of check-in [bd4f156d07] Fix warnings in fts5 code. (check-in: [bd4f156d07] user: dan branch: trunk, size: 59481) | |
|
2015-07-16
| ||
| 20:17 | [ac0614f843] part of check-in [e9bf275cd9] Fix compiler warnings in fts5 code. (check-in: [e9bf275cd9] user: dan branch: trunk, size: 59477) | |
|
2015-07-02
| ||
| 15:52 | [d2e1483456] part of check-in [7819002ed8] Remove "#ifdef SQLITE_ENABLE_FTS5" from individual fts5 source files. Add a single "#if !defined(SQLITE_CORE) || defined(SQLITE_ENABLE_FTS5)" to fts5.c. (check-in: [7819002ed8] user: dan branch: trunk, size: 59477) | |
|
2015-06-26
| ||
| 04:34 | [3386ab0a71] part of check-in [ef2052f81e] Initial changes to get FTS5 working with MSVC. (check-in: [ef2052f81e] user: mistachkin branch: fts5Msvc, size: 59535) | |
|
2015-06-05
| ||
| 19:05 | [549bda1f7e] part of check-in [32cbc0ed36] Make use of range constraints on the rowid field of an fts5 table in full-text queries. (check-in: [32cbc0ed36] user: dan branch: fts5, size: 59527) | |
|
2015-06-03
| ||
| 11:23 | [78a498ba14] part of check-in [4ea015ab98] Fix an fts5 problem in extracting columns from position lists containing large varints. (check-in: [4ea015ab98] user: dan branch: fts5, size: 58779) | |
|
2015-06-02
| ||
| 19:38 | [b28917bc2e] part of check-in [ab85a6fc4f] Change the fts5 multi-column syntax to use parenthesis instead of square brackets. (check-in: [ab85a6fc4f] user: dan branch: fts5, size: 60471) | |
| 18:07 | [aa5683ce00] part of check-in [c9ffda4abb] Merge latest trunk changes with this branch. (check-in: [c9ffda4abb] user: dan branch: fts5, size: 60471) | |
| 17:57 | [ae3cff45a4] part of check-in [80fe305b3e] Reimplement [ec69e09a] so that each call to the xNext() method does not involve two iterations of the match expression tree (only one). (check-in: [80fe305b3e] user: dan branch: fts5, size: 60471) | |
|
2015-06-01
| ||
| 19:17 | [e68f969e92] part of check-in [b43e9a5b7a] Improve performance of the fts5 AND operator. (check-in: [b43e9a5b7a] user: dan branch: fts5, size: 60673) | |
| 09:15 | [e58c9dec14] part of check-in [ec69e09a55] Change fts5 expression processing to avoid linear scans of long doclists caused by phrases that match specific columns only. (check-in: [ec69e09a55] user: dan branch: fts5, size: 58567) | |
|
2015-05-30
| ||
| 11:49 | [6a683326d6] part of check-in [e008c3c8e2] Remove the "#include sqlite3Int.h" from fts5Int.h. (check-in: [e008c3c8e2] user: dan branch: fts5, size: 56168) | |
|
2015-05-29
| ||
| 19:00 | [1685b331ec] part of check-in [ae6794ffa2] Add extra tests and fixes for multi-column matches. (check-in: [ae6794ffa2] user: dan branch: fts5, size: 56164) | |
| 15:55 | [c607282529] part of check-in [0fc0ea2092] Add syntax to fts5 used to specify that a phrase or NEAR group should match a subset of columns. For example "[col1 col2 ...] : <phrase>". (check-in: [0fc0ea2092] user: dan branch: fts5, size: 55920) | |
|
2015-05-28
| ||
| 19:57 | [c94983eaff] part of check-in [b29ac50af0] Optimizations for fts5 queries that match against a specific column. (check-in: [b29ac50af0] user: dan branch: fts5, size: 52652) | |
|
2015-05-25
| ||
| 11:46 | [a8b31d363c] part of check-in [02069782f8] Avoid redundant loads from the %_data table in the fts5 code. (check-in: [02069782f8] user: dan branch: fts5, size: 50817) | |
|
2015-05-23
| ||
| 15:43 | [638df49626] part of check-in [5165de548b] Avoid making redundant copies of position-lists within the fts5 code. (check-in: [5165de548b] user: dan branch: fts5, size: 50827) | |
|
2015-05-22
| ||
| 06:08 | [f9a2ef4efb] part of check-in [fea8a4db9d] Improve test coverage of fts5_unicode2.c. (check-in: [fea8a4db9d] user: dan branch: fts5, size: 50092) | |
|
2015-05-18
| ||
| 17:50 | [0c4b50bb48] part of check-in [47dbfadb99] Improve test coverage of fts5_config.c. (check-in: [47dbfadb99] user: dan branch: fts5, size: 48762) | |
|
2015-05-16
| ||
| 20:04 | [a88af159ce] part of check-in [927d9a64e1] Further test coverage improvements for fts5. (check-in: [927d9a64e1] user: dan branch: fts5, size: 48912) | |
|
2015-05-07
| ||
| 19:29 | [3fe1170453] part of check-in [a684b5e2d9] Change to storing all keys in a single merge-tree structure instead of one main structure and a separate one for each prefix index. This is a file-format change. Also introduce a mechanism for managing file-format changes. (check-in: [a684b5e2d9] user: dan branch: fts5, size: 48866) | |
|
2015-05-02
| ||
| 20:35 | [f49d68411d] part of check-in [c4456dc5f5] Reorganize some of the fts5 expression parsing code. Improve test coverage of the same. (check-in: [c4456dc5f5] user: dan branch: fts5, size: 48797) | |
|
2015-05-01
| ||
| 20:38 | [e2005ba782] part of check-in [d4331943df] Further improvements to test coverage of fts5 code. (check-in: [d4331943df] user: dan branch: fts5, size: 49434) | |
|
2015-04-29
| ||
| 20:54 | [663c75dfdb] part of check-in [c1f07a3aa9] Improve fts5 tests. (check-in: [c1f07a3aa9] user: dan branch: fts5, size: 49368) | |
|
2015-04-28
| ||
| 20:24 | [e647a2626a] part of check-in [07f7095539] Fix an fts5 bug in handling writes while there are active cursors. (check-in: [07f7095539] user: dan branch: fts5, size: 49368) | |
|
2015-04-22
| ||
| 20:58 | [05da381ab2] part of check-in [2dd59b5762] Add extra OOM tests for fts5. (check-in: [2dd59b5762] user: dan branch: fts5, size: 49264) | |
|
2015-03-04
| ||
| 08:29 | [5215137efa] part of check-in [a5d5468c05] Fix a couple of build problems. (check-in: [a5d5468c05] user: dan branch: fts5, size: 49232) | |
|
2015-02-02
| ||
| 11:32 | [eee52c9df8] part of check-in [fb10bbb9f9] Fix some problems with building fts5 and fts3 together using the amalgamation. (check-in: [fb10bbb9f9] user: dan branch: fts5, size: 49172) | |
|
2015-01-24
| ||
| 19:57 | [473e3428a9] part of check-in [5206ca6005] Have fts5 store rowids in ascending order. Query speed is virtually the same regardless of rowid order, and ascending order makes some insert optimizations easier. (check-in: [5206ca6005] user: dan branch: fts5, size: 49178) | |
|
2015-01-19
| ||
| 11:15 | [8a0e643768] part of check-in [75f3d17f86] Handle the case where a tokenizer determines that there are zero tokens in an fts5 query term. (check-in: [75f3d17f86] user: dan branch: fts5, size: 49042) | |
|
2015-01-10
| ||
| 20:34 | [6ba7a2e34a] part of check-in [512e1bdb40] Fix some documentation issues in fts5. (check-in: [512e1bdb40] user: dan branch: fts5, size: 48694) | |
|
2015-01-06
| ||
| 19:08 | [0320ae948e] part of check-in [65f0262fb8] Remove the iPos parameter from the tokenizer callback. Fix the "tokenchars" and "separators" options on the simple tokenizer. (check-in: [65f0262fb8] user: dan branch: fts5, size: 48444) | |
|
2015-01-03
| ||
| 20:44 | [317093f00a] part of check-in [17ef5b59f7] Add support for external content tables to fts5. (check-in: [17ef5b59f7] user: dan branch: fts5, size: 48496) | |
|
2014-12-18
| ||
| 18:25 | [27d3d2deeb] part of check-in [e358c3de5c] Fix various problems in fts5 revealed by fault-injection tests. (check-in: [e358c3de5c] user: dan branch: fts5, size: 48423) | |
|
2014-12-03
| ||
| 17:27 | [5db50cd4ae] part of check-in [2037dba62f] Begin testing fts5 OOM and IO error handling. (check-in: [2037dba62f] user: dan branch: fts5, size: 48235) | |
|
2014-11-15
| ||
| 20:07 | [d317be07d7] part of check-in [fba0b5fc7e] Fix the customization interfaces so that they match the documentation. (check-in: [fba0b5fc7e] user: dan branch: fts5, size: 48154) | |
|
2014-08-05
| ||
| 19:35 | [7b8e380233] part of check-in [5d38e6edc4] Use doclist indexes for AND queries as well as phrases. (check-in: [5d38e6edc4] user: dan branch: fts5, size: 47526) | |
|
2014-08-02
| ||
| 20:49 | [9402474456] part of check-in [b8864da95d] Start changing things to use doclist indexes as required. code is not activated yet. (check-in: [b8864da95d] user: dan branch: fts5, size: 46359) | |
|
2014-07-30
| ||
| 19:41 | [e764d75c58] part of check-in [4cc048c365] Add hidden column "rank". Currently this always returns the same value as the bm25() function. (check-in: [4cc048c365] user: dan branch: fts5, size: 46367) | |
|
2014-07-28
| ||
| 20:14 | [e426baa54b] part of check-in [770b9540c1] Add the "loadfts" program, for performance testing the loading of data into fts3/fts4/fts5 tables. (check-in: [770b9540c1] user: dan branch: fts5, size: 46339) | |
|
2014-07-25
| ||
| 20:30 | [65c1918002] part of check-in [c4d50428ab] Add extension apis xRowCount, xQueryPhrase, xSetAuxdata and xGetAuxdata. And a ranking function that uses all of the above. (check-in: [c4d50428ab] user: dan branch: fts5, size: 46336) | |
|
2014-07-23
| ||
| 19:31 | [2911813db1] part of check-in [bdc58fd28a] Add a snippet() function to fts5. (check-in: [bdc58fd28a] user: dan branch: fts5, size: 43752) | |
|
2014-07-18
| ||
| 19:59 | [288b3e0162] part of check-in [16352d3654] Fix issues with position lists and NEAR constraints. (check-in: [16352d3654] user: dan branch: fts5, size: 43764) | |
|
2014-07-17
| ||
| 15:14 | [52a1b47cfd] part of check-in [5808f30fae] Fix a problem with position list processing for OR queries. (check-in: [5808f30fae] user: dan branch: fts5, size: 40296) | |
|
2014-07-16
| ||
| 19:15 | [e4e4e6d32b] part of check-in [1e2a7ba088] Begin adding interface for auxiliary functions. (check-in: [1e2a7ba088] user: dan branch: fts5, size: 40220) | |
|
2014-07-10
| ||
| 20:21 | [0dc31b06d4] part of check-in [b96b5e1669] Support "ORDER BY rowid ASC". (check-in: [b96b5e1669] user: dan branch: fts5, size: 38672) | |
|
2014-07-08
| ||
| 16:27 | [21351cdd25] part of check-in [75ebd3cd59] Add support for prefix queries to fts5. (check-in: [75ebd3cd59] user: dan branch: fts5, size: 37510) | |
|
2014-07-05
| ||
| 15:15 | [a341fe4f6d] part of check-in [8682b87e79] Add support for AND, OR and NOT to fts5. (check-in: [8682b87e79] user: dan branch: fts5, size: 39619) | |
| 07:54 | [618e6641c8] part of check-in [004667106e] Add support for the "colname : <nearset>" syntax to fts5. (check-in: [004667106e] user: dan branch: fts5, size: 36911) | |
|
2014-07-03
| ||
| 20:39 | [84dd8c1f31] part of check-in [250ae8d401] Add support for NEAR expressions to fts5. (check-in: [250ae8d401] user: dan branch: fts5, size: 32744) | |
|
2014-07-02
| ||
| 20:18 | [aacfcf6b7c] part of check-in [2e5652e652] Add support for phrase queries to fts5. (check-in: [2e5652e652] user: dan branch: fts5, size: 30193) | |
|
2014-06-26
| ||
| 12:31 | [1874b17f10] part of check-in [94eeb077d0] Fix minor problems in term matching. (check-in: [94eeb077d0] user: dan branch: fts5, size: 21248) | |
|
2014-06-25
| ||
| 20:28 | [9666362ff5] part of check-in [47a9f3cc92] Begin adding query support to fts5. (check-in: [47a9f3cc92] user: dan branch: fts5, size: 21230) | |
|
2014-06-23
| ||
| 11:33 | Added: [bdfb98dab7] part of check-in [1e0648dcf2] Add some code for an experimental fts5 module. Does not work yet. (check-in: [1e0648dcf2] user: dan branch: fts5, size: 17884) | |