Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5, 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
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