Debian Codegraph @

mysql-test/suite/sys_vars/r/stored_program_cache_func.result

raw
1 create procedure p1() select 1;
2 flush status;
3 show status like 'handler_read_key';
4 Variable_name Value
5 Handler_read_key 0
6 call p1;
7 1
8 1
9 show status like 'handler_read_key';
10 Variable_name Value
11 Handler_read_key 1
12 call p1;
13 1
14 1
15 show status like 'handler_read_key';
16 Variable_name Value
17 Handler_read_key 1
18 set global stored_program_cache=0;
19 call p1;
20 1
21 1
22 show status like 'handler_read_key';
23 Variable_name Value
24 Handler_read_key 2
25 call p1;
26 1
27 1
28 show status like 'handler_read_key';
29 Variable_name Value
30 Handler_read_key 3
31 drop procedure p1;
32 set global stored_program_cache=default;
33 create procedure pr(i int) begin
34 create table t1 (a int, b int);
35 if (i = 1) then alter table t1 drop a;
36 else alter table t1 drop b;
37 end if;
38 select * from t1;
39 drop table t1;
40 end |
41 call pr(1);
42 b
43 call pr(2);
44 a
45 set global stored_program_cache=0;
46 call pr(1);
47 b
48 call pr(2);
49 a
50 drop procedure pr;
51 set global stored_program_cache=default;