Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
535 check-ins using file doc/tcl-extension-testing.md version 864875c3
|
2025-03-19
| ||
| 11:53 | Avoid running test cases involving ANSI control characters or Unicode on Windows in a slave interpreter, as that combination does not work. (Leaf check-in: c7fd71c7 user: stephan tags: trunk) | |
| 10:14 | Merge trunk into the cygwin-fixes branch. (Leaf check-in: 34eadd37 user: stephan tags: cygwin-fixes) | |
|
2025-03-18
| ||
| 20:28 | Fix two obscure logic problems that cause incorrect answers, found by a third-party fuzzer. (Leaf check-in: 1a8f763c user: drh tags: branch-3.49) | |
| 20:15 | Change the generate_series() table-valued function so that its rowid is just an alias for its value. This allows it to be used as the RHS operand of a RIGHT JOIN. This fixes the issue raised by forum post 1e17219c88. (check-in: 77db4d85 user: drh tags: trunk) | |
| 19:21 | Fix a problem that could occur when the RHS of an IN operator was a compound SELECT featuring an ORDER BY on a subquery that was flattened into one of the component SELECTs introduced by [baa83b460c677c21]. Forum post /forumpost/1e17219c88. (check-in: 7101ccd5 user: dan tags: trunk) | |
| 13:52 | Internal doc touchups in ext/wasm/mkwasmbuilds.c. No functional changes. (check-in: 47d34260 user: stephan tags: trunk) | |
| 12:42 | Further slight simplification of the run-fuzzcheck rules. (Edit: moving to mistake branch because it having to build the binaries before detecting a missing FUZZDB arg is annoying.) (Leaf check-in: aac59804 user: stephan tags: mistake) | |
| 12:31 | Very slight simplification of the run-fuzzcheck rules. (check-in: c858a39f user: stephan tags: trunk) | |
| 11:36 | General updates to autosetup/README.md. (check-in: be8ad5cf user: stephan tags: trunk) | |
| 10:28 | Update the docs in tool/mkccode.tcl to reflect that it's more generic than it was when the docs were written. Change the shebang line to use /bin/env tclsh instead of a hard-coded tclsh path. (check-in: 9300f7f4 user: stephan tags: trunk) | |
|
2025-03-17
| ||
| 15:13 | Prevent integer overflow when parsing NEAR queries in FTS5. (check-in: 1a5283d7 user: drh tags: trunk) | |
| 14:59 | Add support for the --with-wasi-sdk configure flag to the autoconf build. (check-in: 44880fa3 user: stephan tags: trunk) | |
|
2025-03-16
| ||
| 14:05 | Fix a long-standing filename digest computation bug in the OPFS SAHPool VFS which caused all VFS-stored filenames to have a digest value of 0. See /forumpost/042d53c928382021 for full details. (check-in: 493cbe74 user: stephan tags: trunk) | |
| 13:09 | Add --asan-fsanitize=... configure flag to the canonical build to optionally set -fsantize flags for the fuzzcheck-asan tool. Teach proj-check-fsanitiz to fail for flags which the compiler emits any warning for, for reasons described in its comments. (check-in: 013730e9 user: stephan tags: trunk) | |
| 12:27 | Configure-internal doc cleanups. No functional changes. (check-in: be3a2e63 user: stephan tags: trunk) | |
| 11:24 | Consolidate some much-duplicated run-fuzzcheck recipe code in main.mk. (check-in: c0d9b9fa user: stephan tags: trunk) | |
| 00:13 | Rework the run-fuzzcheck makefile target so that it better exploit parallelism. Test case "make -j16 run-fuzzcheck FUZZDB=20250222.db" went from 596 seconds down to 107 seconds. (check-in: 18bda13e user: drh tags: trunk) | |
|
2025-03-15
| ||
| 23:42 | Enhance the fuzzcheck testing tool with new command-line options: --brief, and --slice M N. (check-in: e6413272 user: drh tags: trunk) | |
| 20:35 | Merge the latest trunk enhancements into the reuse-schema branch. (Leaf check-in: 271e0373 user: drh tags: reuse-schema) | |
| 20:32 | Merge the latest trunk enhancements into the bedrock branch via the wal2 intermediary. (Leaf check-in: b1860b63 user: drh tags: bedrock) | |
| 20:28 | Merge the latest trunk enhancements into the wal2 branch. (Leaf check-in: c8d8f613 user: drh tags: wal2) | |
| 20:25 | Merge the latest trunk enhancements into the begin-concurrent branch. (Leaf check-in: 62422549 user: drh tags: begin-concurrent) | |
| 19:55 | Make use of the C99 flexible array feature, when available, so that the -fsanitize=bounds-strict option can be used, when available. Forum thread 311dbf9a1c. (check-in: d4307a0d user: drh tags: trunk) | |
| 19:00 | Work around compilers that do not understand flexible arrays, in the recovery extension and in the fuzzcheck test module. (Closed-Leaf check-in: f101c46c user: drh tags: flex-array) | |
| 18:26 | Fix alignment problems on Linux with -m32 and on Mac PPC. (check-in: 8a91aeca user: drh tags: flex-array) | |
| 16:58 | Speed up parsing of very long fts3 query expressions. (check-in: 2dd5b689 user: dan tags: trunk) | |
| 15:19 | Configure-internal build cleanups (no functional changes). Add EXTRA_SRC to the deps of sqlite3.c. (check-in: 8afb8bbc user: stephan tags: trunk) | |
| 13:50 | -fsanitize is a CFLAG, not LDFLAG, so rename some vars accordingly and simplify the feature check to not run the linker. (check-in: 44f2c64e user: stephan tags: flex-array) | |
| 13:36 | For fuzzcheck-asan, dynamically determine the list of -fsanitize flags to use based on configure-time feature tests. (check-in: b70f9cc8 user: stephan tags: flex-array) | |
| 13:11 | Omit the -fsanitize=bounds-strict for now, as that is still not widely implemented. In particular, it does not work on Macs. (check-in: 3e1c2ac7 user: drh tags: flex-array) | |
| 13:04 | Use flexible arrays in the recovery extension and in the fuzzcheck test program. Adjust the unix makefile to use -fsanitize=bounds-strict when building fuzzcheck-asan. (check-in: 6ea6a6b2 user: drh tags: flex-array) | |
| 12:22 | Use flexible arrays whereever appropriate in FTS5. (check-in: 16dfc415 user: drh tags: flex-array) | |
| 00:11 | Convert the Fts5Sorter.aIdx field to a flexible array. (check-in: 28ac776a user: drh tags: flex-array) | |
|
2025-03-14
| ||
| 23:57 | Turn Fts5Colset.aiCol into a flexible array. (check-in: 0c4d9c74 user: drh tags: flex-array) | |
| 23:20 | In FTS3, rename the MatchinfoBuffer.aMatchinfo field to aMI, to avoid confusing it with MatchInfo.aMatchinfo. Make aMI a flexiable array. (check-in: bb00b973 user: drh tags: flex-array) | |
| 21:15 | Fix one of two flexible arrays in FTS3. (check-in: ddfa87c1 user: drh tags: flex-array) | |
| 20:19 | Use flexible arrays for RTREE. (check-in: 2b417761 user: drh tags: flex-array) | |
| 19:07 | KeyInfo is now an indeterminate size, so we cannot declare a variable of that type, only a pointer to an instance of that type. (check-in: 37b687dc user: drh tags: flex-array) | |
| 18:10 | Make use of the flexible-array feature of C99, when available, to try to pacify -fsanitize=strict-bounds. This check-in fixes the core. There is more yet to do in FTS3, RTREE, and in FTS5. (check-in: 6fd6b32d user: drh tags: flex-array) | |
| 12:37 | Fix an internal doc typo reported in forum post e25e581f917. (check-in: fa6f6ccd user: stephan tags: trunk) | |
| 11:14 | Minor doc corrections for the sahpool-digest fix and merge in current trunk. (Closed-Leaf check-in: 500f2e6e user: stephan tags: sahpool-digest) | |
| 09:34 | Cherrypick the [2b582c0097e33] doc addition, which was initially committed to the wrong branch. (check-in: f786de8d user: stephan tags: trunk) | |
|
2025-03-13
| ||
| 18:51 | Fix the generate_series extension for the case where the termination value is not an even multiple of the step from the start value and there is also a value=NNN constraint in the WHERE clause. Forum post bf2dc8e9 (check-in: 75e72e3b user: drh tags: trunk) | |
|
2025-03-12
| ||
| 15:17 | The --echo flag on the CLI also echos dot-commands provided on the command-line. (check-in: 6ec0c03b user: drh tags: trunk) | |
| 11:41 | Document that sqlite_update_hook() can unset the current hook by passing a NULL callback, to address forum post 652aef4747. (check-in: 2b582c00 user: stephan tags: cygwin-fixes) | |
|
2025-03-11
| ||
| 15:46 | Avoid running test cases involving ANSI control characters or Unicode on Windows in a slave interpreter, as that combination does not work. (Closed-Leaf check-in: f6745a73 user: drh tags: windows-ansi) | |
| 12:19 | The substitute "puts" command used by the Windows implementation of sqlite3_analyzer must invoke fflush() after each line of output. Otherwise the output can be truncated when redirected into a file. (check-in: ba058ce9 user: drh tags: trunk) | |
| 11:24 | Teach testrunner.tcl to distinguish Cygwin from Windows. This gets it running but then all downstream tests fail, at least in part because of the build target name discrepancies between the platform which requires .exe and those which do not. (check-in: 2861788e user: stephan tags: cygwin-fixes) | |
|
2025-03-10
| ||
| 22:31 | Ensure that the TEMP database has been initialized at the beginning of a call to sqlite3_open_blob() for the TEMP database. Fix for the issue reported by forum post 0a556d619b. (check-in: 2cfccdbe user: drh tags: trunk) | |
| 17:35 | Merge trunk into the cygwin-fixes branch. (check-in: f3d14433 user: stephan tags: cygwin-fixes) | |
| 17:28 | Add an explicit db close to test/walsetlk.test to work around an unjustified test failure on Windows when the walsetlk tests are run in the same invocation of testfixture.exe in Windows. (check-in: f418de10 user: stephan tags: trunk) | |
| 15:35 | Patch an unnecessary size_t-to-int conversion which warns on some compilers. (check-in: 8681dfdb user: stephan tags: cygwin-fixes) | |
| 15:27 | Ensure that the 'clean' target for Makefile.msc cleans up the testdir dir, analog to how the canonical makefile works, as stale files there have been leading to test failures. (check-in: a591c018 user: stephan tags: cygwin-fixes) | |
| 15:15 | Reimplement pathname conversion on Cygwin. MSC test passes/failures are on par with trunk and 'make test' running on cygwin is down to a single failure. (check-in: 57a4de09 user: stephan tags: cygwin-fixes) | |
| 14:10 | Tweak [6f24da264cf8d] so that it has no side-effects on autoconf/Makefile.msc. (check-in: d3d322f1 user: stephan tags: cygwin-fixes) | |
| 10:39 | Disable the [d1ba200234f40b84|count-of-view optimization] if any subquery is DISTINCT, as the optimization does not work in that case. (check-in: bae270b9 user: drh tags: branch-3.49) | |
| 10:36 | Fix the build by rerunning test/mkpragmatab.tcl. (check-in: 167d6314 user: drh tags: branch-3.49) | |
| 10:32 | Disable the [d1ba200234f40b84|count-of-view optimization] if any subquery is DISTINCT, as the optimization does not work in that case. Bug reported by forum post a860f5fb2e. (check-in: d7013b63 user: drh tags: trunk) | |
| 09:54 | Add tf.bat target to Makefile.msc to facilitate running of individual test scripts via testfixture.exe. (check-in: 6f24da26 user: stephan tags: cygwin-fixes) | |
|
2025-03-08
| ||
| 06:53 | Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk. (check-in: 84d8fcfc user: stephan tags: cygwin-fixes) | |
|
2025-03-07
| ||
| 06:54 | os_win.c patches for Cygwin (described in the cygwin-fixes branch wiki page). Makefile.msc's test target on trunk fails the same 13 tests as this branch. (check-in: 655c60d1 user: stephan tags: cygwin-fixes) | |
|
2025-03-06
| ||
| 14:40 | Merge trunk into the cygwin-fixes branch (which was inadvertently branched too early). (check-in: a7863b2e user: stephan tags: cygwin-fixes) | |
| 13:49 | Cygwin-centric test script tweaks from Jan Nijtmans. (check-in: 9868615b user: stephan tags: cygwin-fixes) | |
| 13:38 | Cygwin-centric fixes from Jan Nijtmans. (check-in: 20597981 user: stephan tags: cygwin-fixes) | |
| 09:29 | Back out the most significant part of [5c28a17253e2f], as Cygwin is a hybrid. With SQLITE_OS_UNIX it will use POSIX locking, which will misinteract with apps using Windows-style locking. (check-in: 44adf8f3 user: stephan tags: trunk) | |
| 09:08 | Various typo fixes reported by Daniel Dumitriu. No functional changes. (check-in: 37e6ec77 user: stephan tags: trunk) | |
| 07:48 | Additional 'array index is signed char' warning cleanups for the shell and its embedded extensions, analog to [44bd44532d]. (check-in: f3104259 user: stephan tags: trunk) | |
| 07:09 | Fix a tcl typo in the previous checkin which triggers an error on one machine but not another. (check-in: 646c2821 user: stephan tags: trunk) | |
| 06:25 | Have the configure script report cygwin as SQLITE_OS_UNIX instead of SQLITE_OS_WIN, per off-list discussion with Jan Nijtmans. (check-in: 5c28a172 user: stephan tags: trunk) | |
|
2025-03-05
| ||
| 19:39 | Have the recover module add "PRAGMA foreign_keys = off" to SQL output. Have the shell tool add ".dbconfig defensive off". (check-in: dcfe3d32 user: dan tags: trunk) | |
| 18:18 | Always ignore comments in the schema of a database, even if SQLITE_DBCONFIG_ENABLE_COMMENTS is turned off. (check-in: 373ae3f4 user: drh tags: trunk) | |
| 17:26 | Update the recovery extension so that it works with encrypted databases. (check-in: b0b66f21 user: dan tags: trunk) | |
| 17:12 | Use AtomicRead() and AtomicWrite() to access the pcache1_g.bUnderPressure global, to forestall unnecessary angst from thread analyzers. (check-in: 41ec8563 user: drh tags: trunk) | |
| 16:35 | Improvement output for ".schema --indent" in the CLI when the schema contains partial indexes with long and complicated WHERE clauses. (check-in: defd7187 user: drh tags: trunk) | |
| 16:30 | Improvement output for ".schema --indent" in the CLI when the schema contains partial indexes with long and complicated WHERE clauses. (Leaf check-in: 94c6e8d9 user: drh tags: wrong-branch) | |
| 13:39 | Update Lemon so that it accepts filename arguments to directives like "%include". Ex: "%include <./subdir/file-to-include.txt>". This was capability needed by pikchr and backported here for safe keeping. SQLite does not need this capability, though it doesn't hurt to have it in tree. (check-in: 52b97a7a user: drh tags: reuse-schema) | |
|
2025-03-04
| ||
| 21:37 | Minor configure script cleanups which started out as cygwin-specific fixes but ended up just being minor platform-agnostic cleanups. (check-in: 2cda9041 user: stephan tags: trunk) | |
| 21:31 | Roll back part of [6d87a8efe]: the check for tclsh90.exe (as opposed to tclsh9.0.exe) is incorrect on these platforms (it's an msvc build). Also remove an unused function added in that checkin. (Closed-Leaf check-in: dc84976a user: stephan tags: cygwin-fixes) | |
| 21:25 | tclsqlite3 patch from Christian Werner: replace FILE handles with TCL channels for the db copy command. (check-in: ea1f7f8d user: stephan tags: trunk) | |
| 19:38 | Teach autosetup how to find tclsh v9.0 on cygwin. (check-in: 6d87a8ef user: stephan tags: cygwin-fixes) | |
| 17:06 | Fix pointless comparison of an unsigned integer to less than zero in Lemon. (check-in: 559560da user: drh tags: reuse-schema) | |
| 07:29 | Makefile doc updates. Remove a couple extraneous targets. No functional changes. (check-in: 5a3e2299 user: stephan tags: trunk) | |
| 06:29 | Minor doc typo fixes via forum post 65bd941da8. (check-in: 6f6a03e9 user: stephan tags: trunk) | |
| 05:16 | Document the EXTRA_SRC makefile var and add --amalgamation-extra-src=list to the canonical-build configure script as the formal way to pass that at configure-time. (check-in: 44de0ec2 user: stephan tags: trunk) | |
|
2025-03-03
| ||
| 16:53 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: b51690e1 user: drh tags: reuse-schema) | |
| 16:01 | Merge the latest trunk enhancements into the bedrock branch through the wal2 intermediary. (check-in: 20337630 user: drh tags: bedrock) | |
| 15:57 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 6baea938 user: drh tags: wal2) | |
| 15:53 | Merge all the latest trunk enhancements into the begin-concurrent branch. (check-in: 051a6b15 user: drh tags: begin-concurrent) | |
| 14:15 | Internal configure script cleanups. Resolve an as-yet-hypothetical corner case involving the --dev flag mixed with custom CFLAGS containing SQLITE_ENABLE... or SQLITE_OMIT... flags. Fix an unrelated API doc typo reported in forum post 606ea661df. (check-in: 0554c00f user: stephan tags: trunk) | |
| 11:48 | Minor configure script doc tweaks. This is also a note that the basic elements of the build run as-is on Haiku OS Beta 5 but the tcl bits do not (for lack of tclConfig.sh). (check-in: acf9babf user: stephan tags: trunk) | |
|
2025-03-02
| ||
| 20:29 | Ensure that detection of control characters by comparison against 0x1f uses unsigned characters. Forum post 4c344ca61f. (check-in: b7c5ce84 user: drh tags: trunk) | |
|
2025-03-01
| ||
| 23:44 | Use SQLITE_EXTRA_INIT_MUTEXED instead of SQLITE_EXTRA_INIT for the SQLITE_WASM_EXTRA_INIT feature, as suggested in forum post 14183b98fc0b1dea. This doesn't make a functional difference now - this is in the name of future-proofing against eventual threading support in wasm. (check-in: 46479c2e user: stephan tags: trunk) | |
| 11:47 | Add an assert() in vdbesort.c to help both humans and static analyzer AIs understand why a particular array cannot overflow. (check-in: a14d4afd user: drh tags: trunk) | |
|
2025-02-28
| ||
| 15:54 | In the CLI, ensure that all calls to ctype.h macros are cast to unsigned char. Apparently cygwin needs this. (check-in: 44bd4453 user: drh tags: trunk) | |
| 05:01 | Bring the autosetup-related bits up to par with trunk. (check-in: 47fe1c59 user: stephan tags: branch-3.49) | |
| 04:58 | Latest upstream autosetup. Fixes two minor corner-case issues which we haven't yet seen in practice. (check-in: 5c2438a7 user: stephan tags: trunk) | |
| 01:06 | Strive to make sorts stable in the mkpragmatab.tcl build script, so that we get consistent amalgamations regardless of platform. Forum thread c9914addebf3da51. (check-in: 8b5996f4 user: stephan tags: branch-3.49) | |
|
2025-02-27
| ||
| 21:17 | Approximately 100 typo corrections spanning the whole tree, submitted via forum post 0db9827f0464bc33 and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. (check-in: f50c2148 user: stephan tags: trunk) | |
| 19:40 | Reimplement testrunner_data.tcl::trd_get_bin_name() to assume a .exe extension on all platforms not matching "unix", to avoid having to do file-exists checks. (check-in: ce551910 user: stephan tags: trunk) | |
| 16:07 | Strive to make sorts stable in the mkpragmatab.tcl build script, so that we get consistent amalgamations regardless of platform. Forum thread c9914addebf3da51. (check-in: 3f575847 user: drh tags: trunk) | |
| 15:55 | Merge back a sequence of three changes that were branched due to a build break. (check-in: 67809715 user: drh tags: trunk) | |
| 15:52 | Fix build break in [e2bd23f251359e7a]. (Closed-Leaf check-in: 6ed84211 user: drh tags: build-break) | |
| 11:03 | Add support for SQLITE_EXTRA_INIT_MUTEXED - like SQLITE_EXTRA_INIT, but is called from within sqlite3_initialize() when the SQLITE_MUTEX_STATIC_MAIN mutex is still held. (check-in: 3cf88d42 user: dan tags: build-break) | |
| 03:23 | Internal doc typo fixes reported in forum post 01d15f21b6. (check-in: d6514c20 user: stephan tags: build-break) | |
|
2025-02-26
| ||
| 19:22 |
(Edit: Moved to a branch because this breaks "./configure && make devtest")
Teach testrunner how to run local binaries which have a .exe extension. Also teach it to recognized mingw environments (but actually building the test programs there currently doesn't work). (check-in: e2bd23f2 user: stephan tags: build-break) | |
| 18:31 | Teach testrunner.tcl to identify an msys environment. (check-in: e9f777ce user: stephan tags: trunk) | |
| 17:11 | Undo part of [69e83ab859c], as that order of operations breaks the --prefix=... configure flag. Found a workaround for the library version and OS/environment info being emitted when --help. (check-in: cd2a84a7 user: stephan tags: trunk) | |
| 16:15 | configure: extend the readline detection a bit so that it can find readline on termux environments without having to be told where it is. Fix a typo in a libedit-related message. (check-in: 52f528c4 user: stephan tags: trunk) | |
| 09:14 | Shift some bootstrapping configure bits to avoid emitting extra output if --help is specified. (check-in: 69e83ab8 user: stephan tags: trunk) | |
| 03:32 | Merge trunk into the sahpool-digest branch. (check-in: fc1eeb7d user: stephan tags: sahpool-digest) | |
| 03:20 | Fix a bug in mkwasmbuilds.c, introduced in [e4539ebebd89], which caused sqlite3.wasm to get deleted directly after it was built. (check-in: 1a72d1d1 user: stephan tags: trunk) | |
| 03:03 | More work on the sahpool digest fix. New/fixed versions can read legacy (no digest) files but the reverse is only possible in limited circumstances (when files originated from a legacy version). The burning question is whether the real fix would be to remove this digest check altogether, as it only applies in a very limited context, and the fact that it was broken for some 18 months unnoticed suggests that its value might not be worth the CPU cycles. (check-in: 0df62b77 user: stephan tags: sahpool-digest) | |
|
2025-02-25
| ||
| 21:16 | Disable some misuse tests that sometimes cause segfaults during "make releasetest". (check-in: 5856251a user: drh tags: trunk) | |
| 20:55 | Approximately 50 typo fixes, spanning the whole tree, contributed via forum post 006c8fa165083ac3 and individually checked for correctness. Affects only code comments, docs, and a single line of debug output in a test app. (check-in: af928818 user: stephan tags: trunk) | |
| 20:36 | Fix a test case that was broken when the default --escape type was changed by the previous check-in. (check-in: 5f2531e0 user: drh tags: trunk) | |
| 20:10 | Change the default control-character escape algorithm from "symbol" to "ascii", since the "ascii" algorithm works even on terminals that do not support unicode. (check-in: d3532049 user: drh tags: trunk) | |
| 20:02 | Fix harmless "unused parameter" compiler warnings. (check-in: 7a68a3ea user: drh tags: trunk) | |
| 18:10 | Improved help messages for the --escape option in the CLI. (check-in: e6784af6 user: drh tags: trunk) | |
| 16:48 | Configure script cosmetics: emit the host/build system info before the directory info. (check-in: 9d5b97dd user: stephan tags: branch-3.49) | |
| 16:39 | Configure script cosmetics: emit the host/build system info before the directory info. (Edit: this mysteriously broke the --prefix=... flag again) (Edit - no, it didn't - it was a test methodology failure.) (check-in: 6f0b6d95 user: stephan tags: trunk) | |
| 16:17 | Diverse configure tweaks to better support package maintainers on the unix-on-windows environments like msys2, cygwin, and mingw, based largely on feedback in forum posts e6cf2bbb70da2922 and 828fdfe9041fd725. (check-in: 144aacfd user: stephan tags: branch-3.49) | |
| 16:11 | Restructure [826bad10e9ccd6f71e] as that structure mysteriously breaks the --prefix=... configure flag. (check-in: d284230f user: stephan tags: trunk) | |
| 15:57 | Enhancements to help avoid problems in the CLI when trying display content that contains ANSI escape codes: (1) Add the --escape MODE option to the CLI where MODE is one of "symbol", "ascii", "off" where the default is "symbol". (2) Add the unistr() SQL function. (3) Add the unistr_quote() SQL function. (4) Add the %#Q and %#q conversions in the built-in printf. (check-in: e3e509ae user: drh tags: trunk) | |
| 15:54 | Diverse configure tweaks to better support package maintainers on the unix-on-windows environments like msys2, cygwin, and mingw, based largely on feedback in forum posts e6cf2bbb70da2922 and 828fdfe9041fd725. (check-in: 85b56fb0 user: stephan tags: trunk) | |
| 15:27 | Reinstate the assert() removed by [0f6223b8]. Avoid holding a wal-mode write lock after the transaction has been rolled back if an IO error occurs while restarting the wal file. (check-in: 277e150d user: dan tags: trunk) | |
| 13:33 | Fix a test script problem causing errors with Tcl 9. (check-in: dbec2c47 user: dan tags: trunk) | |
| 12:18 | Small performance improvement for the new %#Q conversion in printf. (Closed-Leaf check-in: 17e44078 user: drh tags: unistr) | |
| 12:11 | Update the autoconf Makefile for nmake to support SETLK_TIMEOUT. (check-in: 46909fe3 user: drh tags: trunk) | |
| 11:48 | Avoid running certain tests in walsetlk2.test if SQLITE_ENABLE_SETLK_TIMEOUT is set to 2, not 1. (check-in: 86788c08 user: dan tags: trunk) | |
| 11:47 | Consolidate two different UTF8 encoders into a single subroutine. (check-in: 6208e494 user: drh tags: unistr) | |
| 11:29 | Remove an assert() added by [e88212b1] that is sometimes false. (check-in: 0f6223b8 user: dan tags: trunk) | |
|
2025-02-24
| ||
| 23:34 | Fix the new shellA.test test script so that it works with Valgrind. (check-in: c3949852 user: drh tags: unistr) | |
| 21:27 | Support SQLITE_ENABLE_SETLK_TIMEOUT on windows. (check-in: e88212b1 user: dan tags: trunk) | |
| 20:53 | Slightly simplify auto.def and autoconf/auto.def. (Closed-Leaf check-in: d84f591b user: stephan tags: configure-dll-support) | |
| 20:13 | Use an assert() to fix a harmless (false-positive) scan-build warning in the CLI. (check-in: 4c56cd73 user: drh tags: unistr) | |
| 18:45 | autoconf/auto.def: remove a define which made superfluous by [b8bf966628c0]. Add a check/status message for whether to statically link the library into the CLI shell. (check-in: df95e908 user: stephan tags: configure-dll-support) | |
| 18:14 | configure: in autoconf build if both --disable-shared and --disable-static-shell are used together, ignore the former and emit a notice to that effect. (check-in: b8bf9666 user: stephan tags: configure-dll-support) | |
| 17:50 | Only use unistr() in columnar formats when strictly needed. Do not use unistr() in insert mode when --escape is off. More test cases. (check-in: e029828d user: drh tags: unistr) | |
| 13:51 | Add the unistr_quote() function that works like quote(), but also escape control characters using unistr() if necessary. (check-in: e99e37b5 user: drh tags: unistr) | |
| 13:27 | Bug fix and initial test-case infrastructure for control-character escaping in the CLI. (check-in: c8099977 user: drh tags: unistr) | |
| 12:41 | Ongoing work to get all the quoting and escaping variations in the CLI working correctly. (check-in: b77aea93 user: drh tags: unistr) | |
| 12:19 | Configure doc tweaks. Move the package version/build dir output so that it does not appear at the start of --help text, but otherwise still appears before the first output from low-level config initialization. (check-in: 826bad10 user: stephan tags: configure-dll-support) | |
| 11:21 | Further consolidation of auto.def and autoconf/auto.def. Note in configure --help that --disable-largefile is a legacy option which has no effect on the library but may influence the generated sqlite_cfg.h. (check-in: 17fd6836 user: stephan tags: configure-dll-support) | |
| 10:52 | Merge latest changes from trunk into this branch. (Closed-Leaf check-in: 55324d1c user: dan tags: win32-enable-setlk) | |
| 10:30 | Move the configure output about the SQLite version and build dirs up, so that they appear before any tests for the C compiler and such. (check-in: 83e0f3d1 user: stephan tags: configure-dll-support) | |
| 08:42 | Further consolidation of the main auto.def and the autoconf auto.def content into sqlite-config.tcl. (check-in: 76a4efa9 user: stephan tags: configure-dll-support) | |
| 07:06 | Configure-internal doc tweaks. Fix the distclean rules for libsqlite3.dll.a on msys/cygwin/mingw, broken when the DLL basename was changed for those platforms. (check-in: 8641e2c7 user: stephan tags: configure-dll-support) | |
| 05:10 | Add some internal notes about potential changes for the rpath flag handling. (check-in: 6f904f06 user: stephan tags: configure-dll-support) | |
| 04:47 | Update jimsh0.c from upstream autosetup to address autosetup ticket #75, triggered by this build in the Gentoo project. (check-in: ffd05de8 user: stephan tags: configure-dll-support) | |
| 00:40 | Make column output modes in the CLI responsive to the --escape setting. (check-in: 14ff5557 user: drh tags: unistr) | |
| 00:18 | Three different --escape modes: symbol, ascii, off. (check-in: b5adb52f user: drh tags: unistr) | |
|
2025-02-23
| ||
| 20:50 | Further improvements to control-character escapes in the CLI. (check-in: 9c2f974c user: drh tags: unistr) | |
| 20:20 | Work toward VT100-safe output from the CLI by default. (check-in: 44c44620 user: drh tags: unistr) | |
| 17:55 | Add (disabled) infrastructure for disabling use of the rpath linker flag. This is a proactive precautionary measure because how the rpath is used does not match up with what the unix-on-windows environments do with their DLLs. (check-in: 38ba8e83 user: stephan tags: configure-dll-support) | |
| 17:24 | Internal cleanups to how certain linker flags are tested. (check-in: 6743e3e5 user: stephan tags: configure-dll-support) | |
| 15:34 | Internal configure doc cleanups. Apply the [5ecbe7ddc4] unix-on-windows DLL install dir fix to the canonical build. (check-in: 51b9812d user: stephan tags: configure-dll-support) | |
| 11:48 | The %#Q conversion now adds unistr('...') around the converted string if escape characters were inserted. %#w now works just like %w as escape sequences inside of identifiers are not recognized. (check-in: 997391d4 user: drh tags: unistr) | |
| 00:09 | Enhance the %Q, %q, and %w printf conversions so that if the alternate-form flag # is present, they transform backslash and control characters into unistr()-style backslash escape codes. (check-in: ffbfcc2b user: drh tags: unistr) | |
|
2025-02-22
| ||
| 23:18 | Prototype implementation of the unistr() SQL function. (check-in: 7cc302de user: drh tags: unistr) | |
| 17:33 | Update the help text to account for [35b1c32f80b9]. (check-in: f2e7355d user: stephan tags: configure-dll-support) | |
| 17:30 | Replace --dll-basename=none with --dll-basename=default. (check-in: 35b1c32f user: stephan tags: configure-dll-support) | |
| 16:44 | Tamp down various harmless compiler warnings. Use "int" in places instead of "u16" or "i16" since the compiler complains less and generates faster code. (check-in: 742827f0 user: drh tags: trunk) | |
| 16:31 | On unix-on-windows platforms, if either of --out-implib or --dll-basename are not provided, auto-enable them. Add the 'none' special value to those flags to specifically disable the environment-specific handling of those flags. (check-in: 48640080 user: stephan tags: configure-dll-support) | |
| 14:58 | Ensure that [08c9e56f60] uses an absolute path when appending .exe to mksourceid. (check-in: 906d27f7 user: stephan tags: configure-dll-support) | |
| 14:53 | Random non-functional configure script cleanups. (check-in: 2ee73109 user: stephan tags: configure-dll-support) | |
| 14:53 | tool/mksqlite3h.tcl: when invoking the mksourceid binary, add a .exe to it, if needed, to appease msys2. (check-in: 08c9e56f user: stephan tags: configure-dll-support) | |
| 11:40 | Fix an incorrect assert added by [d7729dbbf231d57c]. (check-in: eeea1127 user: drh tags: trunk) | |
| 00:01 | Fix installation rules for import lib in the autoconf bundle, broken by recent refactoring in this branch. (check-in: 95b71fc7 user: stephan tags: configure-dll-support) | |
|
2025-02-21
| ||
| 23:43 | Rename configure-defined ENABLE_SHARED/STATIC makefile vars to ENABLE_LIB_... so that they're consistent between the canonical and autoconf builds (baby steps towards further configure code consolidation). (check-in: a7647fd0 user: stephan tags: configure-dll-support) | |
| 23:27 | Configure docs/help text tweaks. No functional changes. (check-in: 701cc1af user: stephan tags: configure-dll-support) | |
| 22:46 | Only use the platform-specific --dll-basename if that option is explicitly provided, else use libsqlite3. (check-in: 69bacfdc user: stephan tags: configure-dll-support) | |
| 22:39 | Don't quote dir name in makefile deps, as the quotes are part of the name in that context. (check-in: b0b9e925 user: stephan tags: configure-dll-support) | |
| 22:35 | Ensure that the prefix/bin dir exists on msys/cygwin installations before installing the DLL there. (check-in: 5ecbe7dd user: stephan tags: configure-dll-support) | |
| 21:58 | Add --dll-basename flag to give clients control over the DLL's base name. Split the DLL installation makefile rules into digestible, platform-specific chunks. On Windows-side Unix-like environments, install the DLL into the bin dir. Requires testing and feedback from those platforms' package maintainers to confirm it follows the expectated conventions. (check-in: 8d5fed80 user: stephan tags: configure-dll-support) | |
| 20:35 | The number of declared columns in an index is limited to SQLITE_LIMIT_COLUMN. But the actual number of columns in the implementation might need to be twice as much to account for the primary key at the end. Ensure that the code is able to deal with this. This is a correction to check-in [d7729dbbf231d57c]. (check-in: 5822feec user: drh tags: trunk) | |
| 20:28 | Extend --out-implib to optionally specify the import lib's name. Add as-yet-unused internals for specifying the DLL's base name (which differs across the Windows-side Unix-esque environments). (check-in: 12a55d34 user: stephan tags: configure-dll-support) | |
| 20:22 | Makefile-internal var renaming in prep for pending portability-related changes in the handling of DLLs. No functional/build interface changes. (check-in: ebf41fc9 user: stephan tags: trunk) | |
| 17:03 | Detect when a UNIQUE or PRIMARY KEY on a WITHOUT ROWID table would need to use more than SQLITE_LIMIT_COLUMN columns and raise an error. Also include some unrelated compiler warning fixes. (check-in: d7729dbb user: drh tags: trunk) | |
| 03:22 | configure: in several places where support for -Wl,... linker flags are checked, ensure that the check invokes the linker (not just the compiler) to avoid false positives. This allows us to remove the AIX-specific handling and --disable-rpath bits added in [a15e0f680], as well as make several similar checks more robust. (check-in: 47c43fcb user: stephan tags: branch-3.49) | |
| 03:19 | configure: in several places where support for -Wl,... linker flags are checked, ensure that the check invokes the linker (not just the compiler) to avoid false positives. This allows us to remove the AIX-specific handling and --disable-rpath bits added in [a15e0f680], as well as make several similar checks more robust. (check-in: 4e81e2c7 user: stephan tags: trunk) | |
|
2025-02-20
| ||
| 17:16 | Bump VERSION to 3.49.2. (check-in: eaa2503e user: stephan tags: branch-3.49) | |
| 17:15 | configure: automatically fail the check for rpath on AIX systems and provide a --disable-rpath flag as a fallback for use on platforms which pass the configure-time rpath check but then fail at link-time. Based on discussion in forum thread ae5bd8a84b. (check-in: b6603986 user: stephan tags: branch-3.49) | |
| 17:14 | configure: automatically fail the check for rpath on AIX systems and provide a --disable-rpath flag as a fallback for use on platforms which pass the configure-time rpath check but then fail at link-time. Based on discussion in forum thread ae5bd8a84b. (check-in: a15e0f68 user: stephan tags: trunk) | |
| 16:47 | Fix autoconf bundle to honor the --disable-static and --disable-shared flags, as reported in forum post ae5bd8a84b. Problem introduced in 3.49.0. (check-in: e5ea86dc user: stephan tags: branch-3.49) | |
| 16:45 | Fix autoconf bundle to honor the --disable-static and --disable-shared flags, as reported in forum post ae5bd8a84b. Problem introduced in 3.49.0. (check-in: 56027220 user: stephan tags: trunk) | |
| 12:34 | Experimental prototype for "PRAGMA loadall(TABLE_OR_INDEX)". (Leaf check-in: f24e4d7b user: drh tags: pragma-loadall) | |
| 05:39 | wasm: do not build the (untested/unsupported) node-for-node build by default, to cut build time by about 15%. Adjacent cleanups in mkwasmbuilds.c. (check-in: e4539ebe user: stephan tags: trunk) | |
| 04:45 | wasm makefile docs: make explicit that the node.js-for-node.js builds (as opposed to the node.js-for-browser builds) are both untested and unsupported. (check-in: e1f18488 user: stephan tags: trunk) | |
| 04:14 | Add the pause/unpause capability to the opfs-sahpool VFS, as discussed in forum thread fe8cdb8431c. Summary: this gives clients a way to eke some degree of multi-page/tab/Worker concurrency out of this VFS but requires that coordination to be implemented client-side, e.g. via a SharedWorker or WebLocks. (check-in: b5dbd521 user: stephan tags: trunk) | |
| 03:27 | configure: when running proj-check-function-in-lib, strip -Werror from CFLAGS for the duration of the test. This enables CFLAGS='-Wall -Werror' and the like to be passed to configure without breaking these configure-time checks. (check-in: 4ae9d6c6 user: stephan tags: trunk) | |
|
2025-02-19
| ||
| 13:05 | Increase default CLI shell .prompt buffer length to 128 bytes, based on discussion in forum post 362f185a6aa. (check-in: 628407f0 user: stephan tags: trunk) | |
| 13:02 | Slight tweak to the CLI shell help output to help convey that it can accept multiple SQL arguments, as suggested in forum post 20e617feee. (check-in: 82fc6707 user: stephan tags: trunk) | |
|
2025-02-18
| ||
| 20:27 | Add the SQLITE_MEM5_FAILOVER compile-time option, which if enabled allows MEMSYS5 to go out to the system heap if it is unable to fulfill an allocation request. (Leaf check-in: bdd8617b user: drh tags: mem5-failover) | |
| 15:11 | Have SQLITE_FTS5_ENABLE_TEST_MI builds avoid reading the database schema from within sqlite3_open(). (check-in: 15dc524f user: dan tags: trunk) | |
| 14:56 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: b2bf0630 user: drh tags: reuse-schema) | |
| 14:48 | Merge the latest trunk enhancements into the bedrock branch. (check-in: c09656c6 user: drh tags: bedrock) | |
| 14:38 | Merge all the latest trunk enhancements into the wal2 branch. (check-in: bd465165 user: drh tags: wal2) | |
| 14:37 | Merge all the latest trunk enhancements into the begin-concurrent branch. (check-in: 3c87a6d1 user: drh tags: begin-concurrent) | |
| 13:38 | Version 3.49.1 (check-in: 873d4e27 user: drh tags: release, branch-3.49, version-3.49.1) | |
| 01:16 | Update path on the web server for test/snapshot instances of fiddle. (check-in: 57caa313 user: stephan tags: trunk) | |
|
2025-02-17
| ||
| 20:13 | Add an ORDER BY to a test case for skip-scan to make the output consistent. (check-in: 9c9c1941 user: drh tags: trunk) | |
| 19:44 | Fix problems in test script fkey6.test. (check-in: 088e4765 user: dan tags: trunk) | |
| 19:06 | Fix a typo in a comment in wal.c. (check-in: e0f898f3 user: dan tags: bedrock) | |
| 18:09 | Additional changes making it easier to prove that integer overflow does not occur. No problems found. (check-in: e846743a user: drh tags: trunk) | |
| 17:33 | Code changes that make it easier to prove that no 32-bit integer overflows happen during memory allocation. No problems fixed; this change is just to make future maintenance easier. (check-in: 215650a5 user: drh tags: trunk) | |
| 16:15 | Add two generated files to the distclean rules of the autoconf bundle. (check-in: 57eceb36 user: stephan tags: branch-3.49) | |
| 16:14 | Add two generated files to the distclean rules of the autoconf bundle. (check-in: b59d0ebb user: stephan tags: trunk) | |
| 16:07 | Pull build fix [edb8a78c023] and cleanup [0c085a5ab5] into branch-3.49. (check-in: f10e7ac6 user: stephan tags: branch-3.49) | |
| 16:04 | Replace TEXE (legacy name) with T.exe (3.48+ name) in two places in makefiles. This fixes distclean of jimsh.exe in the canonical build in non-native Windows environments. (check-in: edb8a78c user: stephan tags: trunk) | |
| 14:27 | Harden the SQLITE_DBCONFIG_LOOKASIDE interface against misuse. This is a simplification of [1ec4c308c76c69fb] appropriate for use in a patch release. (check-in: 78c4994c user: drh tags: branch-3.49) | |
| 14:16 | Harden the SQLITE_DBCONFIG_LOOKASIDE interface against misuse, such as described in forum post 48f365daec. Enhancements to the SQLITE_DBCONFIG_LOOKASIDE documentation. Test cases in TH3. (check-in: 1ec4c308 user: drh tags: trunk) | |
| 10:58 | Fix a typo (a missing ")") in a comment that is used to generate documentation. No changes to code. (check-in: ea216856 user: drh tags: trunk) | |
|
2025-02-16
| ||
| 19:16 | Internal reordering/re-grouping of some configure flags. No functional changes. (check-in: 0c085a5a user: stephan tags: trunk) | |
| 18:16 | Re-add the --disable-static-shell configure feature to the autoconf bundle. It got lost in the autoconf-to-autosetup port, as reported in forum post cc219ee7044. (check-in: e9035c6c user: stephan tags: branch-3.49) | |
| 18:14 | Re-add the --disable-static-shell configure feature to the autoconf bundle. It got lost in the autoconf-to-autosetup port, as reported in forum post cc219ee7044. (check-in: 47e817f6 user: stephan tags: trunk) | |
| 13:49 | Update autoconf/Makefile.msc from tool/mkmsvcmin.tcl. (check-in: 9ffe94d2 user: stephan tags: trunk) | |
| 13:13 | API naming typo reported in forum post 416f2d8dec. No functional changes. (check-in: 0cfb9e23 user: stephan tags: trunk) | |
| 11:23 | Add a typecast to avoid 32-bit integer overflow in the concat_ws() function with an enormous separator values and many arguments. (check-in: cf6b162d user: drh tags: branch-3.49) | |
| 11:20 | Remove the autoconf/tea/configure.ac check from tool/srctree-check.tcl since that file no longer exists. (check-in: ff879e8e user: drh tags: branch-3.49) | |
| 10:57 | Add a typecast to avoid 32-bit integer overflow in the concat_ws() function with an enormous separator values and many arguments. (check-in: 498e3f1c user: drh tags: trunk) | |
| 10:50 | Cleanup of the changes for this branch. (Leaf check-in: 9349398e user: drh tags: default-in-values-2) | |
|
2025-02-15
| ||
| 23:47 | Bug fixes in the INSERT logic for VALUES containing DEFAULT terms. (check-in: 2b129c37 user: drh tags: default-in-values-2) | |
| 23:03 | Fixes to the INSERT of DEFAULT in VALUES clauses. Add the ability to UPDATE to DEFAULT. (check-in: 1902a0c1 user: drh tags: default-in-values-2) | |
| 21:53 | Fix the error message text for misuse of the DEFAULT keyword. (check-in: fd1b8683 user: drh tags: default-in-values-2) | |
| 20:31 | An alternative implementation of the default-in-values feature that is cleaner (it avoids dodgy poking about in the parser LALR stack looking for errors) and has less performance impact in the common case where DEFAULT is not used. (check-in: a3d83137 user: drh tags: default-in-values-2) | |
| 17:29 | Remove tea version check from tool/srctree-check.tcl, as it's obsoleted by [be265559]. (check-in: 1860ea06 user: stephan tags: trunk) | |
| 16:29 | Automate update of the library version number in autoconf/tea/configure.ac as part of the tool/mkautoconfamal.sh process. (check-in: d5c0be36 user: stephan tags: branch-3.49) | |
| 16:24 | DLL installation rules no longer create versioned symlinks on platforms where the DLL extension is '.dll' (cygwin, msys2, etc.), as suggested in forum post 28bb79638844c328. (check-in: d94ad545 user: stephan tags: branch-3.49) | |
| 16:24 | Automate update of the library version number in autoconf/tea/configure.ac as part of the tool/mkautoconfamal.sh process, per /chat discussion. (check-in: be265559 user: stephan tags: trunk) | |
| 16:12 | DLL installation rules no longer create versioned symlinks on platforms where the DLL extension is '.dll' (cygwin, msys2, etc.), as suggested in forum post 28bb79638844c328. (check-in: d7434106 user: stephan tags: trunk) | |
| 14:13 | A cleaner workaround for [6a21d6a2]. (check-in: 46780441 user: stephan tags: branch-3.49) | |
| 14:12 | A cleaner workaround for [6a21d6a2], provided by autosetup's creator. (check-in: 334ed723 user: stephan tags: trunk) | |
|
2025-02-14
| ||
| 18:18 | More informative output for the pthread feature test. (check-in: adf042fb user: stephan tags: branch-3.49) | |
| 18:17 | More informative output for the pthread feature test. (check-in: 01b9ed73 user: stephan tags: trunk) | |
| 18:07 | Make failure to find pthreads support non-fatal unless --enable-threadsafe is specifically passed in. Build regression reported in forum post 8e0fdb8c0d. (check-in: f8843b82 user: stephan tags: branch-3.49) | |
| 18:06 | Make failure to find pthreads support non-fatal unless --enable-threadsafe is specifically passed in. Build regression reported in forum post 8e0fdb8c0d. (check-in: 806ad1ac user: stephan tags: trunk) | |
| 17:53 | Simplify the --help workaround introduced in [6a21d6a2ed]. (check-in: 03d0c192 user: stephan tags: branch-3.49) | |
| 17:52 | Simplify the --help workaround introduced in [6a21d6a2ed]. (check-in: b0928f20 user: stephan tags: trunk) | |
| 17:25 | Work around autosetup --help quirk described in [6a21d6a2ed62]. (check-in: 61726358 user: stephan tags: branch-3.49) | |
| 17:21 | Work around a autosetup --help bug which only(?) triggers on tcl 8.6, introduced by [9978c87139b7b042] and reported upstream as ticket #73. Summary: calling 'options' from a proc, instead of the global scope, triggers an error about an invalid use of 'break'. (check-in: 6a21d6a2 user: stephan tags: trunk) | |
| 16:43 | ICU config support: add more details to error messages and correct a typo which would cause a configure crash if --with-icu-config=X refered to a non-executable X. (check-in: 80311f09 user: stephan tags: branch-3.49) | |
| 16:42 | ICU config support: add more details to error messages and correct a typo which would cause a configure crash if --with-icu-config=X refered to a non-executable X. (check-in: ff508926 user: stephan tags: trunk) | |
| 10:28 | Fix test cases added for [4b4f33d791fe4318] so that they also work when compiling with ICU support. Forum post 2ca8a09a7e (check-in: 5964616d user: drh tags: trunk) | |
|
2025-02-13
| ||
| 23:33 | Omit an optimization that did not work - it runs faster with the optimization removed. CLOSED: Development on this branch has stopped. See the new implementation in the default-in-values-2 branch. (Closed-Leaf check-in: d67e28cb user: drh tags: default-in-values) | |
| 19:19 | Remove an unnecessary branch. Improvements to error messages. (check-in: f49ddd80 user: drh tags: default-in-values) | |
| 16:31 | When using the --out-implib build option, install the generated .dll.a file to PREFIX/lib. (check-in: 8e8037ba user: stephan tags: branch-3.49) | |
| 16:20 | When using the --out-implib build option, install the generated .dll.a file to PREFIX/lib. (check-in: 0dadea0e user: stephan tags: trunk) | |
| 16:03 | Fix various problems. Appears to be working now. (check-in: 7fd94f13 user: drh tags: default-in-values) | |
| 14:47 | Ensure the counts of "deferred FK violations" and "deferred immediate FK violations" are kept separate when "PRAGMA defer_foreign_keys" is used. (check-in: c5190b0f user: dan tags: trunk) | |
| 14:45 | Bring the 3.49 branch's configure-related files up to par with the current trunk. (check-in: 1cc8d16b user: stephan tags: branch-3.49) | |
| 11:10 | This version still does not work. This is an incremental check-in to save my place so that I can work on other things. (check-in: 2b73eb3f user: drh tags: default-in-values) | |
|
2025-02-12
| ||
| 20:54 | An attempt to allow the DEFAULT keyword in the VALUES clause of an INSERT. This check-in does not work right. (check-in: 85c108eb user: drh tags: default-in-values) | |
| 20:19 | Fix a few 32-bit overflow problems in showdb.c. (check-in: 93777666 user: dan tags: trunk) | |
| 18:22 | Merge the latest trunk changes into the default-in-values branch. (check-in: 480d7c1a user: drh tags: default-in-values) | |
| 17:21 | Have the win32 VFS take a temporary shared lock (instead of the current exclusive) on the pending-byte when taking a SHARED lock on a db. Do not lock the pending-byte at all when taking an EXCLUSIVE lock if RESERVED is not already held. (check-in: 5127509a user: dan tags: win32-enable-setlk) | |
| 16:59 | configure --help cleanups and eliminate the use of a JS-esque inner function in sqlite-config.tcl. No functional changes. (check-in: 6df859cd user: stephan tags: trunk) | |
| 15:31 | Remove old function declaration accidentally left in sqlite3session.h. (check-in: 0cfbe349 user: dan tags: trunk) | |
| 14:51 | Tiny tcl comment tweaks. No functional changes. (check-in: da94e551 user: stephan tags: trunk) | |
| 08:07 | Fix test script errors in walsetlk3.test. Tests still don't all pass. (check-in: 56eb4114 user: dan tags: win32-enable-setlk) | |
|
2025-02-11
| ||
| 19:54 | Omit the src/pragma.h file. It is generated by the tool/mkpragmatab.tcl script. The makefiles now know how to build this file for themselves. (check-in: 9709ed1c user: drh tags: trunk) | |
| 19:40 | Omit the src/ctime.c source file, since it is automatically generated by a TCL script. Instead, add rules to the various makefiles to generate ctime.c on demand. (check-in: 958bb5de user: drh tags: trunk) | |
| 18:32 | Update tool/mkctimec.tcl so that sqlite3_compileoption_xxx() APIs report on the SQLITE_ENABLE_SETLK_TIMEOUT option. (check-in: 303e8009 user: dan tags: win32-enable-setlk) | |
| 18:29 | Fix "unused variable" warnings in os_unix.c and os_win.c. (check-in: 8e809632 user: dan tags: win32-enable-setlk) | |
| 17:22 | Rename a configure-internal function and fix handling of --dump-defines for the autoconf bundle. (check-in: 3f539d81 user: stephan tags: branch-3.49) | |
| 17:20 | Rename a configure-internal function and fix handling of --dump-defines for the autoconf bundle. (check-in: 6aa54cc1 user: stephan tags: trunk) | |
| 17:13 | Move the configure flags definition and handling into autosetup/sqlite-config.tcl to avoid duplication between auto.def and autoconf/auto.def while still giving us a way to filter the canonical-tree-only flags out of the autoconf build. (check-in: 5a964bf3 user: stephan tags: branch-3.49) | |
| 17:10 | Merge latest changes from trunk into this branch. (check-in: e5ec5bb9 user: dan tags: win32-enable-setlk) | |
| 17:10 | Move the configure flags definition and handling into autosetup/sqlite-config.tcl to avoid duplication between auto.def and autoconf/auto.def while still giving us a way to filter the canonical-tree-only flags out of the autoconf build. (check-in: 9978c871 user: stephan tags: trunk) | |
| 16:00 | Attempt to improvement performance of multiple OP_Columns that occur in a row. Minimal improvement for a lot of complexity and risk. (Closed-Leaf check-in: 53478f29 user: drh tags: column-optimization) | |
| 13:18 | Adapt Fossil SCM patch 3bff7b92d6d, applying -lrt for platforms which need it for one of {fdatasync, nanosleep}. (check-in: 77621fd1 user: stephan tags: branch-3.49) | |
| 13:15 | Make the --out-implib support ([6092b0b86bf93a3d]) specifically opt-in because the feature check for it passes on some platforms where it is not recognized at link-time. (check-in: 8212f8ee user: stephan tags: branch-3.49) | |
| 13:13 | Make the --out-implib support ([6092b0b86bf93a3d]) specifically opt-in because the feature check for it passes on some platforms where it is not recognized at link-time. (check-in: 75535f23 user: stephan tags: trunk) | |
| 13:00 | Adapt Fossil SCM patch 3bff7b92d6d, applying -lrt for platforms which need it for one of {fdatasync, nanosleep}. (check-in: 1768de6e user: stephan tags: trunk) | |
|
2025-02-10
| ||
| 19:48 | Remove a pointless line of code. (check-in: 57b2b812 user: drh tags: trunk) | |
| 19:12 | Add the --size option to the test/speedtest.tcl script. (check-in: 6b9007cb user: drh tags: trunk) | |
| 18:41 | Minor autosetup doc tweaks. (check-in: bb53beb2 user: stephan tags: trunk) | |
| 16:34 | Make the "mix1" testset the default for speedtest1. (check-in: 7a0c3d0e user: drh tags: trunk) | |
| 16:13 | Enhance speedtest1 with a new testset that calls sqlite3_open() and uses the connection many times. (check-in: ce307add user: drh tags: trunk) | |
| 15:58 | Add jimsh.exe and jimsh0.exe to the clean rules in Makefile.msc so that stale builds of those files from msys2 and friends do not cause mysterious build errors. (check-in: 44b4e4db user: stephan tags: trunk) | |
| 15:02 | configure: when dlopen() is not found, only fail fatally if --enable-load-extension is explicitly provided, else warn instead. Based on discussion around forum post 2efe9c33bd9021ca. Update proj-indented-notice to behave like its docs say it should when the -error flag is used. (check-in: 7db7eb22 user: stephan tags: branch-3.49) | |
| 15:01 | configure: when dlopen() is not found, only fail fatally if --enable-load-extension is explicitly provided, else warn instead. Based on discussion around forum post 2efe9c33bd9021ca. Update proj-indented-notice to behave like its docs say it should when the -error flag is used. (check-in: f28e52cb user: stephan tags: trunk) | |
| 11:16 | Convert some expensive NEVER() and ASSERT() macros into assert()s. (check-in: 4aad8918 user: drh tags: trunk) | |
| 00:20 | Small performance increase in jsonTranslateBlobToText(). (check-in: 3b1dcac2 user: drh tags: trunk) | |
|
2025-02-09
| ||
| 20:23 | Performance optimization to the substr() SQL function. (check-in: ce228ce3 user: drh tags: trunk) | |
| 19:49 | Performance and size optimization for the sqlite3ColumnIndex() routine. (check-in: a93e3fe0 user: drh tags: trunk) | |
| 05:37 | Update the 'clean' rules for autoconf/Makefile.in to account for [6092b0b8]. (check-in: 23d25ae2 user: stephan tags: branch-3.49) | |
| 05:37 | Update the 'clean' rules for autoconf/Makefile.in to account for [6092b0b8]. (check-in: f3a35fdc user: stephan tags: trunk) | |
| 05:32 | Apply [6092b0b8] to autoconf/Makefile.in. (check-in: 6c17e4b8 user: stephan tags: branch-3.49) | |
| 05:30 | Apply [6092b0b8] to autoconf/Makefile.in. (check-in: 9ae245cf user: stephan tags: trunk) | |
| 04:40 | configure: if the linker supports --out-implib, generate libsqlite3.X.a, where X is the platform's DLL file extension. Discussion in/around forum post 0c7fc097b2. (check-in: 705a6d3e user: stephan tags: branch-3.49) | |
| 04:38 | configure: if the linker supports --out-implib, generate libsqlite3.X.a, where X is the platform's DLL file extension. Discussion in/around forum post 0c7fc097b2. (check-in: 6092b0b8 user: stephan tags: trunk) | |
| 04:16 | wasm: add some build-time validation to ensure that the problem fixed in [65798c09a00662a3] does not recur. Ensure that files generated via mkwasmbuilds.c have the generated makefile as a dependency. (check-in: 55e01365 user: stephan tags: trunk) | |
| 03:24 | wasm: when building in -O0 mode (typical dev mode), use -sASSERTIONS=2, else -sASSERTIONS=0, in response Emscripten checkin 7e3e35cbff9, which adds assertions to check for the condition reported in Emscripten ticket 23420. Update some unrelated JS-side internal docs. (check-in: 1f554610 user: stephan tags: trunk) | |
| 02:41 | JS: add a mechanism to the Worker1 exec API to fetch the last_insert_rowid(), as requested in forum post 56bc353901. (check-in: c22c4836 user: stephan tags: trunk) | |
| 01:50 | wasm: add some build-time validation to ensure that the problem fixed in [65798c09a00662a3] does not recur. Ensure that files generated via mkwasmbuilds.c have the generated makefile as a dependency. (check-in: 012b308b user: stephan tags: branch-3.49) | |
| 01:30 | configure: when transfering ENABLE/OMIT flags from CFLAGS to OPT_FEATURE_FLAGS, also do the same for CPPFLAGS and remove those ENABLE/OMIT flags from CFLAGS/CPPFLAGS to mimic legacy build behavior. Strip ENABLE/OMIT flags from BUILD_CFLAGS but do not transfer those to OPT_FEATURE_FLAGS, also to mimic legacy behavior. This is the second part of a fix discussed at forum post 9801e54665afd728. (check-in: dcb44da4 user: stephan tags: branch-3.49) | |
| 01:25 | configure: when transfering ENABLE/OMIT flags from CFLAGS to OPT_FEATURE_FLAGS, also do the same for CPPFLAGS and remove those ENABLE/OMIT flags from CFLAGS/CPPFLAGS to mimic legacy build behavior. Strip ENABLE/OMIT flags from BUILD_CFLAGS but do not transfer those to OPT_FEATURE_FLAGS, also to mimic legacy behavior. This is the second part of a fix discussed at forum post 9801e54665afd728. (check-in: 16d307cc user: stephan tags: trunk) | |
| 00:54 | Add the "star" testset to speedtest1. Include it as part of "mix1". (check-in: f1345b84 user: drh tags: trunk) | |
|
2025-02-08
| ||
| 16:16 | Put a 16-byte hash table for column names on each Table object, to speed up column name lookups. (check-in: 11eb8f99 user: drh tags: trunk) | |
| 14:15 | Use the sqlite3ColumnIndex() routine to look up a column in a table, rather than using a custom loop. Performance improvement, size reduction, and complexity decrease. (check-in: 351dbbc2 user: drh tags: trunk) | |
| 13:34 | Fix GCC-isms and compiler warnings introduced by recent check-ins [c56092507c967230] and [6e57848fe1e0e2b5]. (check-in: 91102c04 user: drh tags: trunk) | |
| 12:04 | Improvements to the symbol table hash: faster lookups with fewer calls to sqlite3StrICmp() for schemas with many symbols and large names. (check-in: 6e57848f user: drh tags: trunk) | |
| 11:15 | Improvements to the hash table used to store symbols in the schema, so that it works better (requires fewer calls to sqlite3StrICmp()) for large schemas, and uses less code space. (Closed-Leaf check-in: 0318b68c user: drh tags: hash-improvements) | |
|
2025-02-07
| ||
| 19:18 | build: work around a report of (install -d DIR) failing in one environment if DIR already exists. (check-in: 8f7b7840 user: stephan tags: trunk) | |
| 19:15 | build: work around a report of (install -d DIR) failing in one environment if DIR already exists. (check-in: 4bc6fe30 user: stephan tags: branch-3.49) | |
| 19:09 | Fix comments on the Parse.nMaxArgs field so that they are correct. Add assert()s to ensure they are correct. Other Parse changes to reduce the amount of memset() needed to initialize it. (check-in: c5609250 user: drh tags: trunk) | |
| 15:49 | Further reduction in the amount of memset() needed to initialize the Parse object. (check-in: 45e462c0 user: drh tags: trunk) | |
| 14:47 | Mac-specific build fixes discussed in forum thread 9dfd5b8fd525a5d7: rename dylib links and add legacy-compatibility versioning stamps to libsqlite3.dylib. (check-in: 4b073687 user: stephan tags: branch-3.49) | |
| 14:44 | Mac-specific build fixes discussed in forum thread 9dfd5b8fd525a5d7: rename dylib links and add legacy-compatibility versioning stamps to libsqlite3.dylib. (Edit: this was merged from [aa0033d5aa] but a post-merge update on my end lost that link.) (check-in: 668bcf32 user: stephan tags: trunk) | |
| 13:37 | Reduce the amount of memset() needed to initialize the Parse object. (check-in: 284538d8 user: drh tags: trunk) | |
| 12:59 | configure: change extension of static libraries from .lib to .a on msys/cygwin, as per discussion in forum post 02db2d4240. Replace unidiomatic JS-style use of inner procs in autosetup/proj.tcl with TCL lambdas. (check-in: b7c84c04 user: stephan tags: branch-3.49) | |
| 12:58 | configure: change extension of static libraries from .lib to .a on msys/cygwin, as per discussion in forum post 02db2d4240. Replace unidiomatic JS-style use of inner procs in autosetup/proj.tcl with TCL lambdas. (check-in: 46f51e2a user: stephan tags: trunk) | |
| 12:36 | Reorder a piece of ext/wasm/GNUmakefile to correct the timing of various var accesses. Fixes a problem reported in the downstream npm subproject and explains the confusion in [4aa025a943a4024094b9] (which has been reverted). (check-in: de3d2e4c user: stephan tags: branch-3.49) | |
| 12:33 | Reorder a piece of ext/wasm/GNUmakefile to correct the timing of various var accesses. Fixes a problem reported in the downstream npm subproject and explains the confusion in [4aa025a943a4024094b9] (which has been reverted). (check-in: 65798c09 user: stephan tags: trunk) | |
| 11:55 | Latest upstream jimsh0.c with a slightly different (fconfigure -translation binary) impl. Tested on Win11 and Linux for output compatibility with sqlite3.c/h. (Closed-Leaf check-in: aa0033d5 user: stephan tags: mac-build-fixes) | |
| 11:21 | Merge trunk into mac-build-fixes branch and resolve a doc-only merge conflict. (check-in: 5df30deb user: stephan tags: mac-build-fixes) | |
| 11:18 | Fix out-of-tree builds of the autoconf bundle, as reported in forum post a0cd0beb1baa6bef. Bumd version number to 3.49.1. (check-in: 37dbacde user: stephan tags: branch-3.49) | |
| 11:15 | Fix out-of-tree builds of the autoconf bundle, as reported in forum post a0cd0beb1baa6bef. (check-in: d47964a6 user: stephan tags: trunk) | |
| 10:51 | Use a linker flag check, rather than just an OS check, to determine whether to use the -compatibility/current_version flags. (check-in: 85302582 user: stephan tags: mac-build-fixes) | |
| 02:01 | Library-linking and installation fixes for Mac platforms, as discussed in forum post 9dfd5b8fd5. These still require testing on such a platform. (check-in: 940e78dd user: stephan tags: mac-build-fixes) | |
| 01:43 | Bump TEA configure.ac version number. (check-in: a1a9c780 user: stephan tags: trunk) | |
|
2025-02-06
| ||
| 21:14 | This is an experimental change to investigate the feasibility of allow DEFAULT tokens within VALUES clauses attached to INSERT statements. There is a lot of extra code space consumed for such an obscure feature. (check-in: 2ff4129e user: drh tags: default-in-values) | |
| 17:29 | Adjust the test/speedtest.tcl script so that it uses an on-disk database rather than an in-memory database. (check-in: e93d7aa1 user: drh tags: trunk) | |
| 17:10 | Fix a harmless typo in a comment. (check-in: ed822729 user: drh tags: trunk) | |
| 13:36 | Bump version number to 3.50.0 for the next dev cycle. (check-in: 46d08071 user: stephan tags: trunk) | |
| 13:35 | Fix a dependencies/order-of-operations bug in ext/wasm/GNUmakefile which causes creation of files filtered via c-pp to fail if the ext/wasm/jswasm dir did not exist beforehand. (check-in: 44d7ad8f user: stephan tags: branch-3.49) | |
| 13:18 | Fix a dependencies/order-of-operations bug in ext/wasm/GNUmakefile which causes creation of files filtered via c-pp to fail if the ext/wasm/jswasm dir did not exist beforehand. (check-in: 4bac7613 user: stephan tags: trunk) | |
| 12:56 | Merge version 3.49.0 into the reuse-schema branch. (check-in: 2699ae6e user: drh tags: reuse-schema) | |
| 12:46 | Merge version 3.49.0 into the bedrock branch. (check-in: cc3ce784 user: drh tags: bedrock) | |
| 12:43 | Merge version 3.49.0 into the wal2 branch. (check-in: e194c8e8 user: drh tags: wal2) | |
| 12:39 | Merge version 3.49.0 into begin-concurrent branch. (check-in: 9d3878e9 user: drh tags: begin-concurrent) | |
| 11:55 | Version 3.49.0 (check-in: 4a7dd425 user: drh tags: trunk, release, major-release, version-3.49.0) | |
|
2025-02-05
| ||
| 17:52 | If SQLite is compiled with SQLITE_ENABLE_WAL_BIGHASH defined, use hash tables large enough to fit 128K, instead of 4K, entries in the *-shm file. (check-in: 581efc34 user: dan tags: bedrock) | |
| 16:08 | Fix a harmless unused-parameter compiler warning introduced by [75f3d8744879]. (check-in: 9f28f669 user: drh tags: trunk) | |
| 12:56 | Summarize known incompatibilities/gotches between JimTCL and canonical TCL, and their workarounds. Doc changes only. (check-in: 60c932e6 user: stephan tags: trunk) | |
| 12:49 | Upstream JimTCL patch and minor tcl script tweaks to support (fconfigure -translation binary) for better cross-platform build portability. (check-in: 0974a17c user: stephan tags: trunk) | |
| 12:15 | Portability tweaks to the code generators so that they produce identical output with JimTCL on Windows and Unix systems (that is: no Windows-style line endings). (Leaf check-in: fddcfbca user: stephan tags: branch-3.48) | |
| 12:02 | Attempted improvements to the SQLITE_DBCONFIG_... documentation. (check-in: baac8538 user: drh tags: trunk) | |
|
2025-02-04
| ||
| 02:38 | Detect and report signed integer overflow in the sumInverse() routine, used by window functions. (check-in: 317e9a47 user: drh tags: trunk) | |
|
2025-02-03
| ||
| 23:27 | Test case for the FTS3 fix in the previous check-in. This check-in also accidentally includes a change to session that is intended to remove a static analysis warning. (check-in: 459d8f69 user: drh tags: trunk) | |
| 23:19 | Fix a potential UAF in FTS3. (check-in: 75f3d874 user: drh tags: trunk) | |
| 21:24 | New dbsqlfuzz case added to fuzzdata8.db. (Closed-Leaf check-in: 7ee20cfc user: drh tags: fuzzer-20250203) | |
| 21:04 | The Parse.addrExplain field is never even if SQLITE_OMIT_EXPLAIN is defined. (check-in: 5d81a984 user: drh tags: trunk) | |
| 18:53 | Enhance fuzzcheck so that the --sqlid and --dbid options can take a range of IDs to run. (check-in: 408fa57f user: drh tags: trunk) | |
| 18:49 | Fixes and improved documentation to the new --sqlid and --dbid range options in fuzzcheck. (Closed-Leaf check-in: 59e26632 user: drh tags: fuzzcheck-improvements) | |
| 18:36 | Enhance fuzzcheck so that the --sqlid and --dbid options can specify a range of tests to be run. (check-in: cdd0af6f user: drh tags: fuzzcheck-improvements) | |
| 18:05 | Fix for a potential UAF in FTS5. (check-in: e33f2fed user: drh tags: trunk) | |
| 18:01 | Improve the JS-side sqlite3_set_auxdata() test to also trigger the case that the aux data actually gets reused. Test changes only, no library code. (check-in: 9f27379d user: stephan tags: trunk) | |
| 17:54 | Fix a use-after-free case in fts5 provoked by fuzzdata8.db. Tcl test case pending. (Closed-Leaf check-in: a4962df6 user: dan tags: fuzz-data) | |
| 17:45 | New test case for test/fuzzdata8.db (check-in: 8a882f97 user: drh tags: fuzz-data) | |
| 17:34 | Rework [76c8435a] to eliminate automatic JS-to-WASM function conversions of sqlite3_set_auxdata() destructors because it can leads to leaks on every call of a UDF. This feature never worked before [76c8435a] but fixing it was ill-conceived because of the memory leakage it introduces. WASM function pointers can still be used as destructors in this context. (check-in: 3fb993af user: stephan tags: trunk) | |
| 17:21 | Add a test app to assist in validating the SAHPool digest calculation fix. (check-in: a1e304b8 user: stephan tags: sahpool-digest) | |
| 16:26 | Initial work on a fix for the SAHPool VFS's effectively-no-op digest calculation, as reported in ticket #97 of the downstream npm subproject. This requires more testing alongside databases created before this version to ensure that it's backwards-compatible. (check-in: 9234c33f user: stephan tags: sahpool-digest) | |
| 15:17 | Merge the latest trunk changes into the reuse-schema branch. (check-in: 858163f9 user: drh tags: reuse-schema) | |
| 15:11 | Merge all the latest trunk enhancements into the bedrock branch. (check-in: 1cef92de user: drh tags: bedrock) | |
| 15:07 | Merge the latest trunk enhancements into the wal2 branch. (check-in: e2d4c189 user: drh tags: wal2) | |
| 14:59 | Merge all the latest trunk enhancements and fixes into the begin-concurrent branch. (check-in: f456a72e user: drh tags: begin-concurrent) | |
| 14:55 | Add a more complete test for [76c8435a] and add some commentary about (A) the inability to automatically clean up automatically-generated WASM proxy functions for sqlite3_set_auxdata() destructors and (B) how to deal with (A) to avoid leaking WASM proxy functions. (check-in: d693c2dd user: stephan tags: trunk) | |
| 14:44 | Fix the build process on Windows so that it generates identical sqlite3.c, sqlite3.h, and shell.c files on Windows and Unix. This patch also includes a change to JS bindings that got caught up in the branch. (check-in: 91ef45fc user: drh tags: trunk) | |
| 14:40 | Bring the autoconf-tarball Makefile.msc into alignment with the main Makefile.msc. (Closed-Leaf check-in: 52a7a162 user: drh tags: windows-build-issue) | |
| 14:04 | Correct the FuncPtrAdapter signature for the JS binding of sqlite3_set_auxdata(). Reported in the npm subproject, ticket #92. (check-in: 76c8435a user: stephan tags: windows-build-issue) | |
| 13:20 | Adjust the build process to avoid extra CR characters inserted by jimsh on Windows. (check-in: 1f548539 user: drh tags: windows-build-issue) | |
| 12:42 | The "clean" target on Makefile.msc should not delete the auto.def file. Bug: causes "make devtest" to fail. Moved to a branch until repaired. (check-in: 72fbcedf user: drh tags: windows-build-issue) | |
|
2025-02-02
| ||
| 18:01 | Add a header comment to test/speedtest1.c that outlines how to compile the program using historical amalgamation sources, for comparison testing. (check-in: 602d4dd6 user: drh tags: trunk) | |
| 16:52 | Update to the "--help" output from speedtest1. (check-in: 52164520 user: drh tags: trunk) | |
| 12:15 | URL typo fix in code comments. No code changes. (check-in: 002a1230 user: stephan tags: trunk) | |
|
2025-02-01
| ||
| 23:49 | Add a missing "db2 close" to the ext/session/session_gen.test test module. (check-in: 4068f586 user: drh tags: trunk) | |
| 23:34 | Fix a comment typo - in a comment used to generate documentation. (check-in: b8de75ee user: drh tags: trunk) | |
| 23:28 | Remove an ALWAYS() added by [2567298f4b0fdfeb] because dbsqlfuzz found a way to reach it. The test case was added to TH3. (check-in: d08a7aa8 user: drh tags: trunk) | |
| 21:06 | Enable SQLITE_ENABLE_NORMALIZE for several test configurations. (check-in: b07c6407 user: drh tags: trunk) | |
| 20:53 | Fix an issue with sqlite3_normalized_sql() caused by changes needed to support SQLITE_DBCONFIG_ENABLE_COMMENT. (check-in: 79d287a3 user: drh tags: trunk) | |
| 09:44 | JS doc typo fixes. No functional changes. (check-in: e0d9c74c user: stephan tags: trunk) | |
|
2025-01-31
| ||
| 20:18 | Tweaks to [4b4f33d791fe4318] to make it easier to test. (check-in: 2567298f user: drh tags: trunk) | |
| 18:56 | Fix test case numbering in tests recently added to like3.test. (check-in: 6df2098c user: drh tags: trunk) | |
| 18:45 | Expose the new SQLITE_DBCONFIG_ENABLE_ATTACH_CREATE/WRITE and SQLITE_DBCONFIG_ENABLE_COMMENTS (from [325e547a21955]) to JS/WASM. (check-in: 8da1a9af user: stephan tags: trunk) | |
| 18:34 | Remove an assert() that is not true if a trace-callback is deregistered while there are active statements. (check-in: d53c5824 user: dan tags: branch-3.48) | |
| 18:33 | Remove an assert() that is not true if a trace-callback is deregistered while there are active statements. Forum post 3547aa1078510686. (check-in: 0ecfc4d0 user: dan tags: trunk) | |
| 17:47 | Minor cleanups in the opfs-sahpool pause/unpause API demo. (Closed-Leaf check-in: e205cdc4 user: stephan tags: opfs-sahpool-pause) | |
| 16:34 | Add the conventional license header to sahpool-worker.js and correct the date on the header in sahpool-pausing.js. (check-in: f7c3026b user: stephan tags: opfs-sahpool-pause) | |
| 16:25 | Add a small test app demonstrating cooperative semi-concurrency of the opfs-sahpool VFS using its un/pauseVfs() APIs. (check-in: 09570c55 user: stephan tags: opfs-sahpool-pause) | |
| 14:58 | Fix a problem with LIKE and GLOB processing in utf-16be databases in cases where the utf-8 encoding of a character ends with the byte 0xBF. (check-in: 9d59f8a5 user: drh tags: branch-3.48) | |
| 14:54 | If any errors occur while processing sqlite_dbpage changes, cancel pending truncate operations. (check-in: 3f8d1902 user: drh tags: branch-3.48) | |
| 14:52 | Fix a problem with LIKE and GLOB processing in utf-16be databases in cases where the utf-8 encoding of a character ends with the byte 0xBF. Forum post d7b90d92ffbfc61f (check-in: 4b4f33d7 user: dan tags: trunk) | |
| 14:52 | If any errors occur while processing sqlite_dbpage changes, cancel pending truncate operations. (check-in: 6138e0dc user: drh tags: trunk) | |
| 14:25 | Cleanups in the opfs-sahpool VFS pause/unpause feature and its tests. (check-in: 184ba377 user: stephan tags: opfs-sahpool-pause) | |
| 13:32 | Three new options to sqlite3_db_config(): ATTACH_CREATE, ATTACH_WRITE, and COMMENTS. (check-in: 325e547a user: drh tags: trunk) | |
| 12:39 | Merge trunk into opfs-sahpool-pause branch. (check-in: 775a547e user: stephan tags: opfs-sahpool-pause) | |
| 12:30 | Minor wasm-specific doc touchups. (check-in: 56b618da user: stephan tags: trunk) | |
| 12:09 | Improvements to the SQLITE_DBCONFIG option documentation. (Closed-Leaf check-in: 59f0ba10 user: drh tags: extra-security) | |
| 11:46 | Correct a typo in tool/emcc.sh.in which could cause all of the configure-time work to locate the emcc binary to go unused. Reported in forum post feb325cdde5b6f37. (check-in: 66bf6784 user: stephan tags: branch-3.48) | |
| 11:45 | Correct a typo in tool/emcc.sh.in which could cause all of the configure-time work to locate the emcc binary to go unused. Reported in forum post feb325cdde5b6f37. (check-in: f66efd5b user: stephan tags: trunk) | |
| 01:34 | Add the SQLITE_DBCONFIG_ENABLE_COMMENTS setting (default on) to enable or disable the ability to include comments in SQL input text. (check-in: 393749a2 user: drh tags: extra-security) | |
| 00:54 | Merge all the latest trunk changes into the extra-security branch. (check-in: 86ba5756 user: drh tags: extra-security) | |
|
2025-01-30
| ||
| 21:16 | The reuse-subroutine optimization might have generated byte-code that loops forever. This check-in fixes the problem. (check-in: a8714e8c user: drh tags: branch-3.48) | |
| 21:12 | The reuse-subroutine optimization [c9a3498113074bbc] might have generated byte-code that loops forever. This check-in fixes the problem. (check-in: 0cc4ed8c user: drh tags: trunk) | |
| 16:07 | Remove an unused parameter from an internal-use subroutine in the TCL interface. (check-in: a700692b user: drh tags: trunk) | |
| 16:00 | Improvements to the TCL interface for Tcl9 as suggested by Jan Nijtmans. (check-in: d76c5db8 user: drh tags: trunk) | |
| 13:54 | Updates to the compile-for-windows.md document. (check-in: bcd22ed6 user: drh tags: trunk) | |
| 12:19 | Minor code de-duplication across the top-level auto.def and autoconf/auto.def. (check-in: 3c990d77 user: stephan tags: trunk) | |
| 12:01 | Disable a test case that (intentionally) does use-after-free, as it does occasionally cause problems even for non-sanitizer builds. (check-in: 23c7d5be user: drh tags: trunk) | |
| 11:59 | Minor cleanups to the previous checkin. No functional changes. (check-in: 0146a0da user: stephan tags: branch-3.48) | |
| 11:19 | Fix build regression, introduced in [d2fe6b05f38d9d] (3.48.0), in which SQLITE_OMIT and SQLITE_ENABLE flags passed to configure via CFLAGS were not propagated to the OPT_FEATURE_FLAGS list. Reported in forum post 9801e54665afd728. (check-in: ec71d9dc user: stephan tags: trunk) | |
| 11:16 | Fix build regression, introduced in [d2fe6b05f38d9d] (3.48.0), in which SQLITE_OMIT and SQLITE_ENABLE flags passed to configure via CFLAGS were not propagated to the OPT_FEATURE_FLAGS list. Reported in forum post 9801e54665afd728. (check-in: eedf4536 user: stephan tags: branch-3.48) | |
| 10:55 | Make two private routines in FTS "static" so that they are not callable from outside of SQLite itself. (check-in: 6d3a3d4e user: drh tags: branch-3.48) | |
|
2025-01-29
| ||
| 19:02 | Fix bug in sessions handling of FK constraints introduced by [e09a0c02] (released in 3.48.0). Bug was preventing a changeset containing FK violations from being applied even when the xConflict(CHANGESET_FOREIGN_KEY) returned OMIT. (check-in: 946f33cd user: dan tags: branch-3.48) | |
| 18:53 | Fix bug in sessions handling of FK constraints introduced by [e09a0c02] (released in 3.48.0). Bug was preventing a changeset containing FK violations from being applied even when the xConflict(CHANGESET_FOREIGN_KEY) returned OMIT. (check-in: d7c07581 user: dan tags: trunk) | |
| 17:26 | Consolidate memory allocations made while loading stat4 data in a way that may be more efficient on systems under load. (check-in: af65a902 user: dan tags: bedrock) | |
| 15:11 | If SQLITE_ENABLE_WAL2NOCKSUM is defined, then SQLite calculates the frame checksums used in wal2 mode based on the previous checksum and the frame header only, not the frame body only. This risks corruption following a OS crash or power failure, but also speeds up writes in wal2 mode. (check-in: dc74bd89 user: dan tags: bedrock) | |
| 11:28 | Simplify how OpfsSAHPoolUtil.unpauseVfs()'s returned promise is handled. (check-in: d651b8da user: stephan tags: opfs-sahpool-pause) | |
| 11:08 | Add experimental support to pause/unpause an SAHPool OPFS VFS, as discussed in forum post fe8cdb8431c32455, the intent being enable a page to relinquish, perhaps temporarily, the VFS such that the VFS's storage can be accessed by another page/tab. (check-in: 1d2683fe user: stephan tags: opfs-sahpool-pause) | |
|
2025-01-28
| ||
| 20:32 | Enhance the if() and iif() SQL functions so that they support any number of arguments greater than or equal to two. Suggested by forum post 40f7867f75f80. (check-in: fb76d184 user: drh tags: trunk) | |
| 19:03 | Fix sessions module handling of tables with generated columns. (check-in: 437fb316 user: dan tags: trunk) | |
| 18:05 | Fix a copy/paste typo in the output of vfstrace for xDlClose(). (check-in: ceafa92e user: drh tags: branch-3.48) | |
| 18:03 | Fix a copy/paste typo in the output of vfstrace for xDlClose(). (check-in: 1d57b57c user: drh tags: trunk) | |
| 12:50 | Simplify the IdList object to remove unnecessary fields. Performance increases by about 0.8%. (check-in: a4625bb9 user: drh tags: trunk) | |
| 10:56 | Fix typo in speedtest.md. (check-in: 984a9cc2 user: drh tags: trunk) | |
| 01:37 | The new SQLITE_USE_W32_FOR_CONSOLE_IO macro causes Win32 APIs to be used for console I/O and for stdio to be used otherwise. This is reported to be necessary for builds that use a C-language runtime other than the one provided by Microsoft. This changes if for Windows only. It is a bug fix, though we don't have a test case that will demonstrate a malfunction. (check-in: bfb7f499 user: drh tags: branch-3.48) | |
| 01:10 | Apparently I got the logic of [abfe488ed67e2e35] confused, even backwards. Change it so that the SQLITE_USE_W32_FOR_CONSOLE_IO macro causes Win32 APIs to be used for console I/O and for stdio to be used otherwise. This is reported to be necessary for builds that use a C-language runtime other than the one provided by Microsoft. This changes if for Windows only. It is a bug fix, though we don't have a test case that will demonstrate a malfunction. (check-in: 925e97e6 user: drh tags: trunk) | |
| 00:48 | Remove an ALWAYS() in the star-query heuristic that is sometimes false if you have a corrupt database. dbsqlfuzz c37ba7728d79859b79c8341b59297e88fba017d3. Test case in TH3. (check-in: 6b9a3396 user: drh tags: trunk) | |
|
2025-01-27
| ||
| 21:18 | Use hashing to accelerate column matching on INSERT statements. Code is smaller and about 1.8% faster overall according to test/speedtest.tcl. (check-in: 8be95638 user: drh tags: trunk) | |
| 17:48 | Enhance ./configure to issue an unambiguious error if the pathname to either the source tree or the build directory contains any space characters. (check-in: 614ae5c7 user: drh tags: trunk) | |
| 14:12 | Avoid splitting a hyperlink across lines in the documentation comment for sqlite3_serialize(). (check-in: 74b770bd user: drh tags: trunk) | |
|
2025-01-26
| ||
| 23:34 | Make two private routines in FTS "static" so that they are not callable from outside of SQLite itself. (check-in: 9b11bed0 user: drh tags: trunk) | |
| 20:09 | Further comment improvements in the star-query heuristic. Add an ALWAYS() on an unreachable branch to achieve MC/DC. (check-in: 5e18ce68 user: drh tags: trunk) | |
| 17:29 | Small size and complexity reduction on the star-query heuristic. Improved comments for the star-query heuristic. (check-in: a7ecb2f4 user: drh tags: trunk) | |
|
2025-01-25
| ||
| 23:04 | Revise the strategy used by the star-query heuristic: Instead of decreasing the cost of all fact-table WhereLoops, increase the run-cost of WhereLoops that are SCANs of dimension tables. (check-in: 1bc09c9e user: drh tags: trunk) | |
| 14:30 | Improvments to debug output on the star-query heuristic. (check-in: b3ebeb06 user: drh tags: trunk) | |
| 00:07 | Avoid calling computeMxChoice() after an OOM as some assert()s can fail in that routine if a prior OOM occurred while building the WhereLoop array. (check-in: 8b9e621d user: drh tags: trunk) | |
|
2025-01-24
| ||
| 20:59 | Remove an incorrect ALWAYS() added in check-in [7cfbe14d199bb631]. (check-in: 431a1a29 user: drh tags: trunk) | |
| 18:37 | Clarify handling of a NULL for the 2nd argument to sqlite3_serialize(), as pointed out in forum post 3df7168b90. (check-in: 340edbe5 user: stephan tags: trunk) | |
| 16:37 | Improve the star-query heuristic so that it does a better job of identifying actual star queries. Also includes improved diagnostic output from the query planner. (check-in: 7cfbe14d user: drh tags: trunk) | |
| 16:27 | The debugging output for WhereLoop objects now shows cost estimate changes due to the star-query heuristic. (Closed-Leaf check-in: a280f5f5 user: drh tags: star-query-heuristic) | |
| 15:55 | Minor tweaks to the star-query detection and processing. (check-in: 61f76a45 user: drh tags: star-query-heuristic) | |
| 15:41 | Correct a version number in autosetup/README.md. (check-in: c338caf0 user: stephan tags: trunk) | |
| 14:51 | When looking for star-queries, do not count a table as a dimension table if that table is separated from the fact table by an OUTER or CROSS join or if the table is a self-join. (check-in: 5aebd7df user: drh tags: star-query-heuristic) | |
| 14:13 | Update autosetup/README.md to reflect recent refactoring. (check-in: 60163682 user: stephan tags: trunk) | |
| 12:54 | Replace a handful of hard tabs in string literals with \t in mkwasmbuilds.c. (check-in: e8e4d497 user: stephan tags: trunk) | |
| 09:21 | Minor additions to ext/wasm/README.md. (check-in: 85747ea1 user: stephan tags: trunk) | |
| 09:18 | Update ext/wasm/README.md to reflect simplifications permitted by the current configure script behavior. (check-in: 9abb56c6 user: stephan tags: trunk) | |
| 08:58 | Remove extraneous are-we-making-clean guards from the generated wasm build rules, as that guard is set at a higher level. Rename a makefile call()able for consistency. (check-in: 7f9074e2 user: stephan tags: trunk) | |
|
2025-01-23
| ||
| 22:23 |
wasm: de-list demo-worker1-promiser-esm.html from the test pages because (per Chrome 131) "Module scripts don't support importScripts()" | |
| 21:06 | Fix a possible infinity loop in debugging-printf logic in the query planner. No changes to production code. (check-in: 9a20b940 user: drh tags: trunk) | |
| 19:44 | When running wasm-opt, ignore any failure because it will fail for unknown flags and the set of legal flags will change from version to version. Document the size-reduction effect (or non-effect) of a dozen-odd wasm-opt flags and retain those which demonstrate a wasm file size reduction in -Oz builds (our production build mode). Total size savings: roughly 13kb. (check-in: c9dc581e user: stephan tags: trunk) | |
| 16:11 | Remove some now-dead makefile code, rename a var for consistency, and fix a recipe bug introduced in the previous checkin in the bundler-friendly build. (check-in: 0acd4ef3 user: stephan tags: trunk) | |
| 15:58 | Initial support for post-processing wasm files with wasm-opt (if it's available). This currently shaves 12kb off of the release-mode build of sqlite3.wasm but there are many dozens of wasm-opt flags left to try. (check-in: 5d16e3f2 user: stephan tags: trunk) | |
| 14:09 | Move small parts of ext/wasm/GNUmakefile into ext/wasm/config.make.in and have the configure script populate that, rather than dynamically determining those values on each 'make' invocation. Add a configure-time check for the optional wasm-opt binary in prep for pending experimentation with using it to reduce the wasm file sizes. (check-in: 0a426a54 user: stephan tags: trunk) | |
| 11:42 | Have fts5 better handle OOM errors from sqlite3_blob_close(). (check-in: 7ffa7e02 user: dan tags: branch-3.48) | |
| 11:21 | Remove unnecessary --minify 0 emcc flag from the wasm build, as -g3 implies that capability along with other anti-minification features we rely on. (check-in: 10c91f9c user: stephan tags: trunk) | |
| 06:12 | Do not strip binaries during 'make install', for consistency with the legacy build and per request from package maintainers. (check-in: 92b06a4c user: stephan tags: branch-3.48) | |
| 06:10 | Do not strip binaries during 'make install', for consistency with the legacy build and per request from package maintainers. (check-in: cd3fed5c user: stephan tags: trunk) | |
|
2025-01-22
| ||
| 21:34 | Replace the use of the Autools in ./autoconf/ with Autosetup and extend its configure script to include many of the flags available in the canonical build. (check-in: 8c60d4c9 user: stephan tags: trunk) | |
| 19:37 | Add two new sqlite3_db_config() options that enable the ATTACH command to create new database files and to open databases read/write. Both default to on for backwards compatibility. (check-in: fe0c58d0 user: drh tags: extra-security) | |
| 17:18 | Add the -q/--quiet option to test/speedtest.tcl. Automatically enable -DSQLITE_OMIT_LOAD_EXTENSION and -DSQLITE_THREADSAFE=0 so that no extra libraries are required. (check-in: c20d21b4 user: drh tags: trunk) | |
|
2025-01-21
| ||
| 17:41 | Fix date/time computations to deal with the sub-millisecond rounding problem. (check-in: 55091181 user: drh tags: branch-3.48) | |
| 17:37 | Fix date/time computations to deal with the sub-millisecond rounding problem identified in forum post 766a2c9231. (check-in: afb0a592 user: drh tags: trunk) | |
| 16:30 | Performance improvements to the (debug-use only) Mem.pScopyFrom logic, resulting in about 8x faster performance under -DSQLITE_DEBUG for the query in from forum post 0025389d0860af82. This change only affects builds that use -DSQLITE_DEBUG. (check-in: 7fb1ae25 user: drh tags: trunk) | |
| 15:45 | Explain the lack of docs in autoconf/Makefile.in and refer interested readers to main.mk in canonical tree. Minor cleanups and fixes in tool/mkautoconfamal.sh. (Closed-Leaf check-in: e5bbc242 user: stephan tags: autoconf-to-autosetup) | |
| 15:21 | Increase the version number to 3.48.1. (check-in: 3e006d23 user: drh tags: branch-3.48) | |
| 15:16 | Remove an assert() in the unix file locking logic that is not true if alternative VFS "unix-excl" is used for a read-only connection. (check-in: 2fec6aa9 user: drh tags: branch-3.48) | |
| 15:12 | The FuncDev.nArg field values -3 and -4 now have special meansing of 1 or more or 2 or more arguments, respectively. This saves space in the built-in function table, resulting in slightly faster performance and a reduced binary size. (check-in: 753fd747 user: drh tags: trunk) | |
| 14:40 | Remove now-extraneous autoconf/INSTALL and autoconf/configure.ac and update autoconf/README.* to account for the port to autosetup. (check-in: 646667af user: stephan tags: autoconf-to-autosetup) | |
| 14:34 | Have fts5 better handle OOM errors from sqlite3_blob_close(). (check-in: f418350f user: dan tags: trunk) | |
| 12:33 | Demonstration of how to extend the if() and iif() SQL functions to support more than 3 arguments. (Leaf check-in: f13ef591 user: drh tags: if-many-args) | |
| 11:10 | Use Tcl_GetString() instead of Tcl_GetCharLength() to test for a zero-length string in the TCL interface, since that is much more efficient. (check-in: a8d9dcfd user: drh tags: trunk) | |
|
2025-01-20
| ||
| 20:50 | configure script: work around msys's inability to 'exec' a '.sh' file by prefixing the call with an explicit 'sh', as reported in forum post befb352a42a7cd6d. (check-in: 4cc2dc31 user: stephan tags: branch-3.48) | |
| 20:48 | configure script: work around msys's inability to 'exec' a '.sh' file by prefixing the call with an explicit 'sh', as reported in forum post befb352a42a7cd6d. (check-in: 25b01f1c user: stephan tags: autoconf-to-autosetup) | |
| 19:57 | Add 'dist' and missing 'install' pieces to the autoconf bundle. (check-in: 16fa2041 user: stephan tags: autoconf-to-autosetup) | |
| 19:19 | Remove an assert() in the unix file locking logic that is not true if alternative VFS "unix-excl" is used for a read-only connection. (check-in: bd5dc923 user: drh tags: trunk) | |
| 18:34 | Fix an assert() that could fail if a virtual table called sqlite3_step() from within the xSync() method while committing a "PRAGMA defer_foreign_keys=1" transaction. (check-in: 9303e663 user: dan tags: branch-3.48) | |
| 18:26 | Fix an assert() that could fail if a virtual table called sqlite3_step() from within the xSync() method while committing a "PRAGMA defer_foreign_keys=1" transaction. (check-in: 39bdbb3f user: dan tags: trunk) | |
| 16:14 | configure script: remove an overzealous is-a-file check in the tclsh search which fails to account for implicit .exe extensions on Windows builds. Reported in forum post c27403ef974df9f1. (Same change as [89306d1a4905] but to a different file, as that content was moved since the 3.48 release.) (check-in: 239a3d15 user: stephan tags: trunk) | |
| 16:11 | configure script: remove an overzealous is-a-file check in the tclsh search which fails to account for implicit .exe extensions on Windows builds. Reported in forum post c27403ef974df9f1. (check-in: 89306d1a user: stephan tags: branch-3.48) | |
|
2025-01-19
| ||
| 21:47 | Get libsqlite3.so and .a building in the autoconf bundle. (check-in: 88cee3fc user: stephan tags: autoconf-to-autosetup) | |
| 19:51 | Get the CLI shell building in the autoconf bundle. (check-in: 241cdbc4 user: stephan tags: autoconf-to-autosetup) | |
| 19:14 | Add an SQLITE_TESTCTRL_OPTIMIZATION mask that can disable the query planner heuristics that are designed to help with star queries. (check-in: fec4ff18 user: drh tags: trunk) | |
| 18:58 | Initial work towards converting the autoconf bundle to autosetup. Currently non-functional. (check-in: d7708372 user: stephan tags: autoconf-to-autosetup) | |
| 18:32 | Further refactoring of auto.def to simplify creation of variant builds like the autoconf bundle. (check-in: f806c563 user: stephan tags: trunk) | |
| 16:26 | Minor internal refactoring of auto.def to support the pending autoconf subdir port to autosetup. No functional changes. (check-in: 01ff3758 user: stephan tags: trunk) | |
| 14:53 | Move some of the auto.def functions into autosetup/sqlite-config.tcl for re-use in the pending migration of the autoconf bundle to autosetup. This is just reorg, no functional changes. (check-in: 2f1e9499 user: stephan tags: trunk) | |
|
2025-01-18
| ||
| 23:44 | Enable automatic query-time indexes for WITHOUT ROWID tables. (check-in: 8534af5b user: drh tags: trunk) | |
| 21:19 | Add a simple test case (many more are coming soon to TH3). Fix an obsolete assert(). (Closed-Leaf check-in: aa829a13 user: drh tags: without-rowid-autoidx) | |
| 21:00 | Add support for automatic query-time indexes on WITHOUT ROWID tables. (check-in: 89c4cbd9 user: drh tags: without-rowid-autoidx) | |
| 16:06 | When cross-compiling, change the CFLAGS default to exclude -g, per /chat discussion prompted by forum post 9a67df63eda9925c. (check-in: 67558248 user: stephan tags: branch-3.48) | |
| 16:05 | When cross-compiling, change the CFLAGS default to exclude -g, per /chat discussion prompted by forum post 9a67df63eda9925c. (check-in: 4309da2c user: stephan tags: trunk) | |
| 13:52 | When running make install, avoid the -s (strip) flag when cross-compiling, as it only works for the build platform. Reported in forum post 9a67df63eda9925c. (check-in: cc29664f user: stephan tags: branch-3.48) | |
| 13:51 | When running make install, avoid the -s (strip) flag when cross-compiling, as it only works for the build platform. Reported in forum post 9a67df63eda9925c. Also remove the undocumented and unused --soname=auto option. (check-in: 230e49c1 user: stephan tags: trunk) | |
|
2025-01-17
| ||
| 23:49 | For the purpose of the query planner heuristic added by [38db9b5c83], a query should only count as a star query if the fact tables are connected to the dimension table by an INNER JOIN. If a LEFT JOIN is used, then the fact tables are constrained to be in inner loops anyhow and so the heuristic does not make any sense. But it does interfere with AUTOMATIC index creation, which causes the performance regression reported by forum post d87570a1455. (check-in: 0852c57e user: drh tags: trunk) | |
| 17:09 | Enhance a comment on a test case to add recent context. (check-in: c2647d1b user: drh tags: trunk) | |
| 15:56 | Typo fix in speedtest.md. (check-in: 36027cf3 user: stephan tags: trunk) | |
| 15:39 | Improvements to the speedtest.tcl script. Add documentation on how to use the script. (check-in: eb3853d0 user: drh tags: trunk) | |
| 12:32 | Add the test/speedtest.tcl script to simplify performance and size testing. (check-in: ad7b3867 user: drh tags: trunk) | |
| 10:42 | Fix a potential one-byte buffer overrun when reading from the Windows console in the CLI. (check-in: 42bcc7c1 user: drh tags: branch-3.48) | |
| 10:39 | Fix a potential one-byte buffer overrun when reading from the Windows console in the CLI. Forum post 95e17b8f5c. This problem was introduced by check-in [abfe488ed67e2e35], which was an attempt to get the Windows build working on MingGW. (check-in: 4d967596 user: drh tags: trunk) | |
|
2025-01-16
| ||
| 20:46 | speedtest1: further improvements to the "json" testset. (check-in: c4750f7c user: drh tags: trunk) | |
| 20:08 | speedtest1: Improvements to the "json" testset. Better balance in "mix1". (check-in: 2cc73c5e user: drh tags: trunk) | |
| 17:19 | Revamp the "json" testset in speedtest1. (check-in: d3350883 user: drh tags: trunk) | |
| 14:37 | Add the "json" test case to speedtest1 and include it in "mix1". (check-in: 2db3a3ee user: drh tags: trunk) | |
| 14:06 | Speedtest1 enhancements: (1) Add the ability to scale performance of tests sets using "/NNN" after the testset name, even for testsets in a comma-separated list. (2) Add the "mix1" macro testset. (check-in: 85667b3a user: drh tags: trunk) | |
| 13:10 | wasm: after generating the .js/.mjs file, strip out all of the generated pieces which create Emscripten call() bindings for the sqlite3 APIs, as we don't use those binding, so both the setup time and the memory they use installing WASM proxy bindings is wasted. This eliminates some 200 superfluous/unused bindings from the init process. (check-in: 020d2c75 user: stephan tags: trunk) | |
| 12:15 | When generating the autoconf snapshot, replaces the Libs.private line from sqlite3.pc.in with one compatible with the legacy build, as reported in forum post e40b9b424a. (check-in: fe471547 user: stephan tags: trunk) | |
| 09:27 | Replace use of Emscripten's Module.postRun() with a custom callback so that we get consistent library init timing with both Emscripten 3.1.x and 4.0.x. Details and discussion are in Emscripten ticket #23420. (check-in: 4863a70a user: stephan tags: trunk) | |
| 01:47 | When two indexes have the same cost, use the narrower one (the one with the smaller average on-disk row width). (check-in: 39855967 user: drh tags: trunk) | |
|
2025-01-15
| ||
| 22:58 | Check-in [da9124fee28c155c] broken the new SQLITE_IOCAP_SUBPAGE_READ mechanism for inhibiting direct-overflow-read. This check-in fixes the problem. (check-in: f741ffc0 user: drh tags: branch-3.48) | |
| 21:13 | Check-in [da9124fee28c155c] broken the new SQLITE_IOCAP_SUBPAGE_READ mechanism for inhibiting direct-overflow-read. This check-in fixes the problem. (check-in: 113078d5 user: drh tags: trunk) | |
| 21:11 | Re-enable comment-stripping in the JS dist builds. (check-in: 5decfea3 user: stephan tags: branch-3.48) | |
| 21:09 | Teach tool/stripccomments.c that a backslash immediately preceeding a forward slash means that that forward slash cannot be the start of a comment. This is intended to allow JavaScript regular expressions containing \/* (like the one introduced in emsdk 4.0.0) to pass through properly. Re-enable comment-stripping in the JS dist builds. (check-in: db21d6cc user: stephan tags: trunk) | |
| 21:00 | Work around a behavior change in emsdk 4.0.0 which breaks the load/init timing of the wasm module. (check-in: c0f0d263 user: stephan tags: branch-3.48) | |
| 20:53 | Work around a behavior change in emsdk 4.0.0 which breaks the load/init timing of the wasm module. (check-in: 00a75018 user: stephan tags: trunk) | |
| 20:23 | When choosing between two indexes with the same cost, pick the one with the smaller predicted number of bytes per row. (Closed-Leaf check-in: d4bd0d42 user: drh tags: consider-idx-width) | |
| 19:30 | Variable names and conditional logic simplified in where.c. These changes are cosmetic only and do not affect the resuling machine code. (check-in: dbc2d6a2 user: drh tags: trunk) | |
| 15:27 | Fix a typo in a wasm makefile var name, noting that this doesn't actually fix anything because the var in question is not used when building 'clean' or 'distclean'. (check-in: 7cfc75a6 user: stephan tags: trunk) | |
| 14:31 | Disable the C-style comment stripper in the JS dist build, as explained in forum post 529c20d344. (check-in: 76ffc70f user: stephan tags: branch-3.48) | |
| 14:28 | Disable the C-style comment stripper in the JS dist build, as explained in forum post 529c20d344. (check-in: a9475e76 user: stephan tags: trunk) | |
| 13:35 | Fix another problem that was causing underestimates of index size. (Later:) Closed this branch as I don't think it is the correct approach to the problem. Maybe I'll change my mind later, but that's the decision for now. (Closed-Leaf check-in: a1690ecd user: drh tags: analyze-row-size) | |
| 12:38 | Fix issues with the prior check-ins on this branch. The code seems to work now, though many tests fail because of the new sqlite_stat1.stat text. (check-in: be26698a user: drh tags: analyze-row-size) | |
| 00:46 | Some bug fixes to the previous. Still lots of bugs remaining. (check-in: 76f2bede user: drh tags: analyze-row-size) | |
| 00:29 | Always include the sz=NNN option in the sqlite_stat1.stat field. (check-in: 9c0d6f29 user: drh tags: analyze-row-size) | |
|
2025-01-14
| ||
| 20:47 | Change the version number to 3.49.0 to begin the next development cycle. Any patches to 3.48.0 will go on a branch. (check-in: 8165a3d3 user: drh tags: trunk) | |
| 16:10 | Trying to remove a warning from some compiler that I do not have access to. (check-in: bc6de90c user: drh tags: trunk) | |
| 12:43 | Version 3.48.0 for the reuse-schema branch. (check-in: 1a031a53 user: drh tags: reuse-schema) | |
| 12:28 | Version 3.48.0 for the bedrock branch (check-in: fab341c8 user: drh tags: bedrock) | |
| 12:21 | Version 3.48.0 for the wal2 branch. (check-in: ef970ef0 user: drh tags: wal2) | |
| 12:15 | Version 3.48.0 for the begin-concurrent branch. (check-in: 56d110b6 user: drh tags: begin-concurrent) | |
| 11:05 | Version 3.48.0 (check-in: d2fe6b05 user: drh tags: trunk, release, major-release, version-3.48.0) | |
|
2025-01-13
| ||
| 13:32 | Remove a stray tab character from a comment. (check-in: 315079b1 user: drh tags: trunk) | |
| 11:28 | GCC 13 has become more quite pedantic about the signature of functions matching the type of pointers through which the functions are called. Make adjustments to extension functions and test procedures to work around this. No changes to the core. (check-in: ed83b791 user: drh tags: trunk) | |
|
2025-01-11
| ||
| 16:28 | Fix harmless "implicit fall through" warnings that suddenly appeared when I upgraded to gcc-13. (check-in: 3e2875da user: drh tags: trunk) | |
| 14:43 | Better job at suppressing harmless scan-build warnings. This time testing and working. (check-in: c8479739 user: drh tags: trunk) | |
| 13:59 | Fix harmless scan-build warnings. Actually, this fixed nothing. The scan-build warnings persist. I should have tested before I checked in. Look for a follow-up shortly. (check-in: b93af6fe user: drh tags: trunk) | |
| 09:02 | Fix an age-old bug in the lower-level wasm/js helper bits which (A) caused removal of customized WASM func arguments/results conversion to silently fail and (B) triggered a legitimate warning in the Google closure toolchain. Reported in jaccwabyt ticket c5c296e85a7c01360820. (check-in: 99917a5b user: stephan tags: trunk) | |
|
2025-01-09
| ||
| 19:57 | Update the makefile so that it puts the amalgamation files in a subdirectory in the amalgamation-zip. Forum post b8dd1941e1. (check-in: cef8e88b user: drh tags: trunk) | |
| 14:10 | When removing an fts5 in secure-delete mode, defer setting the table version to SECUREDELETE until flushing data to disk. This prevents problems that can occur if there is a rollback or statement rollback operation. (check-in: c359e555 user: dan tags: trunk) | |
|
2025-01-08
| ||
| 20:43 | Fix another assert() failure in fts5. (check-in: 6da37893 user: dan tags: trunk) | |
| 15:54 | Fix a crash in fts5 that could occur if shadow tables are modified or removed. (check-in: c0b69109 user: dan tags: trunk) | |
| 12:51 | Cross-link and otherwise improve the various how-to-compile documents. No code changes. (check-in: 5e6ede92 user: drh tags: trunk) | |