Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: Icebox
-
Component/s: DMLProc
-
Labels:None
-
Environment:Server version: 10.5.5-MariaDB MariaDB Server
Columnstore: 1.5.4-1
Description
INSERT IGNORE works with single row whereas with multiple row it fails.
MariaDB [test]> CREATE TABLE t1 (col1 INT) ENGINE=Columnstore;
Query OK, 0 rows affected (0.129 sec)
MariaDB [test]> INSERT IGNORE INTO t1 VALUES(1);
Query OK, 1 row affected (0.653 sec)
MariaDB [test]> INSERT IGNORE INTO t1 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