DROP DATABASE IF EXISTS mcol_4607;
CREATE DATABASE mcol_4607;
USE mcol_4607;
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a DECIMAL(30,1)) ENGINE=ColumnStore;
INSERT INTO t1 VALUES (1), (0), (-1), (3661), (1234567890.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
00:00:00.0	0.0
-00:00:01.0	-1.0
01:01:01.0	10101.0
838:59:59.0	8385959.0
DROP DATABASE mcol_4607;