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

INSERT IGNORE is incorrectly supported

    XMLWordPrintable

Details

    Description

      INSERT IGNORE performs insertion attempt for single row insert and results in "INSERT IGNORE is unsupported" for several rows insertion.

      Here's session that demonstrate problematiic behavior:

      MariaDB [(none)]> use test;
      Database changed
      MariaDB [test]> create table t(a int) engine =columnstore;
      Query OK, 0 rows affected (0.352 sec)
       
      MariaDB [test]> insert into t values (1),(2),(3);
      Query OK, 3 rows affected (0.201 sec)
      Records: 3  Duplicates: 0  Warnings: 0
       
      MariaDB [test]> insert ignore into t values (1);
      Query OK, 1 row affected (1.112 sec)
       
      MariaDB [test]> insert ignore into t values (1),(2);
      ERROR 1178 (42000): The storage engine for the table doesn't support IGNORE option in insert statement is not supported in Columnstore.
      MariaDB [test]>
      

      Attachments

        Activity

          People

            leonid.fedorov Leonid Fedorov
            sergey.zefirov Sergey Zefirov
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.