Hello!

I need to create an unique check on a table:
alter table GROUPS
add constraint UNIQUE_GROUP
unique ([NAME1], [NAME2])

This operation is not defined for system tables.
unsuccessful metadata update.
key size too big for index UNIQUE_GROUP.

Both name1 and 2 are of the following domain:
CREATE DOMAIN NAME AS
VARCHAR(40)
COLLATE EN_US;

Charset is ISO8859_1

It does not seem to me that 40 characters for a name is outrageously
large field size. Or is it?

I'm currently using triggers for the same functionality. However it
would be nice to use the feature intended exactly for this.

IIRC the limit was even lower on multi-byte character sets. Again IIRC
it was divided with max size - 3 times smaller in case of unicode_fss.
That's not enough for even one field sometimes.

And now for the point - is increasing this 'key size' being considered
in the near future?


BR,
Lauri
(complaining again :P )