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

Wrong result for 0 + LEAST(TIME'-10:00:00',TIME'10:00:00')

    Details

      Description

      SELECT 0 + LEAST(TIME'-10:00:00',TIME'10:00:00') AS c;


      +--------+
      		 
      | c      |
      		 
      +--------+
      		 
      | 100000 |
      		 
      +--------+

      Looks wrong. The expected result is -100000.

        Attachments

          Issue Links

          blocks

          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 Add a plugin to field types (column types)

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • In Progress
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17318 CAST(LEAST(zero_date,non_zero_date) AS numeric_data_type) returns a wrong result

          • Major - Major loss of function.
          • Closed

            Activity

              People

              • Assignee:
                bar Alexander Barkov
                Reporter:
                bar Alexander Barkov
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: