[Feature Request]: Support insert ignore

[DanielZhangQD]

Is there an existing issue for the same feature request?

• I have checked the existing issues.

Is your feature request related to a problem?

MO does not support `insert ignore` now:

mysql> INSERT IGNORE INTO `test`.`storage` (`collecttime`,`value`,`account`,`interval`) VALUES ('2023-08-15 14:19:00',4790.699000,'test1',1);
ERROR 1064 (HY000): SQL parser error: You have an error in your SQL syntax; check the manual that corresponds to your MatrixOne server version for the right syntax to use. syntax error at line 1 column 13 near " IGNORE INTO `test`.`storage` (`collecttime`,`value`,`account`,`interval`) VALUES ('2023-08-15 14:19:00',4790.699000,'test1',1)";

### Describe the feature you'd like

MO supports `insert ignore`

### Describe implementation you've considered

_No response_

### Documentation, Adoption, Use Case, Migration Strategy

_No response_

### Additional information

_No response_

[domingozhang]

to be implemented in next release

[ouyuanning]

you can try SQL like:

INSERT INTO test.storage (collecttime,value,account,interval) VALUES ('2023-08-15 14:19:00',4790.699000,'test1',1) on duplicate key update account=account;

[DanielZhangQD]

you can try SQL like:

INSERT INTO test.storage (collecttime,value,account,interval) VALUES ('2023-08-15 14:19:00',4790.699000,'test1',1) on duplicate key update account=account;

@ouyuanning 试了一下可以满足我们需求，我们就用这个语句

[dengn]

Update in 1.2. For test and doc side, follow MySQL behavior, and performance should be equal to INSERT INTO.

[YANGGMM]

support insert ignore synatx in #15020

[heni02]

测试总结，目前和mysql差异：@dengn cc
1: null约束报错，mysql不报错

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

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

4.类型不匹配也报错

[heni02]

mo目前没有记录ignore的数据，mysql可以查到ingore的数据 ，@dengn cc

[ouyuanning]

https://github.com/matrixorigin/MO-Cloud/issues/2956

[ouyuanning]

@jensenojs 重新实现一下insert ignore吧。
1、应该要用另外的算子实现，不能走on duplicate key
2、应该就是类似先join一遍，检查通过的行才流入到insert算子 （这里我一时半会也想不出来要不要新增一个join类型）
3、先实现当前的语义，只是不走on duplicate key。 MySQL的语义更复杂，可以逐步来。

[jensenojs]

docs : https://github.com/matrixorigin/docs/pull/284

[aunjgr]

insert ignore语法本身已经支持。性能问题使用 #17500 继续跟踪。