Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
38 events for week 2024-14 beginning on 2024-04-08
Following week ↑|
2024-04-07
| ||
| 18:55 | Merge trunk testing enhancements into the pushdown-subquery branch. (check-in: 287ff24b user: drh tags: pushdown-subquery) | |
| 18:36 | Omit all rowid-in-view restrictions from the fuzzinvariant.c test module as they are no longer necessary, as of the previous check-in. (check-in: 6431538f user: drh tags: trunk) | |
| 18:23 | If SQLITE_ALLOW_ROWID_IN_VIEW is set to 2, then all rowids for views return a value of NULL. (check-in: 0a53dde2 user: drh tags: trunk) | |
| 10:30 | Merge trunk enhancements into the pushdown-subquery branch. (check-in: 27865e31 user: drh tags: pushdown-subquery) | |
| 10:27 | Add comments to note the name abiguity between the MySQL push-down optimization and the WHERE-clause push-down optimization. (check-in: 3d5fb1ec user: drh tags: trunk) | |
| 10:22 | • Edit [681dfe2dd60714da|681dfe2d]: Move to branch wrong-branch. (artifact: 75f1b85e user: drh) | |
|
2024-04-06
| ||
| 23:09 | Add comments to note the name abiguity between the MySQL push-down optimization and the WHERE-clause push-down optimization. (Leaf check-in: 681dfe2d user: drh tags: wrong-branch) | |
| 20:18 | • Edit [6df18e949d367629|6df18e94]: Edit check-in comment. (artifact: 1f13d0ae user: drh) | |
| 20:16 | • Edit [d7bb79ed3a40419d|d7bb79ed]: Edit check-in comment. (artifact: dcc8c677 user: drh) | |
| 18:33 | • Edit [4120bc740a3ef068|4120bc74]: Mark "Closed". (artifact: 80a5c4d4 user: drh) | |
| 18:30 | Do not allow changes to sqlite3ExprIsTableConstant() that support pushdown of subqueries interfere with the hash-join logic. (check-in: 8682931f user: drh tags: pushdown-subquery) | |
| 17:42 | Merge testing logic fixes on trunk into the pushdown-subquery branch. (check-in: a4e1f03d user: drh tags: pushdown-subquery) | |
| 17:37 | Improvements to the accurancy of the fuzzinvariants.c testing module when SQLITE_ALLOW_ROWID_IN_VIEW is defined and the test query involves rowids. (check-in: c6e873d4 user: drh tags: trunk) | |
| 12:19 | Generalize pushdown to allow any uncorrelated subquery to be pushed down. (check-in: 87c45fb0 user: drh tags: pushdown-subquery) | |
| 11:59 | Generalize the pushdown of IN right-hand sides to cover more SELECTs. (Closed-Leaf check-in: 4120bc74 user: drh tags: pushdown-IN-table) | |
|
2024-04-05
| ||
| 20:01 | Experimental enhancement in which expressions of the form "expr IN table" can be pushed down into subexpressions. (check-in: 2cbd7838 user: drh tags: pushdown-IN-table) | |
| 15:04 | Merge all recent trunk enhancements into the reuse-schema branch. (Leaf check-in: e556f3d3 user: drh tags: reuse-schema) | |
| 14:54 | Merge the latest trunk enhancements into the bedrock branch. (check-in: 7a2a64b6 user: drh tags: bedrock) | |
| 14:50 | Merge the latest trunk enhancements into the wal2 branch. (check-in: a8a8a2db user: drh tags: wal2) | |
| 14:46 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: 4ff83342 user: drh tags: begin-concurrent) | |
| 14:13 | Check-in a9657c87c53c1922 is wrong: the IndexedExpr.bMaybeNullRow flag is required for virtual columns if they are part of an outer join. Add a test case to prove it. (check-in: 083b0f7e user: drh tags: branch-3.44) | |
| 14:06 | Fix obscure issues associated with SQLITE_ALLOW_ROWID_IN_VIEW and indexes on virtual columns in a RIGHT JOIN. (check-in: 4b3a253f user: drh tags: branch-3.45) | |
| 13:56 | Check-in [a9657c87c53c1922] is wrong: the IndexedExpr.bMaybeNullRow flag is required for virtual columns if they are part of an outer join. Add a test case (derived from dbsqlfuzz b9e65e2f110df998f1306571fae7af6c01e4d92b) to prove it. (check-in: 4484ec6d user: drh tags: trunk) | |
| 11:28 | When compiling with SQLITE_ALLOW_ROWID_IN_VIEW, if the RETURNING clause of an UPDATE of a view specifies a rowid, then return NULL for the value of that rowid. (check-in: d38cfa60 user: drh tags: branch-3.44) | |
| 11:23 | When compiling with SQLITE_ALLOW_ROWID_IN_VIEW, if the RETURNING clause of an UPDATE of a view specifies a rowid, then return NULL for the value of that rowid. dbsqlfuzz 7863696e9e5ec10b29bcf5ab2681cd6c82a78a4a. (check-in: c7896e88 user: drh tags: trunk) | |
|
2024-04-04
| ||
| 22:53 | Optimize sqlite3.oo1.DB.exec() for the rowMode='object' case to avoid converting the object property keys (column names) from native code to JS for each row. This speeds up large data sets considerably and addresses the report in forum post 3632183d2470617d. (check-in: 8b41ef86 user: stephan tags: trunk) | |
| 14:26 | Add the "interstage-heuristic" that attempts to avoid wildly inefficient queries that use table scans instead of index lookups because the output row estimates are inaccurate. (check-in: 7bf49e2c user: drh tags: trunk) | |
| 13:36 | Fix an ASAN problem in part of the test harness. No changes to SQLite itself. (check-in: 797cda7d user: drh tags: trunk) | |
| 13:07 | Fix test cases due to an error message change. (check-in: c49ec239 user: drh tags: trunk) | |
| 12:37 | Fix exception propagation when the opfs-sahpool VFS fails to initialize to address report in forum post be0141c639. (check-in: db31d178 user: stephan tags: branch-3.45) | |
| 12:36 | Fix exception propagation when the opfs-sahpool VFS fails to initialize to address report in forum post be0141c639. (check-in: cdb3a900 user: stephan tags: trunk) | |
|
2024-04-02
| ||
| 21:55 | Add an optional 3rd argument to the icu_load_collation() function that specifies the "strength" of the comparison. (check-in: acddbc48 user: drh tags: trunk) | |
| 18:48 | Fix typos in comments. Provided ".wheretrace" debugging output for the interstage heuristic module. Do omit automatic index loops in the interstage heuristic. (Leaf check-in: 357d9513 user: drh tags: branch-3.28) | |
| 18:31 | Fix table-valued functions so that they will work as the right table in a LEFT JOIN. Ticket [2ae0c599b735d59e] (check-in: 1f97086d user: drh tags: branch-3.28) | |
| 14:12 | Fix typos in comments. Provided ".wheretrace" debugging output for the interstage heuristic module. Do omit automatic index loops in the interstage heuristic. (Closed-Leaf check-in: 186dcae1 user: drh tags: interstage-heuristic) | |
| 11:54 | Add a heuristic in between the two solver() passes of the query planner that tries to prevent a very slow query plan in cases where the output row count estimate is imprecise. (check-in: 74b247d9 user: drh tags: branch-3.28) | |
| 11:44 | Add a heuristic in between the two solver() passes of the query planner that tries to prevent a very slow query plan in cases where the output row count estimate is imprecise. (check-in: 8018417b user: drh tags: interstage-heuristic) | |
|
2024-04-01
| ||
| 15:38 | Improved comments in the query planner logic that computes the cost for a particular step in a query plan. No code changes. (check-in: 0b2ac2cd user: drh tags: trunk) | |