Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 6.1.1
-
Fix Version/s: 22.08
-
Component/s: PrimProc
-
Labels: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.