]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix assignment to array of domain over composite.
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 19 Oct 2021 17:54:46 +0000 (13:54 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 19 Oct 2021 17:54:46 +0000 (13:54 -0400)
commit30e61a8cdc8624102ebdb1abbbb1e45457877c5c
treee54d5d4eb7ae361c96d077ad99d9dad755b7aac6
parentcf33fb7f4a199213a0a83209b81caa728f5c7750
Fix assignment to array of domain over composite.

An update such as "UPDATE ... SET fld[n].subfld = whatever"
failed if the array elements were domains rather than plain
composites.  That's because isAssignmentIndirectionExpr()
failed to cope with the CoerceToDomain node that would appear
in the expression tree in this case.  The result would typically
be a crash, and even if we accidentally didn't crash, we'd not
correctly preserve other fields of the same array element.

Per report from Onder Kalaci.  Back-patch to v11 where arrays of
domains came in.

Discussion: https://postgr.es/m/PH0PR21MB132823A46AA36F0685B7A29AD8BD9@PH0PR21MB1328.namprd21.prod.outlook.com
src/backend/executor/execExpr.c
src/test/regress/expected/domain.out
src/test/regress/sql/domain.sql