Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins
2023-06-06
| ||
01:07 | More ExportHandler use. Sync w/trunk. Fix .archive UB. (Leaf check-in: 4fd4240f14 user: larrybr tags: cli_extension) | |
2023-06-05
| ||
17:12 | Fix compiler warning in src-verify.c. (Leaf check-in: 2d58c77448 user: drh tags: trunk) | |
13:57 | Update the README.md file to talk about the verify-source makefile target. (check-in: aa8e79e16a user: drh tags: trunk) | |
11:30 | Remove extraneous console trace output from previous check-in. (check-in: c9f6e36d59 user: stephan tags: trunk) | |
11:26 | Add a JS test confirming that binding of statement parameters in a subquery works. (check-in: 5dfaf0bce8 user: stephan tags: trunk) | |
01:05 | Generalize the src-verify.c utility program and provide additional documentation in the header comment. (check-in: 7ed84046ef user: drh tags: trunk) | |
00:57 | Minor cosmetic normalizations for the MSVC makefile. (check-in: c9fda8d6db user: mistachkin tags: trunk) | |
2023-06-04
| ||
22:59 | Fix harmless compiler warnings in tool/src-verify.c (check-in: 0e79ee97b1 user: drh tags: trunk) | |
22:56 | Enhancement to tool/src-verify.c to also check the manifest.uuid file. (check-in: a39a569482 user: drh tags: trunk) | |
22:41 | Add a prototype implementation for the "verify-source" Makefile target. (check-in: ed876ff6a1 user: drh tags: trunk) | |
2023-06-03
| ||
11:22 | Prototype implementation of the octet_length() SQL function. (Leaf check-in: 2db989c863 user: drh tags: octet_length) | |
2023-06-02
| ||
21:31 | Clarify sqlite3_is_interrupted() return. No code change. (check-in: b6c2d3d203 user: larrybr tags: trunk) | |
20:27 | Get built-in ExportHandler instances to do more of .mode work. Replace atexit() with something that works for (not quite) "main" returns. Sync w/trunk. (check-in: a588dd9fc6 user: larrybr tags: cli_extension) | |
18:05 | Restore the LEFT JOIN strength reduction that was partially lost in [d747afda5683ca5f] when strength reduction was generalized to all OUTER JOINs. (check-in: 2d962b84dd user: drh tags: trunk) | |
13:31 | Do that last CLI fix more simply, using established means. (check-in: a1823b2976 user: larrybr tags: trunk) | |
12:56 | Fix CLI fault on missing -nonce reported by [forum:/info/f8c14a1134|forum post f8c14a1134]. (check-in: cd24178bba user: larrybr tags: trunk) | |
00:03 | Fix the OUTER JOIN strength reduction theorem prover's handling of the CASE operator. (check-in: 73d7b14b17 user: drh tags: trunk) | |
2023-06-01
| ||
20:38 | Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOIN as well. Rename it to the "OUTER JOIN strength reduction" optimization. (check-in: d747afda56 user: drh tags: trunk) | |
16:40 | If the filename argument to sqlite3_load_extension() is an empty string, then raise an error. It turns out that if dlopen() is called with an empty filename, it tries to load the current executable. And then if the caller requests some other function from the current executable, mischief can result. (check-in: d016885547 user: drh tags: trunk) | |
00:28 | Add an ALWAYS() on an unreachable branch. (check-in: a00928d480 user: drh tags: trunk) | |
00:01 | Fix the LEFT JOIN strength reduction for IN operators in the WHERE clause. Further simplifications and refinement of the algorithm. (check-in: 96c72dde79 user: drh tags: trunk) | |
2023-05-31
| ||
18:52 | Add a comment to explain why both sides of an AND must be non-null-row in order for the overall expression to be non-null-row. No code changes. (check-in: 8396032ce1 user: drh tags: trunk) | |
18:35 | Improved detection of when the LEFT JOIN strength reduction optimization can be applied. (check-in: f544a8e47c user: drh tags: trunk) | |
12:42 | Minor enhancement to the sqlite3_trace_v2() documentation. No code changes. (check-in: fba97230e3 user: drh tags: trunk) | |
11:03 | Fix a problem causing an infinite loop in the recovery extension when processing a corrupt free-block list. (check-in: 5a516c6c7a user: dan tags: trunk) | |
2023-05-30
| ||
16:40 | Enhancements to date/time functions: (1) Add support for time-shift modifiers of the form (+|-)YYYY-MM-DD HH:MM:SS.SSS (2) Add the timediff(A,B) SQL function that returns the time-shift modifier sufficient to move B to A. (check-in: 574bf370b0 user: drh tags: trunk) | |
14:46 | Simplifications to the new timediff() logic. (Closed-Leaf check-in: d6954259bd user: drh tags: timediff) | |
14:10 | Minor tweak to the OPFS async proxy to attempt to account for a spurious high-load console error message which was reported via the sqlite-wasm npm project. (check-in: a61467d1fb user: stephan tags: trunk) | |
13:27 | Minor internal JS doc fix. No code changes. (check-in: 68abee3c1b user: stephan tags: trunk) | |
11:51 | New test cases for the timediff enhancements. (check-in: f14633ce6d user: drh tags: timediff) | |
11:13 | Allow date/time modifiers of the form (+/-)YYYY-MM-DD without the following HH:MM:SS.SSS. (check-in: fa9237a8ab user: drh tags: timediff) | |
02:50 | Problems fixed. All tests are passing now. (check-in: cff293b0a7 user: drh tags: timediff) | |
02:16 | Improvements to the timediff() function. Test cases added. Not all test cases are passing. (check-in: 2cf6518140 user: drh tags: timediff) | |
2023-05-29
| ||
20:33 | New date/time modifier: (+|-)YYYY-MM-DD HH:MM(:SS.SSS)? (check-in: 3832b8a9ef user: drh tags: timediff) | |
18:01 | Prototype implementation of a proposed "timediff(X,Y)" SQL function. (check-in: 054a195125 user: drh tags: timediff) | |
2023-05-27
| ||
20:08 | Fix an issue with sqldiff reported by [forum:/info/9bd2155bdfae25a7|forum post 9bd2155bdfae25a7]. (check-in: 736a79c149 user: drh tags: trunk) | |
19:34 | Add extra tests for fts5, large rowids and "ORDER BY rowid DESC". No changes to code. (check-in: b5b5eaeed3 user: dan tags: trunk) | |
00:03 | CLI much closer to being callable. (fewer exit() calls) ^C interrupt response improved. Sync w/trunk. Some diagnostic code removed. Some refactoring for sake of FIDDLE build. Streamline main(), by moving code to more dedicated routines and otherwise. Make -quiet more useful. (check-in: bff3a9a834 user: larrybr tags: cli_extension) | |
2023-05-25
| ||
16:49 | Add ability for the JS Worker1.exec() API to report the number of changes made to the caller, per request in [forum:d0b19483642e20dd | forum post d0b19483642e20dd]. (check-in: 6e79505df9 user: stephan tags: trunk) | |
2023-05-23
| ||
19:11 | Minor cleanups in demo JS code, per forum feedback. (check-in: 80c7c0360c user: stephan tags: trunk) | |
17:43 | Avoid performing aggregate processing more than once for a single expression. (Leaf check-in: 1bc549716c user: drh tags: branch-3.42) | |
17:35 | Avoid performing aggregate processing more than once for a single expression. [forum:/info/36ff78b2a3|Forum post 36ff78b2a3]. (check-in: 367b4cc549 user: dan tags: trunk) | |
15:22 | When converting an aggregate expression to AGG_COLUMN, be sure to remove the EP_Unlikely flag if it is present. (check-in: 20c8a9247b user: drh tags: branch-3.42) | |
15:16 | When converting an aggregate expression to AGG_COLUMN, be sure to remove the EP_Unlikely flag if it is present. [forum:/info/fbfe330a2009d036|Forum post fbfe330a2009d036]. (check-in: 48e65f18b2 user: drh tags: trunk) | |
14:05 | Fix a buffer overread in the recovery extension that might occur on 32-bit platforms. (check-in: ff4a9a2b59 user: dan tags: trunk) | |
11:47 | Add test cases for the recovery extension. No changes to code. (check-in: cec49c7d93 user: dan tags: trunk) | |
2023-05-22
| ||
20:36 | Avoid duplicate WIN32_LEAN_AND_MEAN #define. Fix a trivial nit likely never observed. (check-in: 81ffcf41d6 user: larrybr tags: trunk) | |
16:35 | When a floating-point RTREE is presented with large integer constraints - integers that are too big to be represented exactly by a float - then take extra steps to ensure that all possibly relevant entries in the RTREE are returned, even in boundary cases. Fix for the problem identified by [forum:/forumpost/da70ee0d0d|forum post da70ee0d0d]. (check-in: bfd8d91000 user: drh tags: trunk) | |
11:02 | Fix a buffer overrun that could occur in fts5 when processing corrupt records. dbsqlfuzz 0c6d3451d115974bc27ebed9b14b7a8e13ea05f3. (check-in: 4891dbd938 user: dan tags: trunk) | |
2023-05-21
| ||
05:06 | First serious stab at FIDDLE-build-ready. Fix a flub with absent -A option for some builds. (check-in: bfc36f0f10 user: larrybr tags: cli_extension) | |