Debian Codegraph @

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

raw
1
2
3 # 2011-02-23 - Added
4 #
5
6 --source include/have_innodb.inc
7
8 SET @start_global_value = @@global.innodb_lru_scan_depth;
9 SELECT @start_global_value;
10
11 #
12 # exists as global only
13 #
14 --echo Valid value 100 or more
15 select @@global.innodb_lru_scan_depth >= 100;
16 select @@global.innodb_lru_scan_depth;
17 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
18 select @@session.innodb_lru_scan_depth;
19 show global variables like 'innodb_lru_scan_depth';
20 show session variables like 'innodb_lru_scan_depth';
21 --disable_warnings
22 select * from information_schema.global_variables where variable_name='innodb_lru_scan_depth';
23 select * from information_schema.session_variables where variable_name='innodb_lru_scan_depth';
24 --enable_warnings
25
26 #
27 # show that it's writable
28 #
29 set global innodb_lru_scan_depth=325;
30 select @@global.innodb_lru_scan_depth;
31 --disable_warnings
32 select * from information_schema.global_variables where variable_name='innodb_lru_scan_depth';
33 select * from information_schema.session_variables where variable_name='innodb_lru_scan_depth';
34 --enable_warnings
35 --error ER_GLOBAL_VARIABLE
36 set session innodb_lru_scan_depth=444;
37
38 #
39 # incorrect types
40 #
41 --error ER_WRONG_TYPE_FOR_VAR
42 set global innodb_lru_scan_depth=1.1;
43 --error ER_WRONG_TYPE_FOR_VAR
44 set global innodb_lru_scan_depth=1e1;
45 --error ER_WRONG_TYPE_FOR_VAR
46 set global innodb_lru_scan_depth="foo";
47
48 set global innodb_lru_scan_depth=7;
49 select @@global.innodb_lru_scan_depth;
50 --disable_warnings
51 select * from information_schema.global_variables where variable_name='innodb_lru_scan_depth';
52 --enable_warnings
53 set global innodb_lru_scan_depth=-7;
54 select @@global.innodb_lru_scan_depth;
55 --disable_warnings
56 select * from information_schema.global_variables where variable_name='innodb_lru_scan_depth';
57 --enable_warnings
58
59 #
60 # min/max values
61 #
62 set global innodb_lru_scan_depth=100;
63 select @@global.innodb_lru_scan_depth;
64
65 SET @@global.innodb_lru_scan_depth = @start_global_value;
66 SELECT @@global.innodb_lru_scan_depth;