--source ../include/have_columnstore.inc
--disable_warnings
DROP DATABASE IF EXISTS mcol_4607;
--enable_warnings
CREATE DATABASE mcol_4607;
USE mcol_4607;

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
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;

DROP DATABASE mcol_4607;