Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.6.1, 6.1.1
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a DECIMAL(10,1)) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES (-0.1); |
SELECT FROM_UNIXTIME(a) FROM t1; |
+-----------------------+
|
| FROM_UNIXTIME(a) |
|
+-----------------------+
|
| 1970-01-01 04:00:00.1 |
|
+-----------------------+
|
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a DECIMAL(10,1)) ENGINE=InnoDB; |
INSERT INTO t1 VALUES (-0.1); |
SELECT FROM_UNIXTIME(a) FROM t1; |
+------------------+
|
| FROM_UNIXTIME(a) |
|
+------------------+
|
| NULL |
|
+------------------+
|