[MCOL-4637] select * into file from (select ... group by) produces spurious error Created: 2021-03-24  Updated: 2023-07-03

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: 23.10

Type: Bug Priority: Minor
Reporter: Gregory Dorman (Inactive) Assignee: Roman
Resolution: Unresolved Votes: 2
Labels: None

Issue Links:
Issue split
split from MCOL-3890 insert.. select * from (subselect) th... Closed

 Description   

drop table if exists `C2`;
CREATE TABLE `C2` (
`intc` int(6) DEFAULT NULL,
`id` int(11) NOT NULL,
`mm_prezzo` decimal(12,0) DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8;

select * into outfile '/tmp/result.dml' from (SELECT id,intc FROM C2 WHERE intc IN (201909) GROUP BY id,intc) as sel1;
ERROR 1815 (HY000): Internal error: IDB-2021: 'intc' is not in GROUP BY clause. All non-aggregate columns in the SELECT and ORDER BY clause must be included in the GROUP BY clause.
Generated at Thu Feb 08 02:51:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.