[Bug]: REPLACE INTO SELECT not supported with table has primary key

[cpegeric]

Is there an existing issue for the same bug?

• [x] I have checked the existing issues.

Branch Name

main

Commit ID

d662b647ceacf6e78ccfba20573412e7e4f676b1

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Expected Behavior

Expect to be able to run the SQL below for update secondary index table.

REPLACE INTO __mo_index_secondary_0197786c-285f-70cb-9337-e484a3ff92c4(__mo_index_centroid_fk_version, __mo_index_centroid_fk_id, __mo_index_pri_col, __mo_index_centroid_fk_entry) with centroid as (select * from __mo_index_secondary_0197786c-285f-70bb-b277-2cef56da590a where __mo_index_centroid_version = 0), src as (select column_0 as id, cast(column_1 as vecf32(3)) as embed from (values row(2005,'[0.4532634, 0.7297859, 0.48885703]'), row(2009, '[0.68150306, 0.6950923, 0.16590895] '))) select __mo_index_centroid_version, __mo_index_centroid_id, id, embed from src centroidx('vector_l2_ops') join centroid using (__mo_index_centroid, embed);

Steps to Reproduce

create table c(a int primary key , b int, v vecf32(3));
replace into c select * from (values row(1,1,'[1,2,3]'));

Additional information

No response