[Bug]: insert ignore values reported error Inconsistent with MySQL behavior

[heni02]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

85734e6

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

mo insert ignore values目前和mysql差异：
1: null约束报错，mysql不报错

2.外键约束报错，mysql不报错

3.超出类型值范围报错，mysql不报错

4.类型不匹配报错，mysql不报错

Expected Behavior

No response

Steps to Reproduce

1.
create table insert_ignore_04 (product_id INT NOT NULL AUTO_INCREMENT,product_name VARCHAR(255) NOT NULL,quantity_in_stock INT DEFAULT 0,price DECIMAL(10, 2) NOT NULL,PRIMARY KEY (product_id));
insert ignore into insert_ignore_04(product_name, price) VALUES('Laptop', 1200.00),('Monitor', 150.00),('Keyboard', NULL),('Mouse', 15.00);
insert ignore into insert_ignore_04(product_name, quantity_in_stock,price) VALUES(NULL, 5,1200.00),('board',6, NULL),('phone',NULL,1500.00);
select * from insert_ignore_04;

2.
create table parent_table(parent_id INT AUTO_INCREMENT PRIMARY KEY,parent_name VARCHAR(255) NOT NULL);
create table child_table(child_id INT AUTO_INCREMENT PRIMARY KEY,child_name VARCHAR(255) NOT NULL,parent_id INT,FOREIGN KEY (parent_id) REFERENCES parent_table(parent_id)
);
insert ignore into parent_table (parent_name) VALUES ('Parent 1'), ('Parent 2'), ('Parent 3');
insert ignore into child_table (child_name, parent_id) VALUES('Child 1', 1),('Child 2', 2),('Child 3', 4),('Child 4', 1);

3.
create table insert_ignore_02(c1 int,c2 decimal(6,2),unique key(c1));
insert ignore into insert_ignore_02 values("abc",1234.56);

4.
create table insert_ignore_05(id TINYINT,created_at DATETIME);
insert ignore INTO insert_ignore_05 (id, created_at) VALUES(130, '2024-04-03 10:00:00'),(-129, '2024-04-03 11:00:00'),(100, '2024-04-03 12:00:00');

Additional information

No response

[ouyuanning]

语法不一致的部分暂不做处理

[ouyuanning]

语法不一致的部分暂不做处理

[ouyuanning]

语法不一致的部分暂不做处理

[ouyuanning]

锦赛统一处理吧。
近期先只处理性能问题就好了。语法的问题，可以留到后面的版本再处理

[jensenojs]

insert ignore需要重新实现

[jensenojs]

同上

[jensenojs]

同上

[jensenojs]

暂无进展

[jensenojs]

同上

[jensenojs]

处理

• [Tech Request]: when composite primary key has a column that is auto-incr, and this column does not specify a value, no dup check is needed #15809

[jensenojs]

同上

[jensenojs]

等重新设计方案

[jensenojs]

处理 moc#3351

[jensenojs]

无进展

[jensenojs]

no process

[jensenojs]

同上

[jensenojs]

同上

[jensenojs]

处理中移物联的insert pprof

[jensenojs]

处理中移物联的insert pprof

[jensenojs]

等on duplicate update的方案

[jensenojs]

等on dup的解决方案

[jensenojs]

not working on it

[jensenojs]

not working on it

[aunjgr]

#17500 完成后再看

[aunjgr]

not working on it today

[aunjgr]

#17500 完成后再看

[aunjgr]

@heni02 case有问题。

create table insert_ignore_02(c1 int,c2 decimal(6,2),unique key(c1));
insert ignore into insert_ignore_02 values("abc",1234.56);

int列给了一个字符串值"abc"