SQLite

Timeline
Login

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

100 most recent check-ins

2025-04-15
21:59
Correctly handle the case of a multi-column UNIQUE constraint that contains the ROWID as one of it columns, and then the columns of that UNIQUE are used in a row-value IN operator as a WHERE clause constraint. Reported by forum post b9647a113b. Problem introduced by [723f1be3d4a905a6], part of ticket [da78413751863]. (Leaf check-in: d22475b81c user: drh tags: trunk)
19:53
Fix a minor typo in a code comment. (check-in: 158e8c4fd7 user: drh tags: trunk)
15:20
Cleanups and refactoring in proj.tcl and teaish. (check-in: 6b7ca8176e user: stephan tags: trunk)
11:06
Avoid a potential integer overflow in non-default builds of the fts3 matchinfo() function. (check-in: aecc0100ce user: dan tags: trunk)
02:02
Further cleanups and code consolidation between teaish.tcl and sqlite-config.tcl parts. (check-in: 07e9ceee51 user: stephan tags: trunk)
00:47
Slight simplifications in the teaish build. (check-in: 6b2d0e09e4 user: stephan tags: trunk)
2025-04-14
23:52
Update teaish to the latest upstream copy. Move some of its utility code into proj.tcl for reuse in the top-level configure bits. (check-in: 921c5ea769 user: stephan tags: trunk)
19:43
Improved estimate on the number of output rows in a recursive common table expression that uses the UNION operator. Follow-up to [f911f1c4977fbcae] and it's output row estimate changes associated with DISTINCT queries. (check-in: 92513f6bce user: drh tags: trunk)
13:31
JNI: part 3 (of 3) of typos and Java style tweaks suggested in forum post 99ac7961d82f57f3. Tested with jdk v8 and v21. (check-in: 914d4c9d6c user: stephan tags: trunk)
12:09
JNI: part 2 of typos and Java style tweaks suggested in forum post 99ac7961d82f57f3. (check-in: 5e6e9aee5b user: stephan tags: trunk)
11:31
JNI: part 1 of typos and Java style tweaks suggested in forum post 99ac7961d82f57f3. (check-in: ab00af4e48 user: stephan tags: trunk)
10:20
Doc/help text tweaks in autoconf/tea. (check-in: d6889f6b9a user: stephan tags: trunk)
10:18
Minor cleanups and fixes in the autoconf/tea pieces. (check-in: 4d6536bd0a user: stephan tags: trunk)
2025-04-13
16:22
Latest upstream teaish, which restructures the teaish files a bit. (check-in: 4f54f7d07d user: stephan tags: trunk)
2025-04-12
21:47
tea build: use autosetup's file-normalize instead of Tcl's (file normalize) because JimTcl's (file normalize) throws on cygwin for names like '.' and './'. Update a doc URL. (check-in: 0fe77341a0 user: stephan tags: trunk)
21:24
Port autoconf/tea from the autotools to autosetup. (check-in: 691708642b user: stephan tags: trunk)
19:26
Move the post-configure dot-in-file validation from sqlite-config.tcl to proj.tcl for reuse in the tea port and other downstream trees. (check-in: 0bac496d5c user: stephan tags: trunk)
18:37
Doc typo fix. (Closed-Leaf check-in: 10b917040b user: stephan tags: teaish)
10:33
Eliminate a duplicate -lz flag in the teaish build. (check-in: 5efb372c9b user: stephan tags: teaish)
03:20
Add missing teaish.test.tcl. (check-in: 3946a3ad9c user: stephan tags: teaish)
03:08
Add missing exports of various LDFLAGS and CFLAGS for the teaish build. (check-in: 7462b1c66e user: stephan tags: teaish)
02:44
Correct out-of-tree build for autoconf/tea. (check-in: 955b516618 user: stephan tags: teaish)
02:30
Initial port of the TEA build (autoconf/tea) from autotools to autosetup. (check-in: 95227341cf user: stephan tags: teaish)
2025-04-10
20:52
Fix a memory leak in sqlite3session_diff(). (check-in: a6cbc5db1c user: dan tags: trunk)
19:54
Improved detection of run-time errors (ex: OOM errors) in speedtest1. (check-in: 0e5e0e2f55 user: drh tags: trunk)
19:39
Provide new command-line options --hard-heap-limit and --soft-heap-limit for speedtest1. (check-in: 578e9fedea user: drh tags: trunk)
19:03
Be sure that speedtest1 reports any errors that it encounters while running the speed tests. (check-in: 8c8b1a99bc user: drh tags: trunk)
17:25
Fix a comment in sessionD.test. (check-in: 3516354ee5 user: dan tags: trunk)
16:48
Improve the error messages returned by sqlite3session_diff(). (check-in: a3217cdb75 user: dan tags: trunk)
15:01
Fix an obscure problem allowing the propagate-constants optimization to improperly substitute a column of a sub-query with NONE affinity. Forum post 2025-04-08T14:18:45Z. (check-in: 979f384a93 user: dan tags: trunk)
14:53
Fix an obscure problem allowing the propagate-constants optimization to improperly substitute a column of a sub-query with NONE affinity. (Closed-Leaf check-in: d82725dcae user: dan tags: forum-0109bca824)
10:18
Remove unnecessary "www." prefixes on domain names in URLs. (check-in: 20acd630b9 user: drh tags: trunk)
2025-04-09
13:32
Doc updates in proj.tcl. Improve configure check for whether fdatasync or nanosleep require -lrt. Remove references to 'tcl-config' build mode from sqlite-config.tcl, as that build is now implemented without a depency on sqlite-config.tcl because the TEA build's needs are considerably more modest. (check-in: 394bef5441 user: stephan tags: trunk)
2025-04-08
20:00
Remove an incorrect ALWAYS() macro. Forum post 2025-04-08T19:16:42Z. (check-in: 062cca9c63 user: drh tags: trunk)
17:18
Have sqlite3session_diff() automatically attach tables to session objects, as it has always been documented to do. (check-in: 99827144f1 user: dan tags: trunk)
15:58
Have sqlite3session_diff() automatically attach tables to session objects, as it has always been documented to do. (Closed-Leaf check-in: ec1641858e user: dan tags: sessions-diff-autoattach)
2025-04-07
18:29
During the post-configure validation of @VAR@ references, ignore commented-out references in files which seem (based on their name) to be makefiles, as it's sometimes handy to comment-out such vars during development of a configure script and its corresponding makefile(s). (check-in: 25d936b7b2 user: stephan tags: trunk)
02:16
Rename proj-current-proc-name to proj-current-scope and have it distinguish between global scope and an invalid scope level. (check-in: 1c7e5b6cab user: stephan tags: trunk)
02:08
Make it legal to call proj-fatal from the global scope. (check-in: f1cf373b73 user: stephan tags: trunk)
2025-04-06
10:22
Fix a harmless code typo introduced by [b57e3c3db00a6bc6] and reported by forum post 09957d8b2a. (check-in: f3a6cdb89b user: drh tags: trunk)
2025-04-05
11:23
Add default --manpath for Haiku but that path is read-only on my Haiku system, so shelve this. (Edit: this was supposed to have been (fossil stash save -m ...) instead of (fossil ci -m ...).) (Closed-Leaf check-in: e2d9ba6f76 user: stephan tags: haiku-configure-tweaks)
09:17
Extend proj-dot-ins-append to provide a way to use it for the special-case emcc.sh.in handling. (check-in: 0e98bbddc7 user: stephan tags: trunk)
08:48
Add a note that SQLite's copy of proj.tcl can be considered the "canonical copy" for practical purposes. We now have at least 3 copies of it floating around in other trees. (check-in: 77d2c8e9ef user: stephan tags: trunk)
07:12
Move the automatic reconfigure tcl code from sqlite-config.tcl to proj.tcl so that the TEA bits can reuse it. (check-in: 52839db2fc user: stephan tags: trunk)
02:59
Refactor proj-make-from-dot-in and friends to be more useful and remove some annoying limitations. (check-in: 501ff84e12 user: stephan tags: trunk)
2025-04-04
23:12
Rename makefile var libtclsqlite3.SO to libtclsqlite3.DLL for consistency. (check-in: 6fb364c853 user: stephan tags: trunk)
22:59
Correct a makefile var name type in the configure script, introduced in [4947c1c782]. (check-in: 84d77c5fe8 user: stephan tags: trunk)
22:58
Correct a makefile var name type in the configure script, introduced in [8830f86335]. (Leaf check-in: fa29e6a3b7 user: stephan tags: branch-3.49)
22:14
Add more vars to the tclConfig.sh-to-tcl exporter, for use in the TEA build. (check-in: b0e1e49c7a user: stephan tags: trunk)
21:11
Improve --all flag handling so that combinations of (--all --disable-FEATURE) and (--disable-all --FEATURE) work more intuitively. Add missing handling of the --fts3 flag (it was accepted but ignored before). Partial merge of [26ef0ff4bfbb], minus proj.tcl changes. (check-in: 5db613dd40 user: stephan tags: branch-3.49)
20:58
Account for the Mac-specific -install_name linker flag. See forum post 5651662b8875ec0a. (check-in: 8830f86335 user: stephan tags: branch-3.49)
20:50
Account for the Mac-specific -install_name linker flag. See forum post 5651662b8875ec0a. (check-in: 4947c1c782 user: stephan tags: trunk)
16:17
Adapt the --all flag to apply to a different set of features, and default to enabled, for the tcl-extension build. (check-in: b229c8f65a user: stephan tags: trunk)
15:41
Improve --all flag handling so that combinations of (--all --disable-FEATURE) and (--disable-all --FEATURE) work more intuitively. Add missing handling of the --fts3 flag (it was accepted but ignored before). Add TCL_LIBS to the set of vars exported via tclConfig.sh for use in the tea build. (check-in: 26ef0ff4bf user: stephan tags: trunk)
13:25
Merge trunk (Leaf check-in: 436a01e1b1 user: jan.nijtmans tags: cygwin-fixes)
13:23
The win32lock and win32longpath tests don't work on Cygwin (check-in: 32ef3f26e7 user: jan.nijtmans tags: trunk)
13:08
Minor configure-internal cleanups to support the autosetup port of the TEA build. (check-in: 244c2b75c1 user: stephan tags: trunk)
06:49
Merge trunk (check-in: 79dfaf05b8 user: jan.nijtmans tags: cygwin-fixes)
06:47
win32longpath makes no sense on Cygwin. All tests pass now (except delete_db-1.3.0) (check-in: 5cf5d2cedf user: jan.nijtmans tags: cygwin-fixes)
03:26
Minor configure script internal doc edits. No functional changes. (check-in: 357563bc7c user: stephan tags: trunk)
03:16
Make the --static-cli-shell flag available in the autoconf build mode. (check-in: b78a474ecb user: stephan tags: trunk)
02:40
On HaikuOS, if --prefix is not explicitly provided then default it to /boot/home/config/non-packaged, based on an off-list discussion with HaikuOS user BrickViking. (check-in: c4a5582911 user: stephan tags: trunk)
2025-04-03
13:24
Add the --static-cli-shell configure flag to the canonical build, which works like --static-tclsqlite3 but applies to the CLI shell (statically linking it, which only works if all requisite libs are available in static form). It is not called --static-shell because that flag has a completely different legacy meaning in the autoconf build and this flight might eventually be added to that build, so would collide there. (check-in: fd2c1638ec user: stephan tags: trunk)
00:46
Add the --static-tclsqlite3 configure flag (canonical build only) to build tclsqlite3 as a static binary. This will only work on systems which have static versions of all requisite libraries. (check-in: 6183632436 user: stephan tags: trunk)
00:40
Minor cleanups to the --static-tclsqlite3 support. (Closed-Leaf check-in: 06f1143870 user: stephan tags: static-tclsqlite3)
2025-04-02
23:34
Add experimental --static-tclsqlite3 configure flag to build tclsqlite3 statically, which only works if static libtcl/etc. are available. Currently intended for docker builds via Alpine Linux. (check-in: bef3c8b1b9 user: stephan tags: static-tclsqlite3)
12:41
Fix harmless compiler warnings in the memstat.c extension. No changes to the core. (check-in: 9e903953ba user: drh tags: trunk)
11:21
Remove some stray debug output from proj.tcl. (check-in: 5fc7150a20 user: stephan tags: trunk)
10:42
Increase the size of a variable in FTS3 to help static analyzers see that there are no integer overflow problems. (check-in: a921a4682f user: drh tags: trunk)
2025-04-01
16:32
The json-blob-overwrite optimization seeks to prevent unnecessary I/O and data movement when making small changes to the middle of a large JSONB. (check-in: 4a3d7b0421 user: drh tags: trunk)
16:26
Fix a typo accidently added to the prior check-in. (Closed-Leaf check-in: fb2f283038 user: drh tags: json-opt)
15:17
This is an experimental optimization that attempts to keep a JSONB value the same size (same number of bytes) after doing a replace of an elements with a slightly smaller element, by denormalizing the size field. This can perhaps avoid unnecessary page updates and memmove() operations when making small changes in the middle of a large JSONB value. (check-in: b5de9584b7 user: drh tags: json-opt)
2025-03-31
23:18
Fix a harmless typo in a code comment. (check-in: dd251377bd user: drh tags: trunk)
14:12
Feature-complete. Not all test-cases pass. Merge trunk. (check-in: 6552bfb70a user: jan.nijtmans tags: cygwin-fixes)
13:08
Ensure that the compilation of extensions get the same CFLAGS as the core lib. Move the feature flags enabled by --dev out of TARGET_DEBUG and into OPT_FEATURE_FLAGS (for consistency). Rename the make-internal gcov-related flags to be more descriptive. At the end of the configure script, if SQLITE_DEBUG is active then emit a note reminding the builder that performance will suffer. (check-in: e64c6a3856 user: stephan tags: trunk)
11:24
Add the ?ENCODING? parameter to the "db copy" command. If used, it will translate from the given encoding to UTF-8 (Leaf check-in: ac27c2f816 user: jan.nijtmans tags: db-copy-encoding)
10:54
Ensure that extension sources also inherit the debugging-related flags from --debug or --dev. (check-in: 3e96b772a4 user: stephan tags: trunk)
10:29
Correct the ordering of the configure script's handling of the --dev and --debug flags so that --dev's forcing of --debug get picked up early enough. (check-in: e48189ed33 user: stephan tags: trunk)
09:53
The --dev option on ./configure implies --debug and adds -DSQLITE_DEBUG. (check-in: 67dbd9ff0f user: drh tags: trunk)
2025-03-30
09:08
Update tcl.m4 as well (Leaf check-in: 97af9fd79e user: jan.nijtmans tags: tea-update)
2025-03-29
11:50
Minor shell-internal doc addition. No functional changes. (check-in: 01b99c8a28 user: stephan tags: trunk)
2025-03-28
16:31
Correct two tests in shell1.test which were broken by the addition of new output in [0f11087b8475]. (check-in: 909dd0a02a user: stephan tags: trunk)
15:36
CLI shell: make (.output off) an alias for (.output /dev/null) or (.output nul), depending on the platform. Discussed in forum post 633979ce307f1cc6. (check-in: 0f11087b84 user: stephan tags: trunk)
14:32
Configure/make doc tweaks. No functional changes. (check-in: dbcc03bd7a user: stephan tags: trunk)
12:43
Update all TEA files to the latest version. All *.vc files should use Windows CRLF (check-in: aa8dc559cc user: jan.nijtmans tags: tea-update)
08:59
Second round of cygwin fixes: this makes the full "unix" vfs usable with Cygwin as well. Not all tests are working yet. WIP! (check-in: 648aca5b47 user: jan.nijtmans tags: cygwin-fixes)
07:09
Merge trunk (check-in: 6a449918c2 user: jan.nijtmans tags: cygwin-fixes)
2025-03-27
23:29
Merge cygwin and tclsqlite fixes into trunk. (check-in: 121f4d97f9 user: drh tags: trunk)
18:42
Add an explicit db close to fix a file-is-opened failure in session1.test in cygwin. (check-in: c6e4e1cf2b user: stephan tags: cygwin-fixes)
18:22
Rearrange #includes in FTS3 to avoid a harmless compiler warning. (check-in: c5206cee83 user: drh tags: trunk)
17:30
Fix for forum-post b5fde3596c. Also fix encoding issue for non-ASCII characters. Also includes a fix from Stephan Beal, about a missing <stdint.h> include. (Closed-Leaf check-in: e60198001e user: jan.nijtmans tags: tclsqlite-db-copy-fix)
17:25
shell1.test: == => eq (check-in: 99fdd19193 user: jan.nijtmans tags: cygwin-fixes)
14:37
More ==/!= => eq/ne fixes (check-in: 2aa6c4fa6c user: jan.nijtmans tags: cygwin-fixes)
14:32
In Tcl, always use eq/ne for comparing strings, not ==/!= (check-in: f96a5346e3 user: jan.nijtmans tags: cygwin-fixes)
14:13
Merge trunk. Some additional test-fixes for Cygwin (check-in: b36adadfa2 user: jan.nijtmans tags: cygwin-fixes)
10:59
Fix an off-by-one bug in the ".dbtotxt" command from the shell that results in incorrect output. (check-in: 2345094e87 user: drh tags: trunk)
2025-03-26
22:23
Reduce the delay caused by anti-virus retries in Windows when attempting to open a database file with insufficient permission. (check-in: d25c8a6222 user: drh tags: trunk)
17:05
On winOpen(), redo the read-only test on every retry attempt. Just don't retry the winAccess() call. (Closed-Leaf check-in: ccdd67ad9a user: drh tags: winopen-retry)
15:51
Further attempted improvements at fast-fail for an inaccessible database file. (check-in: cdeb21a312 user: drh tags: winopen-retry)
14:45
Attempt to reduce the amount of retry time when trying to open an inaccessible database file on Windows. See forum thread e7991420f5 (check-in: 986e45912c user: drh tags: winopen-retry)