AUTO_INCREMENT 自增id 改为 AUTO_RANDOM 报错

TiDBer_lVKhiLUB · 2023 年6 月 30 日 06:13

mysql> alter table approval modify id BIGINT AUTO_RANDOM
→ ;
8200 - Unsupported modify column: this column has primary key flag
mysql> show variables like ‘tidb_allow_remove_auto_inc’;
±---------------------------±------+
| Variable_name | Value |
±---------------------------±------+
| tidb_allow_remove_auto_inc | ON |
±---------------------------±------+
1 row in set (0.03 sec)

mysql> show create table approval;
±---------±-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±---------±-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| approval | CREATE TABLE approval (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘自增主键’,
uuid varchar(32) NOT NULL DEFAULT ‘’ COMMENT ‘uuid’,
name varchar(32) NOT NULL DEFAULT ‘’ COMMENT ‘工单名称’,
status tinyint(4) NOT NULL COMMENT ‘1-待审核；2-通过；3-驳回；4-撤销’,
level tinyint(4) NOT NULL COMMENT ‘当前节点’,
approval_module_uuid varchar(32) NOT NULL COMMENT ‘审批模板uuid’,
approval_module_code varchar(32) NOT NULL DEFAULT ‘’ COMMENT ‘模板审批类型’,
approval_module_config text DEFAULT NULL COMMENT ‘审批配置模板快照’,
create_user_id bigint(20) NOT NULL COMMENT ‘创建人id’,
business_content text NOT NULL COMMENT ‘审批内容 json’,
create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
execute_content text DEFAULT NULL,
PRIMARY KEY (id) /*T![clustered_index] CLUSTERED */,
UNIQUE KEY uk_uuid (uuid),
KEY idx_create_user_id (create_user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=30001 COMMENT=‘审批主表’ |
±---------±----------------------------------------------------------------------------------------------------