Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 check-ins occurring around 0f0959c6f95046e8.
|
2021-05-24
| ||
| 12:28 | Minor comment improvements in fuzzcheck.c. (check-in: 7aca8d52c1 user: drh tags: trunk) | |
| 12:13 | New dbsqlfuzz cases added to test/fuzzdata8.db. (check-in: 5bb5c9ec04 user: drh tags: trunk) | |
| 11:35 | Fix the TreeView module so that it works with the TK_ERROR exprssion. Also fix an assert() that was failing due to the recent TK_ERROR addition. (check-in: dd56fbe0cf user: drh tags: trunk) | |
| 00:17 | Additional defenses (above and beyond [b986600520696b0c]) to prevent an invalid subquery from causing problems downstream. If an error is found while analyzing a subquery expression, change the expression to TK_ERROR so inhibit further processing on that expression. dbsqlfuzz cf624b8c0484c66e0f552bf6475e3e3f2c22b24e. (check-in: 0be6b6c9f7 user: drh tags: trunk) | |
|
2021-05-23
| ||
| 17:47 | Do not push a WITH clause onto the processing stack if prior errors have occurred. dbsqlfuzz 6b7a144674e215f06ddfeb9042c873d9ee956ac0. (check-in: c2066dde53 user: drh tags: trunk) | |
|
2021-05-22
| ||
| 15:05 | Merge latest trunk changes into this branch. (check-in: dbc65a6958 user: dan tags: reuse-schema) | |
| 11:23 | Do not invoke sqlite3ExprAffinity() after a syntax error that might have left the tree in an inconsistent state. See also [e8a1515b44380cc5] and forum post 7e484e225c. (check-in: b986600520 user: drh tags: trunk) | |
| 11:00 | The fix in the previous check-in was only correct if the OOM occurs on the initial allocation. This changes should make it correct for a resize as well. (check-in: 57087ab2f2 user: drh tags: trunk) | |
| 01:30 | If an FTS5 Cursor fails to enlarge the space for the aInst array, set the size of the aInst array to zero. dbsqlfuzz 294254b8105cca409f27a711f1eb2e9e63cbcac5. (check-in: 4ae5e5b5ec user: drh tags: trunk) | |
|
2021-05-21
| ||
| 21:49 | If there are errors in a nested CTE, be sure to abandon processing. Do not continue since the parse tree may have been left in a goofy state which could cause use-after-free and segfaults. See forum post aa4a7a3980 for an example. (check-in: 94225d6939 user: drh tags: trunk) | |
| 17:31 | Merge latest changes from wal2 into this branch. (check-in: 4efefb5938 user: dan tags: begin-concurrent-pnu-wal2) | |
| 16:42 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 95cc778345 user: drh tags: wal2) | |
| 16:41 | Fix a problem with SQLITE_MAX_MEMORY in malloc.c. (check-in: c18dbe2f38 user: dan tags: trunk) | |
| 16:32 | Merge the latest trunk changes into begin-concurrent-report branch via the begin-concurrent-pnu branch. (check-in: 1dc6cf5113 user: drh tags: begin-concurrent-report) | |
| 16:17 | Merge recent trunk changes into the begin-concurrent-pnu branch. (check-in: a8d05f8e92 user: drh tags: begin-concurrent-pnu) | |
| 15:33 | Merge all recent trunk changes into the begin-concurrent branch. (check-in: 0dba9010ad user: drh tags: begin-concurrent) | |
| 13:32 | Add a new sqlite3_config() option for setting the maximum precision of a printf() substitition. The default value is 100,000. It was formerly more than 2 billion. The default can be changed using the SQLITE_PRINTF_PRECISION_LIMIT compile-time option. (Leaf check-in: fd8b68a474 user: drh tags: compile-time-precision-limit) | |
|
2021-05-20
| ||
| 23:25 | Fix a faulty assert() statement in sqlite3ExprListDup(). This is a continuation of the fix at [59812e7ef705226c]. (check-in: 240f7494bf user: drh tags: trunk) | |
| 18:11 | Enhance one test case to use various alternative definitions of DUAL. (check-in: 179dcb6ba7 user: drh tags: trunk) | |
| 17:15 | Ensure that objects within view definitions are not incorrectly resolved to CTEs that are part of the statement using the view. (check-in: f7dcc4b519 user: dan tags: trunk) | |
| 11:42 | Ensure the required b-tree mutexes are held for "CREATE TABLE IF NOT EXISTS" and "DROP TABLE IF EXISTS" statements on attached databases. (check-in: 67bde01614 user: dan tags: trunk) | |
| 00:44 | Replace [0f0959c6f95046e8] with a new and better solution that also fixes the CTE name resolution problem described in forum post 8590e3f6dc. Test cases for both problems added. (check-in: 5614279daf user: drh tags: trunk) | |
| 00:10 | Fixes and improvements to PRAGMA compile_options. (check-in: 34579549a3 user: drh tags: trunk) | |
|
2021-05-19
| ||
| 23:29 | final merge from trunk (Leaf check-in: 0662956944 user: larrybr tags: compile_options) | |
| 21:55 | When constructing the synthensized SELECT statement that is used to choose the rows in an UPDATE FROM, make sure the first table is really the table being updated, and not some common-table expression that happens to have the same name. forum post a274248080. More changes associated with CTE name resolution are pending. (check-in: 0f0959c6f9 user: drh tags: trunk) | |
| 20:01 | Incorporate ..._DESERIALIZE revision. (check-in: b70587cca9 user: larrybr tags: compile_options) | |
| 19:55 | merge from trunk (check-in: 19ffe3cfe2 user: larrybr tags: compile_options) | |
| 19:28 | Add a comment with useful information about SHM locking. No changes to deliverable code. (check-in: 4e81ea3b15 user: drh tags: trunk) | |
| 19:27 | Fix a formatting error on the comment. (Closed-Leaf check-in: 6f2fb60e49 user: drh tags: better-comment) | |
| 16:55 | Add a table of shared-memory lock offsets in a comment in the os_unix.c code. Include some assert()s to help verify the numbers. (check-in: b480aacb34 user: drh tags: better-comment) | |
| 14:49 | Allow aggregate sub-selects within ORDER BY and PARTITION BY clauses of window frame definitions. (check-in: 3daab94977 user: dan tags: trunk) | |
| 12:17 | Improved column name and column type determination for the RETURNING clause. (check-in: 699c33990a user: drh tags: trunk) | |
| 02:33 | Cure some TCL test failures and narrow an object scope. (check-in: 1155696c70 user: larrybr tags: trunk) | |
|
2021-05-18
| ||
| 19:10 | In the MULTI-INDEX OR query plan, code for sub-expressions can sometimes be generated twice. But for some subqueries, generating code off of the same tree twice causes problems. So now MULTI-INDEX OR makes a copy of the sub-expressions it uses to avoid code-generating them more than once. dbsqlfuzz 9ebd2140e7206ff724e665f172faea28af801635. (check-in: 4a55f72542 user: drh tags: trunk) | |
| 12:36 | Improved comments on the generated opcodes.h file. (check-in: f2a17f1fad user: drh tags: trunk) | |
| 00:52 | Add a CORRUPT_DB term to an assert() added earlier today. (check-in: 304739d238 user: drh tags: trunk) | |
|
2021-05-17
| ||
| 17:14 | Fix harmless compiler warnings. (check-in: ace12a3912 user: drh tags: trunk) | |
| 16:54 | Enhance the integer-comparison optimization on the OP_Eq and similar opcodes so that it avoids a lot of useless work. (check-in: 4221f41af9 user: drh tags: trunk) | |
| 16:20 | Fix problems with refering to CTEs from within sub-selects in PARTITION BY or ORDER BY clauses of window frame definitions. Also a problem with renaming a column when the schema contains a trigger containing a correlated sub-select within a window frames PARTITION BY or ORDER BY clause. (check-in: 4c6cd54a8d user: dan tags: trunk) | |
| 13:11 | When deleting an SQL function that does not exist, return without doing anything at all rather than creating a tombstone function. In this way, function deletes that happen inside virtual-table destructors that are run when a database connection is closing do not create new tombstones in the function table after the function table has already been purged. forum post 726219164b. (check-in: 391c73132c user: drh tags: trunk) | |
| 11:19 | Performance improvement in sqlite3TableLock(). (check-in: 0d77e371c4 user: drh tags: trunk) | |
|
2021-05-15
| ||
| 19:36 | Performance optimization in the memory allocation of allocateCursor. (check-in: 9d16323d14 user: drh tags: trunk) | |
| 13:08 | Performance optimization to the clearCell() routine inside of btree. (check-in: c4e02619a4 user: drh tags: trunk) | |
|
2021-05-14
| ||
| 20:01 | Small performance improvement for sqlite3BtreeInsert(). (check-in: 4ae64484c5 user: drh tags: trunk) | |
| 15:37 | Avoid adding superfluous virtual WHERE clause terms that might arise due to the constant propagation optimization. (check-in: cf63abbe55 user: drh tags: trunk) | |
| 14:26 | Attempt the constant propagation optimization on any WHERE clause that has a top-level AND operator, even if the query is not a join. This is an attempt to partially address the concern raised in forum post 830d37b928. (check-in: e994c9f29f user: drh tags: trunk) | |
| 13:32 | Fix an over-length source code comment in whereexpr.c. No logic changes. (check-in: af5eb902e7 user: drh tags: trunk) | |
|
2021-05-13
| ||
| 18:24 | Modify the sqlite3_stmt_readonly() interface so that it returns false for CREATE TABLE IF NOT EXISTS statements even if the table already exists and the statement is really a read-only no-op. Likewise for DROP TABLE, CREATE INDEX, and DROP INDEX. Update the documentation for sqlite3_stmt_readonly() to reflect this new behavior. (check-in: cf8eb46597 user: drh tags: trunk) | |
| 13:43 | The content columns of the index-btree that implements a WITHOUT ROWID table are not ordered and so the query planner should not assume they are ordered. Fix for the issue identified by forum post 6c8960f545. (check-in: c21bc5a235 user: drh tags: trunk) | |
|
2021-05-12
| ||
| 22:15 | Further simplification of the reverse-order scan logic of the previous check-in. (check-in: b2b0e23ba8 user: drh tags: trunk) | |