Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
101 events for the month beginning 2022-12-01 by user drh
Following month ↑|
2022-12-29
| ||
| 18:54 | A call to sqlite3_declare_vtab() should not cause DML/DDL authorization failures. (check-in: eed1e030 user: drh tags: trunk) | |
|
2022-12-28
| ||
| 14:55 | Merge the 3.40.1 changes into the reuse-schema branch. (Leaf check-in: 126c68bd user: drh tags: reuse-schema-3.40) | |
| 14:03 | Version 3.40.1 (check-in: df5c253c user: drh tags: release, version-3.40.1, branch-3.40) | |
|
2022-12-27
| ||
| 14:06 | Fix a missing 0 at the end of an integer literal in the MEMSYS5 fix. (check-in: e3bc10e8 user: drh tags: branch-3.40) | |
| 14:03 | Fix a missing 0 at the end of an integer literal in check-in [8da0f0c38a458c57] (check-in: e3776796 user: drh tags: trunk) | |
|
2022-12-26
| ||
| 17:09 | Fix an unsafe use of sqlite3_mprintf() in sqlite3_overload_function() identified by forum post: https://sqlite.org/forum/forumpost/95b338860d. (check-in: a3152226 user: drh tags: branch-3.40) | |
| 17:02 | Prevent the sessions rebaser from generating changesets containing UPDATE records for which non-PK fields are present in the old.* but not the new.* record. Also update the changeset iterator to work around such changesets. (check-in: 629dbe25 user: drh tags: branch-3.40) | |
| 16:55 | • Edit [9fa2b94c2e0fd43c|9fa2b94c]: Edit check-in comment. (artifact: 48836ecc user: drh) | |
| 16:54 | In the unix backend, when implementing the defenses against small file descriptors, delete a file just created if it was opened with O_EXCL|O_CREAT so that it can be created again the next time through the loop. Fix for the problem described by forum post 699af709ab3a8ccf. (check-in: 174acf32 user: drh tags: branch-3.40) | |
| 16:45 | Fix an over-zealous assert() reported by Yong Heng. (check-in: 1e9dbb5a user: drh tags: branch-3.40) | |
| 16:24 | Ensure the RETURNING clause is honoured when a row of a temp table is updated by an ON CONFLICT clause. (check-in: ac9568cf user: drh tags: branch-3.40) | |
| 16:12 | Add the SQLITE_FCNTL_RESET_CACHE verb. Use it to ensure that the page cache is purged before and after a the recovery extension is run. (check-in: 71dd920f user: drh tags: branch-3.40) | |
| 16:03 | Fix corner cases in UTF8 handling in the REGEXP extension. Forum post 3ffe058b04. (check-in: 93e68b39 user: drh tags: branch-3.40) | |
| 15:55 | Fix a off-by-one error in code generation that comes up when doing a DISTINCT query against a virtual table with an OR term in the WHERE clause and where the ORDER BY clause has 64 or more references to the result set. Forum post dfe8084751. The error is harmless in production builds, but might cause an assertion fault in a debugging build. (check-in: cbcd7d9b user: drh tags: branch-3.40) | |
| 15:53 | • Edit [04af7ef77043702f|04af7ef7]: Edit check-in comment. (artifact: e93f9f2a user: drh) | |
| 15:44 | Fix safe mode authorizer callback to reject disallowed UDFs. Reported at Forum post 07beac8056151b2f. (check-in: 70964b8a user: drh tags: branch-3.40) | |
| 15:32 | • Edit [c10d40ca683941be|c10d40ca]: Edit check-in comment. (artifact: a5c7f6fc user: drh) | |
| 15:32 | • Edit [8da0f0c38a458c57|8da0f0c3]: Edit check-in comment. (artifact: 23e8ee30 user: drh) | |
| 15:21 | Fix an infinite loop in the MEMSYS5 auxiliary memory allocator that occurs for memory allocations between 500MiB and 1GiB in size. Error introduced by check-in [949133231f8f751a]. The problem only affects builds that include the SQLITE_ENABLE_MEMSYS5 compile-time option. (check-in: c10d40ca user: drh tags: branch-3.40) | |
| 15:14 | Fix an infinite loop in the MEMSYS5 auxiliary memory allocator that occurs for memory allocations between 500MiB and 1GB in size. Error introduced by check-in [949133231f8f751a]. The problem only affects builds that include the SQLITE_ENABLE_MEMSYS5 compile-time option. (check-in: 8da0f0c3 user: drh tags: trunk) | |
|
2022-12-23
| ||
| 14:49 | Fix lots of harmless, nuisance compiler warnings, mostly unused parameter warnings in extensions. (check-in: c14bbe16 user: drh tags: trunk) | |
| 11:46 | Additional fixes for yet more completely harmless compiler warnings. (check-in: 7d3772f0 user: drh tags: trunk) | |
|
2022-12-22
| ||
| 21:32 | Asserts added to ensure that the iCompare variable in the bytecode engine is correctly initialized before it is used. (check-in: 7b5900a1 user: drh tags: trunk) | |
| 19:12 | Avoid having to reinitialize Vdbe.pResultRow upon each call to sqlite3_step() for a small size reduction and performance increase. (check-in: 6a00d67f user: drh tags: trunk) | |
| 18:44 | Rename the Vdbe.pResultSet field to pResultRow in order to better distinguish it from other variables with similar names. (check-in: 1fd6211e user: drh tags: trunk) | |
| 18:35 | Small performance optimization associated with shared cache in the byte-code engine. (check-in: 3181331c user: drh tags: trunk) | |
| 17:36 | Small performance optimization on the OP_Insert opcode. (check-in: 781fdcb9 user: drh tags: trunk) | |
|
2022-12-21
| ||
| 21:01 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 1bfae9b3 user: drh tags: reuse-schema) | |
| 20:43 | Merge the latest trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: bcab19d2 user: drh tags: begin-concurrent-pnu-wal2) | |
| 20:28 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 21ebd4cf user: drh tags: wal2) | |
| 20:17 | Merge the latest trunk enhancements into the begin-concurrent-report branch. (Leaf check-in: 397fb07b user: drh tags: begin-concurrent-report) | |
| 20:07 | Update the begin-concurrent branch with the latest enhancements on trunk. (check-in: 0c198aee user: drh tags: begin-concurrent) | |
| 19:11 | More efficient implementation of large precisions on the "%c" format for the built-in printf(). This is an effort to avoid a reported timeout on a (ridiculous) query generated by OSSFuzz. (check-in: 371f9b88 user: drh tags: trunk) | |
| 14:13 | Ensure that the expression of a virtual column really is an expression and not just a reference to another column, as a real expression is necessary for the indexed expression coverage optimization to work properly. Forum thread 07b36e3899a9ae21. (check-in: 40549bac user: drh tags: trunk) | |
| 12:18 | New WHERETRACE entries for adding and removing objects from the Parse.pIdxEpr list as part of indexed expression coverage. Debug and testing changes only - no affect on production builds. (check-in: 4dc438a9 user: drh tags: trunk) | |
|
2022-12-20
| ||
| 15:22 | Add about 150 new fuzzer cases to test/fuzzdata8.db. (check-in: a8d8d9cd user: drh tags: trunk) | |
| 15:02 | Add ALWAYS() to always-true branches in the locking logic of the memdb VFS. (check-in: 01fa7602 user: drh tags: trunk) | |
| 14:02 | Improvement to the dbsqlfuzz fix of [f113eebdbe68246f]. (check-in: 79d62956 user: drh tags: trunk) | |
| 01:48 | Do not use indexed expressions to replace the expression being indexed on a RIGHT JOIN as that leads to problems, as shown by dbsqlfuzz a644e70d7683a7ca59c71861a153c1dccf8850b9. (check-in: f113eebd user: drh tags: trunk) | |
|
2022-12-19
| ||
| 23:27 | • Edit [b9190d3da70c4171|b9190d3d]: Edit check-in comment. (artifact: b31805b6 user: drh) | |
| 19:04 | Remove an unused variable. (check-in: 5c4d9414 user: drh tags: trunk) | |
| 12:25 | Fix a minor problem with the printAggInfo() routine (used on during debugging). (check-in: c8329967 user: drh tags: trunk) | |
|
2022-12-17
| ||
| 22:10 | Fix an unnecessarily restrictive assert() in the aggregate logic. dbsqlfuzz 699bee2aa26c5dc84afabf6894685c316d936485 (check-in: 8cc0af81 user: drh tags: trunk) | |
| 12:49 | Add NEVER/ALWAYS to branches that have become unreachable due to recent enhancements. (check-in: b4281db4 user: drh tags: trunk) | |
|
2022-12-16
| ||
| 18:32 | Disallow some of the query invariant tests on SQL statements that contain a GROUP BY since output terms that are no covered by the GROUP BY are indeterminant. (check-in: 28ba1fec user: drh tags: trunk) | |
| 12:07 | In the fuzzer invariant checker, do not add new WHERE clause terms that make use of an ambiguous column name. (check-in: d5b46541 user: drh tags: trunk) | |
|
2022-12-15
| ||
| 20:03 | Create a new affinity called FLEXNUM that works like NUMERIC except that it never tries to convert integer to real or real to integer. The affinity is only used internally - it is not possible to create a table column with this affinity. This affinity is used on subqueries and views that are built off of a compound SELECT and where the datatype is controlled by a CAST expression. dbsqlfuzz c9ee6f9a0a8b8fefb02cf69de2a8b67ca39525c8 (check-in: 44135d6e user: drh tags: trunk) | |
| 15:37 | Omit the columnTypeImpl() function from the build when SQLITE_OMIT_DECLTYPE is defined, because it is no longer used in that case. (check-in: 751e344f user: drh tags: trunk) | |
| 13:45 | Fix harmless compiler warnings. (check-in: ddb260cc user: drh tags: trunk) | |
|
2022-12-14
| ||
| 23:53 | Fix minor problems in the new sqlite3ExprDataType() function. (check-in: c1d5261b user: drh tags: trunk) | |
| 18:35 | • Fixed ticket [73ebbb3a]: View ought not be materialized plus 3 other changes (artifact: e973c9e3 user: drh) | |
| 18:34 | Adjust the query planner to be more aggressive about using co-routines rather than materializing subqueries and views. Implementation of enhancement request [73ebbb3a3d1a7bd3]. (check-in: 0b58d1b3 user: drh tags: trunk) | |
| 17:52 | Merge all the latest trunk enhancements into the coroutines-exp2 enhancement branch. (Closed-Leaf check-in: ea278438 user: drh tags: coroutines-exp2) | |
| 17:46 | Rework the code that computes the datatypes and affinities for subqueries and views. If the subquery/view is constructed from a compound SELECT where the affinity varies across arms of the compound, set the affinity for the corresponding column in the constructed view to be BLOB so that it is allowed to take on any data type. (check-in: 27655c93 user: drh tags: trunk) | |
| 14:41 | If the SELECT that implements a subquery or a VIEW or a CREATE TABLE AS is a compound with different result datatypes on two or more arms of the compound, then the overall column type becomes BLOB (ANY). (Closed-Leaf check-in: 6ebb178c user: drh tags: refactor-subquery-types) | |
| 09:06 | Back out the part of the change in [88a05141c28e5ff1] that adds affinity to the materialization of a view, as the affinity can be undefined for a compound query. This passes all TCL tests, but shows failures in the TH3 tests derived from forum post 6f842bc5b2dadcb2, presumably because the WHERE clause of the query uses constraints of the form "source_crs_code='8675'" instead of "source_crs_code=8675". Perhaps further changes on this branch should reimplement affinity on joins in cases where the affinity is unambiguous. (check-in: fe5a77bc user: drh tags: refactor-subquery-types) | |
|
2022-12-13
| ||
| 16:59 | Remove an unused variable from sqlite3SubqueryColumnTypes(). (check-in: c6e3ff39 user: drh tags: refactor-subquery-types) | |
| 16:55 | Use standard datatype names for the column datatypes in views and subqueries. (check-in: baf2c241 user: drh tags: refactor-subquery-types) | |
| 15:54 | Refactor the sqlite3SelectAddColumnTypeAndCollation() routine. Improved comments. Now called sqlite3SubqueryColumnTypes(). (check-in: 4dfb1b45 user: drh tags: refactor-subquery-types) | |
| 13:33 | Slightly faster implementation of sqlite3ExprAffinity(). (check-in: 01cf3278 user: drh tags: trunk) | |
| 00:59 | • Fixed ticket [57c47526]: Incorrect answer when flattening a UNION ALL compound plus 3 other changes (artifact: b6b79106 user: drh) | |
| 00:51 | Merge recent trunk changes into the coroutine-exp2 branch. (check-in: c43f433b user: drh tags: coroutines-exp2) | |
|
2022-12-12
| ||
| 21:22 | Further fix for ticket [57c47526c34f01e8]. If a subquery has a result set column of the form "CAST(expr AS NUMERIC)" do not give that column NUMERIC affinity. NUMERIC affinity always goes to an integer if able, but a CAST to numeric is a no-op if the input is a number. So the two are not equivalent. (check-in: f0325359 user: drh tags: trunk) | |
| 18:58 | If a subquery has a result column of the form "CAST(... AS NUMERIC)" then give that column no affinity rather than NUMERIC affinity. This is because casting to numeric preserves real values that could be integers but numeric affinity does not. By using no affinity on the column, we make the behavior consistent if the subquery is implemented as a co-routine or is materialized. (Closed-Leaf check-in: ece07d09 user: drh tags: cast-to-numeric) | |
|
2022-12-10
| ||
| 19:37 | • Fixed ticket [679ed6a2]: Different affinities in CREATE VIEW depending if column names declared plus 3 other changes (artifact: 351328ce user: drh) | |
| 19:37 | • Edit [6f0bf892695acaa2|6f0bf892]: Edit check-in comment. (artifact: 236a61e3 user: drh) | |
| 13:34 | • Ticket [679ed6a2] Different affinities in CREATE VIEW depending if column names declared status still Open with 5 other changes (artifact: b9a91241 user: drh) | |
| 13:34 | • Ticket [73ebbb3a] View ought not be materialized status still Open with 3 other changes (artifact: f0e33ae3 user: drh) | |
| 13:31 | • Open ticket [57c47526]: Incorrect answer when flattening a UNION ALL compound plus 4 other changes (artifact: 0f234843 user: drh) | |
| 12:06 | Rerun autoconf using version 2.69 to minimize configure script differences with trunk. (check-in: b6334283 user: drh tags: wasi-patches) | |
|
2022-12-09
| ||
| 18:26 | Remove the SQLITE_PREPARE_SAFEOPT flag. The name is obsolete and it is at the wrong level. Instead use the SF_UpdateFrom flags on the Select object. (check-in: 78723a9a user: drh tags: coroutines-exp2) | |
| 17:33 | Do not allow OOM faults in EQP messages associated with automatic indexes on co-routines to go unreported. (check-in: d125d5af user: drh tags: coroutines-exp2) | |
| 13:49 | Fix typo in the SQLITE_DBCONFIG_LOOKASIDE documentation. (check-in: c6e7582a user: drh tags: trunk) | |
|
2022-12-08
| ||
| 16:47 | Improved comments on the new co-routine logic. Fix a C++-ism in the code. Update test cases to accommodate the more aggressive use of co-routines. (check-in: 9243e850 user: drh tags: coroutines-exp2) | |
| 13:56 | Do not use a co-routine on a subquery that is participating in a self-join. (check-in: ea4306a0 user: drh tags: coroutines-exp2) | |
|
2022-12-07
| ||
| 21:19 | Merge the latest fixes and enhancements from trunk into the coroutines-exp2 branch. (check-in: 1c5f4198 user: drh tags: coroutines-exp2) | |
| 19:51 | Fix harmless compiler warning in the dynamic continuation prompt of the CLI. (check-in: 68947b0a user: drh tags: trunk) | |
| 16:58 | Streamline and improve testing of the locking in the memdb VFS. Follow-on to [15f0be8a640e7bfa]. (check-in: d71a0837 user: drh tags: trunk) | |
| 00:14 | Fix a (harmless) off-by-one error in code generation that comes up when doing a DISTINCT query against a virtual table with an OR term in the WHERE clause and where the ORDER BY clause has 64 or more references to the result set. Forum post dfe8084751. NB: The bug is "harmless" in the sense that no harm comes of it in a production build. However, an assertion fault might occur in a debugging build given some really wonky SQL inputs without this fix. (check-in: 04af7ef7 user: drh tags: trunk) | |
|
2022-12-06
| ||
| 19:58 | • New ticket [679ed6a2] Different affinities in CREATE VIEW depending if column names declared. (artifact: 7a0f43e8 user: drh) | |
| 15:24 | Simplified experimental changes to promote the use of co-routines. Less cruft than the coroutines-exp1 branch, but still does not work. Checked in as a work-in-progress. (check-in: e2318a30 user: drh tags: coroutines-exp2) | |
| 15:22 | • Edit [e7d323c16ee77481|e7d323c1]: Mark "Closed". (artifact: c198e561 user: drh) | |
| 15:11 | Fix compiler warnings in the new dynamic continuation prompt logic of the CLI. (check-in: 0d80500d user: drh tags: trunk) | |
| 13:12 | In the unix backend, when implementing the defenses against small file descriptors, delete a file just created if it was opened with O_EXCL|O_CREAT so that it can be created again the next time through the loop. Fix for the problem described by forum post 699af709ab3a8ccf. (check-in: c0cfe058 user: drh tags: trunk) | |
| 00:54 | Highly experimental (and non-working) changes aimed at increasing the number of occasions where a subquery can be implemented using a co-routine rather than being materialized. This is just saving work in progress. (Closed-Leaf check-in: e7d323c1 user: drh tags: coroutines-exp1) | |
|
2022-12-05
| ||
| 17:31 | • Ticket [73ebbb3a] View ought not be materialized status still Open with 6 other changes (artifact: 1faa067b user: drh) | |
| 14:24 | • Edit [15f0be8a640e7bfa|15f0be8a]: Edit check-in comment. (artifact: 39a3161a user: drh) | |
| 14:23 | Fix a problem in the memdb vfs xLock() function allowing clients to upgrade to EXCLUSIVE locks when other connections are holding SHARED. (check-in: d18cce37 user: drh tags: branch-3.40) | |
| 14:20 | Regenerate the configure script so that it includes the correct patch number. (check-in: e2ae2ea1 user: drh tags: branch-3.40) | |
| 10:50 | Remove obsolete "experimental" comments on the virtual-table interface documentation in sqlite.h.in. (check-in: 28fc32ab user: drh tags: trunk) | |
| 02:53 | • Fixed ticket [e8b67424]: Query planner chooses an inefficient algorithm. plus 5 other changes (artifact: a9db5f95 user: drh) | |
| 02:52 | Improved query planner cost estimates. Fix for ticket [e8b674241947eb3b]. (check-in: 1b779afa user: drh tags: trunk) | |
| 02:42 | Use the smaller estimated row size for searching IPK tables, but use the original larger row size estimate for scanning, since the leaves can have large rows. (Closed-Leaf check-in: df381899 user: drh tags: qp-tuning) | |
|
2022-12-04
| ||
| 22:47 | • Edit [4d934f00634fa318|4d934f00]: Move to branch wrong branch.. Edit check-in comment. (artifact: 1438efba user: drh) | |
|
2022-12-03
| ||
| 19:04 | Increase the nominal row size for IPK index lookups slightly, for better balance. (check-in: 1a61c500 user: drh tags: qp-tuning) | |
| 18:21 | Add TOTAL rows to the output generated by tool/vdbe_profile.tcl. (check-in: 98005863 user: drh tags: qp-tuning) | |
| 17:23 | Add a test case to show that ticket [e8b674241947eb3b] has been fixed. (check-in: e20de6d4 user: drh tags: qp-tuning) | |
| 17:09 | Further improvements to the estimated cost of sorting. Take into account the number of columns to be sorted. (check-in: f3290cf8 user: drh tags: qp-tuning) | |
| 00:52 | Tuning the query planner by adjusting the weights that predict the relative performance of sorting and index lookup. (check-in: 9f2806da user: drh tags: qp-tuning) | |
|
2022-12-02
| ||
| 17:52 | For the sqlite3_bind and sqlite3_result interfaces for UTF16 strings, round the number of bytes down to the next even number, to avoid creating a UTF16 string that is an odd number of bytes. Forum post 411199488d065f83. (check-in: b57e3c3d user: drh tags: trunk) | |
| 15:31 | Use sqlite3_result_int64() instead of sqlite3_result_int() when returning potentially large values from the DBSTAT virtual table, to avoid integer overflows in the result. Forum post ada2ab044f. (check-in: 5652154a user: drh tags: trunk) | |