Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5.1, 5.6.1, 6.1.1
-
None
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a DECIMAL(10,1)) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES (1.1); |
SELECT SEC_TO_TIME(a) FROM t1; |
+----------------+
|
| SEC_TO_TIME(a) |
|
+----------------+
|
| 00:00:01.0 |
|
+----------------+
|
Looks wrong. The expected result is:
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a DECIMAL(10,1)) ENGINE=InnoDB; |
INSERT INTO t1 VALUES (1.1); |
SELECT SEC_TO_TIME(a) FROM t1; |
+----------------+
|
| SEC_TO_TIME(a) |
|
+----------------+
|
| 00:00:01.1 |
|
+----------------+
|
