Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16976

Support for periods operations

    XMLWordPrintable

Details

    Description

      The spec should look like:

      period_expr ::= <period> <op> <period>
      		 
      period      ::= PERIOD(<datetime>, <datetime>) | <period_name>
      		 
      period_name ::= <ident>|<table_name>.<ident>
      		 
      op          ::= CONTAINS|OVERLAPS|EQUALS|PRECEDES|SUCCEEDS
      		 
                      |IMMEDIATELY PRECEDES|IMMEDIATELY SUCCEEDS

      Attachments

        Issue Links

          is duplicated by

          Task - A task that needs to be done. MDEV-28383 Implement SQL:2011 WHERE predicates for application-versioned tables (CONTAINS, OVERLAPS, etc.)

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-16972 Application-time periods support (phase 1)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-18928 Application-time periods support (phase 2)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              nikitamalyavin Nikita Malyavin
              nikitamalyavin Nikita Malyavin
              Votes:
              2 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 25d
                  25d
                  Remaining:
                  Time Spent - 7d Remaining Estimate - 18d
                  18d
                  Logged:
                  Time Spent - 7d Remaining Estimate - 18d
                  7d

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.