|
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.
|