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 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)