Debian Codegraph @

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

raw
1 #
2 # ================================================================================
3 # SETUP
4 # ================================================================================
5 SET @@session.sql_log_bin=OFF;
6 #
7 # CREATE 3 CLIENTS, 3 CONNECTIONS, RESULTS TABLE
8 connection default;
9 USE test;
10 flush global status;
11 #
12 # Create results table
13 CREATE TABLE test.status_results
14 (variable_name VARCHAR(64), start INT DEFAULT 0, stop INT DEFAULT 0, delta INT DEFAULT 0,
15 t1 INT DEFAULT 0, t2 INT DEFAULT 0, t3 INT DEFAULT 0, thread INT DEFAULT 0,
16 u1 INT DEFAULT 0, u2 INT DEFAULT 0, u3 INT DEFAULT 0, user INT DEFAULT 0,
17 h1 INT DEFAULT 0, h2 INT DEFAULT 0, h3 INT DEFAULT 0, host INT DEFAULT 0,
18 a1 INT DEFAULT 0, a2 INT DEFAULT 0, a3 INT DEFAULT 0, acct INT DEFAULT 0);
19 INSERT INTO test.status_results (variable_name, start)
20 SELECT sg.variable_name, sg.variable_value+0 FROM performance_schema.global_status sg
21 WHERE variable_name IN ('handler_delete', 'handler_rollback');
22
23 # Create test tables
24 CREATE TABLE t1 (s1 int) ENGINE=InnoDB;
25 INSERT INTO t1 VALUES (1), (2), (2), (3), (3), (3);
26 CREATE TABLE t2 (s1 int) ENGINE=InnoDB;
27 CREATE TABLE t3 (s1 int) ENGINE=InnoDB;
28 #
29 set @orig_sql_mode= @@sql_mode;
30 set sql_mode= (select replace(@@sql_mode,'NO_AUTO_CREATE_USER',''));
31 GRANT ALL ON *.* to 'user1'@localhost;
32 GRANT ALL ON *.* to 'user2'@localhost;
33 GRANT ALL ON *.* to 'user3'@localhost;
34 set sql_mode= @orig_sql_mode;
35 #
36 # ================================================================================
37 # CONNECTION 1: DELETE 1, ROLLBACK x 1
38 # ================================================================================
39 connect con1, localhost, user1,,;
40 SET @@session.sql_log_bin=OFF;
41 DELETE FROM t1 WHERE s1 = 1;
42 START TRANSACTION;
43 INSERT INTO t1 VALUES (1);
44 ROLLBACK;
45 #
46 # ================================================================================
47 # CONNECTION 2: DELETE 2, ROLLBACK x 2
48 # ================================================================================
49 connect con2, localhost, user2,,;
50 SET @@session.sql_log_bin=OFF;
51 DELETE FROM t1 WHERE s1 = 2;
52 #
53 START TRANSACTION;
54 INSERT INTO t1 VALUES (2);
55 ROLLBACK;
56 #
57 START TRANSACTION;
58 INSERT INTO t1 VALUES (2);
59 ROLLBACK;
60 #
61 # ================================================================================
62 # CONNECTION 3: DELETE 3, ROLLBACK x 3
63 # ================================================================================
64 connect con3, localhost, user3,,;
65 SET @@session.sql_log_bin=OFF;
66 DELETE FROM t1 WHERE s1 = 3;
67 #
68 START TRANSACTION;
69 INSERT INTO t1 VALUES (3);
70 ROLLBACK;
71 #
72 START TRANSACTION;
73 INSERT INTO t1 VALUES (3);
74 ROLLBACK;
75 #
76 START TRANSACTION;
77 INSERT INTO t1 VALUES (3);
78 ROLLBACK;
79 #
80 # ================================================================================
81 # CONNECTION DEFAULT: Gather results, compare session and global status counts
82 # ================================================================================
83 connection default;
84 # Get thread ids for each connection.
85 USE performance_schema;
86 SELECT thread_id INTO @con1_id FROM threads WHERE processlist_user IN ('user1') and processlist_id;
87 SELECT thread_id INTO @con2_id FROM threads WHERE processlist_user IN ('user2') and processlist_id;
88 SELECT thread_id INTO @con3_id FROM threads WHERE processlist_user IN ('user3') and processlist_id;
89 #=================
90 # Global results
91 #=================
92 USE test;
93 UPDATE test.status_results sr, performance_schema.global_status sg
94 SET sr.stop = sg.variable_value
95 WHERE sr.variable_name = sg.variable_name
96 AND sg.variable_name IN ('handler_delete', 'handler_rollback');
97 #
98 # Global deltas: END - START.
99 UPDATE test.status_results sr
100 SET sr.delta = sr.stop - sr.start;
101 #=================
102 # Status by thread
103 #=================
104 # Thread results from CON1.
105 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
106 SET sr.t1 = sbt.variable_value
107 WHERE sr.variable_name = sbt.variable_name
108 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
109 AND sbt.thread_id = @con1_id;
110 #
111 # Thread results from CON2.
112 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
113 SET sr.t2 = sbt.variable_value
114 WHERE sr.variable_name = sbt.variable_name
115 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
116 AND sbt.thread_id = @con2_id;
117 #
118 # Thread results from CON3.
119 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
120 SET sr.t3 = sbt.variable_value
121 WHERE sr.variable_name = sbt.variable_name
122 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
123 AND sbt.thread_id = @con3_id;
124 #
125 # Thread totals for 3 connections.
126 UPDATE test.status_results sr
127 SET sr.thread = sr.t1 + sr.t2 + sr.t3;
128 #=================
129 # Status by user
130 #=================
131 # User1
132 UPDATE test.status_results sr, performance_schema.status_by_user sbu
133 SET sr.u1 = sbu.variable_value
134 WHERE sr.variable_name = sbu.variable_name
135 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
136 AND sbu.user IN ('user1');
137 #
138 # User2
139 UPDATE test.status_results sr, performance_schema.status_by_user sbu
140 SET sr.u2 = sbu.variable_value
141 WHERE sr.variable_name = sbu.variable_name
142 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
143 AND sbu.user IN ('user2');
144 #
145 # User3
146 UPDATE test.status_results sr, performance_schema.status_by_user sbu
147 SET sr.u3 = sbu.variable_value
148 WHERE sr.variable_name = sbu.variable_name
149 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
150 AND sbu.user IN ('user3');
151 #
152 # Status totals for 3 users.
153 UPDATE test.status_results sr
154 SET sr.user = sr.u1 + sr.u2 + sr.u3;
155 #===========================
156 # Status by host (localhost)
157 #===========================
158 #
159 # host1 = localhost
160 UPDATE test.status_results sr, performance_schema.status_by_host sbh
161 SET sr.h1 = sbh.variable_value
162 WHERE sr.variable_name = sbh.variable_name
163 AND sbh.variable_name IN ('handler_delete', 'handler_rollback')
164 AND sbh.host IN ('localhost');
165 #
166 # Status totals for 'localhost' only.
167 UPDATE test.status_results sr
168 SET sr.host = sr.h1 + sr.h2 + sr.h3;
169 #==================
170 # Status by account
171 #==================
172 # User1@localhost
173 UPDATE test.status_results sr, performance_schema.status_by_account sba
174 SET sr.a1 = sba.variable_value
175 WHERE sr.variable_name = sba.variable_name
176 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
177 AND sba.user IN ('user1');
178 #
179 # User2@localhost
180 UPDATE test.status_results sr, performance_schema.status_by_account sba
181 SET sr.a2 = sba.variable_value
182 WHERE sr.variable_name = sba.variable_name
183 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
184 AND sba.user IN ('user2');
185 #
186 # User3@localhost
187 UPDATE test.status_results sr, performance_schema.status_by_account sba
188 SET sr.a3 = sba.variable_value
189 WHERE sr.variable_name = sba.variable_name
190 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
191 AND sba.user IN ('user3');
192 #
193 #
194 # Status totals for 3 accounts.
195 UPDATE test.status_results sr
196 SET sr.acct = sr.a1 + sr.a2 + sr.a3;
197 #
198 # ================================================================================
199 # TEST 1: STATUS_BY_THREAD: Verify expected status counts per thread (1,2,3)
200 # ================================================================================
201 #
202 # Review per-thread status counts
203 #
204 USE performance_schema;
205 #
206 # Verify expected counts for 'handler_delete' per thread
207 #
208 SELECT *, IF (variable_value = 1,'OK1','ERROR1') AS Expected FROM status_by_thread WHERE thread_id = @con1_id AND variable_name IN ('handler_delete', 'handler_rollback');
209 THREAD_ID VARIABLE_NAME VARIABLE_VALUE Expected
210 con_1 Handler_delete 1 OK1
211 con_1 Handler_rollback 1 OK1
212 #
213 SELECT *, IF (variable_value = 2,'OK2','ERROR2') AS Expected FROM status_by_thread WHERE thread_id = @con2_id AND variable_name IN ('handler_delete', 'handler_rollback');
214 THREAD_ID VARIABLE_NAME VARIABLE_VALUE Expected
215 con_2 Handler_delete 2 OK2
216 con_2 Handler_rollback 2 OK2
217 #
218 SELECT *, IF (variable_value = 3,'OK3','ERROR3') AS Expected FROM status_by_thread WHERE thread_id = @con3_id AND variable_name IN ('handler_delete', 'handler_rollback');
219 THREAD_ID VARIABLE_NAME VARIABLE_VALUE Expected
220 con_3 Handler_delete 3 OK3
221 con_3 Handler_rollback 3 OK3
222 #
223 # STATUS_BY_THREAD vs. GLOBAL_STATUS
224 #
225 SELECT variable_name, t1, t2, t3, delta, thread, IF(thread=delta,'OK4','ERROR4') Expected
226 FROM test.status_results
227 ORDER BY variable_name;
228 variable_name t1 t2 t3 delta thread Expected
229 Handler_delete 1 2 3 6 6 OK4
230 Handler_rollback 1 2 3 6 6 OK4
231 #
232 # ================================================================================
233 # TEST 2: STATUS_BY_USER: Verify expected status counts per user (1,2,3)
234 # ================================================================================
235 SELECT *, IF (variable_value = 1,'OK5','ERROR5') AS Expected FROM status_by_user WHERE user IN ('user1') AND variable_name IN ('handler_delete');
236 USER VARIABLE_NAME VARIABLE_VALUE Expected
237 user1 Handler_delete 1 OK5
238 #
239 SELECT *, IF (variable_value = 2,'OK6','ERROR6') AS Expected FROM status_by_user WHERE user IN ('user2') AND variable_name IN ('handler_delete');
240 USER VARIABLE_NAME VARIABLE_VALUE Expected
241 user2 Handler_delete 2 OK6
242 #
243 SELECT *, IF (variable_value = 3,'OK7','ERROR7') AS Expected FROM status_by_user WHERE user IN ('user3') AND variable_name IN ('handler_delete');
244 USER VARIABLE_NAME VARIABLE_VALUE Expected
245 user3 Handler_delete 3 OK7
246 #
247 # STATUS_BY_USER vs. GLOBAL_STATUS
248 #
249 SELECT variable_name, u1, u2, u3, delta, user, IF(user=delta,'OK8','ERROR8') Expected
250 FROM test.status_results
251 ORDER BY variable_name;
252 variable_name u1 u2 u3 delta user Expected
253 Handler_delete 1 2 3 6 6 OK8
254 Handler_rollback 1 2 3 6 6 OK8
255 #
256 # ================================================================================
257 # TEST 3: STATUS_BY_ACCOUNT: Verify expected status counts per user, host (1,2,3)
258 # ================================================================================
259 SELECT *, IF (variable_value = 1,'OK9','ERROR9') AS Expected FROM status_by_account WHERE user IN ('user1') AND variable_name IN ('handler_delete');
260 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
261 user1 localhost Handler_delete 1 OK9
262 #
263 SELECT *, IF (variable_value = 2,'OKa','ERRORa') AS Expected FROM status_by_account WHERE user IN ('user2') AND variable_name IN ('handler_delete');
264 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
265 user2 localhost Handler_delete 2 OKa
266 #
267 SELECT *, IF (variable_value = 3,'OKb','ERRORb') AS Expected FROM status_by_account WHERE user IN ('user3') AND variable_name IN ('handler_delete');
268 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
269 user3 localhost Handler_delete 3 OKb
270 #
271 # STATUS_BY_ACCOUNT vs. GLOBAL_STATUS
272 #
273 SELECT variable_name, a1, a2, a3, delta, acct, IF(acct=delta,'OKc','ERRORc') Expected
274 FROM test.status_results
275 ORDER BY variable_name;
276 variable_name a1 a2 a3 delta acct Expected
277 Handler_delete 1 2 3 6 6 OKc
278 Handler_rollback 1 2 3 6 6 OKc
279 # ================================================================================
280 # TEST 4: STATUS_BY_HOST: Verify expected status counts per host (6)
281 # ================================================================================
282 SELECT *, IF (variable_value = 6,'OKd','ERRORd') AS Expected FROM status_by_host WHERE host IN ('localhost') AND variable_name IN ('handler_delete');
283 HOST VARIABLE_NAME VARIABLE_VALUE Expected
284 localhost Handler_delete 6 OKd
285 #
286 # STATUS_BY_HOST vs. GLOBAL_STATUS
287 #
288 # Special case: No way to isolate pre-existing 'localhost' activity, so
289 # just check global totals = sum(status_by_host).
290 #
291 SELECT variable_name, h1, h2, h3, delta, host, IF(host=delta,'OKe','ERRORe') Expected
292 FROM test.status_results
293 ORDER BY variable_name;
294 variable_name h1 h2 h3 delta host Expected
295 Handler_delete 6 0 0 6 6 OKe
296 Handler_rollback 6 0 0 6 6 OKe
297 #
298 # ================================================================================
299 # DISCONNECT ALL USERS AND RUN THE TESTS AGAIN. RESULTS SHOULD NOT CHANGE.
300 # ================================================================================
301 disconnect con1;
302 disconnect con2;
303 disconnect con3;
304 #
305 USE test;
306 #
307 # Clear results table, leave initial global_status counts
308 UPDATE test.status_results
309 SET stop=0, delta=0,
310 t1=0, t2=0, t3=0, thread=0,
311 u1=0, u2=0, u3=0, user=0,
312 h1=0, h2=0, h3=0, host=0,
313 a1=0, a2=0, a3=0, acct=0;
314 #
315 #=================
316 # Global results
317 #=================
318 USE test;
319 UPDATE test.status_results sr, performance_schema.global_status sg
320 SET sr.stop = sg.variable_value
321 WHERE sr.variable_name = sg.variable_name
322 AND sg.variable_name IN ('handler_delete', 'handler_rollback');
323 #
324 # Global deltas: END - START.
325 UPDATE test.status_results sr
326 SET sr.delta = sr.stop - sr.start;
327 #=================
328 # Status by thread
329 #=================
330 # Thread results from CON1.
331 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
332 SET sr.t1 = sbt.variable_value
333 WHERE sr.variable_name = sbt.variable_name
334 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
335 AND sbt.thread_id = @con1_id;
336 #
337 # Thread results from CON2.
338 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
339 SET sr.t2 = sbt.variable_value
340 WHERE sr.variable_name = sbt.variable_name
341 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
342 AND sbt.thread_id = @con2_id;
343 #
344 # Thread results from CON3.
345 UPDATE test.status_results sr, performance_schema.status_by_thread sbt
346 SET sr.t3 = sbt.variable_value
347 WHERE sr.variable_name = sbt.variable_name
348 AND sbt.variable_name IN ('handler_delete', 'handler_rollback')
349 AND sbt.thread_id = @con3_id;
350 #
351 # Thread totals for 3 connections.
352 UPDATE test.status_results sr
353 SET sr.thread = sr.t1 + sr.t2 + sr.t3;
354 #=================
355 # Status by user
356 #=================
357 # User1
358 UPDATE test.status_results sr, performance_schema.status_by_user sbu
359 SET sr.u1 = sbu.variable_value
360 WHERE sr.variable_name = sbu.variable_name
361 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
362 AND sbu.user IN ('user1');
363 #
364 # User2
365 UPDATE test.status_results sr, performance_schema.status_by_user sbu
366 SET sr.u2 = sbu.variable_value
367 WHERE sr.variable_name = sbu.variable_name
368 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
369 AND sbu.user IN ('user2');
370 #
371 # User3
372 UPDATE test.status_results sr, performance_schema.status_by_user sbu
373 SET sr.u3 = sbu.variable_value
374 WHERE sr.variable_name = sbu.variable_name
375 AND sbu.variable_name IN ('handler_delete', 'handler_rollback')
376 AND sbu.user IN ('user3');
377 #
378 # Status totals for 3 users.
379 UPDATE test.status_results sr
380 SET sr.user = sr.u1 + sr.u2 + sr.u3;
381 #===========================
382 # Status by host (localhost)
383 #===========================
384 #
385 # host1 = localhost
386 UPDATE test.status_results sr, performance_schema.status_by_host sbh
387 SET sr.h1 = sbh.variable_value
388 WHERE sr.variable_name = sbh.variable_name
389 AND sbh.variable_name IN ('handler_delete', 'handler_rollback')
390 AND sbh.host IN ('localhost');
391 #
392 # Status totals for 'localhost' only.
393 UPDATE test.status_results sr
394 SET sr.host = sr.h1 + sr.h2 + sr.h3;
395 #==================
396 # Status by account
397 #==================
398 # User1@localhost
399 UPDATE test.status_results sr, performance_schema.status_by_account sba
400 SET sr.a1 = sba.variable_value
401 WHERE sr.variable_name = sba.variable_name
402 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
403 AND sba.user IN ('user1');
404 #
405 # User2@localhost
406 UPDATE test.status_results sr, performance_schema.status_by_account sba
407 SET sr.a2 = sba.variable_value
408 WHERE sr.variable_name = sba.variable_name
409 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
410 AND sba.user IN ('user2');
411 #
412 # User3@localhost
413 UPDATE test.status_results sr, performance_schema.status_by_account sba
414 SET sr.a3 = sba.variable_value
415 WHERE sr.variable_name = sba.variable_name
416 AND sba.variable_name IN ('handler_delete', 'handler_rollback')
417 AND sba.user IN ('user3');
418 #
419 #
420 # Status totals for 3 accounts.
421 UPDATE test.status_results sr
422 SET sr.acct = sr.a1 + sr.a2 + sr.a3;
423 USE performance_schema;
424 #
425 # ================================================================================
426 # TEST X: STATUS_BY_THREAD: Connections are gone--nothing to verify.
427 # ================================================================================
428 #
429 # ================================================================================
430 # TEST 5: STATUS_BY_USER: Verify expected status counts per user (1,2,3)
431 # ================================================================================
432 SELECT *, IF (variable_value = 1,'OKf','ERRORf') AS Expected FROM status_by_user WHERE user IN ('user1') AND variable_name IN ('handler_delete');
433 USER VARIABLE_NAME VARIABLE_VALUE Expected
434 user1 Handler_delete 1 OKf
435 #
436 SELECT *, IF (variable_value = 2,'OKg','ERRORg') AS Expected FROM status_by_user WHERE user IN ('user2') AND variable_name IN ('handler_delete');
437 USER VARIABLE_NAME VARIABLE_VALUE Expected
438 user2 Handler_delete 2 OKg
439 #
440 SELECT *, IF (variable_value = 3,'OKh','ERRORh') AS Expected FROM status_by_user WHERE user IN ('user3') AND variable_name IN ('handler_delete');
441 USER VARIABLE_NAME VARIABLE_VALUE Expected
442 user3 Handler_delete 3 OKh
443 #
444 # STATUS_BY_USER vs. GLOBAL_STATUS
445 #
446 SELECT variable_name, u1, u2, u3, delta, user, IF(user=delta,'OKi','ERRORi') Expected
447 FROM test.status_results
448 ORDER BY variable_name;
449 variable_name u1 u2 u3 delta user Expected
450 Handler_delete 1 2 3 6 6 OKi
451 Handler_rollback 1 2 3 6 6 OKi
452 #
453 # ================================================================================
454 # TEST 6: STATUS_BY_ACCOUNT: Verify expected status counts per user:host (1,2,3)
455 # ================================================================================
456 SELECT *, IF (variable_value = 1,'OKj','ERRORj') AS Expected FROM status_by_account WHERE user IN ('user1') AND variable_name IN ('handler_delete');
457 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
458 user1 localhost Handler_delete 1 OKj
459 #
460 SELECT *, IF (variable_value = 2,'OKk','ERRORk') AS Expected FROM status_by_account WHERE user IN ('user2') AND variable_name IN ('handler_delete');
461 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
462 user2 localhost Handler_delete 2 OKk
463 #
464 SELECT *, IF (variable_value = 3,'OKl','ERRORl') AS Expected FROM status_by_account WHERE user IN ('user3') AND variable_name IN ('handler_delete');
465 USER HOST VARIABLE_NAME VARIABLE_VALUE Expected
466 user3 localhost Handler_delete 3 OKl
467 #
468 # STATUS_BY_ACCOUNT vs. GLOBAL_STATUS
469 #
470 SELECT variable_name, a1, a2, a3, delta, acct, IF(acct=delta,'OKn','ERRORn') Expected
471 FROM test.status_results
472 ORDER BY variable_name;
473 variable_name a1 a2 a3 delta acct Expected
474 Handler_delete 1 2 3 6 6 OKn
475 Handler_rollback 1 2 3 6 6 OKn
476 # ================================================================================
477 # TEST 7: STATUS_BY_HOST: Verify expected status counts per host (6)
478 # ================================================================================
479 SELECT *, IF (variable_value = 6,'OKo','ERRORo') AS Expected FROM status_by_host WHERE host IN ('localhost') AND variable_name IN ('handler_delete');
480 HOST VARIABLE_NAME VARIABLE_VALUE Expected
481 localhost Handler_delete 6 OKo
482 #
483 # STATUS_BY_HOST vs. GLOBAL_STATUS
484 #
485 # Special case: No way to isolate pre-existing 'localhost' activity, so
486 # just check global totals = sum(status_by_host).
487 #
488 SELECT variable_name, h1, h2, h3, delta, host, IF(host=delta,'OKp','ERRORp') Expected
489 FROM test.status_results
490 ORDER BY variable_name;
491 variable_name h1 h2 h3 delta host Expected
492 Handler_delete 6 0 0 6 6 OKp
493 Handler_rollback 6 0 0 6 6 OKp
494 # ================================================================================
495 # TEST 8: FLUSH GLOBAL STATUS should clear account, host and user status
496 # ================================================================================
497 #
498 FLUSH GLOBAL STATUS;
499 #
500 SELECT * FROM status_by_account WHERE user IN ('user1', 'user2', 'user3') AND variable_name IN ('handler_delete');
501 USER HOST VARIABLE_NAME VARIABLE_VALUE
502 user1 localhost Handler_delete 0
503 user2 localhost Handler_delete 0
504 user3 localhost Handler_delete 0
505 #
506 SELECT * FROM status_by_host WHERE host IN ('localhost') AND variable_name IN ('handler_delete');
507 HOST VARIABLE_NAME VARIABLE_VALUE
508 localhost Handler_delete 0
509 #
510 SELECT * FROM status_by_user WHERE user IN ('user1', 'user2', 'user3') AND variable_name IN ('handler_delete');
511 USER VARIABLE_NAME VARIABLE_VALUE
512 user1 Handler_delete 0
513 user2 Handler_delete 0
514 user3 Handler_delete 0
515 # ================================================================================
516 # CLEANUP
517 # ================================================================================
518 DROP TABLE test.t1;
519 DROP TABLE test.t2;
520 DROP TABLE test.t3;
521 DROP TABLE test.status_results;
522 DROP USER 'user1'@localhost;
523 DROP USER 'user2'@localhost;
524 DROP USER 'user3'@localhost;
525 #