Debian Codegraph @

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

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