Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_buf_dump_status_frequency_basic.test

raw
1 --source include/have_innodb.inc
2 --source include/load_sysvars.inc
3
4 SET @start_innodb_buf_dump_status_frequency = @@global.innodb_buf_dump_status_frequency;
5 SELECT @start_innodb_buf_dump_status_frequency;
6
7 SELECT COUNT(@@global.innodb_buf_dump_status_frequency);
8
9 # test valid value
10 SET @@global.innodb_buf_dump_status_frequency = 20;
11 SELECT @@global.innodb_buf_dump_status_frequency;
12
13 # test valid min
14 SET @@global.innodb_buf_dump_status_frequency = 0;
15 SELECT @@global.innodb_buf_dump_status_frequency;
16
17 # test valid max
18 SET @@global.innodb_buf_dump_status_frequency = 100;
19 SELECT @@global.innodb_buf_dump_status_frequency;
20
21 # test invalid value < min
22 SET @@global.innodb_buf_dump_status_frequency = -1;
23 SELECT @@global.innodb_buf_dump_status_frequency;
24
25 # test invalid value > max
26 SET @@global.innodb_buf_dump_status_frequency = 101;
27 SELECT @@global.innodb_buf_dump_status_frequency;
28
29 # test wrong type
30 --Error ER_WRONG_TYPE_FOR_VAR
31 SET @@global.innodb_buf_dump_status_frequency = 10.5;
32 SELECT @@global.innodb_buf_dump_status_frequency;
33
34 --Error ER_WRONG_TYPE_FOR_VAR
35 SET @@global.innodb_buf_dump_status_frequency = "abc";
36 SELECT @@global.innodb_buf_dump_status_frequency;
37
38 SET @@global.innodb_buf_dump_status_frequency = @start_innodb_buf_dump_status_frequency;
39