[Bug]: Replace with duplicate key should not throw error

[ouyuanning]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

a3b2139

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Replace into ... with duplicate key will throw error in MO

Expected Behavior

No response

Steps to Reproduce

select mo_ctl('cn', 'task', 'disable');
drop database if exists db1;
create database db1;
use db1;
create table t1(a int primary key, b int);
replace into t1 values (1,1),(1,2);    --  mysql have no error,  insert one row.  mo throw error: 

--- mysql:
mysql> replace into t1 values (1,1),(1,2);
Query OK, 3 rows affected (0.00 sec)
Records: 2  Duplicates: 1  Warnings: 0

mysql> select * from t1;
+---+------+
| a | b    |
+---+------+
| 1 |    2 |
+---+------+
1 row in set (0.00 sec)


---- mo
mysql> create table t1(a int primary key, b int);
Query OK, 0 rows affected (0.02 sec)

mysql> replace into t1 values (1,1),(1,2);
ERROR 1062 (HY000): Duplicate entry '1' for key 'a'

Additional information

No response

[ouyuanning]

待高斌和龙冉确认排期

[ouyuanning]

后面辛苦龙冉处理吧

[aunjgr]

等下一个版本重构

[aunjgr]

等重构

[aunjgr]

之前經討論確認，MO的replace行爲是，如果新增數據本身主鍵衝突，則報錯。所以重構之後，還是會保持這個行爲。