sqlite

fts5_common.tcl

Extra tests.

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

fts5aa.test

Use the SQLite format() function to format floating point values for test

2024-07-30 16:59:33 +00:00

fts5ab.test

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

2024-06-24 18:06:15 +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

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

2024-06-24 18:06:15 +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

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

2024-06-24 18:06:15 +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

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

2024-06-24 18:06:15 +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

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

Fix a crash in fts5 that could occur if shadow tables are modified or removed.

2025-01-08 15:54:44 +00:00

fts5colset.test

Have fts5.xBestIndex return SQLITE_CONSTRAINT, instead of a large cost, when no usable plan can be found.

2024-06-01 17:56:58 +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

In fts5, avoid starting a new merge of level L if there exists already an ongoing merge of a level less than L.

2024-09-30 17:28:45 +00:00

fts5contentless.test

Add tests to restore coverage of fts5_config.c.

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

fts5corrupt2.test

Get rid of "-encoding binary" across all test cases, as that is no longer

2024-07-30 17:09:51 +00:00

fts5corrupt3.test

Fix a crash in fts5 that could occur if shadow tables are modified or removed.

2025-01-08 15:54:44 +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

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

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 an incorrect tcl comment that appeared in many fts5 test files.

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

fts5corrupt8.test

Optimize allocation of large tombstone arrays in fts5.

2025-07-15 14:21:08 +00:00

fts5corrupt.test

Add tests to restore coverage of fts5_storage.c.

2024-08-16 17:54:00 +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

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 with UPDATEs on fts5 tables that contain blob values.

2025-06-11 17:24:46 +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

Tcl_ChannelType implementations for Tcl9 apparently require that

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

fts5interrupt.test

Tcl_ChannelType implementations for Tcl9 apparently require that

2024-07-30 18:15:59 +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

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

2017-07-07 19:43:23 +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

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

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

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

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

fts5misc.test

Fix an assert() that could fail if a virtual table called sqlite3_step() from within the xSync() method while committing a "PRAGMA defer_foreign_keys=1" transaction.

2025-01-20 18:26:58 +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

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

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

fts5onepass.test

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

2017-07-07 19:43:23 +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

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

2024-06-24 18:06:15 +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

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

2024-06-24 18:06:15 +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

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

2024-06-24 18:06:15 +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

Fix a crash in fts5 that could occur if shadow tables are modified or removed.

2025-01-08 15:54:44 +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

Add tests to restore coverage of fts5_config.c.

2024-08-16 19:05:47 +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

Remove a stray "breakpoint" from a test script.

2024-09-10 18:38:47 +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 an incorrect tcl comment that appeared in many fts5 test files.

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

fts5tok1.test

Prevent fts5 tokenizer unicode61 from considering '\0' to be a token characters, even if other characters of class "Cc" are.

2020-10-26 13:24:36 +00:00

fts5tok2.test

Add a test to verify that the fts3 and fts5 "unicode61" tokenizers are byte for byte compatible.

2016-01-14 20:05:59 +00:00

fts5tokendata.test

Fix the fts5 xInstToken() API for prefix queries that do not use prefix-indexes. This is experimental.

2024-09-14 20:30:14 +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

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

2024-06-24 18:06:15 +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 17:24:46 +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 an incorrect tcl comment that appeared in many fts5 test files.

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

fts5vocab.test

Tcl_ChannelType implementations for Tcl9 apparently require that

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