I Use This!
Very High Activity

Commits : Listings

Analyzed 1 day ago. based on code collected 1 day ago.
Mar 19, 2024 — Apr 18, 2024
Commit Message Contributor Files Modified Lines Added Lines Removed Code Location Date
The first assert() added in [0ebc65481f4a3e79] is not necessarily true in a corrupt database file. So add a term to make it true. More... 4 days ago
If a build fails in testrunner.tcl, do not attempt to run the jobs that depend on that build. Instead, report those jobs as having been skipped. More... 7 days ago
Fixes and new tests logic to ensure that the btree overflow page cache is only used when it is consistent. This resolves the malfunction observed in [forum:/forumpost/284955a3cd454a15|forum post 284955a3cd454a15]. More... 8 days ago
Add assert() statements to help verify the overflow page cache. More... 8 days ago
New assert() statements to verify the correctness of the BTCF_AtLast flag on btree cursors. More... 8 days ago
Test case for the fix in the previous check-in. More... 8 days ago
Mark the BTree cell overflow cache as invalid whenever the rowid goes invalid. More... 8 days ago
Fix handling of the SQLITE_OMIT_WAL check in one place. Resolves [forum:87cc13302de160eb|forum post 87cc13302de160eb]. More... 8 days ago
Fix a "shift exponent is too large" usan error that could occur in the fts3 snippet() function when a query phrase contains more than 64 tokens. More... 10 days ago
Avoid some performance problems in the recover extension when recovering strategically corrupted databases. More... 11 days ago
The read-only CHECK-constraint optimization of [34ddf02d3d21151b] inhibits the xfer optimization for tables with CHECK constraints. However, the xfer optimization is required for correct operation of VACUUM INTO on tables that contain generated columns. Fix this by ignoring CHECK constraints when qualifying the xfer optimization while running VACUUM. Problem reported by [forum:/forumpost/3ec177d68fe7fa2c|forum post 3ec177d68fe7fa2c]. More... 11 days ago
Update tests in returning1.test to account for [c7896e88]. More... 11 days ago
Enhance the WHERE-clause push-down optimization so that it is able to push down WHERE clause terms that contain uncorrelated subqueries. More... 12 days ago
Fix a harmless compiler warning in the ICU extension due to [acddbc489d5231da]. More... 12 days ago
Enhancements to the fuzzer invariant checker to turn optimizations on and off. More... 12 days ago
Merge trunk testing enhancements into the pushdown-subquery branch. More... 12 days ago
Omit all rowid-in-view restrictions from the fuzzinvariant.c test module as they are no longer necessary, as of the previous check-in. More... 12 days ago
If SQLITE_ALLOW_ROWID_IN_VIEW is set to 2, then all rowids for views return a value of NULL. More... 12 days ago
Merge trunk enhancements into the pushdown-subquery branch. More... 13 days ago
Add comments to note the name abiguity between the MySQL push-down optimization and the WHERE-clause push-down optimization. More... 13 days ago
Do not allow changes to sqlite3ExprIsTableConstant() that support pushdown of subqueries interfere with the hash-join logic. More... 13 days ago
Merge testing logic fixes on trunk into the pushdown-subquery branch. More... 13 days ago
Improvements to the accurancy of the fuzzinvariants.c testing module when SQLITE_ALLOW_ROWID_IN_VIEW is defined and the test query involves rowids. More... 13 days ago
Generalize pushdown to allow any uncorrelated subquery to be pushed down. More... 14 days ago
Experimental enhancement in which expressions of the form "expr IN table" can be pushed down into subexpressions. More... 14 days ago
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. More... 15 days ago
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. More... 15 days ago
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. More... 15 days ago
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. More... 15 days ago
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:3632183d2470617d|forum post 3632183d2470617d]. More... 15 days ago