Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.4.1
    • 22.08.8
    • ExeMgr, PrimProc
    • None
    • centos Column store single instance
    • 2021-17, 2022-22

    Description

      Hi

      customer complain and report that this query fail:

       
       
       
       
      MariaDB [dmc_dg_ita_199]> SELECT
      -> ma_id, ma_desc, JSON_ARRAYAGG(DISTINCT cwc_na_id) ma_nas, JSON_ARRAYAGG(DISTINCT cwc_pd_id) ma_pds FROM
      -> (SELECT DISTINCT cwc_ma_id, cwc_na_id, cwc_pd_id FROM dmc_dg_ita_199.campagna_web_codice) CWC JOIN qcommon.marca ON ma_id = cwc_ma_id
      -> GROUP BY ma_id, ma_desc;
      
      

      with the follow errors:

      ERROR 1178 (42000): The storage engine for the table doesn't support Non supported aggregate type on the select clause

      Attachments

        Issue Links

          Activity

            There are no comments yet on this issue.

            People

              Andrey Andrey Piskunov (Inactive)
              massimo.disaro Massimo
              Roman Roman
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.