[MCOL-1365] event insert into select from engince columnstore not working Created: 2018-04-24  Updated: 2021-01-17

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.1.4
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: patrice Assignee: Todd Stoffel (Inactive)
Resolution: Unresolved Votes: 1
Labels: 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;

    1. WORK
      create event insert_debug
      on schedule every 5 second
      do
      insert into toto select (1,2);
  1. DONT WORK
    create event insert_debug
    on schedule every 5 second
    do
    insert into toto
    select a,b from feed;

 Comments   
Comment by David Thompson (Inactive) [ 2018-04-25 ]

The default is for the event scheduler to be off, can you check:
show variables like 'event%';

Then enable, see: https://mariadb.com/kb/en/library/events/

If it is on and still not working let me know.

Comment by patrice [ 2018-04-25 ]


yes it is on, I have other update event running.

Comment by Daniel Lee (Inactive) [ 2018-04-25 ]

Can you post the definition for one of the working events?

Thanks.

Comment by patrice [ 2018-04-25 ]

That should work.

create event insert_debug
on schedule every 5 second
do
insert into toto select (1,2);

Comment by Daniel Lee (Inactive) [ 2018-04-25 ]

This event is was reported as not working in the ticket description. You said you have other update events running. Can you send me one that is running and working correct?

Thanks

Comment by patrice [ 2018-04-25 ]

Sorry for the confusion , I updated the with what works and what dont, the one not using a columnstore table works. the one using table feed did not.

Comment by Daniel Lee (Inactive) [ 2018-04-25 ]

I verified that the event works when the source table is a misaim or innodb table or "select 1 2".

When the source table (feed) is a columnstore table, although the event is executed, no rows are inserted.

Comment by patrice [ 2018-07-26 ]

Any update on this ? I thought this was verified by Daniel Leed in the last comment ?

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