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
 
-