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

INT representation translating TIMESTAMP to INT is inconsistent with MDB's

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • Icebox
    • None
    • None

    Description

      Consider the example

      MariaDB [test]> create table cs2(i timestamp)engine=columnstore;
      Query OK, 0 rows affected (0.353 sec)
       
      MariaDB [test]> insert into cs2 values ('2022-05-21 00:00:00');
      Query OK, 1 row affected (0.144 sec)
       
      MariaDB [test]> select * from cs2;
      +---------------------+
      | i                   |
      +---------------------+
      | 2022-05-21 00:00:00 |
      +---------------------+
      1 row in set (0.043 sec)
       
      MariaDB [test]> select i + 1  from cs2;
      +------------------+
      | i + 1            |
      +------------------+
      | 1733391758131201 |
      +------------------+
      

      MariaDB [test]> create table t1(i timestamp);
      Query OK, 0 rows affected (0.011 sec)
       
      MariaDB [test]> insert into t1  values ('2022-05-21 00:00:00');
      Query OK, 1 row affected (0.002 sec)
       
      MariaDB [test]> select * from t1;
      +---------------------+
      | i                   |
      +---------------------+
      | 2022-05-21 00:00:00 |
      +---------------------+
      1 row in set (0.000 sec)
       
      MariaDB [test]> select i+1 from t1;
      +----------------+
      | i+1            |
      +----------------+
      | 20220521000001 |
      +----------------+
      1 row in set (0.000 sec)
       
      MariaDB [test]> 
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            drrtuy Roman
            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.