5.6.29-log MySQL Community Server:
slave1 [localhost] {msandbox} ((none)) > select GET_LOCK(repeat('x', 195), 1);
+-------------------------------+
| GET_LOCK(repeat('x', 195), 1) |
+-------------------------------+
| 1 |
+-------------------------------+
1 row in set (0.00 sec)
5.6.29 Percona Server:
mysql [localhost] {msandbox} ((none)) > select GET_LOCK(repeat('x', 195), 1);
ERROR 1059 (42000): Identifier name 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' is too long
5.7.10 MySQL Community Server:
mysql [localhost] {msandbox} ((none)) > select GET_LOCK(repeat('x', 195), 1);
ERROR 3057 (42000): Incorrect user-level lock name 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'.
5.7.10-3 Percona Server :
mysql [localhost] {msandbox} ((none)) > select GET_LOCK(repeat('x', 195), 1);
ERROR 3057 (42000): Incorrect user-level lock name 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'.
5.6.29-log MySQL Community Server: repeat( 'x', 195), 1); ------- ------- ------- ----+ repeat( 'x', 195), 1) | ------- ------- ------- ----+ ------- ------- ------- ----+
slave1 [localhost] {msandbox} ((none)) > select GET_LOCK(
+------
| GET_LOCK(
+------
| 1 |
+------
1 row in set (0.00 sec)
5.6.29 Percona Server: repeat( 'x', 195), 1); xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxx' is too long
mysql [localhost] {msandbox} ((none)) > select GET_LOCK(
ERROR 1059 (42000): Identifier name 'xxxxxxxxxxxxxx
5.7.10 MySQL Community Server: repeat( 'x', 195), 1); xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxx' .
mysql [localhost] {msandbox} ((none)) > select GET_LOCK(
ERROR 3057 (42000): Incorrect user-level lock name 'xxxxxxxxxxxxxx
5.7.10-3 Percona Server : repeat( 'x', 195), 1); xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxxxx xxxxxxxxxxxxx' .
mysql [localhost] {msandbox} ((none)) > select GET_LOCK(
ERROR 3057 (42000): Incorrect user-level lock name 'xxxxxxxxxxxxxx