SQLite

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

10 check-ins using file src/btree.h version e823c46d87

2025-07-06
01:19
Improvements to the EXPLAIN QUERY PLAN output for EXISTS-to-JOIN. (Leaf check-in: 6b1ecbaa2e user: drh tags: empty-table-optimizations)
2025-07-05
23:33
Enhance the EXISTS-to-JOIN optimization so that it works on EXISTS subqueries that do not have a WHERE clause, and so that it works on nested EXISTS subqueries. (check-in: c1d5295724 user: drh tags: empty-table-optimizations)
2025-07-04
14:24
Merge fixes from trunk into the empty-table-optimizations branch (check-in: 6f98b16d21 user: drh tags: empty-table-optimizations)
11:06
Do not allow the EXISTS-to-JOIN optimization if the EXISTS clause is based on a view, since that view might expand into a join. (check-in: 872c41fedd user: drh tags: empty-table-optimizations)
10:26
Improve the early-termination optimization so that it works in queries which use the LIKE optimization in the outer loop. (check-in: b4e4d14824 user: drh tags: empty-table-optimizations)
2025-07-03
20:51
Merge the latest trunk fixes and enhancements into the empty-table-optimizations branch (check-in: d4f47e04f5 user: drh tags: empty-table-optimizations)
00:17
Minor tweaks to the exists-to-join optimization. (check-in: 9cb600ad57 user: drh tags: empty-table-optimizations)
2025-07-02
20:46
Merge in the exists-to-join optimization that has been modified to relax the requirement of having an indexed join constraint. (check-in: 1c1aef2b7f user: drh tags: empty-table-optimizations)
17:43
Fix VDBE coverage (check-in: ff593a16d6 user: drh tags: empty-table-optimizations)
14:53
Early exit if one of the inner loops of a 3-way or larger join is an empty table. (check-in: eaad6ac707 user: drh tags: empty-table-optimizations)