Debian Codegraph @

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

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