Skip to content

No support for ANY and ALL use in WHERE #936

Closed
@SeanTroyUWO

Description

@SeanTroyUWO

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

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions