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

MariaDB Columnstore: Views with null-replaced timestamps yield incorrect query results

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 22.08.2, 6.4.2, 23.02.3
    • 23.10.2
    • None
    • None
    • MariaDB 10.6.9 CS 6.4.3 RHEL 8
    • 2024-1

    Description

      We plan to store null in the timestamps, and use a Pentaho-specific view to null-replace them.

      When trying this out, we found (again) a discrepancy between InnoDB and Columnstore:
      what should work (and does in InnoDB) yields incorrect query results in Columnstore.

      In detail: using YEAR(...) = 1970 in a WHERE condition on a null-replaced date yields no rows in case of Columstore-tables-based view, but the correct result set when the view is based on a InnoDB table.
      See the attached SQL.

      Attachments

        Activity

          People

            denis0x0D Denis Khalikov
            aeae81 andreas eschbacher
            Votes:
            1 Vote for this issue
            Watchers:
            4 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.