Grouper Developers Forum

[Tom Barton <>]

Does this imply that an upgrade from v1.4.2 to v1.5.0 must include an 
export and reimport step, at least for MySql sites?

Tom

Chris Hyzer wrote:
> How does this sound to people?
>
> https://bugs.internet2.edu/jira/browse/GRP-321
>
> UUID length in the DB for grouper cols has been varchar 128.
> Not sure why this was chosen originally since we use standard 32 char uuids 
> (and sometimes with some dashes).
>
> Anyways, this is a problem for 2 reasons:
>
> 1. Mysql cant have a combined index size of 1024 (maybe less in some versions)
> 2. If you are doing in-memory databases, sometimes it treats varchars as chars
>
> In the table where we have an index larger than 1024, if we make the uuid's 
> smaller, it fixes the issue. Shilen, TomZ and I have been discussing making 
> those cols smaller (they are all new cols for v1.5). However, I think we 
> should make all uuid's smaller. The DDLutils currently will ignore existing 
> columns which are a different size than they should be.  So if we change the 
> definitions so that they are all size 40 (32 + 4 dashes + a little lee-way), 
> then if you have an existing schema it will leave it the way it is, and if 
> you are making a new schema, then it will make it size 40. If you are 
> importing from old to new, there shouldnt be any existing IDs larger than 40 
> so you will be all good.
>
> OK?
>
> Thanks!
>
> Regards,
> Chris