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 bytes

The index got silently truncated. And, at least on the surface, everything worked.

Now I had someone else using my script but on MySQL 5.6. Which returned an ERROR:

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

Turns out, this is intended behavior on MySQL 5.6:

• http://bugs.mysql.com/bug.php?id=68453

Filed under: computer, programming, index, mysql