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

Time type addition error

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

          Ascending order - Click to sort in descending order
          John Jove John Jove created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          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,)).
          		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.
          {code:sql}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;
          {code}

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

          What actually happened:
          The SELECT statement actually returned ((1,), (1,)).
          serg Sergei Golubchik made changes -
          Component/s Temporal Types [ 11000 ]
          Component/s Data types [ 13906 ]
          Fix Version/s N/A [ 14700 ]
          Resolution Not a Bug [ 6 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ]

          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.