Grouper Developers Forum

[David Langenberg <>]

----- "Chris Hyzer" 
<>
 wrote:

> If we are supporting all databases, then MySQL surely should be
> supported, and it still doesn’t work. The problem with the schema init
> still happens with hib3 and mysql5. I think it is a mysql problem:
> 
> 
> 
> create table grouper_attributes (id varchar(128) not null, group_id
> varchar(128), field_name varchar(32) not null, value varchar(1024) not
> null, primary key (id), unique (group_id, field_name, value))
> 
> 
> 
> Specified key was too long; max key length is 767 bytes
> 
> 
> 
> http://bugs.mysql.com/bug.php?id=4541
> 
> 
> 
> Can we do one of two things:
> 
> 
> 
> 1. Change the grouper_attributes.value so that it is not in the unique
> index with group_id and name? With all three it allows a group to have
> two attributes with the same name, do we have a use case for that?
> 
> 2. –or- Make the size of that column 766. If someone wanted to
> increase it, that is probably easier than having the schemaExport fail
> for mysql users and having to wonder what to do
> 

There was also a suggestion for a workaround in the bug report to add a 
column containing a hash (MD5/SHA1/etc) of the value, then applying the 
unique constraint on group_id, field_name, value_hash.

Dave

-- 
***********************************************************
David Langenberg
Network Based Services
The University of Chicago
***********************************************************