We're updating the issue view to help you get more done. 

MySQL 5.6 compatibility

Description

I ended up updating MySQL on my dev box to 5.6 by accident and found that our schema doesn't work as-is. I found myself running into a couple of max key length issues where the key length is limited to 767 bytes. We have a couple of indexed 1024byte fields though, for instance ca_occurrence_labels.name or ca_object_representations.original_filename.

According to the mysql doc there's no way around that 767byte limit. The weird thing is that it's been there since at least 5.1.

http://dev.mysql.com/doc/refman/5.1/en/create-index.html
http://dev.mysql.com/doc/refman/5.6/en/create-index.html

Environment

None

Activity

Show:
User known
June 24, 2013, 7:27 AM

Argh. There's no reason why we need the key so long. I believe they were saying the keys could be that long in InnoDb. Certainly it did work for a while. Could you revise the schema? I'm online this morning for now but won't be back on for a day or two.

Stefan Keidel
June 24, 2013, 7:55 AM

Okay, I just wanted to run this by you before messing with the schema.

Stefan Keidel
June 24, 2013, 9:07 AM

There's a pull request for this in GitHub.

The changes are quite substantial so I opened a pull request so you can at least take a look before we merge it.

Assignee

Stefan Keidel

Reporter

Stefan Keidel

Labels

None

Components

Fix versions

Affects versions

Priority

Major
Configure