Debian Codegraph @

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

raw
1 CREATE TABLE t_int (c1 TINYINT,
2 c2 SMALLINT,
3 c3 MEDIUMINT,
4 c4 INT,
5 c5 INTEGER,
6 c6 SMALLINT UNSIGNED,
7 c7 MEDIUMINT UNSIGNED,
8 c8 INT UNSIGNED,
9 c9 INTEGER);
10 INSERT INTO t_int VALUES (91,92,93,94,95,96,97,98,99);
11 INSERT INTO t_int VALUES (81,82,83,84,85,86,87,88,89);
12 INSERT INTO t_int VALUES (71,72,73,74,75,76,77,78,79);
13 SELECT * FROM t_int order by c1;
14 c1 c2 c3 c4 c5 c6 c7 c8 c9
15 71 72 73 74 75 76 77 78 79
16 81 82 83 84 85 86 87 88 89
17 91 92 93 94 95 96 97 98 99
18 ##########################################
19 # Run plugin
20 ##########################################
21 INSTALL PLUGIN test_session_detach SONAME 'TEST_SESSION_DETACH';
22 ##########################################
23 # Stop plugin
24 ##########################################
25 UNINSTALL PLUGIN test_session_detach;
26 ##########################################
27 # Plugin log
28 ##########################################
29 =========================================================================
30 Test in a server thread
31 Opening Session 1
32 =========================================================================
33
34 Query 01: SELECT * FROM test.t_int ORDER BY c1
35 num_cols : 9
36 nb rows : 3
37 c1 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)
38 71 72 73 74 75 76 77 78 79
39 81 82 83 84 85 86 87 88 89
40 91 92 93 94 95 96 97 98 99
41
42 affected rows : 0
43 server status : 34
44 warn count : 0
45
46 Detach Session 1
47
48 Query 02: SELECT * FROM test.t_int ORDER BY c1
49 num_cols : 9
50 nb rows : 3
51 c1 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)
52 71 72 73 74 75 76 77 78 79
53 81 82 83 84 85 86 87 88 89
54 91 92 93 94 95 96 97 98 99
55
56 affected rows : 0
57 server status : 34
58 warn count : 0
59
60 Detach Session 1
61
62 Query 03: SELECT * FROM test.t_int ORDER BY c1
63 num_cols : 9
64 nb rows : 3
65 c1 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)
66 71 72 73 74 75 76 77 78 79
67 81 82 83 84 85 86 87 88 89
68 91 92 93 94 95 96 97 98 99
69
70 affected rows : 0
71 server status : 34
72 warn count : 0
73
74 Detach Session 1
75
76 Query 04: SELECT * FROM test.t_int ORDER BY c1
77 num_cols : 9
78 nb rows : 3
79 c1 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)
80 71 72 73 74 75 76 77 78 79
81 81 82 83 84 85 86 87 88 89
82 91 92 93 94 95 96 97 98 99
83
84 affected rows : 0
85 server status : 34
86 warn count : 0
87
88 Detach Session 1
89
90 Query 05: SELECT * FROM test.t_int ORDER BY c1
91 num_cols : 9
92 nb rows : 3
93 c1 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)
94 71 72 73 74 75 76 77 78 79
95 81 82 83 84 85 86 87 88 89
96 91 92 93 94 95 96 97 98 99
97
98 affected rows : 0
99 server status : 34
100 warn count : 0
101
102 Detach Session 1
103 =========================================================================
104 Close Session 1
105 Follows threaded run
106 =========================================================================
107 init thread
108 Opening Session 1
109 =========================================================================
110
111 Query 01: SELECT * FROM test.t_int ORDER BY c1
112 num_cols : 9
113 nb rows : 3
114 c1 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)
115 71 72 73 74 75 76 77 78 79
116 81 82 83 84 85 86 87 88 89
117 91 92 93 94 95 96 97 98 99
118
119 affected rows : 0
120 server status : 34
121 warn count : 0
122
123 Detach Session 1
124
125 Query 02: SELECT * FROM test.t_int ORDER BY c1
126 num_cols : 9
127 nb rows : 3
128 c1 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)
129 71 72 73 74 75 76 77 78 79
130 81 82 83 84 85 86 87 88 89
131 91 92 93 94 95 96 97 98 99
132
133 affected rows : 0
134 server status : 34
135 warn count : 0
136
137 Detach Session 1
138
139 Query 03: SELECT * FROM test.t_int ORDER BY c1
140 num_cols : 9
141 nb rows : 3
142 c1 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)
143 71 72 73 74 75 76 77 78 79
144 81 82 83 84 85 86 87 88 89
145 91 92 93 94 95 96 97 98 99
146
147 affected rows : 0
148 server status : 34
149 warn count : 0
150
151 Detach Session 1
152
153 Query 04: SELECT * FROM test.t_int ORDER BY c1
154 num_cols : 9
155 nb rows : 3
156 c1 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)
157 71 72 73 74 75 76 77 78 79
158 81 82 83 84 85 86 87 88 89
159 91 92 93 94 95 96 97 98 99
160
161 affected rows : 0
162 server status : 34
163 warn count : 0
164
165 Detach Session 1
166
167 Query 05: SELECT * FROM test.t_int ORDER BY c1
168 num_cols : 9
169 nb rows : 3
170 c1 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)
171 71 72 73 74 75 76 77 78 79
172 81 82 83 84 85 86 87 88 89
173 91 92 93 94 95 96 97 98 99
174
175 affected rows : 0
176 server status : 34
177 warn count : 0
178
179 Detach Session 1
180 =========================================================================
181 Close Session 1
182 deinit thread
183 ##########################################
184 # Cleanup
185 ##########################################
186 DROP TABLE IF EXISTS t_int;