Percona's GET LOCK implementation has a limitation on identifier name

[Miguel Angel Nieto]

Percona's GET LOCK implementation has a limitation on identifier name that Oracle's MySQL or Percona Server 5.5 doesn't have.

Percona Server 5.6.17 (before our implementation)

5.6.17

> select GET_LOCK(repeat('x', 195), 1);
+-------------------------------+
| GET_LOCK(repeat('x', 195), 1) |
+-------------------------------+
| 1 |
+-------------------------------+

Percona Server 5.6.29:

> select GET_LOCK(repeat('x', 195), 1);
ERROR 1059 (42000): Identifier name 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' is too long

We should remove it and make it "compatible" with upstream.

[Przemek (pmalkowski)]

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

[Laurynas Biveinis (laurynas-biveinis)]

For 5.7, this is an upstream bug, please report it there and link here.

[Miguel Angel Nieto (miguelangelnieto)]

Reported and upstream bug associated with this one.

[Laurynas Biveinis (laurynas-biveinis)]

Based on upstream bug resolution, reclassifying this as a Wishlist bug "increase MDL object name length"

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2478