Wrong behavior of coalesce()

[randomJoe211]

Describe the bug (required)

The coalesce() function cannot return the first non-null element in a list.

nGQL:

WITH [NULL, 4923, 'abc', 521, 487] AS ids RETURN coalesce(ids);

Your Environments (required)

• OS: ubuntu 20.04
• Nebual Graph version: 3.1.0
  

[czpmango]

The function coalesce() returns the first non-null value in the given list of expressions not in the given list.

[czpmango]

(root@nebula) [nba]> WITH [NULL, 4923, 'abc', 521, 487] AS list1 RETURN head([x in list1 where x is not null | x])
+----------------------------------------------------------------+
| head([__VAR_0 IN list1 WHERE $__VAR_0 IS NOT NULL | $__VAR_0]) |
+----------------------------------------------------------------+
| 4923                                                           |
+----------------------------------------------------------------+

[czpmango]

Closed but free to ask.