[Bug]: the result of fulltext index search is not correct.

[Ariznawlll]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

2b6ab7e

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

场景一：

（看起来搜索的是带有K的所有数据，没有把'Cath K'当作一个字符串来搜索 ）

场景二：

Expected Behavior

the result should be String which contains 'Cath K'

Steps to Reproduce

搜索表中第三列包含字符串Cath K的所有数据
set experimental_fulltext_index=1;
CREATE TABLE `fulltext_test` (
  `col1` bigint DEFAULT NULL,
  `col2` int NOT NULL,
  `col3` varchar(200) DEFAULT NULL,
  `col4` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`col2`),
 FULLTEXT(`col3`) WITH PARSER ngram
);
load data local infile '/Users/ariznawl/Downloads/zhwiki-20241201-pages-articles-multistream-index.txt' into table test.fulltext_test fields terminated by ':' ESCAPED BY '\t' lines terminated by '\n';

场景一：
select * from fulltext_test where match(col3) against('Cath K*' in boolean mode);

场景二：
 select * from fulltext_test where match(col3) against('+Windows +(<Photo Gallery >Defender)' in boolean mode);


test data file is huge, please contact me privately.

Additional information

No response