SQLParseException on query with subqueries with latest nightly about crate

[BaurzhanSakhariev]

Same as https://github.com/orgs/crate/projects/21?pane=issue&itemId=66358387, if I revert #16079, query works.

[hlcianfagna]

Tried fadbaf0 (nightly-5.8.0-2024-05-16-00-02) and this was working

[hlcianfagna]

A bit more context as there may be something more going on, the repro query in this ticket is a simplified version of a more complex query I am trying to run.

• In 5.7.1 and fadbaf0
  • the query in this ticket: works
  • my actual query: fails with a stack trace very similar to the one from #15901 (an issue I came across on a completely different context)
• In 3a9fd77 (nightly-5.8.0-2024-05-23-00-02) - which got the fix for #15901
  • the query in this ticket: still works
  • my actual query: fails with an error message very similar to the one on this issue.
• In f0174b1 (nightly-5.8.0-2024-06-09-00-02)
  • the query in this ticket: does not work anymore
  • my actual query: fails with a very similar message to 3a9fd77 (now a Collect retrieves less fields)

[amotl]

Hi. The Build Status page, demonstrating CI run outcomes of integration tests with 3rd party software, also has a few more red fringes. I didn't investigate more closely, but it might be related.

@BaurzhanSakhariev investigated that issue, which might be unrelated to yours, and added a corresponding card. If its totally unrelated, it looks like we currently observe multiple regressions.

Edit: Red fringes are totally unrelated and just peripheral:

• crate/mlflow-cratedb#149