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.

Sign up for GitHub

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

Jump to bottom

Improve ErrTooLongKey #41272

Closed
dveeden opened this issue Feb 10, 2023 · 0 comments · Fixed by #41270
Closed

Improve ErrTooLongKey #41272

dveeden opened this issue Feb 10, 2023 · 0 comments · Fixed by #41270
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@dveeden
Copy link
Contributor

dveeden commented Feb 10, 2023

Enhancement

This is a bad user experience as the index prefix is specified in characters, but the limit in the error message is in bytes.

Here 1000 characters is 4000 bytes as UTF-8 takes up to 4 bytes per character.

sql> CREATE TABLE t1(id int primary key, c1 text, key(c1(1000)));
ERROR: 1071 (42000): Specified key was too long; max key length is 3072 bytes
@dveeden dveeden added the type/enhancement The issue or PR belongs to an enhancement. label Feb 10, 2023
@dveeden dveeden mentioned this issue Feb 10, 2023
Merged
12 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

ddl: Improve ErrTooLongKey message dveeden/tidb
1 participant
@dveeden