sqlite

fts5_common.tcl

Extra tests.

2024-08-15 20:33:05 +00:00

fts5aa.test

Improve some of the error messages emitted by fts5 when it encounters corruption.

2025-06-23 19:38:22 +00:00

fts5ab.test

Avoid corrupting the fts5 index if a value that was inserted via sqlite3_bind_blob() in a non-utf8 db is deleted.

2025-10-09 14:50:27 +00:00

fts5ac.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5ad.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5ae.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5af.test

Clamp the nToken parameter to the fts5 snippet() function between 0 and 64. It has always been documented this way, but not previously implemented. Report [bugs:/info/2026-06-08T08:29:00Z | 2026-06-08T08:29:00Z].

2026-06-08 11:24:05 +00:00

fts5ag.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5ah.test

Further tests and fixes for this branch.

2024-08-15 18:50:13 +00:00

fts5ai.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5aj.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5ak.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5al.test

Further tests and fixes for this branch.

2024-08-15 18:50:13 +00:00

fts5alter.test

Avoid orphaning an fts5 %_content table when dropping or renaming an fts5 table that uses contentless_unindexed=1. Report [bugs:/info/2026-10-21T02:51:01Z | 2026-10-21T02:51:01Z].

2026-10-21 16:56:58 +00:00

fts5auto.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5aux2.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5aux.test

Do not synthesize position-lists for UNINDEXED fts5 columns in detail=none mode. Report [bugs:/info/2026-10-20T20:40:52Z | 2026-10-20T20:40:52Z].

2026-10-21 17:23:01 +00:00

fts5auxdata.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5bigid.test

Add extra tests for fts5, large rowids and "ORDER BY rowid DESC". No changes to code.

2023-05-27 19:34:46 +00:00

fts5bigpl.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5bigtok2.test

Fix test script errors causing problems on windows.

2026-10-08 16:17:45 +00:00

fts5bigtok.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

fts5blob.test

Alternative implementation of fts5 locale=1 feature that allows blobs to be stored in indexed columns of fts5 locale=1 tables.

2024-09-10 16:19:31 +00:00

fts5cat.test

Add tests to restore coverage of fts5_tokenizer.c.

2024-08-17 17:22:49 +00:00

fts5circref.test

Improve the error messages emitted by fts5 in some cases. Report [forum:2026-10-13T21:57:58Z | 2026-10-13T21:57:58Z].

2026-10-14 16:11:09 +00:00

fts5colset.test

Fix some fts5 cases where all columns are excluded by a column filter (so that no rows match). Report [bugs:/info/2026-08-23T16:25:44Z | 2026-08-23T16:25:44Z].

2026-08-24 18:24:44 +00:00

fts5columnsize.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5config.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5conflict.test

Enable "OR IGNORE" support via SQLITE_VTAB_CONSTRAINT_SUPPORT for internal-content (not contentless or external-content) fts5 tables.

2023-09-16 17:11:44 +00:00

fts5connect.test

Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases

2018-11-07 02:17:01 +00:00

fts5content.test

Improve the error message returned when fts5 finds a row is missing from its content table.

2024-07-08 16:01:49 +00:00

fts5contentless2.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5contentless3.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5contentless4.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5contentless5.test

Fix a problem causing fts5 auxiliary function API methods xRowCount() and xColumnTotalSize() to return inaccurate values after rows had been deleted from a contentless_delete=1 table. Forum post [forum:/info/5e6f15753a | 5e6f15753a].

2026-09-16 13:58:43 +00:00

fts5contentless.test

Add tests to restore coverage of fts5_config.c.

2024-08-16 19:05:47 +00:00

fts5corrupt2.test

Improve some of the error messages emitted by fts5 when it encounters corruption.

2025-06-23 19:38:22 +00:00

fts5corrupt3.test

Remove harmless "breakpoint" command inserted by the previous check-in

2026-07-14 14:52:25 +00:00

fts5corrupt4.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5corrupt5.test

Avoid a possible buffer overrun in 32-bit builds of fts5 that could occur when processing corrupt records. Bug [bugs:/info/2026-06-14T12:21:15Z | 2026-06-14T12:21:15Z].

2026-06-15 13:39:20 +00:00

fts5corrupt6.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5corrupt7.test

Fix another buffer overread in fts5 that could occur when processing corrupt records. Bug [bugs:/info/2026-06-03T03:54:40Z | 2026-06-03T03:54:40Z].

2026-06-03 14:58:13 +00:00

fts5corrupt8.test

Optimize allocation of large tombstone arrays in fts5.

2025-07-15 14:06:15 +00:00

fts5corrupt9.test

Fix further problems with deleting from corrupt fts5 databases in secure-delete mode.

2026-01-16 20:04:04 +00:00

fts5corrupt.test

Detect and report FTS5 index corruption early enough to prevent CPU stack

2026-08-19 14:27:45 +00:00

fts5corruptA.test

Fix a buffer overread that could occur in fts5 within a memcmp() when doing an integrity-check on corrupted records.

2026-06-26 14:08:42 +00:00

fts5corruptB.test

Declare fts5 structure records corrupt if they contain a page number greater than 0x7FFFFF00. Report [bugs:/info/2026-08-17T20:07:33Z | 2026-08-17T20:07:33Z].

2026-08-17 21:26:44 +00:00

fts5corruptbig.test

Avoid integer overflows (a) when dealing with zeroblob(N) calls when 2*N is larger than 2^31, and (b) in fts5 when a corrupt record is close to 2^31 bytes in size. Both of these require special builds with SQLITE_MAX_LENGTH set to a non-default value.

2025-10-13 16:07:28 +00:00

fts5delete.test

Fix a typo in fts5delete.test.

2024-10-02 17:43:06 +00:00

fts5detail.test

Fix a memory leak in fts5 that could occur when processing a query containing multiple classes of error.

2021-06-30 14:04:25 +00:00

fts5determin.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

fts5dlidx.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5doclist.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5ea.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5eb.test

Tcl_ChannelType implementations for Tcl9 apparently require that

2024-07-30 18:15:59 +00:00

fts5error.test

Improve the error messages emitted by fts5 in some cases. Report [forum:2026-10-13T21:57:58Z | 2026-10-13T21:57:58Z].

2026-10-14 16:11:09 +00:00

fts5expr.test

Tests to improve coverage of fts5_expr.c.

2024-08-17 19:07:13 +00:00

fts5fault1.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

fts5fault2.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

fts5fault3.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

fts5fault4.test

Avoid reading the structure record from within the fts5 xConnect method.

2024-08-27 20:37:30 +00:00

fts5fault5.test

Remove some 'breakpoint' commands in test files.

2017-07-19 18:01:42 +00:00

fts5fault6.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5fault7.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

fts5fault8.test

Ensure the fts5 xIntegrity method correctly returns error codes unrelated to corruption or missing SQL elements.

2024-02-01 15:42:22 +00:00

fts5fault9.test

Fix a test problem causing an error in fts5fault9.test.

2018-01-16 20:44:00 +00:00

fts5faultA.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

fts5faultB.test

Allow fts5 to filter on multiple MATCH clauses in a single scan.

2019-09-12 19:38:40 +00:00

fts5faultD.test

Add tests for the trigram tokenizer. Fix minor issues.

2020-10-01 16:10:22 +00:00

fts5faultE.test

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.

2020-10-05 16:41:56 +00:00

fts5faultF.test

Add tests and fixes for the new code on this branch.

2023-07-20 16:07:04 +00:00

fts5faultG.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5faultH.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5faultI.test

Fix a problem causing queries on secure-delete fts5 databases to occasionally return extra, non-matching, rows. Report [bugs:/info/2026-10-18T20:40:47Z | 2026-10-18T20:40:47Z].

2026-10-20 11:13:15 +00:00

fts5first.test

Tcl_ChannelType implementations for Tcl9 apparently require that

2024-07-30 18:15:59 +00:00

fts5full.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5fuzz1.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

fts5hash.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5integrity2.test

Fix a technically undefined signed integer overflow in fts5.

2024-09-02 18:41:59 +00:00

fts5integrity.test

Omit explain_i calls from TCL test scripts.

2026-03-02 16:40:16 +00:00

fts5interrupt.test

In fts5, avoid holding an open blob handle after an INSERT/UPDATE/DELETE statement, as this can interfere with sqlite3_interrupt(). Forum post [forum:/forumpost/95413eb410 | 95413eb410].

2025-12-09 13:41:01 +00:00

fts5join.test

Update fts5 scan costs to take into account that a prefix query combined with a rowid equality constraint is still quite expensive.

2026-03-19 17:56:10 +00:00

fts5lastrowid.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5leftjoin.test

Avoid evaluating special vtab operators (e.g. MATCH) that are part of ON clauses attached to left joins from being evaluated too early. Possible fix for [forum:/forumpost/428ef7c468 | forum post 428ef7c468].

2025-07-12 18:14:41 +00:00

fts5limits.test

Limit the number of nested NOT nodes in an fts5 expression to 256.

2023-05-15 17:14:16 +00:00

fts5locale.test

Handle correctly very large (or small) out-of-range column indexes passed to various fts5 auxiliary functions. Report [bugs:/info/2026-09-23T02:40:15Z | 2026-09-23T02:40:15Z].

2026-09-23 11:06:11 +00:00

fts5matchinfo.test

Fix a problem in the fts5matchinfo.test file that prevented it from

2025-04-22 18:45:40 +00:00

fts5merge2.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

fts5merge.test

Avoid signed integer overflow when an fts5 'merge' command is passed -2147483648 as a parameter.

2025-12-30 11:19:27 +00:00

fts5misc.test

Avoid dropping an error code in fts5 contentless-delete mode after parsing an %_docize record. Report [bugs:/info/2026-09-25T15:52:10Z | 2026-09-25T15:52:10Z].

2026-09-25 17:42:10 +00:00

fts5multi.test

Allow fts5 to filter on multiple MATCH clauses in a single scan.

2019-09-12 19:38:40 +00:00

fts5multiclient.test

Change the error message text for SQLITE_ERROR to omit the part about

2017-07-07 19:43:23 +00:00

fts5near.test

Avoid a potential use-after-free in fts5. Report [bugs:/info/2026-06-08T08:45:27Z | 2026-06-08T08:45:27Z].

2026-06-08 12:03:52 +00:00

fts5onepass.test

Updates to where.c to handle vtabs in joins more similarly to regular tables.

2025-09-13 19:23:12 +00:00

fts5optimize2.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5optimize3.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5optimize.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5origintext2.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5origintext3.test

Allow an fts5 table or query to be configured to collect xInstToken data for any prefix terms as part of the first parse of the main index, if any.

2024-11-02 19:10:50 +00:00

fts5origintext4.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5origintext5.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5origintext6.test

Add tests for xInstToken() and prefix queries with various fts5 configurations.

2024-11-06 16:20:16 +00:00

fts5origintext.test

Allow an fts5 table or query to be configured to collect xInstToken data for any prefix terms as part of the first parse of the main index, if any.

2024-11-02 19:10:50 +00:00

fts5phrase.test

Add tests for an fts5 NEAR() expression with a single argument phrase.

2024-09-06 20:12:59 +00:00

fts5plan.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5porter2.test

Avoid a potentially undefined left-shift in the fts5 porter tokenizer.

2026-04-15 11:23:30 +00:00

fts5porter.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5prefix2.test

In fts5, account for the possibility of negative docids when allocating a buffer to store the results of merging detail=none prefix lists. Fix for report [bugs:/info/2026-08-04T08:49:27Z | 2026-08-04T08:49:27Z].

2026-08-04 11:04:17 +00:00

fts5prefix.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5query.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5rank.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5rebuild.test

Improve some of the error messages emitted by fts5 when it encounters corruption.

2025-06-23 19:38:22 +00:00

fts5restart.test

Tcl_ChannelType implementations for Tcl9 apparently require that

2024-07-30 18:15:59 +00:00

fts5rowid.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5savepoint.test

Test cases added

2026-10-21 10:27:51 +00:00

fts5secure2.test

Add the 'secure-delete' option to fts5. Used to configure fts5 to aggressively remove old full-text-index entries belonging to deleted or updated rows.

2023-04-12 17:40:44 +00:00

fts5secure3.test

Fix a usan complaint about signed integer overflow.

2023-12-22 14:47:30 +00:00

fts5secure4.test

Fix some problems with using fts5 options 'secure-delete' and detail=none together.

2023-04-17 18:32:22 +00:00

fts5secure5.test

Fix some problems with using fts5 options 'secure-delete' and detail=none together.

2023-04-17 18:32:22 +00:00

fts5secure6.test

Fix an fts5 problem caused by a 'rebuild' followed by a DELETE in secure-delete mode.

2023-10-13 15:59:11 +00:00

fts5secure7.test

Add tests for, and source code comments to, fts5. No changes to code.

2023-09-04 16:48:31 +00:00

fts5secure8.test

Fix a problem causing queries on secure-delete fts5 databases to occasionally return extra, non-matching, rows. Report [bugs:/info/2026-10-18T20:40:47Z | 2026-10-18T20:40:47Z].

2026-10-20 11:13:15 +00:00

fts5secure.test

Add extra tests for [4b60a1c3].

2023-09-08 19:18:02 +00:00

fts5securefault.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5simple2.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5simple3.test

Approximately 100 typo corrections spanning the whole tree, submitted via [forum:0db9827f0464bc33|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.

2025-02-27 21:17:55 +00:00

fts5simple.test

Avoid returning extra rows when the RHS of a "rowid = " constraint on an fts5 table is not an integer value. Report [bugs:/info/2026-10-20T20:31:49Z | 2026-10-20T20:31:49Z].

2026-10-21 15:25:33 +00:00

fts5synonym2.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5synonym.test

Fix a problem that could cause fts5 to return incorrect answers when performing prefix queries on tokens with synonyms. Bug [bugs:/info/2026-06-14T11:11:06Z | 2026-06-14T11:11:06Z].

2026-06-15 11:47:52 +00:00

fts5tok1.test

Restore 3.53.0 handling of codepoints u+fffe and u+ffff (they are separator characters) in fts3 and fts5. See forum post [forum:/info/9c6ec90d24 | 2026-10-13T08:37:16Z].

2026-10-13 15:51:29 +00:00

fts5tok2.test

Restore 3.53.0 handling of codepoints u+fffe and u+ffff (they are separator characters) in fts3 and fts5. See forum post [forum:/info/9c6ec90d24 | 2026-10-13T08:37:16Z].

2026-10-13 15:51:29 +00:00

fts5tokendata.test

Improve usage of fts5 doclist-indexes in tokendata=1 tables.

2026-10-21 16:48:04 +00:00

fts5tokenizer2.test

Improved robustness of parsing of tokenize= arguments in FTS5.

2024-08-06 22:49:01 +00:00

fts5tokenizer3.test

Ensure tokenizers registered with xCreateTokenizer_v2() can be accessed using xFindTokenizer(), and that those registered with xCreateTokenizer() work with xFindTokenizer_v2().

2024-08-09 20:59:50 +00:00

fts5tokenizer.test

Silently ignore nested porter tokenizers in FTS5. Having nested porter

2026-05-19 19:33:49 +00:00

fts5trigram2.test

Fix a broken assert in fts5_expr.c.

2024-08-07 21:20:08 +00:00

fts5trigram.test

Fix the fts5 trigram tokenizer so that it handles non-nul-terminated strings.

2024-11-11 19:49:26 +00:00

fts5ubsan.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5umlaut.test

Add the "remove_diacritics=2" option to the unicode61 tokenizer in both FTS5

2018-12-03 16:14:49 +00:00

fts5unicode2.test

Add tests to restore coverage of fts5_tokenizer.c.

2024-08-17 17:22:49 +00:00

fts5unicode3.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5unicode4.test

Fix a problem with UPDATEs on fts5 tables that contain blob values.

2025-06-11 15:03:53 +00:00

fts5unicode.test

Tcl_ChannelType implementations for Tcl9 apparently require that

2024-07-30 18:15:59 +00:00

fts5unindexed2.test

Allow UPDATEs of unindexed columns in fts5 contentless_unindexed=1 tables. Testing to come.

2024-09-27 10:57:41 +00:00

fts5unindexed.test

Fix an incorrect tcl comment that appeared in many fts5 test files.

2024-06-24 18:06:15 +00:00

fts5update2.test

Add tests for DELETE on contentless, contentless-delete and contentless-unindexed fts5 tables.

2024-09-28 15:09:43 +00:00

fts5update.test

Have fts5 reject attempts to insert a non-integer, non-null value into a rowid

2019-01-15 15:18:58 +00:00

fts5version.test

When removing an fts5 in secure-delete mode, defer setting the table version to SECUREDELETE until flushing data to disk. This prevents problems that can occur if there is a rollback or statement rollback operation.

2025-01-09 14:10:25 +00:00

fts5vocab2.test

Fix a buffer overread in the fts5vocab virtual table when processing "term < 123" constraints. Problem recently introduced by [db05b203f4].

2026-08-18 15:06:31 +00:00

fts5vocab.test

Ensure that the fts5_vocab.term column behaves as if it has blob affinity for comparisons.

2026-08-24 17:29:17 +00:00