github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/dml/insert/on_duplicate_ignore.sql (about)

     1  create table if not exists indup_01 (a int primary key, b int);
     2  
     3  insert into indup_01 values (1,1);
     4  insert into indup_01 values (1,2),(2,2) on duplicate key ignore;
     5  select * from indup_01;
     6  
     7  insert into indup_01 values (3,1),(3,2),(3,3) on duplicate key ignore;
     8  select * from indup_01;
     9  
    10  insert into indup_01 values (null,1),(null,2),(null,null) on duplicate key ignore;
    11  select * from indup_01;