[Bug]: insert ignore select from table which 100000 rows reported ExpectedEOB

[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

env：mo standalone mode，default toml configuration
insert_ignore_06 is 100000rows，insert ignore insert_ignore_07 select from insert_ignore_06 reported ExpectedEOB

Expected Behavior

No response

Steps to Reproduce

create table insert_ignore_06(c1 int primary key auto_increment, c2 int);
insert into insert_ignore_06(c2) select result from generate_series(1,100000) g;
create table insert_ignore_07(c1 int primary key, c2 int);
insert into insert_ignore_07 values(20,45),(21,55),(1,45),(6,22),(5,1),(1000,222),(99999,19);
insert ignore into insert_ignore_07 select * from insert_ignore_06;

Additional information

No response

[ouyuanning]

当前的insert ignore是改写成insert on duplicate key ignore，
目前的实现是阻塞型的，大数据量下应该会有比较多问题。行健先帮看看吧

[ouyuanning]

跟这个 https://github.com/matrixorigin/MO-Cloud/issues/2956 一起考虑如何处理吧

[jensenojs]

not working on it

[jensenojs]

等文档评审

[jensenojs]

等文档评审

[jensenojs]

同上

[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]

#18406 上已解决

[aunjgr]

PR合进去就解决了