Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 6.1.1
-
Component/s: PrimProc
-
Labels:
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a VARCHAR(10)) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES ('10.1'); |
SELECT
|
a,
|
CAST(a AS DECIMAL(10,1)), |
CAST(a AS DECIMAL(10,2)), |
CAST(a AS DECIMAL(10,3)) |
FROM t1; |
+------+--------------------------+--------------------------+--------------------------+
|
| a | CAST(a AS DECIMAL(10,1)) | CAST(a AS DECIMAL(10,2)) | CAST(a AS DECIMAL(10,3)) |
|
+------+--------------------------+--------------------------+--------------------------+
|
| 10.1 | 10.1 | 10.01 | 10.001 |
|
+------+--------------------------+--------------------------+--------------------------+
|
Expected to get '10.10' and '10.100' in the third and the fourth column.