Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 5.6.1, 6.1.1
-
Fix Version/s: 22.08
-
Component/s: PrimProc
-
Labels:None
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 |
|
+------------------+
|