Description
Add new function ARRAY_REPLACE_EQUIVALENT which is the same as ARRAY_REPLACE but tests candidate array values for equivalence rather than equality. This distinction permits the replacement of NULL values and composite object values with NULL attributes.
An example of the difference:
SELECT ARRAY_REPLACE([{"a":1},{"a":null}],{"a":null},{"a":2}), ARRAY_REPLACE_EQUIVALENT([{"a":1},{"a":null}],{"a":null},{"a":2}); |
...
|
"results": [ |
{
|
"$1": [ |
{
|
"a": 1 |
},
|
{
|
"a": null |
}
|
],
|
"$2": [ |
{
|
"a": 1 |
},
|
{
|
"a": 2 |
}
|
]
|
}
|
],
|
...
|
Attachments
Issue Links
- relates to
-
MB-51810 Add ARRAY_REPLACE_EQUIVALENT function.
- Resolved