[MCOL-4512] Triggers + INSERT..SELECT might crash MDB Created: 2021-01-22  Updated: 2021-01-25

Status: Open
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 6.1.1
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: Roman Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

The scenario crashes the server:

create table mcs1 (i bigint)engine=columnstore;
 
create table mcs2 (i bigint)engine=columnstore;
 
create view v1 as select i from mcs1;
 
CREATE TRIGGER some AFTER INSERT ON mcs1 FOR EACH ROW  UPDATE mcs2 SET i = i+1;
 
insert into mcs1 select * from mcs2;


Generated at Thu Feb 08 02:50:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.