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

INTERVAL data type

    XMLWordPrintable

Details

    Description

      Currently INTERVAL literals can appear in context of the DATE_ADD function and the operator +.
      For example:

      SELECT DATE_ADD(OrderDate,INTERVAL 30 DAY) AS OrderPayDate FROM Orders
      		 
      SELECT OrderDate + INTERVAL 30 DAY AS OrderParDate FROM Orders;
      		 
      SELECT INTERVAL 30 DAY + OrderDate AS OrderParDate FROM Orders;

      We will change INTERVAL from a DATE_ADD and + specific syntax to a full-functional data type, so intervals can appear in all context where a regular data type can, including:

      • INTERVAL table fields
      • INTERVAL stored routine variables, parameters, function return values
      • Hybrid built-in functions and operators, such as COALESCE, IF, CASE, LEAST, GREATEST.
      • MIN and MAX aggregate functions

      Attachments

        Issue Links

          duplicates

          Task - A task that needs to be done. MDEV-13088 SUGGESTION: New Data Type: Time Intervals

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-19144 sql_mode="oracle" does not support interval data type

          • Major - Major loss of function.
          • Closed
          is blocked by

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-4912 Data type plugin API version 1

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Task - A task that needs to be done. MDEV-12514 Split Item_temporal_func::fix_length_and_dec()

          • Major - Major loss of function.
          • Closed
          is part of

          Epic - Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down. MDEV-21086 New data types

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-35973 Oracle Compatibility Project 1 for 2025

          • Critical - Crashes, loss of data, severe memory leak.
          • In Progress
          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-35972 Oracle: Function TO_DSINTERVAL()

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              bar Alexander Barkov
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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