Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 5.6.1, 6.1.1
-
Fix Version/s: 23.02
-
Component/s: PrimProc
-
Labels:None
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a DECIMAL(30,1)) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES (1); |
SELECT SEC_TO_TIME(a), SEC_TO_TIME(a)+0.0 FROM t1; |
+----------------+--------------------+
|
| SEC_TO_TIME(a) | SEC_TO_TIME(a)+0.0 |
|
+----------------+--------------------+
|
| 00:00:01.0 | 0.0 |
|
+----------------+--------------------+
|
Notice, SEC_TO_TIME(a) per se returned a correct result, but when I further put it into a DECIMAL plus operation, it returned 0.
The expected result is:
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a DECIMAL(30,1)) ENGINE=InnoDB; |
INSERT INTO t1 VALUES (1); |
SELECT SEC_TO_TIME(a), SEC_TO_TIME(a)+0.0 FROM t1; |
+----------------+--------------------+
|
| SEC_TO_TIME(a) | SEC_TO_TIME(a)+0.0 |
|
+----------------+--------------------+
|
| 00:00:01.0 | 1.0 |
|
+----------------+--------------------+
|