Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
124 check-ins for the month beginning 2021-03-01 by user drh
Following month ↑|
2021-03-31
| ||
| 23:56 | When resolving names in the RETURNING clause, do not accept trigger names even within subquires. See forum post 34c81d83c9177f46 for context. (check-in: fd4ea3f626 user: drh tags: trunk) | |
| 17:49 | When resolving column names in the RETURNING clause, do not ignore an incorrect table name qualifier. Raise an error instead. (check-in: 3b916924ce user: drh tags: branch-3.35) | |
| 17:42 | When resolving column names in the RETURNING clause, do not ignore an incorrect table name qualifier. Raise an error instead. See forum post 85aef8bc01 for context. (check-in: 51d5c50b2f user: drh tags: trunk) | |
| 13:51 | Defer deletion of expressions that are optimized out by the AND optimizer in the sqlite3ExprAnd() routine until the corresponding Parse object is deleted. This avoids a dangling pointer in AggInfo if sqlite3ExprAnd() is invoked by the push-down optimization. The dangling pointer appears to be harmless in release builds, only showing up in debug builds. Problem found by dbsqlfuzz. (check-in: 77a30f3f7a user: drh tags: branch-3.35) | |
| 13:41 | Ensure that negative numbers may not be used in frame offset clauses even if they are initially text value. e.g. (RANGE BETWEEN '-1' PRECEDING ...). (check-in: 2d179f58bf user: drh tags: branch-3.35) | |
| 13:31 | Defer deletion of expressions that are optimized out by the AND optimizer in the sqlite3ExprAnd() routine until the corresponding Parse object is deleted. This avoids a dangling pointer in AggInfo if sqlite3ExprAnd() is invoked by the push-down optimization. The dangling pointer appears to be harmless in release builds, only showing up in debug builds. Problem found by dbsqlfuzz. (check-in: c36b43589a user: drh tags: trunk) | |
|
2021-03-30
| ||
| 01:57 | Raise an error if a term of the form "TABLE.*" appears in the RETURNING clause, as SQLite does not (yet) know how to handle that. Ticket [132994c8b1063bfb]. (check-in: 257e16f7b3 user: drh tags: branch-3.35) | |
| 01:52 | Raise an error if a term of the form "TABLE.*" appears in the RETURNING clause, as SQLite does not (yet) know how to handle that. Ticket [132994c8b1063bfb]. (check-in: 3039bcaff9 user: drh tags: trunk) | |
|
2021-03-29
| ||
| 21:59 | Increase the patch number to 3.35.4. (check-in: 4375cec281 user: drh tags: branch-3.35) | |
| 20:01 | Simplify the comparison opcodes in the bytecode engine, for a performance improvement. (check-in: f2af5868be user: drh tags: trunk) | |
| 19:47 | Fix VDBE coverage macros. (Closed-Leaf check-in: ebe100de55 user: drh tags: compare-opcode-opt) | |
| 18:53 | Omit the SQLITE_STOREP2 and SQLITE_KEEPNULL options from the comparison opcodes, allowing them to run faster. This required refactoring the vector comparison logic, which in turn required changing OP_ElseNotEq into OP_ElseEq. (check-in: 380b46054b user: drh tags: compare-opcode-opt) | |
| 14:40 | Add the OP_ZeroOrNull opcode and use it to compute boolean values for scalar comparisons, rather than the SQLITE_STOREP2 parameter to the comparison opcode. (check-in: 93781b6f10 user: drh tags: compare-opcode-opt) | |
| 13:47 | The comparison opcodes (ex: OP_Eq) now set the iCompare flag so that the result of comparison can be used by subsequent OP_Jump or OP_ElseNotEq opcodes. (check-in: bd00df8f07 user: drh tags: compare-opcode-opt) | |
|
2021-03-28
| ||
| 23:37 | Alternative implementation of the comparison opcode speed-up of check-in [4a8805d9a66dc888] that should pass muster with UBSAN. (check-in: afb18f6454 user: drh tags: trunk) | |
| 20:44 | Document the "%token" directive for Lemon. This directive has been in place for a while, but was previously undocumented. (check-in: 36624d3740 user: drh tags: trunk) | |
|
2021-03-27
| ||
| 20:45 | Performance improvement in the comparison opcodes by rewriting an array lookup using pointer arithmetic. This makes gcc 5.4.0 builds with -Os both faster and smaller. Though I suspect that in newer compilers with better optimizers in will probably make no difference at all in the generated machine code. Later: Even though the new code is perfectly valid, and generates correct machine code that is both smaller and faster, UBSAN complains about it in OSSFuzz. So we will take it out. So here was have an example of OSSFuzz coercing a widely used application to become bigger and slower. (Leaf check-in: 4a8805d9a6 user: drh tags: gcc-opt) | |
| 16:21 | For the sqlite3_bind_text16 TCL binding used for testing, ensure that there are at least 3 terminating zeros, so that there will always be a \u0000 character even if the original byte sequence is an odd number of bytes. (check-in: c23d092f37 user: drh tags: trunk) | |
|
2021-03-26
| ||
| 23:59 | In the sqlite3_bind_text and sqlite3_bind_text16 TCL commands of the test suite, ensure that the string is zero-terminated if the size argument is negative. (check-in: f472fd6443 user: drh tags: trunk) | |
| 14:04 | Merge up all the 3.35.3 changes into the begin-concurrent-pnu-wal2 branch. (check-in: 4d425e641d user: drh tags: begin-concurrent-pnu-wal2) | |
| 13:58 | Merge the 3.35.3 enhancements into the wal2 branch. (check-in: a1b8d9d213 user: drh tags: wal2) | |
| 13:47 | Merge patch 3.35.3 into the begin-concurrent-report branch. (check-in: 4ba9fc34c5 user: drh tags: begin-concurrent-report) | |
| 13:38 | Merge version 3.35.3 changes into the begin-concurrent-pnu branch. (check-in: 7e4c48afcc user: drh tags: begin-concurrent-pnu) | |
| 13:31 | Merge from 3.35.3 into the begin-concurrent branch. (check-in: 988da36c86 user: drh tags: begin-concurrent) | |
| 13:16 | Merge in changes for 3.35.3 (check-in: 76f19f4bcf user: drh tags: reuse-schema) | |
| 12:12 | Version 3.35.3 (check-in: 4c5e6c200a user: drh tags: release, branch-3.35, version-3.35.3) | |
|
2021-03-24
| ||
| 23:30 | Remove old testcases() macros. Also remove surplus end-of-line whitespace. (check-in: 54b41915ed user: drh tags: trunk) | |
| 19:44 | Comment improvements to on the distinct-agg optimization. Show a line in the EQP output when using an ephemeral table to implement DISTINCT on an aggregate. (check-in: 037ca79e60 user: drh tags: trunk) | |
| 17:28 | Improvements to distinct aggregates such that they can sometimes avoid using an ephermeral table to test for duplicates if the column that is distinct is part of an index. (check-in: ef4ac0ddd2 user: drh tags: trunk) | |
| 17:04 | Fix a harmless compiler warning. (check-in: 26b005a95e user: drh tags: trunk) | |
|
2021-03-23
| ||
| 21:02 | Add an ALWAYS() on a branch that is always taken. (check-in: 0646d2260c user: drh tags: trunk) | |
| 19:39 | Test result adjustments in test/misc7.test due to the EQP format change. (check-in: d3ade8c7fe user: drh tags: trunk) | |
| 16:34 | When doing schema updates, try to convert (incorrect) double-quoted strings into (SQL-standard) single-quoted strings. (check-in: 0770470488 user: drh tags: trunk) | |
| 15:39 | Tweaks to test/scanstatus.test to account for the new EQP format. (check-in: 2eb28afd01 user: drh tags: trunk) | |
| 15:07 | Changes to test/analyzeG.test to conform to the new EXPLAIN QUERY PLAN syntax. (check-in: d8afde1bf1 user: drh tags: trunk) | |
| 14:33 | Fix a test case in bigmmap.test so that it works with the new EXPLAIN QUERY PLAN output format. (check-in: 9ac064fe2a user: drh tags: trunk) | |
| 14:27 | Add the ExprList.nAlloc column and use it to make the sqlite3ExprListAppend() routine much faster. (check-in: 1d3c4662c2 user: drh tags: trunk) | |
| 01:06 | Enhance the EXPLAIN QUERY PLAN output to use symbolic names to describe subqueries, where possible, instead of cryptic subquery index numbers. And in other ways, make the EQP output cleaner and easier to read. Little code is changed, but many of the test results had to be tweaked to align with the new output format. (check-in: f8e28308fd user: drh tags: trunk) | |
|
2021-03-22
| ||
| 18:53 | Merge recent fixes from trunk. (Closed-Leaf check-in: 4a343698b4 user: drh tags: eqp-improvements) | |
| 16:50 | Increase the version number to 3.36.0 to begin the next development cycle. (check-in: 5cee689d64 user: drh tags: trunk) | |
| 16:47 | This branch for any further patches on 3.35. We anticipate 3.35.3 in a few days. Hopefully there will never be a need for 3.35.4. (check-in: 8de4cb984a user: drh tags: branch-3.35) | |
|
2021-03-21
| ||
| 18:23 | Fix an assert() that in preupdate-hook logic (not normally built) that can be false when running VACUUM on a corrupt database file under PRAGMA writable_schema=ON. (check-in: 6bb2134027 user: drh tags: trunk, same-as-3.35.3) | |
| 17:52 | Add a better comment and an assert() on the code inside sqlite3CreateIndex() that REPLACE indexes come at the end of the index list. forum post ceb51d83f7 (check-in: 71e4da136b user: drh tags: trunk) | |
|
2021-03-20
| ||
| 23:15 | Fix the "box" output mode in the shell when statement returns zero-column rows (for example from "PRAGMA incremental_vacuum"). (check-in: 34439fe3ae user: drh tags: trunk) | |
| 15:46 | Use the canonical name, not the AS name, when showing the MATERIALIZE or CO-ROUTINE lines for a CTE. (check-in: 1b83e232c4 user: drh tags: eqp-improvements) | |
| 15:11 | Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: 50fbd53260 user: drh tags: eqp-improvements) | |
| 01:00 | Fix a faulty assert() in the OP_SkipScan opcode. dbsqlfuzz a15a9b2ca82e812ad52f62c86cc93dca0dc72f01. Test cases in TH3. (check-in: 1805b9aaf1 user: drh tags: trunk) | |
|
2021-03-19
| ||
| 19:44 | Further simplification of the EQP output. Only show "SUBQUERY n" if the subquery is anonymous. (check-in: 1fadd30525 user: drh tags: eqp-improvements) | |
| 19:09 | Merge enhancements from trunk. (check-in: d192d73775 user: drh tags: eqp-improvements) | |
| 17:54 | In the wholenumber virtual table, increase the cost penalty for running open-loop. This appears to fix the problem reported by forum post b52a020ce4. (check-in: f12b54042e user: drh tags: trunk) | |
| 16:29 | Dbsqlfuzz found a new way to make that branch in codeVectorCompare reachable. (check-in: 959272c275 user: drh tags: trunk) | |
| 14:51 | Restore the NEVER() that was taken out by [f481636f1a0333c6] because that case is no longer reachable after the previous check-in. (check-in: e3a78b2a23 user: drh tags: trunk) | |
| 13:53 | Correlated CTEs should not generate a materialization subroutine. If they need to be materialized, each use case must be materialized separately. dbsqlfuzz 01b8355086998f0a452cb31208e80b9d29ca739a. (check-in: d72d865d3e user: drh tags: trunk) | |
| 13:00 | Improved labeling of EXPLAIN QUERY PLAN output. Many test failures due to the different output format. (check-in: 6f8faec022 user: drh tags: eqp-improvements) | |
|
2021-03-18
| ||
| 20:04 | Add a NEVER() on a branch that was made unreachable by the "circular reference" fix. (check-in: 114d9780ae user: drh tags: trunk) | |
| 18:27 | Disable a test case requiring generate_series when virtual tables are not available. (check-in: ee86e2f4c5 user: drh tags: trunk) | |
| 16:52 | Increase the patch level to 3.35.3. (check-in: 259b7c3e21 user: drh tags: trunk) | |
| 16:47 | Fix the OP_OpenDup opcode so that it is able to duplicate a cursor that was itself opened by OP_OpenDup. Add additional verification of ephemeral tables. Fix for ticket [bb8a9fd4a9b7fce5]. (check-in: bcbe5308f3 user: drh tags: trunk) | |
| 16:36 | Remove unnecessary code from sqlite3BtreeClose() and add test cases. (Closed-Leaf check-in: edbfdcaefa user: drh tags: opendup-fix) | |
| 15:42 | Further sanity checking of the OpenDup cursors. (check-in: 0ec71cf169 user: drh tags: opendup-fix) | |
| 14:36 | Fix the dbsqlfuzz-derived authorizer in fuzzcheck to avoid creating junk files when running rogue tests. (check-in: eca21a6206 user: drh tags: trunk) | |
| 13:55 | Fix a problem with the filename normalizer in unix, discovered by dbsqlfuzz. (check-in: ff1eca7fcd user: drh tags: trunk) | |
| 13:19 | New assert statements associated with Ephemeral cursors in the bytecode engine. (check-in: a8ce73e257 user: drh tags: trunk) | |
| 12:36 | Change the name of the iDataVersion field of Btree to iBDataVersion to make it distinct from Pager.iDataVersion. (check-in: e4c44c0bca user: drh tags: trunk) | |
|
2021-03-17
| ||
| 19:52 | Update to version 3.35.2 (check-in: 18bec0d263 user: drh tags: reuse-schema) | |
| 19:07 | Version 3.35.2 (check-in: ea80f3002f user: drh tags: trunk, release, version-3.35.2) | |
| 19:05 | Fix a harmless compiler warning in the appendvfs.c extension. (check-in: 0ed7eb9115 user: drh tags: trunk) | |
|
2021-03-16
| ||
| 18:41 | Date/time functions with no arguments (ex: date() or time()) should be non-deterministic. Fix for ticket [2c6c8689fb5f3d2f]. (check-in: 1734c332e7 user: drh tags: trunk) | |
| 14:43 | Increase the version number to 3.35.2. (check-in: 7a211b3f09 user: drh tags: trunk) | |
| 14:26 | Fix recent breakage of the appendvfs extension. (check-in: 7dbbe5b34e user: drh tags: trunk) | |
| 14:12 | Comment and stylistic changes to the appendvfs.c implementation. (Closed-Leaf check-in: 25c3186aa1 user: drh tags: appendvfs_fix) | |
|
2021-03-15
| ||
| 19:34 | Merge version 3.35.1 into the reuse-schema branch. (check-in: 0fe60a63ae user: drh tags: reuse-schema) | |
| 16:53 | Version 3.35.1 (check-in: aea12399bf user: drh tags: trunk, release, version-3.35.1) | |
| 15:12 | Improvements to the built-in ".dump" documentation in the CLI. (check-in: 0915f969f4 user: drh tags: trunk) | |
| 15:02 | Bump the version number to 3.35.1. (check-in: 184d5a352f user: drh tags: trunk) | |
| 14:58 | Improved detection of conflicting indexes when doing DROP COLUMN on a column whose name is quoted in the index definition. Fix for ticket [1c24a659e6d7f3a1]. (check-in: c450d0ad6b user: drh tags: trunk) | |
|
2021-03-14
| ||
| 20:17 | An additional test case (Closed-Leaf check-in: 7e2d7ca15a user: drh tags: tkt-1c24a659-b) | |
| 19:55 | An alternative approach for fixing ticket [1c24a659e6d7f3a1]. (check-in: a2adae907a user: drh tags: tkt-1c24a659-b) | |
| 01:40 | Never allow a double-quoted identifier that appears by itself in the argument list of an index to be interpreted as a string literal. Proposed fix for ticket [1c24a659e6d7f3a1]. (Closed-Leaf check-in: 7c8aa38125 user: drh tags: tkt-1c24a659) | |
|
2021-03-12
| ||
| 17:26 | Merge the 3.35.0 release into the reuse-schema branch. (check-in: c8237a024d user: drh tags: reuse-schema) | |
| 17:18 | Merge the 3.35.0 release into the begin-concurrent-pnu-wal2 branch. (check-in: 939b9e7530 user: drh tags: begin-concurrent-pnu-wal2) | |
| 17:08 | Merge the 3.35.0 release into the wal2 branch. (check-in: 03142e5f76 user: drh tags: wal2) | |
| 16:50 | Merge the 3.35.0 release into the begin-concurrent-report branch. (check-in: 27f8f56b98 user: drh tags: begin-concurrent-report) | |
| 16:24 | Merge the 3.35.0 release into the begin-concurrent-pnu branch. (check-in: a0a9dd52a7 user: drh tags: begin-concurrent-pnu) | |
| 16:18 | Merge version 3.35.0 changes into the begin-concurrent branch. (check-in: 7e38c889e7 user: drh tags: begin-concurrent) | |
| 15:10 | Version 3.35.0 (check-in: acd63062eb user: drh tags: trunk, release, major-release, version-3.35.0) | |
| 13:49 | Fix broken requirement marks. (check-in: 98d6715284 user: drh tags: trunk) | |
| 01:49 | Fix the ".read" command in the CLI so that SQLITE_OMIT_POPEN disables reading from a pipeline. (check-in: cea34f3cc3 user: drh tags: trunk) | |
|
2021-03-11
| ||
| 13:43 | Bug fix in appendvfs.c: Adjust the size parameter for SQLITE_FCNTL_SIZE_HINT to account for the prefix. (check-in: 41df3bbefd user: drh tags: trunk) | |
|
2021-03-10
| ||
| 18:21 | Improved testcase() related the SQLITE_MAX_ATTACHED vs. SQLITE_MAX_DB problem. (check-in: 27d3c00efe user: drh tags: trunk) | |
| 17:52 | Improvement to the ATTACH-abuse authorizer logic in fuzzcheck. (check-in: 88132f698a user: drh tags: trunk) | |
| 16:35 | Do not confuse the constant SQLITE_MAX_ATTACHED with the maximum number of schemas. Add the new SQLITE_MAX_DB constant for the maximum number of schemas. Forum post a006d86f72. (check-in: 7b65fb9f7b user: drh tags: trunk) | |
|
2021-03-09
| ||
| 23:38 | Add appendvfs.c to the MSVC makefile. (check-in: a6681fbb2e user: drh tags: trunk) | |
| 20:58 | Fix a bad comment (copy-paste error) in the byte code engine. No code changes. (check-in: 1c01745734 user: drh tags: trunk) | |
| 19:52 | Improved comments on the NOT NULL strength reduction optimization. (check-in: a85d722939 user: drh tags: trunk) | |
| 19:32 | Extra comments and testcase() macros associated with the new sqlite3ParserAddCleanup() mechanism. No changes to release builds. (check-in: c3c8691121 user: drh tags: trunk) | |
| 17:09 | Add --enable-math to the amalgamation autoconf. On be default. Improved logging of the amalgamation autoconf. (check-in: 85d28b5225 user: drh tags: trunk) | |
| 16:35 | Math functions are enabled by default in the main configure script. (check-in: b7456e0715 user: drh tags: trunk) | |
| 13:53 | Improvements to the configure script. Math functions are enabled by --enable-all. (check-in: c79c6d18de user: drh tags: trunk) | |
| 13:12 | Update the authorizer in fuzzcheck to align with dbsqlfuzz. (check-in: f86d8fae3b user: drh tags: trunk) | |
|
2021-03-08
| ||
| 17:17 | Fix a bad assert in RENAME COLUMN. dbsqlfuzz 3f0a7245b69cd08617d7d7781ebaedb0fe765a93. (check-in: f13e0d12f1 user: drh tags: trunk) | |
| 16:29 | Fix a harmless compiler warning in appendvfs.c (check-in: f538961a80 user: drh tags: trunk) | |
| 16:13 | Enable internal functions for fuzzcheck. (check-in: 79281603b9 user: drh tags: trunk) | |
| 13:45 | Require that the appendvfs suffix mark indicate that the appended database begins at an offset that is a muliple of 512 and that the appended database contains at least 512 bytes. (Leaf check-in: aeb87cc704 user: drh tags: appendvfs_tighten) | |
| 13:30 | Correct the precendence order for rules that determine how a database is opened by appendvfs when a database is appended to another database. (check-in: 92989fc56f user: drh tags: appendvfs_tighten) | |
| 12:59 | Minor comment and formatting changes. (check-in: cf2add064f user: drh tags: appendvfs_tighten) | |
|
2021-03-06
| ||
| 15:13 | Limit parenthesis nesting depth in FTS3 expressions to SQLITE_MAX_EXPR_DEPTH. (check-in: 5ddd8032ef user: drh tags: trunk) | |
| 13:02 | Fix a possible NULL pointer dereference when applying a DROP COLUMN to a corrupt database schema. dbsqlfuzz 419aa525df93db6e463772c686ac6da27b46da9e (check-in: 349ccf58ae user: drh tags: trunk) | |
|
2021-03-05
| ||
| 18:33 | Modify the SQLITE_DBCONFIG_ENABLE_VIEW option so that it always permits TEMP views, just as SQLITE_DBCONFIG_ENABLE_TRIGGER always permits TEMP triggers. (check-in: 83dab8b358 user: drh tags: trunk) | |
| 14:08 | Fix the processing of implied LIMIT clauses when flattening a compound query. (check-in: 90c6b9fcb0 user: drh tags: trunk) | |
|
2021-03-04
| ||
| 19:44 | Mark the NotUsed parameter to the dropColumnFunc() function as unused, to avoid a harmless compiler warning. (check-in: 2345907109 user: drh tags: trunk) | |
| 18:34 | Put ALWAYS() on a branch that is now always true because of changes in OOM behavior due to check-in [9adf6e2469d18bc3]. (check-in: 8a1bb9c3e9 user: drh tags: trunk) | |
| 16:32 | Remove a branch made unreachable by check-in [e893f88750ea64d4]. (check-in: 20d7dc120d user: drh tags: trunk) | |
| 16:03 | Earlier detection of a misplaced ORDER BY or LIMIT clause in a compound SELECT. This prevents problems in recursive CTEs with multiple recursive terms in which there is an ORDER BY or LIMIT clause on the last non-recursive term. (check-in: e893f88750 user: drh tags: trunk) | |
|
2021-03-03
| ||
| 19:54 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: 73bf458e1d user: drh tags: reuse-schema) | |
| 19:41 | Merge in recent enhancements. (check-in: b0fc8ca14e user: drh tags: begin-concurrent-pnu-wal2) | |
| 19:32 | Merge recent trunk enhancements into the wal2 branch. (check-in: 0ae8103908 user: drh tags: wal2) | |
| 19:25 | Merge recent trunk enhancemenets into the begin-concurrent-pnu branch. (check-in: 59d3ec295a user: drh tags: begin-concurrent-pnu) | |
| 19:17 | Merge recent trunk changes into the begin-concurrent branch. (check-in: acdafef836 user: drh tags: begin-concurrent) | |
| 14:07 | Fix a harmless assertion fault resulting from [6e6b3729e0549de0] that was discovered by dbsqlfuzz. Enhance .selecttrace output to show omitted ORDER BY clauses. New dbsqlfuzz test cases added. (check-in: 27a0388ad6 user: drh tags: trunk) | |
|
2021-03-02
| ||
| 21:07 | Cast a string size variable to 64-bit to avoid any possibility of integer overflow. (check-in: a5940294b2 user: drh tags: trunk) | |
| 16:27 | Limit the size of the exponent input in the second argument to the ieee754() SQL function, to avoid integer overflow. Ticket [22dea1cfdb9151e4]. (check-in: 99aab32da1 user: drh tags: trunk) | |
| 00:42 | Add ALWAYS() to an always-true conditional. (check-in: fa3506db20 user: drh tags: trunk) | |
|
2021-03-01
| ||
| 21:43 | Add #ifndef macros so that the build works again with -DSQLITE_OMIT_AUTHORIZATION and -DSQLITE_OMIT_WINDOWFUNC. (check-in: 9400bdc602 user: drh tags: trunk) | |