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.
Attachments
Issue Links
Activity
Field | Original Value | New Value |
---|---|---|
Description |
{code:sql}
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; {code} {noformat} +------+--------------------------+--------------------------+--------------------------+ | 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 | +------+--------------------------+--------------------------+--------------------------+ {noformat} |
{code:sql}
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; {code} {noformat} +------+--------------------------+--------------------------+--------------------------+ | 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 | +------+--------------------------+--------------------------+--------------------------+ {noformat} Expected to get '10.10' and '10.100' in the third and the fourth column. |
Rank | Ranked higher |
Rank | Ranked higher |
Rank | Ranked higher |
Rank | Ranked higher |
Fix Version/s | 5.6.1 [ 25031 ] | |
Fix Version/s | 5.5.1 [ 25030 ] |
Rank | Ranked higher |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Affects Version/s | All [ 25803 ] | |
Affects Version/s | 5.4.3 [ 25202 ] |
Labels | tech_debt |
Fix Version/s | 6.1.1 [ 25600 ] | |
Fix Version/s | 5.6.1 [ 25031 ] |
Affects Version/s | All [ 25803 ] |