Subject | Does 2.0.3.12981 version requires smaller instead or bigger index keys? ref/eDN6063215442 |
---|---|
Author | dennis |
Post date | 2007-12-12T08:01:44Z |
Hello to all
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?
Thank you in advance
Dennis
[Non-text portions of this message have been removed]
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?
Thank you in advance
Dennis
[Non-text portions of this message have been removed]