Skip to content

Can support "FOR UPDATE SKIP LOCKED"? #1610

Closed
@jimmy384

Description

@jimmy384

It seems not support "SKIP LOCKED". The following two SQL can execute normally in MySql8, but parse failed by JSqlParser.

SELECT * FROM t_user FOR UPDATE SKIP LOCKED;
SELECT * FROM t_user FOR UPDATE OF t_user SKIP LOCKED;
Caused by: java.util.concurrent.ExecutionException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "SKIP" "SKIP"
    at line 1, column 35.

Was expecting one of:

    ";"
    "NOWAIT"
    "OF"
    <EOF>

Can JSqlParser add support for "SKIP LOCKED"?

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