Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.3.12, 5.5.35, 10.0.9, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9
-
None
-
None
Description
mysql> SELECT LEAST('11','2'), CAST(LEAST('11','2') AS DECIMAL);
|
+-----------------+----------------------------------+
|
| LEAST('11','2') | CAST(LEAST('11','2') AS DECIMAL) |
|
+-----------------+----------------------------------+
|
| 11 | 2 |
|
+-----------------+----------------------------------+
|
1 row in set (0.01 sec)
|
The result for CAST(LEAST()) is wrong.
The expected result is 11, similar to what LEAST('11,'2') returns.