Debian Codegraph @

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

raw
1 ############# mysql-test\t\innodb_extend_and_initialize_basic.test ############
2 # #
3 # Variable Name: innodb_extend_and_initialize #
4 # Scope: GLOBAL #
5 # Access Type: Dynamic #
6 # Data Type: bool #
7 # Default Value: false #
8 # Range: #
9 # #
10 # #
11 # Creation Date: 2020-01-27 #
12 # Author: Rahul Agarkar #
13 # #
14 # Description: Test Cases of Dynamic Variable innodb_extend_and_initialize #
15 # that checks the behavior of this variable in the following ways#
16 # * Default Value #
17 # * Valid & Invalid values #
18 # * Scope & Access method #
19 # #
20 ###############################################################################
21
22 # The option innodb_extend_and_initialize is not supported on any
23 # platform other than linux
24 --source include/linux.inc
25 --source include/load_sysvars.inc
26
27 #############################
28 # Messages to be suppressed #
29 #############################
30 CALL mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* ignoring option '--innodb-extend-and-initialize'");
31
32 #######################################
33 # START OF innodb_extend_and_initialize TESTS #
34 #######################################
35
36 ######################
37 # Save initial value #
38 ######################
39
40 SET @start_global_value = @@global.innodb_extend_and_initialize;
41
42 --Error ER_INCORRECT_GLOBAL_LOCAL_VAR
43 SET @start_session_value = @@session.innodb_extend_and_initialize;
44
45 #####################################################
46 # Display the DEFAULT value of innodb_extend_and_initialize #
47 #####################################################
48
49 SELECT @@global.innodb_extend_and_initialize;
50
51 ###########################################
52 # Check the DEFAULT value of wait_timeout #
53 ###########################################
54
55 SET @@global.innodb_extend_and_initialize = DEFAULT;
56 SELECT @@global.innodb_extend_and_initialize;
57
58 --Error ER_GLOBAL_VARIABLE
59 SET @@session.innodb_extend_and_initialize = DEFAULT;
60
61 ################################################################
62 # Change the value of innodb_extend_and_initialize to an invalid value #
63 ################################################################
64
65 --Error ER_WRONG_VALUE_FOR_VAR
66 SET @@global.innodb_extend_and_initialize = 10;
67
68 --Error ER_WRONG_VALUE_FOR_VAR
69 SET @@global.innodb_extend_and_initialize = 'abc';
70
71 SELECT @@global.innodb_extend_and_initialize;
72
73 #####################################################
74 # Change the value of wait_timeout to a valid value #
75 #####################################################
76
77 SET @@global.innodb_extend_and_initialize = false;
78 SELECT @@global.innodb_extend_and_initialize;
79
80 SET @@global.innodb_extend_and_initialize = true;
81 SELECT @@global.innodb_extend_and_initialize;
82
83 SET @@global.innodb_extend_and_initialize = OFF;
84 SELECT @@global.innodb_extend_and_initialize;
85
86 SET @@global.innodb_extend_and_initialize = ON;
87 SELECT @@global.innodb_extend_and_initialize;
88
89 SET @@global.innodb_extend_and_initialize = 0;
90 SELECT @@global.innodb_extend_and_initialize;
91
92 SET @@global.innodb_extend_and_initialize = 1;
93 SELECT @@global.innodb_extend_and_initialize;
94
95 #########################
96 # Restore initial value #
97 #########################
98
99 SET @@global.innodb_extend_and_initialize = @start_global_value;
100
101 ############################################################
102 # Test the server command line option innodb-extend-and-initialize #
103 ############################################################
104
105 # Restart the server with invalid parameter values
106 let $restart_parameters = restart: --innodb-extend-and-initialize=10;
107 --source include/restart_mysqld.inc
108 SELECT @@global.innodb_extend_and_initialize;
109
110 let $restart_parameters = restart: --innodb-extend-and-initialize='xyz';
111 --source include/restart_mysqld.inc
112 SELECT @@global.innodb_extend_and_initialize;
113
114 # Restart the server with valid parameter values
115 let $restart_parameters = restart: --innodb-extend-and-initialize=false;
116 --source include/restart_mysqld.inc
117 SELECT @@global.innodb_extend_and_initialize;
118
119 let $restart_parameters = restart: --innodb-extend-and-initialize=true;
120 --source include/restart_mysqld.inc
121 SELECT @@global.innodb_extend_and_initialize;
122
123 let $restart_parameters = restart: --innodb-extend-and-initialize=off;
124 --source include/restart_mysqld.inc
125 SELECT @@global.innodb_extend_and_initialize;
126
127 let $restart_parameters = restart: --innodb-extend-and-initialize=on;
128 --source include/restart_mysqld.inc
129 SELECT @@global.innodb_extend_and_initialize;
130
131 let $restart_parameters = restart: --innodb-extend-and-initialize=0;
132 --source include/restart_mysqld.inc
133 SELECT @@global.innodb_extend_and_initialize;
134
135 SET @@global.innodb_extend_and_initialize = on;
136 SELECT @@global.innodb_extend_and_initialize;
137
138 let $restart_parameters = restart: --innodb-extend-and-initialize=1;
139 --source include/restart_mysqld.inc
140 SELECT @@global.innodb_extend_and_initialize;
141
142 let $restart_parameters = restart:;
143 --source include/restart_mysqld.inc
144 SELECT @@global.innodb_extend_and_initialize;
145 SET PERSIST innodb_extend_and_initialize = FALSE;
146
147 let $restart_parameters = restart:;
148 --source include/restart_mysqld.inc
149 SELECT @@global.innodb_extend_and_initialize;
150 SET PERSIST innodb_extend_and_initialize = DEFAULT;
151
152 let $restart_parameters = restart:;
153 --source include/restart_mysqld.inc
154 RESET PERSIST;
155
156 #####################################
157 # END OF innodb_extend_and_initialize TESTS #
158 #####################################