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

Group by fails on view with Columnstore engine

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 1.1.3-2, 1.1.7
    • Icebox
    • PrimProc
    • None

    Description

      Hi,

      The attached SQL shows a select statement that only produces the following error when executed on a view of a table using the columnstore engine:

      ERROR 1815 (HY000) at line 23: Internal error: IDB-2021: 'dt' is not in GROUP BY clause. All non-aggregate columns in the SELECT and ORDER BY clause must be in
      cluded in the GROUP BY clause.

      I came across this while using Metabase as this is how it produces aggregate queries.

      Attachments

        Activity

          People

            drrtuy Roman
            brynedwards Bryn Edwards
            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.