[MCOL-4632] CAST(hugeNegativeWideDecimal AS SIGNED) returns 0 or NULL - Jira

XML

Word

Printable

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (d1 DECIMAL(30,0), d2 DECIMAL(30,0) NOT NULL) ENGINE=ColumnStore;

INSERT INTO t1 VALUES (-1e20,-1e20),(1e20,1e20);

SELECT d1, CAST(d1 AS SIGNED), CAST(d2 AS SIGNED) FROM t1;

+------------------------+---------------------+---------------------+

| d1                     | CAST(d1 AS SIGNED)  | CAST(d2 AS SIGNED)  |

+------------------------+---------------------+---------------------+

| -100000000000000000000 |                NULL |                   0 |

|  100000000000000000000 | 9223372036854775807 | 9223372036854775807 |

+------------------------+---------------------+---------------------+

The expected result is:

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (d1 DECIMAL(30,0), d2 DECIMAL(30,0) NOT NULL) ENGINE=InnoDB;

INSERT INTO t1 VALUES (-1e20,-1e20),(1e20,1e20);

SELECT d1, CAST(d1 AS SIGNED), CAST(d2 AS SIGNED) FROM t1;

+------------------------+----------------------+----------------------+

| d1                     | CAST(d1 AS SIGNED)   | CAST(d2 AS SIGNED)   |

+------------------------+----------------------+----------------------+

| -100000000000000000000 | -9223372036854775808 | -9223372036854775808 |

|  100000000000000000000 |  9223372036854775807 |  9223372036854775807 |

+------------------------+----------------------+----------------------+

relates to

MCOL-4361 Replace pow(10.0, (double)scale) expressions with a static dictionary lookup.

MCOL-4648 CAST(UBIGINTNULL_inWideDecimal AS UNSIGNED) returns 0 or NULL

MCOL-641 Full DECIMAL support in ColumnStore

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