[Bug]: table with fulltext index ,delete from table where xxx failed

[tom-csf]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

2.0-dev

Commit ID

b574c10

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Expected Behavior

No response

Steps to Reproduce

load tpch 1g data to tpch_1g database
create table nation3 like nation;
insert into nation3 select * from nation;
set experimental_fulltext_index=1;
create fulltext index fdx9 on nation3(N_COMMENT);
delete from nation3 where n_nationkey = 10;

Additional information

https://shanghai.idc.matrixorigin.cn:30001/explore?panes=%7B%22O2c%22:%7B%22datasource%22:%22loki%22,%22queries%22:%5B%7B%22refId%22:%22A%22,%22expr%22:%22%7Bnamespace%3D%5C%22mo-chaos-b574c10-202411181405%5C%22%7D%20%7C%3D%20%60anic%20this%20error%20should%20not%20be%20logged%60%22,%22queryType%22:%22range%22,%22datasource%22:%7B%22type%22:%22loki%22,%22uid%22:%22loki%22%7D,%22editorMode%22:%22builder%22%7D%5D,%22range%22:%7B%22from%22:%221731919813000%22,%22to%22:%221731919933000%22%7D%7D%7D&schemaVersion=1&orgId=1

[cpegeric]

[jiangxinmeng1]

The type of primary key vector in delete batch doesn't match the index table. The primary key is bigint unsign, while the pk in delete batch is int

the Table Scan result is correct, primary key is bigint unsign

It looks like the primary key of original table. The type and value is the same as the original pk.

[XuPeng-SH]

@cpegeric It looks like the pk type used for the secondary index table deletion is incorrectly using the pk type of the original table.

[cpegeric]

@XuPeng-SH I am trying to join the source pk id (INT) with doc_id (INT).. I didn't use __mo_fake_pk_col to delete.

[tom-csf]

2.0-dev分支验证ok

[Ariznawlll]

testing

[Ariznawlll]

2.0-dev: 4b6c0c1

测试case：
load tpch 1g data to tpch_1g database
create table nation3 like nation;
insert into nation3 select * from nation;
set experimental_fulltext_index=1;
create fulltext index fdx9 on nation3(N_COMMENT);
delete from nation3 where n_nationkey = 10;

[Ariznawlll]

main测试通过