|
Func_sec_to_time::getStrVal() does not handle the following argument data types (throws an exception)
- DATE
- DATETIME
- VARBINARY
- CLOB
- BLOB
- UFLOAT
- UDOUBLE
- TIME
- TIMESTAMP
- NUM_OF_COL_DATA_TYPE
- LONGDOUBLE
- STRINT
- UNDEFINED
An attempt to use an argument of these data types thows an error, e.g.:
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a DOUBLE UNSIGNED) ENGINE=ColumnStore;
|
INSERT INTO t1 VALUES (9.9);
|
SELECT CONCAT(SEC_TO_TIME(a)) FROM t1;
|
ERROR 1815 (HY000): Internal error: sec_to_time: datatype of udouble
|
UFLOAT and UDOUBLE should at least be fixed.
|