Subject Re: [firebird-support] Does 2.0.3.12981 version requires smaller instead or bigger index keys? ref/eDN6063215442
Author Vlad Khorsun
> I was working with version 2.0.0.12748 and now with version 2.0.3.12981 the
> follow index cannot be creatred:
>
> CREATE INDEX CODES_IDX2 ON CODES (KEY_, RES_);
>
>
>
> The error message is:
>
> This operation is not defined for system tables.
>
> unsuccessful metadata update.
>
> key size exceeds implementation restriction for index "CODES_IDX2".
>
>
>
> Key_ and res_ fields are varchar(100),
>
>
>
> Character set: DEFAULT CHARACTER SET NONE
>
>
>
> What happen? Does 2.0.3.12981 version requires smaller instead or bigger
> index keys? Where am I wrong?

What is ODS and page size of your database ? (gstat -h will tell you)

Regards,
Vlad