Description

d2a-raudenaerde

opened on Jul 29, 2022

Issue body actions

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

Activity

1. d2a-raudenaerde

   added 5 commits that reference this issue on Aug 2, 2022

   Closes JSQLParser#1604, added simple OVERLAPS support

   This issue will close once commit ba84580 is merged into the 'master' branch.

   ba84580

   Closes JSQLParser#1604, added simple OVERLAPS support

   This issue will close once commit e3db6d5 is merged into the 'master' branch.

   e3db6d5

   Closes JSQLParser#1604, added simple OVERLAPS support

   This issue will close once commit 8f8f314 is merged into the 'master' branch.

   8f8f314

   Closes JSQLParser#1604, added simple OVERLAPS support

   This issue will close once commit 43296ce is merged into the 'master' branch.

   43296ce

   Closes JSQLParser#1604, added simple OVERLAPS support

   This issue will close once commit 68a4d92 is merged into the 'master' branch.

   68a4d92
2. wumpz

   closed this as completedin 236a50bon Aug 16, 2022
3. yadedoo

   added a commit that references this issue on May 11, 2024

   Closes JSQLParser#1604, added simple OVERLAPS support (JSQLParser#1611)

   This issue will close once commit 236a50b is merged into the 'master' branch.

   236a50b

Issue actions