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.

Sign up for GitHub

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

Jump to bottom

JSqlParser doesn't parse Oracle INTERVAL literal #69

Closed
HEP85 opened this issue Jul 30, 2014 · 1 comment
Closed

JSqlParser doesn't parse Oracle INTERVAL literal #69

HEP85 opened this issue Jul 30, 2014 · 1 comment
Assignees
@wumpz

Comments

@HEP85
Copy link

HEP85 commented Jul 30, 2014

Test SQL: select INTERVAL '5' HOUR from DUAL;
@wumpz
Copy link
Member

wumpz commented Jul 30, 2014

JSqlParser does at the moment only support this syntax:

select INTERVAL '5 HOUR'

This comes from PostgreSQL but I see that PostgreSQL does as well support your variant

select INTERVAL '5' HOUR

Unfortunatly Oracle does not support the first version.

@wumpz wumpz self-assigned this Apr 21, 2015
@wumpz wumpz closed this as completed in 35164e5 May 10, 2015
wumpz added a commit that referenced this issue May 12, 2015
@wumpz
fixes #69
1603487
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@wumpz wumpz

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@HEP85 @wumpz