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"?
It seems not support "SKIP LOCKED". The following two SQL can execute normally in MySql8, but parse failed by JSqlParser.
Can JSqlParser add support for "SKIP LOCKED"?