aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* | | | | | | | | Rework the fix to the problem described bydrh8 days
|\ \ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | [forum:/forumpost/b9647a113b465950|forum post b9647a113b] so that it provides a more complete fix that covers cases that were not resolved by the original fix, and so that it does not cause performance regressions. FossilOrigin-Name: 28db0d152d90fb5e62d03ea5caceabe8901be98522aef3dc2b54564fbc35355d
| * | | | | | | | | Simplifications to the row-value IN operator logic. Do not let the querydrh8 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | planner accept a WhereLoop for a row-value IN operator that uses the same index column more than once. FossilOrigin-Name: d2adf61f21a3ce901a2b08199ad0de191e88ef16e097c5f7a75c95ad958eff12
| * | | | | | | | | Back out the fix at [ba7d5bad32ad6aac] because it does not always work and ↵drh8 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | because it causes a performance regression. Add new test cases for row-value lookups of indexes that contain redundant columns, three of which are currently failing. This branch is seeking an improved solution to the redundant index column problem for row-value lookups. FossilOrigin-Name: ad8ddcefab5cc526b1cd77731e00939c672e61ca83350d28961b67635d20da03
* | | | | | | | | | Work around the Emscripten 4.10 regression described in ↵stephan8 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | [https://github.com/emscripten-core/emscripten/issues/24656 | Emscripten ticket #24656]. Problem reported off-list by BrickViking. FossilOrigin-Name: c385475b250f3364507a95c5832137098a9bb7c7fc12ab3bb116e1fad7bb7645
* | | | | | | | | | Avoid invoking the preupdate hook from within sqlite3_blob_write() if the ↵dan8 days
|/ / / / / / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | cursor is already invalid. FossilOrigin-Name: 9f335b9a4e9e761a0c6afd6dc69665a24506141bde88530bf59fcbdf957ae881
* | | | | | | | / Fix parser error introduced by [325e547a2195571e]. Seedrh8 days
| |_|_|_|_|_|_|/ |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | [forum:/forumpost/095dbfc06e5b1f7e|forum post 095dbfc06e5]. FossilOrigin-Name: 4eefab44941fc6e17742fa49c8734e7f00a2177d82bc572e596228add53aad39
* | | | | | | | Add 'reconfigure' target to Makefile.in to re-run the configure script with ↵stephan11 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | the same flags it was generated with. FossilOrigin-Name: c60907e77b32824aaaf024d299cdaf161b5f64fc927ffe5d5455eeb5754e6b01
* | | | | | | | Propagate the -ldl and -lpthread flags, if needed, into sqlite3.pc, per ↵stephan11 days
| |_|_|_|_|_|/ |/| | | | | | | | | | | | | | | | | | | | | | | | | | | request in [forum:44a58c807353162f | forum post 44a58c807353162f]. FossilOrigin-Name: 64f5f14322349b47451b8cac03bf8cd6f1ae45a8822e7f1ddee3d0b265047501
* | | | | | | Fix harmless compiler warnings.drh11 days
| | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 13af4acebe09b047756c22b800136cffaba532e7fcaa448a4edf4fedb94e9bbc
* | | | | | | Remove an ALWAYS() added by [960a8e6fc91f4] that turns out to be falsedrh11 days
| |_|_|_|_|/ |/| | | | | | | | | | | | | | | | | | | | | | | in some cases of malformed SQL. FossilOrigin-Name: cc8171461bf35f584888a24b844c8b79ad30155b19b61161e9f3abc276e8aae5
* | | | | | Fix a few cases where LIMIT clauses that were part of scalar sub-queries on ↵dan12 days
|\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | virtual tables were not being passed to xBestIndex methods correctly. FossilOrigin-Name: 960a8e6fc91f47add3a089dc6cef013109deadf809994c5149ad3bdfb3884de0
| * | | | | | Improvements to sqlite3_vtab_rhs_value() logging in thedrh12 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ext/misc/vtablog.c extension. FossilOrigin-Name: 25131ee84f53dab1191e02c19cefd256aed2828c7edea325fcc0ba3b0a668583
| * | | | | | Make the value of an explicit LIMIT clause on a scalar sub-query available ↵dan12 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 ↵dan12 days
|/ / / / / / | | | | | | | | | | | | | | | | | | | | | | | | more efficient. FossilOrigin-Name: 7214cb2a5b35190a06a1040cd4c54f325d347f8d8e36a07fd76c0a421e266522
* | | | | | Enhancements to the xBestIndex output from the ext/misc/vtablog.cdrh12 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | extension. FossilOrigin-Name: 8b31acc0b18f38eb4af6efebd1ea25cd65a146651101579aee20afd9ec6dc2de
* | | | | | Fix an uninitialized variable added yesterday by [d27d34fb746280e7].drh12 days
|/ / / / / | | | | | | | | | | | | | | | | | | | | | | | | | 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 determinesdrh13 days
|\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | that no output is possible. FossilOrigin-Name: 2d2b61cba44a756a3a41ef5c95bbb0c0b7111f4b679c578fec9bd0b214cca367
| * \ \ \ \ Merge trunk fixes into the empty-table-optimizations branch.drh14 days
| |\ \ \ \ \ | | | | | | | | | | | | | | FossilOrigin-Name: 63306e447efb3ac17e789a331ed3bb65459eb8b79d66e9c185ba3bd852f34ce3
| * | | | | | More aggressive optimization of addrHalt for RIGHT JOIN.drh2025-06-30
| | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 5e51d1c0dfcafef9e71c99de3f626dee157c935724b84c6e0c630299a880446f
| * | | | | | Compute WhereLevel.addrBrk and .addrHalt early so that those labels can bedrh2025-06-30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 whendrh13 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | query flattening. FossilOrigin-Name: d27d34fb746280e7e81335db4e195914b15403ef0da7b2955550553dd78fbe9a
* | | | | | | Improved comments on bytecode used to implement aggregate queries, to aiddrh13 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | in debugging. FossilOrigin-Name: a1a8b85cdba64a17dcdcd4e6b42b872957cec2dc05b0ac34dfcd82f59344034b
* | | | | | | Improved byte-code comments for the short-circuit optimization ofdrh14 days
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | [0083d5169a46104a], to aid in debugging. FossilOrigin-Name: 113f9d10e347eeaa893ff8b47a461009e0b12589374b93cf3e0bddd19c702dea
* | | | | | | Cache and reuse virtual table cursors in the bytecode engine.drh14 days
| | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 2d187d4232d750cb1840f1d89c8aed65962cb0883c1d7f91c554b451e475c514
* | | | | | | Avoid an assert() failure in fts5 that may occur when processing corrupt ↵dan14 days
| |/ / / / / |/| | | | | | | | | | | | | | | | | | | | | | | records. FossilOrigin-Name: 8afd6ca85724a69970181042d6aac53742ea2b76ded5966b2541c3afe1121fb9
* | | | | | When attempting to optimize "expr AND false" to "false" anddrh14 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 adrh2025-06-30
|\ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 thedrh2025-06-30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | other operand is NULL. FossilOrigin-Name: d86eb16283c4b573c506d4faa422d5d9aeb6abc279d8e6a8e2104737162d417f
| * | | | | Slightly smaller and faster version of the previous check-in.drh2025-06-30
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: f6e6fd02f4ad49c390a2d3c9626d57f9b2fff1f67eb361b30074cc1f5121810e
| * | | | | Factor out the code that tries to avoid evaluating subquery operands if thedrh2025-06-30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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 isdrh2025-06-28
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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.stephan2025-06-30
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: b48d95191662e09659b5b55ae65cd462c9e1700c4f92dd9d40b59548f0797c02
* | | | | | Minor API doc typo fixes from brickviking.stephan2025-06-29
|/ / / / / | | | | | | | | | | FossilOrigin-Name: c7cf9dcb69ce558ba6b81b2787f92ed7383e37f08b199faeb14f7adb4e494532
* | | | | Raise an error right away if the number of aggregate terms in a querydrh2025-06-27
| | | | | | | | | | | | | | | | | | | | | | | | | exceeds the maximum number of columns. FossilOrigin-Name: 5508b56fd24016c13981ec280ecdd833007c9d8dd595edb295b984c2b487b5c8
* | | | | API doc typo fixes and closing DD element tags from brickviking.stephan2025-06-27
| | | | | | | | | | | | | | | FossilOrigin-Name: c9ddd15b0197e6e5c5a74581d94cf986523514ffdb28c66ba18de9a22aec97e9
* | | | | Work around an apparent GCC UBSAN bug. Seedrh2025-06-26
| | | | | | | | | | | | | | | | | | | | | | | | | [forum:/forumpost/1d7c25d4a2d6f5e2|forum thread 1d7c25d4a2d] for details. FossilOrigin-Name: 23056532e51abcff486e38a3319545e6663b4a855abe1bc443e2cd7e0473748c
* | | | | Minor API doc fixes sent off-list from brickviking.stephan2025-06-25
| | | | | | | | | | | | | | | FossilOrigin-Name: cb4d05633a0c9cdf146f3108e1b4b10754cd79d72a425d8cc9cd21836037a01b
* | | | | Similar fix to the previous check-in, but this time fordrh2025-06-24
| | | | | | | | | | | | | | | | | | | | | | | | | sqlite3_preupdate_new(). FossilOrigin-Name: 9aaff764d508cbd9823f23cdf0c510255721bc5c09be481ebc60bd8902ceb8c5
* | | | | Range check the column index on the sqlite3_preupdate_old() interfacedrh2025-06-24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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.stephan2025-06-24
| | | | | | | | | | | | | | | FossilOrigin-Name: 85e8060c4701a601d4bc8a639acd268ee4f2736193820d55ecd9b8abf864132f
* | | | | Improve some of the error messages emitted by fts5 when it encounters ↵dan2025-06-23
| | | | | | | | | | | | | | | | | | | | | | | | | corruption. FossilOrigin-Name: 48044a6b57c0a16cb75139c103ad88ca4ab64d74f70a3dee0d8b817fbfbec3c6
* | | | | Fix an SQL typo introduced by the previous check-in.drh2025-06-23
| | | | | | | | | | | | | | | FossilOrigin-Name: 72a81d247bc74a21d077d311969ac585d0f26bffbd210ec60f03c38bf138790e
* | | | | Escape the "_" character in LIKE patterns in the CLI.drh2025-06-23
| | | | | | | | | | | | | | | | | | | | | | | | | [forum:/forumpost/6a89702f5d|Forum post 6a89702f5d]. FossilOrigin-Name: cf61cd359e666c66b6bba4407a653c799f7f07e1f5ee6b837ad467029c461a6a
* | | | | Fix a harmless compiler warning injected by [c978aed3b6f82b3d].drh2025-06-23
| | | | | | | | | | | | | | | FossilOrigin-Name: f46500247b3a2f8b4a2f0f032cc4066af9cb3918e38a09c59db0a1da5747a25c
* | | | | Improved "statement aborts at ..." log-file messages that identify thedrh2025-06-23
| | | | | | | | | | | | | | | | | | | | | | | | | trigger that caused the abort. FossilOrigin-Name: 7691264fe37300c880d612c91cf093327841fbe85fb7ec67e777e911d2cfc9ee
* | | | | Add the --disable-rpath configure script flag to address ↵stephan2025-06-22
| | | | | | | | | | | | | | | | | | | | | | | | | [forum:13cac3b56516f849 | forum post 13cac3b56516f849]. FossilOrigin-Name: a59d9bb25e518f5d79f654615b92f6c50cfb704b5abee0f820912644b89366c5
* | | | | API doc typo fixes from brickviking.stephan2025-06-22
| | | | | | | | | | | | | | | FossilOrigin-Name: 18e07f8f53693d0dace3c4025a572c1a10582290a338aa7f0913c83842a69b05
* | | | | Minor JS test cleanups prompted by a linter.stephan2025-06-21
| | | | | | | | | | | | | | | FossilOrigin-Name: 764235a3d15fda55af85ebe3b5885fa27336cc0e979f1be2f6770b66a84bbe87
* | | | | Remove some duplicated JS tests.stephan2025-06-21
| | | | | | | | | | | | | | | FossilOrigin-Name: d1cb9ed79d806f667c22f5ba9861451d4d0765aa3072e085831045cf3a39f8b4
* | | | | Reduce the maximum --size flag for JS kvvfs speedtest1 from 4 to 2, as ↵stephan2025-06-21
| | | | | | | | | | | | | | | | | | | | | | | | | --size 3 and 4 are overflowing the kvvfs storage limits. FossilOrigin-Name: b77b3adc828ce543e880e230701edd5e0ccb681e4c3c724ea8ad5ecbd69c73a6
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-15 09:22:16 +0000