Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
203 check-ins using file ext/fts5/test/fts5delete.test version 4a15fb03b6
|
2021-01-20
| ||
| 15:10 | Incorporate the 3.34.1 patches into the reuse-schema branch. (Leaf check-in: cc0e582854 user: drh tags: reuse-schema-3.34) | |
| 14:10 | Version 3.34.1 (Leaf check-in: 10e20c0b43 user: drh tags: release, patch, version-3.34.1, branch-3.34) | |
|
2021-01-19
| ||
| 20:38 | Fix an issue with sha3_query() when the first argument contains blank SQL statements. (check-in: a1a7a5f238 user: drh tags: branch-3.34) | |
| 20:17 | Bump the version number to 3.34.1. (check-in: cea7d0f8a3 user: drh tags: branch-3.34) | |
| 20:09 | Fix a problem handling sub-queries with both a correlated WHERE clause and a "HAVING 0" clause where the parent query is itself an aggregate. The problem was apparently introduced by check-in [6e6b3729e0549de0] (check-in: 30a4c32365 user: drh tags: branch-3.34) | |
| 20:04 | Prevent potential segfault in the sqlite-expert idxPopulateStat1 context cleanup code. (check-in: 69e31d52b2 user: drh tags: branch-3.34) | |
|
2020-12-16
| ||
| 13:20 | Fix a typo in the sqlite3_free_filename() documentation. (check-in: 7316ee19c5 user: drh tags: branch-3.34) | |
|
2020-12-14
| ||
| 13:52 | Minor changes for test coverage. (Closed-Leaf check-in: e5a8fa50f4 user: drh tags: generalized-upsert) | |
|
2020-12-12
| ||
| 00:43 | More test cases. No new problems discovered. (check-in: f34dd67e2d user: drh tags: generalized-upsert) | |
| 00:28 | New test cases with corresponding bug fixes. (check-in: f22c21a94c user: drh tags: generalized-upsert) | |
|
2020-12-11
| ||
| 19:36 | Begin adding test cases. Fix one bug found so far. More are pending. (check-in: aadd67ddf2 user: drh tags: generalized-upsert) | |
| 17:11 | Small performance tweaks. (check-in: 5321d60c57 user: drh tags: generalized-upsert) | |
| 16:49 | Bug fixes so that legacy tests pass. New tests for new functionality have not yet been added. (check-in: aa76790e58 user: drh tags: generalized-upsert) | |
| 01:17 | Logic is in place to handle multiple ON CONFLICT clauses, but it does not work. Any use of ON CONFLICT will likely lead to memory faults. This is an incremental check-in to save my place. (check-in: 155142314f user: drh tags: generalized-upsert) | |
|
2020-12-10
| ||
| 20:31 | Use an iterator for the index loop in sqlite3GenerateConstraintChecks(). The idea is that this iterator can be enhanced to traverse the indexes in any order, as required by multi-index UPSERT. (check-in: 64a4a91ecc user: drh tags: generalized-upsert) | |
| 18:06 | Better integrate the changes on this branch with OP_Insert and OP_IdxInsert. (check-in: 101cef1491 user: dan tags: vacuum-lomem) | |
| 12:49 | The DO UPDATE code generator searches for the correct ON CONFLICT clause to use. (check-in: a47e35ee2d user: drh tags: generalized-upsert) | |
|
2020-12-09
| ||
| 20:33 | Transfer large index or WITHOUT ROWID records between b-trees when vacuuming without loading them into memory. (check-in: dfd4ca6891 user: dan tags: vacuum-lomem) | |
| 20:30 | For upsert, the constraint check code generator uses a copy of the index list for the target table, which can potentially be reordered. (check-in: 3194c00c2c user: drh tags: generalized-upsert) | |
| 16:32 | Avoid loading large intkey rows when VACUUMing, even if the page-size is changing. (check-in: 0d2c377606 user: dan tags: vacuum-lomem) | |
| 13:11 | Improved comments in sqliteInt.h. No changes to code. (check-in: 8ccb8d1d55 user: drh tags: generalized-upsert) | |
| 01:34 | Initialize all terms in the ON CONFLICT clause stack. (check-in: 5e683fd1cb user: drh tags: generalized-upsert) | |
|
2020-12-08
| ||
| 20:19 | Experimental changes to vacuum to avoid loading large records entirely into memory. Currently only works in limited cases only - for rowid tables when the page-size does not change. (check-in: c90e063ca9 user: dan tags: vacuum-lomem) | |
| 14:29 | Enhance UPSERT parsing to allow multiple ON CONFLICT clauses. Only the very last clause may omit the conflict target, but the conflict target may now be omitted for the DO UPDATE resolution. (check-in: 2ca62f4c71 user: drh tags: generalized-upsert) | |
|
2020-12-07
| ||
| 23:14 | Fix a bad assert() in math1Func(). (check-in: 4b28612913 user: drh tags: trunk) | |
| 21:19 | Fix to the --disable-math option to ./configure. (check-in: 99ff641849 user: drh tags: trunk) | |
| 21:13 | Many more math functions. Semantics follows PG wherever possible. (check-in: 6b93627b5d user: drh tags: trunk) | |
| 17:15 | Begin adding new SQL functions that depend on -lm: ceil(), ceiling(), floor(), ln(), log(), and log10() so far. More to follow. (check-in: 4db5f2f787 user: drh tags: trunk) | |
|
2020-12-04
| ||
| 18:47 | Update this branch with latest trunk changes. (check-in: 846e8444f7 user: dan tags: reuse-schema) | |
| 17:05 | Fix harmless compiler warnings associated with the recent FTS5 enhancements. (check-in: 1db7c75191 user: drh tags: trunk) | |
| 16:58 | Fix a bug in the ".eqp" command of the shell that was introduced by the recent sqlite3SelectTrace/SQLITE_TESTCTRL_TRACEFLAGS changes. (check-in: fd02dffceb user: drh tags: trunk) | |
| 16:49 | Ensure that fts5 function matchinfo() is registered before running tests that use it in fts5corrupt3.test. (check-in: 932e05e093 user: dan tags: trunk) | |
| 16:26 | Fix a test script problem in walvfs.test. (check-in: 4c5076fbe4 user: dan tags: trunk) | |
| 16:25 | Fix an incorrect datatype no the sqlite3WhereTrace variable in test1.c. (check-in: 4e6dab30f6 user: drh tags: trunk) | |
| 16:09 | Eliminate the sqlite3_unsupported_selecttrace global variable by creating a new test-control to control SELECT tracing. Note that SELECT tracing is only available on debug builds. (check-in: fb07c4e3c7 user: drh tags: trunk) | |
| 16:04 | Further changes to the trace variables to try to eliminate (harmless) compiler warnings in all configurations. (Closed-Leaf check-in: 3a4c98b989 user: drh tags: traceflags-test-control) | |
| 01:17 | Alternative implementation of ".selecttrace" and ".wheretrace" that uses a test-control rather than global variables. (check-in: d36d6f2923 user: drh tags: traceflags-test-control) | |
|
2020-12-03
| ||
| 21:22 | When merging prefix lists in fts5, use 16-way merges instead of 2-way merges. This faster. (check-in: 026a93508e user: dan tags: trunk) | |
| 19:25 | Do not simulate OOM faults on the SQLITE_FCNTL_CKPT_START and SQLITE_FCNTL_CKPT_DONE file-controls, as those are write-only and the return value is always ignored. (check-in: 62a2d39483 user: drh tags: trunk) | |
| 14:21 | Enhance the generate_series() table-valued function to support negative step values. (check-in: 9b60fc4870 user: drh tags: trunk) | |
|
2020-12-02
| ||
| 20:07 | Prevent potential segfault in the sqlite-expert idxPopulateStat1 context cleanup code. (check-in: c24f13448b user: mistachkin tags: trunk) | |
| 19:08 | Allow a search for an N character prefix in fts5 to use a prefix index of size N+1, if no prefix index of size N exists. (check-in: 78a7801d8f user: dan tags: trunk) | |
| 18:27 | Fix the ".open" command in the CLI so that it accepts command-line options both before and after the filename. (check-in: d330bf0c02 user: drh tags: trunk) | |
| 16:23 | Improve performance for fts5 column filters that filter for more than one column. e.g. "{col1 col2 col3}:phrase". (check-in: d8de2f236d user: dan tags: trunk) | |
| 02:58 | Parameterize the hash function in mkkeywordhash.c. This was an attempt to find a better hash function, which turned out to not be successful. (check-in: 2195d731f5 user: drh tags: trunk) | |
| 00:22 | Increase the version number to 3.35.0 to begin the next development cycle. (check-in: edbabaa308 user: drh tags: trunk) | |
| 00:20 | Slightly faster tokenization of non-keyword identifiers. (check-in: 55fa22bd40 user: drh tags: trunk) | |
|
2020-12-01
| ||
| 23:18 | Add the --lookaside SIZE COUNT command-line option to the dbfuzz2 testing tool. (check-in: 2466960c0b user: drh tags: trunk) | |
| 16:36 | Merge the 3.34.0 release into the reuse-schema branch. (check-in: 73b5f614cd user: drh tags: reuse-schema) | |
| 16:14 | Version 3.34.0 (check-in: a26b6597e3 user: drh tags: trunk, release, major-release, version-3.34.0) | |
|
2020-11-30
| ||
| 18:52 | Update the tea/win/makefile.vc file that ships as part of the autoconf package to use "sqlite3" instead of "tclsqlite3" for the installed dll filename. (check-in: 23212b1a05 user: dan tags: trunk) | |
| 18:43 | Update the tea/win/makefile.vc file that ships as part of the autoconf package to use "sqlite3" instead of "tclsqlite3" for the installed dll filename. (Closed-Leaf check-in: 93d4d9dc05 user: dan tags: win-tea-fix) | |
| 14:20 | Do not reuse the obsolete SQLITE_TESTCTRL_PRNG_RESET value for SQLITE_TESTCTRL_SEEK_COUNT. Give SEEK_COUNT its own unique value. This avoids incompatibility with legacy test code. (check-in: fdba0b1290 user: drh tags: trunk) | |
|
2020-11-27
| ||
| 20:56 | Improve the speed of the tokenizer by recognizing that tokens starting with letters "_", "Y", or "Z" can never be SQL keywords and must be ordinary identifiers. (Closed-Leaf check-in: 16e281ed62 user: drh tags: faster-tokenizer) | |
| 19:40 | Fix a compiler warning in fts5_aux.c. (check-in: 8edb983bc8 user: dan tags: trunk) | |
| 16:15 | Add missing cast to fts5 bm25() code. (check-in: 6ff9673847 user: dan tags: trunk) | |
| 16:08 | Remove a redundant "if( rc==SQLITE_OK )" from the fts5 bm25() code. (check-in: d85f4f27f5 user: dan tags: trunk) | |
| 16:05 | Move an "if( rc==SQLITE_OK )" to outside a loop body in the fts5 bm25() code. (check-in: 14a4dcf347 user: dan tags: trunk) | |
| 15:28 | Fix a case in the FTS5 integrity check where a corrupt database could cause a buffer overread. (check-in: a32b4f650d user: dan tags: trunk) | |
|
2020-11-26
| ||
| 20:13 | Update mkunicode.tcl to match the change erroneously made to machine generated file fts5_unicode2.c in [b7b7bde9]. (check-in: 326d579d77 user: dan tags: trunk) | |
| 18:41 | Merge latest changes from wal2 branch. (check-in: b451bb724e user: dan tags: begin-concurrent-pnu-wal2) | |
| 18:08 | Merge latest trunk changes into this branch. (check-in: cb1f6f18e7 user: dan tags: wal2) | |
| 17:54 | Merge latest changes from begin-concurrent-pnu into this branch. (check-in: d2de81a24f user: dan tags: begin-concurrent-report) | |
| 17:36 | Merge latest changes from trunk into this branch. (check-in: a42e6f34f5 user: dan tags: begin-concurrent-pnu) | |
| 11:37 | Update this branch with latest changes from trunk. (check-in: ddb97eeef7 user: dan tags: begin-concurrent) | |
|
2020-11-25
| ||
| 20:29 | Merge trunk changes into this branch. (check-in: f4b7c10057 user: dan tags: reuse-schema) | |
| 18:44 | Update a requirement mark in the e_expr.test script. (check-in: bb174a074b user: drh tags: trunk) | |
| 16:28 | Fix harmless compiler warnings about unused function parameters. (check-in: 25d067c270 user: drh tags: trunk) | |
| 15:29 | Fix a potential NULL pointer dereference in the geopoly_overlap() routine of the GeoPoly extension. (check-in: b5665712e6 user: drh tags: trunk) | |
| 14:50 | Fix the shell1.test test script so that it works on windows. (check-in: 9bd15b07e5 user: drh tags: trunk) | |
| 13:59 | Change the -init option to the command-line shell to honor the -bail option. Also change it to report an error if the filename mentioned cannot be opened. (check-in: a29f54bd2c user: drh tags: trunk) | |
|
2020-11-24
| ||
| 23:40 | Fix a typo in the sqlite3_txn_state() documentation. (check-in: 5b4325295b user: drh tags: trunk) | |
| 21:19 | Add the new sqlite3_txn_state() interface to the set of routines accessible by run-time loadables extensions. (check-in: db25f1dc8e user: drh tags: trunk) | |
| 19:55 | Fix a harmless typo in a comment. (check-in: b2a201f1b5 user: drh tags: trunk) | |
| 17:55 | Fix a bug in OOM handling code introduced by [6a28713d]. (check-in: 8a786ce994 user: dan tags: trunk) | |
| 16:44 | Ensure that super-journal and other journal filenames passed by SQLite to an sqlite3_vfs.xOpen() implementation may be safely passed to sqlite3_uri_parameter() and similar functions. (check-in: 6a28713d59 user: dan tags: trunk) | |
| 13:14 | Remove the VERSION_NUMBER macro from configure.ac as it has been unused since 2009 check-in [7f4810747b086498]. See also forum post bb2c634fcd. (check-in: 5466dd55d4 user: drh tags: trunk) | |
|
2020-11-23
| ||
| 21:05 | Syntactic changes to work around a bug in gcov 9.3.0. No changes to the generated code for release builds. (check-in: 4f1573b146 user: drh tags: trunk) | |
| 17:36 | In os_unix.c, put ALWAYS() on unreachable branches associated with pathname normalization. (check-in: b45a08e3c7 user: drh tags: trunk) | |
| 15:30 | Fix a test script problem causing crash8.test to fail when run with leak-sanitizer. (check-in: 2c437f7a2c user: dan tags: trunk) | |
| 14:50 | Allow "substring()" as an alias for "substr()" for compatibility with other SQL engines. (check-in: aa2ee5754c user: drh tags: trunk) | |
|
2020-11-20
| ||
| 14:16 | Add file doc/vdbesort-memory.md, containing notes on the way vdbesort.c uses heap memory. (check-in: 07f53899a9 user: dan tags: trunk) | |
|
2020-11-19
| ||
| 21:12 | The xFullPathname method of the unix VFS now normalizes the filenames by omitting surplus "/", "/./" and "/../" strings. (check-in: c38dec6f52 user: drh tags: trunk) | |
| 21:01 | More test case changes so that shared-cache mode tests all work with normalized database names. (Closed-Leaf check-in: 6f0d5f0949 user: drh tags: stronger-nofollow) | |
| 20:07 | Fix the tkt3793 test case so that work even when filenames are normalized. (check-in: e85d32ac6c user: drh tags: stronger-nofollow) | |
| 19:43 | Use an ephemeral table rather than a RowSet to remember rowids in the two-pass UPDATE algorithm, as this uses much less memory for large UPDATEs. (check-in: 842c432772 user: drh tags: trunk) | |
|
2020-11-18
| ||
| 23:44 | If a read() or pread() indicates that the database file is unreadable due to filesystem damage, then it returns SQLITE_IOERR_CORRUPTFS which is then converted into SQLITE_CORRUPT before being returned to the application. (check-in: 849e4e14fd user: drh tags: trunk) | |
| 21:50 | Improvements to the mechanism that attempts to report SQLITE_CORRUPT if pread() says that the underlying filesystem is corrupt. (Closed-Leaf check-in: b887c7504e user: drh tags: detect-corrupt-fs) | |
| 21:15 | Merge trunk changes into this branch. (check-in: 6004de525d user: dan tags: reuse-schema) | |
| 20:55 | Update cksumvfs.c so that if SQLITE_AMALGAMATION is defined, SQLITE_CKSUMVFS_STATIC is implied. (check-in: 184e9d782d user: dan tags: trunk) | |
| 18:36 | Add test infrastructure for cksumvfs. And update cksumvfs so that it works in concert with version 2 VFSs. No changes to core SQLite. (check-in: 43d4801df5 user: dan tags: trunk) | |
| 14:30 | Fix a problem causing sqlite3_carray_bind() to return an undefined value. (check-in: 083203a549 user: dan tags: trunk) | |
| 14:12 | Update test code to fix a problem with SQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: 29c779a07b user: dan tags: trunk) | |
| 12:48 | On unix, for certain error codes of read()/pread() return SQLITE_IOERR_CORRUPTFS instead of SQLITE_IOERR_READ. And then convert this error into SQLITE_CORRUPT prior to returning back to the application. (check-in: 9538ea8447 user: drh tags: detect-corrupt-fs) | |
|
2020-11-17
| ||
| 21:26 | Claw back most of the performance lost in the previous commit. (Closed-Leaf check-in: df8ce2675b user: drh tags: lowmem-update-exp) | |
| 21:09 | Fix trivial memory leaks in the shell and sqldiff programs. (check-in: 272793e5ed user: dan tags: trunk) | |
| 18:25 | Fix test file busy2.test so that it works with the "inmemory_journal" permutation. (check-in: b192fdddb6 user: dan tags: trunk) | |
| 14:41 | Add a single-argument form to the CARRAY table-valued function, with content bound using the sqlite3_carray_bind() interface that is included with the extension. (check-in: 7b229cb120 user: drh tags: trunk) | |
|
2020-11-16
| ||
| 18:45 | Enhance the unix VFS so that it removes extra "/", "/./" and "/../" from the database filename. (check-in: 7ba89d3e5c user: drh tags: stronger-nofollow) | |
|
2020-11-14
| ||
| 20:03 | Modify UPDATE so that two-pass updates on a rowid table use an ephemeral table to store rowids rather than a RowSet. This uses less memory, though it is slower. (check-in: 4673096dd8 user: drh tags: lowmem-update-exp) | |
|
2020-11-12
| ||
| 18:16 | Improved diagnostics output with ".wheretrace 0x800". No changes to non-debug builds. (check-in: 772ae83c61 user: drh tags: trunk) | |
|
2020-11-11
| ||
| 19:11 | Fix a typo in a comment. No changes to code. (check-in: 572f1ed59d user: drh tags: trunk) | |
|
2020-11-08
| ||
| 20:44 | Use NEVER and ALWAYS macros to confirm that the return value from sqlite3ExprSkipCollateAndLikely() is never NULL in some of its use cases. (check-in: 76d2eb86e1 user: drh tags: trunk) | |
|
2020-11-06
| ||
| 16:48 | Add ALWAYS() to conditionals associated with SHM locking that are always true. (check-in: b599e89076 user: drh tags: trunk) | |
|
2020-11-05
| ||
| 19:13 | Suppress errors associated with TEMP triggers that reference objects in non-TEMP databases. This is a continuation of the fix for ticket #3810 shown in check-in [ba1afc040171810d] from 2009-08-06, based on a bug report in forum post 157dc791df (check-in: 991ca9b26b user: drh tags: trunk) | |
| 14:50 | Remove unused variable from speedtest1.c (check-in: c0a18565e6 user: drh tags: trunk) | |
|
2020-11-03
| ||
| 11:54 | Make platform compilation clearer, including the section that applies to both *ix and Windows Add link to the detailed compilation instructions Add brief Android section, it seems strange to omit it since Android is the majority use case by numbers (Closed-Leaf check-in: 2a71bebfe3 user: shearer tags: docupdate) | |
| 11:27 | Update for new git-style syntax in Fossil (check-in: d46b6778b1 user: shearer tags: docupdate) | |
| 11:20 | Add links, especially for the docsrc repo, which is otherwise hard to find (check-in: e03867e2fb user: shearer tags: docupdate) | |
|
2020-11-02
| ||
| 00:40 | Fix an another OSS-Fuzz discovered assertion fault due to ALTER TABLE and strange triggers. (check-in: 6646d7898c user: drh tags: trunk) | |
|
2020-10-31
| ||
| 18:58 | Add the -tabs command-line option to the CLI. (check-in: 7d01e84dc4 user: drh tags: trunk) | |
| 16:33 | Update the ALTER TABLE command to correctly handle UPDATE ... FROM statements within trigger programs. (check-in: 3e6af89040 user: dan tags: trunk) | |
|
2020-10-27
| ||
| 11:58 | Prettify btree.h headings. Close branch. (Closed-Leaf check-in: ee9689ad2f user: shearer tags: btree-code-documentation) | |
| 11:13 | Typo in btree.h (and unwanted merge; this branch for cherrypicking btree.h only) (check-in: eb6e5fc189 user: shearer tags: btree-code-documentation) | |
| 11:07 | Final commit in btree.h reorg. No more unknowns. (check-in: ea06f1d1f9 user: shearer tags: btree-code-documentation) | |
|
2020-10-26
| ||
| 18:14 | Always create a statement journal when using the OP_ParseSchema opcode, as you never know when it might fail. See the discussion on forum post daa2c728cc. (check-in: aa512f72cf user: drh tags: trunk) | |
| 16:22 | Ensure that the table argument passed to Tcl_GetIndexFromObjStruct() in the sessions module test code is declared "static". (check-in: 80eba105d6 user: dan tags: trunk) | |
| 13:24 | Prevent fts5 tokenizer unicode61 from considering '\0' to be a token characters, even if other characters of class "Cc" are. See forum thread 09609d7e22 for details. (check-in: b7b7bde9b7 user: dan tags: trunk) | |
|
2020-10-22
| ||
| 18:50 | Minor tweaks to query planning weights so that when STAT4 is enabled and functioning, a full table scan is more likely to be selected if that seems like the fastest solution. Only do this when STAT4 info is available because an error has a large potential downside. (check-in: 0e7e113d9f user: drh tags: trunk) | |
| 18:16 | Test case updates. (Closed-Leaf check-in: 27c681c9c6 user: drh tags: avoid-bad-indexes) | |
| 15:47 | Sometimes it makes sense to do a full table scan rather than try to use an index when most of the rows will be selected. This branch is trying to tune the query planner to make that happen more often. (check-in: 0f42099ad6 user: drh tags: avoid-bad-indexes) | |
|
2020-10-20
| ||
| 14:40 | Fix the sqlite3_hard_heap_limit() so that it works with sqlite3_realloc64() in addition to sqlite3_malloc64(). Improvements to OOM processing and debugging aids in the fuzzcheck utility. (check-in: 602d736916 user: drh tags: trunk) | |
| 12:37 | Fix an assert() inside of debug-only code that can fail following an OOM. (check-in: 79da254f41 user: drh tags: trunk) | |
|
2020-10-19
| ||
| 20:49 | Fix an incorrect table ref-count in the new recursive CTE logic that might result in a reference to freed memory following a syntax error. (check-in: 75a0288871 user: drh tags: trunk) | |
| 12:35 | Enhance recursive common table expressions to support two or more recursive terms. (check-in: 77e64647ec user: drh tags: trunk) | |
| 01:44 | New test cases for recursive CTEs with multiple recursive terms. (Leaf check-in: cd5182bd6f user: drh tags: cte-enhancement) | |
| 01:23 | Allow multiple recursive terms in the compound SELECT of a recursive CTE. This facilitates writing a query to find find the connected components of an undirected graph. (check-in: 5481fa8c79 user: drh tags: cte-enhancement) | |
|
2020-10-18
| ||
| 18:35 | Fix harmless compiler warnings. (check-in: 7f8802bb7b user: mistachkin tags: trunk) | |
|
2020-10-17
| ||
| 22:13 | Fix the SQLITE_DESERIALIZE_FREEONCLOSE flag so that it works as it is documented to work. See forum post ba1dff667a (check-in: d6fac8a1d3 user: drh tags: trunk) | |
| 19:09 | Fix an incorrect printf() in debugging logic in where.c. Problem reported by forum post 80a9c47769772207. (check-in: 883da4dadc user: drh tags: trunk) | |
|
2020-10-15
| ||
| 17:59 | Minor fixes to the cksumvfs documentation in the header comment of the source file. Enhance speedtest1.c so that it can more easily do performance comparisons of cksumvfs. (check-in: ed3bb818f5 user: drh tags: trunk) | |
| 14:37 | The windows VFS accepts query parameter "exclusive=true" to cause it to take a mandatory file lock, preventing other applications from even reading the file. See forum thread 11b5560864189b5d. (check-in: 05b573fdb2 user: drh tags: trunk) | |
|
2020-10-14
| ||
| 21:31 | Enhancements to TclKit batch tool for MSVC. (check-in: 2a8a455211 user: mistachkin tags: trunk) | |
| 21:30 | Fix typo in a documentation comment. (check-in: 462adc7d6b user: mistachkin tags: trunk) | |
| 15:46 | Enhanced documentation for sqlite3_vtab_nochange() to make it clear that it is an optimization and that virtual table implementations should be prepared for it to always return false. (check-in: 3e2643619d user: drh tags: trunk) | |
|
2020-10-12
| ||
| 18:09 | Fix some fts5 problems with signed integer overflow causing segfaults in -ftrapv builds. (check-in: 7e17c2f4b7 user: dan tags: trunk) | |
| 17:57 | Improved quoting of the table name argument for the ".import" command of the CLI. See forum post 34591fefbe. (check-in: ce97b56d63 user: drh tags: trunk) | |
| 16:54 | Add options --data-only and --nosys to the ".dump" command in the CLI. (check-in: 57123b14a7 user: drh tags: trunk) | |
| 15:27 | Fix ALTER TABLE so that it can run even if the schema contains unknown collation sequences. (check-in: bc4bb9433f user: dan tags: trunk) | |
| 14:56 | Add the --nosys option to the .schema command in the CLI. (check-in: b72ee69453 user: drh tags: trunk) | |
| 14:29 | Fix UPDATE FROM statements on virtual tables that are declared WITHOUT ROWID. See forum post 0fee7951eb for more information. (check-in: bcb0bc6a7b user: dan tags: trunk) | |
| 13:24 | Fix BEGIN IMMEDIATE and BEGIN EXCLUSIVE so that they work even if one or more of the database files in the connection are read-only. Test cases for this are in TH3. (check-in: 2fa08c3963 user: drh tags: trunk) | |
|
2020-10-07
| ||
| 11:24 | In the CSV extension, use SQLITE_TRANSIENT rather than SQLITE_STATIC on return values that can in fact change. (check-in: 54b54f02c6 user: drh tags: trunk) | |
|
2020-10-06
| ||
| 15:48 | More additions and improvements to btree.h documentation (check-in: a49a7cdec7 user: shearer tags: btree-code-documentation) | |
|
2020-10-05
| ||
| 16:41 | 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 tags: trunk) | |
|
2020-10-03
| ||
| 19:16 | Do not apply affinities when creating entries for automatic indexes on views. Fix for [95302bdb]. (check-in: df12f09722 user: dan tags: trunk) | |
| 17:06 | Fix a segfault caused by running "column LIKE NULL" against an fts5 table using the trigram tokenizer. Fix for [e33ee62575fc22]. (check-in: 6e72a08de7 user: dan tags: trunk) | |
| 14:36 | FTS5 does not handle tokens that contain embedded nul characters. Prevent the trigram tokenizer from returning such tokens. Fix for [2ba5930b2]. (check-in: b1d048748c user: dan tags: trunk) | |
|
2020-10-02
| ||
| 15:15 | Fix some test code so that testfixture can build with SQLITE_OMIT_WAL defined. (check-in: dd009cd7ae user: dan tags: trunk) | |
| 13:48 | Additional corner-case fixes for the in-scan-vs-index or OP_SeekScan optimization. (check-in: ad5ab24ebd user: drh tags: trunk) | |
| 12:49 | Remove an incorrect assert() from the OP_SeekScan opcode. (check-in: c0400f8c0b user: drh tags: trunk) | |
| 12:42 | Fix a faulty assert() statement. Add new test cases. (check-in: 80ecdb3da4 user: drh tags: trunk) | |
| 11:55 | For the OP_SeekScan optimization, the OP_IdxGT does not necessarily come right after the OP_SeekGE. So use the P2 operand of OP_SeekScan to point to the first instruction after OP_IdxGT. Problem found by dbsqlfuzz. (check-in: 091d719394 user: drh tags: trunk) | |
| 02:02 | Disable the OP_SeekScan opcode of the in-scan-vs-index optimization when in PRAGMA reverse_unordered_selects mode, as the OP_SeekScan only works with forwards scans. Thanks to OSSFuzz for pointing out the problem to us. (check-in: c75c3a3b75 user: drh tags: trunk) | |
|
2020-10-01
| ||
| 17:24 | Add experimental "trigram" tokenizer to fts5. (check-in: c4e8ec7907 user: dan tags: trunk) | |
| 17:15 | Add the -trigram option to the fts5txt2db.tcl script. (Closed-Leaf check-in: a394dd2602 user: dan tags: fts5-trigram) | |
| 16:10 | Add tests for the trigram tokenizer. Fix minor issues. (check-in: 897ced99b4 user: dan tags: fts5-trigram) | |
| 15:46 | Fix the OP_SeekScan opcode so that its variable names do not cause problems for the test/vdbe-compress.tcl script. (check-in: 7a78274a07 user: drh tags: trunk) | |
| 14:38 | Remove a debugging printf() accidentally left in the previous check-in. (check-in: e9d1efa597 user: drh tags: trunk) | |
| 14:36 | The IN-early-out optimization does not work for virtual tables. Do not try to use it there. Fix for ticket [2d5a3163563d559f]. Test cases in TH3. (check-in: dbec6910d9 user: drh tags: trunk) | |
|
2020-09-30
| ||
| 20:35 | 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 tags: fts5-trigram) | |
| 18:06 | Improved query optimization for multi-column indexes where the second or later columns are constrained by an IN operator and the earlier index columns limit the search to a small number of rows. Use the new OP_SeekScan opcode which does scanning of the relevant range of the index but gives up and falls back to doing a seek if the number of rows scanned grows to large, in order to guard against pathological cases where the estimated number of rows to be scanned is far too small. (check-in: 4a43430fd2 user: drh tags: trunk) | |
| 18:03 | For the OP_SeekScan opcode, adjust the number of steps run before giving up based on the estimated number of comparisons needed to perform a seek. (Closed-Leaf check-in: dc4172e6b8 user: drh tags: in-scan-vs-index) | |
| 17:32 | Back out the incorrect optimization of check-in [e51ecadcbdef5ce6] as ticket [5c4e7aa793943803] reports a case where the optimization does not work. (check-in: 7395e96b8c user: drh tags: trunk) | |
| 15:36 | In the query flattener when substituting expression Y in place of expression X, if X is marked has having come from an ON or USING clause of a LEFT JOIN, then be sure that all subexpressions of Y, not just the root node of Y, are similarly marked. Otherwise, if Y is an AND operator, it will be split up during WHERE clause analysis and the subexpressions will not get the special treatment needed by LEFT JOIN ON/USING clauses. Fix for ticket [66e4b0e271c47145]. (check-in: 69f9eb7343 user: drh tags: trunk) | |
| 09:17 | Better understanding of savepoint code (check-in: ce6d8d6215 user: shearer tags: trunk) | |
| 00:48 | Add an sqlite3FaultSim() call to btreeNext() to make it easier to simulate I/O errors in calls to sqlite3BtreeNext(), and in OP_SeekScan. (check-in: 29cca775d3 user: drh tags: in-scan-vs-index) | |
| 00:10 | In the OP_SeekScan opcode, changes to pOp must occur after the call to VdbeBranchTaken() so that the VdbeBranchTaken() attributes the branch to the correct opcode. (check-in: 61fbe7aa7c user: drh tags: in-scan-vs-index) | |
|
2020-09-29
| ||
| 23:52 | The OP_SeekScan opcode is a no-op if the cursor is not pointing to a valid row upon entry. (check-in: 4afc96b5fe user: drh tags: in-scan-vs-index) | |
| 20:22 | Coverage testing of the OP_SeekScan opcode. Fix a problem that comes up when OP_SeekScan reaches the end of the table. (check-in: 9e57e758a6 user: drh tags: in-scan-vs-index) | |
| 17:29 | Improved comments on the new OP_SeekScan opcode. (check-in: 6110fdd5bb user: drh tags: in-scan-vs-index) | |
| 16:05 | Improved performance by manually in-lining the sqlite3VdbeIdxKeyCompare() routine for the OP_IdxGT opcode and its kin. (check-in: 2206a2c848 user: drh tags: in-scan-vs-index) | |
| 15:32 | Typo fix to repair the early-out optimization. Also avoid unnecessary OP_SeekHit opcodes. (check-in: 8fd7d8dfcd user: drh tags: in-scan-vs-index) | |
| 01:48 | The OP_SeekScan opcode works, but using it requires disabling the IN-earlyout optimization because the OP_IfNoHope opcode might move the cursor. (check-in: f3c36b840c user: drh tags: in-scan-vs-index) | |
|
2020-09-28
| ||
| 19:51 | Revisiting the IN-scan optimization to try to fix it for the corner case where the statistics deceive the query planner into using a scan when an indexed lookup would be better. This check-in changes the code generation to do the IN-scan using a new OP_SeekScan opcode. That new opcode is designed to abandon the scan and fall back to a seek if it doesn't find a match quickly enough. For this work-in-progress check-in, OP_SeekScan is still a no-op and OP_SeekGE still ends up doing all the work. (check-in: d720b6981e user: drh tags: in-scan-vs-index) | |
| 15:49 | Small performance improvement and size reduction by reducing the size of the WhereTerm object. (check-in: 43f7ddad80 user: drh tags: trunk) | |
| 13:34 | Avoid the possibility of integer overflow on the --pagecache option to the CLI. See forum post 10a2892377 (check-in: d3d13df31a user: drh tags: trunk) | |
|
2020-09-25
| ||
| 17:17 | Clarify (check-in: 14dba0f3b5 user: shearer tags: btree-code-documentation) | |
| 16:54 | Distinguish between checkpoints (WAL-only, implementation specific) and savepoints (Btree internal implementation of COMMIT/ROLLBACK subtransactions) and SQL SAVEPOINT (identical name for SQL-level subtransactions) (check-in: ae686ab6a8 user: shearer tags: btree-code-documentation) | |
| 14:26 | Reset to trunk's func. Still learning Fossil. (check-in: a4840cf5c6 user: shearer tags: btree-code-documentation) | |
| 13:56 | More classification of functions. Fix incorrect comment that sqlite3BtreeCursorHasHint() is only used within asserts. (check-in: 78d8db7cb7 user: shearer tags: btree-code-documentation) | |
| 09:42 | Merge recent trunk changes into the btree-code-documentation branch (check-in: 3a576608e6 user: shearer tags: btree-code-documentation) | |
| 08:17 | Add reminder comment that, by definition, these functions won't be called from elsewhere in SQLite. Useful to remember for beginners who may suspect unusued code. (check-in: 6f5c1fde24 user: shearer tags: btree-code-documentation) | |
|
2020-09-24
| ||
| 11:41 | Added context to explain that the test coverage is about MC/DC in general, not just an SQLite-specifc test harness. (check-in: 770dbedddc user: shearer tags: btree-code-documentation) | |
| 06:37 | Group metadata definitions together (check-in: 5c306f4251 user: shearer tags: btree-code-documentation) | |
|
2020-09-23
| ||
| 17:31 | Figured out where/how sqlite3BtreeRowCountEst() is called (check-in: a46537153c user: shearer tags: btree-code-documentation) | |
|
2020-09-21
| ||
| 20:18 | Fix harmless compiler warning seen with MSVC. (check-in: 4591ee03d7 user: mistachkin tags: trunk) | |
| 14:53 | In fts5 integrity checks, do not compare the contents of the index against an external content table unless specifically requested. (check-in: 782163693f user: dan tags: trunk) | |
|
2020-09-20
| ||
| 13:33 | Remove a new assert() that the compiler finds is always true at compile-time, to avoid a compiler warning. (check-in: 8bbaee2385 user: drh tags: trunk) | |
| 12:10 | Attempt to silence harmless static analyzer warnings in Lemon and in the Lemon-generated parser. (check-in: de8ce22a46 user: drh tags: trunk) | |
|
2020-09-17
| ||
| 21:11 | Fix a typo in the documentation comment for sqlite3_preupdate_hook(). (check-in: 4542d194e2 user: dan tags: trunk) | |
| 17:01 | Fix a problem in sqlite-expert causing it to ignore equality constraints on the second or subsequent columns of a multi-column PRIMARY KEY. (check-in: c666c85a43 user: dan tags: trunk) | |
| 15:16 | Fix a problem in fts5 causing the in-memory hash table to be flushed more often than necessary. (check-in: 9a55601d07 user: dan tags: trunk) | |
| 15:04 | Order btree.h by logical function, add comments (check-in: ab53b31795 user: shearer tags: btree-code-documentation) | |
| 14:16 | Fix a "jump depends on unitialized value" valgrind/asan error in fts5. (check-in: 66f94d623c user: dan tags: trunk) | |
| 11:56 | Earlier detection of corruption in the rtreecheck() SQL function to prevent a (harmless) read of an uninitialized value. (check-in: e2074b2478 user: drh tags: trunk) | |
| 11:32 | Prevent use-after-free of the u.vtab.idxStr string following an OOM while generating the OP_VFilter opcode. (check-in: 751fe4edb2 user: drh tags: trunk) | |
| 00:46 | DISTINCT may not be ignored inside a UNION ALL common table expression. Fix for ticket [c51489c3b8f919c5] (check-in: 7d2b590d3a user: drh tags: trunk) | |
|
2020-09-16
| ||
| 19:48 | Fix a pair of assert()s in "PRAGMA foreign_key_check" that might have given a false-positive following an OOM. (check-in: 9ea3039b53 user: drh tags: trunk) | |
| 16:55 | Fix harmless compiler warnings in Lemon. (check-in: 6c94ba4b1c user: drh tags: trunk) | |
|
2020-09-15
| ||
| 20:48 | Fix a buffer overread found by OSSFuzz that could occur if a WITHOUT ROWID table with many columns was NATURAL JOINed against itself. (check-in: 3d35fa0be8 user: dan tags: trunk) | |
| 12:29 | Do not invoke usleep() for more than 999999 microseconds. (check-in: 1f5ed852f2 user: drh tags: trunk) | |
|
2020-09-11
| ||
| 15:01 | 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 tags: trunk) | |