Debian Codegraph @

mysql-test/suite/innodb/r/parallel_read_kill.result

raw
1 #
2 # Bug#31016076 SELECT COUNT(*) ON LARGE TABLE HANG FOREVER EVEN AFTER CTRL+C
3 #
4 CREATE PROCEDURE populate_t1(IN BASE INT, IN SIZE INT)
5 BEGIN
6 DECLARE i INT DEFAULT BASE;
7 WHILE (i <= SIZE) DO
8 INSERT INTO t1(f2, f3) values (i, i);
9 SET i = i + 1;
10 END WHILE;
11 END|
12 CREATE TABLE t1(
13 f1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
14 f2 INT NOT NULL,
15 f3 INT NOT NULL)
16 ENGINE=INNODB;
17 # Create 150000 uncommitted rows
18 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
19 SET SESSION innodb_parallel_read_threads=2;
20 # Count committed rows
21 SET DEBUG_SYNC='parallel_read_wait_for_kill_query SIGNAL ready WAIT_FOR kill_query';
22 SELECT count(*) FROM t1;
23 SET DEBUG_SYNC='now WAIT_FOR ready';
24 SET DEBUG_SYNC='now SIGNAL kill_query';
25 # Killing select query
26 kill query @id;
27 # Should be 0 since the query should not be active
28 SELECT COUNT(*) FROM information_schema.processlist WHERE id = @id AND
29 INFO = 'SELECT count(*) FROM t1' AND state="executing";
30 COUNT(*)
31 0
32 Warnings:
33 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
34 ERROR 70100: Query execution was interrupted
35 # Cleanup
36 SET DEBUG_SYNC="RESET";
37 DROP PROCEDURE populate_t1;
38 DROP TABLE t1;