Delete IN (select id from columnstoreTable) not working

drop table if exists deleteTestInnoDB;
create table if not exists deleteTestInnoDB (
report_id int
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
insert into deleteTestInnoDB values (0),(1),(2),(3);
select * from deleteTestInnoDB;

drop table if exists deleteTestInnoDB2;
create table if not exists deleteTestInnoDB2 (
report_id int
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
insert into deleteTestInnoDB2 values (1),(2),(3),(4);
select * from deleteTestInnoDB2;

drop table if exists deleteTestColumnstore;
create table if not exists deleteTestColumnstore (
report_id int
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb4;
insert into deleteTestColumnstore values (1),(2),(3),(4);
select * from deleteTestColumnstore;

delete from deleteTestInnoDB where report_id in (select report_id from deleteTestColumnstore); – nothing is deleted!!! (In ETL: connection to ExeMgr was lost.)

delete from deleteTestInnoDB where report_id in (select report_id from deleteTestInnoDB2); – works
delete from deleteTestInnoDB where report_id in (1,2,3,4); – works
delete from deleteTestColumnstore where report_id in (select report_id from deleteTestInnoDB); – works