]> git.ipfire.org Git - thirdparty/sqlite.git/commit
Continue to back away from the LEFT JOIN optimization of check-in [41c27bc0ff1d3135]
authordrh <drh@noemail.net>
Wed, 18 Dec 2019 20:51:58 +0000 (20:51 +0000)
committerdrh <drh@noemail.net>
Wed, 18 Dec 2019 20:51:58 +0000 (20:51 +0000)
commit396afe6f6aa90a31303c183e11b2b2d4b7956b35
tree616244fdd680e0c166a3ca19a4e997b188a51586
parent6e1c45ef2ee3aaea9e1f89e1cfa036c0f112e92c
Continue to back away from the LEFT JOIN optimization of check-in [41c27bc0ff1d3135]
by disallowing query flattening if the outer query is DISTINCT.  Without this fix,
if an index scan is run on the table within the view on the right-hand side of the
LEFT JOIN, stale result registers might be accessed yielding incorrect results,
and/or an OP_IfNullRow opcode might be invoked on the un-opened table, resulting
in a NULL-pointer dereference.  This problem was found by the Yongheng and Rui fuzzer.

FossilOrigin-Name: 862974312edf00e9d1068115d1a39b7235b7db68b6d86b81d38a12f025a4748e
manifest
manifest.uuid
src/select.c
test/join.test