Skip to content

Missing support for SQL operator 'OVERLAPS' #1604

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
Closed
d2a-raudenaerde opened this issue Jul 29, 2022 · 0 comments
Closed

Missing support for SQL operator 'OVERLAPS' #1604

d2a-raudenaerde opened this issue Jul 29, 2022 · 0 comments

Comments

@d2a-raudenaerde
Copy link
Contributor

In SQL it is possible to do something like this:

select 'yes' from dual where (sysdate-5,sysdate) overlaps (sysdate-2,sysdate-1) (interval5.sql)

JsqlParser currently does not support this.

I started a Discussion on how it could be implemented: #1600
d2a-raudenaerde added a commit to d2a-raudenaerde/JSqlParser that referenced this issue Aug 2, 2022
@d2a-raudenaerde
Closes JSQLParser#1604, added simple OVERLAPS support
ba84580
d2a-raudenaerde added a commit to d2a-raudenaerde/JSqlParser that referenced this issue Aug 4, 2022
@d2a-raudenaerde
Closes JSQLParser#1604, added simple OVERLAPS support
e3db6d5
d2a-raudenaerde added a commit to d2a-raudenaerde/JSqlParser that referenced this issue Aug 4, 2022
@d2a-raudenaerde
Closes JSQLParser#1604, added simple OVERLAPS support
8f8f314
d2a-raudenaerde added a commit to d2a-raudenaerde/JSqlParser that referenced this issue Aug 4, 2022
@d2a-raudenaerde
Closes JSQLParser#1604, added simple OVERLAPS support
43296ce
d2a-raudenaerde added a commit to d2a-raudenaerde/JSqlParser that referenced this issue Aug 4, 2022
@d2a-raudenaerde
Closes JSQLParser#1604, added simple OVERLAPS support
68a4d92
@wumpz wumpz closed this as completed in 236a50b Aug 16, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@d2a-raudenaerde