Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
--- /usr/share/mysql-test/plugin/columnstore/columnstore/basic/r/mcs247_from_unixtime_funtion2.result 2026-06-09 19:36:12.000000000 +0200
|
+++ /usr/share/mysql-test/plugin/columnstore/columnstore/basic/r/mcs247_from_unixtime_funtion2.reject 2026-06-10 02:28:47.022184739 +0200
|
@@ -39,11 +39,11 @@
|
SELECT t1_INT, FROM_UNIXTIME(t1_INT) FROM t1 ORDER BY 1;
|
t1_INT FROM_UNIXTIME(t1_INT)
|
-7299 NULL
|
-103 EXPECTED_DATETIME_103
|
-9913 EXPECTED_DATETIME_9913
|
+103 1970-01-01 01:01:43
|
+9913 1970-01-01 03:45:13
|
SELECT t1_DECIMAL, FROM_UNIXTIME(t1_DECIMAL) FROM t1 ORDER BY 1;
|
t1_DECIMAL FROM_UNIXTIME(t1_DECIMAL)
|
-111.99000 EXPECTED_DATETIME_111.99000
|
-1234.56990 EXPECTED_DATETIME_1234.56990
|
-98765.43210 EXPECTED_DATETIME_98765.43210
|
+111.99000 1970-01-01 01:01:51.99000
|
+1234.56990 1970-01-01 01:20:34.56990
|
+98765.43210 1970-01-02 04:26:05.43210
|
DROP DATABASE mcs247_db2;
|
|
Manual check: different results with Columnstore and InnoDB
MariaDB [(none)]> SET time_zone='+00:00';
|
Query OK, 0 rows affected (0.000 sec)
|
|
|
MariaDB [(none)]> CREATE DATABASE mcs247_db2;
|
Query OK, 1 row affected (0.000 sec)
|
|
|
MariaDB [(none)]> USE mcs247_db2;
|
Database changed
|
MariaDB [mcs247_db2]> CREATE TABLE t1 (t1_INT INT, t1_DECIMAL DECIMAL(12,5), t1_TEXT TEXT, t1_DATE DATE, t1_TIME TIME )ENGINE=Columnstore;
|
Query OK, 0 rows affected (0.202 sec)
|
|
|
MariaDB [mcs247_db2]> CREATE TABLE t2 ( t1_INT INT, t1_DECIMAL DECIMAL(12,5), t1_TEXT TEXT, t1_DATE DATE, t1_TIME TIME );
|
Query OK, 0 rows affected (0.005 sec)
|
|
|
MariaDB [mcs247_db2]> INSERT INTO t1 VALUES(103, 1234.5699, repeat('o', 5), '1997-12-12', '22:12:02');
|
Query OK, 1 row affected (0.331 sec)
|
|
|
MariaDB [mcs247_db2]> INSERT INTO t2 VALUES(103, 1234.5699, repeat('o', 5), '1997-12-12', '22:12:02');
|
Query OK, 1 row affected (0.001 sec)
|
|
|
MariaDB [mcs247_db2]> INSERT INTO t1 VALUES(-7299, 111.99, repeat('p', 5), '2001-1-1', '23:59:59');
|
Query OK, 1 row affected (0.089 sec)
|
|
|
MariaDB [mcs247_db2]> INSERT INTO t2 VALUES(-7299, 111.99, repeat('p', 5), '2001-1-1', '23:59:59');
|
Query OK, 1 row affected (0.001 sec)
|
|
|
MariaDB [mcs247_db2]> INSERT INTO t1 VALUES(9913, 98765.4321, repeat('q', 5), '09-12-11', '01:08:59');
|
Query OK, 1 row affected (0.089 sec)
|
|
|
MariaDB [mcs247_db2]> INSERT INTO t2 VALUES(9913, 98765.4321, repeat('q', 5), '09-12-11', '01:08:59');
|
Query OK, 1 row affected (0.001 sec)
|
|
|
MariaDB [mcs247_db2]> SELECT t1_INT, FROM_UNIXTIME(t1_INT) FROM t1 ORDER BY 1;
|
+--------+-----------------------+
|
| t1_INT | FROM_UNIXTIME(t1_INT) |
|
+--------+-----------------------+
|
| -7299 | NULL |
|
| 103 | 1970-01-01 01:01:43 |
|
| 9913 | 1970-01-01 03:45:13 |
|
+--------+-----------------------+
|
3 rows in set (0.108 sec)
|
|
|
MariaDB [mcs247_db2]> SELECT t1_INT, FROM_UNIXTIME(t1_INT) FROM t2 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 |
|
+--------+-----------------------+
|
3 rows in set (0.000 sec)
|
|