Debian Codegraph @

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

raw
1
2
3 # 2010-01-25 - Added
4 #
5
6 --source include/have_innodb.inc
7
8 SET @start_global_value = @@global.innodb_old_blocks_pct;
9 SELECT @start_global_value;
10
11 #
12 # exists as global only
13 #
14 --echo Valid values are between 5 and 95
15 select @@global.innodb_old_blocks_pct between 5 and 95;
16 select @@global.innodb_old_blocks_pct;
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 select @@session.innodb_old_blocks_pct;
19 show global variables like 'innodb_old_blocks_pct';
20 show session variables like 'innodb_old_blocks_pct';
21 --disable_warnings
22 select * from information_schema.global_variables where variable_name='innodb_old_blocks_pct';
23 select * from information_schema.session_variables where variable_name='innodb_old_blocks_pct';
24 --enable_warnings
25
26 #
27 # show that it's writable
28 #
29 set global innodb_old_blocks_pct=10;
30 select @@global.innodb_old_blocks_pct;
31 --disable_warnings
32 select * from information_schema.global_variables where variable_name='innodb_old_blocks_pct';
33 select * from information_schema.session_variables where variable_name='innodb_old_blocks_pct';
34 --enable_warnings
35 --error ER_GLOBAL_VARIABLE
36 set session innodb_old_blocks_pct=1;
37
38 #
39 # check the default value
40 #
41 set @@global.innodb_old_blocks_pct=DEFAULT;
42 select @@global.innodb_old_blocks_pct;
43
44 #
45 # incorrect types
46 #
47 --error ER_WRONG_TYPE_FOR_VAR
48 set global innodb_old_blocks_pct=1.1;
49 --error ER_WRONG_TYPE_FOR_VAR
50 set global innodb_old_blocks_pct=1e1;
51 --error ER_WRONG_TYPE_FOR_VAR
52 set global innodb_old_blocks_pct="foo";
53 --error ER_WRONG_TYPE_FOR_VAR
54 set global innodb_old_blocks_pct=" ";
55 --error ER_WRONG_TYPE_FOR_VAR
56 set global innodb_old_blocks_pct='';
57
58 set global innodb_old_blocks_pct=4;
59 select @@global.innodb_old_blocks_pct;
60 --disable_warnings
61 select * from information_schema.global_variables where variable_name='innodb_old_blocks_pct';
62 --enable_warnings
63 set global innodb_old_blocks_pct=-7;
64 select @@global.innodb_old_blocks_pct;
65 --disable_warnings
66 select * from information_schema.global_variables where variable_name='innodb_old_blocks_pct';
67 --enable_warnings
68 set global innodb_old_blocks_pct=96;
69 select @@global.innodb_old_blocks_pct;
70 --disable_warnings
71 select * from information_schema.global_variables where variable_name='innodb_old_blocks_pct';
72 --enable_warnings
73
74 #
75 # min/max values
76 #
77 set global innodb_old_blocks_pct=5;
78 select @@global.innodb_old_blocks_pct;
79 set global innodb_old_blocks_pct=95;
80 select @@global.innodb_old_blocks_pct;
81
82 SET @@global.innodb_old_blocks_pct = @start_global_value;
83 SELECT @@global.innodb_old_blocks_pct;