Closed
Description
Seems like the parser only supports the use of ANY
and ALL
in SELECT
, not WHERE
.
This form seems to work:
SELECT ALL column_name(s)
FROM table_name
WHERE condition;
There's a test for it in tests/sqlparser_common.rs line: 1539
This does not supported:
SELECT column_name(s)
FROM table_name
WHERE column_name operator ALL
(SELECT column_name
FROM table_name
WHERE condition);
I'm not sure why this is the case. Please let me know if this is intentional. If not I can create a PR.
Metadata
Metadata
Assignees
Labels
No labels