Percona's GET LOCK implementation has a limitation on identifier name
Bug #1555503 reported by
Miguel Angel Nieto
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.6 |
Triaged
|
Wishlist
|
Unassigned | |||
5.7 |
Triaged
|
Wishlist
|
Unassigned |
Bug Description
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(
+------
| GET_LOCK(
+------
| 1 |
+------
Percona Server 5.6.29:
> select GET_LOCK(
ERROR 1059 (42000): Identifier name 'xxxxxxxxxxxxxx
We should remove it and make it "compatible" with upstream.
tags: | added: i66580 |
To post a comment you must log in.
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