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

Wrong result of MAKETIME(0, 0, 59.9)

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Duplicate
        • Affects Version/s: 10.0.3, 5.5.32, 5.3.12
        • Fix Version/s: None
        • Component/s: None
        • Labels:
          None

          Description

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

          The above result is wrong.
          The expected result is '00:00:59.9'.

          Note: MySQL-5.6 correctly returns '00:00:59.9'.

            Gliffy Diagrams

              Attachments

                Issue Links

                is duplicated by

                Bug - A problem which impairs or prevents the functions of the product. MDEV-4724 Some temporal functions do not preserve microseconds

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

                  Activity

                  There are no comments yet on this issue.

                    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: