[Bug]: REPLACE INTO SELECT not supported with table has fulltext/vector index

[cpegeric]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

d662b64

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

[aunjgr]

replace into c select * from (values row(1,1,'[1,2,3]'));

is not a supported syntax in MO. You can write

replace into c values(1,1,'[1,2,3]');

instead.

[cpegeric]

[XuPeng-SH]

should be fixed.
@Ariznawlll

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