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

MariaDB Columnstore: incorrect query results on views grouping identical datetimes via TIMESTAMP keyword

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 22.08.2, 6.4.2, 23.02.3
    • Icebox
    • None
    • None
    • MariaDB 10.6.9 CS 6.4.3 RHEL 8

    Description

      Special Analyzer/Mondrian-generated queries using datetime column (containing only identical values) and grouping on the datetimes work on Columnstore tables, but not on views when they include a CASE WHEN for null replacement in the view definition.
      InnoDB works flawlessly.

      The problem was found out after dragging "Beladungszeit" (having only identical values) into an Analyzer report resulting in emptying out the whole report ("keine Berichtsdaten").

      Example-File attached.

      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.