Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
6.1.1
Description
TIME_TO_SEC() gives unexpected results for seconds having decimals
|
CREATE TABLE t1(col TIME(3))ENGINE=Columnstore; |
INSERT INTO t1 VALUES('00:00:40.991'); |
SELECT TIME_TO_SEC('00:00:40.991') FROM t1;
|
+-----------------------------+
|
| TIME_TO_SEC('00:00:40.991') |
|
+-----------------------------+
|
| 0.000 |
|
+-----------------------------+
|
SELECT TIME_TO_SEC('00:00:40.99') FROM t1;
|
+-----------------------------+
|
| TIME_TO_SEC('00:00:40.99') |
|
+-----------------------------+
|
| 40.99 |
|
+-----------------------------+
|
SELECT col, TIME_TO_SEC(col) FROM t1;
|
+--------------+------------------+
|
| col | TIME_TO_SEC(col) |
|
+--------------+------------------+
|
| 00:00:40.991 | 40.000 |
|
+--------------+------------------+
|
This is a regression.
Artifacts: https://cspkg.s3.amazonaws.com/index.html?prefix=develop/cron/1175
Attachments
Issue Links
- relates to
-
MCOL-4743 Regression: TIME_TO_SEC(const_expr) erroneosly returns 0
- Closed