[MCOL-5224] JSON_ARRAYAGG join failing Created: 2022-09-19  Updated: 2023-02-06  Resolved: 2022-11-01

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr, PrimProc
Affects Version/s: 6.4.1
Fix Version/s: 22.08.8

Type: New Feature Priority: Major
Reporter: Massimo Assignee: Andrey Piskunov (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

centos Column store single instance


Issue Links:
Duplicate
duplicates MCOL-5227 Implement JSON_ARRAYAGG Closed
is duplicated by MCOL-5227 Implement JSON_ARRAYAGG Closed
Sprint: 2021-17, 2022-22
Assigned for Review: Roman Roman

 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
Generated at Thu Feb 08 02:56:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.