pingcap / pingcap/tidb

'&' in User level lock name will displayed as \u0026

Open
#34,470 1 comment 0 reactions 0 assignees View on GitHub
severity/minor sig/sql-infra type/bug
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.