[MCOL-4462] CAST(varchar_expr AS DECIMAL(M,N)) returns a wrong result - Jira

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.

is blocked by

MCOL-4531 New string-to-decimal conversion implementation

relates to

MCOL-4500 Bit functions processing throws internally trying to cast char into decimal representation

Transition	Time In Source Status	Execution Times

Alexander Barkov made transition - 2021-03-02 11:24

Open

Closed

73d 22h 25m

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB ColumnStore