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 upMultiple inner query inside IN clause does not work #905
Comments
|
Did you already try the actual version 3.1? |
|
@wumpz yes. it did not work. but i already have the fix now. :) can i submit pull request for JSqlParserCC.jjt? tested in 2.1. pull request to master branch? how about the tag? thanks! |
|
Sure. But I will integrate it in version 3.1. You want to stay with 2.1? |
|
@wumpz - we still have clients using JRE 1.7. Until we fully migrate to JRE 12 or JRE 1.8 minimum, need to use 2.1. |
|
@jobert21 I see. 1.7 was along time ago, at least for me. Do you want your patch merged into some version 2.1.1? |
|
@wumpz yes. will submit a pull request. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Describe the bug
SQL with multiple inner query inside IN clause does not work. Example below
To Reproduce
Steps to reproduce the behavior:
select * from table_a where other_id in ((select id from table_b where name like '%aa%'), (select id from table_b where name like '%bb%'))CCJSqlParserUtil.parse(sql)Encountered unexpected token: "in" "IN"Expected behavior
The query runs properly when executing in SQL Server.
System