Debian Codegraph @

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

raw
1 use test;
2 drop table if exists t1;
3 create table t1 (id int primary key, value int, value2 int,
4 value3 int, index(value,value2)) engine=innodb;
5 insert into t1 values
6 (10,10,10,10),(11,11,11,11),(12,12,12,12),(13,13,13,13),(14,14,14,14),
7 (15,15,15,15),(16,16,16,16),(17,17,17,17),(18,18,18,18),(19,19,19,19),
8 (20,20,20,20);
9 use test;
10 start transaction with consistent snapshot;
11 use test;
12 CREATE PROCEDURE update_t1()
13 BEGIN
14 DECLARE i INT DEFAULT 1;
15 while (i <= 28000) DO
16 update test.t1 set value2=value2+1, value3=value3+1 where id=12;
17 SET i = i + 1;
18 END WHILE;
19 END|
20 set autocommit=0;
21 CALL update_t1();
22 select * from t1;
23 id value value2 value3
24 10 10 10 10
25 11 11 11 11
26 12 12 28012 28012
27 13 13 13 13
28 14 14 14 14
29 15 15 15 15
30 16 16 16 16
31 17 17 17 17
32 18 18 18 18
33 19 19 19 19
34 20 20 20 20
35 set autocommit=1;
36 select * from t1;
37 id value value2 value3
38 10 10 10 10
39 11 11 11 11
40 12 12 28012 28012
41 13 13 13 13
42 14 14 14 14
43 15 15 15 15
44 16 16 16 16
45 17 17 17 17
46 18 18 18 18
47 19 19 19 19
48 20 20 20 20
49 select * from t1 force index(value) where value=12;
50 kill query @id;
51 ERROR 70100: Query execution was interrupted
52 drop procedure if exists update_t1;
53 drop table if exists t1;