]> git.ipfire.org Git - thirdparty/sqlite.git/commit
If terms of the WHERE clause require that the right table in a LEFT JOIN
authordrh <drh@noemail.net>
Tue, 20 Mar 2018 21:16:15 +0000 (21:16 +0000)
committerdrh <drh@noemail.net>
Tue, 20 Mar 2018 21:16:15 +0000 (21:16 +0000)
commit2589787c5a89a5337a80bd2b526a8c67bea854d7
tree6d4294098c591f411fdf94404e164d4ffdea2e61
parentf6e6f023083a4d4d221d152439074b4ed74a077c
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.

FossilOrigin-Name: 5b7abecc7ab8ccbbb8cb5e0f672e67625c2555ad03442efbf34cb395f5bb71a8
manifest
manifest.uuid
src/expr.c
src/select.c
src/sqliteInt.h
test/e_select.test
test/join2.test