1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
call mtr.add_suppression("This is a warning from test plugin");
call mtr.add_suppression("This is an error from test plugin");
------ Setup ------------------------------------------------
------ Run plugin ------------------------------------------------
INSTALL PLUGIN test_sql_reset_connection SONAME 'TEST_SQL_RESET_CONNECTION';
------ Stop plugin -----------------------------------------------
UNINSTALL PLUGIN test_sql_reset_connection;
------ Check output from tested service --------------------------------------
=======================================================================
COM_RESET_CONNECTION
set @secret = 123
select @secret
-----------------------------------------------------------------
@secret LONGLONG(8)
123
select @secret
-----------------------------------------------------------------
@secret VARCHAR(15)
[NULL]
Has session ID changed: 0
=======================================================================
COM_RESET_CONNECTION from another session
set @another_secret = 456
select @another_secret
-----------------------------------------------------------------
@another_secret LONGLONG(8)
456
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
do reset_connection()
COM_RESET_CONNECTION
set @secret = 123
select @secret
-----------------------------------------------------------------
@secret LONGLONG(8)
123
select @secret
-----------------------------------------------------------------
@secret VARCHAR(15)
[NULL]
Has session ID changed: 0
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
select @another_secret
-----------------------------------------------------------------
@another_secret LONGLONG(8)
456
Has session ID changed: 0
=======================================================================
------- Cleanup --------------------------------------
|
