[MCOL-4232] INSERT IGNORE is not ignoring NOT NULL constraint 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 should ignore the NOT NULL column constraint but on Columnstore it does not.

DROP TABLE IF EXISTS t1, t2;
CREATE TABLE t1(
c1 CHAR(5),
c2 CHAR(10) NOT NULL
)ENGINE=Columnstore;
INSERT IGNORE INTO t1 (c1) VALUES ('hello');
ERROR 1815 (HY000): Internal error: CAL0001: Insert Failed: IDB-4015: Column 'c2' cannot be null.

On Innodb -
INSERT IGNORE INTO t1 (c1) VALUES ('hello');
Query OK, 1 row affected, 1 warning (0.003 sec)

SHOW WARNINGS;
----------------------------------------------------

Level Code Message

----------------------------------------------------

Warning 1364 Field 'c2' doesn't have a default value

----------------------------------------------------
1 row in set (0.000 sec)

SELECT * FROM t1;
---------+

c1 c2

---------+

hello  

---------+
1 row in set (0.001 sec)
Generated at Thu Feb 08 02:48:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.