SQLite

Timeline
Login

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

200 most recent check-ins using file tool/mkccode.tcl version 86463e68ce

2025-02-19
00:18
Version 3.44.4 (Leaf check-in: f1e31fd996 user: drh tags: branch-3.44, version-3.44.4, patch-release)
2025-02-18
18:05
Cherry pick recent fixes into branch-3.44. (check-in: 75bbd094db user: drh tags: branch-3.44)
2025-01-10
18:03
Update log messages on this branch to say "v=22". Also add log message to slow calls to sqlite3_schema_copy(). (Leaf check-in: b0cd8dfcf9 user: dan tags: cf8f1552-commit-instr)
17:36
Add the experimental sqlite3_schema_copy() API, for copying schemas between database handles. (check-in: 04ea435d24 user: dan tags: cf8f1552-commit-instr)
17:09
Minor updates to schemacopy.test. (Closed-Leaf check-in: 1d544b535f user: dan tags: schema-copy)
15:10
Allow ".testctrl schemacopy 1" in the shell tool on this branch. For testing sqlite3_schema_copy(). (check-in: 1edc2e5590 user: dan tags: schema-copy)
11:34
Update test script wal2big2.test to be less sensitive to PRNG output. (check-in: 2a5e7c5cd6 user: dan tags: schema-copy)
2025-01-09
20:41
Run tests with SQLITE_TESTCTRL_SCHEMACOPY for mdevtest and sdevtest on this branch. (check-in: c25dd2dec5 user: dan tags: schema-copy)
19:18
Rationalize and add comments to new code on this branch. (check-in: e1603c9cda user: dan tags: schema-copy)
17:12
Fix minor issues on this branch. Remove unused code. (check-in: c2610bb4be user: dan tags: schema-copy)
2025-01-08
17:16
Fix problem in test code on this branch. (check-in: 05d90f8b28 user: dan tags: schema-copy)
10:55
Ensure that integrity-check processes tables in the same order when using a copied schema as it does when using one loaded directly from the db. (check-in: 961af94442 user: dan tags: schema-copy)
2025-01-07
21:04
Fix many problems in the sqlite3_schema_copy() function. (check-in: ac9ca88590 user: dan tags: schema-copy)
2025-01-06
20:39
Implemenation of experimental API sqlite3_schema_copy(), for copying a database schema between connections. More testing to come. (check-in: 65ede04d21 user: dan tags: schema-copy)
2024-12-23
11:31
Up logs to "v=21". (check-in: dc3a24a784 user: dan tags: cf8f1552-commit-instr)
11:23
Experimental: If SQLite is compiled with SQLITE_WAL_BIGHASH defined, use hash tables large enough to fit 128K, instead of 4K, entries in the *-shm file. (check-in: 6e800b7035 user: dan tags: cf8f1552-commit-instr)
2024-12-20
19:37
When loading stat4 data, make a single large allocation for all Index.aSample[] arrays, instead of a separate allocation for each. (check-in: b40cd7395c user: dan tags: cf8f1552-commit-instr)
2024-12-13
18:13
Avoid a memset() when loading stat4 data. Add instrumentation to the same code. (check-in: fa87355f62 user: dan tags: cf8f1552-commit-instr)
2024-12-12
20:39
Increase the maximum number of arguments on an SQL function to 1000 with the capability to increase it further up to 32767 using a compile-time option. (check-in: 3c25c69c93 user: drh tags: cf8f1552-commit-instr)
19:20
Add extra logging for alternative stat4 code. (check-in: 9dde0365cb user: dan tags: cf8f1552-commit-instr)
19:15
Experimental code to load stat4 data using a single pass. (check-in: e0bcd30581 user: dan tags: cf8f1552-commit-instr)
2024-12-11
20:42
When a writer initializes a new *-shm file hash table, zero only the hash-table slots, not the array of page numbers. (check-in: ac5401c62b user: dan tags: cf8f1552-commit-instr)
2024-12-10
14:56
Fix a problem with the formatting of "slow schema" log messages. Also change logging version to v=17. (check-in: df4183ace9 user: dan tags: cf8f1552-commit-instr)
2024-12-09
21:26
Fix a problem with non-PASSIVE wal2 checkpoints sometimes taking the WRITER lock. (check-in: 1a59cae3c3 user: dan tags: cf8f1552-commit-instr)
2024-12-07
21:20
Version 3.47.2 for the reuse-schema branch. (Leaf check-in: 96428a5137 user: drh tags: reuse-schema-3.47)
21:16
Version 3.47.2 for wal2 (Leaf check-in: 11fd09dbb7 user: drh tags: wal2-3.47)
21:14
Version 3.47.2 for begin-concurrent (Leaf check-in: e725fe5aec user: drh tags: begin-concurrent-3.47)
20:39
Version 3.47.2 (Leaf check-in: 2aabe05e2e user: drh tags: release, version-3.47.2, branch-3.47)
20:01
Yet another iteration of the solution to the floating-point conversion problem. This one avoids complaints about oversize double values from -fsanitize. (check-in: 07bd06b13c user: drh tags: branch-3.47)
19:12
A cleaner and more robust solution to the floating-point conversion problem originally fixed earlier today. (check-in: 18b20494ce user: drh tags: branch-3.47)
14:53
Increment the version number to 3.47.2 (check-in: 42aa7157f8 user: drh tags: branch-3.47)
14:51
On x64 hardware, round-trip uint64_t→double→uint64_t conversions fail for values greater than UINT64_MAX-2047. This caused the SQLite text-to-float converter routine to give incorrect results for values between '1.8446744073709550592eNNN' and '1.8446744073709551609eNNN' for any exponent NNN. Fixed by this check-in. (check-in: 17537a98cb user: drh tags: branch-3.47)
2024-12-06
17:52
Update logging (now v=16) to more closely analyze all attempts to load the main db schema. (check-in: 65b753735b user: dan tags: cf8f1552-commit-instr)
09:36
Guard the x64 assembler in wal.c with "ifdef __x86_64__". (check-in: 5fa1699e31 user: dan tags: cf8f1552-commit-instr)
2024-12-05
19:45
Add logging to report on occasions when loading the ANALYZE data is slow. (check-in: 5f9f6764e9 user: dan tags: cf8f1552-commit-instr)
16:52
Use an inline asm "ret stosp" instruction instead of a memset() when a writer is required to zero a hash table. (check-in: c10fa6af8b user: dan tags: cf8f1552-commit-instr)
2024-12-04
11:01
Temporarily enable zeroing of wal2-mode hash tables within PASSIVE, as well as non-PASSIVE, checkpoints. (check-in: a97a2b0da1 user: dan tags: cf8f1552-commit-instr)
2024-12-02
19:32
Ensure that the query flattener does not change an ON clause term to a WHERE clause term. (check-in: e487d3b3c0 user: drh tags: branch-3.47)
16:38
Add the SVG version of the SQLite logo. (check-in: a2061fe09f user: drh tags: branch-3.47)
2024-12-01
16:19
Fix the percentile extension so that works as an independent extension. Forum post ab25469a350e0488 (check-in: 86256f2cd4 user: stephan tags: branch-3.47)
2024-11-28
19:14
Update logging version to "v=13". (check-in: 442167b86a user: dan tags: cf8f1552-commit-instr)
18:58
In wal2 mode, attempt to zero old *-shm hash table pages within non-PASSIVE checkpoints. This saves writers from having to do it. (check-in: 40aafd4585 user: dan tags: cf8f1552-commit-instr)
2024-11-26
17:30
Avoid ever logging times for ROLLBACK commands. (check-in: bc7f7986ec user: dan tags: cf8f1552-commit-instr)
2024-11-25
14:16
Version 3.47.1 for the reuse-schema branch. (check-in: 83e95cf3ed user: drh tags: reuse-schema-3.47)
12:07
Version 3.47.1 (check-in: b95d11e958 user: drh tags: release, version-3.47.1, branch-3.47)
2024-11-22
18:50
Fix a problem handling OOM errors in fts3 that could occur when parsing multi-token strings. (check-in: c8dcac3340 user: drh tags: branch-3.47)
17:45
Fix two problems with argument expansion in sqlite-tclsh on Windows. (check-in: dcef1992d5 user: drh tags: branch-3.47)
16:52
Remove a flaky JS test which has a result depending on unrepredictable context. That same feature is more reliably tested at a later point in the same script. (check-in: 540a4a1624 user: stephan tags: branch-3.47)
12:12
Fix some harmless scanbuild warnings in the shell. (check-in: 04d6124d34 user: drh tags: branch-3.47)
11:27
Document that -nofollow does not work on Windows. Fix Windows symlink test cases for when the test suite is run as administrator. (check-in: 3f76388a47 user: drh tags: branch-3.47)
11:18
Bump the version number to 3.47.1 (check-in: b6942a0b2f user: drh tags: branch-3.47)
2024-11-20
21:45
Cherrypick a couple of changes requested by Mozilla onto the 3.47 branch. (check-in: b50d20d795 user: drh tags: branch-3.47)
20:26
Logging enhancements. And mark logs v=12. (check-in: 853f9cf453 user: dan tags: cf8f1552-commit-instr)
18:49
Experimental change to omit writing frame checksums to the wal file. (check-in: 4d37067270 user: dan tags: cf8f1552-commit-instr)
17:47
Update logging version to "v=11". This should have been part of the previous commit. (check-in: e6663fab61 user: dan tags: cf8f1552-commit-instr)
15:02
If a subquery is copied and then changes are made to the copy, be sure to give the copy a unique Select.selId value so that the original will not be substituted in place of the modified copy. (check-in: 16d46e1160 user: drh tags: branch-3.47)
11:37
Do not report an sqlite3_error_offset() for errors that occur inside of views or triggers, since the text of those elements is not part of the original query. (check-in: cb5ddebf79 user: drh tags: branch-3.47)
2024-11-19
17:32
Extra logging for the freelist and hash table components of COMMITs of BEGIN CONCURRENT transactions. (check-in: 2ba41da8c4 user: dan tags: cf8f1552-commit-instr)
2024-11-17
09:51
buildtclext.tcl: add docs explaining the DESTDIR check and break out of the auto_path search loop early if the DESTDIR is not writable, rather than re-checking that repeatedly. (check-in: 322be94569 user: stephan tags: branch-3.47)
2024-11-16
17:12
Handle DESTDIR at an earlier phase in buildtclext.tcl to account for the is-writable-dir check and to filter out //zipfs: dirs as (im)possible installation targets. (check-in: 2f6e5946cf user: stephan tags: branch-3.47)
14:33
Add DESTDIR support to the tclextension-install target, via [67a3ca0c013b] and [d1663cf05f7d]. (check-in: 38136b33f9 user: stephan tags: branch-3.47)
2024-11-13
14:42
Increase maximum length of sqlite3_log() messages to 700 bytes. Mark log messages as v=10. (check-in: 35aa893d45 user: dan tags: cf8f1552-commit-instr)
11:12
Optimize deferred allocation of pages on this branch by avoiding BTALLOC_LE. (check-in: e0c0176793 user: dan tags: cf8f1552-commit-instr)
2024-11-09
18:17
Fix a case in fts3 where a corrupt database record was not being handled correctly. (check-in: 17bc57fa16 user: drh tags: branch-3.47)
2024-11-08
17:09
Even more detailed logging of slow COMMIT statements. (check-in: 3a45387a09 user: dan tags: cf8f1552-commit-instr)
2024-11-07
18:06
Fix an OOB write that could occur in fts3 when dealing with corrupt database records. (check-in: 521b873be7 user: drh tags: branch-3.47)
2024-11-05
18:53
Have the xBestIndex method of the generate_series virtual table ignore contraints on the "value" column with usable=0. (check-in: 1333e54422 user: dan tags: branch-3.47)
2024-11-04
17:33
Avoid loading the entire record into memory for an sqlite3_preupdate_old() call that retrieves an IPK value. (Leaf check-in: f9a90a0d2c user: dan tags: branch-3.46)
13:59
Fix two mismatched uses of malloc() and sqlite3_free() in sqlite3_stdio.c, as reported in forum post 7dd7c70038. (check-in: 5238959d05 user: stephan tags: branch-3.47)
2024-11-01
15:25
Update log messages to say "v=8" instead of "v=7". (check-in: 492a0a8543 user: dan tags: cf8f1552-commit-instr)
15:20
Still more logging, this time focused on the sqlite3WalFrames() function. (check-in: 52d332f0c7 user: dan tags: cf8f1552-commit-instr)
2024-10-30
18:24
Add extra logging to analyze COMMIT commands. (check-in: 7dbb43bd30 user: dan tags: cf8f1552-commit-instr)
00:35
Replace 3 instances of the == 'test' shell command operator with =, as == is apparently not as portable across shells. Problem reported in forum post 14274389fb2. (check-in: 68199c40fe user: stephan tags: branch-3.47)
2024-10-25
18:37
Update special logging messages on this branch to say "v=6" instead of "v=5". (check-in: af4e778bd3 user: dan tags: cf8f1552-commit-instr)
18:24
Reduce the number of malloc()/free() calls that may occur when a BEGIN CONCURRENT transaction is committed. (check-in: fcd68bebf2 user: dan tags: cf8f1552-commit-instr)
2024-10-24
19:31
Patch sqlite3_rsync.c to disable undesirable automatic line ending conversions on Windows. (check-in: e3c27c6d8a user: drh tags: branch-3.47)
16:02
Add missing ZERO_ARGUMENT_GENERATE_SERIES checks to ext/misc/series.c. (check-in: 31e104cc40 user: stephan tags: branch-3.47)
15:58
Add missing ZERO_ARGUMENT_GENERATE_SERIES checks to ext/misc/series.c, as reported via support mail. (check-in: 5a8e3915ee user: stephan tags: trunk)
15:57
Add missing ZERO_ARGUMENT_GENERATE_SERIES checks to ext/misc/series.c, as reported via support mail. (Closed-Leaf check-in: cd82e4c0f5 user: stephan tags: ifdef-SQLITE_CORE)
12:06
Fix an inconsistency in the way SQLITE_CORE is used in fts3.c. (check-in: d4816e534a user: dan tags: trunk)
07:44
Beginnings of rephrasing #if SQLITE_CORE to #ifdef/ifndef for consistency, as discussed in forum post cea40371c5e34b09. (check-in: 58d91abf0c user: stephan tags: ifdef-SQLITE_CORE)
2024-10-23
17:16
Extra logging to debug slow commit statements. (check-in: 9cafae1fff user: dan tags: cf8f1552-commit-instr)
11:33
Reorder conditions in sqlite3PagerDirectReadOk() for coverage. (check-in: da9124fee2 user: drh tags: trunk)
11:06
Fix harmless compiler warnings in wherecode.c. One such warning was identified by forum post 721675f007 and the other was found by tool/warnings.sh. (check-in: 987b96aa63 user: drh tags: trunk)
10:36
Add two new #include statements to the composite "fts5.c" file that is constructed as part of the build process. These #includes are no-ops in the SQLite amalgamation (and are commented out automatically by the amalgamation builder) but are needed if the FTS5 extension is built separately, it seems. Enhancement request. (check-in: 1bf8daeb24 user: drh tags: trunk)
2024-10-22
20:16
Changes to EXPLAIN QUERY PLAN to identify covering index plan that use indexes on expressions. (check-in: 29fb4919b6 user: dan tags: trunk)
20:09
Add the "halt" command to testrunner.tcl (check-in: 2cc25d5dbb user: drh tags: trunk)
19:33
Add the SQLITE_IOCAP_SUBPAGE_READ bit to the possible returns values from xDeviceCharacteristics method of the system-IO abstract class. The direct-overflow-read optimization is disabled for any VFS that does not set this bit. The bit is set for standard VFSes. (check-in: 6e7d498cda user: drh tags: trunk)
18:26
Rename to SQLITE_IOCAP_SUBPAGE_READ. (Closed-Leaf check-in: dd446ef181 user: drh tags: bypass-iocap)
18:00
Add the SQLITE_IOCAP_BYPASS device characteristic. Do not allow the SQLITE_DIRECT_OVERFLOW_READ optimization if that capability is missing. (check-in: f50ae00ce9 user: drh tags: bypass-iocap)
16:26
Add still more logging to determine why schema loads are so slow in some circumstances. (check-in: d02ec06e5b user: dan tags: cf8f1552-commit-instr)
16:19
Do not typedef Tcl_Size if it is already #defined. (check-in: 53491688cf user: drh tags: trunk)
10:29
Further changes to sqlite3_rsync.c to work around Windows issues. (check-in: e2bd3219d9 user: drh tags: trunk)
09:43
Set I/O mode to binary in Windows in sqlite3_rsync. (check-in: 6717528744 user: drh tags: trunk)
2024-10-21
22:45
In testrunner.tcl: Better estimates for ETC (Estimated Time to Completion). Show the ETC even for the single-line status reports. (check-in: 2a2f5f4e37 user: drh tags: trunk)
21:53
Add sqlite3rebaser_... to the API symbols accepted by the 'checksymbols' makefile target. (check-in: 0284590f21 user: stephan tags: trunk)
17:13
Update the reuse-schema branch to version 3.47.0 (check-in: d49d282795 user: drh tags: reuse-schema)
17:10
Update the bedrock branch to version 3.47.0 (check-in: d2d954d43a user: drh tags: bedrock)
17:05
Update the wal2 branch to version 3.47.0 (check-in: d34b6a9138 user: drh tags: wal2)
17:00
Update the begin-concurrent branch to version-3.47.0 (check-in: 457bb035e3 user: drh tags: begin-concurrent)
16:30
Version 3.47.0 (check-in: 03a9703e27 user: drh tags: trunk, release, major-release, version-3.47.0)
14:24
Add a case to testrunner.tcl so that mdevtest can run on openbsd. (check-in: e904b37fb2 user: dan tags: trunk)
11:49
Add extra logging to SQL statements used to load the database schema on this branch. This requires SQLITE_ENABLE_STMT_SCANSTATUS. (check-in: 08e1dea9c0 user: dan tags: cf8f1552-commit-instr)
10:47
Avoid using LIKE in sqlite3expert.c, in case "PRAGMA case_sensitive_like" has been used or the "like" UDF replaced by something unexpected. (check-in: 9f642b3dbc user: dan tags: trunk)
2024-10-20
07:19
Fix another problem with ".expert" and virtual tables. Forum post 49d6a19ec. (check-in: 7a7162293c user: dan tags: trunk)
2024-10-19
22:45
Add sqlite3_rsync to the docs at the top of mktoolzip.tcl. No code changes. (check-in: 10f5c4a2fc user: stephan tags: trunk)
13:38
Add missing TEXE suffixes in the tool-zip makefile target. (check-in: 5a594dbcd5 user: stephan tags: trunk)
13:20
Move the #include of hwtime.h from the bottom of util.c to the top of vdbe.c so that it will be available when needed, even for non-amalgamation builds. (check-in: 5f23036a87 user: drh tags: trunk)
12:47
Get the spell-checking targets working. Rename some symbols. (check-in: e389ef9c14 user: stephan tags: autosetup)
12:39
An assortment of comment typo fixes discovered by aspell. Add several new words to tool/custom.txt. No code changes. (check-in: 59b76a99e4 user: stephan tags: trunk)
11:02
Remove unnecessary VACUUMs from the previous check-in to sqlite3_rsync. (check-in: ad8d481242 user: drh tags: trunk)
00:49
Get mptest(er) building. (check-in: f740f6a444 user: stephan tags: autosetup)
00:16
Fix the sqlite3_rsync utility so that it is able to synchronize a database using a UTF16 text encoding. Forum post e055d50821. (check-in: 981347009c user: drh tags: trunk)
2024-10-18
23:54
Minor doc cleanups in SQLTester.mjs and confirm that the tests pass with both OPFS VFSes. (check-in: ac747d57c2 user: stephan tags: trunk)
23:36
Fix three bugs in SQLTester.mjs which caused --tableresult tests, escaping of SQL values to incorrectly fail, and the --column-names setting to not be reset between tests. (check-in: 779368dd9b user: stephan tags: trunk)
23:10
Fix a var reference typo in SQLTester.mjs. (check-in: 31179fa78e user: stephan tags: trunk)
16:50
Remove the unused dbfuzz2-asan/msan makefile targets. Fix a comment typo in a makefile. (check-in: 07843ac245 user: stephan tags: trunk)
16:47
Remove the problematic dbfuzz2-asan/msan targets, which Richard says are not used anymore. (check-in: 503ce205a1 user: stephan tags: autosetup)
16:39
Get most of the fuzzing-related apps building, sans dbuzz2-asan/msan, both of which refuse to link with clang v18 because it's trying to use -lstdc++ despite the app being only C. (check-in: 3e84345292 user: stephan tags: autosetup)
12:31
Remove a not-strictly-necessary 'undefine' invocation from ext/wasm/GNUmakefile, as it is not compatible with too-old versions of gmake. Resolves the problem reported in forum post e57932e3ccdc2c9c. (check-in: a31a946441 user: stephan tags: trunk)
10:51
Minor enhancements to the compile-for-windows.md document. (check-in: 5f0cc7f264 user: drh tags: trunk)
10:42
Fix typo in the README.txt for the amalgamation autoconf tarball. (check-in: 62d24a69fe user: drh tags: trunk)
01:14
New assert() statements to validate OP_OpenEphemeral logic. (check-in: 6d55c3e238 user: drh tags: trunk)
2024-10-17
23:14
Fix obsolete M4 macro in the configure script for the TEA extension within the autoconf tarball. (check-in: 360613a224 user: drh tags: trunk)
22:20
Merge current trunk into the autosetup branch. (check-in: 352da23b46 user: stephan tags: autosetup)
22:19
General cleanups. Rename BTCL to BTCLSH for some clarity. (check-in: 83eaef7d62 user: stephan tags: autosetup)
18:12
Fixes from code inspection: (1) Extra paranoid defense against integer overflow. (2) Remove a stray blank line in an FTS5 comment. (check-in: 8563728dee user: drh tags: trunk)
16:22
Fix a typo in compile-for-unix.md. Simplify hyperlinks in the compile-for-* documents. (check-in: 8cd7d15774 user: drh tags: trunk)
13:29
Improved README.txt file in the amalgamation-autoconf tarball. (check-in: b781435038 user: drh tags: trunk)
13:00
Attempt to get the TEA builder in the amalgamation-autoconf tarball working using hints from Jan Nijtmans. (check-in: ad9d7bdef9 user: drh tags: trunk)
12:17
Fix the OPFS VFS's xOpen() to honor the read-only flag. Fix the OPFS SAHPool VFS to enable re-installation of the VFS after calling OpfsSAHPoolUtil.removeVfs(). (check-in: 63ee358420 user: stephan tags: branch-3.46)
12:14
Ensure that the OPFS VFS's xOpen() writes back the read-only flag to the output flags. Resolves the problem reported in forum post cf37d5ff1182c31081. (check-in: 0a32624015 user: stephan tags: trunk)
11:12
When calling OpfsSAHPoolUtil.removeVfs(), ensure that the cached result the VFS init is also removed so that the VFS may later be registered again with the same name. Set up test code for the regression reported in forum post cf37d5ff11 (which uncovered the removeVfs() shortcoming) but that test is currently only known to fail with the "opfs" VFS and is not currently set up to fail. (check-in: b7f7a5deea user: stephan tags: trunk)
2024-10-16
15:14
Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 93f0febab4 user: drh tags: reuse-schema)
15:09
Merge the latest trunk enhancements into the bedrock branch. (check-in: d5289de411 user: drh tags: bedrock)
15:03
Merge the latest trunk enhancements into the wal2 branch. (check-in: 2e96c8bb7a user: drh tags: wal2)
14:52
Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 92cd032aa9 user: drh tags: begin-concurrent)
14:05
Add has_tclconfig to the tidy makefile target. (check-in: 309e6d6f07 user: stephan tags: trunk)
14:04
Get testfixture building. (check-in: 9a7e56a017 user: stephan tags: autosetup)
13:02
Merge trunk into this branch. (check-in: 9c3bb3dc4f user: stephan tags: autosetup)
11:05
Change the name of the new utility program from sqlite3-rsync to sqlite3_rsync - dash changed to underscore - for consistency with the preexisting sqlite3_analyzer. (check-in: 86e794cbaa user: drh tags: trunk)
10:20
In the unix Makefile, strip compiled binaries prior to adding them to the tool ZIP archive. (check-in: cd8ae6fd71 user: drh tags: trunk)
2024-10-15
22:22
Fix harmless compiler warning in flockCheckReservedLock(). (check-in: f369de3d8f user: drh tags: trunk)
18:45
Fix the "tool-zip" makefile target so that it includes sqlite3-rsync. (check-in: ecdbedb16b user: drh tags: trunk)
14:28
Fix a typo in a comment used to generate document. No code changes. (check-in: 9b4bc5c4c1 user: drh tags: trunk)
14:00
Cross-reference the sqlite3_backup_init() function to the documentation for VACUUM INTO and sqlite3-rsync. Comment changes only. No changes to code. (check-in: 405c23ce02 user: drh tags: trunk)
2024-10-14
18:43
Avoid the possibility of buffer overrun in the READ_UTF8 macro by using an less-than operator rather than not-equal-to. (check-in: 20e60bf058 user: drh tags: trunk)
11:48
There is no need to DELETE the content of sqlite_sequence in the output of the CLI ".dump" command because that table will initially be empty if it exists at all. Forum post 2e31f49d004 (check-in: 8d7fe903d0 user: drh tags: trunk)
10:45
The CLI now default to ".crlf ON" in Windows. CSV output always uses CRLF on all platforms. (check-in: 84d19f03b1 user: drh tags: trunk)
09:19
Be consistent about using "CRLF" instead of "CRNL". (check-in: ec4f4cfd5f user: drh tags: trunk)
09:08
Fix a harmless compiler warning in the CLI. (check-in: 31c46e84ff user: drh tags: trunk)
2024-10-12
19:33
Fix a problem with the ".expert" command and queries that use virtual tables. (check-in: 43787b8ec5 user: dan tags: trunk)
18:33
Ensure that test file ext/expert/expert1.test works with non-fts5 builds. (Closed-Leaf check-in: 933dfd0618 user: dan tags: expert-vtab-fix)
18:00
Allow the ".expert" command to analyze statements that use built-in virtual tables. (check-in: a201906cd3 user: dan tags: expert-vtab-fix)
2024-10-11
23:31
Additional clarification in the comments to sqlite3_stdio.c. No changes to code. (check-in: 2db24c5364 user: drh tags: trunk)
20:36
Experimental change to explain query plan to identify covering indexes on expressions. (Closed-Leaf check-in: 3bb03a2891 user: dan tags: eqp-covering-index-on-expr)
19:57
Update comments in ext/misc/sqlite3_stdio.c to reflect the latest enhancements. No changes to code. (check-in: 9621c3b527 user: drh tags: trunk)
19:33
Add the doc/compile-for-unix.md document. (check-in: a3e16e478b user: drh tags: trunk)
19:22
Avoid a segfault when calling src-verify without any arguments. (check-in: c0c4e6f111 user: stephan tags: trunk)
19:18
Add two missing $(BEXE) suffixes, as reported in forum post 9ad28680d3. Problem introduced by [1218a203483cecdc] being incomplete in where it added that suffix. (check-in: de9663c0aa user: stephan tags: trunk)
19:13
Improved instructions in the TEA readme for building the TCL extension. (check-in: bf996f7102 user: drh tags: trunk)
19:08
Update the README for the TEA extension in the amalgamation tarball. (check-in: acc866c8f1 user: drh tags: trunk)
18:59
Avoid running some new tests in lock5.test with the inmemory_journal permutation. (check-in: 0b12e2e55c user: dan tags: trunk)
17:43
Update the autoconf Makefile.msc (check-in: 911ab32997 user: drh tags: trunk)
17:02
An improved method for statically linking sqlite3_analyzer.exe using Tcl9. Enable wildcard expansion of arguments to testfiture on Windows. (check-in: 9b87ea219b user: drh tags: trunk)
14:30
Fix the CSV output mode in the CLI such that the line ending is NL by default but goes to CRLF if ".crnl on" is set. Make the .crnl command available on non-Windows builds. Update the .crnl command such that if it has no arguments it shows the current setting. (check-in: da750e39df user: drh tags: trunk)
14:02
Avoid undesirable NL to CRLF translation when doing binary output to the Windows console. (check-in: d25bdce36a user: drh tags: trunk)
2024-10-10
15:28
Fix a typo in the previous commit. (check-in: 6deb4794f8 user: dan tags: cf8f1552-commit-instr)
14:31
Add extra logging points to the code on this branch. (check-in: f29ff2f308 user: dan tags: cf8f1552-commit-instr)
10:47
Improvements to TCL9 support. Fixes to the Makefiles so that the "install" targets are consistent and so that they work better with TCL9. (check-in: bcfae7183e user: drh tags: trunk)
10:33
For compatibility, allow the TCL interfact to continue working with TCL 8.5. (Closed-Leaf check-in: 69346e9d47 user: drh tags: make-install-fixes)
09:59
Adjustments to the Makefile.msc to get static builds of sqlite3_analyzer.exe working with TCL9. Update the compile-for-windows.md document for TCL9. (check-in: df16d07d8d user: drh tags: make-install-fixes)
2024-10-09
20:05
Improvements to Makefile.msc: (1) Attempt to find sane values for key variables based on the value of TCLDIR. (2) Default to TCLVERSION 90 instead of 86. (3) Add the "tcl-env" target that shows the values of key variables associated with TCL. (check-in: 6b7a789a41 user: drh tags: make-install-fixes)
17:47
Add quotes around $(CC) in tclextension-related targets so that a CC of "ccache cc" works. (check-in: e8f719d13f user: stephan tags: make-install-fixes)
16:32
Fix a problem in the generate_series() extension introduced by [d50b784807333c54]. (check-in: 41d58a014c user: drh tags: trunk)
16:28
Fix the xCheckReservedLock() method of the flock VFS to avoid dropping the file lock. (check-in: f7acb189d8 user: dan tags: trunk)
15:40
Fix the xCheckReservedLock() method of the flock VFS to avoid dropping the file-lock. (Closed-Leaf check-in: 8ffaf85249 user: dan tags: flock-vfs-fix)
13:54
Change the makefile to prefer the use of tclsh9.0 if it is available. (check-in: 28e2b9a23f user: drh tags: make-install-fixes)
13:40
Make it so that the TCL extension installed using "make install" has the same name as the one installed by "make tclextension-install". (check-in: e21fc1ba44 user: drh tags: make-install-fixes)
13:26
Add sqlite3rc.h build. (check-in: 8d5f99f7e3 user: stephan tags: autosetup)
13:20
More work on the tcl build parts. (check-in: 292ad7d519 user: stephan tags: autosetup)
13:19
Changes to the TCL extension and how it is built, suggested by Jan Nijtmans. (check-in: 9c06901932 user: drh tags: make-install-fixes)
11:52
Improved handling of unicode characters in the LIKE optimization. Follow-up to [bce52ce2a6e7f3d3]. (check-in: 9d0eb39804 user: drh tags: trunk)
08:05
Remove extra layer of quotes around install target dirs. (check-in: f2e3cf219e user: stephan tags: autosetup)
07:12
More work on the tcl build bits. (check-in: f00988a909 user: stephan tags: autosetup)
05:28
Generic build cleanups. (check-in: 2cd213b387 user: stephan tags: autosetup)
05:20
Add a few missing $(BEXE) suffixes on makefile targets which are apparently never run on platforms where that var is non-empty. (check-in: 1218a20348 user: stephan tags: trunk)
04:27
More work on the --with-tcl bits. (check-in: 4d4cc49b6a user: stephan tags: autosetup)
04:01
Get much of the --with-tcl-related bits working. (check-in: 4e4a740369 user: stephan tags: autosetup)
2024-10-08
17:27
Enable the ".crnl" command on Windows builds of the CLI even if the SQLITE_U8TEXT_ONLY or SQLITE_U8TEST_STDIO compile-time options are used. (check-in: 6364a2f044 user: drh tags: trunk)
16:33
Fix build portability problems discovered on an ARM OpenBSD system. (check-in: ef5348dc3f user: stephan tags: autosetup)
16:06
Get some basic install rules working. (check-in: e9ab211f82 user: stephan tags: autosetup)
16:05
Make tool/emcc.sh.in Bourne-friendly. (check-in: a69ab88474 user: stephan tags: autosetup)
15:11
Additional improvements to the behavior of ".crnl" in the CLI. The default output mode is O_BINARY so that results are identical on Windows and non-Windows systems. On Windows you can optionally do ".crnl on" to enable NL-to-CRLF conversion on output. Output to Windows console is always O_U8TEXT and so is unaffected by the .crnl setting. (check-in: dbfc10b898 user: drh tags: trunk)
15:08
Add logging to help analyze slow "PRAGMA cache_size = ?" statements. (check-in: cd6f585cad user: dan tags: cf8f1552-commit-instr)
14:07
Fix the .crnl command in the shell so that it does not get undone by calls to print a quoted string or CSV output. (check-in: 6b932337c8 user: drh tags: trunk)
10:10
Allow expressions with subtypes to be read from indexes unless they are being used as direct or indirect parameters to SQLITE_SUBTYPE functions. (check-in: 39a56a23fe user: drh tags: trunk)
00:15
Add an ALWAYS() on a branch in the new indexed-subtype logic. (Closed-Leaf check-in: f150c3c5b8 user: drh tags: indexed-subtype-expr)
2024-10-07
21:04
Add a NEVER() to an unreachable branch in the new indexed-subtype logic. Mark the pi() function as deterministic. (check-in: 50be8f5091 user: drh tags: indexed-subtype-expr)
18:06
The (undocumented) subtype() SQL function should have the SQLITE_SUBTYPE flag. (check-in: c361dd9184 user: drh tags: indexed-subtype-expr)