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

Inconsistent warnings when converting string to decimal

        Details

        • Type: Bug
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Affects Version/s: 10.0.9
        • Fix Version/s: 10.0
        • Component/s: None
        • Labels:
          None

          Description

          mysql> select cast('' as decimal(30,1)), cast(concat('') as decimal(30,1)); show warnings;
+---------------------------+-----------------------------------+
| cast('' as decimal(30,1)) | cast(concat('') as decimal(30,1)) |
+---------------------------+-----------------------------------+
|                       0.0 |                               0.0 |
+---------------------------+-----------------------------------+
1 row in set, 2 warnings (0.00 sec)

+---------+------+---------------------------------------------------------+
| Level   | Code | Message                                                 |
+---------+------+---------------------------------------------------------+
| Warning | 1292 | Truncated incorrect DECIMAL value: ''                   |
| Warning | 1918 | Encountered illegal value '' when converting to DECIMAL |
+---------+------+---------------------------------------------------------+
2 rows in set (0.00 sec)

          The warnings should probably be the same for both values.

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-5945 Warning generation is inconsistent when converting from number to string

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

                  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: