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

32-bit timestamp values support

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 23.10.0
    • None
    • FuncExp
    • None

    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

              maxmether Max Mether
              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.