Comment 1 for bug 1555503

Revision history for this message
Przemek (pmalkowski) wrote :

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'.