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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
|
##########################################
# Run plugin
##########################################
INSTALL PLUGIN test_session_attach SONAME 'TEST_SESSION_ATTACH';
CREATE FUNCTION execute_test RETURNS INTEGER
SONAME 'TEST_SESSION_ATTACH';
##########################################
# Execute test case
##########################################
select execute_test();
execute_test()
0
##########################################
# Stop plugin
##########################################
DROP FUNCTION execute_test;
UNINSTALL PLUGIN test_session_attach;
##########################################
# Plugin log
##########################################
=========================================================================
Test in a server thread. Attach must fail on non srv_session thread.
Opening Session 1
Opening Session 2
Opening Session 3
Opening Session 4
Opening Session 5
Opening Session 6
Opening Session 7
Opening Session 8
Opening Session 9
Opening Session 10
=========================================================================
Query 01: SET SESSION test_session_attach_var_int = 10;
Query 02: SET SESSION test_session_attach_var_int = 20;
Query 03: SET SESSION test_session_attach_var_int = 30;
Query 04: SET SESSION test_session_attach_var_int = 40;
Query 05: SET SESSION test_session_attach_var_int = 50;
Query 06: SET SESSION test_session_attach_var_int = 60;
Query 07: SET SESSION test_session_attach_var_int = 70;
Query 08: SET SESSION test_session_attach_var_int = 80;
Query 09: SET SESSION test_session_attach_var_int = 90;
Query 10: SET SESSION test_session_attach_var_int = 100;
=========================================================================
Attach Session 1
Attach Session 1 failed.
Attach Session 2
Attach Session 2 failed.
Attach Session 3
Attach Session 3 failed.
Attach Session 4
Attach Session 4 failed.
Attach Session 5
Attach Session 5 failed.
Attach Session 6
Attach Session 6 failed.
Attach Session 7
Attach Session 7 failed.
Attach Session 8
Attach Session 8 failed.
Attach Session 9
Attach Session 9 failed.
Attach Session 10
Attach Session 10 failed.
=========================================================================
Close Session 1
Close Session 2
Close Session 3
Close Session 4
Close Session 5
Close Session 6
Close Session 7
Close Session 8
Close Session 9
Close Session 10
Closed all sessions
Follows threaded run. Successful scenario.
=========================================================================
init thread
Opening Session 1
Opening Session 2
Opening Session 3
Opening Session 4
Opening Session 5
Opening Session 6
Opening Session 7
Opening Session 8
Opening Session 9
Opening Session 10
=========================================================================
Query 01: SET SESSION test_session_attach_var_int = 10;
Query 02: SET SESSION test_session_attach_var_int = 20;
Query 03: SET SESSION test_session_attach_var_int = 30;
Query 04: SET SESSION test_session_attach_var_int = 40;
Query 05: SET SESSION test_session_attach_var_int = 50;
Query 06: SET SESSION test_session_attach_var_int = 60;
Query 07: SET SESSION test_session_attach_var_int = 70;
Query 08: SET SESSION test_session_attach_var_int = 80;
Query 09: SET SESSION test_session_attach_var_int = 90;
Query 10: SET SESSION test_session_attach_var_int = 100;
=========================================================================
Attach Session 1
Verify Session 1 variable
Detach Session 1
Attach Session 2
Verify Session 2 variable
Detach Session 2
Attach Session 3
Verify Session 3 variable
Detach Session 3
Attach Session 4
Verify Session 4 variable
Detach Session 4
Attach Session 5
Verify Session 5 variable
Detach Session 5
Attach Session 6
Verify Session 6 variable
Detach Session 6
Attach Session 7
Verify Session 7 variable
Detach Session 7
Attach Session 8
Verify Session 8 variable
Detach Session 8
Attach Session 9
Verify Session 9 variable
Detach Session 9
Attach Session 10
Verify Session 10 variable
Detach Session 10
=========================================================================
Close Session 1
Close Session 2
Close Session 3
Close Session 4
Close Session 5
Close Session 6
Close Session 7
Close Session 8
Close Session 9
Close Session 10
Closed all sessions
deinit thread
|
