[MCOL-4231] INSERT IGNORE with multiple rows fails Created: 2020-08-05  Updated: 2023-10-26  Resolved: 2023-10-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: susil.behera Assignee: Unassigned
Resolution: Won't Do Votes: 0
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
Generated at Thu Feb 08 02:48:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.