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

Parser doesn't recognise Oracle ( + ) operator, if it contains whitespace #10675

Closed
lukaseder opened this issue Sep 23, 2020 · 2 comments
Closed

Comments

@lukaseder
Copy link
Member

Unfortunately, the Oracle (+) operator for outer joins is not a single token. It consists of 3 tokens ( + ). As such, this is valid Oracle SQL:

select cd, count(t_book.id)
from t_language, t_book
where t_language.id = t_book.language_id(
 +
)
group by cd

To produce:

CD|COUNT(T_BOOK.ID)|
--|----------------|
fr|               0|
pt|               1|
de|               1|
en|               2|

The parser currently doesn't correctly parse this, but produces this error:

Unknown function: [4:2] ...t_book
where t_language.id = t_book.language_id(
[*]+
)
group by cd

@lukaseder
Copy link
Member Author

Related: #10670

@lukaseder
Copy link
Member Author

Fixed in jOOQ 3.14.0. Backport scheduled for 3.13.5 (#10676)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
No open projects
Development

No branches or pull requests

1 participant