SQL:
WITH tab(x) AS (VALUES 1, 2, 1, CAST(NULL AS INTEGER)) SELECT JSON_ARRAYAGG(x), JSON_ARRAYAGG(x NULL ON NULl) FROM tab
Produces:
EXPR$0 |EXPR$1 | --------|--------| [1,2,1] |[1,2,1] |
Should be:
EXPR$0 |EXPR$1 |
--------|--------|
[1,2,1] |[1,2,1,null] |
- links to