[MCOL-4607] SEC_TO_TIME(wideDecimal) returns 0 in DECIMAL context - Jira

XML

Word

Printable

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a DECIMAL(30,1)) ENGINE=ColumnStore;

INSERT INTO t1 VALUES (1);

SELECT SEC_TO_TIME(a), SEC_TO_TIME(a)+0.0 FROM t1;

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

| SEC_TO_TIME(a) | SEC_TO_TIME(a)+0.0 |

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

| 00:00:01.0     |                0.0 |

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

Notice, SEC_TO_TIME(a) per se returned a correct result, but when I further put it into a DECIMAL plus operation, it returned 0.

The expected result is:

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a DECIMAL(30,1)) ENGINE=InnoDB;

INSERT INTO t1 VALUES (1);

SELECT SEC_TO_TIME(a), SEC_TO_TIME(a)+0.0 FROM t1;

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

| SEC_TO_TIME(a) | SEC_TO_TIME(a)+0.0 |

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

| 00:00:01.0     |                1.0 |

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

relates to

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

MCOL-641 Full DECIMAL support in ColumnStore

MCOL-4651 SEC_TO_TIME(hugePositiveDecimal) returns a negative time