[MCOL-4514] DATE + INTERVAL a SECOND is not like in MariaDB - Jira

XML

Word

Printable

This is similar to MCOL-4420, however for VARCHAR input instead of DECIMAL input.

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(10)) ENGINE=MyISAM;

INSERT INTO t1 VALUES ('1.9');

SELECT TIMESTAMP'2001-01-01 00:00:00' +  INTERVAL a SECOND FROM t1;

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

| TIMESTAMP'2001-01-01 00:00:00' +  INTERVAL a SECOND |

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

| 2001-01-01 00:00:01.900000                          |

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

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a VARCHAR(10)) ENGINE=COLUMNSTORE;

INSERT INTO t1 VALUES ('1.9');

SELECT TIMESTAMP'2001-01-01 00:00:00' +  INTERVAL a SECOND FROM t1;

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

| TIMESTAMP'2001-01-01 00:00:00' +  INTERVAL a SECOND |

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

| 2001-01-01 00:00:01.000000                          |

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

Notice, unlike MyISAM, with ColumnStore the fractional part is set to zeros instead of '.900000'.

relates to

MCOL-4416 FROM_UNIXTIME() returns a bad result for DECIMAL input

MCOL-4418 SEC_TO_TIME() returns a wrong result for DECIMAL input

MCOL-4419 MAKETIME() returns a wrong result for DECIMAL input

MCOL-4420 DATE_ADD() returns a wrong result for DECIMAL input

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