/ Timeline
Login

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

1050 check-ins using file src/test_demovfs.c version 3efa2adf4f

2024-11-22
14:12
Makefile doc cleanups. No functional changes. (Leaf check-in: 64add0ac70 user: stephan tags: trunk)
13:47
Remove the libsqlite3.so.3 link from the installation process, as it now serves no functional purpose. We retain libsqlite3.so.0 (A) for compatibility with clients linked against legacy builds and (B) 0 is still valid as the library's ABI version. (check-in: 91bd9813e0 user: stephan tags: trunk)
13:22
Add links to the SONAME discussion at relevant places in auto.def and the makefiles. No functional changes. (check-in: c78dcc318a user: stephan tags: trunk)
12:29
Fix harmless scanbuild warnings caused by the introduction of the ".dbtotxt" command into the CLI by check-in [b43acf5a8cd4a5ef]. (check-in: 554d8fbd86 user: drh tags: trunk)
12:12
Fix some harmless scanbuild warnings in the shell. (Leaf check-in: 04d6124d34 user: drh tags: branch-3.47)
12:07
Fix some harmless scanbuild warnings in the shell. (check-in: 9ba1c9b505 user: drh tags: trunk)
12:00
Fix harmless compiler warning caused by [c77a4a42f2e3d164]. (check-in: 063690d2c5 user: drh tags: trunk)
11:27
Document that -nofollow does not work on Windows. Fix Windows symlink test cases for when the test suite is run as administrator. (check-in: 3f76388a47 user: drh tags: branch-3.47)
11:18
Bump the version number to 3.47.1 (check-in: b6942a0b2f user: drh tags: branch-3.47)
2024-11-21
20:57
Make ".scanstatus" an undocumented alternative name for ".scanstats" in the CLI. (check-in: f20688efc2 user: drh tags: trunk)
20:10
Fix a bug-in-waiting (one too few list elements) in [b6bd25bd769e]. (check-in: e527dcd016 user: stephan tags: trunk)
20:07
Add the --scanstatus configure flag to set -DSQLITE_ENABLE_STMT_SCANSTATUS. (check-in: b6bd25bd76 user: stephan tags: trunk)
15:53
Fix a JS test which was broken when OMIT_PROGRESS_CALLBACK was _not_ used. (check-in: fba23150b5 user: stephan tags: trunk)
01:50
Document that -nofollow does not work on Windows. Fix Windows symlink test cases for when the test suite is run as administrator. (check-in: 4de8a75ec5 user: drh tags: trunk)
2024-11-20
21:45
Cherrypick a couple of changes requested by Mozilla onto the 3.47 branch. (check-in: b50d20d795 user: drh tags: branch-3.47)
20:39
Fix compiler warnings caused by variable shadowing. (Leaf check-in: 211b305791 user: dan tags: fts5-tokendata-prefix)
20:26
Logging enhancements. And mark logs v=12. (Leaf check-in: 853f9cf453 user: dan tags: cf8f1552-commit-instr)
20:24
Merge the latest trunk fixes and makefile enhancements into the commit-and-continue branch. (Leaf check-in: 34cb6029cc user: drh tags: commit-and-continue)
18:49
Experimental change to omit writing frame checksums to the wal file. (check-in: 4d37067270 user: dan tags: cf8f1552-commit-instr)
17:47
Update logging version to "v=11". This should have been part of the previous commit. (check-in: e6663fab61 user: dan tags: cf8f1552-commit-instr)
16:21
New configuration option --dynlink-tools causes some command-line tools like sqldiff and sqlite3_analyzer to link against the libsqlite3.so system library rather than being built-in. Caution: sqlite3_analyzer requires the SQLITE_ENABLE_DBSTAT_VTAB compile-time option on its SQLite library in order to work, so do not use --dynlink-tools to build sqlite3_analyzer without it. (check-in: 314c606dd3 user: drh tags: trunk)
16:17
Use shared-library flags, not shared-object flags, to create shared libraries. This makes no difference on Linux, but is required for Mac. (Closed-Leaf check-in: bfaa3ee758 user: drh tags: link-tools-dynamically)
15:02
If a subquery is copied and then changes are made to the copy, be sure to give the copy a unique Select.selId value so that the original will not be substituted in place of the modified copy. (check-in: 16d46e1160 user: drh tags: branch-3.47)
14:59
Bug fix in the SubrtnSig logic from [c9a3498113074bbc], if a subquery is copied and then changes are made to the copy, be sure to give the copy a unique Select.selId value so that the original will not be substituted in place of the modified copy. [forum:/forumpost/0b9ded2f8428ac00|Forum post 0b9ded2f8428ac00]. (check-in: 19d1bede56 user: drh tags: trunk)
14:19
Provide the sqlite3ShowWhereTerm() interface callable interactively from a debugger, when compiling with SQLITE_DEBUG. (check-in: c77a4a42f2 user: drh tags: trunk)
11:37
Do not report an sqlite3_error_offset() for errors that occur inside of views or triggers, since the text of those elements is not part of the original query. (check-in: cb5ddebf79 user: drh tags: branch-3.47)
11:34
Do not report an sqlite3_error_offset() for errors that occur inside of views or triggers, since the text of those elements is not part of the original query. (check-in: bf66c6dfc2 user: drh tags: trunk)
2024-11-19
21:19
Add fix from [bfab759611b0] to sqltclsh. Remove some now-unneeded has_tclsh84/5 checks in cases where jimsh can be used. (check-in: 9d389b9983 user: stephan tags: link-tools-dynamically)
21:14
Add missing $TCL_LIBS to the link for sqlite3_analyzer. (check-in: bfab759611 user: drh tags: link-tools-dynamically)
20:23
Didn't work out; broke the build. Was: Add the ability to build certain tools dynamically linked to libsqlite3 instead of embedding their own copy of sqlite3.c. (Closed-Leaf check-in: 84bd96a6f1 user: stephan tags: mistake)
20:21
Rename --link-tools-dynamically to --dynlink-tools, per discussion. (check-in: 50b9f6fde4 user: stephan tags: link-tools-dynamically)
20:14
Move the in-comment-code commentary about --with-debug, from [7b14309be4], into the --help text for that flag, where it's readily visible. (check-in: c938e5d783 user: stephan tags: link-tools-dynamically)
19:47
Get sqlite3_analyzer optionally linking against libsqlite3.so instead of embedding sqlite3.c. Patch mkccode.tcl to accept digits in its IFDEF/IFNDEF checks and sqlite3_analyzer.c.in to only include sqlite3.c if -DINCLUDE_SQLITE3_C is passed to mkccode.tcl. (check-in: 80f3bf8c2e user: stephan tags: link-tools-dynamically)
19:16
Merge trunk into this branch. Fix a small jimtcl/tclsh regex incompatibility in mkccode.tcl. (check-in: 7fb3ebfec6 user: stephan tags: link-tools-dynamically)
18:26
Enhancements to tool/mkccode.tcl such that it recognizes -D command line arguments and can use them in internal IFDEF and IFNDEF macros. Update the tool/sqlite3_analyzer.c.in script such that it omits the SQLite amalgamation if -DSQLITE_ENABLE_DBSTAT_VTAB is defined. (check-in: 7fec209290 user: drh tags: trunk)
17:41
Revert linking the shell to the dll for reasons explained in new makefile comments. Move the --with-debug configure flag into the developer options set and add commentary about why it should never be used for production builds. (check-in: 7b14309be4 user: stephan tags: link-tools-dynamically)
17:32
Extra logging for the freelist and hash table components of COMMITs of BEGIN CONCURRENT transactions. (check-in: 2ba41da8c4 user: dan tags: cf8f1552-commit-instr)
16:40
Reformulate sqldiff deps and rules so that the target matches the resulting file name, to avoid rebuilding it on every make invocation. Apply the same treatment to the sqlite3 CLI shell. (check-in: 9a17b83f85 user: stephan tags: link-tools-dynamically)
15:20
Initial configure support for linking certain binaries to libsqlite3.so instead of embedding it dynamically (which they typically do). This currently applies only to sqldiff, but support for adding the same for other tools is planned. This requires disabling the soname because setting it causes the build to link to whatever libsqlite3.so.0 is installed system-wide, so the soname now defaults to off. (check-in: 9192c146e2 user: stephan tags: link-tools-dynamically)
11:58
Fix a problem handling OOM errors in fts3 that could occur when parsing multi-token strings. (check-in: 4c4d1db00b user: dan tags: trunk)
2024-11-18
21:15
Merge recent trunk changes into the reuse-schema branch. (Leaf check-in: 63bac8dd71 user: drh tags: reuse-schema)
20:44
Merge the divergence reduction into the bedrock branch. (Leaf check-in: e03dd0bd31 user: drh tags: bedrock)
20:30
Continue to reduce divergence between wal2 and trunk. (Leaf check-in: 9591ab7c6b user: drh tags: wal2)
18:49
Realignment of begin-concurrent with trunk. (Leaf check-in: 3823295299 user: drh tags: begin-concurrent)
18:45
Reduce divergence from trunk. (check-in: c5d77671c4 user: drh tags: begin-concurrent)
18:45
Reduce divergence from begin-concurrent. (check-in: 84d41e9d04 user: drh tags: trunk)
18:27
Realign trunk and wal2. (check-in: dcf2768720 user: drh tags: wal2)
18:03
Attempt to reduce divergence from trunk. (check-in: ffe9f9ccd7 user: drh tags: wal2)
17:05
Attempt to reduce divergence with the wal2 branch. (check-in: e0d8f9916c user: drh tags: trunk)
16:52
Realign the begin-concurrent branch with trunk. (check-in: b92c9a66ba user: drh tags: begin-concurrent)
16:44
Attempt to reduce divergence from trunk. (check-in: ae863439e8 user: drh tags: begin-concurrent)
16:44
Attempt to reduce divergence with begin-concurrent. (check-in: f783d90187 user: drh tags: trunk)
15:51
Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 00d021eda4 user: drh tags: reuse-schema)
15:34
Merge the latest trunk changes into the bedrock branch. (check-in: 59a7eb297c user: drh tags: bedrock)
15:30
Merge the latest trunk changes into the wal2 branch. (check-in: d19aeff609 user: drh tags: wal2)
15:18
Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 680a2eaabb user: drh tags: begin-concurrent)
14:54
Disable commit-and-continue tests under the inmemory-journal and journaltest permutations. (check-in: 2f31c2b0a1 user: drh tags: commit-and-continue)
14:15
Remove the .POSIX entries from the makefiles because they cause portability problems rather than solve them. (check-in: e1330ecf17 user: stephan tags: trunk)
14:08
Fix a "applying zero offset to null pointer" usan error in the fts5 trigram tokenizer. (check-in: 9b79b999d4 user: dan tags: trunk)
13:29
Fix minor problems in testrunner.tcl that pop up when the command-line arguments are such that no tests are run. (check-in: 321ded32f6 user: drh tags: trunk)
11:49
The COMMIT AND CONTINUE TRANSACTION syntax is disabled by default. Enable it using the SQLITE_DBCONFIG_CONTINUE_TRANSACTION configuration option. (check-in: a2b784cb87 user: drh tags: commit-and-continue)
11:14
Fix a typo in a variable name. (check-in: 9c7f569acd user: drh tags: commit-and-continue)
2024-11-17
23:53
Fix an uninitialized variable that appears to be the cause of the problems with check-in [80b98446fc070d9a]. (check-in: 22393c3a08 user: drh tags: commit-and-continue)
11:46
Merge the latest trunk enhancements into the commit-and-continue branch. (check-in: 1742af1215 user: drh tags: commit-and-continue)
11:42
Make the --vfstrace output from the CLI go to the same output channel as everything else. (check-in: f71d490020 user: drh tags: trunk)
09:51
buildtclext.tcl: add docs explaining the DESTDIR check and break out of the auto_path search loop early if the DESTDIR is not writable, rather than re-checking that repeatedly. (check-in: 322be94569 user: stephan tags: branch-3.47)
09:49
buildtclext.tcl: add docs explaining the DESTDIR check and break out of the auto_path search loop early if the DESTDIR is not writable, rather than re-checking that repeatedly. (check-in: d07be336ea user: stephan tags: trunk)
2024-11-16
23:32
Add simple test cases. In doing so I found that the feature does not work on a Linux ramdisk, nor on Win11. Gotta fix that. (check-in: 80b98446fc user: drh tags: commit-and-continue)
18:59
Merge all the latest trunk enhancements into the commit-and-continue branch. (check-in: d217b4847e user: drh tags: commit-and-continue)
18:54
Call fflush() on ".echo" output from the shell, so that the output to stdout is aligned with output to stderr. (check-in: c38b9db3c4 user: drh tags: trunk)
18:37
Clean up the implementation now that it only has to deal with the much simplier concept of COMMIT AND CONTINUE TRANSACTION. (check-in: 17360660bb user: drh tags: commit-and-continue)
17:39
Fix argument expansion in sqlite-tclsh on Windows such that if an argument does not match a filename even after glob expansion, it is appended to the argument list verbatim. (check-in: cd942dce14 user: drh tags: trunk)
17:12
Handle DESTDIR at an earlier phase in buildtclext.tcl to account for the is-writable-dir check and to filter out //zipfs: dirs as (im)possible installation targets. (check-in: 2f6e5946cf user: stephan tags: branch-3.47)
17:09
Handle DESTDIR at an earlier phase in buildtclext.tcl to account for the is-writable-dir check and to filter out //zipfs: dirs as (im)possible installation targets. (check-in: d2e8c161a1 user: stephan tags: trunk)
14:40
Simplify the new syntax to be just "COMMIT AND CONTINUE TRANSACTION". (check-in: 61797109a2 user: drh tags: commit-and-continue)
14:33
Add DESTDIR support to the tclextension-install target, via [67a3ca0c013b] and [d1663cf05f7d]. (check-in: 38136b33f9 user: stephan tags: branch-3.47)
14:30
Add the --destdir flag to the tclextension-install makefile target. (check-in: d1663cf05f user: stephan tags: trunk)
14:29
Add --destdir flag support to buildtclext.tcl, but do not yet add that to the makefile (so that this change can be cherrypicked to the 3.47 build). (check-in: 67a3ca0c01 user: stephan tags: trunk)
10:42
Rename tool/tclConfigShToTcl.sh to tool/tclConfigShToAutoDef.sh in the name of pedantic correctness. (check-in: a7dd196d99 user: stephan tags: trunk)
09:00
configure: tiny simplification of proj-assert. (check-in: bfdc416b56 user: stephan tags: trunk)
2024-11-15
20:42
Load all the latest trunk enhancements, and especially the enhancements to vfstrace, into the commit-and-begin branch. (check-in: 605889b021 user: drh tags: commit-and-continue)
20:39
Enhance the vfstrace extension such that the output can be controlled using the "PRAGMA vfstrace('...');" statement. See header comment on the source code for details. (check-in: 96105d3359 user: drh tags: trunk)
19:42
In the interest of minimizing downstream disruption, set the soname of libsqlite3.so to (by default) its legacy value of libsqlite3.so.0 and unconditionally create (or replace) a symlink with that name at install-time, in addition to the newer-named symlinks. (check-in: 0773677b55 user: stephan tags: trunk)
17:28
Another approach at implementing COMMIT AND BEGIN. (check-in: a905bd5dd6 user: drh tags: commit-and-continue)
16:35
Generic auto.def cleanups. No functional differences. (check-in: 02aceb8c13 user: stephan tags: trunk)
15:31
buildtclext.tcl: work around a case, reported in [forum:0683a49cb02f31a1|forum post 0683a49cb0], in which package maintainers edit their copy of tclConfig.sh to change the TCL_SHLIB_LD command. (check-in: e24a3efec8 user: stephan tags: trunk)
10:53
configure: add optional pkg-config support for detecting ICU. (check-in: 3e5b8077c6 user: stephan tags: trunk)
10:47
When checking pkg-config for ICU support use icu-io instead of icu-uc, as that contains all requires libs on Linux and BSD. (Closed-Leaf check-in: 6ca457542e user: stephan tags: autosetup-icu-pkg-config)
10:12
configure script doc additions for the ICU feature check. (check-in: 1925a68fc2 user: stephan tags: trunk)
10:07
An experiment in optionally using pkg-config to determine the libs to link in for ICU support, but its ldflags is missing one required lib on both Linux and OpenBSD. Keeping this for later reference, as it demonstrates how to use pkg-config from autosetup. (check-in: 09caa94c9e user: stephan tags: autosetup-icu-pkg-config)
2024-11-14
22:59
Attempt to hold a lock across the COMMIT AND BEGIN boundary so that no other process can start a new transaction in between the COMMIT and the BEGIN. (check-in: bc8bcc53ff user: drh tags: commit-and-continue)
19:59
Fix assertion faults in the COMMIT AND BEGIN path. (check-in: a9a4ac17c2 user: drh tags: commit-and-continue)
19:36
Merge more makefile enhancements from trunk into the commit-and-begin branch. (check-in: 098400d361 user: drh tags: commit-and-continue)
19:34
Fix typo in the handling of the new --dev flag which caused it to set the --debug flag instead of the --with-debug flag (the former is for autosetup's internal use). (check-in: 81202d2ab5 user: stephan tags: trunk)
19:25
Remove $prefix/include from the default -I path because it can cause the build to pick up an unintended copy of sqlite3.h. Extend the ICU configure support (the origin of -I$prefix/include) to enable fetching the -I path from icu-config and apply it only to those objects which need it. (check-in: f778dfdd6d user: stephan tags: trunk)
19:08
Merge makefile enhancements from trunk into the commit-and-begin branch. (check-in: b5dd11e0ac user: drh tags: commit-and-continue)
19:06
Add new makefile target "sqlite3d" (where the "d" means either "development" or "debug") that always uses separate source files, regardless of the --disable-amalgmation setting. (check-in: 91da205beb user: drh tags: trunk)
17:52
Add --enable-dev configure flag which sets various other flags. (check-in: ea79c363a4 user: stephan tags: trunk)
17:25
Merge the latest trunk enhancements and fixes into the commit-and-begin branch. (check-in: 05fb5d3075 user: drh tags: commit-and-continue)
16:06
Remove unused sqlite_cfg.h.in from the build. (check-in: bba54e26de user: stephan tags: trunk)
16:00
Fix a state makefile dependency which refered to the now-removed sqlite_cfg.h.in. (Closed-Leaf check-in: 9a726b4be8 user: stephan tags: makefile-simplification)
15:55
Remove some obsolete macros from the CLI. (check-in: 5c4eb62570 user: drh tags: trunk)
15:25
Remove unused sqlite_cfg.h.in (sqlite_cfg.h gets generated without an input template). (check-in: 6148f2d392 user: stephan tags: makefile-simplification)
14:38
Fix a problem with window functions min() and max() when used with a FILTER clause. Forum post [forum:/forumpost/e9126d554a | e9126d554a]. (check-in: d15fb0f75e user: dan tags: trunk)
12:23
Document the if block at the end of sqlite-check-tcl. (check-in: 6bfd09408b user: stephan tags: trunk)
12:09
configure: avoid performing multiple checks for -lm on behalf of --enable-fts4 and --enable-fts5. (check-in: 6940caa192 user: stephan tags: trunk)
12:03
Early prototype code for COMMIT AND BEGIN. Does not currently work. (check-in: ddac597321 user: drh tags: commit-and-continue)
2024-11-13
18:23
Enhance the vfstrace.c extension to show symbolic names for the various SHM locks. (check-in: c0dd7de8f1 user: drh tags: trunk)
18:04
Fix a memory leak in the ".dump" command of the CLI that can occur if an error other than database corruption is seen while trying to query the database. (check-in: 2560cc7072 user: drh tags: trunk)
16:08
Add the test/fork-test.c test program. (check-in: 0611e2b0cf user: drh tags: trunk)
14:58
Add the SQLITE_FCNTL_NULL_IO file-control. (check-in: f0e917fcf5 user: drh tags: trunk)
14:42
Increase maximum length of sqlite3_log() messages to 700 bytes. Mark log messages as v=10. (check-in: 35aa893d45 user: dan tags: cf8f1552-commit-instr)
11:12
Optimize deferred allocation of pages on this branch by avoiding BTALLOC_LE. (check-in: e0c0176793 user: dan tags: cf8f1552-commit-instr)
2024-11-12
13:37
Ensure that the sqlite3_index_info.idxStr string coming back from FTS5 is always zero-terminated, even if the xBestIndex call fails with an SQLITE_CONSTRAINT error. (check-in: a4e976a030 user: drh tags: trunk)
2024-11-11
21:11
Clarify the documentation to make it clear that rows inserted by a CREATE TABLE AS SELECT statement are not counted by sqlite3_count64(). [forum:/forumpost/1e6cde5648|Forum post 1e6cde5648]. (check-in: 5c5982e393 user: drh tags: trunk)
21:07
Adjust the behavior of sqlite3_changes64() so that it counts INSERTs into a new table created using "CREATE TABLE name AS SELECT ...". It has never done this before. The documentation is a little ambiguous about whether or not it actually should. This check-in is on a branch because it will probably never make it to trunk for fear of breaking some legacy program. (Closed-Leaf check-in: b741608cd3 user: drh tags: chngcnt-create-as)
19:49
Fix the fts5 trigram tokenizer so that it handles non-nul-terminated strings. (check-in: 84f4e37178 user: dan tags: trunk)
19:07
Add the ".dbtotxt" command to the CLI. (check-in: b43acf5a8c user: drh tags: trunk)
18:15
Wrap some exceptionally long lines in main.mk. Add option to override LDFLAGS on the sqlite3.dll target. Audit: all targets for which it is hypothetically relevant can now inherit user-supplied LDFLAGS, but only those provided to the configure script, not at make-time, in order to mimic the historical build's restriction in that regard. (check-in: 073080cae3 user: stephan tags: trunk)
18:11
Optimize deferred allocation of pages on this branch by avoiding BTALLOC_LE. (check-in: 0812161025 user: dan tags: begin-concurrent)
17:03
Update this branch with latest changes and build system updates from trunk. (check-in: 52bd7953f1 user: dan tags: begin-concurrent)
17:02
Use Win32 APIs to read/write the console in Windows unless the SQLITE_USE_STDIO_FOR_CONSOLE option is defined. This is an attempt to get the build working on MinGW. (check-in: abfe488ed6 user: drh tags: trunk)
13:17
Add an -fsanitize=fuzzer compatibility mode to the CLI. (Leaf check-in: d85f14c713 user: drh tags: cli-fuzz)
09:53
Doc update to account for [05073350087b]. (check-in: b81976c520 user: stephan tags: trunk)
09:37
Rename proj-define-if-opt-truthy to the more accurate, and less verbose, proj-define-for-opt. (check-in: 0507335008 user: stephan tags: trunk)
2024-11-09
18:17
Fix a case in fts3 where a corrupt database record was not being handled correctly. (check-in: 17bc57fa16 user: drh tags: branch-3.47)
17:54
Fix a case in fts3 where a corrupt database record was not being handled correctly. (check-in: cbcb53759b user: dan tags: trunk)
14:34
Fix a deps problem, introduced in [1bd9de719], which breaks the build on systems where HAVE_TCL=0. (check-in: 7953a8bdcb user: stephan tags: trunk)
10:23
Simplify usage of proj-assert by making the expr prefix implicit. Add an optional description arg to proj-assert, defaulting to the body of the assertion script. (check-in: ada7b36c37 user: stephan tags: trunk)
09:19
Remove three unused files from autosetup/. (check-in: 906563a7e0 user: stephan tags: trunk)
06:35
Remove an unused lib import from auto.def. (check-in: 53a71981ab user: stephan tags: trunk)
2024-11-08
20:57
Increase the minimum SQLITE_LENGTH_LIMIT from 1 to 30 to avoid problems doing simple things like converting strings into integers. See also [8fd5b8ec4ab9b555]. (check-in: 6aa01707af user: drh tags: trunk)
20:44
Fix an assert() failure in sqlite3recover.c. (check-in: f52bb19281 user: dan tags: trunk)
17:09
Even more detailed logging of slow COMMIT statements. (check-in: 3a45387a09 user: dan tags: cf8f1552-commit-instr)
14:34
Remove one dep from .tclenv.sh which is only valid for configure-driven builds, not static makefiles. (check-in: 22986767da user: stephan tags: trunk)
13:37
Add 'tcl' makefile target which builds all but tclextension (which does not have a well-defined name and dependencies). Improve the deps for .tclenv.sh to avoid getting a stale tclsh when re-configuring with a different --with-tcl(sh). (check-in: 1bd9de719b user: stephan tags: trunk)
08:01
Add missing CFLAGS.intree_includes to T.compile.tcl to fix build of tclsqlite3. (check-in: bb3c6dc126 user: stephan tags: trunk)
07:37
More closely emulate the legacy build's handling of LDFLAGS, permitting them to be passed to configure but not to make. We cannot 100% enforce that because main.mk is not filtered by the configure script, so we instead add a level of indirection to make passing of LDFLAGS=... to make a no-op. (check-in: d1af9f3183 user: stephan tags: trunk)
06:22
Support clients passing in LDFLAGS to configure/make, but in a more limited form than the legacy build it (i.e. only to select targets rather than all targets). Rename make-side internal uses of CFLAGS to CFLAGS.env for consistency with the new LDFLAGS.env. See discussion in [forum:5fcbea40f3|forum thread 5fcbea40f3]. (check-in: a5e07e8063 user: stephan tags: trunk)
05:26
Disable setting of the SONAME (enabled by [2a2419ef742]), as it's not clear whether blindly setting the SONAME, which now differs from its historical value, will cause more grief than it solves. Add a (disabled) experiment which permits setting (or not) the SONAME to the legacy or current values. This change is up for further change as experimentation proves whether we truly need/want the SONAME. See discussion in/around [forum:0c6fc6f46b2cb3|forum post 0c6fc6f46b2cb3]. (check-in: d931456805 user: stephan tags: trunk)
2024-11-07
18:06
Fix an OOB write that could occur in fts3 when dealing with corrupt database records. (check-in: 521b873be7 user: drh tags: branch-3.47)
17:34
Fix an OOB write that could occur in fts3 when dealing with corrupt database records. (check-in: 108863ec79 user: dan tags: trunk)
16:59
Extend the set of --flags which get cleared/unset when using --with-wasi-sdk. Enable the soname linker option for libsqlite3.so. (check-in: 2a2419ef74 user: stephan tags: trunk)
15:23
Doc touchups in the line-editing feature check code. (check-in: bb5656bdc9 user: stephan tags: trunk)
15:04
tcl configuration: --with-tcl=prefix is equivalent to passing the --prefix dir to it. If --with-tcl or --enable-tcl are explicitly passed in and tclConfig.sh is not found, fail fatally. When TCL is either explicitly disabled or default search for it fails non-fatally, be more explicit about which components are not available. (check-in: c5389d39a9 user: stephan tags: trunk)
12:03
Further improvements to the ".mode json" output in the CLI. (check-in: 6201b5707f user: drh tags: trunk)
10:07
Autosetup doc touchups. (check-in: 5745152900 user: stephan tags: trunk)
09:36
Extend the list of "truthy" config values to include "true". Related doc updates. (check-in: 4455718e48 user: stephan tags: trunk)
08:57
Add some internal docs to auto.def explaining certain passages. (check-in: 4749967e1b user: stephan tags: trunk)
08:29
Document the purpose of a global auto.def var added in [0d558318172d]. (check-in: f5b6604716 user: stephan tags: trunk)
07:31
When --with-linenoise refers to the msteveb flavor and jimsh is the TCL used for code generation, enable linenoise in jimsh. Remove some dead auto.def code. (check-in: 0d55831817 user: stephan tags: trunk)
06:02
Add mention of file-isexec in autosetup/README.md. (check-in: f469356749 user: stephan tags: trunk)
06:00
Change several 'file exists' checks for tclsh to file-isexec because that checks for .exe extensions on Windows. (check-in: 052a1b4d7c user: stephan tags: trunk)
05:26
For platforms where tclsh is found but tclConfig.sh is not, set HAVE_TCL to 0. We can't build the TCL components on those. Problem reported in [forum:5106aee3a8|forum post 5106aee3a8]. (check-in: 04d2576b2e user: stephan tags: trunk)
2024-11-06
19:19
Fix an FTS3 corruption test case that depends on the specific pseudo-random byte sequence generated by sqlite3_randomness(), which is different on big-endian platforms than it is on little-endian platforms. (check-in: 6216bfcb74 user: drh tags: trunk)
17:31
Merge latest trunk changes into this branch. (check-in: edb8423493 user: dan tags: fts5-tokendata-prefix)
16:20
Add tests for xInstToken() and prefix queries with various fts5 configurations. (check-in: 9cc04331a0 user: dan tags: fts5-tokendata-prefix)
12:58
Re-phrase some (#if !SQLITE_CORE) to (#ifndef SQLITE_CORE), as discussed in [forum:cea40371c5e34b09 | forum post cea40371c5e34b09]. (check-in: 5495b12569 user: stephan tags: trunk)
12:13
Elaborate on how autosetup selects a tclsh to use. (check-in: d3887895a3 user: stephan tags: trunk)
10:09
Fix typo in the LICENSE.md file. (check-in: 0588cc5c2f user: drh tags: trunk)
08:29
Minor doc tweaks. (check-in: 2919a61bd4 user: stephan tags: trunk)
07:20
When constructing the auto-reconfigure commands, only quote args which look like they need it. Minor doc updates. (check-in: d4fbd34f7a user: stephan tags: trunk)
06:44
Minor doc tweaks and typo fixes. (check-in: 406d9122b7 user: stephan tags: trunk)
06:06
Split the motivation of the makefile var naming convention into its doc own section. (check-in: bf42b93cc7 user: stephan tags: trunk)
05:54
Add a section to autosetup/README.md describing the motivations for the more glaring design decisions. (check-in: c0940a822a user: stephan tags: trunk)
04:38
Add autosetup/README.md - maintenance-related docs for SQLite developers (e.g. how to update autosetup). Start marking up the proj.tcl APIs with autosetup's doc markup so that they appear in the ./configure --reference output. (check-in: aa6213767f user: stephan tags: trunk)
02:59
Enhance the --with-emsdk flag to use a default value of 'auto', meaning to search the environment for it, and to fail fatally if --with-emsdk is explicitly provided but the SDK is not found. (check-in: 9724b747ca user: stephan tags: trunk)
2024-11-05
23:26
Improve the ".mode json" output of the CLI so that it encodes U+007f using an escape sequence. (check-in: 8b58cf9bbd user: drh tags: trunk)
18:53
Have the xBestIndex method of the generate_series virtual table ignore contraints on the "value" column with usable=0. (check-in: 1333e54422 user: dan tags: branch-3.47)
18:25
Have the xBestIndex method of the generate_series virtual table ignore contraints on the "value" column with usable=0. (check-in: f5113a2ef8 user: dan tags: trunk)
13:34
Work around a TCL {list-quoting} quirk when escaped/deferred var derefs are passed in as values to the autotools-conventional --XYZdir flags (as seen in a downstream package build script). (check-in: 6adfca7e85 user: stephan tags: trunk)
13:03
Remove the --enable-rbu flag from the configure script, per /chat discussion, because it's a highly niche feature not in active use. (check-in: 77db0cd736 user: stephan tags: trunk)
11:59
Ensure that the one-line running status output from testrunner.tcl does not exceed the 80-char line width of a standard terminal. (check-in: 1eae0f9ed3 user: drh tags: trunk)
09:49
auto.def: remove an extraneous global var, some dead tcl/makefile code/comments, and some extraneous output. Rename an internal-use proc. Disable the ext/wasm cleanup in the top-level (dist)clean because the noise from gmake is irritating. (check-in: ee9eb8b157 user: stephan tags: trunk)
08:21
Enhance the rpath configure check to honor --exec-prefix=... Remove some debugging code and move other debugging code around. (check-in: a8c1a82b56 user: stephan tags: trunk)
08:14
Roll back [47e50fa84dacf83c] for consistency with the legacy build. sqlite3.pc is now generated equivalently to prior versions. (check-in: af79d11e38 user: stephan tags: trunk)
07:55
Add the --enable-rbu configure flag and building of the commented-out rbu binary. (check-in: 6c6fa3adfe user: stephan tags: trunk)
07:29
Remove some dead makefile code. (check-in: b69ce89d22 user: stephan tags: trunk)
02:38
Change a (#define HAVE_FCHMOD) to (#define HAVE_FCHMOD 1) per user request in [forum:24cf6020c6|forum post 24cf6020c6]. There's no semantic change for this tree, but this is consistent with how auto-config tools would define it and the empty #define interferes with some downstream code. (check-in: 9c46d84f3b user: stephan tags: trunk)
02:14
sqlite3_stdio.c now uses sqlite3_malloc()/sqlite3_free() instead of malloc()/free(). Reported in [forum:6b6cb3ddc8a89b55|forum post 6b6cb3dd]. (check-in: 1982471da1 user: stephan tags: trunk)
2024-11-04
20:16
Fix the percentile extension so that works as an independent extension. [forum:/forumpost/ab25469a350e0488|Forum post ab25469a350e0488] (check-in: 27b829c344 user: drh tags: trunk)
19:18
Fix harmless compiler warnings. (check-in: bc93e17924 user: drh tags: trunk)
19:08
Ensure that the database encoding is detected before the code generator gets too far down into byte-code generation and execution, but not so early that it interferes with initialization. [forum:/forumpost/bc75a4d20b756044|Forum thread bc75a4d20b756044]. (check-in: af7173a10e user: drh tags: trunk)
16:59
Avoid loading the entire record into memory for an sqlite3_preupdate_old() call that retrieves an IPK value. (check-in: 7f4de43733 user: dan tags: trunk)
13:59
Fix two mismatched uses of malloc() and sqlite3_free() in sqlite3_stdio.c, as reported in [forum:7dd7c70038 | forum post 7dd7c70038]. (check-in: 5238959d05 user: stephan tags: branch-3.47)
13:57
Fix two mismatched uses of malloc() and sqlite3_free() in sqlite3_stdio.c, as reported in [forum:7dd7c70038 | forum post 7dd7c70038]. (check-in: af0a345b3b user: stephan tags: trunk)
12:11
Fix typo of --libexec ==> --libexecdir, discovered via audit of a downstream build script. Unrelated doc touchups. (check-in: a60e5d76d0 user: stephan tags: trunk)
10:16
Ensure that the ext/wasm fiddle build undefines certain shell feature flags which it cannot use but might be inherited from the top-level makefile. (check-in: 99bb5d9b68 user: stephan tags: trunk)
08:29
When installing the shared lib, re-activate the accommodation of legacy-style .so links (removed in [80584e165e4]) based on two reports that not having those will cause all clients linked against the legacy naming convention to fail to dynamically link (which would preclude an update of a system-level libsqlite3 package). Set up the infrastructure needed for adding an SONAME to the library but do not yet activate it. See discussion in/around [forum:046133a7da|forum post 046133a7da]. (check-in: 1586eaceb1 user: stephan tags: trunk)
06:38
Minor internal doc additions. (check-in: 9edc8582c9 user: stephan tags: trunk)
05:27
Latest upstream autosetup to get handling of (==ignoring) autotools' x-includes and x-libraries flags and stop leakage of some autosetup-init-level vars into auto.def's global scope. (check-in: 307349bf91 user: stephan tags: trunk)
04:12
Latest upstream jimsh0.c, which accounts for the problem patched locally by [29b944959568]. (check-in: c7a5b7d2db user: stephan tags: trunk)
03:43
Minor doc correction and proj.tcl-internal API renaming. (check-in: c8b24c590e user: stephan tags: trunk)
2024-11-03
21:32
Move the .default-CFLAGS handling into a utility function, rename the corresponding file to .env-VAR, and apply that lookup to a couple more places. (check-in: f01b61f21d user: stephan tags: trunk)
20:15
Fix a CFLAGS.jimsh typo in Makefile.in. Change default jimsh flags to include -O1, which slows down its build but speeds up its runtime considerably. (check-in: a912c16915 user: stephan tags: trunk)
19:42
If any autotools-conventional dir names are explicitly overridden via ./configure --dirname=X then export those names as-is to the makefile, otherwise derive them from $prefix. This is, at least in part, a compromise to provide package maintainers a way to specify a libdir which will be incorporated into the -rpath link flag (which we can only determine at configure-time). (check-in: 832abe8a8a user: stephan tags: trunk)
18:30
Workaround for a compiler-specific jimsh compilation error reported in [forum:18e420d0b1404d63|forum post 18e420d0]. Reported upstream as ticket #322. (check-in: 29b9449595 user: stephan tags: trunk)
07:45
Minor doc updates. Remove two outdated todos. (check-in: ad19237845 user: stephan tags: trunk)
05:33
Fix another T.exe typo and remove an outdated TODO. (check-in: 02208e6bfa user: stephan tags: trunk)
01:31
Fix T.exe typos in main.mk which break installation on platforms where that value is not empty. Also some unrelated doc tweaks. (check-in: ab97ff44e6 user: stephan tags: trunk)
2024-11-02
19:10
Allow an fts5 table or query to be configured to collect xInstToken data for any prefix terms as part of the first parse of the main index, if any. (check-in: 46929ae92b user: dan tags: fts5-tokendata-prefix)
05:50
An experiment in hybridizing overriding of autotools-conventional XYZdir vars, the goal being to be able to provide both overrriding of them at configure-time and make-time with sensible semantics. Based on notes from [forum:00d12a41f7|forum post 00d12a41f7]. (Closed-Leaf check-in: cc259bf5f1 user: stephan tags: autosetup-dir-overrides)
03:34
Add autotools-compatible overridable dir name vars for the various installation targets, calculated at make-time instead of exported at configure-time for reasons explained at length in the accompanying comments. (check-in: 24aba7ee58 user: stephan tags: trunk)
2024-11-01
19:41
Merge latest trunk changes into this branch. (check-in: 790c56d493 user: dan tags: fts5-tokendata-prefix)
15:25
Update log messages to say "v=8" instead of "v=7". (check-in: 492a0a8543 user: dan tags: cf8f1552-commit-instr)
15:20
Still more logging, this time focused on the sqlite3WalFrames() function. (check-in: 52d332f0c7 user: dan tags: cf8f1552-commit-instr)
09:50
Merge the readonly-ignore-wal-jrnl enhancement into the reuse-schema branch, so that it can be found there in all future releases. Other recent trunk enhancements are also part of that change and are merged as well. (check-in: 4e4885a067 user: drh tags: reuse-schema)
01:56
When configuring with --with-wasi-sdk, ensure that we use that SDK's 'ar' tool instead of whatever is in the PATH. When pushing/popping the define var scope for the jimsh compatility check, include more defines per consultation with autosetup's creator. (check-in: 2dcc465a70 user: stephan tags: trunk)
2024-10-31
18:29
In testrunner.tcl, only show the ETC on the status line if it will fit within the 80-character line limit. (check-in: 45a3213d23 user: drh tags: trunk)
17:38
Fix the clean-autosetup target in Makefile.in so that it does not fail even in cases where gmake is unavailable. (check-in: 207ca21bd7 user: drh tags: trunk)
17:23
Extra defenses against UAF when failing to allocate a transient cursor. No known path to a UAF currently exists. This change just helps with the static analysis to prove it. (check-in: bae0581111 user: drh tags: trunk)
15:59
Update this branch so that it works with ZipVFS. (Closed-Leaf check-in: 68eb7a64d0 user: drh tags: reuse-schema-ro-waljrnl)
15:40
Update this branch so that it works with ZipVFS. (Closed-Leaf check-in: bc71b0a0b3 user: dan tags: readonly-ignore-wal-jrnl)
11:53
When building a shared library on Mac, one must specify the original *.o files that go into that library. It does not work to specify a prior shared library containing a subset of the files to be included. (check-in: 5adc7d5dab user: drh tags: trunk)
11:21
Omit unnecessary bold text in ./configure output. (check-in: d1368dc12b user: drh tags: trunk)
11:19
Improved differentiation between antirez and msteveb linenoise. (check-in: cfb4bfcf14 user: drh tags: trunk)
11:04
The presence or absence of the linenoise-ship.c source file is sufficient to differentiate Antirez linenoise from MSteveB linenoise. (Closed-Leaf check-in: 28cc77b916 user: drh tags: linenoise-detection)
09:25
Add a missing 'close' call to proj-file-content-list. (check-in: 005702f334 user: stephan tags: trunk)
08:12
Add -trim flag to proj-file-content. (check-in: babf66f5c7 user: stephan tags: trunk)
08:03
Remove some proj-assert checks which are not valid on OpenBSD. Ensure that queued up notices about TCL warnings are displayed before leaving sqlite-check-tcl. (check-in: 3447308f3f user: stephan tags: trunk)
07:30
When reading in .default-CFLAGS, trim it. (check-in: a62a5171ac user: stephan tags: trunk)
07:20
Add the .POSIX special target to the main makefiles to hint to the make impl that it should behave POSIXly-correct. Fix the default file extension for static libs in main.mk. (check-in: 2c615d3a32 user: stephan tags: trunk)
07:01
Add more deps to T.tcl.env.sh so that it gets rebuilt if configure is run with a different --with-tcl value. Remove all references to the superfluous XYZdir makefile vars conventionally set by the autotools (they're just noise in this build). (check-in: 831665101e user: stephan tags: trunk)
06:52
If a file named .default-CFLAGS exists in the build dir, use its contents as the default value of the CFLAGS unless it's overridden by being passed in or in the environment. (check-in: 731d333c22 user: stephan tags: trunk)
06:38
When --with-wasi-sdk is active, temporarily swap CC and CC_FOR_BUILD for purposes of looking for APIs required by B.cc. (check-in: 435f2ee818 user: stephan tags: trunk)
05:47
Change default CFLAGS to {-g -O2} to match the legacy build. (check-in: 5117749429 user: stephan tags: trunk)
01:51
Fix a corner case in automatic TCLLIBDIR detection: if the $auto_path list is not empty but none of them refer to an existing dir, the last dir in that list would have been accepted as the TCLLIBDIR. It will now error out instead. (check-in: 1d2ecae130 user: stephan tags: trunk)
00:56
Reimplement how the TCL-related environment vars are made available to make recipes which need them, reducing the console noise and consolidating it with the has_tclconfig flag file. It now uses a generated shell snippet which it sources, rather than inlining all of that shell code. (check-in: 0cdfd142e1 user: stephan tags: trunk)
2024-10-30
23:10
Minor cleanups to the linenoise flavor detection test. (check-in: 3be32de162 user: stephan tags: trunk)
22:49
Move the linenoise flavor check from auto.def to proj.tcl for re-use in downstream projects. (check-in: 84e503dc1e user: stephan tags: trunk)
22:41
Expand [c0048e4482e9] to determine the linenoise API flavor via a compile test rather than guessing based on the filename. (check-in: dbf0079190 user: stephan tags: trunk)
22:09
proj.tcl/main.mk doc updates. No functional changes. (check-in: e06574c6b4 user: stephan tags: trunk)
19:13
Adjust Makefile.in to honor the CC environment variable. Add the "show-variables" target to main.mk, for debugging. (check-in: e5f1a01f9f user: drh tags: trunk)
18:24
Add extra logging to analyze COMMIT commands. (check-in: 7dbb43bd30 user: dan tags: cf8f1552-commit-instr)
14:24
Merge the readonly-ignore-wal-jrnl feature into a sub-branch of reuse-schema. (check-in: 67087fe433 user: drh tags: reuse-schema-ro-waljrnl)
14:03
Fix the CLI so that it can use either the canonical Antirez linenoise (with HAVE_LINENOISE=1) or Steve Bennett's enhanced linenoise that works on the Win32 console as well as on Unix (with HAVE_LINENOISE=2). The ./configure script detects which one to use and sets HAVE_LINENOISE accordingly. (check-in: c0048e4482 user: drh tags: trunk)
13:47
Require the SQLITE_ENABLE_READONLY_WALJOURNAL pre-processor macro to activate the new feature on this branch. (check-in: 21ed4e7886 user: dan tags: readonly-ignore-wal-jrnl)
11:21
Merge latest trunk changes into this branch. (check-in: 403e01b03c user: dan tags: readonly-ignore-wal-jrnl)
11:21
Fix a problem that could occur if a read-only connection switches its journal mode from "persist" to "off" or "memory" when the file-system contains a hot-journal created by a "PRAGMA journal_mode = wal" command. (check-in: 85b5ed0253 user: dan tags: readonly-ignore-wal-jrnl)
05:07
Clean up and add docs to the TCL vetting steps. Make warning and error messages bold if stdout isatty. (check-in: 47157dcf9e user: stephan tags: trunk)
04:07
Remove accommodation of the legacy-named shared libraries from the installation rules, per discussion. Rename install-includes to install-headers. Quote installation target dir names "just in case". (check-in: 80584e165e user: stephan tags: trunk)
03:51
Generic makefile cleanups. (check-in: 6f86ff2e8c user: stephan tags: trunk)
02:06
Re-enable exporting of TCLLIBDIR at configure-time so that clients can override it once there rather than having to override it on an arbitrary number of make invocations (which they can still do, but now need not). Based on feedback in [forum:38f6988e57b738e5|forum post 38f6988e57b]. (check-in: ee6e15f12e user: stephan tags: trunk)
01:47
When calculating the TCLLIBDIR in main.mk, allow the user to override it using an environment var or make var assignment, per feedback in [forum:38f6988e57b738e5|forum post 38f6988e57b]. (check-in: 838633182c user: stephan tags: trunk)
00:35
Replace 3 instances of the == 'test' shell command operator with =, as == is apparently not as portable across shells. Problem reported in [forum:14274389fb2|forum post 14274389fb2]. (check-in: 68199c40fe user: stephan tags: branch-3.47)
2024-10-29
23:42
Split the core-most CFLAGS, which should not be overridable (like -fPIC), into CFLAGS.core, so that went CFLAGS=... is passed on in a make invocation the -fPIC flag is not lost (as reported in [forum:39f8c54391d38c72 | forum post 39f8c543]). (check-in: f5899d22c6 user: stephan tags: trunk)
23:19
Try to detect if --with-readline-cflags is passed a non-cflags value, e.g. readline/readline.h, and fail loudly if it is. The legacy configure accepted that formulation but silently did nothing useful with it and that formulation now causes the auto-completion test to fail, as reported in [forum:f13b8e8f38402367 | forum post f13b8e8f38402367]. (check-in: c97f34d064 user: stephan tags: trunk)
20:27
General auto.def cleanups and docs. (check-in: e2f41c2540 user: stephan tags: trunk)
20:27
Add fault-injection tests for the new code on this branch. (check-in: 349b2d8957 user: dan tags: readonly-ignore-wal-jrnl)
19:34
Allow read-only connections to ignore hot journals created by "PRAGMA journal_mode = wal". (check-in: d003480db7 user: dan tags: readonly-ignore-wal-jrnl)
19:03
Reformulate the readline completion signature compatibility test so that -Wunused-variable in the CFLAGS does not cause it to fail. Problem reported via email. (check-in: 3891669a3f user: stephan tags: trunk)
18:50
Rename an almost-name-colliding auto.def function. Fix a refactoring-induced change which broke implicit lookup of tclConfig.sh. Add msg-debug proc to enable toggling of developer-level debug messages via a configure argument. (check-in: 265ba15df1 user: stephan tags: trunk)
17:55
Remove some extraneous configure output. (check-in: 2234569edb user: stephan tags: trunk)
14:22
Fix a typo in LICENSE.md (check-in: decc600348 user: drh tags: trunk)
08:42
When either --readline or --editline are explicitly provided but the corresponding feature is not found, fail fatally. If not explicitly requested, simply disable that feature if the lib is not found. (check-in: 1d24a29c6e user: stephan tags: trunk)
08:18
Minor --help text tweak. (check-in: 80ac10ed8d user: stephan tags: trunk)
08:14
Add proj-assert proc and add a couple of asserts to the editline/readline checks. (check-in: db9870caa8 user: stephan tags: trunk)
08:01
Teach configure --editline to report itself to shell.c as either HAVE_EDITLINE or HAVE_READLINE, depending on which headers are available (editline/readline.h or readline/readline.h, both of which work and some systems only have the latter), but then link against libedit regardless of which one shell.c thinks it is using. (check-in: 85077b20e6 user: stephan tags: trunk)
04:21
Remove LDFLAGS_LIBZ from sqlite3.pc.in (pkg-config) because it's not needed by the library, only the shell. Re-enable the notice about --disable-static only being partially true. (check-in: e03c564aff user: stephan tags: trunk)
03:29
Remove some dead auto.def code. Link tclsqlite3 shell against the .so instead of .a, analog to [45315f8f275d]. Move some header file tests which are only needed for jimsh into the jimsh compilability check block. (check-in: 9a259026ae user: stephan tags: trunk)
2024-10-28
22:35
Enclose the generated "sqlite3.c" and "sqlite3.h" in a single big #ifdef so that if they get truncated by more than a little whitespace, they will not compile and the truncation can be easily detected. (check-in: c3b624e2a9 user: drh tags: trunk)
19:19
Remove unnecessary install-sh and spec.template files. (check-in: 3acb6d789e user: drh tags: trunk)
18:41
Minor makefile formatting cleanups. No functional changes. (check-in: 10b2cfdccd user: stephan tags: trunk)
18:30
Calculate TCLLIBDIR in the makefile targets which use it, rather than via the configure script. This enables its use in static makefiles. (check-in: 6b1494cecb user: stephan tags: trunk)
17:30
Remove the ltmain.sh autotools remnant. (check-in: dad5eb9393 user: stephan tags: trunk)
17:27
Remove the never-used and never-documented and long-ago deprecated user-authentication feature option. [65884d4f81a4705b]. (check-in: 3a3f7bf430 user: drh tags: trunk)
17:20
Perform some makefile acrobatics to get the tclConfig.sh state applied for static makefiles. (check-in: 9b141d108b user: stephan tags: trunk)
16:31
The async extension was superseded by WAL mode about 11 years ago, and has long been deprecated. Remove it from the source tree. (Anybody who really needs it can still dig it out of the historical records.) (check-in: f98da150a9 user: drh tags: trunk)
16:28
Have sqlite3_rsync avoid write-locking the origin database. (check-in: b7eb653050 user: dan tags: trunk)
15:38
Omit the antiquated and long-unsupport async extension since it has been superseded by WAL mode for over a decade. (Closed-Leaf check-in: 10b1b86821 user: drh tags: omit-async)
14:53
Omit ext/consio from the tree. No longer needed or supported. (check-in: 1ce8507f73 user: drh tags: trunk)
14:46
Update Makefile.linux-generic to account for recent var renaming. (check-in: 6cb7cb7e33 user: stephan tags: trunk)
14:24
Link libtclsqlite3.so to libsqlite3.so, not libsqlite3.a. (check-in: 45315f8f27 user: stephan tags: trunk)
14:16
Rename the 'hwaci' auto.def utility API to the more generic 'proj' API, per /chat discussion. Fix a function name typo which caused readline detection to kill the configure in one code path. (check-in: e20610f06b user: stephan tags: trunk)
13:16
Remove the long-unused, legacy vsixtest/ logic from the source tree. (check-in: 45ec9415b2 user: drh tags: trunk)
11:13
Simplify how hwaci-xfer-options-aliases figures out whether flags are provided. (check-in: f06122a543 user: stephan tags: trunk)
10:39
Merge latest trunk changes into this branch. (check-in: bce9a524de user: dan tags: fts5-tokendata-prefix)
02:49
Document why -IPREFIX/include is now part of T.cc.sqlite. (check-in: d64dcb1a89 user: stephan tags: trunk)
02:46
Correct the default config value for HAVE_TCL (0 until proven otherwise) and fix the starting dir for SQLITE_AUTORECONFIG (formerly SQLITE_AUTOREMAKE), as reported in [forum:8ab69387008f2f6c | forum post 8ab69387008f2f6c]. (check-in: 55f78b6396 user: stephan tags: trunk)
02:11
Have --enable-editline fail rather than emit a warning which would easily be overlooked by automated builds. The error message explains a potential workaround for activating libedit. (check-in: 2bd1b9557a user: stephan tags: trunk)
01:13
Docs and small code cleanups in hwaci-common.tcl. (check-in: 1353d4b600 user: stephan tags: trunk)
00:56
Add --with-icu-config flag to use the icu-config binary to find the required ldflags for linking the ICU libraries. (check-in: 64f33bb125 user: stephan tags: trunk)
2024-10-27
22:34
Expand the 'make help' target and clean up some overly-noisy configure output. (check-in: c895766ed3 user: stephan tags: trunk)
22:18
Re-order the auto.def flags logical groups. Add some discrete bold formatting to select configure output. Remove some dead code. Account for behavior misunderstanding of user-notice. Add the start of a 'make help' target. General cosmetic cleanups. (check-in: ab95ee33df user: stephan tags: trunk)
20:46
Generic cleanups in auto.def and hwaci-common.tcl. (check-in: 428e542452 user: stephan tags: trunk)
20:14
Doc additions and minor cleanups in the --flag alias handling. (check-in: 37a1da0381 user: stephan tags: trunk)
20:04
Rename --with-readline-lib/inc to --with-readline-ldflags/cflags, for clarity, but retain the older names as aliases using autosetup's "hidden alias" feature. Rename the newly-added --with-icu-lib to --with-icu-ldflags (with no backwards compatibility). (check-in: e50a03f9f2 user: stephan tags: trunk)
19:26
When ICU is enabled, ensure that the CLI shell build enables its feature flag and include LDFLAGS_ICU in sqlite3.pc. (check-in: abec913c00 user: stephan tags: trunk)
19:22
Add --with-icu-inc=CFLAGS, but its justification (based on examination of a downstream build script) as iffy, so this needs to be considered more closely before committing to it. (Edit: no, we don't want to pass on any ICU-side CFLAGS when building the library, especially not the one provided by icu-config --clflags.) (Closed-Leaf check-in: 5fc0b460a1 user: stephan tags: configure-with-icu-inc)
18:46
When readline is enabled, attempt to determine whether the completion API is compatible and, if it's not, disable it in the shell app. (check-in: 4564dbe4ac user: stephan tags: trunk)
16:12
Fix build errors in fts5_tcl.c on Mac. (check-in: 133fff8bd7 user: drh tags: trunk)
15:58
Fix test code added by [ba358d26]. (check-in: b7da7980d3 user: dan tags: trunk)
14:41
Merge latest trunk into this branch. (check-in: 740a37c5d5 user: dan tags: fts5-tokendata-prefix)
10:48
Improvements to the PATTERN option of the "testrunner.tcl joblist" command. The pattern match is case insensitive and applies to the state and displaytype in addition to displayname. (check-in: 63a8f60f98 user: drh tags: trunk)
10:33
Help systems still using Tcl8.6 to compile tclsqlite.c by changing a typedef into a #define. (check-in: 82ab8ff399 user: drh tags: trunk)
09:28
Remove some incorrect code comments. (check-in: 6dfda7f579 user: stephan tags: trunk)
08:52
Re-add the --disable-static flag to (mostly) disable static lib build. Some components require the static lib and will trump this preference if they are activated. Delete temp files created by mksqlite3h.tcl. (check-in: e296cd11a2 user: stephan tags: trunk)
08:29
Generic auto.def cleanups. (check-in: 19a5377e60 user: stephan tags: trunk)
08:10
Ensure that --disable-tcl is honored. Move LDFLAGS.icu from the CLI shell target to LDFLAGS.libsqlite3. (check-in: 39ce3f6350 user: stephan tags: trunk)
07:06
configure: add --with-icu-lib=LDFLAGS and --enable-icu-collations. Fix auto-reconfigure when flags contain spaces. (check-in: 2a881a2e1b user: stephan tags: trunk)
06:03
Makefile.in: include CPPFLAGS in the CFLAGS, as the legacy Makefile.in did, because some downstream scripts rely on that. Remove a duplicated TCLLIBDIR assignment. (check-in: 8e352f4199 user: stephan tags: trunk)
05:28
configure: document why --enable-editline does not work and emit a warning with a potential alternative/workaround if it's used. Various cosmetic cleanups. (check-in: ccb8f16f8a user: stephan tags: trunk)
04:27
Bring the automated readline detection up to parity with the legacy configure script. (check-in: 2ddeb7a8f5 user: stephan tags: trunk)
02:27
Rename --with-readline-ldflags/cflags to --with-readline-lib/inc because it turns out that ldflags/cflags have (when passed an explicit value) the same semantics the legacy lib/inc flags. Still to-fix is that the no-flag-given readline search behavior differs, and is much more limited, from the legacy configure behavior. (check-in: 8f6897b92c user: stephan tags: trunk)
02:08
Correct sqlite3.pc to represent the library, not the CLI shell. Remove the half-baked an unused READLINE_H config define. Internal tcl doc fixes. (check-in: c8c70353bb user: stephan tags: trunk)
2024-10-26
21:51
Get --with-linenoise=DIR configure flag working. (check-in: 66ce47e5de user: stephan tags: trunk)
19:16
Remove the install-lib makefile dep from install-tcl, as it breaks non-root-user invocations of 'make install-tcl' when the --prefix is left at its default and --with-tcl is explicitly provided. (check-in: e7eabfb61f user: stephan tags: trunk)
18:34
configure flag --disable-readline now trumps --with-readline-... (check-in: b66076e51b user: stephan tags: trunk)
18:17
Add new configure --with-readline-ldflags/cflags/header flags as brute-force method for clients to tell configure how to compile and link against readline. (check-in: eaa3a8053e user: stephan tags: trunk)
18:09
Add test case for fts5 trigram tokenizer. (check-in: ba358d265b user: dan tags: trunk)
17:47
In Makefile.msc, build jimsh0.exe locally, not in the source directory. (check-in: 1b9eb4564b user: drh tags: trunk)
16:04
Remove LDFLAGS_ZLIB from sqlite3.pc.in because -lsqlite3 already includes that. (check-in: 47e50fa84d user: stephan tags: trunk)
16:03
Patch bundle accumulated via /chat: add missing --enable/disable-shared flag to configure script and update testrunner.tcl for other configure script flag changes. (check-in: 32fc9c3f62 user: stephan tags: trunk)
11:18
Fix a bug in the computation of LDFLAGS.libsqlite3 introduced by [63218898ed0a6d46]. (check-in: 58373d523c user: drh tags: trunk)
04:31
Add missing B.exe extension to src-verify, as reported in the forum. (check-in: 2801fb6507 user: stephan tags: trunk)
03:30
Doc typo fix. (check-in: da50e85d9a user: stephan tags: trunk)
03:22
Rephrase 'older' as 'legacy' in the docs from [0a50e33051] and [2b2ca7dec18d]. (check-in: d212cc3682 user: stephan tags: trunk)
03:19
Expand the libtool-style link support from [0a50e33051] such that if INSTALL_SO_086_LINKS=1 is passed to 'make install' then the libtool-style names are always linked in, regardless of whether they already existed or not. In either case, we unconditionally remove libsqlite3.la because it cannot work with the newly-installed non-libtool .so file. (check-in: 2b2ca7dec1 user: stephan tags: trunk)
03:05
Disable generation of config.defines.json until/unless it proves interesting. Honor the --disable-largefile flag. When installing libsqlite3.so and an older-style libtool installation is found, re-link the libtool-generated files to the newly-installed ones to retain their historical names. (check-in: 0a50e33051 user: stephan tags: trunk)
2024-10-25
23:45
Correct unresolved @LIBS@ placeholder in sqlite3.pc.in. (check-in: 63218898ed user: stephan tags: trunk)
23:25
Use (cc-with {-includes stdint.h}) when checking for the various int types because, despite it being C99, it turns out that we do indeed use it if it's available. (check-in: 51a9278134 user: stephan tags: trunk)
23:13
When --with-tclsh=X is used, use X for all TCL purposes, including in-tree code generation, per developer request. (check-in: 12498e55c0 user: stephan tags: trunk)
23:04
Fix BUILD_CFLAGS (for B.cc) to not inherit CFLAGS (which are only for T.cc). (check-in: ffdce13deb user: stephan tags: trunk)
23:03
Experimentally: when ./configure CC=foo is used in a non-cross-compilation build and CC_FOR_BUILD is not explicitly provided, force CC_FOR_BUILD to default to CC. This is debatable - see the code comments for the justification. (check-in: a49bee6841 user: stephan tags: trunk)
22:44
Rename VERSION_XYZ to the more conventional PACKAGE_VERSION and remove the unused VERSION_XY. (check-in: 2d2f6dfdeb user: stephan tags: trunk)
20:21
Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 12fc5fd5e0 user: drh tags: reuse-schema)
20:06
Merge the latest trunk enhancements and especially autosetup into the bedrock branch. (check-in: 86a305b900 user: drh tags: bedrock)
19:40
Merge the latest trunk enhancements and especially the autosetup changes into the wal2 branch. (check-in: 4ddea432bb user: drh tags: wal2)
19:32
Merge the latest trunk enhancements and especially the new autosetup changes from trunk into the begin-concurrent branch. (check-in: af43791d47 user: drh tags: begin-concurrent)
18:37
Update special logging messages on this branch to say "v=6" instead of "v=5". (check-in: af4e778bd3 user: dan tags: cf8f1552-commit-instr)
18:24
Reduce the number of malloc()/free() calls that may occur when a BEGIN CONCURRENT transaction is committed. (check-in: fcd68bebf2 user: dan tags: cf8f1552-commit-instr)
16:20
Merge the latest trunk enhancements into the lateral-join branch. (Leaf check-in: e7f27bbdf4 user: drh tags: lateral-join)
15:28
Update the compile-for-*.md documents. (check-in: c4da7fa279 user: drh tags: trunk)
14:39
Rework the configure+make system to use autosetup rather than autoconf. Autosetup runs faster and is easier to maintain, and it allows for common targets (such as "sqlite3" and "sqlite3.c") to be built within having to install "tclsh". (check-in: d8c0e01842 user: drh tags: trunk)
14:36
Restore the amalgamation-tarball and snapshot-tarball targets, at least for now. (Closed-Leaf check-in: 1baf4b9488 user: drh tags: autosetup)
13:56
Minor auto.def cleanups and doc addtions. (check-in: ea53aba82b user: stephan tags: autosetup)
12:22
New jimsh0.c file for autosetup. (check-in: cfacf86411 user: drh tags: autosetup)
12:06
Update the LICENSE.md file to describe BSD-licensed code that is included in the repository as a convenience to developers but which is not itself actually a part of SQLite. (check-in: deb5994bb1 user: drh tags: autosetup)
05:53
Ensure that jimsh is built in the proper dir in an out-of-tree build and that jimsh0 is cleaned up by distclean. (check-in: e0286e258b user: stephan tags: autosetup)
04:48
Rename config-defines.json to config.defines.json for consistent with other generated config.* files. Rename --defs-json-include-lowercase to the even less wieldy --defines-json-include-lowercase. (check-in: 131a2a7ef8 user: stephan tags: autosetup)
04:39
Add --defs-json-include-lowercase configure flag to cause config-defs.json to include lower-case defines, which are primarily the various build-related system paths. (check-in: 0f2555ea3c user: stephan tags: autosetup)
04:16
Internal cleanups and docs in hwaci-common.tcl. (check-in: 30699b57d2 user: stephan tags: autosetup)
03:56
Docs related to the -array defs-dump option. Rename some internal-use hwaci-common.tcl APIs after discovering that a - as a symbol suffix fails for var derefs (but works for procs calls). (check-in: 0d5da3888e user: stephan tags: autosetup)
03:35
Experimentally add the -array formatting option to hwaci-dump-defs-json and emit OPT_FEATURE_FLAGS/OPT_SHELL in both flat string and array forms. (check-in: ce6bc4603c user: stephan tags: autosetup)
03:18
./configure now emits config-defs.json, a JSON-formatted counterpart of the DEFS=... info which the pre-built autotools bundles emit. (check-in: 800b083c3a user: stephan tags: autosetup)
2024-10-24
19:56
The "WITHOUT_JIMSH=1" option on the nmake command-line forces the use of standard TCL for building, instead of jimsh0. (check-in: 9f861f66e2 user: drh tags: autosetup)
19:31
Patch sqlite3_rsync.c to disable undesirable automatic line ending conversions on Windows. (check-in: e3c27c6d8a user: drh tags: branch-3.47)
19:17
Basic builds now appear to work using jimsh0 on Windows. (check-in: d8f5193970 user: drh tags: autosetup)
17:16
Fix a bug in jimsh0.c for when it is compiled using MSVC. (check-in: f7def0be74 user: drh tags: autosetup)
16:02
Add missing ZERO_ARGUMENT_GENERATE_SERIES checks to ext/misc/series.c. (check-in: 31e104cc40 user: stephan tags: branch-3.47)
15:58
Add missing ZERO_ARGUMENT_GENERATE_SERIES checks to ext/misc/series.c, as reported via support mail. (check-in: 5a8e3915ee user: stephan tags: trunk)
15:57
Add missing ZERO_ARGUMENT_GENERATE_SERIES checks to ext/misc/series.c, as reported via support mail. (Closed-Leaf check-in: cd82e4c0f5 user: stephan tags: ifdef-SQLITE_CORE)
15:57
Fix the new tool/cp.tcl so that it works with older TCL versions, such as jimtcl. (check-in: 61f18c9618 user: drh tags: autosetup)
15:36
Fix harmless compiler warnings. One of the warnings was code that deliberately committed memory errors to test the systems ability to cope. But compilers don't allow that any more, so we'll have to leave that capability untested. (check-in: 7e7b3b2edb user: drh tags: autosetup)
15:14
Add the tool/cp.tcl script and use it to simplify Makefile.msc. (check-in: b7db2146a8 user: drh tags: autosetup)
14:33
Back out [bd66222721] because it causes conflicts with test runs, apparently due to .o files being built with different flags. This means that the CLI shell currently does not honor --disable-amalgamation. (check-in: b063317352 user: stephan tags: autosetup)
13:27
Tweaks to help make jimsh0 usable to build using nmake. Does not quite work yet, but getting closer. (check-in: e911303b8d user: drh tags: autosetup)
12:57
Minor makefile tweaks to account for customizations via a custom hand-built makefile. (check-in: 7f92e820e6 user: stephan tags: autosetup)
12:18
Fix jimsh0.c so that it compiles using MSVC: "cl jimsh0.c" (check-in: f531825d4e user: drh tags: autosetup)
12:06
Fix an inconsistency in the way SQLITE_CORE is used in fts3.c. (check-in: d4816e534a user: dan tags: trunk)
12:03
Fix the sqlite3(.EXE) build to honor --disable-amalgamation. (check-in: bd66222721 user: stephan tags: autosetup)
11:20
Merge all the latest trunk enhancements into the autosetup branch. (check-in: d0554ac468 user: drh tags: autosetup)
11:11
Update the version number for the TEA extension. (check-in: 56353bcffa user: drh tags: autosetup)
07:44
Beginnings of rephrasing #if SQLITE_CORE to #ifdef/ifndef for consistency, as discussed in [forum:cea40371c5e34b09 | forum post cea40371c5e34b09]. (check-in: 58d91abf0c user: stephan tags: ifdef-SQLITE_CORE)
07:31
Various build cleanups centered around straightening out various uses of CFLAGS and its cousins. Teach Makefile.linux-generic to figure out the TOP dir on its own (a GNU Make-ism, but it's a Linux-specific makefile). (check-in: 58a0f7e79c user: stephan tags: autosetup)
05:33
More potentially-controversial makefile symbol renaming. This is simply more readable to my eyes. (check-in: 6d4d1d5fef user: stephan tags: autosetup)
05:03
Bump version number to 3.48.0 (in this branch only - in trunk, doing so requires a specific autoconf version) and rename the RELEASE and VERSION makefile symbols for clarity's sake. (check-in: 4193d90f21 user: stephan tags: autosetup)
04:56
Potentially controversial/unconventional makefile symbol renamings and docs explaining them. (check-in: 7eceb7539d user: stephan tags: autosetup)
04:34
Generic build cleanups. (check-in: be7b32a77f user: stephan tags: autosetup)
03:50
Get Makefile.linux-generic (formerly Makefile.linux-gcc) working with jimsh in out-of-tree builds. Pass on -DHAVE_READLINE=1 to the sqlite3 shell if configure detects it. (check-in: a555ff6dbc user: stephan tags: autosetup)
03:14
General make cleanups. Start adding a sanity-check mechanism to main.mk which does basic validation of the vars it expects to be set by the file which includes it. Get Makefile.linux-gcc working for the core-most rules. (check-in: 85b2c73ccb user: stephan tags: autosetup)
01:26
Rename some build vars for legibility. Fix hwaci-make-from-dot-in when the input file list is multi-line. (check-in: fdb5844215 user: stephan tags: autosetup)
00:02
Fix out-of-tree builds configured with --disable-amalgamation. (check-in: 182dac1c46 user: stephan tags: autosetup)
2024-10-23
17:40
Remove unused configure check for clang-18. (check-in: d73ac7286a user: stephan tags: autosetup)
17:17
Remove three autotools files which are not needed in the autosetup port. (check-in: fc20861443 user: stephan tags: autosetup)
17:16
Extra logging to debug slow commit statements. (check-in: 9cafae1fff user: dan tags: cf8f1552-commit-instr)
16:59
Fix a #define typo in jimsh0.c, eliminating the need to explicitly pass -DJIM_COMPAT when building it. This fix has since made its way upstream. (check-in: 9b105abf6f user: stephan tags: autosetup)
16:46
After compiling jimsh, run sanity tests on it to ensure that it is built with -DJIM_COMPAT and one of (-DHAVE_REALPATH, -DHAVE__FULLPATH). (check-in: ea6a14a6e6 user: stephan tags: autosetup)
16:03
Work around a minor JimTCL regexp incompatibility in tool/vdbe-compress.tcl. Summary: it thinks that backslash-escaped octal values are back-references, which it does not like. (check-in: aeac23359b user: stephan tags: autosetup)
15:13
Remove the configure-script VERSION check from tool/srctree-check.tcl, as it's not relevant in the autosetup build. (check-in: 6c5826d752 user: stephan tags: autosetup)
15:05
Add missing export of LDFLAGS_DLOPEN to Makefile.in. (check-in: d18af84bf7 user: stephan tags: autosetup)
11:33
Reorder conditions in sqlite3PagerDirectReadOk() for coverage. (check-in: da9124fee2 user: drh tags: trunk)
11:06
Fix harmless compiler warnings in wherecode.c. One such warning was identified by [forum:/forumpost/721675f007|forum post 721675f007] and the other was found by tool/warnings.sh. (check-in: 987b96aa63 user: drh tags: trunk)
10:36
Add two new #include statements to the composite "fts5.c" file that is constructed as part of the build process. These #includes are no-ops in the SQLite amalgamation (and are commented out automatically by the amalgamation builder) but are needed if the FTS5 extension is built separately, it seems. Enhancement request. (check-in: 1bf8daeb24 user: drh tags: trunk)
02:36
Another fix for autosetup/autosetup-find-tclsh for the case where a tclsh is found on the system. (check-in: 19d78fcef4 user: stephan tags: autosetup)
02:22
Latest autosetup/autosetup-find-tclsh from autosetup ticket #67. (check-in: 0e33f6cd48 user: stephan tags: autosetup)
02:17
Reorder some auto.def code to avoid breaking --help. (check-in: 151d7dfc8d user: stephan tags: autosetup)
02:11
Minor cleanups in the --with-wasi-sdk bits. (check-in: d952c17981 user: stephan tags: autosetup)
01:59
Get auto.def handling the case that no tclsh is installed in a default location. If not, use jimsh if we can find realpath(), else bail out. (check-in: 359741bc76 user: stephan tags: autosetup)
01:33
Fix /dev/null and stderr redirection ordering in autosetup/autosetup-find-tclsh so that the extraneous strlcpy()/snprintf()/rand() warning output from ld on OpenBSD does not break detection of jimsh0. (check-in: cd447e50d1 user: stephan tags: autosetup)
01:18
Use pkg-config for readline detection, if available. Unrelated minor tcl cleanups. (check-in: 3a41ac08a4 user: stephan tags: autosetup)
2024-10-22
20:16
Changes to EXPLAIN QUERY PLAN to identify covering index plan that use indexes on expressions. (check-in: 29fb4919b6 user: dan tags: trunk)
20:09
Add the "halt" command to testrunner.tcl (check-in: 2cc25d5dbb user: drh tags: trunk)
19:33
Add the SQLITE_IOCAP_SUBPAGE_READ bit to the possible returns values from xDeviceCharacteristics method of the system-IO abstract class. The direct-overflow-read optimization is disabled for any VFS that does not set this bit. The bit is set for standard VFSes. (check-in: 6e7d498cda user: drh tags: trunk)
18:26
Rename to SQLITE_IOCAP_SUBPAGE_READ. (Closed-Leaf check-in: dd446ef181 user: drh tags: bypass-iocap)
18:00
Add the SQLITE_IOCAP_BYPASS device characteristic. Do not allow the SQLITE_DIRECT_OVERFLOW_READ optimization if that capability is missing. (check-in: f50ae00ce9 user: drh tags: bypass-iocap)
17:57
Minor build docs and cleanups. (check-in: 0eb96ea2d1 user: stephan tags: autosetup)
16:26
Add still more logging to determine why schema loads are so slow in some circumstances. (check-in: d02ec06e5b user: dan tags: cf8f1552-commit-instr)
16:19
Do not typedef Tcl_Size if it is already #defined. (check-in: 53491688cf user: drh tags: trunk)
13:02
Minor cleanups to how configure generates tool/emcc.sh. (check-in: 4484b46236 user: stephan tags: autosetup)
12:56
Teach ext/wasm/GNUmakefile to use tool/emcc.sh and fix a syntax error in tool/emcc.sh.in. Work around a JimTCL incompatibility in tool/mkshellc.tcl. (check-in: 24e0f6ecc6 user: stephan tags: autosetup)
10:29
Further changes to sqlite3_rsync.c to work around Windows issues. (check-in: e2bd3219d9 user: drh tags: trunk)
09:43
Set I/O mode to binary in Windows in sqlite3_rsync. (check-in: 6717528744 user: drh tags: trunk)
03:56
After discussing [4d4423df8d14] with Steve Bennett, do not prepend $prefix/bin to the search path for binaries, as that path is commonly used for cross-compiled targets and we want binaries which will run on the build host. (check-in: f2008a7d79 user: stephan tags: autosetup)
03:33
Touch configure-generated files at configure-time even if autosetup does not update them because their contents would not be changed. Works around wonky deps causing too-frequent rebuilds. (check-in: 339b48af17 user: stephan tags: autosetup)
03:12
Rename hwaci-error to the more descriptive hwaci-fatal. Use autosetup's file-isexec instead of [file executable] for portability. Remove the binary file lookup cache - unnecessary complexity. When searching for tools like tclsh, check under $prefix/bin before checking the $PATH. This seems like the right thing to do, but the fact that autosetup's file-search API's do not do that by default leaves some room for doubt about the wisdom of this change. (check-in: 4d4423df8d user: stephan tags: autosetup)
2024-10-21
22:45
In testrunner.tcl: Better estimates for ETC (Estimated Time to Completion). Show the ETC even for the single-line status reports. (check-in: 2a2f5f4e37 user: drh tags: trunk)
22:15
Bring checksymbols target up to date and add a TODO based on a feature request from the forum. (check-in: c00a03256b user: stephan tags: autosetup)
21:53
Add sqlite3rebaser_... to the API symbols accepted by the 'checksymbols' makefile target. (check-in: 0284590f21 user: stephan tags: trunk)
21:32
Resolve two build FIXMEs. (check-in: 4de51c165c user: stephan tags: autosetup)
21:22
Get most of the numerous misc tool binaries building. (check-in: fa74cbb40c user: stephan tags: autosetup)
20:12
Simplify how the targets which may or may not be enabled, depending on config flags, are formulated in main.mk. (check-in: 7bea793ce4 user: stephan tags: autosetup)
19:51
More build doc tweaks and get ./startup building. (check-in: cee285029c user: stephan tags: autosetup)
17:50
Start moving most Makefile.in docs over to main.mk. Fix compilation of tclsqlite.c. (check-in: 5b154e08ab user: stephan tags: autosetup)
17:13
Update the reuse-schema branch to version 3.47.0 (check-in: d49d282795 user: drh tags: reuse-schema)
17:10
Update the bedrock branch to version 3.47.0 (check-in: d2d954d43a user: drh tags: bedrock)
17:05
Update the wal2 branch to version 3.47.0 (check-in: d34b6a9138 user: drh tags: wal2)
17:00
Update the begin-concurrent branch to version-3.47.0 (check-in: 457bb035e3 user: drh tags: begin-concurrent)
16:30
Version 3.47.0 (check-in: 03a9703e27 user: drh tags: trunk, release, major-release, version-3.47.0)
16:06
Add docs introducing how to define and use autosetup configure flags. Use -DJIM_COMPAT when building jimsh to force its expr command to be syntax-compatible with canonical TCL. (check-in: a6a275de3d user: stephan tags: autosetup)
14:24
Add a case to testrunner.tcl so that mdevtest can run on openbsd. (check-in: e904b37fb2 user: dan tags: trunk)
13:11
Merge trunk into autosetup branch. (check-in: 347a50e66f user: stephan tags: autosetup)
11:49
Add extra logging to SQL statements used to load the database schema on this branch. This requires SQLITE_ENABLE_STMT_SCANSTATUS. (check-in: 08e1dea9c0 user: dan tags: cf8f1552-commit-instr)
10:47
Avoid using LIKE in sqlite3expert.c, in case "PRAGMA case_sensitive_like" has been used or the "like" UDF replaced by something unexpected. (check-in: 9f642b3dbc user: dan tags: trunk)
2024-10-20
07:19
Fix another problem with ".expert" and virtual tables. [forum:/forumpost/49d6a19ec|Forum post 49d6a19ec]. (check-in: 7a7162293c user: dan tags: trunk)
02:47
Build doc touchups. (check-in: 109d441bf1 user: stephan tags: autosetup)
02:35
A possible fix for some as-yet-unused configure code which looks for a module loader. (check-in: c6c799a54b user: stephan tags: autosetup)
01:41
Cosmetic tweaks to auto.def. (check-in: 476d2407e5 user: stephan tags: autosetup)
01:34
Minor doc updates. (check-in: 6578a8d59e user: stephan tags: autosetup)
01:14
Do not check for Emscripten when doing a --with-wasi-sdk build. (check-in: 111cff2cf3 user: stephan tags: autosetup)
01:09
Generic build cleanups and reorgs. (check-in: 365a3d71cf user: stephan tags: autosetup)
2024-10-19
22:45
Add sqlite3_rsync to the docs at the top of mktoolzip.tcl. No code changes. (check-in: 10f5c4a2fc user: stephan tags: trunk)
20:53
More build cleanups and get it working with BSD make (which apparently does not support $<). (check-in: dcf4fc78fb user: stephan tags: autosetup)
20:26
Move most of the makefile code into the static main.mk. (check-in: 09905ed094 user: stephan tags: autosetup)
18:31
Factor out all autosetup-processed @if/@else blocks from Makefile.in in prep for moving most of the makefile code into main.mk (which has, so far, been completely overlooked in this port but will now become the main basis for the static parts of the build). The idea is that all build configuration goes into a platform-dependent makefile which then includes main.mk. (check-in: 707e0f5857 user: stephan tags: autosetup)
16:58
Generic build cleanups. (check-in: 510afccf02 user: stephan tags: autosetup)
13:51
Merge trunk into autosetup branch. (check-in: 2923a8924c user: stephan tags: autosetup)
13:44
Get tool-zip target, and its prerequisites, building. (check-in: 38cc5db3a8 user: stephan tags: autosetup)
13:38
Add missing TEXE suffixes in the tool-zip makefile target. (check-in: 5a594dbcd5 user: stephan tags: trunk)
13:20
Move the #include of hwtime.h from the bottom of util.c to the top of vdbe.c so that it will be available when needed, even for non-amalgamation builds. (check-in: 5f23036a87 user: drh tags: trunk)
13:19
Get more of the test/utility targets building. (check-in: 24c81c6c52 user: stephan tags: autosetup)
13:18
Work around a JimTCL regsub incompatibility in mkccode.tcl. (check-in: c2e5dd791c user: stephan tags: autosetup)
12:47
Get the spell-checking targets working. Rename some symbols. (check-in: e389ef9c14 user: stephan tags: autosetup)
12:39
An assortment of comment typo fixes discovered by aspell. Add several new words to tool/custom.txt. No code changes. (check-in: 59b76a99e4 user: stephan tags: trunk)
11:02
Remove unnecessary VACUUMs from the previous check-in to sqlite3_rsync. (check-in: ad8d481242 user: drh tags: trunk)
00:49
Get mptest(er) building. (check-in: f740f6a444 user: stephan tags: autosetup)
00:16
Fix the sqlite3_rsync utility so that it is able to synchronize a database using a UTF16 text encoding. [forum:/forumpost/e055d50821|Forum post e055d50821]. (check-in: 981347009c user: drh tags: trunk)
2024-10-18
23:54
Minor doc cleanups in SQLTester.mjs and confirm that the tests pass with both OPFS VFSes. (check-in: ac747d57c2 user: stephan tags: trunk)
23:36
Fix three bugs in SQLTester.mjs which caused --tableresult tests, escaping of SQL values to incorrectly fail, and the --column-names setting to not be reset between tests. (check-in: 779368dd9b user: stephan tags: trunk)
23:10
Fix a var reference typo in SQLTester.mjs. (check-in: 31179fa78e user: stephan tags: trunk)
16:50
Remove the unused dbfuzz2-asan/msan makefile targets. Fix a comment typo in a makefile. (check-in: 07843ac245 user: stephan tags: trunk)
16:47
Remove the problematic dbfuzz2-asan/msan targets, which Richard says are not used anymore. (check-in: 503ce205a1 user: stephan tags: autosetup)
16:39
Get most of the fuzzing-related apps building, sans dbuzz2-asan/msan, both of which refuse to link with clang v18 because it's trying to use -lstdc++ despite the app being only C. (check-in: 3e84345292 user: stephan tags: autosetup)
12:31
Remove a not-strictly-necessary 'undefine' invocation from ext/wasm/GNUmakefile, as it is not compatible with too-old versions of gmake. Resolves the problem reported in [forum:e57932e3ccdc2c9c | forum post e57932e3ccdc2c9c]. (check-in: a31a946441 user: stephan tags: trunk)
10:51
Minor enhancements to the compile-for-windows.md document. (check-in: 5f0cc7f264 user: drh tags: trunk)
10:42
Fix typo in the README.txt for the amalgamation autoconf tarball. (check-in: 62d24a69fe user: drh tags: trunk)
01:14
New assert() statements to validate OP_OpenEphemeral logic. (check-in: 6d55c3e238 user: drh tags: trunk)
2024-10-17
23:14
Fix obsolete M4 macro in the configure script for the TEA extension within the autoconf tarball. (check-in: 360613a224 user: drh tags: trunk)
22:20
Merge current trunk into the autosetup branch. (check-in: 352da23b46 user: stephan tags: autosetup)
22:19
General cleanups. Rename BTCL to BTCLSH for some clarity. (check-in: 83eaef7d62 user: stephan tags: autosetup)
18:12
Fixes from code inspection: (1) Extra paranoid defense against integer overflow. (2) Remove a stray blank line in an FTS5 comment. (check-in: 8563728dee user: drh tags: trunk)
16:22
Fix a typo in compile-for-unix.md. Simplify hyperlinks in the compile-for-* documents. (check-in: 8cd7d15774 user: drh tags: trunk)
13:29
Improved README.txt file in the amalgamation-autoconf tarball. (check-in: b781435038 user: drh tags: trunk)
13:00
Attempt to get the TEA builder in the amalgamation-autoconf tarball working using hints from Jan Nijtmans. (check-in: ad9d7bdef9 user: drh tags: trunk)
12:14
Ensure that the OPFS VFS's xOpen() writes back the read-only flag to the output flags. Resolves the problem reported in [forum:cf37d5ff1182c31081 | forum post cf37d5ff1182c31081]. (check-in: 0a32624015 user: stephan tags: trunk)
11:12
When calling OpfsSAHPoolUtil.removeVfs(), ensure that the cached result the VFS init is also removed so that the VFS may later be registered again with the same name. Set up test code for the regression reported in [forum:cf37d5ff11 | forum post cf37d5ff11] (which uncovered the removeVfs() shortcoming) but that test is currently only known to fail with the "opfs" VFS and is not currently set up to fail. (check-in: b7f7a5deea user: stephan tags: trunk)
2024-10-16
15:14
Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 93f0febab4 user: drh tags: reuse-schema)
15:09
Merge the latest trunk enhancements into the bedrock branch. (check-in: d5289de411 user: drh tags: bedrock)
15:03
Merge the latest trunk enhancements into the wal2 branch. (check-in: 2e96c8bb7a user: drh tags: wal2)
14:52
Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 92cd032aa9 user: drh tags: begin-concurrent)
14:05
Add has_tclconfig to the tidy makefile target. (check-in: 309e6d6f07 user: stephan tags: trunk)
14:04
Get testfixture building. (check-in: 9a7e56a017 user: stephan tags: autosetup)
13:02
Merge trunk into this branch. (check-in: 9c3bb3dc4f user: stephan tags: autosetup)
11:05
Change the name of the new utility program from sqlite3-rsync to sqlite3_rsync - dash changed to underscore - for consistency with the preexisting sqlite3_analyzer. (check-in: 86e794cbaa user: drh tags: trunk)
10:20
In the unix Makefile, strip compiled binaries prior to adding them to the tool ZIP archive. (check-in: cd8ae6fd71 user: drh tags: trunk)
2024-10-15
22:22
Fix harmless compiler warning in flockCheckReservedLock(). (check-in: f369de3d8f user: drh tags: trunk)
18:45
Fix the "tool-zip" makefile target so that it includes sqlite3-rsync. (check-in: ecdbedb16b user: drh tags: trunk)
14:28
Fix a typo in a comment used to generate document. No code changes. (check-in: 9b4bc5c4c1 user: drh tags: trunk)
14:00
Cross-reference the sqlite3_backup_init() function to the documentation for VACUUM INTO and sqlite3-rsync. Comment changes only. No changes to code. (check-in: 405c23ce02 user: drh tags: trunk)
2024-10-14
18:43
Avoid the possibility of buffer overrun in the READ_UTF8 macro by using an less-than operator rather than not-equal-to. (check-in: 20e60bf058 user: drh tags: trunk)
11:48
There is no need to DELETE the content of sqlite_sequence in the output of the CLI ".dump" command because that table will initially be empty if it exists at all. [forum:/forumpost/2e31f49d00472cec|Forum post 2e31f49d004] (check-in: 8d7fe903d0 user: drh tags: trunk)
10:45
The CLI now default to ".crlf ON" in Windows. CSV output always uses CRLF on all platforms. (check-in: 84d19f03b1 user: drh tags: trunk)
09:19
Be consistent about using "CRLF" instead of "CRNL". (check-in: ec4f4cfd5f user: drh tags: trunk)
09:08
Fix a harmless compiler warning in the CLI. (check-in: 31c46e84ff user: drh tags: trunk)
2024-10-12
19:33
Fix a problem with the ".expert" command and queries that use virtual tables. (check-in: 43787b8ec5 user: dan tags: trunk)
18:33
Ensure that test file ext/expert/expert1.test works with non-fts5 builds. (Closed-Leaf check-in: 933dfd0618 user: dan tags: expert-vtab-fix)
18:00
Allow the ".expert" command to analyze statements that use built-in virtual tables. (check-in: a201906cd3 user: dan tags: expert-vtab-fix)
2024-10-11
23:31
Additional clarification in the comments to sqlite3_stdio.c. No changes to code. (check-in: 2db24c5364 user: drh tags: trunk)
20:36
Experimental change to explain query plan to identify covering indexes on expressions. (Closed-Leaf check-in: 3bb03a2891 user: dan tags: eqp-covering-index-on-expr)
19:57
Update comments in ext/misc/sqlite3_stdio.c to reflect the latest enhancements. No changes to code. (check-in: 9621c3b527 user: drh tags: trunk)
19:33
Add the doc/compile-for-unix.md document. (check-in: a3e16e478b user: drh tags: trunk)
19:22
Avoid a segfault when calling src-verify without any arguments. (check-in: c0c4e6f111 user: stephan tags: trunk)
19:18
Add two missing $(BEXE) suffixes, as reported in [forum:9ad28680d394afda | forum post 9ad28680d3]. Problem introduced by [1218a203483cecdc] being incomplete in where it added that suffix. (check-in: de9663c0aa user: stephan tags: trunk)
19:13
Improved instructions in the TEA readme for building the TCL extension. (check-in: bf996f7102 user: drh tags: trunk)
19:08
Update the README for the TEA extension in the amalgamation tarball. (check-in: acc866c8f1 user: drh tags: trunk)
18:59
Avoid running some new tests in lock5.test with the inmemory_journal permutation. (check-in: 0b12e2e55c user: dan tags: trunk)
17:43
Update the autoconf Makefile.msc (check-in: 911ab32997 user: drh tags: trunk)
17:02
An improved method for statically linking sqlite3_analyzer.exe using Tcl9. Enable wildcard expansion of arguments to testfiture on Windows. (check-in: 9b87ea219b user: drh tags: trunk)
14:30
Fix the CSV output mode in the CLI such that the line ending is NL by default but goes to CRLF if ".crnl on" is set. Make the .crnl command available on non-Windows builds. Update the .crnl command such that if it has no arguments it shows the current setting. (check-in: da750e39df user: drh tags: trunk)
14:02
Avoid undesirable NL to CRLF translation when doing binary output to the Windows console. (check-in: d25bdce36a user: drh tags: trunk)
2024-10-10
15:28
Fix a typo in the previous commit. (check-in: 6deb4794f8 user: dan tags: cf8f1552-commit-instr)
14:31
Add extra logging points to the code on this branch. (check-in: f29ff2f308 user: dan tags: cf8f1552-commit-instr)
10:47
Improvements to TCL9 support. Fixes to the Makefiles so that the "install" targets are consistent and so that they work better with TCL9. (check-in: bcfae7183e user: drh tags: trunk)
10:33
For compatibility, allow the TCL interfact to continue working with TCL 8.5. (Closed-Leaf check-in: 69346e9d47 user: drh tags: make-install-fixes)
09:59
Adjustments to the Makefile.msc to get static builds of sqlite3_analyzer.exe working with TCL9. Update the compile-for-windows.md document for TCL9. (check-in: df16d07d8d user: drh tags: make-install-fixes)
2024-10-09
20:05
Improvements to Makefile.msc: (1) Attempt to find sane values for key variables based on the value of TCLDIR. (2) Default to TCLVERSION 90 instead of 86. (3) Add the "tcl-env" target that shows the values of key variables associated with TCL. (check-in: 6b7a789a41 user: drh tags: make-install-fixes)
17:47
Add quotes around $(CC) in tclextension-related targets so that a CC of "ccache cc" works. (check-in: e8f719d13f user: stephan tags: make-install-fixes)
16:32
Fix a problem in the generate_series() extension introduced by [d50b784807333c54]. (check-in: 41d58a014c user: drh tags: trunk)
16:28
Fix the xCheckReservedLock() method of the flock VFS to avoid dropping the file lock. (check-in: f7acb189d8 user: dan tags: trunk)
15:40
Fix the xCheckReservedLock() method of the flock VFS to avoid dropping the file-lock. (Closed-Leaf check-in: 8ffaf85249 user: dan tags: flock-vfs-fix)
13:54
Change the makefile to prefer the use of tclsh9.0 if it is available. (check-in: 28e2b9a23f user: drh tags: make-install-fixes)
13:40
Make it so that the TCL extension installed using "make install" has the same name as the one installed by "make tclextension-install". (check-in: e21fc1ba44 user: drh tags: make-install-fixes)
13:26
Add sqlite3rc.h build. (check-in: 8d5f99f7e3 user: stephan tags: autosetup)
13:20
More work on the tcl build parts. (check-in: 292ad7d519 user: stephan tags: autosetup)
13:19
Changes to the TCL extension and how it is built, suggested by Jan Nijtmans. (check-in: 9c06901932 user: drh tags: make-install-fixes)
11:52
Improved handling of unicode characters in the LIKE optimization. Follow-up to [bce52ce2a6e7f3d3]. (check-in: 9d0eb39804 user: drh tags: trunk)
08:05
Remove extra layer of quotes around install target dirs. (check-in: f2e3cf219e user: stephan tags: autosetup)
07:12
More work on the tcl build bits. (check-in: f00988a909 user: stephan tags: autosetup)
05:28
Generic build cleanups. (check-in: 2cd213b387 user: stephan tags: autosetup)
05:20
Add a few missing $(BEXE) suffixes on makefile targets which are apparently never run on platforms where that var is non-empty. (check-in: 1218a20348 user: stephan tags: trunk)
04:27
More work on the --with-tcl bits. (check-in: 4d4cc49b6a user: stephan tags: autosetup)
04:01
Get much of the --with-tcl-related bits working. (check-in: 4e4a740369 user: stephan tags: autosetup)
2024-10-08
17:27
Enable the ".crnl" command on Windows builds of the CLI even if the SQLITE_U8TEXT_ONLY or SQLITE_U8TEST_STDIO compile-time options are used. (check-in: 6364a2f044 user: drh tags: trunk)
16:33
Fix build portability problems discovered on an ARM OpenBSD system. (check-in: ef5348dc3f user: stephan tags: autosetup)
16:06
Get some basic install rules working. (check-in: e9ab211f82 user: stephan tags: autosetup)
16:05
Make tool/emcc.sh.in Bourne-friendly. (check-in: a69ab88474 user: stephan tags: autosetup)
15:11
Additional improvements to the behavior of ".crnl" in the CLI. The default output mode is O_BINARY so that results are identical on Windows and non-Windows systems. On Windows you can optionally do ".crnl on" to enable NL-to-CRLF conversion on output. Output to Windows console is always O_U8TEXT and so is unaffected by the .crnl setting. (check-in: dbfc10b898 user: drh tags: trunk)
15:08
Add logging to help analyze slow "PRAGMA cache_size = ?" statements. (check-in: cd6f585cad user: dan tags: cf8f1552-commit-instr)
14:07
Fix the .crnl command in the shell so that it does not get undone by calls to print a quoted string or CSV output. (check-in: 6b932337c8 user: drh tags: trunk)
10:10
Allow expressions with subtypes to be read from indexes unless they are being used as direct or indirect parameters to SQLITE_SUBTYPE functions. (check-in: 39a56a23fe user: drh tags: trunk)
00:15
Add an ALWAYS() on a branch in the new indexed-subtype logic. (Closed-Leaf check-in: f150c3c5b8 user: drh tags: indexed-subtype-expr)
2024-10-07
21:04
Add a NEVER() to an unreachable branch in the new indexed-subtype logic. Mark the pi() function as deterministic. (check-in: 50be8f5091 user: drh tags: indexed-subtype-expr)
18:06
The (undocumented) subtype() SQL function should have the SQLITE_SUBTYPE flag. (check-in: c361dd9184 user: drh tags: indexed-subtype-expr)
16:53
Merge the latest trunk enhancements into the indexed-subtype-expr branch. (check-in: 2fe2f37458 user: drh tags: indexed-subtype-expr)
16:11
Add logging to help analyze commit performance. (check-in: c5391f2cc9 user: dan tags: cf8f1552-commit-instr)
12:48
Add the undocumented test/debug function parseuri(), useful for fuzzing. Only appears when compiling with SQLITE_DEBUG. (check-in: 011fab70cb user: drh tags: trunk)
12:19
Fix handling of U+fffd in the LIKE optimization. dbsqlfuzz eee57fb9eea1dfa5aa40dfa87865cf8c84d12f96. (check-in: bce52ce2a6 user: drh tags: trunk)
12:15
Check-in to the wrong branch. (Closed-Leaf check-in: 13addee687 user: drh tags: mistake)
11:47
Fix an assert() failure in "PRAGMA integrity_check" that could occur when checking a corrupt database. (check-in: d218993be5 user: dan tags: trunk)
2024-10-06
21:26
Origin should not send content for the lock-byte page to the replica, in sqlite3-rsync. [forum:/forumpost/d14b55e5fa19c25f|Forum post d14b55e5fa19c25f]. (Closed-Leaf check-in: aa9bd711cc user: drh tags: parseuri)
15:01
New SQL function for testing/debugging use only: parseuri(). (check-in: 37d3b6b17e user: drh tags: parseuri)
2024-10-05
22:28
Fix minor problem with error recovery after OOM in the parser. (check-in: aafab58453 user: drh tags: lateral-join)
22:02
Merge the Makefile fix from trunk. (check-in: 9403bbaaff user: drh tags: lateral-join)
21:44
Back out [2f7eab381e16] because the stderr output on systems without gmake causes grief in the testing tools. (check-in: cc6f3de032 user: stephan tags: trunk)
18:10
Allow expressions with subtypes to be read from indexes unless they are being used as direct or indirect parameters to SQLITE_SUBTYPE functions. (check-in: aa440e78e9 user: dan tags: indexed-subtype-expr)
17:37
Experimental change to allow expressions with subtypes to be read from indexes in situations where they are not used as function parameters. (check-in: ac63f98ad8 user: dan tags: indexed-subtype-expr)
15:51
Merge latest trunk changes into this branch. (check-in: a92bb48a48 user: dan tags: lateral-join)
12:06
Merge trunk into autosetup branch. (check-in: 6cbb05fde1 user: stephan tags: autosetup)
12:02
Add ext/wasm to the top-level clean/distclean rules in such a way that any error due to a lack of gmake are ignored. (check-in: 2f7eab381e user: stephan tags: trunk)
2024-10-04
17:02
Fix typo in documentation for SQLITE_SUBTYPE. No code changes. (check-in: 6733893f45 user: dan tags: trunk)
14:49
Ensure that logging is only performed for COMMIT operations that take 2 seconds or longer. (Leaf check-in: 14186d1e8d user: dan tags: bedrock-commit-instr)
14:11
Add further logging intended for use in analyzing COMMIT performance. (check-in: bbbd3d9be8 user: dan tags: bedrock-commit-instr)
2024-10-03
21:00
Add logging to help analyze COMMIT performance. (check-in: 72404dfc0d user: dan tags: bedrock-commit-instr)
16:31
Unconditionally include <ctype.h> in sqliteInt.h, even in builds where it is not needed. (check-in: 825f01d7e2 user: drh tags: trunk)
10:06
Fix to the previous: The dbpageRollbackTo() method should return SQLITE_OK. (check-in: 4dea722112 user: drh tags: trunk)
09:53
Fix missing return value from the new dbpageRollbackTo() callback. (check-in: d1e0992e1f user: drh tags: trunk)
2024-10-02
18:54
Modify the behavior of sqlite_dbpage so that the null-INSERT that truncates a database must be the very last INSERT operation within a transaction in order to be effective. This simplifies the code and also makes the behavior easier to document and understand. (check-in: b869a7d9ce user: drh tags: trunk)
17:43
Fix a typo in fts5delete.test. (check-in: b1f001435e user: dan tags: trunk)
17:04
Add the contentless_unindexed=1 option to fts5. This causes the values of any UNINDEXED columns of a contentless fts5 table to be stored persistently in the database. (check-in: 58313ac59e user: dan tags: trunk)
16:55
Adjust the new truncation behavior of sqlite_dbpage(N,null) such that it causes the database to be truncated to N-1 pages. This makes more since. An error is raised if N is less than 2. (check-in: 7d5ff86ef7 user: drh tags: trunk)
13:26
Remove all use of the "long double" data type from SQLite, as hardware support for long double is increasingly rare and the use of long double creates challenges for some compilers. (check-in: 761d8fd18b user: drh tags: trunk)
11:34
Remove a few more traces of long double from the code. (Closed-Leaf check-in: 11d6a89e4a user: drh tags: omit-long-double)
11:15
Ensure that if sqlite3_snapshot_get() is called immediately after a "BEGIN", then it locks the database such that the returned snapshot object may not be invalidated by a writer or checkpointer until after the sqlite3_snapshot_get() caller has closed its transaction. (check-in: eb5277e490 user: dan tags: trunk)
11:11
Merge latest trunk changes into this branch. (Closed-Leaf check-in: 2b3945e6a5 user: dan tags: snapshot_get-locking)
11:11
Update docs for sqlite3_snapshot_get(). (check-in: 78c3892ab7 user: dan tags: snapshot_get-locking)
2024-10-01
20:38
Rationalize code further. And add tests. (check-in: 0ca002a4ab user: dan tags: fts5-tokendata-prefix)
20:29
Remove all code that makes use of the C-language "long double" datatype. (check-in: f622b52024 user: drh tags: omit-long-double)
19:10
New #ifdefs to omit code that is unused when SQLITE_USE_LONG DOUBLE is defined. (check-in: 98066e2d22 user: drh tags: trunk)
17:57
Another comment about the LONGDOUBLE wasm topic. No code changes. (check-in: 1755831cb1 user: stephan tags: trunk)
17:08
Use the new SQLITE_USE_LONG_DOUBLE to disable long-double support in WASM builds, as they cannot be represented in JS and this saves approximately 5.5kb in the resulting wasm file. (check-in: fa7b56f776 user: stephan tags: trunk)
16:55
Add compile-time option -DSQLITE_USE_LONG_DOUBLE=0 to omit all attempts to use "long double". Or =1 to omit attempts to use the Dekker algorithms to achieve high-resolution floating point. (check-in: ca5964ef70 user: drh tags: trunk)
13:40
Get more of the CLI utils building. (check-in: 6838b7b5d6 user: stephan tags: autosetup)
11:09
Correct missing LDFLAGS_ZLIB for libsqlite3.so. (check-in: 98bbba3a05 user: stephan tags: autosetup)
11:04
Fix reversed logic in the build/target/host names in several hwaci-* functions. (check-in: fde7257ad9 user: stephan tags: autosetup)
10:49
Add an #if'd-out block to sqlite3-wasm.c mentioning the LONGDOUBLE_TYPE, as brought up in [forum:cbfb0d0ac0a4e349 | forum post cbfb0d0ac]. No functional changes. (check-in: 0b83e8f1ef user: stephan tags: trunk)
2024-09-30
19:01
Add static library build. Get build working (for a given value of working) with the --disable-amalgamation flag. (check-in: ddfda58004 user: stephan tags: autosetup)
18:19
Fix the character width tables for the CLI such that all unicode code-points less than 0x300 have a width of 1. This is in fact the case for Mac, Ubuntu, and Windows. (check-in: f0c5a86fef user: drh tags: trunk)
17:57
Merge the latest trunk enhancements, via the wal2 branch, into the bedrock branch. (check-in: fd6ff55141 user: dan tags: bedrock)
17:53
Fix a usan warning in test_hexio.c on this branch. (check-in: 59fba0288d user: dan tags: wal2)
17:44
More generic build tinkering. (check-in: 433bfc7902 user: stephan tags: autosetup)
17:32
Merge the latest trunk enhancements, including fix for assert() failure in fts5, into the wal2 branch. (check-in: ab63561812 user: dan tags: wal2)
17:28
In fts5, avoid starting a new merge of level L if there exists already an ongoing merge of a level less than L. (check-in: 350c6e75ce user: dan tags: trunk)
15:17
Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 1ba833743d user: drh tags: reuse-schema)
14:41
Merge the latest trunk enhancements into the wal2 branch. (check-in: 0f9e2fceec user: drh tags: wal2)
14:33
Generic build tinkering. (check-in: b6c1772ce0 user: stephan tags: autosetup)
12:39
Merge all the latest trunk enhancements into the begin-concurrent branch. (check-in: 1bf073d7c0 user: drh tags: begin-concurrent)
2024-09-28
20:45
Rationalize some of the new code on this branch. (check-in: 66f209ba40 user: dan tags: fts5-tokendata-prefix)
19:52
Fix the CLI so that the --bom option only outputs a single BOM, not two. (check-in: 76b6331e6a user: drh tags: trunk)
15:20
Merge trunk changes into this branch. (Closed-Leaf check-in: 81d48df62c user: dan tags: fts5-contentless-unindexed)
15:13
Add another missing mkdir to the wasm build process. (check-in: e815055b32 user: stephan tags: trunk)
15:09
Add tests for DELETE on contentless, contentless-delete and contentless-unindexed fts5 tables. (check-in: 74832fffb6 user: dan tags: fts5-contentless-unindexed)
14:51
Get libsqlite3.so building. (check-in: c65e3679e0 user: stephan tags: autosetup)
13:51
Complete a line of documentation which was interrupted mid-sentence. (check-in: c9cbbeda3d user: stephan tags: trunk)
12:01
wasm: move the makefile-eval-generated fiddle rules into mkwasmbuilds.c. Squelch some warnings from grep when running 'make clean' on a clean tree. (check-in: 0485d1360b user: stephan tags: trunk)
11:23
Ensure that the temporary build dir is mkdir'd by wasm deps which depend on it. (check-in: cabdf97972 user: stephan tags: trunk)
11:03
For wasm builds: automatically use higher optimization (but slower build) levels when a target related to deliverables (as opposed to dev mode) is explicitly invoked. (check-in: 45361ab974 user: stephan tags: trunk)
00:41
Latest upstream autosetup for a --help fix on QNX. (check-in: b9faebbb54 user: stephan tags: autosetup)
00:39
Minor makefile doc fixes. No functional changes. (check-in: b3ad58e1fc user: stephan tags: trunk)
00:37
Merge trunk into autosetup branch for latest wasm pieces. (check-in: c3877d1241 user: stephan tags: autosetup)
00:02
Merge wasm-build-rework branch into trunk. Summary: 1) add optional bare-bones build, stripped of many optional library features, 2) replace much of the hyper-spaghetti wasm-specific makefile code with a more legible static code generator. (check-in: 208c277146 user: stephan tags: trunk)
2024-09-27
23:45
Fix fiddle build broken by recent build-level reworks. Remove a stale reference to an old CSS file. (Closed-Leaf check-in: f904b3b784 user: stephan tags: wasm-build-rework)
19:21
Extra test cases for UPDATEs of contentless tables. (check-in: 4d11d844de user: dan tags: fts5-contentless-unindexed)
19:10
Fix a problem with UPDATE statements that modify the rowid of contentless_delete=1 tables. (check-in: d69abca821 user: dan tags: fts5-contentless-unindexed)
18:32
Fix a problem with UPDATEs that do not modify all UNINDEXED columns of a contentless_delete=1, contentless_unindexed=1 table. (check-in: b6b1db8d34 user: dan tags: fts5-contentless-unindexed)
16:43
Merge trunk into the autosetup branch. (check-in: 9586ea204c user: stephan tags: autosetup)
16:20
Squash sign-comparison warnings reported in [forum:5e605a763a65c3f8 | forum post 5e605a763a65c3f8]. (check-in: e74fce93c5 user: stephan tags: trunk)
13:29
Add basic libreadline detection and build CLI shell. (check-in: 2ba7ab5625 user: stephan tags: autosetup)
12:15
General tinkering and cleanups in the autosetup bits. (check-in: a290e3b15d user: stephan tags: autosetup)
11:35
Merge trunk changes into this branch. (check-in: 4a26a4e001 user: dan tags: fts5-contentless-unindexed)
10:57
Allow UPDATEs of unindexed columns in fts5 contentless_unindexed=1 tables. Testing to come. (check-in: cd36d66c88 user: dan tags: fts5-contentless-unindexed)
09:40
Rename TCL_GENERATOR to BTCL for consistency with BCC/TCC. (check-in: a7ff8f3c2c user: stephan tags: autosetup)
03:16
Disable the optional extending of JimTCL on the grounds of YAGNI. (check-in: f395c269d5 user: stephan tags: autosetup)
03:04
General auto.def cleanups, mostly around JimTCL. Swap out impl for the sqlite_cfg.h generator - this approach is lower-maintenance (requires no hand-maintained template) but may not be compatible with expectations. (check-in: da197946db user: stephan tags: autosetup)
02:35
Tweak build to fall back to system-side tclsh if we cannot find realpath() or _fullpath() for JimTCL (needed for some of the code generator scripts to work). (check-in: b31dbb9945 user: stephan tags: autosetup)
01:42
Run all of the TCL-based code generators using JimTCL. (check-in: 3193b86a91 user: stephan tags: autosetup)
01:30
Generate sqlite3.h/.c with jimsh, somewhat to my surprise. (check-in: c365d8e1f7 user: stephan tags: autosetup)
01:25
Experimentally build shell.c using the autosetup-provided JimTCL. (check-in: 5bd62cdbc4 user: stephan tags: autosetup)
01:04
Remove some gratuitous overengineering before it can spread. (check-in: 94340011ed user: stephan tags: autosetup)
01:00
Get the generated .c/.h files generating. (check-in: e890c8508d user: stephan tags: autosetup)
2024-09-26
22:25
Fix a harmless compiler warning in the CLI. (check-in: 27ef1909bb user: drh tags: trunk)
21:09
Re-indent some tcl code. (check-in: 34ea629a07 user: stephan tags: autosetup)
21:08
Latest hwaci-common.tcl after refactoring to facilitate including a copy in the libfossil tree. (check-in: feea65bcd5 user: stephan tags: autosetup)
19:38
Add the ext/misc/sqlite3_stdio.c portability interface and incorporate it into the CLI, sqldiff, and sqlite3_analyzer. Enhance the CLI with the new ".www" dot-command and related options on .once and .output. (check-in: f97f9944b8 user: drh tags: trunk)
19:16
Provide SQLITE_U8TEXT_ONLY and SQLITE_U8TEXT_STDIO compile-time options to the sqlite3_stdio.c module. (Closed-Leaf check-in: f31588520e user: drh tags: cli-stdlib)
18:40
Get lemon building. Re-indent hwaci-common.tcl for consistency. (check-in: 53dc33d5e2 user: stephan tags: autosetup)
18:13
Resolve a harmless compiler warning in QNX builds. (check-in: 2916460179 user: stephan tags: trunk)
18:02
When possible, avoid taking wal file read-lock 0 in sqlite3_snapshot_get(). (check-in: 34b6ac3d76 user: dan tags: snapshot_get-locking)
14:09
Do not remove *.def in the cleanup rules because auto.def is a required part of autosetup. Remove the .o vs .obj detection/distinction because the Unix-like Windows environments use .o. (check-in: 65eb1072e2 user: stephan tags: autosetup)
13:12
Clarification of the meaning of the nByte parameter to sqlite3_prepare(). Comment and documentation change only - no changes to the code. (check-in: 92d71eee4f user: drh tags: trunk)
12:16
Cleanups of the --with-wasi-sdk bits. Straighten out VERSION vs RELEASE. (check-in: 7638f3ad15 user: stephan tags: autosetup)
08:53
Merge current trunk into this branch. (check-in: 683a9e1e2f user: stephan tags: autosetup)
08:25
Remove a misled acrobatics related to cross-compilation, based on suggestions from Steve Bennett. Add a quick-n-dirty placeholder check for tclsh to move that part along. (check-in: c419168938 user: stephan tags: autosetup)
01:29
Fix shell test cases to account for recent additions to the ".help" output. (check-in: 54c22bc616 user: drh tags: cli-stdlib)
2024-09-25
23:09
Time for a break. (check-in: 1d29cd9095 user: stephan tags: autosetup)
22:13
Integrate the configure-time Emscripten bits. (check-in: 456125a144 user: stephan tags: autosetup)
18:55
Change the way tokendata indexes are collected for prefix queries. (check-in: 204ddf4e72 user: dan tags: fts5-tokendata-prefix)
18:03
Further streamlining of auto.def. (check-in: 74d1243359 user: stephan tags: autosetup)
16:11
Always show HTML table headers in ".www" output mode. (check-in: 660ca5ce66 user: drh tags: cli-stdlib)
15:55
Add the --plain option to the ".www" dot-command. (check-in: a9209519f6 user: drh tags: cli-stdlib)
15:26
Have the zipfile and fileio extensions use sqlite3_stdio.c when it is available - such as when those extensions are preloaded into the CLI. (check-in: 74bbb2b2b4 user: drh tags: cli-stdlib)
14:58
Improve common feature flag handling a bit. (check-in: 8716c35eaa user: stephan tags: autosetup)
14:38
Lots of work on auto.def and the utility tcl lib. Still lots more to do. (check-in: 2141527a38 user: stephan tags: autosetup)
14:09
Redirect timer output just like any other text. (check-in: 3b5ae21074 user: drh tags: cli-stdlib)
13:56
Improvements to ".www" and ".output -w" so that text that is not part of query output is shown using <pre>. (check-in: f8ef65c523 user: drh tags: cli-stdlib)
13:29
Add the "www" output mode that include <table> in the HTML output. Add the ".www" command and the "-w" option to ".once". (check-in: b06fd9e6bc user: drh tags: cli-stdlib)
12:56
Always include a UTF-8 BOM at the beginning of the output CSV when using the ".excel" command on Windows, as the actual Excel program requires the BOM in order to work correctly. (check-in: 04727fc002 user: drh tags: cli-stdlib)
12:16
Change --enable-tempstore to --with-tempstore to avoid the uphill (and losing) battle with autosetup's built-in handling of the --enable/--disable prefixes. (check-in: 8bea45fbbf user: stephan tags: autosetup)
12:03
Prevent regular DELETE and UPDATE statements from running against contentless_unindexed=1 tables that are not also contentless_delete=1. (check-in: 21539e9d0d user: dan tags: fts5-contentless-unindexed)
11:38
Fix stray fputs() calls in the CLI. (check-in: 1ee3fa0f0e user: drh tags: cli-stdlib)
11:27
Use sqlite3_fgets() instead of fgetc() to end the startup debugging pause in the CLI. (check-in: 869b3c05e8 user: drh tags: cli-stdlib)
09:43
Merge trunk enhancements, and especially the zero- and double-width character processing for columnar outputs into the cli-stdlib branch. (check-in: d6262a4bcd user: drh tags: cli-stdlib)
09:39
In the CLI, for columnar output formats, try to account for the presence of zero-width and double-width characters in the output and adjust column widths accordingly. (check-in: 9592b9ba3a user: drh tags: trunk)
09:33
Improvements to comments on data structures and subroutines. (Closed-Leaf check-in: b217e3004b user: drh tags: variable-width-char)
08:04
Baby steps towards a working auto.def. (check-in: c223dbb4fb user: stephan tags: autosetup)
07:30
Add --enable-tempstore support and document some of the weirdness of trying to use an explicit prefix of --enable with non-boolean flags (autosetup unconditionally handles --enable and --disable prefixes on its own and always treats them as boolean flags). (check-in: fe6fa4ce52 user: stephan tags: autosetup)
06:25
Re-enable the --enable-all bits after figuring out that autosetup(options) is not a dict, but a list. (check-in: beb2a12045 user: stephan tags: autosetup)
06:07
Disable with --enable-all bits, as the helper function it uses is dying for reasons beyond my meager tcl-fu. (check-in: d2b883120e user: stephan tags: autosetup)
04:34
Correct some copy/paste errors in the previous checkin. (check-in: 9752768d8a user: stephan tags: autosetup)
04:20
Get --enable-all flag essentially working. (check-in: 0a49436c98 user: stephan tags: autosetup)
03:37
Get several of the --enable/--disable configure flags working. (check-in: fd16d53d3a user: stephan tags: autosetup)
02:00
Testing libfossil checkin fix for inheritance of privateness. Edit: the test passed but this branch was subsequently made non-private because working with private branches is tedious. (check-in: 4b104926bf user: stephan tags: autosetup)
01:39
Get skeleton auto.def running, but it doesn't really do much except some standard boilerplate stuff. (check-in: e707634cf7 user: stephan tags: autosetup)
2024-09-24
21:54
Minor wasmfs speedtest1 build tweaks. Disable one wasmfs demo which was broken by Emscripten-side changes. (check-in: 5ccc85d8f5 user: stephan tags: wasm-build-rework)
21:08
Initial pristine autosetup bits. (check-in: dfb1e7f0cc user: stephan tags: autosetup)
19:47
Fix over-length lines in the shell source code. (check-in: f3fdf76a0d user: drh tags: cli-stdlib)
19:19
Fix error messages in the shell. (check-in: aeef82e974 user: drh tags: cli-stdlib)
18:01
Get fiddle working again on this branch. (check-in: 0f228317c6 user: drh tags: cli-stdlib)
17:49
Port sqlite3_analyzer.exe to use sqlite3_stdio. (check-in: 7c1c1226d8 user: drh tags: cli-stdlib)
17:40
Port sqldiff over to use sqlite3_stdio. (check-in: 18f784c47d user: drh tags: cli-stdlib)
16:09
Get output redirection working again in the CLI. (check-in: 086034c350 user: drh tags: cli-stdlib)
15:43
Merge trunk changes into this branch. (check-in: 9945206e6e user: dan tags: fts5-tokendata-prefix)
15:11
Fix a memory leak in sqlite3expert.c introduced by [f1d76c86]. (check-in: 42bb941584 user: dan tags: trunk)
13:46
Add the sqlite3_stdio.h library for Windows console I/O. (check-in: fcd0ecffc9 user: drh tags: cli-stdlib)
13:00
Minor tweaks in mkwasmbuilds.c. (check-in: cee4328072 user: stephan tags: wasm-build-rework)
12:16
Wasm build cleanups. Fix the wasm speedtest1 builds broken by yesterday's refactoring. (check-in: 5d4a090230 user: stephan tags: wasm-build-rework)
11:26
Avoid an error in sqlite3expert if the database has existing indexes on expressions. (check-in: f1d76c8636 user: dan tags: trunk)
10:30
Use _wfopen() instead of fopen() on Windows in the CLI. (check-in: 21a8cac5e9 user: drh tags: cli-stdlib)
09:51
Always use fputws() for output to a Windows command-line prompt. (check-in: 33950a8c3f user: drh tags: cli-stdlib)
00:53
Remove an ALWAYS() that can sometimes be false, with wildly incorrect SQL inputs. dbsqlfuzz 707afcf73930de2624cdeca0ad1f0deea982dfea (check-in: 766cf5535b user: drh tags: trunk)
00:31
Further wasm build cleanups and tweaks. No functional changes. (check-in: 3b72a14343 user: stephan tags: wasm-build-rework)
00:01
In the CLI, when displaying results in a columnar format, take into account zero-width and double-width Unicode characters. (check-in: 47cfad71ed user: drh tags: variable-width-char)
2024-09-23
22:56
Typo fix in makefile comments. (check-in: a4a1287fe8 user: stephan tags: wasm-build-rework)
21:22
wasm: replace much of the eval makefile spaghetti with equivalent code generated from a small C app. It turns out that's easier to read and write than doing the same thing from shell or tcl code, due entirely to C's lack of need for escaping dollar signs. (check-in: 5440de4890 user: stephan tags: wasm-build-rework)
20:23
CLI uses only lib-c for I/O on Windows. No calls to Win32. Works on Win11, at least. Reads and writes unicode to/from the console and UTF-8 to/from files. Prototype code only - must testing and additional work required. (check-in: 5c54530d5a user: drh tags: cli-stdlib)
19:32
Fix a couple of problems with the sessions streaming interfaces. (check-in: 9a1fc8d36b user: dan tags: trunk)
17:06
Merge current trunk into this branch. (check-in: ed47d7f9a4 user: stephan tags: wasm-build-rework)
2024-09-21
17:27
Add the run-fuzzcheck target to the MSVC makefile. (check-in: 2e5194407a user: drh tags: trunk)
15:57
If the database filename pointer passed to sqlite3_open() is a null pointer change it into ":memory:". (check-in: 62e11a3a78 user: drh tags: trunk)
2024-09-20
17:41
Fix comment typo in the fileio.c extension. No changes to code. (check-in: bf2c5b368a user: drh tags: trunk)
17:38
Passing shell tests on Linux and Windows. A number of FILE* API content transfer calls are diverted to the consio library via macros. (Leaf check-in: 1546546287 user: larrybr tags: win-dupe-crt-fio)
14:18
Fix flub in cfWrite(). (for Win32) (check-in: 3884ddb4dc user: larrybr tags: win-dupe-crt-fio)
13:13
Sync with trunk. Buildable. (A WIP, to be further tested) (check-in: 187f1d0a1c user: larrybr tags: win-dupe-crt-fio)
12:58
New assert()s to help verify union access. No logic changes. Testing and validation code only. (check-in: b7b64c53f5 user: drh tags: trunk)
02:08
Move non-console FILE* I/O to {Read,Write}File() on Win32. (This is a WIP. It builds but needs more testing.) (check-in: b769ed0027 user: larrybr tags: win-dupe-crt-fio)
2024-09-19
15:44
Fix harmless compiler warning in the vfstrace extension. (check-in: c8b4d092a2 user: drh tags: trunk)
13:39
Improved rebustness to malformed UTF-16 inputs to sqlite3_prepare16_v2(). (check-in: 7b3a517b3e user: drh tags: trunk)
00:05
Remove a stray newline. (check-in: 77f587dc3b user: mistachkin tags: trunk)
2024-09-18
16:33
Improvements to the scope of valueFromFunction(). (check-in: a0f39419cb user: drh tags: trunk)
15:52
Fix the preupdate hook so that it works when the "old.*" row has a column with a non-NULL default value that was added by ALTER TABLE ADD COLUMN after the current record was created. (check-in: 6a8c687904 user: dan tags: trunk)
15:38
Fix sqlite3-rsync so that it recognizes drive-letters on the front of pathnames in Windows, and does not misinterpret them as hostnames. (check-in: 54a3bbd578 user: drh tags: trunk)
15:02
Fix the preupdate hook so that it works when the "old.*" row has a column with a non-NULL default value that was added by ALTER TABLE ADD COLUMN after the current record was created. (Closed-Leaf check-in: 00a398cf90 user: dan tags: preupdate-hook-fix)
2024-09-17
22:57
Fix harmless static analyzer warning in sqlite3-rsync. (check-in: a63e412b6b user: drh tags: trunk)
21:42
Add assert() statements to some of the sqlite3_bind() APIs that help human readers and static analyzers, both, reason about the code and verify that it is memory safe. (check-in: 9752878814 user: drh tags: trunk)
10:36
In sqlite3-rsync, do not allow the '/' character to appear anywhere in the USER@HOST: prefix to one of the argument databases. (check-in: 6089a90463 user: drh tags: trunk)
2024-09-16
20:53
Fix a typo in an error message in sqlite3-rsync. (check-in: 3f25d6c8ea user: drh tags: trunk)
14:11
Cleanup the sqlite3-rsync executable as part of "make clean" (check-in: 8c5e481b49 user: drh tags: trunk)
10:58
In sqlite3-rsync, open the replica database using ATTACH since the sqlite3_dbpage virtual table is technically a part of "main". This avoids locking problems. (check-in: 39c56c836a user: drh tags: trunk)
09:12
Improved error message in sqlite3-rsync if the SQL statement for ORIGIN_TXN fails. (check-in: 73bde71ed1 user: drh tags: trunk)
2024-09-15
18:37
Provide more opportunity for the remote side in sqlite3-rsync to send error messages back to the local side. Be sure to invoke pclose2() when done. (check-in: 23a6350515 user: drh tags: trunk)
2024-09-14
20:30
Fix the fts5 xInstToken() API for prefix queries that do not use prefix-indexes. This is experimental. (check-in: 97c2824f47 user: dan tags: fts5-tokendata-prefix)
16:52
Merge subsequent changes to sqlite-rsync that were accidentally missed by the prior check-in. (check-in: 50762ba078 user: drh tags: trunk)
16:39
Enhancements to sqlite_dbpage() so that it accepts INSERT statements that can extend or truncate the database. Add the sqlite3-rsync utility program that make a copy of a live database over SSH. (check-in: b7a8ce4c8c user: drh tags: trunk)
16:30
CLI arg handling robustness improvements. (Leaf check-in: 129aca54f6 user: stephan tags: sqlite3-rsync)
16:28
Add the --version option. (check-in: 9961334c80 user: drh tags: sqlite3-rsync)
16:03
New debugging options: --logfile, --errorfile, --remote-errorfile. If page 1 changes, always send it last. (check-in: 2d8cd76691 user: drh tags: sqlite3-rsync)
11:38
Always show the -v traffic message even if there are multiple -v options. (check-in: fc05a5b7f7 user: drh tags: sqlite3-rsync)
11:23
Add the --logfile FILE option for debugging. (check-in: 30e1b92d56 user: drh tags: sqlite3-rsync)
10:59
Improved error messages coming out of sqlite3-rsync. (check-in: 452fb6de39 user: drh tags: sqlite3-rsync)
10:48
Make the output from sqlite3-rsync with a single -v option the same as it is with regular rsync. Only show the SSH command with two or more -v options, or if there is an error in popen2(). (check-in: 105ec44b47 user: drh tags: sqlite3-rsync)
2024-09-13
23:41
Merge sqlite_dbpage fixes into the sqlite3-rsync branch. (check-in: dff76b7a34 user: drh tags: sqlite3-rsync)
21:47
Bug fix in the enhanced sqlite_dbpage for when truncating two or more ATTACH-ed databases within the same transaction. (Leaf check-in: 6aa9c8e79b user: drh tags: dbpage)
16:30
Require that the contentless_unindexed=1 option be specified before storing the values of fts5 UNINDEXED column belonging to contentless tables. (check-in: c51dc2a5e7 user: dan tags: fts5-contentless-unindexed)
16:15
Fix the hanging problem. (Closed-Leaf check-in: d57903f7fd user: drh tags: sqlite3-rsync-consio)
16:12
Fix harmless compiler warning on Windows. (check-in: 86e0219d97 user: drh tags: sqlite3-rsync)
16:10
Close the db as sqlite3_analyzer exits. (See [forum:af384c2315d9718a|forum post, "sqlite3_analyzer not closing WAL-mode db cleanly" ].) (check-in: 94ceac9884 user: larrybr tags: trunk)
16:08
Changes so that the -consio sub-branch of sqlite3-rsync will compile on Win11. It compiles, but it does not work. The process just hangs. (check-in: b4eff1fd6e user: drh tags: sqlite3-rsync-consio)
15:37
Merge latest trunk changes, including the changes to the fts5 locale=1 feature, into this branch. (check-in: d2f0d19936 user: dan tags: fts5-contentless-unindexed)
14:40
Merge sqlite3-rsync branch into sqlite3-rsync-consio branch. (check-in: c9bdbe21fe user: stephan tags: sqlite3-rsync-consio)
13:53
Improved informational output from sqlite3-rsync. (check-in: e55e3e8ec2 user: drh tags: sqlite3-rsync)
12:35
Preveious check-in was actually doing an 8-round KeccakF1600. This one corrects that to just 6 rounds. (check-in: 3c36f5814f user: drh tags: sqlite3-rsync)
12:28
Change the hash algorithm from SHA1 to a 6-round KeccakF1600 with a rate of 160. This uses about 1/3rd fewer CPU cycles. (check-in: 96c7f47a8f user: drh tags: sqlite3-rsync)
12:01
Merge sqlite3-rsync branch into sqlite3-rsync-consio branch. (check-in: 983979cc78 user: stephan tags: sqlite3-rsync-consio)
11:14
Further enhancement to PTRMAP display in showdb: Show the details of invalid entries that are within the range of the database file. Continue to ignore invalid entries beyond the end of the database file. (check-in: 4cad385b90 user: drh tags: trunk)
2024-09-12
23:30
Better initialization of new database files in sqlite3-rsync. (check-in: 75d5a8eb3d user: drh tags: sqlite3-rsync)
21:58
Enhancement to the "showdb" utility such that the "ptrmap" command shows PTRMAP entries that extend off the end of the database, as long as they appear to be well-formatted. (check-in: a9f95fe5ce user: drh tags: trunk)
21:33
A slight tweak to consio to enable it to build both (A) directly embedded in shell.c and (B) as a separately-compiled .c file for use with sqlite3-rsync.c. (check-in: 6ffb392f92 user: stephan tags: sqlite3-rsync-consio)
21:03
Add RSYNC_OPT to the sqlite3-rsync build flags. (check-in: b2a3497e55 user: stephan tags: sqlite3-rsync)
20:50
Convert sqlite3-rsync.c to use the ext/consio I/O library. The caveat is that it requires direct inclusion of the consio source code, making sqlite3-rsync.c no longer a standalone file. (check-in: 62a9b6fd55 user: stephan tags: sqlite3-rsync-consio)
18:15
Port some of the shell's CLI flag-handling code into sqlite3-rsync to make the arg handling more robust. (check-in: 53fb9b1180 user: stephan tags: sqlite3-rsync)
17:06
Replica must be in writable_schema mode. (check-in: e385525793 user: drh tags: sqlite3-rsync)
16:54
Improved --commcheck. Add the infoMsg() function which is useful for debugging. (check-in: b979d02ffd user: drh tags: sqlite3-rsync)
15:51
Pass the names of both the origin and the replica databases to the remote side, so that if the remote is the replica, it will have access to the origin database name in case the replica name is really a directory. (check-in: 435c30171d user: drh tags: sqlite3-rsync)
15:36
Add a protocol version number to the first message, and give the two sides an opportunity to negotiate a suitable protocol number, for future compatibility. Send the page size as a power-of-two. (check-in: df0623aae1 user: drh tags: sqlite3-rsync)
14:43
Add sha1() functions to the CLI. Fix sha1b() such that it actually returns a BLOB. (check-in: fe65821a3b user: drh tags: sqlite3-rsync)
12:04
Improved debugging output. (check-in: 80461e0d72 user: drh tags: sqlite3-rsync)
2024-09-11
17:02
Progress on the sqlite3-rsync utility. This is an incremental check-in. It does compile, but it does not work. (check-in: fa06977b6d user: drh tags: sqlite3-rsync)
12:17
Disable the debug-use-only functions sqlite3_mutex_held() and sqlite3_mutex_notheld() when compiling with TSAN in as much as those routines cause TSAN to complain. Response to https://issues.chromium.org/issues/41427446. (check-in: db702dd785 user: drh tags: trunk)
2024-09-10
22:14
Improved SSH infrastructure. The foundation is now in place to begin working on the actual sync protocol. Still experimental. Still a work in progress. (check-in: 9a1a95f523 user: drh tags: sqlite3-rsync)
20:32
Alternative implementation of fts5 locale=1 feature that allows blobs to be stored in indexed columns of fts5 locale=1 tables. (check-in: 198305de92 user: dan tags: trunk)
18:38
Remove a stray "breakpoint" from a test script. (Closed-Leaf check-in: 7d87a27a01 user: dan tags: fts5-locale-alternate)
17:05
Initial infrastructure for the sqlite3-rsync utility. Prototype only. Does not work. (check-in: 397b2d37b7 user: drh tags: sqlite3-rsync)
16:40
Fix a test in fts3corrupt4.test that would fail if SQLITE_ENABLE_FTS5 was not defined. (check-in: 437849c808 user: dan tags: trunk)
16:19
Alternative implementation of fts5 locale=1 feature that allows blobs to be stored in indexed columns of fts5 locale=1 tables. (check-in: 55c5c119a0 user: dan tags: fts5-locale-alternate)
12:09
Add the ability for sqlite_dbpage to truncate the database file by writing a NULL page. Experimental. (check-in: eb3c89ee2e user: drh tags: dbpage)
2024-09-09
19:12
Fix an OOM-handling problem affecting locale=1 fts5 tables. (check-in: d8103684f6 user: dan tags: trunk)
18:45
Generalize the sqlite3_dbpage virtual table so that it is able to write new pages onto the end of the database file using INSERT. (check-in: fe0d67e72d user: drh tags: trunk)
15:39
Move the vfstrace extension out of src/ and into ext/misc/. Make it a standard part of the CLI. Improve its output. Also fix some unrelated comment typos. (check-in: 123cb1f579 user: drh tags: trunk)
15:33
Fix dependencies in makefiles to include ext/misc/vfstrace.c as necessary. Improved xFileControl() output from vfstrace.c. (Closed-Leaf check-in: e8f2d63130 user: drh tags: vfstrace)
15:19
Fix harmless compiler warnings in the vfstrace.c extension. (check-in: f23954e604 user: drh tags: vfstrace)
15:12
Fix harmless compiler warnings in FTS5. (check-in: aa75e701de user: drh tags: trunk)
14:50
Move the vfstrace extension out of src/ over into ext/misc/ where it belongs. Make it part of the standard build for the CLI. Bring some of the vfstrace output up-to-date. (check-in: 055b97de8d user: drh tags: vfstrace)
2024-09-07
16:22
Fix a problem with fts5 locale=1 tables and UPDATE statements that may affect more than one row. (check-in: 70e42f941c user: dan tags: trunk)
16:04
Fix an off-by-one error in the routines that bind the special $test_TTT and $int_NNN parameters for fuzz testing. Fix to testing logic only - no changes to the SQLite core. (check-in: 6206b90a4e user: drh tags: trunk)
2024-09-06
20:12
Add tests for an fts5 NEAR() expression with a single argument phrase. (check-in: e319d43bfd user: dan tags: trunk)
15:52
Merge the latest trunk enhancements into the reuse-schema branch. (check-in: f9ce1ababb user: drh tags: reuse-schema)
15:45
Update the bedrock branch to include all the latest enhancements from trunk. (check-in: 4a3386ccb8 user: drh tags: bedrock)
15:42
Merge the latest trunk enhancement into the wal2 branch. (check-in: f3e3ad6945 user: drh tags: wal2)
15:39
Merge all the latest trunk enhancements into the begin-concurrent branch. (check-in: 2a87a969e7 user: drh tags: begin-concurrent)
15:01
Resolve the "No rule to make target '0'" error when building with --disable-tcl. (check-in: d94541ae76 user: stephan tags: trunk)
14:01
Fix a harmless stray carriage-return character. (check-in: 84a6c5f975 user: drh tags: trunk)
13:13
In testrunner.tcl, correctly capture and display information about the system under test: hostname, OS, pointer size, byte-order. (check-in: ec75cfc5d4 user: drh tags: trunk)
11:21
Fix harmless compiler warnings. (check-in: 60fb8ee153 user: drh tags: trunk)
10:35
A testcase() macro added to help ensure that the fix to the omit-noop-join optimization from yesterday does not regress. (check-in: 224628b103 user: drh tags: trunk)
09:49
Clarification and simplification to the README.md file and to the instructions for building on Windows. (check-in: f69ef1a37b user: drh tags: trunk)
2024-09-05
23:40
Fix a testrunner status reporting problem introduced by [aa5f10f21dbfb24e]. (check-in: d20c65c3b4 user: drh tags: trunk)
23:22
Ensure that the WhereInfo.revMask bitmap is adjusted when tables are removed from the FROM clause by the Omit-Noop-Join optimization of [0cd82ee9a8413cf1]. Fix for the issue described by [forum:/forumpost/8a1e467e905b8d27|format post 8a1e467e905b8d27]. (check-in: 22ca5a2ffb user: drh tags: trunk)
15:55
Update notes on build procedures in the README.md file. (check-in: 1d12744fe7 user: drh tags: trunk)
15:28
Testrunner.tcl enhancements: (1) Attempt to build the SQLite tcl extension if it is not already available. (2) testrunner target "devtest" is added as an alias for "mdevtest". (3) Try to keep summary information at the end of a test below 80-characters per line. (4) Update the Makefile.in so that the "clean" target removes the tcl extension built by item 1 above. (check-in: aa5f10f21d user: drh tags: trunk)
12:06
Enhance testrunner.tcl to keep track of the platform and SQLite version as reported by individual test cases and to report that information in the summary at the end of each test run. (check-in: 80ebb7c7e6 user: drh tags: trunk)
11:46
Faster implementation of the aggregate_test_counts procedure inside of testrunner.tcl. (check-in: a01d869520 user: drh tags: trunk)
2024-09-04
18:51
Make the default TCLDIR be C:\Tcl in the Makefile.msc. (check-in: c2c0a9176a user: drh tags: trunk)
16:54
Update the bedrock branch to include all of the latest trunk enhancements. (check-in: cf8f155280 user: drh tags: bedrock)
16:46
Merge all the latest trunk enhancements into the wal2 branch. (check-in: 9f53034371 user: drh tags: wal2)
16:01
Fix a bug in the parsing of some corner-case JSON PATH strings that contain escaped double-quotes. (check-in: 60ac55c4b7 user: drh tags: trunk)
13:42
Put a proper shebang at the start of the testrunner.tcl script and make the script executable. (check-in: c0c6e9abeb user: drh tags: trunk)
13:09
Make extra efforts to delete the over-size directory names created by the win32longpath.test module. (check-in: 3c8035ed3f user: drh tags: trunk)
11:22
Add the "joblist" command to testrunner.tcl (check-in: f64469f480 user: drh tags: trunk)
2024-09-03
18:55
Store the values of any UNINDEXED columns of a contentless fts5 table persistently in the database. Warning: This currently creates a (technically) incompatible file-format for contentless fts5 tables that have UNINDEXED columns. (check-in: dcacb1a8ef user: dan tags: fts5-contentless-unindexed)
17:01
Add SQLITE_USE_ONLY_WIN32 to the Default configuration for testing on Windows. Take it off of Stdcall. (Leaf check-in: 8ace3f15e4 user: drh tags: new-win32-test-config)
16:04
Enhance the "errors" command in testrunner.tcl so that it accepts the "-s" or "--summary" argument to see a list of failed jobs, and so that an additional argument is a GLOB pattern that restricts the output to jobs whose names match that pattern. (check-in: dcbebe30f5 user: drh tags: trunk)
14:15
Fix ext/consio so that it works correctly with SQLITE_USE_ONLY_WIN32. (check-in: efc6f3d7e9 user: drh tags: trunk)
14:00
In testrunner.tcl, compile the Windows Default configuration using SQLITE_ENABLE_STMT_SCANSTATUS. (check-in: 49e8b1635f user: drh tags: trunk)
12:41
Fix harmless compiler warnings in the percentile extension. (check-in: c5557f281c user: drh tags: trunk)
10:53
In testrunner.tcl, allow setting njob to zero, which causes no new jobs to be launched and for the process to shut down once all current jobs are completed. (check-in: 0ef65fd4ba user: drh tags: trunk)
02:09
Cause cfGets() (under SQLITE_USE_ONLY_WIN32) to better emulate fgets(). (check-in: 2d783524d1 user: larrybr tags: win-dupe-crt-fio)
2024-09-02
21:59
Fix possible NULL pointer dereference following OOM in the new error reporting logic of the percentile extension. (check-in: 7891a266c4 user: drh tags: trunk)
18:41
Fix a technically undefined signed integer overflow in fts5. (check-in: e6bec37ea1 user: dan tags: trunk)
17:27
Make the percential extension easier to incorporate as a built-in on Windows applications. (check-in: 831e2be411 user: drh tags: trunk)
14:46
Remove some debug/test code from percentile. Make the extension easier to statically link. (check-in: 6e5f146e27 user: drh tags: trunk)
12:07
Enhance the percentile extension to support percentile_cont() and percentile_disc(). Add support for ordered-set aggregate notation in the parser when compiling with SQLITE_ENABLE_ORDERED_SET_AGGREGATES. A new function property SQLITE_SELFORDER1 must appear on any aggregate function that wants to take advantage of the ordered-set aggregate notation. (check-in: 557bd245ef user: drh tags: trunk)
11:17
Improved error messages on percentile functions. More tests cases for percentile and for ordered-set aggregates. (Leaf check-in: e1bca168e7 user: drh tags: ordered-set-agg)
09:40
Change the name of the enabling compile-time macro to SQLITE_ENABLE_ORDERED_SET_AGGREGATES. (check-in: 3b1cdddf83 user: drh tags: ordered-set-agg)
2024-09-01
23:56
More internal documentation improvements. (check-in: 8b91b74931 user: drh tags: ordered-set-agg)
23:47
Improved documentation of recent enhancements to the percentile extension. (check-in: 51e7b4c9cf user: drh tags: ordered-set-agg)
23:27
The WITHIN GROUP (ORDER BY ...) syntax is now a compile-time option: SQLITE_ENABLE_ORDERED_SET_FUNCS. There is no increment in the code size if the option is omitted. (check-in: c9367e2532 user: drh tags: ordered-set-agg)
20:24
Implement percentile_cont() and percentile_disc(). (check-in: b1a93f67d6 user: drh tags: ordered-set-agg)
19:19
No prepare-time penality for ordered-set aggregates for applications that do not use them. (check-in: e070c16d21 user: drh tags: ordered-set-agg)
18:57
Merge fixes from trunk into the ordere-set-agg branch. (check-in: 7528ddcfdf user: drh tags: ordered-set-agg)
18:54
Improved sort function in the percentile extension. (check-in: 9f84e8d59b user: drh tags: trunk)
10:52
Fix to the quicksort algorithm in the percentile extension. (check-in: 54313f74b2 user: drh tags: trunk)
2024-08-31
22:22
Add error checking: Do not allow functions other than those in the percentile extension to use the ordered-set aggregate notation. (check-in: 317d901429 user: drh tags: ordered-set-agg)
20:09
Demonstration of how ordered-set aggregates might be parsed and integrated into the existing parse tree, should we decide to support them. (check-in: ef97778900 user: drh tags: ordered-set-agg)
19:24
Include percentile() and merge() in the fuzzcheck test utility. (check-in: d1d0942a94 user: drh tags: trunk)
18:35
Omit the percentile_cont() function added by [095c22e62248f8ef] (and not yet released) since its usage conflicts with the PG percentile_cont() function. (check-in: 3fe0a85297 user: drh tags: trunk)
18:08
Allow percentile() and median() to act as window functions. (check-in: 94cf96af8f user: drh tags: trunk)
17:50
Still more test cases. (Closed-Leaf check-in: f099046081 user: drh tags: percentile-window)
17:27
Add more test cases. (check-in: 0d0e545679 user: drh tags: percentile-window)
16:55
Avoid unnecessary sort operations when running one of the percentile aggregates as a window function. (check-in: 5d31153621 user: drh tags: percentile-window)
15:02
Test cases added. (check-in: 25e6822984 user: drh tags: percentile-window)
14:31
Enhance the percentile() and median() extension functions so that they can be window functions. (check-in: 4d0e3df4b9 user: drh tags: percentile-window)
2024-08-30
17:33
Do not fail the omittest if ICU libraries are not installed. (check-in: ddc55efd2d user: drh tags: trunk)
16:51
New makefile target: "tidy". The "tidy" target removes all build products be leaves behind test results. The "clean" target has been enhanced to do a better job. The tool/omittest.tcl script is rewritten to work on the configure-generated Makefile and to require no arguments. (check-in: e48add0269 user: drh tags: trunk)
16:43
A couple of #defines so that the build work with SQLITE_OMIT_FLOATING_POINT. (Closed-Leaf check-in: be768f80c7 user: drh tags: makefile-improvements)
16:24
Rework the tool/omittest.tcl script so that it works with the configure-generated Makefile, and requires no arguments. Update the configure-generated Makefile with a new "tidy" target which is like "clean" except that is preserves test logs. Use "make tidy" to force everything to be recompiled from scratch without destroying logs. (check-in: 99491df19d user: drh tags: makefile-improvements)
12:10
Improvements to "make clean" on unix. (check-in: a1d775f075 user: drh tags: makefile-improvements)
01:11
In the testrunner.tcl status report, try to provide a rough estimate of the time remaining. (check-in: 90bc616d20 user: drh tags: trunk)
2024-08-29
23:43
Merge the latest trunk enhancement into the bedrock branch through the wal2 intermediary. (check-in: ff94464cec user: drh tags: bedrock)
23:33
Merge all the latest trunk enhancements into the wal2 branch. (check-in: dfecc79c8f user: drh tags: wal2)
23:32
Sync the autoconf/Makefile.msc with the main ./Makefile.msc (check-in: 9de47c3611 user: drh tags: trunk)
23:26
Sync the amalgamation makefile for MSVC with the main makefile. (check-in: fcc4c3b484 user: drh tags: begin-concurrent)
23:24
Merge all the latest trunk enhancements into the begin-concurrent branch. (check-in: b05d30bec1 user: drh tags: begin-concurrent)
22:05
Fix a problem in winOpen(). Merge the makefile enhancements from trunk. (check-in: bd247ae7f9 user: drh tags: reuse-schema)
19:37
Fix tests cases for SQLITE_ENABLE_SHARED_CACHE so that they work on Windows. (check-in: 60795a30c6 user: drh tags: reuse-schema)
18:32
All makefiles are responsive to OPTIONS=... command-line arguments, and add the RHS value of OPTIONS= to builds and to lemon and other build steps that might respond to -D or -U options. (check-in: 854b3776ee user: drh tags: trunk)
17:42
Merge all the latest trunk enhancements into the reuse-schema branch. (check-in: 87aa6fc212 user: drh tags: reuse-schema)
16:27
Fix a case where the BTCF_AtLast flag was being left set incorrectly. This was causing obscure window function queries to fail. (check-in: e042eb0247 user: dan tags: trunk)
2024-08-28
19:13
Do not allow sqlite3_blob_open() to work on a any table that contains generated columns, even columns of the table which are not generated themselves, because such columns might be part of the expression of a STORED column. This restriction could be relaxed some, but that would be a lot of code for something that nobody ever uses. (check-in: 6e84947123 user: drh tags: trunk)
15:54
Fix a dropped error code in fts5. (check-in: df55502e4f user: dan tags: trunk)
13:55
Update the README.md file to recommend running "devtest" instead of "mdevtest". (check-in: eb016f66ea user: drh tags: trunk)
13:51
Maybe [7420b13238da4e6b] was not such a good idea. Restore "make test" so that it works as before - running a single-threaded test over the source tree with options specified by ./configure and similar. Instead, change the "make devtest" target so that runs the automated multi-threaded tests on a standard configuration. (check-in: dc9fee980d user: drh tags: trunk)
13:34
Minor wording change on testrunner output. (check-in: 115e685979 user: drh tags: trunk)
12:10
Update the "make test" target so that it is really just "mdevtest" with "srctree-check" and "sourcetest". (check-in: 7420b13238 user: drh tags: trunk)
11:03
Further improvements to the status display in order to maximum the amount of information shown on the limited screen realestate available when running via "watch" or in continuous monitoring mode. All details are still shown when doing a stand-alone "status". (check-in: 557a2c65f5 user: drh tags: trunk)
10:36
Only limit the number of failures reported by testrunner status if using VT100 cursor movement. For a straight-up "status" command, show everything. (check-in: 791237e0f4 user: drh tags: trunk)
10:25
In the testrunner status display, limit the number of reported failed jobs to avoid overflowing the terminal when there are many failures. (check-in: ffeaa4d5d7 user: drh tags: trunk)
09:47
Disable shell test cases that require virtual tables when testfixture is built using SQLITE_OMIT_VIRTUALTABLE. (check-in: 8c73d54fd1 user: drh tags: trunk)
09:31
Reenable SQLITE_OMIT_VIRTUALTABLE on the Device-One alignment for testrunner. (check-in: 8f2cb35763 user: drh tags: trunk)
2024-08-27
22:28
Changes to the way "release" tests were constructed in [d03d35eebaf82709] were incorrect. Fixed here. Also enhance --explain to chose permutation configurations and so that PATTERNS on the the command line can match against permutation configurations. (check-in: 1f962ffc9e user: drh tags: trunk)
21:44
Improvements to --status overwrite in testrunner. (check-in: 26372762ab user: drh tags: trunk)
20:37
Avoid reading the structure record from within the fts5 xConnect method. (check-in: 6a6ce343b2 user: dan tags: trunk)
19:49
Further minor improvements and tweaks to the testrunner --status display. (check-in: 7d1ccc6dfc user: drh tags: trunk)
19:48
Fix typo in the previous check-in. Ensure that --status header lines do not overflow and wrap. (Closed-Leaf check-in: 2eaea67495 user: drh tags: testrunner-fix)
19:43
In testrunner, when doing the --status updates to the screen, be sure to overwrite dead text at the end of each line with spaces. (check-in: 7c195f132c user: drh tags: testrunner-fix)
19:28
Further improvement to the status display in testrunner.tcl. Show the number of errors and the number of test cases on the status summary. (check-in: dbc1ac8692 user: drh tags: trunk)
19:27
Modify the implementation of "wrapper" tokenizers to make them more robust in the case where the database connection is closed before the tokenizers are deleted. (check-in: 7c0001d6eb user: dan tags: trunk)
19:17
Improvements to testrunner.tcl: Show elapse time in MM:SS or HH:MM:SS. Keep track of the total number of tests and the total number of errors and report those values on a summary line at the end. (check-in: 40b232924c user: drh tags: trunk)
18:25
Add test code to drop an fts5 table with corrupt records in its shadow tables. (check-in: ca21c942c3 user: dan tags: trunk)
17:38
Updates to testrunner: (1) Omit all testing of User-Auth. (2) Automatically add the "*" wildcard before and after all pattern arguments. (3) Build the sqlite3 CLI for release tests. (check-in: d03d35eeba user: drh tags: trunk)
14:35
Merge the SQLITE_USE_ONLY_WIN32 flag for consio into trunk. (check-in: e9b03b082d user: drh tags: trunk)
14:25
Only avoid all C-runtime I/O if the SQLITE_USE_ONLY_WIN32 flag is defined. (check-in: 164b1e1962 user: drh tags: win-dupe-crt-fio)
13:57
Merge all the latests trunk enhancements into the win-dupe-crt-fio branch. (check-in: 2d52db98f4 user: drh tags: win-dupe-crt-fio)
2024-08-26
19:08
Changes to documentation comments in fts5.h. (check-in: 886545a8d0 user: dan tags: trunk)
17:35
Randomize the name of the attached database used to do VACUUM. (check-in: 0f4e65d73a user: drh tags: trunk)
14:20
Remove redundant #ifdef accidentally inserted into mkkeywordhash.c. Update 2024-08-27: This branch demonstrates that FROM-first queries can be achieved by simply adding new production rules to the LALR(1) grammar. We do not wish to go down that path at this time. But we might revisit that idea in the future. For now, this branch is closed. (Closed-Leaf check-in: b08f3b7449 user: drh tags: sql-pipes)
14:06
Add the AGGREGATE clause to the pipeline. (check-in: 16d32676e2 user: drh tags: sql-pipes)
13:20
Working better now. (check-in: 4bdcc18d2c user: drh tags: sql-pipes)
12:26
Reduce rules added to the grammar. Kinda works, but there are still bugs. (check-in: 3c7a5cc6d0 user: drh tags: sql-pipes)
02:53
Another version of the parser with a slightly richer syntax. The ghastly pipe operator is now optional, but is never required. Pipelines cannot be initiated from an arbitrary SELECT unless the arbitrary SELECT is a subquery on the initial FROM. (check-in: 8781d7352b user: drh tags: sql-pipes)
00:15
Proof-of-concept grammar rules to parse Google-style "pipe" syntax for SQL, without the ghastly "|>" operator. The grammar rules are not connected to working code. They just parse the syntax. Pipelines that begin with an ordinary SELECT statement must have the keyword "INTO" (rather than the "|>" operator) separating the SELECT from the start of the pipeline, to avoid syntactic and semantic ambiguity. (check-in: 2c4bae3e68 user: drh tags: sql-pipes)
2024-08-25
12:04
Merge trunk into the wasm-build-rework branch. (check-in: a1cf3095a8 user: stephan tags: wasm-build-rework)
11:59
shell.c.in: use eputz/oputz() instead of eputf/oputf() where appropriate to avoid compilation errors in -std=c99 mode (namely wasm builds). (check-in: 9ef8317fae user: stephan tags: trunk)
2024-08-24
20:05
Fix harmless compiler warnings in fts5V2toV1Tokenize(). (check-in: df65d00f10 user: drh tags: trunk)
20:01
Fix compiler warnings in the CLI detected by MSVC. (check-in: 23ae505cbf user: drh tags: trunk)
19:06
Improved help message for the --enable-test-status configuration option. Fix the build for when that option is omitted. (check-in: b404a5fe3f user: drh tags: trunk)
19:02
New ./configure option --enable-test-status causes testrunner.tcl to be run with the --status option for targets like mdevtest and releasetest. (check-in: 9ca8513c26 user: drh tags: trunk)
18:42
Remove a term from an assert() that is no longer relevant. (check-in: 8b4766252b user: drh tags: trunk)
15:54
Avoid a stack overflow that could be caused by a recursively defined WINDOW() with a strategically embedded error. (check-in: bada54bd6b user: dan tags: trunk)
11:48
Ensure that the WhereLoop.u.btree.pOrderBy field added by the order-by-subquery optimization [7a0cdc7edb704a88] is correctly initialized. dbsqlfuzz 437be171a98687082a31ea6efc2fd5c5d64481c8. (check-in: b75f8b2252 user: drh tags: trunk)
2024-08-23
21:20
Eliminate use of strcpy() in shell.c.in to squelch an unwarranted link-time warning on OpenBSD. (check-in: 32e9bf7f97 user: stephan tags: trunk)
17:40
Fix a problem in the ext/fts5/extract_api_docs.tcl script. (check-in: 9a9d0f6301 user: dan tags: trunk)
15:18
Add fts5 auxiliary function fts5_get_locale(). For querying the locale of a stored value. (check-in: 396f720f36 user: dan tags: trunk)
2024-08-22
18:12
Enhance the generate_series() table-valued function such that it is able to recognize equality and inequality constraints on the "value" column and optimize its operating accordingly. (check-in: d50b784807 user: drh tags: trunk)
16:22
Add the SQLITE_INDEX_SCAN_HEX bit to the sqlite3_index_info.idxFlags bitmask. When set, this bit causes the EXPLAIN QUERY PLAN output to show the idxNum value in hex rather than in decimal. This is purely a debugging aid. (check-in: 6c00e88ebd user: drh tags: trunk)
2024-08-21
20:25
Add SQLITE_TESTCTRL_GETOPT. Use it to implement improvements to the ".testctrl opt" dot-command in the CLI, and similar enhancements to TH3. (check-in: 6500baa991 user: drh tags: trunk)
18:57
Add the new SQLITE_TESTCTRL_OPTGET that retrieves the current optimization setting. Use this in the CLI to provide symbolic fine-grain control over optimization settings using the ".testctrl opt" dot-command. (Closed-Leaf check-in: 0ea4e1e8fc user: drh tags: optimization-onoff)
17:38
Improved comments on byte-code subroutine calls to materialize subqueries. Should not affect production builds. (check-in: 6b024c85ef user: drh tags: trunk)
13:57
README.md: a markup link fix and use the canonical URL for Fossil. (check-in: c49bfee6b8 user: stephan tags: trunk)
13:44
Updates and enhancements to the README.md file. No code changes. (check-in: 3161b80289 user: drh tags: trunk)
12:01
Add code comments for a "table-of-contents" and various milestone marks in the 1300+ line long sqlite3Select() function, to help improve readiability and maintainability. Comment changes only - no functional changes. (check-in: 00cfbb9fa5 user: drh tags: trunk)
10:37
Fix a minor typo in a comment. (check-in: 92c80af112 user: drh tags: trunk)
10:32
Improvements to treetrace output for subqueries. Debug code only. (check-in: 0a835d18d9 user: drh tags: trunk)
09:56
De-duplicate some error-output code in shell.c.in as part of tracking down the cause of [forum:5647ca2af1|forum post 5647ca2af1]. (check-in: fd5904495e user: stephan tags: trunk)
07:38
Remove incorrect assert() statements in the SrcItem invariant validator. dbsqlfuzz 7f908865436ce531b0ace55c97a1c71d05c4e76c. (check-in: 81a1ede388 user: drh tags: trunk)
2024-08-20
23:11
Refactor the SrcItem object to move fields associated with subqueries out into a separate object named Subquery. This reduces the size of the SrcItem object by about 1/3rd and provides improved performance. (check-in: 484bcd75bc user: drh tags: trunk)
22:44
Fix a name resolution issue with CTEs. (Leaf check-in: 4fa8235dd5 user: drh tags: srcitem-opt)
22:05
Fix minor comment issues. (check-in: c1bbed19f4 user: drh tags: srcitem-opt)
20:01
Remove unreachable code. (check-in: 17699329aa user: drh tags: srcitem-opt)
19:09
Tighter checking of access constraints on union members in SrcItem. Improved invariant checking. (check-in: fd72d3400a user: drh tags: srcitem-opt)
17:41
Fix some stray SrcItem field name fixes. (check-in: bc5f5ce59e user: drh tags: srcitem-opt)
17:24
Fix a memory leak so that now all dev tests (including TH3) are passing. (check-in: 3995c45fff user: drh tags: srcitem-opt)
16:50
Memory issues fixes so that mdevtest now passes. (check-in: b249516f6a user: drh tags: srcitem-opt)
14:12
When the database encoding is UTF-16LE and the GLOB optimization is used, it is ok to use the range search over an index, but it is not ok to disable the actual GLOB function call. (check-in: 3399698376 user: drh tags: trunk)
12:09
Fix for the UTF-16LE problem reporte by [forum:/forumpost/dc7e1b7527e84343|forum post dc7e1b7527e84343]. Because of the unexpected ordering of characters using the default collation (memcmp() order) in UTF-16LE, the LIKE/GLOB optimization restricts its attention to the pattern prefix that is all ASCII, which is the common case. (check-in: a5797ebdea user: drh tags: trunk)
2024-08-19
23:43
Earlier error detection while processing complex aggregate queries. dbsqlfuzz 5242c2f07f4aa031aa3c80461f18e9b7619ede9b (check-in: 70f4973078 user: drh tags: trunk)
22:48
Refactor the SrcItem object so that information about subqueries is stored in a separately allocated Subquery object. This reduces the memory requirements for SrcItem and makes the code run faster. It also provides an expansion path for subquery processing that does not burden simple queries. The current checking mostly works, but there are still issues that need to be tracked down and fixed. (check-in: 8ff5dda844 user: drh tags: srcitem-opt)
20:35
Update some comments that are processed into the fts5.html webpage. (check-in: 3e06ab218b user: dan tags: trunk)
14:33
Add the fts5_locale() function and related functionality to fts5. (check-in: b963290010 user: dan tags: trunk)
14:20
Fix leap-year handling for dates prior to 0400-03-01. [forum:/forumpost/eaa0a09786c6368b|Forum post eaa0a09786c6368b]. (check-in: 474b7e34b8 user: drh tags: trunk)
13:53
New date/time test cases to validate ancient dates. (Closed-Leaf check-in: 82719074f0 user: drh tags: ancient-date-fix)
12:54
Attempt to fix date/time calculations for days earlier than 0400-03-01. See [forum:/forumpost/eaa0a09786c6368b|forum thread eaa0a09786c6368b]. (check-in: 00cae11fff user: drh tags: ancient-date-fix)
10:40
Merge trunk changes into this branch. (Closed-Leaf check-in: 6787603bd0 user: dan tags: fts5-locale)
2024-08-18
14:46
Fix a problem with detail=none, content='' tables. (check-in: 4b8070816a user: dan tags: fts5-locale)
09:53
Automatically disable directory fsync when compiling for AIX. (check-in: 8d170e07e2 user: drh tags: trunk)
2024-08-17
23:23
Give unique names to fields in the SrcItem object, to facilitate analysis of how those fields are used using "grep". (check-in: 9f5aeef3cb user: drh tags: srcitem-opt)
19:46
Reduce the size of the SrcItem object by combining fields into a union. (check-in: a4c59ac3c6 user: drh tags: srcitem-opt)
19:40
Fix a broken assert() in fts5_storage.c. (check-in: 01116e3279 user: dan tags: fts5-locale)
19:11
Merge trunk changes into this branch. (check-in: 6a8ff9ba5e user: dan tags: fts5-locale)
19:07
Tests to improve coverage of fts5_expr.c. (check-in: f4b839e526 user: dan tags: fts5-locale)
17:22
Add tests to restore coverage of fts5_tokenizer.c. (check-in: 8f9257361b user: dan tags: fts5-locale)
16:17
Adjust Makefile.in so that it outputs a slightly better error message on an attempt to build something that requires TCL libraries when HAVE_TCL is false. (check-in: a4043cbeb8 user: drh tags: trunk)
15:52
Adjust the "configure" script so that it just disables the ability to run tests rather than erroring out if tclsh is unable to recommend a suitable tclConfig.sh. (check-in: 793ff83d09 user: drh tags: trunk)
14:59
Fix a typo in an "ifdef" that broke SQLITE_OMIT_ANALYZE builds. (check-in: c09da26cb6 user: dan tags: trunk)
2024-08-16
19:05
Add tests to restore coverage of fts5_config.c. (check-in: 9d971b31df user: dan tags: fts5-locale)
19:04
Merge all the latest trunk enhancements, and especially the order-by-subquery optimization, into the bedrock branch, via wal2. (check-in: d0591db3bb user: drh tags: bedrock)
18:58
Merge the latest trunk enhancements into the wal2 branch. (check-in: a78208b597 user: drh tags: wal2)
18:51
If a subquery has an ORDER BY clause and that ordering is helpful in satisfying the ORDER BY or GROUP BY of the outer query without doing an extra sort, then omit or reduce the sort in the outer query. Call this the "order-by-subquery optimization". (check-in: 7a0cdc7edb user: drh tags: trunk)
17:54
Add tests to restore coverage of fts5_storage.c. (check-in: 38841881a0 user: dan tags: fts5-locale)
16:20
Add tests to restore coverage of fts5_main.c. (check-in: 681edd08ab user: dan tags: fts5-locale)
15:35
Ensure that memory allocations in ANALYZE are always 8-byte aligned in order to satisfy a new assert() added by [539e4f661767ef90]. (check-in: a1915cbdec user: drh tags: trunk)
11:26
Fix handling of COLLATE. Add test cases for the same. Code cleanup for improved understandability and maintainability. (Closed-Leaf check-in: 41a41c173a user: drh tags: order-by-subquery)
02:19
Bug fix in the subquery ORDER BY propagator. (check-in: 5a9a3b8af7 user: drh tags: order-by-subquery)
00:37
Improvements to the subquery ORDER BY decision algorithm. Fewer false-negatives. (check-in: b82421e3f5 user: drh tags: order-by-subquery)
2024-08-15
23:38
If a subquery is materialized due to an ORDER BY and that ordering is useful in helping to satisfy the ORDER BY or GROUP BY in the order query without doing an extra sort, then omit the extra sort. (check-in: 2fbb4dc232 user: drh tags: order-by-subquery)
20:33
Extra tests. (check-in: fb257540d3 user: dan tags: fts5-locale)
18:50
Further tests and fixes for this branch. (check-in: d27985245a user: dan tags: fts5-locale)
15:31
Improved help message for --disable-tcl on the configure script. (check-in: 96e6cfb211 user: drh tags: trunk)
15:23
Reinstate the --disable-tcl option on ./configure. [forum:/forumpost/845d4a57becc7f3c|Forum thread 845d4a57becc7f3c]. (check-in: de927016aa user: drh tags: trunk)
2024-08-14
20:00
Doc typo correction reported in the forum. (check-in: 48900a867c user: stephan tags: trunk)
17:58
Improved documentation for the sha3() SQL functions in the shathree.c extension in ext/misc. (check-in: 0ce609103e user: drh tags: trunk)
15:04
Add a compile-time option that enables setting the encryption key. (Leaf check-in: dafc517415 user: drh tags: iotester)
14:50
incremental improvements to iotester. (check-in: 51f5d3d991 user: drh tags: iotester)
14:26
Fix an assert() in fts5 that might fail with an expression like "... NOT ''". (check-in: 317c91edfc user: dan tags: trunk)
14:12
More incremental improvements to the iotester program. (check-in: 30a383fc3d user: drh tags: iotester)
13:31
Further improvements to the new iotester program. (check-in: dd71dde547 user: drh tags: iotester)
2024-08-13
21:15
More tests for the new code on this branch. (check-in: 00792e807f user: dan tags: fts5-locale)
21:04
Add the sha3_agg() aggregate to the shathree extension. (check-in: c4d7f9996c user: drh tags: trunk)
20:16
Use the xDelete method of the VFS rather than direct interation with the filesystem. (check-in: 96df5aa656 user: drh tags: iotester)
19:30
Infrastructure for a new test program named "iotester" that strives to verify the operation of a VFS object. (check-in: b46d86c22b user: drh tags: iotester)
15:04
Add tests and fix minor issues with the code on this branch. (check-in: def5243a7b user: dan tags: fts5-locale)
2024-08-12
18:39
Add extra documentation comments to fts5_main.c. (check-in: 1a7a9bd3f6 user: dan tags: fts5-locale)
17:28
Fix problem with some fts5 aux function APIs with (locale=, detail=none/column) tables. (check-in: bf116dec6f user: dan tags: fts5-locale)
17:03
Fix further issues to do with fts5 locale support. (check-in: e626123580 user: dan tags: fts5-locale)
13:31
Merge current trunk into this branch. (check-in: 900a593ddf user: stephan tags: wasm-build-rework)
11:46
Update the porter tokenizer to use locales. (check-in: 3291ce3a33 user: dan tags: fts5-locale)
11:13
Update the auxiliary function API to include xTokenize_x2() instead of xSetLocale(). (check-in: f7d56a1f21 user: dan tags: fts5-locale)
09:49
Resolve parameters Bind $int_N and $test_T in fuzzcheck inputs. (check-in: 9c10664416 user: drh tags: trunk)
2024-08-10
20:24
Merge the latest trunk enhancements into main reuse-schema branch. (check-in: 31a71a79bf user: drh tags: reuse-schema)
20:03
Merge trunk changes into this branch. (check-in: b243007525 user: dan tags: fts5-locale)
19:57
Prevent the fts5 xPhraseNext() or xPhraseFirst() APIs from returning an out-of-range column number, even if the database is corrupt. (check-in: d4014c87ba user: dan tags: trunk)
15:46
Revision to check-in [d9f726ade6b258f8] so that OOM and other unrelated failures are not overridden by a syntax error in the tokenizer spec. (check-in: 3778b2a9ca user: drh tags: trunk)
15:05
Fix harmless compiler warning related to the TCL8-to-TCL9 transition. This change in testing code only and is not relevante to the core SQLite. (check-in: c86ef65545 user: drh tags: trunk)
14:53
Fix behavior change in the offset() SQL function introduced by check-in [f0b671183f44d0ae]. (check-in: c2ac17f183 user: drh tags: trunk)
10:05
Enhancements to covering-index prediction. In particular, avoid the false-positive prediction described by [forum:/forumpost/e60e4c295d22f8ce|forum post e60e4c295d22f8ce]. Add early detection of over-prediction of covering-indexes so that sqlite3_prepare() will return an error rather than just generate bad bytecode. (check-in: f0b671183f user: drh tags: trunk)
09:56
Add an assert() to fix a harmless compiler warning in the recovery extension. (check-in: 2502339339 user: drh tags: trunk)
2024-08-09
22:48
Fix a few minor TCL9 compatibilities issues. (check-in: 69eed19914 user: drh tags: trunk)
18:53
Import the second ALTER TABLE fix from trunk. (Closed-Leaf check-in: 1de3e58836 user: drh tags: covering-index-patch)
18:42
Fix another instance where ALTER TABLE was returning SQLITE_INTERNAL instead of SQLITE_ERROR one malformed input. (check-in: b416756320 user: drh tags: trunk)
18:22
Merge the error code fix from trunk. (check-in: 81dfb8cd5d user: drh tags: covering-index-patch)
18:18
Fix the internal routine sqlite3ResolveExprListNames() so that it returns SQLITE_OK or SQLITE_ERROR instead of WRC_Continue or WRC_Abort. Without this fix, some times of obscure syntax errors end up returning SQLITE_INTERNAL rather than SQLITE_ERROR. (check-in: 9052187efd user: drh tags: trunk)
17:09
Do not attempt to use a covering index based purely on columns-used when doing an UPDATE or DELETE of a WITHOUT ROWID table. Raise an SQLITE_INTERNAL error if there is ever a situation where a table reference cannot be converted into an index reference when the query planner thinks that a covering index is appropriate. (check-in: fae39ae932 user: drh tags: covering-index-patch)
13:56
Add SQLITE_TESTCTRL_EDITSTMT for making rogue changes to the statement bytecode, to test the death-cursor error detection mechanism. (Closed-Leaf check-in: 58ffd5d97e user: drh tags: death-cursor)
12:35
Bind the new debug parameters in fuzzinvariants.c. (check-in: 7e1dc26305 user: drh tags: trunk)
12:19
Remove unused static var cBadGroup from ext/consio/console_io.c to resolve a compiler warning reported in the fossil forum. This is a build fix, not a functional change. (check-in: fa047c3ea7 user: stephan tags: trunk)
10:56
Fix some signed/unsigned compiler warnings on this branch. (check-in: 681d228023 user: dan tags: wal2)
10:50
Fix some signed/unsigned compiler warnings on this branch. (check-in: d615d52918 user: dan tags: bedrock)
10:37
Remove two unnecessary int casts, as reported in [forum:84fe63b7b3|forum post 84fe63b7b3]. (check-in: 137cc3e9e8 user: dan tags: begin-concurrent)
09:49
Remove two unnecessary int casts, as reported in [forum:84fe63b7b3|forum post 84fe63b7b3]. (check-in: 1de0c1b574 user: stephan tags: bedrock)
02:10
Change the null-cursor in the previous check-in into a death-cursor. Any access of the cursor causes the prepared statement to return an SQLITE_INTERNAL error. We'll need to add a way to edit the bytecode using sqlite3_test_control() in order to test the death-cursor code path. (check-in: 8894b243ef user: drh tags: death-cursor)
01:38
If there is any question about whether or not the WHERE_IDX_ONLY flag in the query planner is correct, create a backup null-cursor for the table, so that we never try to run an OP_Column against an unopened cursor. (check-in: 7f1617f7bf user: drh tags: death-cursor)
2024-08-08
19:45
Do not allow the WHERE_IDX_ONLY query planner result in cases where a partial index is used on an UPDATE or a DELETE, since the code might still need to access the original table due to parameterized terms in the WHERE clause of the partial index. (Closed-Leaf check-in: 7058d93b09 user: drh tags: partial-index-terms-patch)
16:04
In the vdbe_addoptrace output, show OP_Column opcodes that fail to translate from table to index. This is an aid to testing and analysis only. No changes to production code. (Closed-Leaf check-in: 7f464793fc user: drh tags: extra-debug)
15:26
Ensure sqlite3expert.c unregisters any SQL user-functions it registers with the database handle before returning. (check-in: 123b154ce3 user: dan tags: trunk)
15:07
Add assert() statements and reorganize code slightly in fts3 and fts5 to make it easier to follow. (check-in: 797b0a13fd user: dan tags: trunk)
14:45
Do not let the number of terms on a VALUES clause be limited by SQLITE_LIMIT_COMPOUND_SELECT, even if the VALUES clause contains elements that appear to be variables due to the use of double-quoted string literals. Chromium issue 358174302. (check-in: 670beb133e user: drh tags: trunk)
12:14
Back out the --memory option to ".parameter init" in the CLI, as the capability is no longer needed for testing due to the new "$int_N" and "$text_T" automatic bindings, and the "init --memory" is hence just added complication. (check-in: 3b1b0c1419 user: drh tags: trunk)
12:08
In the CLI, recognize magic parameter names "$int_NNN" and "$text_TTT" and bind them with integer value NNN and text value TTT respectively. Intended for testing and debugging use only. (check-in: a929cdb00f user: drh tags: trunk)
10:51
Move a misplaced va_end, as reported in [forum:702c79e9da|forum post 702c79e9da]. (check-in: daa25fb35f user: stephan tags: trunk)
10:10
Add the --memory option to the ".parameter init" CLI command. When present, the --memory option causes the sqlite_parameters table to be created in a completely independent :memory: database. This can be done to avoid parameter binding queries from being affected by debug settings such as ".wheretrace", ".treetrace", "PRAGMA vdbe_addoptrace=on", and similar. (check-in: 4e69dce209 user: drh tags: trunk)
2024-08-07
21:20
Fix a broken assert in fts5_expr.c. (check-in: 08cc548840 user: dan tags: trunk)
15:17
Add a new assert() to help static analyzers understand that a pointer is never NULL. (check-in: 433f2b942e user: drh tags: trunk)
14:54
Fix a harmless compiler warning in an assert(). (check-in: 5e4c9a74b2 user: drh tags: trunk)
2024-08-06
23:09
Remove unused test cases from FTS5, as they interfere with "grep". (check-in: 048a71bae4 user: drh tags: trunk)
22:49
Improved robustness of parsing of tokenize= arguments in FTS5. [forum:/forumpost/171bcc2bcd|Forum post 171bcc2bcd]. (check-in: d9f726ade6 user: drh tags: trunk)
20:00
Improvements to ./configure that will hopefully break fewer builds. (check-in: 769e32a69b user: drh tags: trunk)
10:29
Change the AggInfoColumnReg() and AggInfoFuncReg() macros for compilers that cannot parse empty elements of a comma expression. [forum:/forumpost/8fd21998dc|Forum post 8fd21998dc]. (check-in: 533a6251f1 user: drh tags: trunk)
2024-08-04
10:13
Restore legacy "tcl_install" makefile target, as an interim measure until I can figure out what is going on. (check-in: 931ad7d9e3 user: drh tags: trunk)
2024-08-03
23:00
Fix to the previous checkin: The colUsed parameter should have high-order bit set if any of the 64-th or greater columns of the virtual table is used. The lower 63 bits of colUsed always show the usage of the first 63 columns of the virtual table. (check-in: 90ac845775 user: drh tags: trunk)
21:45
Ensure that the sqlite3_index_info.colUsed mask always includes the PK fields of WITHOUT ROWID virtual tables. (check-in: ff4ac279b0 user: drh tags: trunk)
18:58
Fix a typo in [c327c0c0] preventing the shell tool from running ".dump" scripts that feature virtual tables. (check-in: 10e97abb87 user: dan tags: trunk)
18:45
Ensure the sqlite3_index_info.colUsed mask always includes the PK fields of WITHOUT ROWID vtabs in cases where they may be used. (Closed-Leaf check-in: c327c0c02c user: dan tags: vtab-pk-colUsed-fix)
15:55
Add the --status option to the test runs using testrunner.tcl. Only works on Unix platforms. The "exec" command appears to interfere with VT100 escape codes on windows. (check-in: 94015cda4c user: drh tags: trunk)
2024-08-02
18:20
Make sure the input buffer is big enough for an memcpy() when doing the restore autodetection in the shell. (check-in: 1637d29d51 user: drh tags: trunk)
17:36
Add the "-d SECS" option to the "status" command of testrunner.tcl (check-in: 2151ea3163 user: drh tags: trunk)
15:28
New MSVC makefile targets: tclextension, tclextension-install, tclextension-uninstall, and tclextension-list. (check-in: c38734f575 user: drh tags: trunk)
13:56
Fix typo in a progress message in the builttclext.tcl script. (check-in: 5e7c946456 user: drh tags: trunk)
11:32
Fix problems in the configure/Makefile system caused by recent enhancements and report by [forum:/forumpost/242ebd0c81|forum post 242ebd0c81]. (check-in: a59319fe4a user: drh tags: trunk)
00:59
New configuration option: --with-tclsh=FILE. New makefile targets: tclextension, tclextension-install, tclextension-uninstall, tclextension-list. (check-in: 888284d1d4 user: drh tags: trunk)
00:56
Previous Makefile.in change broke the tclextension-install target. (Closed-Leaf check-in: 7748367c78 user: drh tags: autoconf-revamp)
00:51
Continuing refinements of the tclextension-install makefile target. (check-in: 871c20a848 user: drh tags: autoconf-revamp)
00:19
Extra robustness for the SQLite Tcl Extension builder, so that it works on Debian Linux. (check-in: 2f0738daaf user: drh tags: autoconf-revamp)
2024-08-01
23:30
Simplification the ./configure script. Carry Makefile CFLAGS and OPTS through into builttclext.tcl. Fix a bug in tclsqlite.c introduced by the previous check-in. (check-in: 72a80aa0ab user: drh tags: autoconf-revamp)
23:00
Add the tclextension-list makefile target. The the makefile running on Mac. (check-in: 2f667cc8e5 user: drh tags: autoconf-revamp)
20:26
New makefile targets: tclextension-install and tclextension-uninstall. Seem to work on Linux. (check-in: 534f8344ab user: drh tags: autoconf-revamp)
20:18
Work on a TCL script that will compile and install the TCL extension. Works on Linux only, so far. This is an incremental check-in. (check-in: 58babd2aa4 user: drh tags: autoconf-revamp)
18:10
Clean up and restructure the TCL configuration sections in autoconf. The new --with-tclsh=FILE option lets you select the specific tclsh that you want to run. (check-in: 8fafc679d9 user: drh tags: autoconf-revamp)
14:43
Include a test case summary in the output of "errors" in testrunner.tcl. (check-in: 173df1478e user: drh tags: trunk)
14:16
Add the "errors" command to testrunner.tcl. (check-in: 03b7f99229 user: drh tags: trunk)
01:06
Merge the latest trunk enhancements into the reuse-schema branch. (check-in: ff9fdd07d2 user: drh tags: reuse-schema)
00:47
Merge the latest trunk enhancements into the bedrock branch. (check-in: c1f616ce80 user: drh tags: bedrock)
00:38
Merge the latest trunk enhancements into the wal2 branch. (check-in: eac582056f user: drh tags: wal2)
00:02
Merge all the latest trunk enhancements into the begin-concurrent branch. (check-in: 3b131bd9aa user: drh tags: begin-concurrent)
2024-07-31
23:49
Merge the latest trunk enhancements into the lateral-join branch. (check-in: ac6ae84626 user: drh tags: lateral-join)
23:46
Merge all the latest trunk enhancements into the exists-to-join branch. (Leaf check-in: 9084a4c872 user: drh tags: exists-to-join)
22:36
Fix the tclsqlite.c TCL interface module so that it works with both Tcl8 and Tcl9. Make changes across the TCL-based test harness to enable SQLite to be tested with either Tcl8 or Tcl9. Get the --with-tcl= argument on the configure script working. Testing changes only - no changes to the SQLite core. I believe the previous merge attempt didn't work because of errors in the merge itself, not because of faults in the code. Trying again... (check-in: ea9d88f9ca user: drh tags: trunk)
22:26
testrunner.db should be in WAL mode for improved concurrency while running "watch sqlite3 test/testrunner.tcl status". (Leaf check-in: f23ad09798 user: drh tags: tcl9)
22:25
Make the #include section of tclsqlite.c the same as tclsqlite.h. (check-in: 2afadbeb12 user: drh tags: tcl9)
22:17
Fix typo in testrunner.tcl for the "status" command that was causing it to fail if any errors were seen. (check-in: 8327c5ed53 user: drh tags: tcl9)
21:59
Use `<tcl.h>` instead of `"tcl.h"` to include the TCL interface. (check-in: 4e32d4aed7 user: drh tags: tcl9)
21:46
Changed: Move this back onto the branch. It isn't ready for trunk yet. Fix the tclsqlite.c TCL interface module so that it works with both Tcl8 and Tcl9. Make changes across the TCL-based test harness to enable SQLite to be tested with either Tcl8 or Tcl9. Get the --with-tcl= argument on the configure script working. Testing changes only - no changes to the SQLite core. (check-in: 2a04b1bea1 user: drh tags: tcl9)
19:57
More tweaks to testfixture-implemented TCL commands to make them safe for Tcl9. (Closed-Leaf check-in: 67897ca97d user: drh tags: tcl9)
19:56
Under Tcl9, the %x format letter truncates to 32-bits. Must use %llx in order to get a 64-bit rendering. (check-in: a3044e0ae6 user: drh tags: tcl9)
17:15
Fixes to testfixture routines needed to test snapshots. (check-in: 66f61c3b35 user: drh tags: tcl9)
16:37
Fix a typo in testrunner_data.tcl that prevented --with-tcl specifications from being carried through into sub-builds. Adjust test cases to account for new floating-point differences discovered when --with-tcl was fixed. (check-in: b8f8135191 user: drh tags: tcl9)
15:04
Remove obsolete testfixture TCL commands formerly required by Windows but now handled by Tcl itself. Update tests case accordingly. (check-in: 4f065fb638 user: drh tags: tcl9)
13:00
Fix problems uncovered while testing Tcl9 on Windows. (check-in: d5523c77fd user: drh tags: tcl9)
12:19
Minor adjustments to get Tcl9-based testing working on Macs. (check-in: 066c8672ee user: drh tags: tcl9)
11:42
Adjust the configure script so that the --with-tcl option is used to find the appropriate tclsh. (check-in: 6fb9e37c75 user: drh tags: tcl9)
11:12
Patch to testrunner.tcl so that it works with Tcl9's pedantic UTF-8 checking. (check-in: 8d4a23d32d user: drh tags: tcl9)
10:59
Fixes to tclsqlite.c to facilitate TEA installs. (check-in: 7157c3c910 user: drh tags: tcl9)
02:01
Fix a problem with strictly conforming UTF8 in shell1.test. (check-in: 8ee187f98d user: drh tags: tcl9)
01:53
Adjust a few tests that don't work even with the new floating point comparison routine. (check-in: 895125a489 user: drh tags: tcl9)
01:45
Implement a new comparison routine to compare text renderings of floating point values. This gets the number of failures down to just 5. But the routine needs work, and probably refactoring. (check-in: 71f2ee5db0 user: drh tags: tcl9)
2024-07-30
20:39
All tests in "make test" now pass with Tcl9, except for about 198 cases where the error involves small differences in the rendering to floating point values. (check-in: 8e27f5326c user: drh tags: tcl9)
18:49
More adjustments to the incrblob channel: Apparently you need to wait until the close2Proc is called with a flag of 0 before actually shutting down the channel. (check-in: fa549a5507 user: drh tags: tcl9)
18:42
Adjustments to test cases for session so that they work with Tcl9. (check-in: d417415b96 user: drh tags: tcl9)
18:15
Tcl_ChannelType implementations for Tcl9 apparently require that wideSeekProc be implemented. Also adjust minor test script issues for fts5 tests so that they can be run sequentially and so that they do not depend on the specific floating point output formats generated by Tcl. (check-in: 19fda979c5 user: drh tags: tcl9)
17:09
Get rid of "-encoding binary" across all test cases, as that is no longer supported in Tcl9. Use "-translation binary" instead. (check-in: e0d9670dd9 user: drh tags: tcl9)
16:59
Use the SQLite format() function to format floating point values for test results, to avoid inconsistences in TCL versions. (check-in: 6a63c47219 user: drh tags: tcl9)
16:51
Fix the incrblob channel so that partial close works with Tcl9. (check-in: d54ec2de78 user: drh tags: tcl9)
15:49
First attempt at getting the build to work with Tcl 9.0. (check-in: 6e5bb48a74 user: drh tags: tcl9)