Debian Codegraph @

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

raw
1
2 SET @start_global_value = @@global.innodb_log_compressed_pages;
3 SELECT @start_global_value;
4
5
6 --echo '#---------------------BS_STVARS_028_01----------------------#'
7 ####################################################################
8 # Displaying default value #
9 ####################################################################
10 SELECT COUNT(@@GLOBAL.innodb_log_compressed_pages);
11 --echo 1 Expected
12
13
14 --echo '#---------------------BS_STVARS_028_02----------------------#'
15 ####################################################################
16 # Check if Value can set #
17 ####################################################################
18
19 SET @@global.innodb_log_compressed_pages = 0;
20 SELECT @@global.innodb_log_compressed_pages;
21
22 SET @@global.innodb_log_compressed_pages ='On' ;
23 SELECT @@global.innodb_log_compressed_pages;
24
25 SET @@global.innodb_log_compressed_pages ='Off' ;
26 SELECT @@global.innodb_log_compressed_pages;
27
28 SET @@global.innodb_log_compressed_pages = 1;
29 SELECT @@global.innodb_log_compressed_pages;
30
31 --echo '#---------------------BS_STVARS_028_03----------------------#'
32 #################################################################
33 # Check if the value in GLOBAL Table matches value in variable #
34 #################################################################
35
36 --disable_warnings
37 SELECT IF(@@GLOBAL.innodb_log_compressed_pages,'ON','OFF') = VARIABLE_VALUE
38 FROM performance_schema.global_variables
39 WHERE VARIABLE_NAME='innodb_log_compressed_pages';
40 --enable_warnings
41 --echo 1 Expected
42
43 SELECT COUNT(@@GLOBAL.innodb_log_compressed_pages);
44 --echo 1 Expected
45
46 --disable_warnings
47 SELECT COUNT(VARIABLE_VALUE)
48 FROM performance_schema.global_variables
49 WHERE VARIABLE_NAME='innodb_log_compressed_pages';
50 --enable_warnings
51 --echo 1 Expected
52
53
54
55 --echo '#---------------------BS_STVARS_028_04----------------------#'
56 ################################################################################
57 # Check if accessing variable with and without GLOBAL point to same variable #
58 ################################################################################
59 SELECT @@innodb_log_compressed_pages = @@GLOBAL.innodb_log_compressed_pages;
60 --echo 1 Expected
61
62
63
64 --echo '#---------------------BS_STVARS_028_05----------------------#'
65 ################################################################################
66 # Check if innodb_log_compressed_pages can be accessed with and without @@ sign#
67 ################################################################################
68
69 SELECT COUNT(@@innodb_log_compressed_pages);
70 --echo 1 Expected
71
72 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
73 SELECT COUNT(@@local.innodb_log_compressed_pages);
74 --echo Expected error 'Variable is a GLOBAL variable'
75
76 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
77 SELECT COUNT(@@SESSION.innodb_log_compressed_pages);
78 --echo Expected error 'Variable is a GLOBAL variable'
79
80 SELECT COUNT(@@GLOBAL.innodb_log_compressed_pages);
81 --echo 1 Expected
82
83 --Error ER_BAD_FIELD_ERROR
84 SELECT innodb_log_compressed_pages;
85
86 #
87 # Cleanup
88 #
89
90 SET @@global.innodb_log_compressed_pages = @start_global_value;
91 SELECT @@global.innodb_log_compressed_pages;