Skip to Content.
Sympa Menu

grouper-dev - Re: [grouper-dev] changing lenght of attribute value column

Subject: Grouper Developers Forum

List archive

Re: [grouper-dev] changing lenght of attribute value column


Chronological Thread 
  • From: David Langenberg <>
  • To: Chris Hyzer <>
  • Cc: Grouper Dev <>
  • Subject: Re: [grouper-dev] changing lenght of attribute value column
  • Date: Thu, 6 Mar 2008 12:16:57 -0600 (CST)


----- "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
***********************************************************



Archive powered by MHonArc 2.6.16.

Top of Page