MySQL 5.5 vs 5.6: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

I was building an index which was too long using MySQL 5.5. MySQL returned a WARNING 1071 (42000): Specified key was too long; max key length is 767 bytesWARNING 1071 (42000): Specified key was too long; max key length is 767 bytes The index got silently truncated. And, at least on the surface, everything worked. Continue reading →