github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/dml/insert/on_duplicate_ignore.result (about) 1 create table if not exists indup_01 (a int primary key, b int); 2 insert into indup_01 values (1,1); 3 insert into indup_01 values (1,2),(2,2) on duplicate key ignore; 4 select * from indup_01; 5 a b 6 1 1 7 2 2 8 insert into indup_01 values (3,1),(3,2),(3,3) on duplicate key ignore; 9 select * from indup_01; 10 a b 11 1 1 12 2 2 13 3 1 14 insert into indup_01 values (null,1),(null,2),(null,null) on duplicate key ignore; 15 constraint violation: Column 'a' cannot be null 16 select * from indup_01; 17 a b 18 1 1 19 2 2 20 3 1