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