【产品名称】
Oceanbase for mysql
【产品版本】
Ob 3.1.3,ODC 3.3.0
【问题描述】
创建表后,能通过ODC新增唯一索引失败
表SQL:
CREATE TABLE `staff` ( `staff_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘员工ID’, `staff_name` varchar(100) NOT NULL COMMENT ‘员工姓名’, `age` int(11) DEFAULT ‘0’ COMMENT ‘员工年龄’, `dept_id` bigint(20) NOT NULL COMMENT ‘部门ID’, `company_id` bigint(20) NOT NULL COMMENT ‘公司名称’, `email` varchar(255) NOT NULL COMMENT ‘邮箱地址’, `create_time` datetime NOT NULL COMMENT ‘创建时间’, `update_time` datetime NOT NULL COMMENT ‘更新时间’, `version` bigint(20) NOT NULL COMMENT ‘版本号’, PRIMARY KEY (`staff_id`) ) AUTO_INCREMENT = 1000001 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = COMPACT COMPRESSION = ‘zstd_1.3.8’ REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
创建索引SQL:
create unique index staff_name_index on `staff`(`staff_name`) global;
异常:
执行以下 SQL 失败
create unique index staff_name_index on `staff`(`staff_name`) global;
失
败原因:
ErrorCode = 5703, SQLState = HY000, Details = Add index failed