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
jsqlparser cannot parse the expression with "=" in select statement.
To Reproduce
Steps to reproduce the behavior:
Example SQL select sum(case when companyid not in (null) then 1 else 0 end)=1 as validate_companyid from table1;
Parsing this SQL using JSqlParser with this statements
CCJSqlParserManager ccjSqlParserManager = new CCJSqlParserManager();
Statement statement;
List columns = new ArrayList();
try {
statement = ccjSqlParserManager.parse(new StringReader(singleSql));
Exception
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "=" "="
at line 1, column 64.
Was expecting one of:
"&"
","
"."
"::"
";"
"<<"
">>"
...
Expected behavior
System