Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.9
-
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.
Attachments
Issue Links
- relates to
-
MDEV-5945 Warning generation is inconsistent when converting from number to string
-
- Closed
-