[BUG] Relevance Search Query Not Working With Nested Function

[forestmvey]

What is the bug?
Using a relevance based search function in the WHERE clause with the nested function in one SELECT clause fails the query.

"query":"SELECT nested(message.info), someField FROM nested_objects WHERE match(someField, 'a');"
-------------------------------------------------------------------------------------------------------
{
  "error": {
    "reason": "Invalid SQL query",
    "details": "syntax error, expect AGAINST, actual EOF",
    "type": "ParserException"
  },
  "status": 400
}

While both these queries succeed individually, together the query fails.

"query":"SELECT someField FROM nested_objects WHERE match(someField, 'a');"
"query":"SELECT nested(message.info) FROM nested_objects;"

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

1. Push query into SQL plugin - "SELECT nested(message.info), someField FROM nested_objects WHERE match(someField, 'a');"
2. See failure results.

What is the expected behavior?
The nested function should return a valid field when used in a SELECT clause with a Relevance based search function in the WHERE clause.

What is your host/environment?

• OS: MacOS
• Version 13.2.1