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

MariaDB 10.5 Columnstore: a generated SQL statement for a Yellowfin view leads to an error when multiple COUNT(DISTINCT)s are present

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 5.5.2
    • N/A
    • N/A
    • None
    • Mariadb 10.5.10 RHEL 8.2 SC 5.5.2

    Description

      Scenario:

      YF view reads a DB-view (see EBI-733) that does a SELECT from a single table
      on user-hidden IDs, COUNT(DISTINCT)s are created for getting the metrics "Anzahl ..." (via a "simple" computed field using COUNTDISTINCT(...)) in the YF view (not "FREEHAND SQL")
      YF produces a SQL statement for the view-definition that countains multiple COUNT(DISTINCT...) statements
      an error message pops up due to a MariaDB error
      A single count(distinct) does not lead to an error.
      Commenting out the (some; which?) columns in the GROUP BY removes the error.

      Attachments

        Activity

          People

            Unassigned Unassigned
            aeae81 andreas eschbacher
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.