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