[Bug]: Fulltext index query panic 'internal error: double operator'.

[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

场景一：

场景二：

Expected Behavior

execute successfully

Steps to Reproduce

场景一：
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('+Windows +(<"Photo" >defender)' in boolean mode);

场景二：
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`,`col4`) 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,col4) against ('+CC_BY +(<-1.0 >-SA-1.0)' in boolean mode);


test data file is huge, please contact me privately.

Additional information

No response

[cpegeric]

you cannot have Phrase search "" together with other operations. Invalid search string.

you cannot have double operator -< .... this is not permitted.

[Ariznawlll]

mysql> select git_version();
+---------------+
| git_version() |
+---------------+
| b43417f |
+---------------+
1 row in set (0.01 sec)

测试通过✅