Debian Codegraph @

mysql-test/suite/test_service_sql_api/r/test_sql_reset_connection.result

raw
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 --------------------------------------