SQLite

Timeline
Login

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

129 check-ins for the month beginning 2024-12-01

Following month ↑
2024-12-30
21:23
Add the convenience makefile target (unix-only) "src-archives" that builds the various tarballs and ZIP archives that go on the download page. This is intended to make it easier and less error prone to put up new "draft" download pages for testing. (check-in: 2b17bc4965 user: drh tags: trunk)
13:54
New assert() statements to show that the sqlite3_value.db field is initialized for MemArrays. (check-in: 7cd8ccf57d user: drh tags: trunk)
12:29
Add an extra assert() to releaseMemArray() just to prove that the sqlite3_value.db field is never NULL. (check-in: b969ef1def user: drh tags: trunk)
2024-12-29
11:54
Four new assert() statements to help with static analysis. (check-in: e7f7c9d22b user: drh tags: trunk)
2024-12-28
13:04
Show ETC in fuzzcheck with the --spinner option when there is only one input file. (check-in: 809699aeaa user: drh tags: trunk)
12:32
Fixes to the substr() SQL function so that it can handle ridiculously large numbers in its 2nd and 3rd arguments without signed integer overflows. (check-in: c1de8f916e user: drh tags: trunk)
2024-12-26
16:10
Omit code to link all winShm objects open on a single node into a list. This is no longer required. (check-in: b400ab4ba9 user: dan tags: win32-enable-setlk)
14:40
Merge trunk changes into this branch. (check-in: 3e2893097c user: dan tags: win32-enable-setlk)
2024-12-24
14:44
Properly wait for asynchronous results for calls to LockFileEx() on FILE_FLAG_OVERLAPPED files even if LOCKFILE_FAIL_IMMEDIATELY, which usually causes LockFileEx() to return synchronously, is specified. (check-in: 35b3e73c5a user: dan tags: win32-enable-setlk)
01:05
Merge the latest trunk changes into the reuse-schema branch. (check-in: 5149d50f34 user: drh tags: reuse-schema)
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-22
21:17
In the (debugging) rtreenode() function, do not override an error coming out of sqlite3_result_text(). (check-in: 286559dfb3 user: drh tags: trunk)
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-19
20:29
Fix a test case in sqllimits1.test so that it works with the Apple configuration which changes the default SQLITE_MAX_LENGTH. (check-in: 536fff14ac user: drh tags: trunk)
19:52
Correction to check-in [a9759fc78d6cb0df] - printf() parameters values must be integers. (check-in: 2db531d191 user: drh tags: trunk)
19:02
The BTree mutex must be held when calling sqlite3BtreeLastPage(). This check-in fixes a bug introduced by [cf8b99e17872c054]. (check-in: e6c30ee52c user: drh tags: trunk)
14:20
Fix the sort4.test module so that the first two test cases are omitted when SQLite has been compiled using SQLITE_MAX_WORKER_THREADS=0. (check-in: 5b96dcf5f6 user: drh tags: trunk)
14:09
configure script: only set the SQLITE_TEMP_STORE feature flag if --with-tempstore is explicitly set, to avoid colliding with that flag being set by other means via the test fixture scripts. (check-in: c7839b8097 user: stephan tags: trunk)
14:08
Fix the Microsoft makefile so that it does not set SQLITE_TEMP_STORE unnecessarily. (check-in: f9b92f9513 user: drh tags: trunk)
13:36
Enhance lemon so that it accepts the -U command-line option that undefines a preprocessor macro. (check-in: e2188a3edf user: drh tags: trunk)
12:08
Fix additional integer overflow problems in the substr() function. (check-in: 472abb492f user: drh tags: trunk)
2024-12-18
20:29
Fix possible integer oveflow in the second and third argument to substr(). (check-in: b04b4006f3 user: drh tags: trunk)
20: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. (Leaf check-in: 0cb853ea1d user: dan tags: bedrock-bighash)
18:29
Avoid 32-bit roundoff error on the second argument to round(). Forum post 170aeab92a. (check-in: a9759fc78d user: drh tags: trunk)
03:41
Rename some var refs in ext/lsm1/Makefile for the new build process. (check-in: 0ce42fa586 user: stephan tags: trunk)
2024-12-17
14:32
Do not attempt to truncate a database in sqlite_dbpage if the database is not larger than the requested truncation size. (check-in: cf8b99e178 user: drh tags: trunk)
2024-12-16
20:30
Optimize deferred allocation of pages on this branch by avoiding BTALLOC_LE. (check-in: b1e8046859 user: dan tags: bedrock)
19:31
Fix release test errors on winrt. (check-in: 39bebd50b8 user: dan tags: win32-enable-setlk)
18:35
Merge recent trunk changes into the reuse-schema branch. (check-in: ebbc6752bb user: drh tags: reuse-schema)
18:29
Merge divergence-reduction changes into the bedrock branch. (check-in: ec5d7025cb user: drh tags: bedrock)
18:16
Sync wal2 with trunk. (check-in: caadbe0c0c user: drh tags: wal2)
18:13
Further reduction in divergence from trunk. (check-in: e4406a6e26 user: drh tags: wal2)
18:04
Code formatting changes to make trunk more like wal2. (check-in: 8f725472b0 user: drh tags: trunk)
17:46
Reduce divergence of wal2 from trunk. (check-in: 90d744d674 user: drh tags: wal2)
15:13
Fix a problem on this branch causing a file-handle to be leaked following an OOM condition. (check-in: 5ca12dc964 user: dan tags: win32-enable-setlk)
14:06
Merge all the latest trunk changes and enhancements into the reuse-schema branch. (check-in: 58563686eb user: drh tags: reuse-schema)
13:38
Merge all the latest trunk/wal2 enhancements and fixes into the bedrock branch. (check-in: a0cf2621c4 user: drh tags: bedrock)
13:32
Sync with trunk. (check-in: eab619453a user: drh tags: wal2)
13:25
Changes for better alignment with the wal2 branch. (check-in: 4fab85b3d0 user: drh tags: trunk)
13:05
Synchronize the WASM code with trunk. (check-in: 3619baa19e user: drh tags: wal2)
12:41
Merge all the latest trunk enhancements and fixes into the wal2 branch. (check-in: 011ce4ae69 user: drh tags: wal2)
12:19
Resynchronize the begin-concurrent branch with trunk. (check-in: e4718a04be user: drh tags: begin-concurrent)
12:09
Remove unnecessary divergence from trunk. (check-in: 019b043428 user: drh tags: begin-concurrent)
12:08
Remove unnecessary end-of-line whitespace. (check-in: ae580443d2 user: drh tags: trunk)
11:19
Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: faef90eac3 user: drh tags: begin-concurrent)
07:03
Tiny makefile/configure script doc tweaks. No functional changes. (check-in: ed5e912622 user: stephan tags: trunk)
2024-12-14
17:36
Merge changes from wal2, including the fix to prevent non-PASSIVE checkpoints from ever taking the writer lock. (check-in: eb8449ea9a user: dan tags: bedrock)
17:19
Update to walRestartLog() function to make it shorter easier to merge with branch "bedrock". (check-in: 88d7fb2aef user: dan tags: wal2)
16:50
Fix a problem with non-PASSIVE wal2 checkpoints sometimes taking the WRITER lock. (check-in: 11d7865a56 user: dan tags: wal2)
16:41
Do not attempt to switch wal files when writing if the current transaction read from both wal files. This fix is already on branch 'bedrock'. (check-in: 693cc8e8db user: dan tags: wal2)
2024-12-13
20:18
Fix a problem with the output of "PRAGMA wal_checkpoint" introduced long ago by [63483e22c775183e]. (check-in: c5f7bba868 user: dan tags: wal2)
18:13
Avoid a memset() when loading stat4 data. Add instrumentation to the same code. (check-in: fa87355f62 user: dan tags: cf8f1552-commit-instr)
17:01
Merge all recent trunk enhancements and fixes into the wal2 branch. Addendum: This was part of an attempt to reduce divergence. I'm still trying to figure out the best way to do that. (Closed-Leaf check-in: be32067a2a user: drh tags: mistake)
16:37
Try to reduce incidental divergence between trunk and wal2. (Leaf check-in: 01c8ebfb1f user: drh tags: wal2-conflict-reduction)
01:29
Fix a harmless compiler warning that comes up when using SQLITE_DEBUG in separate compilation mode. (check-in: 52e0f8cab9 user: drh tags: trunk)
2024-12-12
20:59
Fix a buffer overread in test code. Add test configurations for ENABLE_SETLK=1 and FOR_WINRT=1 builds to release testing. (check-in: b558db5db7 user: dan tags: win32-enable-setlk)
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)
15:11
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: e8d7d68ba0 user: drh tags: trunk)
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)
15:30
Ensure that all win32 API functions invocations in os_win.c are made via the function table. Fix asan error in test code. (check-in: 2ffdc799c6 user: dan tags: win32-enable-setlk)
2024-12-10
21:24
Fix a problem with walsetlk.test on windows. (check-in: 704e6567c1 user: dan tags: win32-enable-setlk)
19:00
Ensure windows may block on a SHARED (but not EXCLUSIVE) DMS lock. (check-in: 55e4e7bb00 user: dan tags: win32-enable-setlk)
18:12
Fix walsetlk.test to work on unix. (check-in: 798dff041b user: dan tags: win32-enable-setlk)
17:36
Merge latest trunk changes into this branch. (check-in: d67a42d625 user: dan tags: win32-enable-setlk)
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)
12:32
Fix harmless typo in a comment describing the columnMallocFailure() function. (check-in: 0f3b484fd7 user: drh tags: trunk)
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)
21:01
Bring all the latest trunk fixes and enhancements into the commit-and-continue branch. (Leaf check-in: 19e47df37a user: drh tags: commit-and-continue)
20:46
Make the TCL interface more rebust against very large strings coming out of TCL9. (check-in: e2bae4143a user: drh tags: trunk)
20:37
Enhance the ".import" command of the CLI so that it is able to insert into a view that has an instead-of trigger. Forum post 3e03c73150f8b9f8. (check-in: 7dcc3731a9 user: drh tags: trunk)
20:36
Enhance the ".import" command of the CLI so that it is able to insert into a view that has an instead-of trigger. (Originally checked into the wrong branch.) (check-in: c71acee1cf user: drh tags: commit-and-continue)
17:30
Test the case where a db connection blocks for a while and then successfully obtains the lock. (check-in: 9cbc97ff84 user: dan tags: win32-enable-setlk)
16:01
Enhance tests to ensure that blocking locks, and not calls to xSleep(), are being used by SQLITE_ENABLE_SETLK_TIMEOUT builds when they should be. (check-in: c892242bb6 user: dan tags: win32-enable-setlk)
13:02
Add NEVER() around branches that seems to have been made obsolete by [a350ea7c6b89725b]. (check-in: cb5bad5c74 user: drh tags: trunk)
11:47
Further improvements to the decimal-to-float conversion for values close to LARGEST_UINT64. (check-in: 453c949914 user: drh tags: trunk)
11:37
Fix an obscure problem with multiple outer joins, ON clauses and query flattening. Forum thread 5c8a069d23. (check-in: a350ea7c6b user: dan tags: trunk)
11:12
Fix an obscure problem with multiple outer joins, ON clauses and query flattening. Forum thread 5c8a069d23. (Closed-Leaf check-in: 289daf6cee user: dan tags: forum-5c8a069d23-fix)
10:57
Add a note in Makefile.msc about EXTRA_SRC files possibly requiring manual editing. (check-in: a0a36bad45 user: drh tags: trunk)
10:52
Resynchronize autoconf/Makefile.msc (Closed-Leaf check-in: 8f9c640818 user: drh tags: makefile-fix)
2024-12-08
18:38
Add a note in Makefile.msc about EXTRA_SRC files possibly requiring manual editing, as discussed in forum thread 903f721f3e7c0d25. (check-in: 229c2f013c user: stephan tags: makefile-fix)
2024-12-07
23:29
Merge the latest trunk fixes and enhancements into the bedrock branch. (check-in: 08cfa7e8b3 user: drh tags: bedrock)
23:24
Update the wal2 branch with the latest trunk enhancements and fixes. (check-in: d3ce95f7e0 user: drh tags: wal2)
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, branch-3.47, version-3.47.2)
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:57
Yet another iteration of the solution to the floating-point conversion problem - this what avoids complaints about oversize double values from -fsanitize. (check-in: fc6904a508 user: drh tags: trunk)
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)
19:06
A cleaner and more robust solution to the floating-point conversion problem originally fixed by [81342fa6dd03fffb]. (check-in: 351de57f80 user: drh tags: trunk)
17:08
Fix more harmless compiler warnings. (check-in: f5b8fd7763 user: drh tags: trunk)
16:53
Fix harmless compiler warning caused by the previous check-in. (check-in: 462700aeb7 user: drh tags: trunk)
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)
14:48
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. This problem was introduced by check-in [761d8fd18b0ee868] and first appeared in version 3.47.0 and was reported by forum post 569a7209179a7f5e. Fixed by this check-in. (check-in: 81342fa6dd user: drh tags: trunk)
2024-12-06
18:35
Add the SQLITE_PREPARE_DONT_LOG option for sqlite3_prepare_v3(), that prevents errors in the compilation of the SQL from being sent to sqlite3_log(). (check-in: 8704034254 user: drh tags: trunk)
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)
00:12
Minor doc update in auto.def. No functional changes. (check-in: d324be296d user: stephan tags: trunk)
00:09
Ensure that the post-config checks for @UNEXPANDED_VARS@ pass even if --disable-tcl is used, as reported in forum post 74ef8059fc. (check-in: a38606bf44 user: stephan tags: trunk)
2024-12-05
23:53
Fix the build of sqlite3_analyzer.exe on Windows that was broken by check-in [80f3bf8c2ee31ba1]. (check-in: 223f47b2db user: drh tags: trunk)
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
19:32
Fix filectrl.test so that it works with winrt builds. (check-in: 70b0cfb049 user: dan tags: win32-enable-setlk)
18:27
Assume an NT-based OS when running tests if sqlite_os_type is not set. (check-in: 22e4aeded0 user: dan tags: win32-enable-setlk)
16:01
Minor doc correction in ext/misc/shathree.c, as reported in the forum. No functional changes. (check-in: 3b82d2c6b7 user: stephan tags: trunk)
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-03
19:41
Back out minor changes not required by this branch. (check-in: 68c34ffd23 user: dan tags: win32-enable-setlk)
19:30
Merge latest trunk into this branch. (check-in: eb13b8b3ef user: dan tags: win32-enable-setlk)
19:09
Further test file tweaks to run with SQLITE_OS_WINRT builds. (check-in: 54853421ba user: dan tags: win32-enable-setlk)
15:19
Fix the lock_win32_file test command so that it works with winrt builds. (check-in: 5994656074 user: dan tags: win32-enable-setlk)
2024-12-02
20:48
Fix a problem with SQLITE_OS_WINRT builds. (check-in: baf43e8c7d user: dan tags: win32-enable-setlk)
19:55
Improve the output from the ".testctrl opt" command in the CLI. (check-in: de7064d118 user: drh tags: trunk)
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)
17:21
Ensure that the query flattener does not change an ON clause term to a WHERE clause term. Forum post 3f676b1196. Follow-up to [f1eae192315335d7]. (check-in: bdd408a255 user: dan tags: trunk)
16:38
Add the SVG version of the SQLite logo. (check-in: a2061fe09f user: drh tags: branch-3.47)
16:24
Fix a comment typo on the sqlite3ExprIsSingleTableConstraint() routine. (check-in: 346a845bf1 user: drh tags: trunk)
16:07
Fix a harmless typo in debugging output. (check-in: 578f76cfb2 user: drh tags: trunk)
14:14
Reformulate [9e09d5d6] so that memsys5 shows up in the late-config summary as being enabled and does the right thing if both --debug and --memsys3 are used. (check-in: 447db1cd0a user: stephan tags: trunk)
13:47
Enable MEMSYS5 with the --dev configure option. (check-in: 9e09d5d60a user: drh tags: trunk)
13:29
Slighly less confusing output from treeview during debugging. (check-in: 7aef0b9305 user: drh tags: trunk)
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)
15:23
Trim a bit more from the sqlite370.svg border to get it closer in scaled size to the logo currently on the docsrc site. (check-in: 81c7277fc5 user: stephan tags: trunk)
14:20
Correct the fill color for the background of sqlite370.svg - it was slightly darker than it should have been. (check-in: 732132407b user: stephan tags: trunk)
14:14
Re-export sqlite370.svg to retain the gradient part and clip the size using the cutting guides in sqlite370.eps. (check-in: 12017b01c8 user: stephan tags: trunk)
14:02
Export a clipped copy of sqlite370.eps as sqlite370.svg, based on discussion in forum post 1bbd6d17ca. (check-in: dd3a13c120 user: stephan tags: trunk)
Previous month ↓