| 1 |
CREATE TABLE bug51920 (i INT) ENGINE=InnoDB; |
| 2 |
INSERT INTO bug51920 VALUES (1); |
| 3 |
BEGIN; |
| 4 |
SELECT * FROM bug51920 FOR UPDATE; |
| 5 |
i |
| 6 |
1 |
| 7 |
UPDATE bug51920 SET i=2; |
| 8 |
SELECT ID FROM INFORMATION_SCHEMA.PROCESSLIST |
| 9 |
WHERE INFO="UPDATE bug51920 SET i=2" |
| 10 |
INTO @thread_id; |
| 11 |
Warnings: |
| 12 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 13 |
KILL @thread_id; |
| 14 |
Got one of the listed errors |
| 15 |
DROP TABLE bug51920; |