Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/join2.test
|
2024-09-05
| ||
| 23:22 | [f59d63264f] part of check-in [22ca5a2ffb] Ensure that the WhereInfo.revMask bitmap is adjusted when tables are removed from the FROM clause by the Omit-Noop-Join optimization of [0cd82ee9a8413cf1]. Fix for the issue described by format post 8a1e467e905b8d27. (check-in: [22ca5a2ffb] user: drh branch: trunk, size: 12952) | |
|
2023-03-11
| ||
| 23:21 | [8561fe82ce] part of check-in [dc9f025dc4] The check-in at [198b3e33dcfd74c7] caused a performance regression for some queries, which is here fixed. Problem reported by forum post b405033490fa56d9. (check-in: [dc9f025dc4] user: drh branch: trunk, size: 12231) | |
|
2023-03-02
| ||
| 13:49 | [c378a2c59d] part of check-in [8fe13f7a5e] When flattening the right operand of a LEFT JOIN (check-in [41c27bc0ff1d3135]), ensure that the OP_IfNullRow opcode does not NULL-out a subquery result that was computed within OP_Once. This fixes the problem problem reported by forum post 402f05296d. (check-in: [8fe13f7a5e] user: drh branch: trunk, size: 11461) | |
|
2023-03-01
| ||
| 20:23 | [88f4527101] part of check-in [198b3e33dc] When flattening a view that is the right operand of a LEFT JOIN, using the optimization of check-in [41c27bc0ff1d3135], always insert the TK_IF_NULL_ROW expression nodes, even for TK_COLUMN expressions, as the TK_COLUMN might be a column from an outer query and hence still need to be NULLed out. This fixes the problem described by forum post 26387ea7ef. (check-in: [198b3e33dc] user: drh branch: trunk, size: 10857) | |
|
2022-04-16
| ||
| 23:38 | [466b072338] part of check-in [bd5fd68435] New test cases, one of which is failing, indicating a bug that needs fixing. (check-in: [bd5fd68435] user: drh branch: right-join, size: 9904) | |
|
2022-04-11
| ||
| 18:54 | [9751dac84a] part of check-in [bdd1499c0f] New test cases added. (check-in: [bdd1499c0f] user: drh branch: right-join, size: 9897) | |
| 14:26 | [bf5ce6bfce] part of check-in [d91faeffea] Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output. (check-in: [d91faeffea] user: drh branch: right-join, size: 9466) | |
|
2021-03-20
| ||
| 15:11 | [9bdc615841] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 9386) | |
|
2020-08-19
| ||
| 23:32 | [21fc30e54a] part of check-in [871f2ddcfb] Do not skip over TK_IF_NULL_ROW operators when bypassing TK_COLLATE operators. Fix to check-in [ac31edd3eeafcef4] which was itself a fix for ticket [45f4bf4eb4ffd788]. (check-in: [871f2ddcfb] user: drh branch: trunk, size: 9488) | |
|
2020-04-25
| ||
| 15:01 | [7d24d095ab] part of check-in [ac31edd3ee] Ensure affinity is not discarded from a view column if the view appears on the rhs of a LEFT JOIN. Fix for [45f4bf4e]. (check-in: [ac31edd3ee] user: dan branch: trunk, size: 8971) | |
|
2019-12-23
| ||
| 15:17 | [659bc6193f] part of check-in [2f17974912] Fix a case in which SQLite could fail to identify "x BETWEEN ? AND ?" being true as implying that x is not null. Ticket [dfd66334]. (check-in: [2f17974912] user: dan branch: trunk, size: 8275) | |
|
2018-05-02
| ||
| 18:00 | [10f7047e72] part of check-in [5f0e803e33] Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. (check-in: [5f0e803e33] user: drh branch: rework-EQP, size: 7989) | |
|
2018-03-27
| ||
| 15:13 | [f5ea0fd3b0] part of check-in [f08c1731b0] The push-down optimization was being too aggressive such that it sometimes generated incorrect results. Reinstate the restriction (4) (with qualifications) that was removed by check-ins [b5d3dd8cb0b1e4] and [dd568c27b1d765]. (check-in: [f08c1731b0] user: drh branch: trunk, size: 8022) | |
|
2018-03-20
| ||
| 21:16 | [2339e3a808] part of check-in [5b7abecc7a] If terms of the WHERE clause require that the right table in a LEFT JOIN not be a null row, then simplify the LEFT JOIN into an ordinary JOIN. (check-in: [5b7abecc7a] user: drh branch: join-strength-reduction, size: 7611) | |
|
2018-01-31
| ||
| 14:07 | [f1b5ba94ba] part of check-in [74d857d178] Fix a failing assert() in the new code on this branch. (check-in: [74d857d178] user: dan branch: omit-left-join-fix, size: 7599) | |
|
2018-01-29
| ||
| 17:08 | [96f56ccf0a] part of check-in [88411a402b] Update the omit-left-join optimization so that it works in some cases when the RHS is subject to a UNIQUE but not NOT NULL constraint. (check-in: [88411a402b] user: dan branch: omit-left-join-fix, size: 7317) | |
|
2017-11-23
| ||
| 04:45 | [1a0c263999] part of check-in [b016c28fa5] Fix a problem in the omit-table-from-left-join optimization from check-in [0cd82ee9a8413cf] that was discovered by OSSFuzz. (check-in: [b016c28fa5] user: drh branch: trunk, size: 5632) | |
|
2017-11-21
| ||
| 19:22 | [ac70b2b79a] part of check-in [618ca9fe53] Update the omit-table-from-left-join optimization so that it can omit tables from the middle of the join as well as the end. (check-in: [618ca9fe53] user: dan branch: left-join-optimization, size: 4932) | |
|
2017-11-20
| ||
| 15:45 | [770a9b6c9f] part of check-in [bff5dcfd2b] Fix a typo in a test script on this branch. (check-in: [bff5dcfd2b] user: dan branch: left-join-omit-fix, size: 3475) | |
| 14:40 | [8e3085b352] part of check-in [299d7ca52f] Fix a problem preventing the planner from identifying scans that visit at most one row in cases where that property is guaranteed by a unique, not-null, non-IPK column that is the leftmost in its table. (check-in: [299d7ca52f] user: dan branch: left-join-omit-fix, size: 3472) | |
|
2017-01-10
| ||
| 17:37 | [a48f723c56] part of check-in [e500c15a9f] Add a test case for ticket [25e335f802dd]. (check-in: [e500c15a9f] user: dan branch: trunk, size: 2425) | |
|
2005-01-21
| ||
| 03:12 | [f2171c265e] part of check-in [bb0254ab14] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab14] user: danielk1977 branch: trunk, size: 1827) | |
|
2004-01-24
| ||
| 20:18 | Added: [c97e4c5aa6] part of check-in [3626f6d4a1] Add the ability to group FROM terms using parentheses. Names of columns in a join no longer include the table name. (CVS 1197) (check-in: [3626f6d4a1] user: drh branch: trunk, size: 1784) | |