summaryrefslogtreecommitdiff
path: root/contrib/jsonb_plpython
diff options
context:
space:
mode:
authorRichard Guo2025-09-16 09:42:20 +0000
committerRichard Guo2025-09-16 09:42:20 +0000
commitb63a822452152a7bd613fd4b28e0967e626e274e (patch)
treec842738783cc29611804939bcb1fa56293a2e8cf /contrib/jsonb_plpython
parentcfa6cd29271e67c43c1040e3420c1145fdcdceb7 (diff)
Treat JsonConstructorExpr as non-strict
JsonConstructorExpr can produce non-NULL output with a NULL input, so it should be treated as a non-strict construct. Failing to do so can lead to incorrect query behavior. For example, in the reported case, when pulling up a subquery that is under an outer join, if the subquery's target list contains a JsonConstructorExpr that uses subquery variables and it is mistakenly treated as strict, it will be pulled up without being wrapped in a PlaceHolderVar. As a result, the expression will be evaluated at the wrong place and will not be forced to null when the outer join should do so. Back-patch to v16 where JsonConstructorExpr was introduced. Bug: #19046 Reported-by: Runyuan He <[email protected]> Author: Tender Wang <[email protected]> Co-authored-by: Richard Guo <[email protected]> Discussion: https://postgr.es/m/[email protected] Backpatch-through: 16
Diffstat (limited to 'contrib/jsonb_plpython')
0 files changed, 0 insertions, 0 deletions