Skip to content

[BUG] JSQLParser 5.4-SNAPSHOT : PostgreSQL : ROWS FROM not supported #2411

@tomershay

Description

@tomershay

Failing SQL Feature:

ROWS FROM, which is used to combine multiple set-returning functions (SRFs) into a single FROM item

Docs here

SQL Example:

SELECT *
FROM ROWS FROM (
    generate_series(1,3),
    generate_series(10,12)
) AS t(a,b);

Parsing error:
ParseException: Encountered: <K_FROM> / "FROM", at line 2, column 11, in lexical state DEFAULT.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions