aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Fix harmless compiler warnings.HEADmasterdrh4 hours
| | | FossilOrigin-Name: 13af4acebe09b047756c22b800136cffaba532e7fcaa448a4edf4fedb94e9bbc
* Remove an ALWAYS() added by [960a8e6fc91f4] that turns out to be falsedrh5 hours
| | | | | in some cases of malformed SQL. FossilOrigin-Name: cc8171461bf35f584888a24b844c8b79ad30155b19b61161e9f3abc276e8aae5
* Fix a few cases where LIMIT clauses that were part of scalar sub-queries on ↵dan24 hours
|\ | | | | | | | | virtual tables were not being passed to xBestIndex methods correctly. FossilOrigin-Name: 960a8e6fc91f47add3a089dc6cef013109deadf809994c5149ad3bdfb3884de0
| * Improvements to sqlite3_vtab_rhs_value() logging in thedrh25 hours
| | | | | | | | | | ext/misc/vtablog.c extension. FossilOrigin-Name: 25131ee84f53dab1191e02c19cefd256aed2828c7edea325fcc0ba3b0a668583
| * Make the value of an explicit LIMIT clause on a scalar sub-query available ↵dan25 hours
| | | | | | | | | | to xBestIndex for simple "LIMIT 0" and "LIMIT 1" queries. FossilOrigin-Name: 33b6a63caafccc61b3193714911cd8b5dd9b7f1798054b8c7845b23688d531f2
| * Make handling of LIMIT clauses in correlated sub-queries on virtual tables ↵dan26 hours
|/ | | | | more efficient. FossilOrigin-Name: 7214cb2a5b35190a06a1040cd4c54f325d347f8d8e36a07fd76c0a421e266522
* Enhancements to the xBestIndex output from the ext/misc/vtablog.cdrh26 hours
| | | | | extension. FossilOrigin-Name: 8b31acc0b18f38eb4af6efebd1ea25cd65a146651101579aee20afd9ec6dc2de
* Fix an uninitialized variable added yesterday by [d27d34fb746280e7].drh28 hours
| | | | | | This problem was discovered overnight by [https://github.com/google/oss-fuzz|OSSFuzz]. FossilOrigin-Name: 6db4703f1178fc808f3a75c355fb6638fb12c88f6e1ce7f579e200ced8089114
* Improve the bytecode for joins such that it exits earlier if it determinesdrh2 days
|\ | | | | | | | | that no output is possible. FossilOrigin-Name: 2d2b61cba44a756a3a41ef5c95bbb0c0b7111f4b679c578fec9bd0b214cca367
| * Merge trunk fixes into the empty-table-optimizations branch.drh3 days
| |\ | | | | | | FossilOrigin-Name: 63306e447efb3ac17e789a331ed3bb65459eb8b79d66e9c185ba3bd852f34ce3
| * | More aggressive optimization of addrHalt for RIGHT JOIN.drh4 days
| | | | | | | | | FossilOrigin-Name: 5e51d1c0dfcafef9e71c99de3f626dee157c935724b84c6e0c630299a880446f
| * | Compute WhereLevel.addrBrk and .addrHalt early so that those labels can bedrh4 days
| | | | | | | | | | | | | | | | | | used to abort loops early. Use this to improve performance on two more of the cases described by [forum:/forumpost/52651713ac|forum post 52651713ac]. FossilOrigin-Name: 6fc0b9ac23be6840542982de4bb282ebca1db8b5ab3baefdde95a997c1506e81
* | | Ensure that Expr.op2 values for TK_AGG_FUNCTION nodes are adjusted whendrh3 days
| | | | | | | | | | | | | | | query flattening. FossilOrigin-Name: d27d34fb746280e7e81335db4e195914b15403ef0da7b2955550553dd78fbe9a
* | | Improved comments on bytecode used to implement aggregate queries, to aiddrh3 days
| | | | | | | | | | | | | | | in debugging. FossilOrigin-Name: a1a8b85cdba64a17dcdcd4e6b42b872957cec2dc05b0ac34dfcd82f59344034b
* | | Improved byte-code comments for the short-circuit optimization ofdrh3 days
| | | | | | | | | | | | | | | [0083d5169a46104a], to aid in debugging. FossilOrigin-Name: 113f9d10e347eeaa893ff8b47a461009e0b12589374b93cf3e0bddd19c702dea
* | | Cache and reuse virtual table cursors in the bytecode engine.drh3 days
| | | | | | | | | FossilOrigin-Name: 2d187d4232d750cb1840f1d89c8aed65962cb0883c1d7f91c554b451e475c514
* | | Avoid an assert() failure in fts5 that may occur when processing corrupt ↵dan3 days
| |/ |/| | | | | | | records. FossilOrigin-Name: 8afd6ca85724a69970181042d6aac53742ea2b76ded5966b2541c3afe1121fb9
* | When attempting to optimize "expr AND false" to "false" anddrh3 days
|/ | | | | | | "expr IN ()" to "false", take care not to delete aggregate functions in the "expr" as doing so can change the meaning of the query. See [forum:/forumpost/f4878de3e7dd4764|forum thread f4878de3e7]. FossilOrigin-Name: 77397bd67d918db57d5ac545d6d963194806fdabcdaa8f822b6b09e4cfe8b715
* Strive to skip the evaluation of scalar subqueries that are part of adrh4 days
|\ | | | | | | | | | | larger expression if the result from the scalar subquery does not change the result of the overall expression. FossilOrigin-Name: 0083d5169a46104a25355bdd9d5a2f4027b049191ebda571dd228477ec217296
| * For all binary operators, try to avoid computing subquery operands if thedrh4 days
| | | | | | | | | | other operand is NULL. FossilOrigin-Name: d86eb16283c4b573c506d4faa422d5d9aeb6abc279d8e6a8e2104737162d417f
| * Slightly smaller and faster version of the previous check-in.drh4 days
| | | | | | FossilOrigin-Name: f6e6fd02f4ad49c390a2d3c9626d57f9b2fff1f67eb361b30074cc1f5121810e
| * Factor out the code that tries to avoid evaluating subquery operands if thedrh4 days
| | | | | | | | | | | | other operand is NULL into a subroutine, so that it can be more easily reused by other parts of the code generator. FossilOrigin-Name: 3c6c71bcea16443b82234414137dfa1b59e2ee8fe5097906c738fc1228fec4e6
| * Improve the bytecode generated for comparisons so that if one operand isdrh6 days
| | | | | | | | | | | | | | a subquery and the other operand evaluates to NULL, the subquery operand is not even computed. This fixes 5 of the 12 slow queries described in [forum:/forumpost/52651713ac|forum post 52651713ac]. FossilOrigin-Name: f147bc04776ac0056412f69dfc518016c0d5b4e9d964664e3d88f595fb29dbe0
* | Minor API doc typo fixes from brickviking.stephan4 days
| | | | | | FossilOrigin-Name: b48d95191662e09659b5b55ae65cd462c9e1700c4f92dd9d40b59548f0797c02
* | Minor API doc typo fixes from brickviking.stephan5 days
|/ | | FossilOrigin-Name: c7cf9dcb69ce558ba6b81b2787f92ed7383e37f08b199faeb14f7adb4e494532
* Raise an error right away if the number of aggregate terms in a querydrh7 days
| | | | | exceeds the maximum number of columns. FossilOrigin-Name: 5508b56fd24016c13981ec280ecdd833007c9d8dd595edb295b984c2b487b5c8
* API doc typo fixes and closing DD element tags from brickviking.stephan7 days
| | | FossilOrigin-Name: c9ddd15b0197e6e5c5a74581d94cf986523514ffdb28c66ba18de9a22aec97e9
* Work around an apparent GCC UBSAN bug. Seedrh8 days
| | | | | [forum:/forumpost/1d7c25d4a2d6f5e2|forum thread 1d7c25d4a2d] for details. FossilOrigin-Name: 23056532e51abcff486e38a3319545e6663b4a855abe1bc443e2cd7e0473748c
* Minor API doc fixes sent off-list from brickviking.stephan9 days
| | | FossilOrigin-Name: cb4d05633a0c9cdf146f3108e1b4b10754cd79d72a425d8cc9cd21836037a01b
* Similar fix to the previous check-in, but this time fordrh10 days
| | | | | sqlite3_preupdate_new(). FossilOrigin-Name: 9aaff764d508cbd9823f23cdf0c510255721bc5c09be481ebc60bd8902ceb8c5
* Range check the column index on the sqlite3_preupdate_old() interfacedrh10 days
| | | | | | and return SQLITE_MISUSE if too large. [forum:/forumpost/b617e497287235d0|Forum post b617e49728]. FossilOrigin-Name: 6a5701e6c7be25cba93e55438f950966e1dacb32eb2b23a8acc8ac53da6f0a85
* API doc typo fixes and one rephrasing improvement from brickviking.stephan10 days
| | | FossilOrigin-Name: 85e8060c4701a601d4bc8a639acd268ee4f2736193820d55ecd9b8abf864132f
* Improve some of the error messages emitted by fts5 when it encounters ↵dan11 days
| | | | | corruption. FossilOrigin-Name: 48044a6b57c0a16cb75139c103ad88ca4ab64d74f70a3dee0d8b817fbfbec3c6
* Fix an SQL typo introduced by the previous check-in.drh11 days
| | | FossilOrigin-Name: 72a81d247bc74a21d077d311969ac585d0f26bffbd210ec60f03c38bf138790e
* Escape the "_" character in LIKE patterns in the CLI.drh11 days
| | | | | [forum:/forumpost/6a89702f5d|Forum post 6a89702f5d]. FossilOrigin-Name: cf61cd359e666c66b6bba4407a653c799f7f07e1f5ee6b837ad467029c461a6a
* Fix a harmless compiler warning injected by [c978aed3b6f82b3d].drh11 days
| | | FossilOrigin-Name: f46500247b3a2f8b4a2f0f032cc4066af9cb3918e38a09c59db0a1da5747a25c
* Improved "statement aborts at ..." log-file messages that identify thedrh11 days
| | | | | trigger that caused the abort. FossilOrigin-Name: 7691264fe37300c880d612c91cf093327841fbe85fb7ec67e777e911d2cfc9ee
* Add the --disable-rpath configure script flag to address ↵stephan12 days
| | | | | [forum:13cac3b56516f849 | forum post 13cac3b56516f849]. FossilOrigin-Name: a59d9bb25e518f5d79f654615b92f6c50cfb704b5abee0f820912644b89366c5
* API doc typo fixes from brickviking.stephan12 days
| | | FossilOrigin-Name: 18e07f8f53693d0dace3c4025a572c1a10582290a338aa7f0913c83842a69b05
* Minor JS test cleanups prompted by a linter.stephan13 days
| | | FossilOrigin-Name: 764235a3d15fda55af85ebe3b5885fa27336cc0e979f1be2f6770b66a84bbe87
* Remove some duplicated JS tests.stephan13 days
| | | FossilOrigin-Name: d1cb9ed79d806f667c22f5ba9861451d4d0765aa3072e085831045cf3a39f8b4
* Reduce the maximum --size flag for JS kvvfs speedtest1 from 4 to 2, as ↵stephan13 days
| | | | | --size 3 and 4 are overflowing the kvvfs storage limits. FossilOrigin-Name: b77b3adc828ce543e880e230701edd5e0ccb681e4c3c724ea8ad5ecbd69c73a6
* Give oo1.Stmt.get() similar treatment to [8c187140a60b]. This is an internal ↵stephan13 days
| | | | | change only - the API is unaffected. FossilOrigin-Name: f5a7abc0a447273de40dacc463d267d26d4b62be56ee15baf05825791c2a7a6e
* Extend the SEE-via-kvvfs tests to include all three key types.stephan13 days
| | | FossilOrigin-Name: fc001aa5ee978795c2ff670bea64db0b69b6bde98653769d9cede8825a28e698
* Rework how JS's oo1.DB.exec() flags its Stmt objects to make certain Stmt ↵stephan13 days
| | | | | APIs illegal (i.e. throwing) if called while that Stmt is being step()ped by DB.exec() (which can happen via client-provided per-result-row callbacks). This is an internal change only - the API is unaffected. Remove some unrelated dead code. FossilOrigin-Name: 8c187140a60b62dc3b6066b8615766d52b7a29a5de992cbb6d312dbb225a980b
* Numerous small doc typo from BrickViking.stephan13 days
| | | FossilOrigin-Name: 3aab4415de615c178205936372c625bb571bad1016c3d2e7bb2a45932356f3d6
* Enhance sqlite3BtreeSetPageSize() so that it detects early if no changesdrh2025-06-20
| | | | | are needed and exists with SQLITE_OK. FossilOrigin-Name: c978aed3b6f82b3d9d2e0ca0283c611351bca5e5496e86a9d5d0731ebcd27c84
* Fix an out-of-order local variable declaration in ext/misc/fileio.c.drh2025-06-19
| | | FossilOrigin-Name: a88bb75288a06492a04ab1278e8a2101a74f4ba712d328b4c73e86ac01cb946d
* Improve the accuracy of sqlite3BtreeRowCountEst().drh2025-06-19
| | | FossilOrigin-Name: e553fb538ec1527457e2927edf9127dccf268a8a3b5918d4fb0d066ad9676094
* Generalize the indexCellCompare() so that works on any index page, not justdrh2025-06-19
| | | | | the current page that a cursor is pointing to. FossilOrigin-Name: b305a7f5db183d8e0e5d62ca3c9c6260ad94bb954f7342bd3caabcd8308a21f5
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-04 16:22:10 +0000