Debian Codegraph @

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

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