Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.6.17
-
None
Description
-- #1
|
-- print [{}] - VALID
|
SELECT JSON_ARRAYAGG(JSON_OBJECT()); |
 |
-- #2
|
-- print [NULL] - INVALID ???
|
SELECT JSON_ARRAYAGG(JSON_OBJECT()) |
WHERE FALSE; |
The code #2 expects no rows selected, but it actually selects a single row with a [NULL] value.
I don't see this in other functions, but I see this error in the JSON_ARRAYAGG() function.