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

Assignee

Stefan Keidel

Reporter

Stefan Keidel

Labels

None

Components

Fix versions

Affects versions

Priority

Major
Configure