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

Wrong TIME value from a long string

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.3, 5.5.31, 5.1.67, 5.2.14, 5.3.12
        • Fix Version/s: 5.3.13, 10.0, 5.5
        • Component/s: None
        • Labels:
          None

          Description

          This query 

          mysql> select time('11111112233');
+---------------------+
| time('11111112233') |
+---------------------+
| 838:59:59.999999    |
+---------------------+
1 row in set, 1 warning (0.00 sec)

          correctly adjusts (with a warning) the results to the maximum supported
          value. However, if the string gets longer, it does not work any more:

          mysql> select time('111111112233');
+----------------------+
| time('111111112233') |
+----------------------+
| 11:22:33             |
+----------------------+

          The last query should be fixed to adjust the TIME value and produce a warning.

            Gliffy Diagrams

              Attachments

                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: