Updates should ignore null values?
|Reported by:||dmisev||Owned by:|
|Keywords:||Cc:||pbaumann, vmerticariu, bphamhuu, negroscuro7@…|
Description (last modified by dmisev)
In an update, if the source array contains null values, should they overwrite the existing values in the target array?
If they do then we cannot do mosaics properly, see e.g. https://groups.google.com/d/msg/rasdaman-users/OFuT_hkk_Iw/HjiubaIRAgAJ
The source array in an update statement doesn't have null values associated to it, only the persistent arrays (and intermediate arrays derived from these) in the database have. If we would introduce a mechanism to attach null values to any array value, we could say that then they can be ignored in the update. Something like:
UPDATE coll AS c SET c ASSIGN decode($1) WITH NULL VALUES