]> git.ipfire.org Git - thirdparty/sqlite.git/commit
When flattening a view that is the right operand of a LEFT JOIN, using
authordrh <>
Wed, 1 Mar 2023 20:23:46 +0000 (20:23 +0000)
committerdrh <>
Wed, 1 Mar 2023 20:23:46 +0000 (20:23 +0000)
commitbf901148678bef77f5910c7046053021b611b40b
tree1d1c1d53c29c54d976c378c087c9b478e3878020
parentfe373482552e7b254cf6d3f94ca734014a58250b
When flattening a view that is the right operand of a LEFT JOIN, using
the optimization of check-in [41c27bc0ff1d3135], always insert the
TK_IF_NULL_ROW expression nodes, even for TK_COLUMN expressions, as
the TK_COLUMN might be a column from an outer query and hence still need
to be NULLed out. This fixes the problem described by
[forum:/forumpost/26387ea7ef|forum post 26387ea7ef].

FossilOrigin-Name: 198b3e33dcfd74c7ba6abcf789ee81dfed464a50ebf15c8edeff349d36789fca
manifest
manifest.uuid
src/select.c
test/join2.test