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

Some temporal functions do not preserve microseconds

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: 10.0.4, 5.5.31, 5.3.12
        • Fix Version/s: 10.0.5, 5.5.33
        • Component/s: None
        • Labels:
          None

          Description

          The function MAKETIME() in MariaDB does not preserve fractional digits:

          MariaDB [test]> SELECT MAKETIME(10,10,10.231);
+------------------------+
| MAKETIME(10,10,10.231) |
+------------------------+
| 10:10:10               |
+------------------------+
1 row in set (0.00 sec)

          It works as expected in MySQL-5.6:

          MySQL [test]> SELECT MAKETIME(10,10,10.231);
+------------------------+
| MAKETIME(10,10,10.231) |
+------------------------+
| 10:10:10.231           |
+------------------------+
1 row in set (0.00 sec)

          A possibly related problem:

          MariaDB [test]> SELECT MAKETIME(0, 0, 59.9);
+----------------------+
| MAKETIME(0, 0, 59.9) |
+----------------------+
| NULL                 |
+----------------------+

          The above result is wrong.
          It seems 59.9 is rounded to 60, which makes a wrong time '00:00:60', hence NULL.
          The expected result is '00:00:59.9'.

          More examples:

          MariaDB [test]> drop table if exists t1; create table t1 as select time('10:00:00'); show create table t1;
Query OK, 0 rows affected (0.00 sec)
Query OK, 1 row affected (0.10 sec)
Records: 1  Duplicates: 0  Warnings: 0
+-------+------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                         |
+-------+------------------------------------------------------------------------------------------------------+
| t1    | CREATE TABLE `t1` (
  `time('10:00:00')` time(6) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

          The expected column type is time(0).

            Gliffy Diagrams

              Attachments

                Issue Links

                blocks

                Bug - A problem which impairs or prevents the functions of the product. MDEV-4843 Wrong data type for TIMESTAMP('2001-01-01','10:10:10')

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

                Bug - A problem which impairs or prevents the functions of the product. MDEV-4862 Wrong result of MAKETIME(0, 0, 59.9)

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

                Bug - A problem which impairs or prevents the functions of the product. MDEV-4863 COALESCE(time_or_datetime) returns wrong results in numeric context

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

                Bug - A problem which impairs or prevents the functions of the product. MDEV-3922 UNIX_TIMESTAMP() reports decimal when date specified as string

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

                Bug - A problem which impairs or prevents the functions of the product. MDEV-4861 TIME/DATETIME arithmetics does not preserve INTERVAL precision

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

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment -

                  for maketime it was kind of intentional. it used to take three integers, and it still does. feel free to change it, if you'd like.

                  the second issue is a duplicate of MDEV-3922

                  Show
                  serg Sergei Golubchik added a comment - for maketime it was kind of intentional. it used to take three integers, and it still does. feel free to change it, if you'd like. the second issue is a duplicate of MDEV-3922
                  Hide
                  Permalink
                  bar Alexander Barkov added a comment -

                  Fixed in 5.5.31, 5.3.12

                  Show
                  bar Alexander Barkov added a comment - Fixed in 5.5.31, 5.3.12

                    People

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

                      Dates

                      • Created:
                        Updated:
                        Resolved: