]> git.ipfire.org Git - thirdparty/sqlite.git/commit
When flattening the right operand of a LEFT JOIN
authordrh <>
Thu, 2 Mar 2023 13:49:50 +0000 (13:49 +0000)
committerdrh <>
Thu, 2 Mar 2023 13:49:50 +0000 (13:49 +0000)
commit3f23ce664e84366c3e7c7fcf675c480e2d3988af
tree733e4e32c1c90f451026185292a439a573476513
parentc355f6c839f3df778eae3892a6bdd1b099566930
When flattening the right operand of a LEFT JOIN
(check-in [41c27bc0ff1d3135]), ensure that the OP_IfNullRow opcode does not
NULL-out a subquery result that was computed within OP_Once.  This fixes
the problem problem reported by
[forum:/forumpost/402f05296d|forum post 402f05296d].

FossilOrigin-Name: 8fe13f7a5e5eb798189acb25a608df7a94c2f5cc83463331a048b779c7890c82
manifest
manifest.uuid
src/expr.c
test/join2.test