Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1365

event insert into select from engince columnstore not working

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 1.1.4
    • Icebox
    • 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;

        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;

      Attachments

        Activity

          People

            allen.herrera Allen Herrera
            allen.herrera Allen Herrera
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.