Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2.5
    • 5.6.1
    • None
    • 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

            Transition Time In Source Status Execution Times
            Alexander Barkov made transition -
            Open In Progress
            9d 17h 7m 1
            Alexander Barkov made transition -
            In Progress In Review
            13s 1
            Gagan Goel (Inactive) made transition -
            In Review In Testing
            1h 12m 1
            Daniel Lee (Inactive) made transition -
            In Testing Closed
            1h 51m 1

            People

              dleeyh Daniel Lee (Inactive)
              toddstoffel Todd Stoffel (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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