It seems that the function "if(expr1,expr2,expr3)" is not supported。

[GaryBoBo]

Encountered unexpected token: "(" "("

[manticore-projects]

Should be supported with 4.2-Snapshot.
Please verify and provide a full test case otherwise.

[GaryBoBo]

SELECT if(1 in (1,2,3),'yes','no') from dual

[manticore-projects]

1 in (1,2,3) should not be a valid expression.

[manticore-projects]

But it parses correctly. You can try here online.

[GaryBoBo]

Use CCJSqlParserUtil.parse(String sql) to parse this sql throws exception.

[GaryBoBo]

Thank you! This JSQLParser Snapshot solved my problem.

[manticore-projects]

Welcome, you can also use the JSQLParser 4.2 Snapshot from upstream.
The nonofficial patched JSQLParser 4.1 Snapshot was a temporary Bridge Gap Solution and is no longer needed.

Please mark this discussion as ANSWERED, thank you.

[manticore-projects]

Please refer to issue #1284 which has been resolved in the meantime by PR #1285.
After that PR you can definitely use upstream.