Debian Codegraph @

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

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