Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Unresolved
-
1.1.4
-
None
-
None
Description
Hi,
I am trying to use event to update a table using insert into select from a columnstore table, and nothing is happening. if doing a classic insert it work or if the select is not using columnstore engine. Sample code to reproduce is below.
drop table toto;
create table toto (a integer,b integer) Engine=Columnstore;
create table feed (a integer,b integer) Engine=Columnstore;
insert into feed(a,b) values (100,200),(10,20),(1000,2000);
drop event insert_debug;
-
- WORK
create event insert_debug
on schedule every 5 second
do
insert into toto select (1,2);
- WORK
- DONT WORK
create event insert_debug
on schedule every 5 second
do
insert into toto
select a,b from feed;