ARRAY_CAT Function: Changes to NULL Handling¶
This behavior change is in the 2023_01 bundle.
For the current status of the bundle, refer to Bundle History.
The way in which the ARRAY_CAT function handles NULL input values has changed:
If you passed NULL as an input argument to ARRAY_CAT, the function reported the following error:
NULL result in a non-nullable column
If you pass NULL as an input argument to ARRAY_CAT, the function returns NULL, rather than reporting an error.