Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
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.