Skip to Content.
Sympa Menu

grouper-dev - changing lenght of attribute value column

Subject: Grouper Developers Forum

List archive

changing lenght of attribute value column

Chronological Thread 
  • From: Chris Hyzer <>
  • To: Grouper Dev <>
  • Subject: changing lenght of attribute value column
  • Date: Thu, 6 Mar 2008 13:05:15 -0500
  • Accept-language: en-US
  • Acceptlanguage: en-US

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


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


Im not having much luck searching the listservs since I know this has been discussed…


I search for mysql and don’t see the message, does the search work or am I not doing it right?





Archive powered by MHonArc 2.6.16.

Top of Page