'&' in User level lock name will displayed as \u0026
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Bug Report
Please answer these questions before submitting your issue. Thanks!
### 1. Minimal reproduce step (Required)
1. select get_lock('!@#$%^&()_+',3600); in session A
2. select get_lock('!@#$%^&()_+',3600); in session B, session B will wait for the lock
3. select * from information_schema.data_lock_waits;
### 2. What did you expect to see? (Required)
lock name in KEY_INFO should be : "index_values":["!@#$%^&()_+"]}
### 3. What did you see instead (Required)
```sql
mysql> select * from information_schema.data_lock_waits;
+------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+------------------------+------------------------------------------------------------------+-----------------+
| KEY | KEY_INFO | TRX_ID | CURRENT_HOLDING_TRX_ID | SQL_DIGEST | SQL_DIGEST_TEXT |
+------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+------------------------+------------------------------------------------------------------+-----------------+
| 7480000000000000465F6980000000000000010121402324255E2628FF295F2B0000000000FA | {"db_id":3,"db_name":"mysql","table_id":70,"table_name":"advisory_locks","index_id":1,"index_name":"PRIMARY","index_values":["!@#$%^\u0026()_+"]} | 433082322883706884 | 433082321389223939 | 503fd5b0bd3ca476326b20cdb82e8088bb82376f9a3b81c2f1887bcf46bb3da6 | NULL |
+------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------+--------------------+------------------------+------------------------------------------------------------------+-----------------+
1 row in set (0.01 sec)
```
### 4. What is your TiDB version? (Required)
| Release Version: v6.1.0-alpha
Edition: Community
Git Commit Hash: 2c19f0a116143fd8a5cefc9dcb5f3d9c6c894372
Git Branch: heads/refs/tags/v6.1.0-alpha
UTC Build Time: 2022-05-05 14:58:11
GoVersion: go1.18
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
Contributor guide
Assessment
This issue has not been assessed yet.