Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5
-
Component/s: Data types
-
Labels:None
Description
SELECT
|
ROUND(18446744073709551615,rand()*0) AS c1, |
ROUND(18446744073709551615.0,rand()*0) AS c2; |
+----------------------+------------------------+
|
| c1 | c2 |
|
+----------------------+------------------------+
|
| 18446744073709552000 | 18446744073709551615.0 |
|
+----------------------+------------------------+
|
The result for c1 is wrong. It should be equal to 18446744073709551615, like c2, just without the '.0' part.
Attachments
Issue Links
- relates to
-
MDEV-23032 FLOOR()/CEIL() incorrectly calculate the precision of a DECIMAL(M,D) column.
-
- Closed
-