/ Check-in [5b7abecc]
Login

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

Overview
Comment: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.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | join-strength-reduction
Files: files | file ages | folders
SHA3-256: 5b7abecc7ab8ccbbb8cb5e0f672e67625c2555ad03442efbf34cb395f5bb71a8
User & Date: drh 2018-03-20 21:16:15
Context
2018-03-20
22:52
Do a more thorough job of cleaning traces of the strength-reduced LEFT JOIN. check-in: 08833dda user: drh tags: join-strength-reduction
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. check-in: 5b7abecc user: drh tags: join-strength-reduction
19:02
Fix incorrect testcase labels on two cases in join5.test. No changes to code. check-in: 4661ac81 user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/expr.c.

Changes to src/select.c.

Changes to src/sqliteInt.h.

Changes to test/e_select.test.

Changes to test/join2.test.