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

GROUP BY on duplicate expressions using functions throws error "IDB-2001: ... is not in GROUP BY clause." on Columnstore

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 23.10
    • 23.10.1
    • MariaDB Server
    • MariaDB 10.5.18, Columnstore 5.6.8; RHEL 8.5
    • 2023-11

    Description

      The attached query throws the mentioned error when using Columnstore, but not when using InnoDB.
      Furthermore, using Columnstore, omitting the function calls also works.

      While this is for sure an unconventional query, this is generated by a third-party BI software, where we cannot influence how generation of the SQL statements is done.

      Attachments

        Activity

          People

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