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

alter table failed for global table #5

Closed
actiontech-bot opened this issue Aug 24, 2017 · 0 comments
Closed

alter table failed for global table #5

actiontech-bot opened this issue Aug 24, 2017 · 0 comments

Comments

@actiontech-bot
Copy link
Member

actiontech-bot commented Aug 24, 2017

Raised by: @sevenFH

Steps:

  1. Make a global table called global_table
  2. Following queries will fail with error: ERROR 1064 (HY000): op table not in schema----GLOBAL_TABLE DROP|ADD|CHANGE
    1. alter table global_table drop name; //drop column
    2. alter table global_table add name1 char(10); //add column
    3. alter table global_table change name name char(15); //alter column type
    4. alter table global_table change name name1 varchar(10); //update column name
    5. alter table global_table drop index global_table_inx; //drop index
  3. Above queries succeed on sharding table
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants