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

Insert from view regression

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.5
    • Fix Version/s: 5.6.1
    • Component/s: None
    • Labels:
    • Sprint:
      2021-7

      Description

      Inserting into a Columnstore table from a view used to work in 1.2 and below. A customer noticed that in 5.x and above that it no longer functions. See this example:

      CREATE DATABASE monty;
      USE monty;
      CREATE TABLE foo (id INT, fname VARCHAR(20));
      INSERT INTO foo VALUES (1,'Greg');
      CREATE VIEW view_foo as SELECT * FROM foo;
      SELECT * FROM view_foo;
      CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore;
      INSERT INTO bar SELECT * FROM view_foo;
      


      – ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported.

      However, if we use the wrapper trick, it does work:

      INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t;
      


      – OK: 1 row affected

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              toddstoffel Todd Stoffel
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration