/ File History
Login

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

History of test/join2.test

2018-05-02
18:00
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. file: [10f7047e] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 7989
2018-03-27
15:13
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]. file: [f5ea0fd3] check-in: [f08c1731] user: drh branch: trunk, size: 8022
2018-03-20
21:16
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. file: [2339e3a8] check-in: [5b7abecc] user: drh branch: join-strength-reduction, size: 7611
2018-01-31
14:07
Fix a failing assert() in the new code on this branch. file: [f1b5ba94] check-in: [74d857d1] user: dan branch: omit-left-join-fix, size: 7599
2018-01-29
17:08
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. file: [96f56ccf] check-in: [88411a40] user: dan branch: omit-left-join-fix, size: 7317
2017-11-23
04:45
Fix a problem in the omit-table-from-left-join optimization from check-in [0cd82ee9a8413cf] that was discovered by OSSFuzz. file: [1a0c2639] check-in: [b016c28f] user: drh branch: trunk, size: 5632
2017-11-21
19:22
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. file: [ac70b2b7] check-in: [618ca9fe] user: dan branch: left-join-optimization, size: 4932
2017-11-20
15:45
Fix a typo in a test script on this branch. file: [770a9b6c] check-in: [bff5dcfd] user: dan branch: left-join-omit-fix, size: 3475
14:40
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. file: [8e3085b3] check-in: [299d7ca5] user: dan branch: left-join-omit-fix, size: 3472
2017-01-10
17:37
Add a test case for ticket [25e335f802dd]. file: [a48f723c] check-in: [e500c15a] user: dan branch: trunk, size: 2425
2005-01-21
03:12
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [f2171c26] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 1827
2004-01-24
20:18
Add the ability to group FROM terms using parentheses. Names of columns in a join no longer include the table name. (CVS 1197) file: [c97e4c5a] check-in: [3626f6d4] user: drh branch: trunk, size: 1784 Added