Debian Codegraph @

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

raw
1 # Variable name: innodb_page_cleaners
2 # Scope: Global
3 # Access type: Static
4 # Data type: numeric
5
6
7 SELECT COUNT(@@GLOBAL.innodb_page_cleaners);
8 --echo 1 Expected
9
10 SELECT COUNT(@@innodb_page_cleaners);
11 --echo 1 Expected
12
13 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
14 SET @@GLOBAL.innodb_page_cleaners=1;
15 --echo Expected error 'Read-only variable'
16
17 --Error ER_BAD_FIELD_ERROR
18 SELECT innodb_page_cleaners;
19 --echo Expected error 'Unknown column'
20
21 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
22 SELECT @@SESSION.innodb_page_cleaners;
23
24 --disable_warnings
25 SELECT @@GLOBAL.innodb_page_cleaners = VARIABLE_VALUE
26 FROM performance_schema.global_variables
27 WHERE VARIABLE_NAME='innodb_page_cleaners';
28 --enable_warnings
29 --echo 1 Expected
30
31 --disable_warnings
32 SELECT COUNT(VARIABLE_VALUE)
33 FROM performance_schema.global_variables
34 WHERE VARIABLE_NAME='innodb_page_cleaners';
35 --enable_warnings
36 --echo 1 Expected
37
38 SELECT @@innodb_page_cleaners = @@GLOBAL.innodb_page_cleaners;
39 --echo 1 Expected
40
41 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
42 SELECT COUNT(@@local.innodb_page_cleaners);
43 --echo Expected error 'Variable is a GLOBAL variable'
44
45 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
46 SELECT COUNT(@@SESSION.innodb_page_cleaners);
47 --echo Expected error 'Variable is a GLOBAL variable'
48
49 # Check the default value
50 --disable_warnings
51 SELECT VARIABLE_NAME, VARIABLE_VALUE
52 FROM performance_schema.global_variables
53 WHERE VARIABLE_NAME = 'innodb_page_cleaners';
54 --enable_warnings
55