[Bug]: cannot drop fulltext index with sql 'alter table table_name drop index index_name'.

[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

创建的时候带有fulltext index name，但是通过show create table查出来的table schema中并没有相关的fulltext index的name，通过alter table table_name drop index index_name删除的时候必须指定index的name，所以无法删除

Expected Behavior

No response

Steps to Reproduce

CREATE TABLE `fulltext_test01` (
  `col1` bigint DEFAULT NULL,
  `col2` int NOT NULL,
  `col3` varchar(200) DEFAULT NULL,
  `col4` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`col2`),
 FULLTEXT f01(`col3`) WITH PARSER ngram
);

alter table table_name drop index index_name;

Additional information

No response

[Ariznawlll]

main commit: e9a5458

测试步骤：

CREATE TABLE `fulltext_test01` (
`col1` bigint DEFAULT NULL,
`col2` int NOT NULL,
`col3` varchar(200) DEFAULT NULL,
`col4` varchar(200) DEFAULT NULL,
PRIMARY KEY (`col2`),
FULLTEXT f01(`col3`) WITH PARSER ngram
);
show create table fulltext_test01;
load data local infile '/Users/ariznawl/Downloads/zhwiki-20241201-pages-articles-multistream-index.txt' into table test.fulltext_test01 fields terminated by ':' ESCAPED BY '\t' lines terminated by '\n';
alter table fulltext_test01 drop index f01;
show create table fulltext_test01;

main测试通过✅

[Ariznawlll]

2.0-dev: 4477346

测试步骤：

CREATE TABLE `fulltext_test01` (
`col1` bigint DEFAULT NULL,
`col2` int NOT NULL,
`col3` varchar(200) DEFAULT NULL,
`col4` varchar(200) DEFAULT NULL,
PRIMARY KEY (`col2`),
FULLTEXT f01(`col3`) WITH PARSER ngram
);
show create table fulltext_test01;
load data local infile '/Users/ariznawl/Downloads/zhwiki-20241201-pages-articles-multistream-index.txt' into table test.fulltext_test01 fields terminated by ':' ESCAPED BY '\t' lines terminated by '\n';
alter table fulltext_test01 drop index f01;
show create table fulltext_test01;

2.0-dev 测试通过✅