]> git.ipfire.org Git - thirdparty/sqlite.git/commit
projects / thirdparty / sqlite.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f42ceb9) | patch
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
treec699ec0c9a3fa825933536c5357c792db39469b9tree | snapshot
parentf42ceb9075c6dc64e36c17a1836ea3a0a2b4e8f6commit | diff
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 diff | blob | blame | history
manifest.uuid diff | blob | blame | history
src/select.c diff | blob | blame | history
test/join.test diff | blob | blame | history
Mirror of https://github.com/sqlite/sqlite.git