[MCOL-4618] FLOOR(-9999.0) returns a bad result - Jira

XML

Word

Printable

DROP TABLE IF EXISTS cs1;

CREATE TABLE cs1 (d6 DECIMAL(18,1))ENGINE=ColumnStore;

INSERT INTO cs1 VALUES (-9999.0);

SELECT  d6, FLOOR(d6) FROM cs1;

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

| d6      | FLOOR(d6) |

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

| -9999.0 |    -10000 |

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

Looks wrong. The expected result is:

DROP TABLE IF EXISTS cs1;

CREATE TABLE cs1 (d6 DECIMAL(18,1))ENGINE=InnoDB;

INSERT INTO cs1 VALUES (-9999.0);

SELECT  d6, FLOOR(d6) FROM cs1;

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

| d6      | FLOOR(d6) |

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

| -9999.0 |     -9999 |

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

blocks

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

relates to

MCOL-4653 CEIL(negativeNarrowDecimal) inside another function returns a wrong result

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