Debian Codegraph @

mysql-test/suite/perfschema/r/show_sanity.result

raw
1 create table test.sanity(
2 `SHOW_MODE` varchar(48) NOT NULL,
3 `SOURCE` varchar(64) NOT NULL,
4 `VARIABLE_NAME` varchar(64) NOT NULL);
5 select thread_id from performance_schema.threads
6 where processlist_id = connection_id()
7 into @my_tid;
8 select @@global.show_compatibility_56 into @show_compatibility_56_save;
9 set @my_user='root';
10 set @my_host='localhost';
11
12 ================================================================================
13 SHOW_COMPATIBILITY_56 = ON
14 ================================================================================
15 set global show_compatibility_56 = on;
16
17 # STEP 1-1
18 insert into test.sanity
19 select "5.6", "I_S.GLOBAL_VARIABLES", variable_name
20 from information_schema.global_variables;
21 Warnings:
22 Warning 1287 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.global_variables instead
23
24 # STEP 1-2
25 insert into test.sanity
26 select "5.6", "I_S.SESSION_VARIABLES", variable_name
27 from information_schema.session_variables;
28 Warnings:
29 Warning 1287 'INFORMATION_SCHEMA.SESSION_VARIABLES' is deprecated and will be removed in a future release. Please use performance_schema.session_variables instead
30
31 # STEP 1-3
32 insert into test.sanity
33 select "5.6", "P_S.GLOBAL_VARIABLES", variable_name
34 from performance_schema.global_variables;
35
36 # STEP 1-4
37 insert into test.sanity
38 select "5.6", "P_S.VARIABLES_BY_THREAD", variable_name
39 from performance_schema.variables_by_thread
40 where thread_id = @my_tid;
41
42 # STEP 1-5
43 insert into test.sanity
44 select "5.6", "P_S.SESSION_VARIABLES", variable_name
45 from performance_schema.session_variables;
46
47 # STEP 1-6
48 insert into test.sanity
49 select "5.6", "I_S.GLOBAL_STATUS", variable_name
50 from information_schema.global_status;
51 Warnings:
52 Warning 1287 'INFORMATION_SCHEMA.GLOBAL_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.global_status instead
53
54 # STEP 1-7
55 insert into test.sanity
56 select "5.6", "I_S.SESSION_STATUS", variable_name
57 from information_schema.session_status;
58 Warnings:
59 Warning 1287 'INFORMATION_SCHEMA.SESSION_STATUS' is deprecated and will be removed in a future release. Please use performance_schema.session_status instead
60
61 # STEP 1-8
62 insert into test.sanity
63 select "5.6", "P_S.GLOBAL_STATUS", variable_name
64 from performance_schema.global_status;
65
66 # STEP 1-9
67 # EMPTY, NO WARNINGS (not available in 5.6 mode)
68 select *
69 from performance_schema.status_by_thread;
70 THREAD_ID VARIABLE_NAME VARIABLE_VALUE
71
72 # STEP 1-10
73 insert into test.sanity
74 select "5.6", "P_S.SESSION_STATUS", variable_name
75 from performance_schema.session_status;
76
77 # STEP 1-11
78 # EMPTY, NO WARNINGS (not available in 5.6 mode)
79 select *
80 from performance_schema.status_by_account;
81 USER HOST VARIABLE_NAME VARIABLE_VALUE
82
83 # STEP 1-12
84 # EMPTY, NO WARNINGS (not available in 5.6 mode)
85 select *
86 from performance_schema.status_by_user;
87 USER VARIABLE_NAME VARIABLE_VALUE
88
89 # STEP 1-13
90 # EMPTY, NO WARNINGS (not available in 5.6 mode)
91 select *
92 from performance_schema.status_by_host;
93 HOST VARIABLE_NAME VARIABLE_VALUE
94
95 ================================================================================
96 SHOW_COMPATIBILITY_56 = OFF
97 ================================================================================
98 set global show_compatibility_56 = off;
99
100 # STEP 2-1
101 # FAILS WITH ERROR
102 select *
103 from information_schema.global_variables;
104 ERROR HY000: The 'INFORMATION_SCHEMA.GLOBAL_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'
105
106 # STEP 2-2
107 # FAILS WITH ERROR
108 select *
109 from information_schema.session_variables;
110 ERROR HY000: The 'INFORMATION_SCHEMA.SESSION_VARIABLES' feature is disabled; see the documentation for 'show_compatibility_56'
111
112 # STEP 2-3
113 insert into test.sanity
114 select "5.7", "P_S.GLOBAL_VARIABLES", variable_name
115 from performance_schema.global_variables;
116
117 # STEP 2-4
118 insert into test.sanity
119 select "5.7", "P_S.VARIABLES_BY_THREAD", variable_name
120 from performance_schema.variables_by_thread
121 where thread_id = @my_tid;
122
123 # STEP 2-5
124 insert into test.sanity
125 select "5.7", "P_S.SESSION_VARIABLES", variable_name
126 from performance_schema.session_variables;
127
128 # STEP 2-6
129 # FAILS WITH ERROR
130 select *
131 from information_schema.global_status;
132 ERROR HY000: The 'INFORMATION_SCHEMA.GLOBAL_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'
133
134 # STEP 2-7
135 # FAILS WITH ERROR
136 select *
137 from information_schema.session_status;
138 ERROR HY000: The 'INFORMATION_SCHEMA.SESSION_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'
139
140 # STEP 2-8
141 insert into test.sanity
142 select "5.7", "P_S.GLOBAL_STATUS", variable_name
143 from performance_schema.global_status;
144
145 # STEP 2-9
146 insert into test.sanity
147 select "5.7", "P_S.STATUS_BY_THREAD", variable_name
148 from performance_schema.status_by_thread
149 where thread_id = @my_tid;
150
151 # STEP 2-10
152 insert into test.sanity
153 select "5.7", "P_S.SESSION_STATUS", variable_name
154 from performance_schema.session_status;
155
156 # STEP 2-11
157 insert into test.sanity
158 select "5.7", "P_S.STATUS_BY_ACCOUNT", variable_name
159 from performance_schema.status_by_account
160 where `user` = @my_user and `host` = @my_host;
161
162 # STEP 2-12
163 insert into test.sanity
164 select "5.7", "P_S.STATUS_BY_USER", variable_name
165 from performance_schema.status_by_user
166 where `user` = @my_user;
167
168 # STEP 2-13
169 insert into test.sanity
170 select "5.7", "P_S.STATUS_BY_HOST", variable_name
171 from performance_schema.status_by_host
172 where `host` = @my_host;
173
174 # STEP 2-14
175 # Known global variables in 5.6 that should not display in session queries.
176 # These should be global-only system variables.
177
178 # STEP 2-15
179 # Known global status in 5.6 that should not exist in session queries.
180 # These should be global-only status variables.
181
182 # STEP 2-15A
183 # COM counters appear in I_S.SESSION_STATUS, but not in P_S.SESSION_STATUS
184
185 # STEP 2-15B
186 # These slave status counters appear in I_S.SESSION_STATUS, but not in P_S.SESSION_STATUS
187 insert into test.sanity values
188 ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_HEARTBEAT_PERIOD"),
189 ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_LAST_HEARTBEAT"),
190 ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_RECEIVED_HEARTBEATS"),
191 ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_RETRIED_TRANSACTIONS"),
192 ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_RUNNING")
193 ;
194
195 # STEP 2-16
196 # Known session-only status in 5.6 that should not exist in global queries.
197 insert into test.sanity values
198 ("JUNK: SESSION-ONLY", "I_S.GLOBAL_STATUS", "COMPRESSION"),
199 ("JUNK: SESSION-ONLY", "I_S.GLOBAL_STATUS", "LAST_QUERY_COST"),
200 ("JUNK: SESSION-ONLY", "I_S.GLOBAL_STATUS", "LAST_QUERY_PARTIAL_PLANS")
201 ;
202
203 # STEP 2-16A
204 # COM counters appear in I_S.GLOBAL_STATUS but not in P_S.GLOBAL_STATUS
205
206 # STEP 2-16B
207 # These slave status counters appear in I_S.GLOBAL_STATUS, but not in P_S.GLOBAL_STATUS
208 insert into test.sanity values
209 ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_HEARTBEAT_PERIOD"),
210 ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_LAST_HEARTBEAT"),
211 ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_RECEIVED_HEARTBEATS"),
212 ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_RETRIED_TRANSACTIONS"),
213 ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_RUNNING")
214 ;
215
216 # STEP 2-17
217 # Status variables that should not exist in queries that aggregate across threads.
218 # Criteria: Session-only OR non-aggregatable.
219 insert into test.sanity values
220 ("JUNK", "NO AGGREGATE", "COMPRESSION"),
221 ("JUNK", "NO AGGREGATE", "LAST_QUERY_COST"),
222 ("JUNK", "NO AGGREGATE", "LAST_QUERY_PARTIAL_PLANS"),
223 ("JUNK", "NO AGGREGATE", "OPEN_TABLES"),
224 ("JUNK", "NO AGGREGATE", "QUERIES"),
225 ("JUNK", "NO AGGREGATE", "SLOW_LAUNCH_THREADS"),
226 ("JUNK", "NO AGGREGATE", "SSL_CIPHER"),
227 ("JUNK", "NO AGGREGATE", "SSL_CIPHER_LIST"),
228 ("JUNK", "NO AGGREGATE", "SSL_DEFAULT_TIMEOUT"),
229 ("JUNK", "NO AGGREGATE", "SSL_SERVER_NOT_AFTER"),
230 ("JUNK", "NO AGGREGATE", "SSL_SERVER_NOT_BEFORE"),
231 ("JUNK", "NO AGGREGATE", "SSL_SESSIONS_REUSED"),
232 ("JUNK", "NO AGGREGATE", "SSL_VERIFY_DEPTH"),
233 ("JUNK", "NO AGGREGATE", "SSL_VERIFY_MODE"),
234 ("JUNK", "NO AGGREGATE", "SSL_VERSION")
235 ;
236
237 ================================================================================
238 TEST 1A
239 Present in 5.6 P_S.GLOBAL_VARIABLES (1-3)
240 Missing in 5.6 I_S.GLOBAL_VARIABLES (1-1)
241 ================================================================================
242 select * from test.sanity
243 where show_mode = "5.6"
244 and source = "P_S.GLOBAL_VARIABLES"
245 and upper(variable_name) not in (
246 select upper(variable_name) from test.sanity
247 where show_mode = "5.6"
248 and source = "I_S.GLOBAL_VARIABLES")
249 order by show_mode, source, variable_name;
250 SHOW_MODE SOURCE VARIABLE_NAME
251
252 ================================================================================
253 TEST 1B
254 Present in 5.7 P_S.GLOBAL_VARIABLES (2-3)
255 Missing in 5.6 I_S.GLOBAL_VARIABLES (1-1)
256 ================================================================================
257 select * from test.sanity
258 where show_mode = "5.7"
259 and source = "P_S.GLOBAL_VARIABLES"
260 and upper(variable_name) not in (
261 select upper(variable_name) from test.sanity
262 where show_mode = "5.6"
263 and source = "I_S.GLOBAL_VARIABLES")
264 order by show_mode, source, variable_name;
265 SHOW_MODE SOURCE VARIABLE_NAME
266
267 ================================================================================
268 TEST 2A
269 Present in 5.6 I_S.GLOBAL_VARIABLES (1-1)
270 Missing in 5.6 P_S.GLOBAL_VARIABLES (1-3)
271 ================================================================================
272 select * from test.sanity
273 where show_mode = "5.6"
274 and source = "I_S.GLOBAL_VARIABLES"
275 and upper(variable_name) not in (
276 select upper(variable_name) from test.sanity
277 where show_mode = "5.6"
278 and source = "P_S.GLOBAL_VARIABLES")
279 order by show_mode, source, variable_name;
280 SHOW_MODE SOURCE VARIABLE_NAME
281 5.6 I_S.GLOBAL_VARIABLES SQL_LOG_BIN
282
283 ================================================================================
284 TEST 2B
285 Present in 5.6 I_S.GLOBAL_VARIABLES (1-1)
286 Missing in 5.7 P_S.GLOBAL_VARIABLES (2-3)
287 ================================================================================
288 select * from test.sanity
289 where show_mode = "5.6"
290 and source = "I_S.GLOBAL_VARIABLES"
291 and upper(variable_name) not in (
292 select upper(variable_name) from test.sanity
293 where show_mode = "5.7"
294 and source = "P_S.GLOBAL_VARIABLES")
295 order by show_mode, source, variable_name;
296 SHOW_MODE SOURCE VARIABLE_NAME
297 5.6 I_S.GLOBAL_VARIABLES SQL_LOG_BIN
298
299 ================================================================================
300 TEST 3A
301 Present in 5.6 P_S.SESSION_VARIABLES (1-5)
302 Missing in 5.6 I_S.SESSION_VARIABLES (1-2)
303 ================================================================================
304 select * from test.sanity
305 where show_mode = "5.6"
306 and source = "P_S.SESSION_VARIABLES"
307 and upper(variable_name) not in (
308 select upper(variable_name) from test.sanity
309 where show_mode = "5.6"
310 and source = "I_S.SESSION_VARIABLES")
311 order by show_mode, source, variable_name;
312 SHOW_MODE SOURCE VARIABLE_NAME
313
314 ================================================================================
315 TEST 3B
316 Present in 5.7 P_S.SESSION_VARIABLES (2-5)
317 Missing in 5.6 I_S.SESSION_VARIABLES (1-2)
318 ================================================================================
319 select * from test.sanity
320 where show_mode = "5.7"
321 and source = "P_S.SESSION_VARIABLES"
322 and upper(variable_name) not in (
323 select upper(variable_name) from test.sanity
324 where show_mode = "5.6"
325 and source = "I_S.SESSION_VARIABLES")
326 order by show_mode, source, variable_name;
327 SHOW_MODE SOURCE VARIABLE_NAME
328
329 ================================================================================
330 TEST 4A
331 Present in 5.6 I_S.SESSION_VARIABLES (1-2)
332 Missing in 5.6 P_S.SESSION_VARIABLES (1-5)
333 ================================================================================
334 select * from test.sanity
335 where show_mode = "5.6"
336 and source = "I_S.SESSION_VARIABLES"
337 and upper(variable_name) not in (
338 select upper(variable_name) from test.sanity
339 where show_mode = "5.6"
340 and source = "P_S.SESSION_VARIABLES")
341 order by show_mode, source, variable_name;
342 SHOW_MODE SOURCE VARIABLE_NAME
343 5.6 I_S.SESSION_VARIABLES GTID_EXECUTED
344
345 ================================================================================
346 TEST 4B
347 Present in 5.6 I_S.SESSION_VARIABLES (1-2)
348 Missing in 5.7 P_S.SESSION_VARIABLES (2-5)
349 ================================================================================
350 select * from test.sanity
351 where show_mode = "5.6"
352 and source = "I_S.SESSION_VARIABLES"
353 and upper(variable_name) not in (
354 select upper(variable_name) from test.sanity
355 where show_mode = "5.7"
356 and source = "P_S.SESSION_VARIABLES")
357 order by show_mode, source, variable_name;
358 SHOW_MODE SOURCE VARIABLE_NAME
359 5.6 I_S.SESSION_VARIABLES GTID_EXECUTED
360
361 ================================================================================
362 TEST 5A
363 Present in 5.6 P_S.VARIABLES_BY_THREAD (1-4)
364 Missing in 5.6 I_S.SESSION_VARIABLES (1-2)
365 ================================================================================
366 select * from test.sanity
367 where show_mode = "5.6"
368 and source = "P_S.VARIABLES_BY_THREAD"
369 and upper(variable_name) not in (
370 select upper(variable_name) from test.sanity
371 where show_mode = "5.6"
372 and source = "I_S.SESSION_VARIABLES")
373 order by show_mode, source, variable_name;
374 SHOW_MODE SOURCE VARIABLE_NAME
375
376 ================================================================================
377 TEST 5B
378 Present in 5.7 P_S.VARIABLES_BY_THREAD (2-4)
379 Missing in 5.6 I_S.SESSION_VARIABLES (1-2)
380 ================================================================================
381 select * from test.sanity
382 where show_mode = "5.7"
383 and source = "P_S.VARIABLES_BY_THREAD"
384 and upper(variable_name) not in (
385 select upper(variable_name) from test.sanity
386 where show_mode = "5.6"
387 and source = "I_S.SESSION_VARIABLES")
388 order by show_mode, source, variable_name;
389 SHOW_MODE SOURCE VARIABLE_NAME
390
391 ================================================================================
392 TEST 5C
393 Present in 5.6 I_S.SESSION_VARIABLES (1-2)
394 Missing in 5.6 P_S.VARIABLES_BY_THREAD (1-4)
395 EXPECT NOTHING BESIDE KNOWN GLOBAL VARIABLES (2-14)
396 ================================================================================
397 select * from test.sanity
398 where show_mode = "5.6"
399 and source = "I_S.SESSION_VARIABLES"
400 and upper(variable_name) not in (
401 select upper(variable_name) from test.sanity
402 where show_mode = "5.6"
403 and source = "P_S.VARIABLES_BY_THREAD")
404 and upper(variable_name) not in (
405 select upper(variable_name) from test.sanity
406 where show_mode = "JUNK: GLOBAL-ONLY"
407 and source = "I_S.SESSION_VARIABLES")
408 order by show_mode, source, variable_name;
409 SHOW_MODE SOURCE VARIABLE_NAME
410 5.6 I_S.SESSION_VARIABLES BINLOG_TRANSACTION_DEPENDENCY_HISTORY_SIZE
411 5.6 I_S.SESSION_VARIABLES BINLOG_TRANSACTION_DEPENDENCY_TRACKING
412 5.6 I_S.SESSION_VARIABLES GTID_EXECUTED
413 5.6 I_S.SESSION_VARIABLES INNODB_DEADLOCK_DETECT
414 5.6 I_S.SESSION_VARIABLES INNODB_STATS_INCLUDE_DELETE_MARKED
415 5.6 I_S.SESSION_VARIABLES KEYRING_OPERATIONS
416 5.6 I_S.SESSION_VARIABLES LOG_STATEMENTS_UNSAFE_FOR_BINLOG
417 5.6 I_S.SESSION_VARIABLES PERFORMANCE_SCHEMA_SHOW_PROCESSLIST
418 5.6 I_S.SESSION_VARIABLES REPLICATION_OPTIMIZE_FOR_STATIC_PLUGIN_CONFIG
419 5.6 I_S.SESSION_VARIABLES REPLICATION_SENDER_OBSERVE_COMMIT_ONLY
420 5.6 I_S.SESSION_VARIABLES TLS_VERSION
421
422 ================================================================================
423 TEST 5D
424 Present in 5.6 I_S.SESSION_VARIABLES (1-2)
425 Missing in 5.7 P_S.VARIABLES_BY_THREAD (2-5)
426 EXPECT NOTHING BESIDE KNOWN GLOBAL VARIABLES (2-14)
427 ================================================================================
428 select * from test.sanity
429 where show_mode = "5.6"
430 and source = "I_S.SESSION_VARIABLES"
431 and upper(variable_name) not in (
432 select upper(variable_name) from test.sanity
433 where show_mode = "5.7"
434 and source = "P_S.VARIABLES_BY_THREAD")
435 and upper(variable_name) not in (
436 select upper(variable_name) from test.sanity
437 where show_mode = "JUNK: GLOBAL-ONLY"
438 and source = "I_S.SESSION_VARIABLES")
439 order by show_mode, source, variable_name;
440 SHOW_MODE SOURCE VARIABLE_NAME
441 5.6 I_S.SESSION_VARIABLES BINLOG_TRANSACTION_DEPENDENCY_HISTORY_SIZE
442 5.6 I_S.SESSION_VARIABLES BINLOG_TRANSACTION_DEPENDENCY_TRACKING
443 5.6 I_S.SESSION_VARIABLES GTID_EXECUTED
444 5.6 I_S.SESSION_VARIABLES INNODB_DEADLOCK_DETECT
445 5.6 I_S.SESSION_VARIABLES INNODB_STATS_INCLUDE_DELETE_MARKED
446 5.6 I_S.SESSION_VARIABLES KEYRING_OPERATIONS
447 5.6 I_S.SESSION_VARIABLES LOG_STATEMENTS_UNSAFE_FOR_BINLOG
448 5.6 I_S.SESSION_VARIABLES PERFORMANCE_SCHEMA_SHOW_PROCESSLIST
449 5.6 I_S.SESSION_VARIABLES REPLICATION_OPTIMIZE_FOR_STATIC_PLUGIN_CONFIG
450 5.6 I_S.SESSION_VARIABLES REPLICATION_SENDER_OBSERVE_COMMIT_ONLY
451 5.6 I_S.SESSION_VARIABLES TLS_VERSION
452
453 ================================================================================
454 TEST 5E
455 KNOWN GLOBAL VARIABLES (2-14)
456 Expect missing in 5.6 P_S.VARIABLES_BY_THREAD (1-4)
457 ================================================================================
458 select * from test.sanity
459 where show_mode = "JUNK: GLOBAL-ONLY"
460 and source = "I_S.SESSION_VARIABLES"
461 and upper(variable_name) in (
462 select upper(variable_name) from test.sanity
463 where show_mode = "5.6"
464 and source = "P_S.VARIABLES_BY_THREAD")
465 order by show_mode, source, variable_name;
466 SHOW_MODE SOURCE VARIABLE_NAME
467
468 ================================================================================
469 TEST 5F
470 KNOWN GLOBAL VARIABLES (2-14)
471 Expect missing in 5.7 P_S.VARIABLES_BY_THREAD (2-5)
472 ================================================================================
473 select * from test.sanity
474 where show_mode = "JUNK: GLOBAL-ONLY"
475 and source = "I_S.SESSION_VARIABLES"
476 and upper(variable_name) in (
477 select upper(variable_name) from test.sanity
478 where show_mode = "5.7"
479 and source = "P_S.VARIABLES_BY_THREAD")
480 order by show_mode, source, variable_name;
481 SHOW_MODE SOURCE VARIABLE_NAME
482
483 ================================================================================
484 TEST 6A
485 Present in 5.7 P_S.GLOBAL_STATUS (2-8)
486 Missing in 5.6 I_S.GLOBAL_STATUS (1-6)
487 EXPECT NOTHING
488 ================================================================================
489 select * from test.sanity
490 where show_mode = "5.7"
491 and source = "P_S.GLOBAL_STATUS"
492 and upper(variable_name) not in (
493 select upper(variable_name) from test.sanity
494 where show_mode = "5.6"
495 and source = "I_S.GLOBAL_STATUS")
496 order by show_mode, source, variable_name;
497 SHOW_MODE SOURCE VARIABLE_NAME
498
499 ================================================================================
500 TEST 6B
501 Present in 5.7 P_S.GLOBAL_STATUS (2-8)
502 Missing in 5.6 P_S.GLOBAL_STATUS (1-8)
503 EXPECT NOTHING
504 ================================================================================
505 select * from test.sanity
506 where show_mode = "5.7"
507 and source = "P_S.GLOBAL_STATUS"
508 and upper(variable_name) not in (
509 select upper(variable_name) from test.sanity
510 where show_mode = "5.6"
511 and source = "P_S.GLOBAL_STATUS")
512 order by show_mode, source, variable_name;
513 SHOW_MODE SOURCE VARIABLE_NAME
514
515 ================================================================================
516 TEST 6C
517 Present in 5.6 P_S.GLOBAL_STATUS (1-8)
518 Missing in 5.7 P_S.GLOBAL_STATUS (2-8)
519 EXPECT NOTHING
520 ================================================================================
521 select * from test.sanity
522 where show_mode = "5.6"
523 and source = "P_S.GLOBAL_STATUS"
524 and upper(variable_name) not in (
525 select upper(variable_name) from test.sanity
526 where show_mode = "5.7"
527 and source = "P_S.GLOBAL_STATUS")
528 order by show_mode, source, variable_name;
529 SHOW_MODE SOURCE VARIABLE_NAME
530
531 ================================================================================
532 TEST 7
533 Present in 5.6 I_S.GLOBAL_STATUS (1-6)
534 Missing in 5.7 P_S.GLOBAL_STATUS (2-8)
535 EXPECT NOTHING AFTER REMOVING KNOWN SESSION-ONLY, COM COUNTERS AND SLAVE-ONLY (2-16 & 2-16A & 2-16B)
536 ================================================================================
537 select * from test.sanity
538 where show_mode = "5.6"
539 and source = "I_S.GLOBAL_STATUS"
540 and upper(variable_name) not in (
541 select upper(variable_name) from test.sanity
542 where (show_mode = "JUNK: SESSION-ONLY" or show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY")
543 and source = "I_S.GLOBAL_STATUS")
544 and upper(variable_name) not in (
545 select upper(variable_name) from test.sanity
546 where show_mode = "5.7"
547 and source = "P_S.GLOBAL_STATUS")
548 order by show_mode, source, variable_name;
549 SHOW_MODE SOURCE VARIABLE_NAME
550 5.6 I_S.GLOBAL_STATUS COM_SHUTDOWN
551
552 ================================================================================
553 TEST 8
554 KNOWN SESSION-ONLY (2-16)
555 KNOWN COM COUNTERS (2-16A)
556 KNOWN SLAVE-ONLY (2-16B)
557 Status variables that should NOT be present in 5.7 P_S.GLOBAL_STATUS (2-8)
558 EXPECT NOTHING
559 ================================================================================
560 select * from test.sanity
561 where show_mode = "5.7"
562 and source = "P_S.GLOBAL_STATUS"
563 and upper(variable_name) in (
564 select upper(variable_name) from test.sanity
565 where (show_mode = "JUNK: SESSION-ONLY" or show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY")
566 and source = "I_S.GLOBAL_STATUS")
567 order by show_mode, source, variable_name;
568 SHOW_MODE SOURCE VARIABLE_NAME
569
570 ================================================================================
571 TEST 9A
572 Present in 5.7 P_S.SESSION_STATUS (2-10)
573 Missing in 5.6 I_S.SESSION_STATUS (1-7)
574 EXPECT NOTHING
575 ================================================================================
576 select * from test.sanity
577 where show_mode = "5.7"
578 and source = "P_S.SESSION_STATUS"
579 and upper(variable_name) not in (
580 select upper(variable_name) from test.sanity
581 where show_mode = "5.6"
582 and source = "I_S.SESSION_STATUS")
583 order by show_mode, source, variable_name;
584 SHOW_MODE SOURCE VARIABLE_NAME
585
586 ================================================================================
587 TEST 9B
588 Present in 5.7 P_S.SESSION_STATUS (2-10)
589 Missing in 5.6 P_S.SESSION_STATUS (1-10)
590 EXPECT NOTHING
591 ================================================================================
592 select * from test.sanity
593 where show_mode = "5.7"
594 and source = "P_S.SESSION_STATUS"
595 and upper(variable_name) not in (
596 select upper(variable_name) from test.sanity
597 where show_mode = "5.6"
598 and source = "P_S.SESSION_STATUS")
599 order by show_mode, source, variable_name;
600 SHOW_MODE SOURCE VARIABLE_NAME
601
602 ================================================================================
603 TEST 9C
604 Present in 5.6 P_S.SESSION_STATUS (1-10)
605 Missing in 5.7 P_S.SESSION_STATUS (2-10)
606 EXPECT NOTHING
607 ================================================================================
608 select * from test.sanity
609 where show_mode = "5.6"
610 and source = "P_S.SESSION_STATUS"
611 and upper(variable_name) not in (
612 select upper(variable_name) from test.sanity
613 where show_mode = "5.7"
614 and source = "P_S.SESSION_STATUS")
615 order by show_mode, source, variable_name;
616 SHOW_MODE SOURCE VARIABLE_NAME
617
618 ================================================================================
619 TEST 10
620 Present in 5.6 I_S.SESSION_STATUS (1-7)
621 Missing in 5.7 P_S.SESSION_STATUS (2-10)
622 EXPECT NOTHING AFTER REMOVING KNOWN COM COUNTERS AND SLAVE-ONLY (2-15A & 2-15B)
623 ================================================================================
624 select * from test.sanity
625 where show_mode = "5.6"
626 and source = "I_S.SESSION_STATUS"
627 and upper(variable_name) not in (
628 select upper(variable_name) from test.sanity
629 where (show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY")
630 and source = "I_S.SESSION_STATUS")
631 and upper(variable_name) not in (
632 select upper(variable_name) from test.sanity
633 where show_mode = "5.7"
634 and source = "P_S.SESSION_STATUS")
635 order by show_mode, source, variable_name;
636 SHOW_MODE SOURCE VARIABLE_NAME
637 5.6 I_S.SESSION_STATUS COM_SHUTDOWN
638
639 ================================================================================
640 TEST 11
641 KNOWN COM COUNTERS (2-15A)
642 KNOWN SLAVE-ONLY (2-15B)
643 Status variables that should NOT be present in 5.7 P_S.SESSION_STATUS (2-10)
644 EXPECT NOTHING
645 ================================================================================
646 select * from test.sanity
647 where show_mode = "5.7"
648 and source = "P_S.SESSION_STATUS"
649 and upper(variable_name) in (
650 select upper(variable_name) from test.sanity
651 where (show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY")
652 and source = "I_S.SESSION_STATUS")
653 order by show_mode, source, variable_name;
654 SHOW_MODE SOURCE VARIABLE_NAME
655
656 ================================================================================
657 TEST 12
658 Present in 5.7 P_S.SESSION_STATUS (2-10)
659 Missing in 5.7 P_S.STATUS_BY_THREAD
660 EXPECT NOTHING AFTER REMOVING KNOWN GLOBAL-ONLY (2-15)
661 ================================================================================
662 select * from test.sanity
663 where show_mode = "5.7"
664 and source = "P_S.SESSION_STATUS"
665 and upper(variable_name) not in (
666 select upper(variable_name) from test.sanity
667 where show_mode = "5.7"
668 and source = "P_S.STATUS_BY_THREAD")
669 and upper(variable_name) not in (
670 select upper(variable_name) from test.sanity
671 where (show_mode = "JUNK: GLOBAL-ONLY")
672 and source = "I_S.SESSION_STATUS")
673 order by show_mode, source, variable_name;
674 SHOW_MODE SOURCE VARIABLE_NAME
675
676 ================================================================================
677 TEST 13
678 Present in 5.7 P_S.STATUS_BY_THREAD
679 Missing in 5.7 P_S.SESSION_STATUS (2-10)
680 EXPECT NOTHING
681 ================================================================================
682 select * from test.sanity
683 where show_mode = "5.7"
684 and source = "P_S.STATUS_BY_THREAD"
685 and upper(variable_name) not in (
686 select upper(variable_name) from test.sanity
687 where show_mode = "5.7"
688 and source = "P_S.SESSION_STATUS")
689 order by show_mode, source, variable_name;
690 SHOW_MODE SOURCE VARIABLE_NAME
691
692 ================================================================================
693 TEST 14
694 Present in 5.7 P_S.SESSION_STATUS (2-10)
695 Missing in 5.7 P_S.STATUS_BY_ACCOUNT
696 EXPECT NOTHING AFTER REMOVING
697 - KNOWN GLOBAL-ONLY (2-15)
698 - STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
699 ================================================================================
700 select * from test.sanity
701 where show_mode = "5.7"
702 and source = "P_S.SESSION_STATUS"
703 and upper(variable_name) not in (
704 select upper(variable_name) from test.sanity
705 where show_mode = "JUNK"
706 and source = "NO AGGREGATE")
707 and upper(variable_name) not in (
708 select upper(variable_name) from test.sanity
709 where (show_mode = "JUNK: GLOBAL-ONLY")
710 and source = "I_S.SESSION_STATUS")
711 and upper(variable_name) not in (
712 select upper(variable_name) from test.sanity
713 where show_mode = "5.7"
714 and source = "P_S.STATUS_BY_ACCOUNT")
715 order by show_mode, source, variable_name;
716 SHOW_MODE SOURCE VARIABLE_NAME
717
718 ================================================================================
719 TEST 15
720 Present in 5.7 P_S.STATUS_BY_ACCOUNT
721 Missing in 5.7 P_S.SESSION_STATUS (2-10)
722 EXPECT NOTHING
723 ================================================================================
724 select * from test.sanity
725 where show_mode = "5.7"
726 and source = "P_S.STATUS_BY_ACCOUNT"
727 and upper(variable_name) not in (
728 select upper(variable_name) from test.sanity
729 where show_mode = "5.7"
730 and source = "P_S.SESSION_STATUS")
731 order by show_mode, source, variable_name;
732 SHOW_MODE SOURCE VARIABLE_NAME
733
734 ================================================================================
735 TEST 16
736 KNOWN STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
737 Status variables that should NOT be present in 5.7 P_S.STATUS_BY_ACCOUNT
738 ================================================================================
739 select * from performance_schema.status_by_account
740 where upper(variable_name) in (
741 select upper(variable_name) from test.sanity
742 where show_mode = "JUNK"
743 and source = "NO AGGREGATE")
744 order by variable_name;
745 USER HOST VARIABLE_NAME VARIABLE_VALUE
746
747 ================================================================================
748 TEST 17
749 Present in 5.7 P_S.SESSION_STATUS (2-10)
750 Missing in 5.7 P_S.STATUS_BY_USER
751 EXPECT NOTHING AFTER REMOVING
752 - KNOWN GLOBAL-ONLY (2-15)
753 - STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
754 ================================================================================
755 select * from test.sanity
756 where show_mode = "5.7"
757 and source = "P_S.SESSION_STATUS"
758 and upper(variable_name) not in (
759 select upper(variable_name) from test.sanity
760 where show_mode = "JUNK"
761 and source = "NO AGGREGATE")
762 and upper(variable_name) not in (
763 select upper(variable_name) from test.sanity
764 where (show_mode = "JUNK: GLOBAL-ONLY")
765 and source = "I_S.SESSION_STATUS")
766 and upper(variable_name) not in (
767 select upper(variable_name) from test.sanity
768 where show_mode = "5.7"
769 and source = "P_S.STATUS_BY_USER")
770 order by show_mode, source, variable_name;
771 SHOW_MODE SOURCE VARIABLE_NAME
772
773 ================================================================================
774 TEST 18
775 Present in 5.7 P_S.STATUS_BY_USER
776 Missing in 5.7 P_S.SESSION_STATUS (2-10)
777 ================================================================================
778 select * from test.sanity
779 where show_mode = "5.7"
780 and source = "P_S.STATUS_BY_USER"
781 and upper(variable_name) not in (
782 select upper(variable_name) from test.sanity
783 where show_mode = "5.7"
784 and source = "P_S.SESSION_STATUS")
785 order by show_mode, source, variable_name;
786 SHOW_MODE SOURCE VARIABLE_NAME
787
788 ================================================================================
789 TEST 19
790 KNOWN STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
791 Status variables that should NOT be present in 5.7 P_S.STATUS_BY_USER
792 ================================================================================
793 select * from performance_schema.status_by_user
794 where upper(variable_name) in (
795 select upper(variable_name) from test.sanity
796 where show_mode = "JUNK"
797 and source = "NO AGGREGATE")
798 order by variable_name;
799 USER VARIABLE_NAME VARIABLE_VALUE
800
801 ================================================================================
802 TEST 20
803 Present in 5.7 P_S.SESSION_STATUS (2-10)
804 Missing in 5.7 P_S.STATUS_BY_HOST
805 EXPECT NOTHING AFTER REMOVING
806 - KNOWN GLOBAL-ONLY (2-15)
807 - STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
808 ================================================================================
809 select * from test.sanity
810 where show_mode = "5.7"
811 and source = "P_S.SESSION_STATUS"
812 and upper(variable_name) not in (
813 select upper(variable_name) from test.sanity
814 where show_mode = "JUNK"
815 and source = "NO AGGREGATE")
816 and upper(variable_name) not in (
817 select upper(variable_name) from test.sanity
818 where (show_mode = "JUNK: GLOBAL-ONLY")
819 and source = "I_S.SESSION_STATUS")
820 and upper(variable_name) not in (
821 select upper(variable_name) from test.sanity
822 where show_mode = "5.7"
823 and source = "P_S.STATUS_BY_HOST")
824 order by show_mode, source, variable_name;
825 SHOW_MODE SOURCE VARIABLE_NAME
826
827 ================================================================================
828 TEST 21
829 Present in 5.7 P_S.STATUS_BY_HOST
830 Missing in 5.7 P_S.SESSION_STATUS (2-10)
831 ================================================================================
832 select * from test.sanity
833 where show_mode = "5.7"
834 and source = "P_S.STATUS_BY_HOST"
835 and upper(variable_name) not in (
836 select upper(variable_name) from test.sanity
837 where show_mode = "5.7"
838 and source = "P_S.SESSION_STATUS")
839 order by show_mode, source, variable_name;
840 SHOW_MODE SOURCE VARIABLE_NAME
841
842 ================================================================================
843 TEST 22
844 KNOWN STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
845 Status variables that should NOT be present in 5.7 P_S.STATUS_BY_HOST
846 ================================================================================
847 select * from performance_schema.status_by_host
848 where upper(variable_name) in (
849 select upper(variable_name) from test.sanity
850 where show_mode = "JUNK"
851 and source = "NO AGGREGATE")
852 order by variable_name;
853 HOST VARIABLE_NAME VARIABLE_VALUE
854
855 ================================================================================
856 CLEAN UP
857 ================================================================================
858 set @@global.show_compatibility_56 = @show_compatibility_56_save;
859 drop table test.sanity;