[待回复] 手册中的将不可见索引转化为可见索引时报语法错误

180 2 2025-8-15 15:15

手册中的位置：https://greatsql.cn/docs/8.0.32- ... 2-2-4-dp-index.html

测试如下：
GreatSQL> show create table t1\G
*************************** 1. row ***************************
   Table: t1
Create Table: CREATE TABLE `t1` (
  `id` int NOT NULL,
  `name` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_name` (`name`) /*!80000 INVISIBLE */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1 row in set (0.00 sec)

GreatSQL> alter table t1 modify index idx_name visible;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index idx_name visible' at line 1
GreatSQL> \s
--------------
mysql  Ver 8.0.32-27 for Linux on x86_64 (GreatSQL, Release 27, Revision aa66a385910)

Connection id:       24
Current database:    demo1
Current user:          root@localhost
SSL:                   Not in use
Current pager:       stdout
Using outfile:       ''
Using delimiter:       ;
Server version:       8.0.32-27 GreatSQL, Release 27, Revision aa66a385910
Protocol version:    10
Connection:          Localhost via UNIX socket
Server characterset: utf8mb4
Db    characterset: utf8mb4
Client characterset: utf8mb4
Conn.  characterset: utf8mb4
UNIX socket:          /tmp/mysql.sock
Uptime:                24 min 32 sec

Threads: 2  Questions: 6775  Slow queries: 6  Opens: 376  Flush tables: 3  Open tables: 272  Queries per second avg: 4.602
--------------

GreatSQL> alter table t1 alter index idx_name visible;
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

GreatSQL>
GreatSQL> show create table t1\G
*************************** 1. row ***************************
   Table: t1
Create Table: CREATE TABLE `t1` (
  `id` int NOT NULL,
  `name` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
1 row in set (0.00 sec)

测试, GreatSQL

全部回复(2)

只看楼主