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

CAST(x AS INTERVAL DAY_SECOND(N))

Details

    Description

      To write mtr tests easier, we'll add CAST(x AS INTERVAL DAY_SECOND(N)).
      For now it will return a VARCHAR with a specific format:

      [+][DD ]hh:mm:ss[.ffffff]

      It will be helpful to write tests with functions that now understand long time intervals:

      • TIMESTMP(ts, time_interval)
      • ADDTIME(ts, time_interval)
      • EXTRACT(DAY FROM src)

      So in this query:

      SELECT
      		 
        CAST(1223344.123456 AS INTERVAL DAY_SECOND(6)) AS cast_itds,
      		 
        EXTRACT(DAY FROM 1223344.123456) AS d,
      		 
        EXTRACT(HOUR FROM 1223344.123456) AS h;


      +-------------------+------+------+
      		 
      | cast_itds         | d    | h    |
      		 
      +-------------------+------+------+
      		 
      | 5 02:33:44.123456 |    5 |    2 |
      		 
      +-------------------+------+------+

      it will be clear how the day and the hour value are calculated.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-16991 Rounding vs truncation for TIME, DATETIME, TIMESTAMP

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17351 Wrong results for GREATEST,TIMESTAMP,ADDTIME with an out-of-range TIME-alike argument

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-17740 Extend EXTRACT(x AS DAY*) to understand long time intervals

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            bar Alexander Barkov created issue -
            bar Alexander Barkov made changes -
            Field Original Value New Value
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            bar Alexander Barkov made changes -
            issue.field.resolutiondate 2018-11-20 09:51:06.0 2018-11-20 09:51:06.968
            bar Alexander Barkov made changes -
            Fix Version/s 10.4.1 [ 23228 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 90782 ] MariaDB v4 [ 133764 ]

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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