diff options
author | Andres Freund <andres@anarazel.de> | 2015-07-24 11:48:53 +0200 |
---|---|---|
committer | Andres Freund <andres@anarazel.de> | 2015-07-24 11:52:07 +0200 |
commit | c1ca3a19df376bcbb6d651d15b9a4ffcaa377ff1 (patch) | |
tree | 2b4f9277d4cd45da95aa1b2eda87527bb0a06d83 /src/backend/utils/adt/jsonb.c | |
parent | 16c33c50e122e3e7d03fc7ddd5cbd105c0118234 (diff) | |
download | postgresql-c1ca3a19df376bcbb6d651d15b9a4ffcaa377ff1.tar.gz postgresql-c1ca3a19df376bcbb6d651d15b9a4ffcaa377ff1.zip |
Fix bug around assignment expressions containing indirections.
Handling of assigned-to expressions with indirection (e.g. set f1[1] =
3) was broken for ON CONFLICT DO UPDATE. The problem was that
ParseState was consulted to determine if an INSERT-appropriate or
UPDATE-appropriate behavior should be used when transforming expressions
with indirections. When the wrong path was taken the old row was
substituted with NULL, leading to wrong results..
To fix remove p_is_update and only use p_is_insert to decide how to
transform the assignment expression, and uset p_is_insert while parsing
the on conflict statement. This isn't particularly pretty, but it's not
any worse than before.
Author: Peter Geoghegan, slightly edited by me
Discussion: CAM3SWZS8RPvA=KFxADZWw3wAHnnbxMxDzkEC6fNaFc7zSm411w@mail.gmail.com
Backpatch: 9.5, where the feature was introduced
Diffstat (limited to 'src/backend/utils/adt/jsonb.c')
0 files changed, 0 insertions, 0 deletions