Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-715

Add PERIOD type constructor and period operators (CONTAINS, PRECEDES, etc.)

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.13.0
    • stream
    • None

    Description

      Add support for period operators: CONTAINS, OVERLAPS, EQUALS, PRECEDES, SUCCEEDS, IMMEDIATELY PRECEDES, and IMMEDIATELY SUCCEEDS.

      These are among the temporal database features added to SQL:2011.

      See http://www.sigmod.org/publications/sigmod-record/0612/publications/1209/pdfs/07.industry.kulkarni.pdf.

      Attachments

        Issue Links

          is depended upon by

          New Feature - A new feature of the product, which has yet to be developed. PHOENIX-967 Consider (some of) SQL 2011 temporal support

          • Major - Major loss of function.
          • Open

          Activity

            People

              julianhyde Julian Hyde
              julianhyde Julian Hyde
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: