Debian Codegraph @

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

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