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