Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
22.08.2
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]>
|