SQLite

All files named ”ext/fts5/test/fts5aa.test”
Login

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

History for ext/fts5/test/fts5aa.test

2025-06-23
19:38
[cf4ff61808] part of check-in [48044a6b57] Improve some of the error messages emitted by fts5 when it encounters corruption. (check-in: [48044a6b57] user: dan branch: trunk, size: 18606)
2024-07-30
16:59
[015c81b84d] part of check-in [6a63c47219] Use the SQLite format() function to format floating point values for test results, to avoid inconsistences in TCL versions. (check-in: [6a63c47219] user: drh branch: tcl9, size: 18600)
16:51
[183a2296fc] part of check-in [d54ec2de78] Fix the incrblob channel so that partial close works with Tcl9. (check-in: [d54ec2de78] user: drh branch: tcl9, size: 18587)
2023-10-11
21:08
[4db8151986] 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: 18604)
2023-09-06
12:52
[ba5158eba7] part of check-in [17bede8cde] Add the xIntegrity method to the sqlite3_module object. Implement this method in RTREE, FTS3/4, and FTS5 so that "PRAGMA integrity_check" also verifies the correctness of shadow tables associated with those virtual tables. (check-in: [17bede8cde] user: drh branch: vtab-integrity-check, size: 17677)
2023-07-10
20:44
[2106b14aa6] part of check-in [e513bea84d] Begin adding support for deleting rows from contentless fts5 tables. (check-in: [e513bea84d] user: dan branch: fts5-contentless-delete, size: 17580)
2019-09-03
19:40
[71f3ce62bc] part of check-in [b54aa18b0f] Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. (check-in: [b54aa18b0f] user: dan branch: branch-3.18, size: 16000)
19:29
[d5700987d4] part of check-in [b584fd36f7] Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. (check-in: [b584fd36f7] user: dan branch: branch-3.9, size: 14977)
18:43
[e23fcbde0f] part of check-in [0770363b30] Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. (check-in: [0770363b30] user: drh branch: branch-3.19, size: 16637)
18:36
[7ef4b01457] part of check-in [68b898381a] Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. (check-in: [68b898381a] user: drh branch: branch-3.22, size: 16692)
2019-03-18
15:49
[5bd43427b7] part of check-in [b3fa58dd74] Fix a buffer overread that could occur when running fts5 prefix queries inside a transaction. (check-in: [b3fa58dd74] user: dan branch: trunk, size: 17569)
15:23
[9fa16772f8] part of check-in [45c73deb44] Fix an fts5 problem with interleaving reads and writes in a single transaction. (check-in: [45c73deb44] user: dan branch: trunk, size: 17228)
2018-12-22
16:14
[1706f81630] part of check-in [c064964deb] Fix one more instance of excess whitespace in test result strings. (check-in: [c064964deb] user: drh branch: trunk, size: 16752)
2018-11-06
15:57
[840081efae] part of check-in [1c1d24edbb] Turn on defensive mode for running test scripts. Does not yet work. (check-in: [1c1d24edbb] user: drh branch: read-only-shadow, size: 16753)
2018-04-09
14:26
[87f4b50e75] part of check-in [a0ca4ddbbf] Fix the fts5 xBestIndex method so that it is not confused by "IS", "!=", "REGEXP", "GLOB" or "LIKE" operators. Fix for ticket [2b8aed9f]. (check-in: [a0ca4ddbbf] user: dan branch: trunk, size: 16720)
2018-02-07
18:02
[6e2fdb0ee6] part of check-in [2a5f813bc6] In extensions rtree, fts3 and fts5, ensure that when dynamic buffers are bound to persistent SQL statements using SQLITE_STATIC, the binding is replaced with an SQL NULL before the buffer is freed. Otherwise, a user may obtain a pointer to the persistent statement using sqlite3_next_stmt() and attempt to access the freed buffer using sqlite3_expanded_sql() or similar. (check-in: [2a5f813bc6] user: dan branch: trunk, size: 16369)
2017-07-07
19:43
[cba3fae646] part of check-in [732f90d632] Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0). (check-in: [732f90d632] user: drh branch: trunk, size: 16352)
2017-04-21
16:04
[6dd1bfa442] part of check-in [840042cb2b] Fix an FTS5 bug that could cause a prefix-query without a prefix-index on a database that contains delete-markers to return extra, non-matching, rows. (check-in: [840042cb2b] user: dan branch: trunk, size: 16374)
2017-04-08
09:12
[b3cb080db4] part of check-in [a921ada890] Have fts5 close any open blob-handle when a new savepoint is opened. This ensures that fts5 does not prevent DROP TABLE statements (which always open a savepoint) from succeeding. (check-in: [a921ada890] user: dan branch: trunk, size: 16037)
2016-03-22
15:01
[bd2d88182b] part of check-in [e1ab2d376a] Fix some errors in fts5 test scripts. (check-in: [e1ab2d376a] user: dan branch: trunk, size: 15657)
2016-01-06
19:43
[7e814df4a0] part of check-in [625695b3d7] Fix a test script problem caused by a change in constraint handling within the core. (check-in: [625695b3d7] user: dan branch: fts5-offsets, size: 15310)
2016-01-02
19:01
[4abbc14eb2] 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: 15310)
2015-10-27
20:04
[2c553eea4d] part of check-in [a85c2a4758] Have contentless and external content fts5 tables ignore "OR REPLACE" conflict handling. (check-in: [a85c2a4758] user: dan branch: trunk, size: 14829)
2015-10-14
21:08
[34ad813e9e] part of check-in [f4de6d450e] Tests and minor fixes to improve coverage of FTS5 code. (check-in: [f4de6d450e] user: dan branch: trunk, size: 14825)
2015-09-10
15:49
[4804f23700] part of check-in [85aac7b8b6] Update description of on-disk format in fts5_index.c. (check-in: [85aac7b8b6] user: dan branch: fts5-incompatible, size: 14652)
2015-09-08
19:55
[fb84c53e90] part of check-in [00d990061d] Remove the 0x00 terminators from the end of fts5 doclists stored on disk. (check-in: [00d990061d] user: dan branch: fts5-incompatible, size: 14656)
2015-09-05
19:52
[1ac5a3bd88] part of check-in [a1f4c3b543] Experiment with a different fts5 leaf page format that allows faster seeks. (check-in: [a1f4c3b543] user: dan branch: fts5-incompatible, size: 14898)
2015-09-04
11:13
[f558e1e5cc] part of check-in [d648ddd93d] Enhance showfts5.tcl so that it can optionally display the number of terms in each segment. (check-in: [d648ddd93d] user: dan branch: trunk, size: 14628)
2015-09-03
15:37
[be961d10b0] part of check-in [89f24f31a8] Add tests to improve coverage of fts5_varint.c. (check-in: [89f24f31a8] user: dan branch: fts5-incompatible, size: 14630)
2015-09-02
19:48
[86def30ff5] 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: 14182)
2015-08-31
20:06
[caa44c528f] 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: 13880)
2015-07-27
11:43
[c6e680a0d1] part of check-in [427bf09ba4] Minor tweak to the SQL schema used by fts5. (check-in: [427bf09ba4] user: dan branch: fts5-btree-index, size: 13879)
2015-07-15
19:46
[8dac4216e5] part of check-in [862418e350] Use a WITHOUT ROWID table to index fts5 btree leaves. This is faster to query and only slightly larger than storing btree nodes within an intkey table. (check-in: [862418e350] user: dan branch: fts5-btree-index, size: 13886)
2015-07-09
19:02
[4e896b9154] part of check-in [898618ccf6] Reduce the number of calls to malloc() made by fts5. (check-in: [898618ccf6] user: dan branch: trunk, size: 13786)
2015-07-06
20:27
[f7f057811e] part of check-in [7b7da1eb43] Speed up seek operations on fts5 b-tree structures. (check-in: [7b7da1eb43] user: dan branch: trunk, size: 13779)
2015-06-06
16:28
[0be21c89fd] part of check-in [3a9cb64813] Fix handling of fts5 rowid constraints in the absence of a MATCH clause. Add tests to cover recently added branches. (check-in: [3a9cb64813] user: dan branch: fts5, size: 13647)
2015-05-28
19:57
[5f73afe6a1] part of check-in [b29ac50af0] Optimizations for fts5 queries that match against a specific column. (check-in: [b29ac50af0] user: dan branch: fts5, size: 11677)
2015-05-18
20:34
[26f1a46221] part of check-in [4dfe2e5871] Improve test coverage of fts5_storage.c. (check-in: [4dfe2e5871] user: dan branch: fts5, size: 11507)
17:50
[29409f14de] part of check-in [47dbfadb99] Improve test coverage of fts5_config.c. (check-in: [47dbfadb99] user: dan branch: fts5, size: 10909)
2015-05-13
17:15
[5f221b8248] part of check-in [aa34bf666c] Change fts5 doclist-index structures to be trees instead of flat lists. This only makes a difference for databases that contain millions of instances of the same token. (check-in: [aa34bf666c] user: dan branch: fts5, size: 10236)
2015-04-29
20:54
[e17657bd74] part of check-in [c1f07a3aa9] Improve fts5 tests. (check-in: [c1f07a3aa9] user: dan branch: fts5, size: 10259)
2015-04-25
18:56
[87b2e01084] part of check-in [e748651c94] Add tests for fts5. (check-in: [e748651c94] user: dan branch: fts5, size: 10258)
2015-04-14
20:15
[91f22b3cc7] part of check-in [9341c070bb] Begin changing fts5 to use a delete flag so that delete markers may be annihilated more quickly. (check-in: [9341c070bb] user: dan branch: fts5, size: 10248)
2015-01-27
20:41
[065767c60a] part of check-in [f704bc059e] Fix a problem with fts5 doclist-indexes that occured if the first rowid of the first non-term page of a doclist is zero. (check-in: [f704bc059e] user: dan branch: fts5, size: 10258)
2015-01-24
19:57
[e77e28ac85] 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: 10251)
2015-01-21
20:30
[8ddbbcbeda] part of check-in [c020a291ed] Further tests and fixes for fts5. (check-in: [c020a291ed] user: dan branch: fts5, size: 10153)
06:36
[770dbb3710] part of check-in [b3348b1e07] Merge latest trunk changes with this branch. (check-in: [b3348b1e07] user: dan branch: fts5, size: 9869)
2015-01-20
20:34
[ad7eb7ace2] part of check-in [f45a0dc0a8] Add extra fault injection tests to fts5. (check-in: [f45a0dc0a8] user: dan branch: fts5, size: 9026)
2015-01-19
11:15
[59f5f2ca67] 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: 9037)
2015-01-06
19:08
[3941b54d75] 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: 8954)
14:38
[2affb47c0e] part of check-in [ce6a899baf] Further fixes and test cases related to external content tables. (check-in: [ce6a899baf] user: dan branch: fts5, size: 9018)
2014-12-29
15:59
Renamed and modified test/fts5aa.test → ext/fts5/test/fts5aa.test. [01fff9cf4e] part of check-in [7f148edb30] Move all fts5 test files to new directory "ext/fts5/test". (check-in: [7f148edb30] user: dan branch: fts5, size: 8591)