Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: only one auto-increment column permitted(ret=-4016) #1956

Open
lyukun opened this issue May 9, 2024 · 0 comments
Open

[Bug]: only one auto-increment column permitted(ret=-4016) #1956

lyukun opened this issue May 9, 2024 · 0 comments
Assignees
Labels
type: bug Something isn't working

Comments

@lyukun
Copy link

lyukun commented May 9, 2024

【版本信息】
observer (OceanBase 4.2.2.0)

REVISION: 1-de6501cc7353c2ce882533e1379c96289918735d
BUILD_BRANCH: HEAD
BUILD_TIME: Dec 25 2023 15:25:59
BUILD_FLAGS: RelWithDebInfo
BUILD_INFO: jenkins-oceanbase_build_4_2_x_7u-B708

Copyright (c) 2011-present OceanBase Inc.

【复现语句】
create table obschema_t_jAGEm3(obschema_c_0_pH4WcWj bit(16) NOT NULL default b'1010110110111',obschema_c_1_AtBZz1 int(255) auto_increment NOT NULL,obschema_c_2_Ttxy68 varchar(200) NOT NULL default 'aEFGHI01',obschema_c_3_IQK decimal(20,10) NOT NULL default 0.20339070,obschema_c_4_YEF decimal(25,10) NOT NULL default 0.20349070, primary key(obschema_c_0_pH4WcWj,obschema_c_1_AtBZz1,obschema_c_2_Ttxy68,obschema_c_3_IQK),index obschema_i_0_Rchwghg(obschema_c_0_pH4WcWj,obschema_c_1_AtBZz1,obschema_c_2_Ttxy68,obschema_c_3_IQK),unique index obschema_i_1_uni_iY(obschema_c_0_pH4WcWj,obschema_c_3_IQK,obschema_c_4_YEF));

obclient [test]> alter table obschema_t_jAGEm3 change column obschema_c_1_AtBZz1 obschema_c_1_qSt7t3C int(255) auto_increment NOT NULL;
ERROR 4016 (HY000): Internal error

@lyukun lyukun added the type: bug Something isn't working label May 9, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type: bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant