[MCOL-6088] alias: ERROR 1178 (42000): The storage engine for the table doesn't support MCS-2016: Non supported item on the GROUP BY list. - Jira

XML

Word

Printable

The following testcase throw:

CREATE TABLE `test2` (

  `id` INT UNSIGNED NOT NULL,

  `GBP` DOUBLE UNSIGNED NOT NULL,

  `cat_id` INT UNSIGNED NOT NULL,

  `cat_id_level_0` INT UNSIGNED NOT NULL

) ENGINE=Columnstore;

SELECT cat_id_level_0 AS entity_id, SUM(GBP) AS spend, cat_id_level_0 AS cat_id

FROM test2

GROUP BY cat_id;

throw
ERROR 1178 (42000): The storage engine for the table doesn't support MCS-2016: Non supported item 'cat_id' on the GROUP BY list.

since 23.10.2

Maybe a regression from ~~MCOL-4234~~ or ~~MCOL-4235~~

Expected:

Warning: #1052 Column 'cat_id' in group statement is ambiguous

relates to

MCOL-4234 ORDER BY clause if not included in the GROUP BY clause fails

MCOL-4235 Group By ... Order By NULL fails

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.