Skip to content

OPTIMIZE statement cannot be parsed #348

@msbruno

Description

@msbruno

SQL commands like the sql below cannot be parsed, an exception occurs.

SELECT *
FROM EMP
ORDER BY SALARY DESC
OPTIMIZE FOR 20 ROWS;

Exception: "net.sf.jsqlparser.parser.ParseException: Encountered " <S_IDENTIFIER> "OPTIMIZE "" at line 4, column 3.
Was expecting one of:

"FOR" ..."

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