Skip to content

Missing support for SQL operator 'OVERLAPS' #1604

Closed
Closed
Missing support for SQL operator 'OVERLAPS'#1604

Description

@d2a-raudenaerde
d2a-raudenaerde
opened on Jul 29, 2022

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

    ba84580

    Closes JSQLParser#1604, added simple OVERLAPS support

    e3db6d5

    Closes JSQLParser#1604, added simple OVERLAPS support

    8f8f314

    Closes JSQLParser#1604, added simple OVERLAPS support

    43296ce

    Closes JSQLParser#1604, added simple OVERLAPS support

    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)

    236a50b
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions