Debian Codegraph @

mysql-test/suite/sys_vars/r/session_track_system_variables_basic.result

raw
1 #
2 # Variable name : session_track_system_variables
3 # Scope : Global & Session
4 #
5 # Global - default
6 SELECT @@global.session_track_system_variables;
7 @@global.session_track_system_variables
8 autocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
9 # Session - default
10 SELECT @@session.session_track_system_variables;
11 @@session.session_track_system_variables
12 autocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
13
14 # via INFORMATION_SCHEMA.GLOBAL_VARIABLES
15 SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME LIKE 'session_track_system_variables' ORDER BY VARIABLE_NAME;
16 VARIABLE_NAME VARIABLE_VALUE
17 SESSION_TRACK_SYSTEM_VARIABLES autocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
18 # via INFORMATION_SCHEMA.SESSION_VARIABLES
19 SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME LIKE 'session_track_system_variables' ORDER BY VARIABLE_NAME;
20 VARIABLE_NAME VARIABLE_VALUE
21 SESSION_TRACK_SYSTEM_VARIABLES autocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
22 SET @global_saved_tmp = @@global.session_track_system_variables;
23
24 # Altering global variable's value
25 SET @@global.session_track_system_variables='autocommit';
26 SELECT @@global.session_track_system_variables;
27 @@global.session_track_system_variables
28 autocommit
29 SELECT @@session.session_track_system_variables;
30 @@session.session_track_system_variables
31 autocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
32
33 # Altering session variable's value
34 SET @@session.session_track_system_variables='autocommit';
35 SELECT @@global.session_track_system_variables;
36 @@global.session_track_system_variables
37 autocommit
38 SELECT @@session.session_track_system_variables;
39 @@session.session_track_system_variables
40 autocommit
41
42 # Variables' values in a new session.
43 connect con1,"127.0.0.1",root,,test,$MASTER_MYPORT,;
44 # Global - expect "autocommit"
45 SELECT @@global.session_track_system_variables;
46 @@global.session_track_system_variables
47 autocommit
48
49 # Session - expect "autocommit"
50 SELECT @@session.session_track_system_variables;
51 @@session.session_track_system_variables
52 autocommit
53
54 # Switching to the default connection.
55 connection default;
56 SELECT @@global.session_track_system_variables;
57 @@global.session_track_system_variables
58 autocommit
59 SELECT @@session.session_track_system_variables;
60 @@session.session_track_system_variables
61 autocommit
62
63 # Test if DEFAULT is working as expected.
64 SET @@global.session_track_system_variables = DEFAULT;
65 SET @@session.session_track_system_variables = DEFAULT;
66
67 SELECT @@global.session_track_system_variables;
68 @@global.session_track_system_variables
69 autocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
70 SELECT @@session.session_track_system_variables;
71 @@session.session_track_system_variables
72 autocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
73
74 # Variables' values in a new session (con2).
75 connect con2,"127.0.0.1",root,,test,$MASTER_MYPORT,;
76 SELECT @@global.session_track_system_variables;
77 @@global.session_track_system_variables
78 autocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
79 SELECT @@session.session_track_system_variables;
80 @@session.session_track_system_variables
81 autocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
82
83 # Altering session should not affect global.
84 SET @@session.session_track_system_variables = 'sql_mode';
85 SELECT @@global.session_track_system_variables;
86 @@global.session_track_system_variables
87 autocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
88 SELECT @@session.session_track_system_variables;
89 @@session.session_track_system_variables
90 sql_mode
91
92 # Variables' values in a new session (con3).
93 connect con3,"127.0.0.1",root,,test,$MASTER_MYPORT,;
94 # Altering global should not affect session.
95 SET @@global.session_track_system_variables = 'sql_mode';
96 SELECT @@global.session_track_system_variables;
97 @@global.session_track_system_variables
98 sql_mode
99 SELECT @@session.session_track_system_variables;
100 @@session.session_track_system_variables
101 autocommit,character_set_client,character_set_connection,character_set_results,redirect_url,time_zone
102
103 # Switching to the default connection.
104 connection default;
105 # Testing NULL
106 SET @@global.session_track_system_variables = NULL;
107 ERROR 42000: Variable 'session_track_system_variables' can't be set to the value of 'NULL'
108 SET @@session.session_track_system_variables = NULL;
109 ERROR 42000: Variable 'session_track_system_variables' can't be set to the value of 'NULL'
110 # testing with duplicate entries.
111 SET @@global.session_track_system_variables= "time_zone";
112 SET @@session.session_track_system_variables= "time_zone";
113 SET @@global.session_track_system_variables= "sql_mode,sql_mode";
114 SET @@session.session_track_system_variables= "sql_mode,sql_mode";
115 SELECT @@global.session_track_system_variables;
116 @@global.session_track_system_variables
117 sql_mode
118 SELECT @@session.session_track_system_variables;
119 @@session.session_track_system_variables
120 sql_mode
121
122 # testing ordering
123 SET @@global.session_track_system_variables= "time_zone,sql_mode";
124 SET @@session.session_track_system_variables= "time_zone,sql_mode";
125 SELECT @@global.session_track_system_variables;
126 @@global.session_track_system_variables
127 sql_mode,time_zone
128 SELECT @@session.session_track_system_variables;
129 @@session.session_track_system_variables
130 sql_mode,time_zone
131
132 # special values
133 SET @@global.session_track_system_variables= "*";
134 SET @@session.session_track_system_variables= "*";
135 SELECT @@global.session_track_system_variables;
136 @@global.session_track_system_variables
137 *
138 SELECT @@session.session_track_system_variables;
139 @@session.session_track_system_variables
140 *
141 SET @@global.session_track_system_variables= "";
142 SET @@session.session_track_system_variables= "";
143 SELECT @@global.session_track_system_variables;
144 @@global.session_track_system_variables
145
146 SELECT @@session.session_track_system_variables;
147 @@session.session_track_system_variables
148
149
150 # MDEV-22524 SIGABRT in safe_mutex_unlock with session_track_system_variables and max_relay_log_size.
151 SET SESSION session_track_system_variables="sql_slave_skip_counter", sql_slave_skip_counter= 0;
152 # Restoring the original values.
153 SET @@global.session_track_system_variables = @global_saved_tmp;
154 # End of 10.2 tests.
155 #
156 # MDEV-39207 plugin variables disappear from session_track_system_variables list
157 #
158 install soname 'ha_example.so';
159 # Plugin global vars are not included
160 set global session_track_system_variables='myisam_block_size';
161 select @@global.session_track_system_variables;
162 @@global.session_track_system_variables
163
164 set global session_track_system_variables='example_int_var';
165 select @@global.session_track_system_variables;
166 @@global.session_track_system_variables
167 example_int_var
168 set global session_track_system_variables='myisam_sort_buffer_size,example_int_var';
169 select @@global.session_track_system_variables;
170 @@global.session_track_system_variables
171 example_int_var,myisam_sort_buffer_size
172 set global session_track_system_variables='myisam_block_size,myisam_sort_buffer_size,character_set_client,example_int_var';
173 select @@global.session_track_system_variables;
174 @@global.session_track_system_variables
175 character_set_client,example_int_var,myisam_sort_buffer_size
176 # Session tracking works as expected for plugin session var
177 connect foo,localhost,root;
178 select @@session.session_track_system_variables;
179 @@session.session_track_system_variables
180 character_set_client,example_int_var,myisam_sort_buffer_size
181 set session example_int_var = -1;
182 -- Tracker : SESSION_TRACK_SYSTEM_VARIABLES
183 -- example_int_var: -1
184
185 connection default;
186 disconnect foo;
187 uninstall soname 'ha_example.so';
188 SET @@global.session_track_system_variables = @global_saved_tmp;
189 # End of 10.11 tests
190 #
191 # MDEV-31609 Send initial values of system variables in first OK packet
192 #
193 connect foo,localhost,root;
194 -- Tracker : SESSION_TRACK_SYSTEM_VARIABLES
195 -- autocommit: ON
196 -- character_set_client: latin1
197 -- character_set_connection: latin1
198 -- character_set_results: latin1
199 -- redirect_url:
200 -- time_zone: SYSTEM
201
202 connection default;
203 disconnect foo;
204 # End of tests 11.5
205 #
206 # MDEV-38179 regression in t_connect
207 #
208 # myisam_block_size is a global only plugin var and is not
209 # added to the session_track_system_variables.
210 # example_int_var is a session plugin var and is included.
211 install soname 'ha_example.so';
212 set global session_track_system_variables='sql_slave_skip_counter,character_set_client,example_int_var';
213 select @@global.session_track_system_variables;
214 @@global.session_track_system_variables
215 character_set_client,example_int_var,sql_slave_skip_counter
216 connect foo,localhost,root;
217 -- Tracker : SESSION_TRACK_SYSTEM_VARIABLES
218 -- character_set_client: latin1
219 -- example_int_var: 0
220 -- sql_slave_skip_counter: 0
221
222 select @@session.session_track_system_variables;
223 @@session.session_track_system_variables
224 character_set_client,example_int_var,sql_slave_skip_counter
225 connection default;
226 disconnect foo;
227 set global session_track_system_variables='sql_slave_skip_counter,myisam_block_size,character_set_client,example_int_var';
228 select @@global.session_track_system_variables;
229 @@global.session_track_system_variables
230 character_set_client,example_int_var,sql_slave_skip_counter
231 connect foo,localhost,root;
232 -- Tracker : SESSION_TRACK_SYSTEM_VARIABLES
233 -- character_set_client: latin1
234 -- example_int_var: 0
235 -- sql_slave_skip_counter: 0
236
237 select @@session.session_track_system_variables;
238 @@session.session_track_system_variables
239 character_set_client,example_int_var,sql_slave_skip_counter
240 connection default;
241 disconnect foo;
242 set global session_track_system_variables='sql_slave_skip_counter,myisam_block_size,max_connections,character_set_client,example_int_var';
243 select @@global.session_track_system_variables;
244 @@global.session_track_system_variables
245 character_set_client,example_int_var,max_connections,sql_slave_skip_counter
246 connect foo,localhost,root;
247 -- Tracker : SESSION_TRACK_SYSTEM_VARIABLES
248 -- character_set_client: latin1
249 -- example_int_var: 0
250 -- max_connections: 151
251 -- sql_slave_skip_counter: 0
252
253 select @@session.session_track_system_variables;
254 @@session.session_track_system_variables
255 character_set_client,example_int_var,max_connections,sql_slave_skip_counter
256 connection default;
257 disconnect foo;
258 set global session_track_system_variables='sql_slave_skip_counter,*';
259 select @@global.session_track_system_variables;
260 @@global.session_track_system_variables
261 *
262 connect foo,localhost,root;
263 select @@session.session_track_system_variables;
264 @@session.session_track_system_variables
265 *
266 connection default;
267 SET global session_track_system_variables = @global_saved_tmp;
268 disconnect foo;
269 uninstall soname 'ha_example.so';
270 # End of tests 11.8