|
This problem does not exists in develop-5 and is only repeatable in 6.x.
DROP TABLE IF EXISTS t1;
|
CREATE TABLE t1 (a INT)ENGINE=ColumnStore;
|
INSERT INTO t1 VALUES (1);
|
SELECT TIME_TO_SEC('10:50:40.9999') FROM t1;
|
+------------------------------+
|
| TIME_TO_SEC('10:50:40.9999') |
|
+------------------------------+
|
| 0.0000 |
|
+------------------------------+
|
Looks wrong. It should return this result:
SELECT TIME_TO_SEC('10:50:40.9999');
|
+------------------------------+
|
| TIME_TO_SEC('10:50:40.9999') |
|
+------------------------------+
|
| 39040.9999 |
|
+------------------------------+
|
|