/ Check-in [08833dda]
Login

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

Overview
Comment:Do a more thorough job of cleaning traces of the strength-reduced LEFT JOIN.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | join-strength-reduction
Files: files | file ages | folders
SHA3-256: 08833dda3a25965cc509d0244d7cd68bdb2306351ca52862f347e1efe5db4508
User & Date: drh 2018-03-20 22:52:27
Original Comment: Do a more thorough job of cleaning erasing traces of the strength-reduced LEFT JOIN.
Context
2018-03-21
01:59
Relax LEFT-JOIN restrictions on the push-down optimization. Closed-Leaf check-in: b5d3dd8c user: drh tags: join-strength-reduction
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
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/select.c.

Changes to test/cursorhint2.test.