]> git.ipfire.org Git - thirdparty/sqlite.git/commit
When synthesizing an ON constraint from a USING or NATURAL, if the left-hand
authordrh <>
Fri, 30 May 2025 19:55:46 +0000 (19:55 +0000)
committerdrh <>
Fri, 30 May 2025 19:55:46 +0000 (19:55 +0000)
commitdd16539e71e375abbe2affa3b142f2454a3d9edc
treec699ec0c9a3fa825933536c5357c792db39469b9
parentf42ceb9075c6dc64e36c17a1836ea3a0a2b4e8f6
When synthesizing an ON constraint from a USING or NATURAL, if the left-hand
side is coming from a RIGHT JOIN, be sure to set the EP_CanBeNull flag so that
the optimizer knows to check for NULL even if the column has a NOT NULL
constraint.  Fix for the problem reported by
[forum:/forumpost/4fc70203b61c7e12|forum post 4fc70203b61]

FossilOrigin-Name: 60adc78a22956429d34ccc4e2c193c5994c11c3b3cff7901d47fad7d92dba935
manifest
manifest.uuid
src/select.c
test/join.test