Debian Codegraph @

mysql-test/suite/innodb/include/dml_ops.inc

raw
1 delimiter |;
2 create procedure populate_t1()
3 begin
4 declare i int default 1;
5 while (i <= 200) do
6 insert into t1 values (i, 'a', 'b');
7 set i = i + 1;
8 end while;
9 end|
10 create procedure populate_t1_small()
11 begin
12 declare i int default 1;
13 while (i <= 20) do
14 insert into t1 values (i, 'c', 'd');
15 set i = i + 1;
16 end while;
17 end|
18 create procedure populate_t1_small2()
19 begin
20 declare i int default 30;
21 while (i <= 50) do
22 insert into t1 values (i, 'e', 'f');
23 set i = i + 1;
24 end while;
25 end|
26 delimiter ;|
27 #
28 begin;
29 select count(*) from t1;
30 call populate_t1();
31 select count(*) from t1;
32 select * from t1 limit 10;
33 rollback;
34 select count(*) from t1;
35 #
36 begin;
37 call populate_t1();
38 select count(*) from t1;
39 commit;
40 select count(*) from t1;
41 #
42 truncate table t1;
43 select count(*) from t1;
44 #
45 call populate_t1_small();
46 select count(*) from t1;
47 rollback;
48 select count(*) from t1;
49 truncate table t1;
50 #
51 call populate_t1();
52 select count(*) from t1;
53 delete from t1 where keyc <= 60;
54 select count(*) from t1;
55 call populate_t1_small();
56 select count(*) from t1;
57 select * from t1 limit 10;
58 begin;
59 call populate_t1_small2();
60 select count(*) from t1;
61 select * from t1 where keyc > 30 limit 10;
62 rollback;
63 select count(*) from t1;
64 select * from t1 where keyc > 30 limit 10;
65 #
66 update t1 set keyc = keyc + 2000;
67 select * from t1 limit 10;
68 rollback;
69 begin;
70 update t1 set keyc = keyc + 2000;
71 select * from t1 limit 10;
72 rollback;
73 select * from t1 limit 10;
74 commit;
75 select * from t1 limit 10;
76 #
77 insert into t2 select * from t1 where keyc < 2101;
78 select count(*) from t2;
79 #
80 drop procedure populate_t1;
81 drop procedure populate_t1_small;
82 drop procedure populate_t1_small2;