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/have_innodb.inc
27 --source include/load_sysvars.inc
28
29 ########################################################################
30 # START OF innodb_flushing_avg_loops TESTS #
31 ########################################################################
32
33
34 ###############################################################################
35 #Saving initial value of innodb_flushing_avg_loops in a temporary variable #
36 ###############################################################################
37
38 SET @global_start_value = @@global.innodb_flushing_avg_loops;
39 SELECT @global_start_value;
40
41 --echo '#--------------------FN_DYNVARS_046_01------------------------#'
42 ########################################################################
43 # Display the DEFAULT value of innodb_flushing_avg_loops #
44 ########################################################################
45
46 SET @@global.innodb_flushing_avg_loops = 1;
47 SET @@global.innodb_flushing_avg_loops = DEFAULT;
48 SELECT @@global.innodb_flushing_avg_loops;
49
50 --echo '#---------------------FN_DYNVARS_046_02-------------------------#'
51 ##################################################################################
52 # Check if innodb_flushing_avg_loops can be accessed with and without @@ sign #
53 ##################################################################################
54
55 --Error ER_GLOBAL_VARIABLE
56 SET innodb_flushing_avg_loops = 1;
57 SELECT @@innodb_flushing_avg_loops;
58
59 --Error ER_UNKNOWN_TABLE
60 SELECT local.innodb_flushing_avg_loops;
61
62 SET global innodb_flushing_avg_loops = 1;
63 SELECT @@global.innodb_flushing_avg_loops;
64
65 --echo '#--------------------FN_DYNVARS_046_03------------------------#'
66 ###############################################################################
67 # change the value of innodb_flushing_avg_loops to a valid value #
68 ###############################################################################
69
70 SET @@global.innodb_flushing_avg_loops = 1;
71 SELECT @@global.innodb_flushing_avg_loops;
72
73 SET @@global.innodb_flushing_avg_loops = 60;
74 SELECT @@global.innodb_flushing_avg_loops;
75
76 SET @@global.innodb_flushing_avg_loops = 1000;
77 SELECT @@global.innodb_flushing_avg_loops;
78
79 --echo '#--------------------FN_DYNVARS_046_04-------------------------#'
80 ###########################################################################
81 # Change the value of innodb_flushing_avg_loops to invalid value #
82 ###########################################################################
83
84 SET @@global.innodb_flushing_avg_loops = -1;
85 SELECT @@global.innodb_flushing_avg_loops;
86
87 --Error ER_WRONG_TYPE_FOR_VAR
88 SET @@global.innodb_flushing_avg_loops = "T";
89 SELECT @@global.innodb_flushing_avg_loops;
90
91 --Error ER_WRONG_TYPE_FOR_VAR
92 SET @@global.innodb_flushing_avg_loops = "Y";
93 SELECT @@global.innodb_flushing_avg_loops;
94
95 SET @@global.innodb_flushing_avg_loops = 1001;
96 SELECT @@global.innodb_flushing_avg_loops;
97 --Error ER_WRONG_TYPE_FOR_VAR
98 SET @@global.innodb_flushing_avg_loops = ' ';
99 SELECT @@global.innodb_flushing_avg_loops;
100 --Error ER_WRONG_TYPE_FOR_VAR
101 SET @@global.innodb_flushing_avg_loops = " ";
102 SELECT @@global.innodb_flushing_avg_loops;
103
104 --echo '#----------------------FN_DYNVARS_046_05------------------------#'
105 #########################################################################
106 # Check if the value in GLOBAL Table matches value in variable #
107 #########################################################################
108
109 --disable_warnings
110 SELECT @@global.innodb_flushing_avg_loops =
111 VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
112 WHERE VARIABLE_NAME='innodb_flushing_avg_loops';
113 --enable_warnings
114 SELECT @@global.innodb_flushing_avg_loops;
115 --disable_warnings
116 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
117 WHERE VARIABLE_NAME='innodb_flushing_avg_loops';
118 --enable_warnings
119
120 --echo '#---------------------FN_DYNVARS_046_06-------------------------#'
121 ###################################################################
122 # Check if ON and OFF values can be used on variable #
123 ###################################################################
124
125 --ERROR ER_WRONG_TYPE_FOR_VAR
126 SET @@global.innodb_flushing_avg_loops = OFF;
127 SELECT @@global.innodb_flushing_avg_loops;
128
129 --ERROR ER_WRONG_TYPE_FOR_VAR
130 SET @@global.innodb_flushing_avg_loops = ON;
131 SELECT @@global.innodb_flushing_avg_loops;
132
133 --echo '#---------------------FN_DYNVARS_046_07----------------------#'
134 ###################################################################
135 # Check if TRUE and FALSE values can be used on variable #
136 ###################################################################
137
138
139 SET @@global.innodb_flushing_avg_loops = TRUE;
140 SELECT @@global.innodb_flushing_avg_loops;
141 SET @@global.innodb_flushing_avg_loops = FALSE;
142 SELECT @@global.innodb_flushing_avg_loops;
143
144 ##############################
145 # Restore initial value #
146 ##############################
147
148 SET @@global.innodb_flushing_avg_loops = @global_start_value;
149 SELECT @@global.innodb_flushing_avg_loops;
150
151 ###############################################################
152 # END OF innodb_flushing_avg_loops TESTS #
153 ###############################################################