Details
-
Bug
-
Status: In Progress (View Workflow)
-
Major
-
Resolution: Unresolved
-
23.10.6
-
None
-
None
-
None
-
2025-9
Description
--- /usr/share/mariadb/mariadb-test/suite/columnstore/basic/r/mcs247_from_unixtime_funtion.result 2025-09-09 14:32:22.857051340 +0000
|
+++ /usr/share/mariadb/mariadb-test/suite/columnstore/basic/r/mcs247_from_unixtime_funtion.reject 2025-10-02 00:26:03.537687198 +0000
|
@@ -14,7 +14,9 @@
|
INSERT INTO t1 VALUES(9913, 98765.4321, repeat('q', 5), '09-12-11', '01:08:59');
|
SELECT FROM_UNIXTIME(0) FROM t1 LIMIT 1;
|
FROM_UNIXTIME(0)
|
-1970-01-01 00:00:00
|
+NULL
|
+Warnings:
|
+Warning 1292 Truncated incorrect unixtime value: '0.0'
|
SELECT FROM_UNIXTIME(-1) FROM t1 LIMIT 1;
|
FROM_UNIXTIME(-1)
|
NULL
|
@@ -42,11 +44,11 @@
|
SELECT t1_INT, FROM_UNIXTIME(t1_INT) FROM t1 ORDER BY 1;
|
t1_INT FROM_UNIXTIME(t1_INT)
|
-7299 NULL
|
-103 1970-01-01 00:01:43
|
-9913 1970-01-01 02:45:13
|
+103 1970-08-06 10:44:40
|
+9913 1970-08-06 10:44:40
|
SELECT t1_DECIMAL, FROM_UNIXTIME(t1_DECIMAL) FROM t1 ORDER BY 1;
|
t1_DECIMAL FROM_UNIXTIME(t1_DECIMAL)
|
-111.99000 1970-01-01 00:01:51.99000
|
-1234.56990 1970-01-01 00:20:34.56990
|
-98765.43210 1970-01-02 03:26:05.43210
|
+111.99000 1970-08-06 10:44:40.37167
|
+1234.56990 1970-08-06 10:44:40.37355
|
+98765.43210 1970-08-06 10:44:41.35554
|
DROP DATABASE mcs247_db;
|
|
Attachments
Issue Links
- blocks
-
MCOL-6003 Check columnstore against 11.8
-
- In Progress
-