Grouper Developers Forum

[Chris Hyzer <>]

That is also an option, thanks.  I don’t see this issue in Jira, is there an 
issue number?
If we really care that it is unique, this might not work since multiple 
inputs can hash to the same value, so I would lean toward one of the previous 
options... but if those aren’t ok, then this would be better than now I guess

Thanks!
Chris

> -----Original Message-----
> From: David Langenberg 
> [mailto:]
> Sent: Thursday, March 06, 2008 1:17 PM
> To: Chris Hyzer
> Cc: Grouper Dev
> Subject: Re: [grouper-dev] changing lenght of attribute value column
>
>
> ----- "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
> ***********************************************************