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 upWhen SQL query contains an IN operator with multi-column expressions JSQLParserException is thrown #939
Comments
|
Is JSqlParser supporting customized syntax? If so maybe we can support it by ourselves @wumpz |
|
@meelistolk see #737 |
Describe the bug
When SQL query contains an IN operator with multi-column expressions (made with row constructors) and the query is parsed with CCJSqlParserUtil.parseStatements(sql) the parse method throws JSQLParserException.
To Reproduce
Steps to reproduce the behavior:
select code,name
from users
where (code,name) in ((1,'name1'),(86,'name2'))
Expected behavior
This query should be parseable and should not throw an exception
System