Index char limit error

                 Key: CORE-5752
             Project: Firebird Core
          Issue Type: Bug
          Components: Charsets/Collation
    Affects Versions: 3.0.3
         Environment: Windows
            Reporter: Reydy Valentin

When I want to create a index with two varchar(205) in utf8, firebird give me a 
error (key size exceeds implementation restriction for index).
But according to the documentation, normally the limit is 509 from this compute 
And for my is (8192 / 4 - 9) / 4 = 509 (Same the doc)

Exemple script for test this issue

-- Basic table
CREATE TABLE "table" (
    "id"     INTEGER NOT NULL,
    "fname"  VARCHAR(205) NOT NULL,
    "lname"  VARCHAR(205) NOT NULL,
    "fname2" VARCHAR(204) NOT NULL,
    "lname2" VARCHAR(204) NOT NULL

CREATE INDEX "idx_table_test1" ON "table" ("fname", "lname"); -- 410 : Fail
CREATE INDEX "idx_table_test2" ON "table" ("fname", "lname2"); -- 409 : Fail
CREATE INDEX "idx_table_test3" ON "table" ("fname2", "lname2"); -- 408 : Work

Why ?

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
For more information on JIRA, see:


Check out the vibrant tech community on one of the world's most
engaging tech sites,!
Firebird-Devel mailing list, web interface at

Reply via email to