Repository navigation
Can support "FOR UPDATE SKIP LOCKED"? #1610
Description
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"?
Activity
d2a-raudenaerde commentedon Aug 5, 2022
PostgreSQL also supports this (unfortunately, I don't have any SQL standard grammars > 2003 so I can't check when it was added. It did not exist in sql2003.
lucasdillmann commentedon Oct 19, 2022
Hi. I've implemented the support for SKIP LOCKED tokens through the PR above. Can anyone check it and let me know if everything is OK?
#1610 Support for SKIP LOCKED tokens on SELECT statements (#1649)
wumpz commentedon Oct 25, 2022
Seems OK. I merged it. Use as a final commit something like fixes #issue then the issue will be closed automatically after merge.
lucasdillmann commentedon Oct 26, 2022
Hi @wumpz, thanks for the review, merge and the feedback on the commit message.