Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around d2fe6b05f3.
|
2025-01-17
| ||
| 23:49 | For the purpose of the query planner heuristic added by [38db9b5c83], a query should only count as a star query if the fact tables are connected to the dimension table by an INNER JOIN. If a LEFT JOIN is used, then the fact tables are constrained to be in inner loops anyhow and so the heuristic does not make any sense. But it does interfere with AUTOMATIC index creation, which causes the performance regression reported by forum post d87570a1455. (Leaf check-in: 0852c57e user: drh tags: trunk) | |
| 17:09 | Enhance a comment on a test case to add recent context. (check-in: c2647d1b user: drh tags: trunk) | |
| 15:56 | Typo fix in speedtest.md. (check-in: 36027cf3 user: stephan tags: trunk) | |
| 15:39 | Improvements to the speedtest.tcl script. Add documentation on how to use the script. (check-in: eb3853d0 user: drh tags: trunk) | |
| 12:32 | Add the test/speedtest.tcl script to simplify performance and size testing. (check-in: ad7b3867 user: drh tags: trunk) | |
| 10:42 | Fix a potential one-byte buffer overrun when reading from the Windows console in the CLI. (Leaf check-in: 42bcc7c1 user: drh tags: branch-3.48) | |
| 10:39 | Fix a potential one-byte buffer overrun when reading from the Windows console in the CLI. Forum post 95e17b8f5c. This problem was introduced by check-in [abfe488ed67e2e35], which was an attempt to get the Windows build working on MingGW. (check-in: 4d967596 user: drh tags: trunk) | |
|
2025-01-16
| ||
| 20:46 | speedtest1: further improvements to the "json" testset. (check-in: c4750f7c user: drh tags: trunk) | |
| 20:08 | speedtest1: Improvements to the "json" testset. Better balance in "mix1". (check-in: 2cc73c5e user: drh tags: trunk) | |
| 17:19 | Revamp the "json" testset in speedtest1. (check-in: d3350883 user: drh tags: trunk) | |
| 14:37 | Add the "json" test case to speedtest1 and include it in "mix1". (check-in: 2db3a3ee user: drh tags: trunk) | |
| 14:06 | Speedtest1 enhancements: (1) Add the ability to scale performance of tests sets using "/NNN" after the testset name, even for testsets in a comma-separated list. (2) Add the "mix1" macro testset. (check-in: 85667b3a user: drh tags: trunk) | |
| 13:10 | wasm: after generating the .js/.mjs file, strip out all of the generated pieces which create Emscripten call() bindings for the sqlite3 APIs, as we don't use those binding, so both the setup time and the memory they use installing WASM proxy bindings is wasted. This eliminates some 200 superfluous/unused bindings from the init process. (check-in: 020d2c75 user: stephan tags: trunk) | |
| 12:15 | When generating the autoconf snapshot, replaces the Libs.private line from sqlite3.pc.in with one compatible with the legacy build, as reported in forum post e40b9b424a. (check-in: fe471547 user: stephan tags: trunk) | |
| 09:27 | Replace use of Emscripten's Module.postRun() with a custom callback so that we get consistent library init timing with both Emscripten 3.1.x and 4.0.x. Details and discussion are in Emscripten ticket #23420. (check-in: 4863a70a user: stephan tags: trunk) | |
| 01:47 | When two indexes have the same cost, use the narrower one (the one with the smaller average on-disk row width). (check-in: 39855967 user: drh tags: trunk) | |
|
2025-01-15
| ||
| 22:58 | Check-in [da9124fee28c155c] broken the new SQLITE_IOCAP_SUBPAGE_READ mechanism for inhibiting direct-overflow-read. This check-in fixes the problem. (check-in: f741ffc0 user: drh tags: branch-3.48) | |
| 21:13 | Check-in [da9124fee28c155c] broken the new SQLITE_IOCAP_SUBPAGE_READ mechanism for inhibiting direct-overflow-read. This check-in fixes the problem. (check-in: 113078d5 user: drh tags: trunk) | |
| 21:11 | Re-enable comment-stripping in the JS dist builds. (check-in: 5decfea3 user: stephan tags: branch-3.48) | |
| 21:09 | Teach tool/stripccomments.c that a backslash immediately preceeding a forward slash means that that forward slash cannot be the start of a comment. This is intended to allow JavaScript regular expressions containing \/* (like the one introduced in emsdk 4.0.0) to pass through properly. Re-enable comment-stripping in the JS dist builds. (check-in: db21d6cc user: stephan tags: trunk) | |
| 21:00 | Work around a behavior change in emsdk 4.0.0 which breaks the load/init timing of the wasm module. (check-in: c0f0d263 user: stephan tags: branch-3.48) | |
| 20:53 | Work around a behavior change in emsdk 4.0.0 which breaks the load/init timing of the wasm module. (check-in: 00a75018 user: stephan tags: trunk) | |
| 20:23 | When choosing between two indexes with the same cost, pick the one with the smaller predicted number of bytes per row. (Closed-Leaf check-in: d4bd0d42 user: drh tags: consider-idx-width) | |
| 19:30 | Variable names and conditional logic simplified in where.c. These changes are cosmetic only and do not affect the resuling machine code. (check-in: dbc2d6a2 user: drh tags: trunk) | |
| 15:27 | Fix a typo in a wasm makefile var name, noting that this doesn't actually fix anything because the var in question is not used when building 'clean' or 'distclean'. (check-in: 7cfc75a6 user: stephan tags: trunk) | |
| 14:31 | Disable the C-style comment stripper in the JS dist build, as explained in forum post 529c20d344. (check-in: 76ffc70f user: stephan tags: branch-3.48) | |
| 14:28 | Disable the C-style comment stripper in the JS dist build, as explained in forum post 529c20d344. (check-in: a9475e76 user: stephan tags: trunk) | |
| 13:35 | Fix another problem that was causing underestimates of index size. (Later:) Closed this branch as I don't think it is the correct approach to the problem. Maybe I'll change my mind later, but that's the decision for now. (Closed-Leaf check-in: a1690ecd user: drh tags: analyze-row-size) | |
| 12:45 | Have windows SQLITE_ENABLE_SETLK_TIMEOUT builds block indefinitely if the busy-timeout is set to 0x7FFFFFFF. (Leaf check-in: daefcafe user: dan tags: win32-enable-setlk) | |
| 12:38 | Fix issues with the prior check-ins on this branch. The code seems to work now, though many tests fail because of the new sqlite_stat1.stat text. (check-in: be26698a user: drh tags: analyze-row-size) | |
| 00:46 | Some bug fixes to the previous. Still lots of bugs remaining. (check-in: 76f2bede user: drh tags: analyze-row-size) | |
| 00:29 | Always include the sz=NNN option in the sqlite_stat1.stat field. (check-in: 9c0d6f29 user: drh tags: analyze-row-size) | |
|
2025-01-14
| ||
| 20:47 | Change the version number to 3.49.0 to begin the next development cycle. Any patches to 3.48.0 will go on a branch. (check-in: 8165a3d3 user: drh tags: trunk) | |
| 16:10 | Trying to remove a warning from some compiler that I do not have access to. (check-in: bc6de90c user: drh tags: trunk) | |
| 12:43 | Version 3.48.0 for the reuse-schema branch. (Leaf check-in: 1a031a53 user: drh tags: reuse-schema) | |
| 12:28 | Version 3.48.0 for the bedrock branch (Leaf check-in: fab341c8 user: drh tags: bedrock) | |
| 12:21 | Version 3.48.0 for the wal2 branch. (Leaf check-in: ef970ef0 user: drh tags: wal2) | |
| 12:15 | Version 3.48.0 for the begin-concurrent branch. (Leaf check-in: 56d110b6 user: drh tags: begin-concurrent) | |
| 11:05 | Version 3.48.0 (check-in: d2fe6b05 user: drh tags: trunk, release, major-release, version-3.48.0) | |
|
2025-01-13
| ||
| 13:32 | Remove a stray tab character from a comment. (check-in: 315079b1 user: drh tags: trunk) | |
| 11:28 | GCC 13 has become more quite pedantic about the signature of functions matching the type of pointers through which the functions are called. Make adjustments to extension functions and test procedures to work around this. No changes to the core. (check-in: ed83b791 user: drh tags: trunk) | |
|
2025-01-11
| ||
| 16:28 | Fix harmless "implicit fall through" warnings that suddenly appeared when I upgraded to gcc-13. (check-in: 3e2875da user: drh tags: trunk) | |
| 14:43 | Better job at suppressing harmless scan-build warnings. This time testing and working. (check-in: c8479739 user: drh tags: trunk) | |
| 13:59 | Fix harmless scan-build warnings. Actually, this fixed nothing. The scan-build warnings persist. I should have tested before I checked in. Look for a follow-up shortly. (check-in: b93af6fe user: drh tags: trunk) | |
| 09:02 | Fix an age-old bug in the lower-level wasm/js helper bits which (A) caused removal of customized WASM func arguments/results conversion to silently fail and (B) triggered a legitimate warning in the Google closure toolchain. Reported in jaccwabyt ticket c5c296e85a7c01360820. (check-in: 99917a5b user: stephan tags: trunk) | |
|
2025-01-10
| ||
| 18:03 | Update log messages on this branch to say "v=22". Also add log message to slow calls to sqlite3_schema_copy(). (Leaf check-in: b0cd8dfc user: dan tags: cf8f1552-commit-instr) | |
| 17:36 | Add the experimental sqlite3_schema_copy() API, for copying schemas between database handles. (check-in: 04ea435d user: dan tags: cf8f1552-commit-instr) | |
| 17:09 | Minor updates to schemacopy.test. (Closed-Leaf check-in: 1d544b53 user: dan tags: schema-copy) | |
| 15:10 | Allow ".testctrl schemacopy 1" in the shell tool on this branch. For testing sqlite3_schema_copy(). (check-in: 1edc2e55 user: dan tags: schema-copy) | |
| 11:34 | Update test script wal2big2.test to be less sensitive to PRNG output. (check-in: 2a5e7c5c user: dan tags: schema-copy) | |
|
2025-01-09
| ||
| 20:41 | Run tests with SQLITE_TESTCTRL_SCHEMACOPY for mdevtest and sdevtest on this branch. (check-in: c25dd2de user: dan tags: schema-copy) | |
| 19:57 | Update the makefile so that it puts the amalgamation files in a subdirectory in the amalgamation-zip. Forum post b8dd1941e1. (check-in: cef8e88b user: drh tags: trunk) | |
| 19:18 | Rationalize and add comments to new code on this branch. (check-in: e1603c9c user: dan tags: schema-copy) | |
| 17:12 | Fix minor issues on this branch. Remove unused code. (check-in: c2610bb4 user: dan tags: schema-copy) | |
| 14:10 | When removing an fts5 in secure-delete mode, defer setting the table version to SECUREDELETE until flushing data to disk. This prevents problems that can occur if there is a rollback or statement rollback operation. (check-in: c359e555 user: dan tags: trunk) | |
|
2025-01-08
| ||
| 20:43 | Fix another assert() failure in fts5. (check-in: 6da37893 user: dan tags: trunk) | |
| 17:16 | Fix problem in test code on this branch. (check-in: 05d90f8b user: dan tags: schema-copy) | |
| 15:54 | Fix a crash in fts5 that could occur if shadow tables are modified or removed. (check-in: c0b69109 user: dan tags: trunk) | |
| 12:51 | Cross-link and otherwise improve the various how-to-compile documents. No code changes. (check-in: 5e6ede92 user: drh tags: trunk) | |
| 12:25 | In the doc/tcl-extension-testing.md document, provide enhanced explanation for why the tcl library needs to be copied into the install directory. (check-in: cff70c85 user: drh tags: trunk) | |
| 10:55 | Ensure that integrity-check processes tables in the same order when using a copied schema as it does when using one loaded directly from the db. (check-in: 961af944 user: dan tags: schema-copy) | |
|
2025-01-07
| ||
| 21:04 | Fix many problems in the sqlite3_schema_copy() function. (check-in: ac9ca885 user: dan tags: schema-copy) | |
| 18:50 | Further refinement to the Tcl extension testing procedure. (check-in: 32b8b078 user: drh tags: trunk) | |
| 16:36 | Improvements to [14b38ae6ab86a314] so that the Tcl interface is better able to work with boolean values in both Tcl86 and Tcl90. (check-in: 4e85343d user: drh tags: trunk) | |
| 15:39 | Fix a memory error in test logic introduced by [8704034254938662]. (check-in: 8a56e98d user: drh tags: trunk) | |
| 15:00 | Typo in the previous check-in. (check-in: 5872d7a0 user: drh tags: trunk) | |
| 14:55 | Enhancements to the Tcl SQLite extension testing procedures so that they install a full-featured SQLite and so that Tcl is build statically so that there is no need to worry with LD_LIBRARY_PATH. (check-in: c8972e65 user: drh tags: trunk) | |
| 12:14 | Make the TCL extension aware of the booleanString type within TCL. (check-in: 14b38ae6 user: drh tags: trunk) | |
| 11:54 | Fix a typo in the previous check-in. (check-in: 7d41885e user: drh tags: trunk) | |
| 00:17 | Minor fixes to tclsqlite.c to promote portability. (check-in: dd934f03 user: drh tags: trunk) | |
|
2025-01-06
| ||
| 23:33 | Enhance the makefile to make it easier to build from a read-only source tree. (check-in: f99a70ec user: drh tags: trunk) | |
| 21:36 | Fix a problem with tool/mksqlite3h.tcl that prevents it from running out of a read-only check-out. (check-in: cb54f006 user: drh tags: trunk) | |
| 20:39 | Implemenation of experimental API sqlite3_schema_copy(), for copying a database schema between connections. More testing to come. (check-in: 65ede04d user: dan tags: schema-copy) | |
| 20:12 | Merge all the latest trunk changes into the reuse-schema branch. (check-in: 3703a844 user: drh tags: reuse-schema) | |
| 18:32 | Fix a minor problem with the sqlite3_get_table_printf() test interface. No core changes. (check-in: a0df29c7 user: drh tags: trunk) | |
| 17:01 | Add test case for using both SQLITE_CHANGESETAPPLY_IGNORENOOP and SQLITE_CHANGESETAPPLY_FKNOACTION. (check-in: b1cc53fa user: dan tags: trunk) | |
|
2025-01-05
| ||
| 19:58 | Further refactoring of the TCL extension test procedure document, for improved clarity and usability. (check-in: bcdaef43 user: drh tags: trunk) | |
| 17:16 | Refactor the TCL extension test procedure to deal with TCL8.6 and TCL9.0 separately, to simplify the procedures and reduce cognative stress on the tester. (check-in: 52815363 user: drh tags: trunk) | |
| 11:40 | Fix typo in the tcl-extension-testing.md document. (check-in: 28150c61 user: drh tags: trunk) | |
| 11:19 | Improvements to TCL extension test procedure description. Improvements to the tclextension-list and tclextension-verify makefile targets to suppress unnecessary output. (check-in: 3e92fea0 user: drh tags: trunk) | |
|
2025-01-04
| ||
| 20:50 | Improvements to testing and validation of the SQLite TCL extension. (check-in: 9d7597ca user: drh tags: trunk) | |
| 20:13 | Show the values of $(JIM_TCLSH) and $(VISUALSTUDIOVERSION) in the output of "nmake tcl-env". (check-in: 4270abc0 user: drh tags: trunk) | |
| 19:50 | Allow the 2nd argument to ".param set" to use previously bound parameters, as suggested by forum post 823e1bd746. (check-in: 13a35ad7 user: drh tags: trunk) | |
| 16:30 | Fix a problem in the sessions extension allowing changesets containing foreign key violations to be committed under some circumstances. (check-in: e09a0c02 user: dan tags: trunk) | |
| 15:52 | Add the document describing test procedures for the TCL extension build process. Update the Windows makefile so that it builds the TCL extensions successfully with a default installation of Tcl8.6. (check-in: 3263db92 user: drh tags: trunk) | |
| 15:51 | Adjust the Windows Makefile.msc so that it can build the tclextension with Tcl8.6 successfully. Updates to the tcl-extension test procedure document. (Closed-Leaf check-in: 0c2cdc63 user: drh tags: test-procedures) | |
| 14:10 | Add new tcl-extension-testing.md document. The Windows side is not yet working. (check-in: 9dc805df user: drh tags: test-procedures) | |
|
2025-01-03
| ||
| 15:21 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 3b485202 user: drh tags: reuse-schema) | |
| 15:15 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 4b9497cf user: drh tags: bedrock) | |
| 15:12 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 0992237c user: drh tags: wal2) | |
| 15:07 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 99293f4f user: drh tags: begin-concurrent) | |
| 11:51 | Add comment to the columnIsGoodIndexCandidate() routine to record the results of a failed experiment. No changes to code. (check-in: 9ee57a30 user: drh tags: trunk) | |
| 11:22 | Avoid using Int32x32To64() with a 64-bit argument in fileio.c - this level of micro-optimization is not really necessary there. (check-in: 1291b013 user: dan tags: trunk) | |
|
2025-01-02
| ||
| 21:23 | Improve the treeview output for CteUse objects. (check-in: 2b16d694 user: drh tags: trunk) | |
| 18:43 | Improvements to the display of subqueries in the FROM clause for treeview output. (Debug and analysis code only - does not affect production builds.) (check-in: 4a2d65cd user: drh tags: trunk) | |
| 17:56 | Close database connections in test/dbpage.test, for Windows. (check-in: 322d255e user: drh tags: trunk) | |
| 15:39 | Fix recent test cases so that they work even when auto_vacuum defaults to on. (check-in: 41f6e466 user: drh tags: trunk) | |
| 15:27 | Add a test case for ROLLBACK TO of database truncate operations made through the sqlite_dbpage vtab. (check-in: eb335beb user: dan tags: trunk) | |
| 15:03 | Improvements to the way that truncation is implemented in sqlite_dbpage(). (check-in: ac4bb2e4 user: drh tags: trunk) | |
| 12:14 | Update the build instructions for Windows to note that VS2015 or later is required to avoid the need to install tclsh.exe. (check-in: da0ef056 user: drh tags: trunk) | |