Debian Codegraph @

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

raw
1 ##### mysql-test\t\innodb_compression_failure_threshold_pct_basic.test ########
2 # #
3 # Variable Name: innodb_compression_failure_threshold_pct #
4 # Scope: GLOBAL #
5 # Access Type: Dynamic #
6 # Data Type: Numeric #
7 # Default Value: 5 #
8 # Range: 0-100 #
9 # #
10 # #
11 # Creation Date: 2008-02-07 #
12 # Author: Rizwan #
13 # #
14 #Description: Test Cases of Dynamic System Variable #
15 # innodb_compression_failure_threshold_pct #
16 # that checks the behavior of #
17 # this variable in the following ways #
18 # * Default Value #
19 # * Valid & Invalid values #
20 # * Scope & Access method #
21 # * Data Integrity #
22 # #
23 # Reference: http://dev.mysql.com/doc/refman/5.1/en/ #
24 # server-system-variables.html #
25 # #
26 ###############################################################################
27 --source include/load_sysvars.inc
28
29 ######################################################################
30 # START OF innodb_compression_failure_threshold_pct TESTS #
31 ######################################################################
32
33
34 ############################################################################################
35 # Saving initial value of innodb_compression_failure_threshold_pct in a temporary variable #
36 ############################################################################################
37
38 SET @global_start_value = @@global.innodb_compression_failure_threshold_pct;
39 SELECT @global_start_value;
40
41 --echo '#--------------------FN_DYNVARS_046_01------------------------#'
42 ########################################################################
43 # Display the DEFAULT value of innodb_compression_failure_threshold_pct#
44 ########################################################################
45
46 SET @@global.innodb_compression_failure_threshold_pct = 0;
47 SET @@global.innodb_compression_failure_threshold_pct = DEFAULT;
48 SELECT @@global.innodb_compression_failure_threshold_pct;
49
50 --echo '#---------------------FN_DYNVARS_046_02-------------------------#'
51 ##############################################################################################
52 # check if innodb_compression_failure_threshold_pct can be accessed with and without @@ sign #
53 ##############################################################################################
54
55 --Error ER_GLOBAL_VARIABLE
56 SET innodb_compression_failure_threshold_pct = 1;
57 SELECT @@innodb_compression_failure_threshold_pct;
58
59 --Error ER_UNKNOWN_TABLE
60 SELECT local.innodb_compression_failure_threshold_pct;
61
62 SET global innodb_compression_failure_threshold_pct = 0;
63 SELECT @@global.innodb_compression_failure_threshold_pct;
64
65 --echo '#--------------------FN_DYNVARS_046_03------------------------#'
66 #################################################################################
67 # change the value of innodb_compression_failure_threshold_pct to a valid value #
68 #################################################################################
69
70 SET @@global.innodb_compression_failure_threshold_pct = 0;
71 SELECT @@global.innodb_compression_failure_threshold_pct;
72
73 SET @@global.innodb_compression_failure_threshold_pct = 1;
74 SELECT @@global.innodb_compression_failure_threshold_pct;
75 SET @@global.innodb_compression_failure_threshold_pct = 100;
76 SELECT @@global.innodb_compression_failure_threshold_pct;
77
78 --echo '#--------------------FN_DYNVARS_046_04-------------------------#'
79 ################################################################################
80 # Cange the value of innodb_compression_failure_threshold_pct to invalid value #
81 ################################################################################
82
83 SET @@global.innodb_compression_failure_threshold_pct = -1;
84 SELECT @@global.innodb_compression_failure_threshold_pct;
85
86 --Error ER_WRONG_TYPE_FOR_VAR
87 SET @@global.innodb_compression_failure_threshold_pct = "T";
88 SELECT @@global.innodb_compression_failure_threshold_pct;
89 --Error ER_WRONG_TYPE_FOR_VAR
90 SET @@global.innodb_compression_failure_threshold_pct = 1.1;
91 SELECT @@global.innodb_compression_failure_threshold_pct;
92
93 --Error ER_WRONG_TYPE_FOR_VAR
94 SET @@global.innodb_compression_failure_threshold_pct = "Y";
95 SELECT @@global.innodb_compression_failure_threshold_pct;
96
97 SET @@global.innodb_compression_failure_threshold_pct = 101;
98 SELECT @@global.innodb_compression_failure_threshold_pct;
99 --Error ER_WRONG_TYPE_FOR_VAR
100 SET @@global.innodb_compression_failure_threshold_pct = " ";
101 SELECT @@global.innodb_compression_failure_threshold_pct;
102 --Error ER_WRONG_TYPE_FOR_VAR
103 SET @@global.innodb_compression_failure_threshold_pct = ' ';
104 SELECT @@global.innodb_compression_failure_threshold_pct;
105
106 --echo '#----------------------FN_DYNVARS_046_05------------------------#'
107 #########################################################################
108 # Check if the value in GLOBAL Table matches value in variable #
109 #########################################################################
110
111 --disable_warnings
112 SELECT @@global.innodb_compression_failure_threshold_pct =
113 VARIABLE_VALUE FROM performance_schema.global_variables
114 WHERE VARIABLE_NAME='innodb_compression_failure_threshold_pct';
115 --enable_warnings
116 SELECT @@global.innodb_compression_failure_threshold_pct;
117 --disable_warnings
118 SELECT VARIABLE_VALUE FROM performance_schema.global_variables
119 WHERE VARIABLE_NAME='innodb_compression_failure_threshold_pct';
120 --enable_warnings
121
122 --echo '#---------------------FN_DYNVARS_046_06-------------------------#'
123 ###################################################################
124 # Check if ON and OFF values can be used on variable #
125 ###################################################################
126
127 --ERROR ER_WRONG_TYPE_FOR_VAR
128 SET @@global.innodb_compression_failure_threshold_pct = OFF;
129 SELECT @@global.innodb_compression_failure_threshold_pct;
130
131 --ERROR ER_WRONG_TYPE_FOR_VAR
132 SET @@global.innodb_compression_failure_threshold_pct = ON;
133 SELECT @@global.innodb_compression_failure_threshold_pct;
134
135 --echo '#---------------------FN_DYNVARS_046_07----------------------#'
136 ###################################################################
137 # Check if TRUE and FALSE values can be used on variable #
138 ###################################################################
139
140 SET @@global.innodb_compression_failure_threshold_pct = TRUE;
141 SELECT @@global.innodb_compression_failure_threshold_pct;
142 SET @@global.innodb_compression_failure_threshold_pct = FALSE;
143 SELECT @@global.innodb_compression_failure_threshold_pct;
144
145 ##############################
146 # Restore initial value #
147 ##############################
148
149 SET @@global.innodb_compression_failure_threshold_pct = @global_start_value;
150 SELECT @@global.innodb_compression_failure_threshold_pct;
151
152 ###############################################################
153 # END OF innodb_compression_failure_threshold_pct TESTS #
154 ###############################################################