Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
6.1.1
-
None
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a DECIMAL(30,1)) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES (-9223372036854775807.9); |
SELECT a, ROUND(a), CAST(ROUND(a) AS SIGNED) FROM t1; |
+------------------------+----------------------+--------------------------+
|
| a | ROUND(a) | CAST(ROUND(a) AS SIGNED) |
|
+------------------------+----------------------+--------------------------+
|
| -9223372036854775807.9 | -9223372036854775808 | NULL |
|
+------------------------+----------------------+--------------------------+
|
NULL in the last column looks wrong.