Debian Codegraph @

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

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