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