improve error message "key size too big for index"
--------------------------------------------------
Key: CORE-6354
URL: http://tracker.firebirdsql.org/browse/CORE-6354
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Reporter: Karol Bieniaszewski
Priority: Minor
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 CORE-2201 - "Vrinda Nayak 15/Nov/17 04:29 PM"
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
