Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-6173

From unixtime function fails with 11.8

    XMLWordPrintable

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

          Activity

            People

              kristina Kristina Pavlova
              tturenko Timofey Turenko
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.