/ Timeline
Login

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

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

2024-09-28
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. (Leaf check-in: 45361ab974 user: stephan tags: trunk)
00:39
Minor makefile doc fixes. No functional changes. (check-in: b3ad58e1fc user: stephan tags: trunk)
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. (Leaf 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:20
Squash sign-comparison warnings reported in [forum:5e605a763a65c3f8 | forum post 5e605a763a65c3f8]. (check-in: e74fce93c5 user: stephan tags: trunk)
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)
2024-09-26
22:25
Fix a harmless compiler warning in the CLI. (check-in: 27ef1909bb user: drh tags: trunk)
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: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(). (Leaf check-in: 34b6ac3d76 user: dan tags: snapshot_get-locking)
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)
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
18:55
Change the way tokendata indexes are collected for prefix queries. (Leaf check-in: 204ddf4e72 user: dan tags: fts5-tokendata-prefix)
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: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: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)
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)
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. (Leaf check-in: f9ce1ababb user: drh tags: reuse-schema)
15:45
Update the bedrock branch to include all the latest enhancements from trunk. (Leaf check-in: 4a3386ccb8 user: drh tags: bedrock)
15:42
Merge the latest trunk enhancement into the wal2 branch. (Leaf check-in: f3e3ad6945 user: drh tags: wal2)
15:39
Merge all the latest trunk enhancements into the begin-concurrent branch. (Leaf 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. (Leaf 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)