Debian Codegraph @

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

raw
1 --source include/have_innodb.inc
2
3 SELECT @@GLOBAL.innodb_doublewrite;
4
5 SET @@GLOBAL.innodb_doublewrite=0;
6 SELECT @@GLOBAL.innodb_doublewrite;
7
8 SET @@GLOBAL.innodb_doublewrite=2;
9 --error ER_WRONG_VALUE_FOR_VAR
10 SET @@GLOBAL.innodb_doublewrite=3;
11 SELECT @@GLOBAL.innodb_doublewrite;
12 SET @@GLOBAL.innodb_doublewrite=1;
13 SELECT @@GLOBAL.innodb_doublewrite;
14
15 SELECT COUNT(VARIABLE_VALUE)
16 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
17 WHERE VARIABLE_NAME='innodb_doublewrite';
18
19 --echo '#---------------------BS_STVARS_026_04----------------------#'
20 ################################################################################
21 # Check if accessing variable with and without GLOBAL point to same variable #
22 ################################################################################
23 SELECT @@innodb_doublewrite = @@GLOBAL.innodb_doublewrite;
24 --echo 1 Expected
25
26 --echo '#---------------------BS_STVARS_026_05----------------------#'
27 ################################################################################
28 # Check if innodb_doublewrite can be accessed with and without @@ sign #
29 ################################################################################
30
31 SELECT COUNT(@@innodb_doublewrite);
32 --echo 1 Expected
33
34 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
35 SELECT COUNT(@@local.innodb_doublewrite);
36 --echo Expected error 'Variable is a GLOBAL variable'
37
38 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
39 SELECT COUNT(@@SESSION.innodb_doublewrite);
40 --echo Expected error 'Variable is a GLOBAL variable'
41
42 SELECT COUNT(@@GLOBAL.innodb_doublewrite);
43 --echo 1 Expected
44
45 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
46 SELECT @@innodb_doublewrite = @@SESSION.innodb_doublewrite;