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

Time type addition error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 11.4.3
    • N/A
    • Temporal Types
    • None
    • ubuntu,x86

    Description

      What I did:
      There was a problem with the addition of TIME types when adding a time to another time and the result exceeded the 24-hour format. The result of the TIME type was not accurate.
      An error occurred when '23:59:59' + TIME '00:01:00' was calculated.

      CREATE TABLE t1(
      c1 TIME
      );
      INSERT INTO t1 (c1) VALUES
      ('00:00:01'),
      ('23:59:59'); 
       
      SELECT c1 + TIME '00:01:00' < TIME '01:00:00'
      FROM t1;
      

      What I wanted to happen:
      The SELECT statement should return ((1,), (0,)).

      What actually happened:
      The SELECT statement actually returned ((1,), (1,)).

      Attachments

        Activity

          People

            serg Sergei Golubchik
            John Jove John Jove
            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.