Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-33302

Columnstore does not support 32-bit timestamps: CAL0001: MCS-2025: Data truncated for column

    XMLWordPrintable

Details

    Description

      bb-11.4-timestamp 53df87b27d9e0c0e7e5f2e2e7e5aabd86aa20bee

      MariaDB [test]> create table t (a timestamp) engine=Columnstore;
      Query OK, 0 rows affected (0.760 sec)
       
      MariaDB [test]> insert into t values ('2030-01-01 00:00:00');
      Query OK, 1 row affected (1.209 sec)
       
      MariaDB [test]> insert into t values ('2040-01-01 00:00:00');
      ERROR 1264 (22003): CAL0001: MCS-2025: Data truncated for column 'a'   
       
      MariaDB [test]> show warnings;
      +-------+------+-----------------------------------------------------+
      | Level | Code | Message                                             |
      +-------+------+-----------------------------------------------------+
      | Error | 1264 | CAL0001: MCS-2025: Data truncated for column 'a'    |
      | Error | 1036 | Table 't' is read only                              |
      +-------+------+-----------------------------------------------------+
      2 rows in set (0.000 sec)
       
      MariaDB [test]> insert into t values ('2038-01-01 00:00:00');
      Query OK, 1 row affected (0.125 sec)
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.