SQLite

Check-in [08833dda3a]
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
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.787
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: b5d3dd8cb0 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: 08833dda3a 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: 5b7abecc7a user: drh tags: join-strength-reduction)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/select.c.
Changes to test/cursorhint2.test.