The Wayback Machine - https://web.archive.org/web/20201011182957/https://github.com/JSQLParser/JSqlParser/pull/631
Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

IN clause without parentheses is not working but work in Oracle DB #631

Open
wants to merge 1 commit into
base: master
from

Conversation

@skylark-nam
Copy link

@skylark-nam skylark-nam commented Jul 1, 2018

Hi, Oracle expressions are possible. expression IN value1

ex) select 1 from dual where a in 1

@coveralls
Copy link

@coveralls coveralls commented Jul 1, 2018

Coverage Status

Coverage remained the same at 86.099% when pulling 193a80d on skylark-nam:master into ffbf96e on JSQLParser:master.

@wumpz
Copy link
Member

@wumpz wumpz commented Jul 2, 2018

I have two problems with this commit:

  1. something like "in ( expr" would be accepted. If there is an opening parenthesis there must be a closing one. I know it is not yet done for all of JSqlParser, but it should.
  2. The deparser should reconstruct exactly the same statement from the parse tree. But without any change, it would forget the parenthesis.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked issues

Successfully merging this pull request may close these issues.

None yet

3 participants
You can’t perform that action at this time.