Join GitHub today
GitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together.
Sign upGitHub is home to over 50 million developers working together to host and review code, manage projects, and build software together.
Sign up
Describe the bug
when parse a page sql with CCJSqlParserUtil, encounter a ParseException, but the sql is right which can run in my pgSQL
To Reproduce
Steps to reproduce the behavior:
select s.* from camera s where s.index_code = '12' limit 10 offset (5 - 1) * 10
CCJSqlParserUtil.parse(sql);
net.sf.jsqlparser.parser.ParseException: Encountered " "(" "( "" at line 1, column 77.
Was expecting one of:
<S_LONG> ...
"?" ...
Expected behavior
A clear and concise description of what you expected to happen.
util will work when I replace (5 - 1) * 10 in offset with 40, but it should work use this expression
System