heni02 commented 5 months ago

Is there an existing issue for the same bug?

[X] I have checked the existing issues.

Branch Name

main

Commit ID

85734e607d12a7a34ac31f8cdc91e72d9eaf98e3

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

EXPECT RESULT是mysql的结果，ACTUAL RESULT是mo的结果

企业微信截图_26451731-12bf-4cc3-8faf-f08aee431c08

Expected Behavior

No response

Steps to Reproduce

create table insert_ignore_03(c1 int auto_increment primary key,c2 int,key(c2));
insert into insert_ignore_03(c2) values(2),(2),(5),(10),(12),(NULL);
insert ignore into insert_ignore_03(c2) values(7),(2),(5),(10),(12),(NULL);
select * from insert_ignore_03;
以上sql客户端执行可能不能复现，可以用mo-tester执行insert_ignore.sql
 ./run.sh -n -p  /Users/heni/matrixone/test/distributed/cases/dml/insert/insert_ignore.sql -m run

Additional information

No response

heni02 commented 5 months ago

同样ignore结果错误，偶现不是必现

企业微信截图_dc6f4d5f-be56-4db1-a890-578000aa8e2f

create table insert_ignore_01(c1 int not null auto_increment primary key,c2 varchar(10)); insert into insert_ignore_01(c2) values("a"),("b"),("c"),("d"); insert ignore into insert_ignore_01 values(3,"e"),(6,"f"),(1,"g"); insert ignore into insert_ignore_01(c2) values("h"),("g"),("k"); insert ignore into insert_ignore_01 values(NULL,NULL); select * from insert_ignore_01;

ouyuanning commented 5 months ago

辛苦锦赛先帮忙看看

jensenojs commented 5 months ago

重新设计insert ignore实现

jensenojs commented 5 months ago

正在编写文档

jensenojs commented 5 months ago

无进展

jensenojs commented 5 months ago

insert ignore需要重新实现