-
Notifications
You must be signed in to change notification settings - Fork 246
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
SQL issue-[Script issue]: Specified key was too long; max key length is 3072 bytes #356
Comments
Thanks for contribute @huan11 . |
@NickNYU yes, UNIQUE KEY is too long which caused the issue.
|
Awesome!! that's reasonable Please send a Pull Request according to this question, thanks The basic idea of the varchar length is a draft thought when I was defining the table, not a big deal. It is just in Ant Group we leverage OceanBase as default DB, and seems like OB has a high toleration than traditional DBs. |
@NickNYU PR have been raised : ) |
PR has been merged, thx for contribution @huan11 |
Describe the bug
Env: MySQL version: Server version: 8.0.37 MySQL Community Server - GPL
Scripts: https://github.com/sofastack/sofa-registry/blob/master/create_table.sql
Expected behavior
Script shld be work well.
Actual behavior
When follow the guide (https://www.sofastack.tech/projects/sofa-registry/server-quick-start/ ), it failed at '2.启动 registry-integration' Step.
how to fix
reduce the width of column data_center and column remote_data_center. (change 512 to 255)
Environment
Env: MySQL version: Server version: 8.0.37 MySQL Community Server - GPL
The text was updated successfully, but these errors were encountered: