1CREATE TABLE t_int (c1  TINYINT,
2c2  SMALLINT,
3c3  MEDIUMINT,
4c4  INT,
5c5  INTEGER,
6c6  SMALLINT UNSIGNED,
7c7  MEDIUMINT UNSIGNED,
8c8  INT UNSIGNED,
9c9  INTEGER);
10INSERT INTO t_int VALUES (91,92,93,94,95,96,97,98,99);
11INSERT INTO t_int VALUES (81,82,83,84,85,86,87,88,89);
12INSERT INTO t_int VALUES (71,72,73,74,75,76,77,78,79);
13SELECT * FROM t_int order by c1;
14c1	c2	c3	c4	c5	c6	c7	c8	c9
1571	72	73	74	75	76	77	78	79
1681	82	83	84	85	86	87	88	89
1791	92	93	94	95	96	97	98	99
18##########################################
19# Run plugin
20##########################################
21INSTALL PLUGIN test_session_detach SONAME 'TEST_SESSION_DETACH';
22##########################################
23# Stop plugin
24##########################################
25UNINSTALL PLUGIN test_session_detach;
26##########################################
27# Plugin log
28##########################################
29=========================================================================
30Test in a server thread
31Opening Session 1
32=========================================================================
33
34Query 01: SELECT * FROM test.t_int ORDER BY c1
35num_cols : 9
36nb rows  : 3
37c1 TINY(1)	c2 SHORT(2)	c3 INT24(9)	c4 LONG(3)	c5 LONG(3)	c6 SHORT(2)	c7 INT24(9)	c8 LONG(3)	c9 LONG(3)
3871		72		73		74		75		76		77		78		79
3981		82		83		84		85		86		87		88		89
4091		92		93		94		95		96		97		98		99
41
42affected rows : 0
43server status : 34
44warn count    : 0
45
46Detach Session 1
47
48Query 02: SELECT * FROM test.t_int ORDER BY c1
49num_cols : 9
50nb rows  : 3
51c1 TINY(1)	c2 SHORT(2)	c3 INT24(9)	c4 LONG(3)	c5 LONG(3)	c6 SHORT(2)	c7 INT24(9)	c8 LONG(3)	c9 LONG(3)
5271		72		73		74		75		76		77		78		79
5381		82		83		84		85		86		87		88		89
5491		92		93		94		95		96		97		98		99
55
56affected rows : 0
57server status : 34
58warn count    : 0
59
60Detach Session 1
61
62Query 03: SELECT * FROM test.t_int ORDER BY c1
63num_cols : 9
64nb rows  : 3
65c1 TINY(1)	c2 SHORT(2)	c3 INT24(9)	c4 LONG(3)	c5 LONG(3)	c6 SHORT(2)	c7 INT24(9)	c8 LONG(3)	c9 LONG(3)
6671		72		73		74		75		76		77		78		79
6781		82		83		84		85		86		87		88		89
6891		92		93		94		95		96		97		98		99
69
70affected rows : 0
71server status : 34
72warn count    : 0
73
74Detach Session 1
75
76Query 04: SELECT * FROM test.t_int ORDER BY c1
77num_cols : 9
78nb rows  : 3
79c1 TINY(1)	c2 SHORT(2)	c3 INT24(9)	c4 LONG(3)	c5 LONG(3)	c6 SHORT(2)	c7 INT24(9)	c8 LONG(3)	c9 LONG(3)
8071		72		73		74		75		76		77		78		79
8181		82		83		84		85		86		87		88		89
8291		92		93		94		95		96		97		98		99
83
84affected rows : 0
85server status : 34
86warn count    : 0
87
88Detach Session 1
89
90Query 05: SELECT * FROM test.t_int ORDER BY c1
91num_cols : 9
92nb rows  : 3
93c1 TINY(1)	c2 SHORT(2)	c3 INT24(9)	c4 LONG(3)	c5 LONG(3)	c6 SHORT(2)	c7 INT24(9)	c8 LONG(3)	c9 LONG(3)
9471		72		73		74		75		76		77		78		79
9581		82		83		84		85		86		87		88		89
9691		92		93		94		95		96		97		98		99
97
98affected rows : 0
99server status : 34
100warn count    : 0
101
102Detach Session 1
103=========================================================================
104Close Session 1
105Follows threaded run
106=========================================================================
107init thread
108Opening Session 1
109=========================================================================
110
111Query 01: SELECT * FROM test.t_int ORDER BY c1
112num_cols : 9
113nb rows  : 3
114c1 TINY(1)	c2 SHORT(2)	c3 INT24(9)	c4 LONG(3)	c5 LONG(3)	c6 SHORT(2)	c7 INT24(9)	c8 LONG(3)	c9 LONG(3)
11571		72		73		74		75		76		77		78		79
11681		82		83		84		85		86		87		88		89
11791		92		93		94		95		96		97		98		99
118
119affected rows : 0
120server status : 34
121warn count    : 0
122
123Detach Session 1
124
125Query 02: SELECT * FROM test.t_int ORDER BY c1
126num_cols : 9
127nb rows  : 3
128c1 TINY(1)	c2 SHORT(2)	c3 INT24(9)	c4 LONG(3)	c5 LONG(3)	c6 SHORT(2)	c7 INT24(9)	c8 LONG(3)	c9 LONG(3)
12971		72		73		74		75		76		77		78		79
13081		82		83		84		85		86		87		88		89
13191		92		93		94		95		96		97		98		99
132
133affected rows : 0
134server status : 34
135warn count    : 0
136
137Detach Session 1
138
139Query 03: SELECT * FROM test.t_int ORDER BY c1
140num_cols : 9
141nb rows  : 3
142c1 TINY(1)	c2 SHORT(2)	c3 INT24(9)	c4 LONG(3)	c5 LONG(3)	c6 SHORT(2)	c7 INT24(9)	c8 LONG(3)	c9 LONG(3)
14371		72		73		74		75		76		77		78		79
14481		82		83		84		85		86		87		88		89
14591		92		93		94		95		96		97		98		99
146
147affected rows : 0
148server status : 34
149warn count    : 0
150
151Detach Session 1
152
153Query 04: SELECT * FROM test.t_int ORDER BY c1
154num_cols : 9
155nb rows  : 3
156c1 TINY(1)	c2 SHORT(2)	c3 INT24(9)	c4 LONG(3)	c5 LONG(3)	c6 SHORT(2)	c7 INT24(9)	c8 LONG(3)	c9 LONG(3)
15771		72		73		74		75		76		77		78		79
15881		82		83		84		85		86		87		88		89
15991		92		93		94		95		96		97		98		99
160
161affected rows : 0
162server status : 34
163warn count    : 0
164
165Detach Session 1
166
167Query 05: SELECT * FROM test.t_int ORDER BY c1
168num_cols : 9
169nb rows  : 3
170c1 TINY(1)	c2 SHORT(2)	c3 INT24(9)	c4 LONG(3)	c5 LONG(3)	c6 SHORT(2)	c7 INT24(9)	c8 LONG(3)	c9 LONG(3)
17171		72		73		74		75		76		77		78		79
17281		82		83		84		85		86		87		88		89
17391		92		93		94		95		96		97		98		99
174
175affected rows : 0
176server status : 34
177warn count    : 0
178
179Detach Session 1
180=========================================================================
181Close Session 1
182deinit thread
183##########################################
184# Cleanup
185##########################################
186DROP TABLE IF EXISTS t_int;
187