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

improve error message "key size too big for index" [CORE6354] #6595

Open
firebird-automations opened this issue Jul 3, 2020 · 0 comments
Open

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @livius2

Now when we try to create index on big e.g. VARCHAR(1000) field
we got an error
"key size too big for index XXX".

But this is not definitly true as it depend on page size.

Will be good if the message will be variable. It should depend of database page size.
As you know max index size depend on page size. This info should be included into error message.
If database page size is lower then FB max page size it should contain info like:

"key size too big for index XXX. Increase database page size to support bigger key sizes."

Now many users of Firebird use some tools which have default 4K page size. And they think that FB is so limited and they choose different database for use becaouse of such simple thing.
I know presonally 2 persons which was affected by this and i see also sample in FB tracker CORE2201 - "Vrinda Nayak 15/Nov/17 04:29 PM"

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

1 participant