When binding SQL statements in Query Watch, SQL statements with quotation marks at the end do not take effect
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Bug Report
Query watch hopes to be compatible with the writing of "SQL TEXT EXACT TO 'select sleep(2);'"
### 1. Minimal reproduce step (Required)
mysql> select * from information_schema.runaway_watches;
Empty set (0.01 sec)
mysql> select * from information_schema.resource_groups;
+---------+------------+----------+-----------+-------------+------------+
| NAME | RU_PER_SEC | PRIORITY | BURSTABLE | QUERY_LIMIT | BACKGROUND |
+---------+------------+----------+-----------+-------------+------------+
| default | UNLIMITED | MEDIUM | YES | NULL | NULL |
+---------+------------+----------+-----------+-------------+------------+
1 row in set (0.00 sec)
mysql> QUERY WATCH ADD RESOURCE GROUP default ACTION KILL SQL TEXT EXACT TO 'select sleep(2);' ;
+----------+
| WATCH_ID |
+----------+
| 9 |
+----------+
1 row in set (0.01 sec)
mysql> select sleep(2);
+----------+
| sleep(2) |
+----------+
| 0 |
+----------+
1 row in set (2.01 sec)
mysql> QUERY WATCH ADD RESOURCE GROUP default ACTION KILL SQL TEXT EXACT TO 'select sleep(2)' ;
+----------+
| WATCH_ID |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)
mysql> select sleep(2);
ERROR 8254 (HY000): Quarantined and interrupted because of being in runaway watch list
mysql>
### 2. What did you expect to see? (Required)
mysql> QUERY WATCH ADD RESOURCE GROUP default ACTION KILL SQL TEXT EXACT TO 'select sleep(2);' ;
+----------+
| WATCH_ID |
+----------+
| 9 |
+----------+
1 row in set (0.01 sec)
mysql> select sleep(2);
ERROR 8254 (HY000): Quarantined and interrupted because of being in runaway watch list
### 3. What did you see instead (Required)
mysql> QUERY WATCH ADD RESOURCE GROUP default ACTION KILL SQL TEXT EXACT TO 'select sleep(2);' ;
+----------+
| WATCH_ID |
+----------+
| 9 |
+----------+
1 row in set (0.01 sec)
mysql> select sleep(2);
+----------+
| sleep(2) |
+----------+
| 0 |
+----------+
1 row in set (2.01 sec)
### 4. What is your TiDB version? (Required)
v8.5.1
Contributor guide
Assessment
This issue has not been assessed yet.