Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
130 check-ins for the month beginning 2023-06-01
Following month ↑|
2023-06-30
| ||
| 23:42 | Fix an issue with the "+" attribute in printf(). (check-in: bdfd1eb1d7 user: drh tags: fp-to-decimal-refactor) | |
| 23:18 | Begin cutting over sqlite3FpDecode() into printf(). The code in this check-in gets a lot right, but there are still some formatting discrepencies. (check-in: c134d423e7 user: drh tags: fp-to-decimal-refactor) | |
| 19:41 | Add decimal rounding to the sqlite3FpDecode() routine. (check-in: 27871140ca user: drh tags: fp-to-decimal-refactor) | |
| 19:14 | Add experimental ".scanstats vm" command to the shell tool. (check-in: e727640fb5 user: dan tags: scanstatus-exp) | |
| 19:13 | Fix an error in the previous commit on this branch. (check-in: 47c11ca90f user: dan tags: scanstatus-exp) | |
| 18:59 | Add the "nexec" and "ncycle" columns to the bytecode virtual table. For accessing counters collected when SQLITE_DBCONFIG_STMT_SCANSTATUS is enabled. (check-in: f7b163a319 user: dan tags: scanstatus-exp) | |
| 18:35 | Experiments with a new algorithm for converting ieee-754 binary64 numbers into decimal. (check-in: e923405e44 user: drh tags: fp-to-decimal-refactor) | |
| 18:31 | Add support for sqlite3_stmt_scanstatus_v2() profiling of GROUP BY clauses that use a temp b-tree, and for sub-queries implemented as co-routines. (check-in: 7afad1f759 user: dan tags: trunk) | |
| 18:23 | Improve support for sqlite3_stmt_scanstatus_v2() profiling of sub-queries implemented as co-routines. (Closed-Leaf check-in: 4e8718dc35 user: dan tags: scanstatus-exp) | |
| 17:14 | Add support for sqlite3_stmt_scanstatus_v2() profiling of GROUP BY clauses that use a temp b-tree. (check-in: 796eadcc50 user: dan tags: scanstatus-exp) | |
| 16:16 | Add extra debugging code for sqlite3_stmt_scanstatus_v2() to test1.c. (check-in: f936f10140 user: dan tags: trunk) | |
| 14:01 | Completely unwind the enhanced precision sum() from [a915f15a916af698] so as not to offend UBSAN and OSS-Fuzz. (check-in: 85be05b66e user: drh tags: trunk) | |
| 12:59 | Omit the doubleToReal() function in vdbemem.c. Use the equivalent sqlite3RealToI64() function in its place. (check-in: 625820e8eb user: drh tags: trunk) | |
| 11:51 | Make the sum() function less precise and slower in order to avoid harmless signed integer overflow UBSAN warnings from OSS-Fuzz. (check-in: 1be0646a2c user: drh tags: trunk) | |
|
2023-06-29
| ||
| 23:03 | Cleanup and commenting of the new DECIMAL extension code. No functional changes. (check-in: 5124481663 user: drh tags: trunk) | |
| 20:28 | Enhancements to the DECIMAL extension: (1) If the argument to decimal(X) is a floating point value (or an 8-byte blob), the floating point value is expanded into its exact decimal representation. (2) Function decimal_sci(X) works the same except it returns the result in scientific notation. (3) New function decimal_pow2(N) returns the full decimal expansion of the N-th integer power of 2. (check-in: 8baf8c10ae user: drh tags: trunk) | |
| 17:58 | Sync w/trunk (check-in: fe9aa2e9c1 user: larrybr tags: cli_extension) | |
| 17:48 | Fix harmless compiler warnings about unused function arguments. (check-in: 24927c1377 user: drh tags: trunk) | |
| 17:36 | Improve the range of floating-point numbers that can be handled as integers for numeric-to-text conversion. (check-in: 41580ba452 user: drh tags: trunk) | |
| 17:26 | Further refine the dtostr() testing function in the CLI so that it takes an optional second parameter which is the number of significant digits to display. (check-in: 2f9d4444aa user: drh tags: trunk) | |
| 16:48 | Change the (undocumented) dtostr() SQL function in the CLI so that it only shows the first 26 significant digits - 10 more digits than are available in a 64-bit double. (check-in: d758859f6a user: drh tags: trunk) | |
| 14:49 | Add the decimal_sci(X) function to the Decimal extension for showing a decimal value in scientific notation: +D.DDDDDe+DD (check-in: 61d4923913 user: drh tags: trunk) | |
| 12:14 | CLI enhancements to facilitate SQLite core testing: (1) Add built-in functions strtod() and dtostr() that convert text to floating point and back using C-library routines. (2) Do not disable all of ".testctrl" without --unsafe-testing, but only those subcommands of .testctrl that are actually dangerous. (check-in: 669996a8dd user: drh tags: trunk) | |
|
2023-06-28
| ||
| 12:02 | Enhance the SUM() aggregate (and related AVG() and TOTAL()) so that the running sum is accurate to about 100 bits. (check-in: a915f15a91 user: drh tags: trunk) | |
| 11:46 | Improved accuracy of floating-point conversion constants as suggested by forum post 598d32f6135c41c1. (check-in: 4943e8a181 user: drh tags: trunk) | |
|
2023-06-26
| ||
| 19:57 | Simple test cases for the enhanced SUM() function. (Closed-Leaf check-in: c66ef2440e user: drh tags: extended-precision-fp) | |
| 19:35 | Use ideas from T. J. Dekker in "A Floating-Point Technique for Extending the Available Precision" (1971-07-26) to enhance the accuracy of the SUM() aggregate function in cases where input magnitudes vary wildly. (check-in: 439fc00fee user: drh tags: extended-precision-fp) | |
| 17:23 | Fix CLI .sha3sum error message for keyword identifiers, reported in forum post 7cbe081746dd. (check-in: bc27bda164 user: larrybr tags: branch-3.42) | |
| 17:08 | Fix CLI .sha3sum error message for keyword identifiers, reported in forum post 7cbe081746dd. (check-in: 9d7813ddcf user: larrybr tags: trunk) | |
| 07:20 | Replace some JS 'self' references with 'globalThis', as reported via the npm subproject. (check-in: b6ae84915f user: stephan tags: branch-3.42) | |
| 07:05 | Replace some JS 'self' references with 'globalThis', as reported via the npm subproject. (check-in: d4e66dfc2e user: stephan tags: trunk) | |
|
2023-06-25
| ||
| 20:23 | Fix typo in the README.md file. (check-in: 6d435d1dac user: drh tags: trunk) | |
|
2023-06-23
| ||
| 11:10 | Add support for the octet_length() SQL function, with low-level optimizations that avoid loading large string content from disk when the argument to octet_length() is a table column. (check-in: fa5f77862c user: drh tags: trunk) | |
|
2023-06-22
| ||
| 21:19 | Optimize the argument to the octet_length() function so that it does not attempt to read content from disk. (Closed-Leaf check-in: 8b8ea4e3f5 user: drh tags: octet_length) | |
| 15:26 | basic test cases for octet_length(). (check-in: 034a5fe2a0 user: drh tags: octet_length) | |
| 14:50 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 905c6c9ddb user: drh tags: reuse-schema) | |
| 14:40 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 0551b79b17 user: drh tags: bedrock) | |
| 14:20 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 80ac494f73 user: drh tags: wal2) | |
| 13:28 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: 5bd26fea6a user: drh tags: begin-concurrent) | |
| 13:01 | Merge recent trunk enhancements into the octet_length branch. (check-in: d35c214811 user: drh tags: octet_length) | |
| 01:03 | Simplification to the getAndInitPage() routine that results in improved performance. (check-in: 2e9734c233 user: drh tags: trunk) | |
|
2023-06-21
| ||
| 21:47 | Improved comment on the getAndInitPage() in btree.c. No code changes. (check-in: dc468cfdb8 user: drh tags: trunk) | |
| 18:12 | This is a failed attempt to optimize the usage of the page cache in sqlite3BtreeIndexMoveto() by deferring calls to sqlite3PagerUnref() for child pages of the btree until we are sure those pages will not be reused. The code does not work in two senses: (1) Many tests still fail. (2) The performance gain is less than 2 million cycles and does not seem worth the extra risk and complication. (Closed-Leaf check-in: 84731a1fd2 user: drh tags: pcache-opt) | |
| 14:48 | Sync w/trunk (for CLI -cachetrace) (check-in: a61f937701 user: larrybr tags: cli_extension) | |
| 14:11 | Add the --pcachetrace option to the CLI. (check-in: 61dfa92b44 user: drh tags: trunk) | |
|
2023-06-20
| ||
| 17:45 | Omit unnecessary calls to table locking routines in the common case when there is no shared cache. (check-in: f94f3021cd user: drh tags: trunk) | |
| 16:26 | Avoid unnecessary calls to sqlite3DeleteTable() with NULL pointers. (check-in: 4a35f39199 user: drh tags: trunk) | |
| 15:48 | Avoid unnecessary calls to sqlite3CodeRowTrigger(). (check-in: 27c174dbd0 user: drh tags: trunk) | |
| 11:46 | Performance optimization in sqlite3VdbeAddOp4Int(). (check-in: 456a24324b user: drh tags: trunk) | |
|
2023-06-19
| ||
| 23:27 | Avoid unnecessary NULL pointer checks on calls to sqlite3WalkExpr(). (check-in: 73d86a12fb user: drh tags: trunk) | |
| 20:54 | Small performance improvement and size reduction by recognizing that no SQL keywords have less than 2 characters. (check-in: 6b3d25b798 user: drh tags: trunk) | |
| 18:16 | Add the sqlite3_commit_status() API. For querying a connection for (a) the ranges of wal/wal2 frames written after a successful commit, and (b) the conflicting frame following a failed commit of a BEGIN CONCURRENT transaction. (check-in: 4b08d4dad6 user: dan tags: bedrock) | |
| 13:09 | Fix large integer constants so that they work on older C compilers. (check-in: 3c94f87806 user: drh tags: trunk) | |
|
2023-06-17
| ||
| 23:53 | Cure tclshext build warning. Sync w/trunk. (check-in: e9f2119106 user: larrybr tags: cli_extension) | |
| 15:42 | Fix harmless compiler warnings that show up on 32-bit RaspberryPI builds. (check-in: bc4d20f362 user: drh tags: trunk) | |
| 15:22 | In date/time functions, fix the rendering of "subsecond" and the computeHMS() routine to better deal with floating point rounding errors that arise on some 32-bit systems. (check-in: e46a00ae88 user: drh tags: trunk) | |
| 01:56 | Sync w/trunk. (check-in: 746733c1c5 user: larrybr tags: cli_extension) | |
|
2023-06-16
| ||
| 19:45 | Clear MSVC warnings and fix a typedef issue with MSVC build. (check-in: b0cb4cfcea user: larrybr tags: cli_extension) | |
| 14:39 | Address various harmless compiler warnings from forum post d526da8ee4. (check-in: 365caf2f97 user: drh tags: trunk) | |
| 11:05 | Fix the pager such that if the xOpen() message sends back the SQLITE_OPEN_MEMORY flag, the pager is opened in journal-mode MEMORY, even if compiled with SQLITE_OMIT_DESERIALIZE. No changes to the logic as long as that OMIT flag is omitted. We need to better document the behavior of xOpen to describe this. (check-in: da1252b298 user: drh tags: trunk) | |
| 02:18 | More doc tweaks, one teensy enhancement, and a new feature bug fix (check-in: 1073ef0629 user: larrybr tags: cli_extension) | |
|
2023-06-15
| ||
| 16:02 | Updates to the README.md file. (check-in: fa5cb6dab5 user: drh tags: trunk) | |
| 15:43 | Fix harmless typo in a comment. (check-in: 6937986a68 user: drh tags: trunk) | |
|
2023-06-14
| ||
| 13:45 | Add SQLITE_DBCONFIG_RANDOM_SCANORDER. This option causes unconstrained table and index scan to happen in a random order, in order to help detect under-constrained queries in applications. Closed because this feature does not add any new capabilities that are not already available with SQLITE_DBCONFIG_REVERSE_SCANORDER, but it does make the behavior non-deterministic, and hence more difficult to test. (Closed-Leaf check-in: 330219863c user: drh tags: random-scanorder) | |
| 12:19 | Work around what appears to be a GCC 32-bit optimization problem in the computeHMS() routine of the date/time logic. (check-in: aebdbcbebf user: drh tags: trunk) | |
|
2023-06-13
| ||
| 23:04 | Improve and add docs for extensible shell. (check-in: 1a57af86da user: larrybr tags: cli_extension) | |
| 18:10 | Improved sqlite3_error_offset() values for bare column errors on '*' and 'table.*' expressions in SELECT statements. (check-in: 118fe60087 user: drh tags: trunk) | |
| 16:55 | Extended the time-diff format so that it can have a 5-digit year. This enables time differences to span the full range of dates supported by SQLite. Also fix some inaccuracies in the computation of time differences and add new test cases. (check-in: d57ddbf4ee user: drh tags: trunk) | |
|
2023-06-12
| ||
| 18:22 | Initialize a local variable in FTS3 to avoid a GCC compiler warning. (check-in: 7ec4ab327d user: drh tags: trunk) | |
| 18:11 | Finish .parameter improvements. (no set <cast_op> anymore, not useful enough for its apparent complexity) (check-in: bbbdb864f0 user: larrybr tags: cli_extension) | |
| 14:26 | The decision was made to halt work on this enhancement. See the discussion beginning with forum post 4c8a673560d7999a. The changes on this branch work, but they add unnecessary user complexity with no corresponding benefit. (Closed-Leaf check-in: c8ef3b7874 user: drh tags: newbie-safe-aggregates) | |
| 14:16 | Fix a buffer over-read that could occur as part of an fts5 secure-delete operation on a database containing corrupt fts5 records. dbsqlfuzz a463eac437783bcd246cc675b87842618a569cae (check-in: 44fdc798de user: drh tags: branch-3.42) | |
| 14:12 | Make sure temporary sqlite3_value objects used by STAT4 are reset to NULL prior to being reused, to prevent a memory leak associated with the custom xDel string value destructor. dbsqlfuzz 65209ab5d5730e4fd14fff9d024325a77239036e. (check-in: 2cf197a28b user: drh tags: branch-3.42) | |
| 14:09 | Defer setting the BTS_PAGESIZE_FIXED flag until after we are certain there are no errors and the page size has been set. Forum post b901808856. (check-in: cefaf128d2 user: drh tags: branch-3.42) | |
| 14:03 | Extra space to prevent a buffer overread on corrupt STAT4 records. dbsqlfuzz 7128d1b41ce9df2c007f9c24c1e89e2f1b2590ca. (check-in: 566c4c14dd user: drh tags: branch-3.42) | |
| 13:57 | Simplify a memcpy() in defragmentPage(). It now might copy more content than is strictly necessary, but runs faster and uses less code space. Possible reasons for the improved performance: (1) the copy is now always 8-byte aligned, (2) fewer intermediate results are required which means less register pressure which helps the compiler to optimize the subroutine. (check-in: 1292d676ea user: drh tags: branch-3.42) | |
| 13:53 | Fix CLI fault on missing -nonce reported by forum post f8c14a1134. (check-in: 67cf7c4096 user: drh tags: branch-3.42) | |
| 13:49 | Fix a problem causing bloom filters to be used less efficiently than they might be. Problem reported by forum post 06c3f01da6. (check-in: 56d9bb7aa6 user: dan tags: trunk) | |
| 13:46 | Fix a problem causing an infinite loop in the recovery extension when processing a corrupt free-block list. (check-in: d21c06b73d user: drh tags: branch-3.42) | |
| 13:43 | Fix an issue with sqldiff reported by forum post 9bd2155bdfae25a7. (check-in: 50721074f7 user: drh tags: branch-3.42) | |
| 13:31 | Check-in [70e12efd1b189560] left a path through lockBtree() that failed to set the BTS_PAGESIZE_FIXED flag. That omission is fixed by this check-in. dbsqlfuzz 02c9ab74eb0619c9ae3b894ce157fae1d7f94645 (check-in: 30dcc872eb user: drh tags: trunk) | |
| 11:06 | Fix a buffer over-read that could occur as part of an fts5 secure-delete operation on a database containing corrupt fts5 records. dbsqlfuzz a463eac437783bcd246cc675b87842618a569cae (check-in: a35c50eca9 user: dan tags: trunk) | |
|
2023-06-11
| ||
| 22:05 | Merge the latest trunk enhancements into the newbie-safe-aggregates branch. (check-in: 75a877a923 user: drh tags: newbie-safe-aggregates) | |
| 21:58 | Make sure temporary sqlite3_value objects used by STAT4 are reset to NULL prior to being reused, to prevent a memory leak associated with the custom xDel string value destructor. dbsqlfuzz 65209ab5d5730e4fd14fff9d024325a77239036e. (check-in: 88be7075cd user: drh tags: trunk) | |
|
2023-06-10
| ||
| 19:33 | Defer setting the BTS_PAGESIZE_FIXED flag until after we are certain there are no errors and the page size has been set. (check-in: 70e12efd1b user: drh tags: trunk) | |
| 18:40 | Fix an assert that can go bad if STAT4 content is corrupt. This is a follow-up to the previous check-in. (check-in: ac1d3860af user: drh tags: trunk) | |
| 17:27 | Add documentation for SQLITE_DBCONFIG_STRICT_AGGREGATE. (check-in: 76fb915138 user: drh tags: newbie-safe-aggregates) | |
| 17:15 | Merge the latest trunk enhancements into the newbie-safe-aggregates branch. (check-in: e19e20fbaf user: drh tags: newbie-safe-aggregates) | |
| 17:05 | Extra space to prevent a buffer overread on corrupt STAT4 records. dbsqlfuzz 7128d1b41ce9df2c007f9c24c1e89e2f1b2590ca. (check-in: b99135288b user: drh tags: trunk) | |
| 10:37 | Enhance fuzzcheck so that it understand the sqlite3_db_config() and optimization settings from unused bits in the database header, which dbsqlfuzz is now using. (check-in: 918708c6de user: drh tags: trunk) | |
| 09:24 | Fix a potential UAF in the parser caused by the changes on this branch. (check-in: c29ec76944 user: drh tags: newbie-safe-aggregates) | |
| 08:19 | Add CFLAGS_FIDDLE to ext/wasm/fiddle.make as a way to pass on additional compilation flags to the fiddle build from the CLI, e.g. CFLAGS_FIDDLE=-DSQLITE_STRICT_AGGREGATE. Expose SQLITE_DBCONFIG_STRICT_AGGREGATE to JS. (check-in: 0b01720879 user: stephan tags: newbie-safe-aggregates) | |
|
2023-06-09
| ||
| 19:24 | Naming consistency: Always use the singular "STRICT AGGREGATE", not the plural. (check-in: 275d056e46 user: drh tags: newbie-safe-aggregates) | |
| 18:58 | Improved sqlite3_error_offset() values for bare column errors on '*' and 'table.*' expressions in SELECT statements. (check-in: 446ad162f7 user: drh tags: newbie-safe-aggregates) | |
| 18:30 | The -DSQLITE_STRICT_AGGREGATES compile-time option enables SQLITE_DBCONFIG_STRICT_AGGREGATE by default. (check-in: cd1f6b27d9 user: drh tags: newbie-safe-aggregates) | |
| 15:54 | Simplify a memcpy() in defragmentPage(). It now might copy more content than is strictly necessary, but runs faster and uses less code space. Possible reasons for the improved performance: (1) the copy is now always 8-byte aligned, (2) fewer intermediate results are required which means less register pressure which helps the compiler to optimize the subroutine. (check-in: 6e5607ae4d user: drh tags: trunk) | |
| 13:08 | Experimental change to add a per-connection option that raises an error if a bare column appears in an aggregate query. (check-in: f587891134 user: drh tags: newbie-safe-aggregates) | |
| 06:04 | More .parameter improvements, a WIP for ".parameter set <cast_op> ..." (check-in: 2b51dcdad8 user: larrybr tags: cli_extension) | |
| 01:11 | Sync w/trunk. Fix spelling nits. Add ".parameter edit ..." improvements. (check-in: d73f065b93 user: larrybr tags: cli_extension) | |
|
2023-06-08
| ||
| 20:49 | Remove SQLITE_EXTENSION_INIT macros from dbdata.c. (check-in: 106ec74576 user: dan tags: trunk) | |
| 16:19 | Improvements to the src-verify.c utility program so that it continues to muddle through a corrupt manifest file, making the most sense of it that it can and reporting "manifest" has having changed at the end. (check-in: 157b5d25e0 user: drh tags: trunk) | |
| 15:30 | Fix the amagamation generator so that it works one a clean source tree. (check-in: f502610d03 user: drh tags: trunk) | |
| 15:27 | Include source provenance in the header comment of the amalgamation. (check-in: e3eb5af905 user: drh tags: trunk) | |
| 12:52 | Enhance Lemon so that it remembers which -D command-line options are actually used in the grammar and includes a list of all such options in the header of the generated output file. (check-in: c47a4dbd24 user: drh tags: trunk) | |
|
2023-06-07
| ||
| 23:10 | Add spell-checking for all comments in main sources. (./src/ .c .h .in) make target "misspell" tells of misspelled words for which no exceptions have been put into tool/custom.txt . (check-in: 5332abf0ad user: larrybr tags: trunk) | |
| 17:03 | Fix straggler misspellings and tidy the custom dictionary. Also include pickups from forum post c61fb09afd. (Closed-Leaf check-in: 8c291d9994 user: larrybr tags: spell-check) | |
| 15:00 | Remove additional traces of FTS1 and FTS2 that were missed by [2bb50d5aedef0fd2] (check-in: 9a12bac5d2 user: drh tags: trunk) | |
| 14:47 | Remove unused, legacy shell script "mkso.sh" from the root of the repo. (check-in: 57f75e4869 user: drh tags: trunk) | |
| 08:40 | Add a C-source spell-checking facility. make misspell (on Nix) (check-in: 26c1bb4bd9 user: larrybr tags: spell-check) | |
|
2023-06-06
| ||
| 01:07 | More ExportHandler use. Sync w/trunk. Fix .archive UB. (check-in: 4fd4240f14 user: larrybr tags: cli_extension) | |
|
2023-06-05
| ||
| 17:12 | Fix compiler warning in src-verify.c. (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. (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 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) | |