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

Cannot change column collation from utf8mb4_general_ci to utf8mb4_general_ci #11052

Closed
tangenta opened this issue Jul 3, 2019 · 0 comments · Fixed by #11065
Closed

Cannot change column collation from utf8mb4_general_ci to utf8mb4_general_ci #11052

tangenta opened this issue Jul 3, 2019 · 0 comments · Fixed by #11065
Assignees
Labels
type/bug The issue is confirmed as a bug.

Comments

@tangenta
Copy link
Contributor

tangenta commented Jul 3, 2019

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?
    If possible, provide a recipe for reproducing the error.
create table t (b char(1) collate utf8mb4_general_ci);
alter table t modify b char(1) character set utf8mb4 collate utf8mb4_general_ci;
  1. What did you expect to see?
    In MySQL 5.7:
Query OK (0.059 sec)
  1. What did you see instead?
    In TiDB:
Error 1105: unsupported modify collate from utf8mb4_general_ci to utf8mb4_bin
  1. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?
+--------------------------------------------------------------------------+
| tidb_version()                                                           |
+--------------------------------------------------------------------------+
| Release Version: v3.0.0-rc.1-271-gf56ef0064                              |
| Git Commit Hash: f56ef00649ec388b1ac3989f8009442f3be4e299                |
| Git Branch: master                                                       |
| UTC Build Time: 2019-07-03 08:47:32                                      |
| GoVersion: go version go1.12.5 linux/amd64                               |
| Race Enabled: false                                                      |
| TiKV Min Version: 2.1.0-alpha.1-ff3dd160846b7d1aed9079c389fc188f7f5ea13e |
| Check Table Before Drop: false                                           |
+--------------------------------------------------------------------------+
@tangenta tangenta added the type/bug The issue is confirmed as a bug. label Jul 3, 2019
@tangenta tangenta self-assigned this Jul 3, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant