aboutsummaryrefslogtreecommitdiff
path: root/test/join2.test
Commit message (Expand)AuthorAge
* Ensure that the WhereInfo.revMask bitmap is adjusted when tables are removeddrh2024-09-05
* The check-in at [198b3e33dcfd74c7] caused a performance regression for somedrh2023-03-11
* When flattening the right operand of a LEFT JOINdrh2023-03-02
* When flattening a view that is the right operand of a LEFT JOIN, usingdrh2023-03-01
* New test cases, one of which is failing, indicating a bug that needs fixing.drh2022-04-16
* New test cases added.drh2022-04-11
* Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output.drh2022-04-11
* Revise tests cases to align with the new EXPLAIN QUERY PLAN output.drh2021-03-20
* Do not skip over TK_IF_NULL_ROW operators when bypassing TK_COLLATE operators.drh2020-08-19
* Ensure affinity is not discarded from a view column if the view appears on th...dan2020-04-25
* Fix a case in which SQLite could fail to identify "x BETWEEN ? AND ?" being t...dan2019-12-23
* Fix test cases so that they work with the new EXPLAIN QUERY PLAN outputdrh2018-05-02
* The push-down optimization was being too aggressive such that it sometimesdrh2018-03-27
* If terms of the WHERE clause require that the right table in a LEFT JOINdrh2018-03-20
* Fix a failing assert() in the new code on this branch.dan2018-01-31
* Update the omit-left-join optimization so that it works in some cases when thedan2018-01-29
* Fix a problem in the omit-table-from-left-join optimization drh2017-11-23
* Update the omit-table-from-left-join optimization so that it can omit tablesdan2017-11-21
* Fix a typo in a test script on this branch.dan2017-11-20
* Fix a problem preventing the planner from identifying scans that visit at mostdan2017-11-20
* Add a test case for ticket [25e335f802dd].dan2017-01-10
* Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT ...danielk19772005-01-21
* Add the ability to group FROM terms using parentheses. Names of columns indrh2004-01-24