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

MariaDB Columnstore all versions: update and inserts behave differently on 0000-00-00 00:00:00 datetime

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 23.02.3, 23.10.0
    • 23.10.2
    • None
    • Tested on 2 Systems:
      1.) MariaDB 10.5.13 RHEL 8.5
      2.) MariaDB 10.3.16 CentOS 7.6
    • 2024-1

    Description

      Both on EBI03 (MariaDB 10.5.13) and EBI01 (MariaDB 10.3.16) the following bug was found on Columnstore tables:

      an insert into a datetime field of '0000-00-00 00:00:00' stores it this way,
      BUT an UPDATE on datetime field of '0000-00-00 00:00:00' stores it as <null>

      whereas on InnoDB tables in both cases '0000-00-00 00:00:00' is stored.

      See the attached SQL.

      Note: the SQL_MODE options STRICT_TRANS_TABLES, ALLOW_INVALID_DATES, NO_ZERO_DATE, NO_ZERO_IN_DATE might have an impact.
      However, on the same session with the same set of SQL_MODE settings, in any case both engines should behave the same.

      Attachments

        Issue Links

          Activity

            It is possible that this behavior will be affected by MCOL-271 which is in progress.
            This test case should be run after MCOL-271 is complete to see if it fixed it.

            David.Hall David Hall (Inactive) added a comment - It is possible that this behavior will be affected by MCOL-271 which is in progress. This test case should be run after MCOL-271 is complete to see if it fixed it.

            verified on develop/rl8-build-fix from 05 April 2024

            kirill.perov@mariadb.com Kirill Perov (Inactive) added a comment - verified on develop/rl8-build-fix from 05 April 2024

            People

              sergey.zefirov Sergey Zefirov
              aeae81 andreas eschbacher
              Kirill Perov Kirill Perov (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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