[BUG] NESTED Function Fails in non-SELECT Clauses

[forestmvey]

What is the bug?
The nested function fails query execution when used in WHERE, GROUP BY, ORDER BY, and HAVING clauses.

How can one reproduce the bug?
Steps to reproduce the behavior:

1. Execute query: select * from nested_objects GROUP BY nested(message.info);
2. See error message:

{
  "error": {
    "reason": "There was internal problem at backend",
    "details": "Failed to serialize expression: FunctionExpression(functionName=nested, arguments=[message.info])",
    "type": "IllegalStateException"
  },
  "status": 503
}

3. Execute Query: SELECT * FROM nested_objects WHERE nested(message.info) = 'a';
4. See error:

{
  "error": {
    "reason": "There was internal problem at backend",
    "details": "Failed to serialize expression: =(FunctionExpression(functionName=nested, arguments=[message.info]), \"a\")",
    "type": "IllegalStateException"
  },
  "status": 503
}

What is the expected behavior?
Nested function query should succeed when used in WHERE clause, and in GROUP BY with json format.

What is your host/environment?

• Version: 4e9ca016f45ccebacd629aebcd12fdf4d3bbb2e8

[dai-chen]

Do we want to close this now?

[forestmvey]

Do we want to close this now?

@dai-chen Yes we are good to close this now!