Debian Codegraph @

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

raw
1 # Creating table t1
2 CREATE TABLE t1(c1 INT NOT NULL, c2 INT, PRIMARY KEY(c1));
3 INSERT INTO t1 VALUES (1,1), (2,2), (3,1), (4,2), (5,1), (6,2), (7,3);
4 ##########################################
5 # Run plugin
6 ##########################################
7 INSTALL PLUGIN test_sql_commit SONAME 'TEST_SQL_COMMIT';
8 ##########################################
9 # Stop plugin
10 ##########################################
11 UNINSTALL PLUGIN test_sql_commit;
12 ##########################################
13 # Plugin log
14 ##########################################
15 ========================================================================
16 Test in a server thread
17 [srv_session_open]
18 ------------------------------------------------------------------
19 EXECUTING:[35][SELECT 'first complex command' as a]
20 [CS_TEXT_REPRESENTATION]
21 [protocol init]
22 [meta] rows: 1
23 [meta] cols: 1
24 [meta] server status: 2
25 [meta] server status: AUTOCOMMIT
26 [meta] warning count: 0
27
28 [meta][field] db name:
29 [meta][field] table name:
30 [meta][field] org table name:
31 [meta][field] col name: a
32 [meta][field] org col name:
33 [meta][field] length: 63
34 [meta][field] charsetnr: 33
35 [meta][field] flags: 1 (NOT_NULL )
36 [meta][field] decimals: 31
37 [meta][field] type: VARCHAR (15)
38
39
40 [meta][charset result] number: 33
41 [meta][charset result] name: utf8mb3
42 [meta][charset result] collation: utf8mb3_general_ci
43 [meta][charset result] sort order:
44
45 [data][.a][ 21][first complex command]
46
47 [end] server status: 2
48 [end] server status: AUTOCOMMIT
49 [end] warning count: 0
50 [CS_BINARY_REPRESENTATION]
51 [protocol init]
52 [meta] rows: 1
53 [meta] cols: 1
54 [meta] server status: 2
55 [meta] server status: AUTOCOMMIT
56 [meta] warning count: 0
57
58 [meta][field] db name:
59 [meta][field] table name:
60 [meta][field] org table name:
61 [meta][field] col name: a
62 [meta][field] org col name:
63 [meta][field] length: 63
64 [meta][field] charsetnr: 33
65 [meta][field] flags: 1 (NOT_NULL )
66 [meta][field] decimals: 31
67 [meta][field] type: VARCHAR (15)
68
69
70 [meta][charset result] number: 33
71 [meta][charset result] name: utf8mb3
72 [meta][charset result] collation: utf8mb3_general_ci
73 [meta][charset result] sort order:
74
75 [data][.a][ 21][first complex command]
76
77 [end] server status: 2
78 [end] server status: AUTOCOMMIT
79 [end] warning count: 0
80 ------------------------------------------------------------------
81 EXECUTING:[18][SET AUTOCOMMIT = 0]
82 [CS_TEXT_REPRESENTATION]
83 [protocol init]
84 [meta] rows: 0
85 [meta] cols: 0
86 [meta] server status: 2
87 [meta] server status: AUTOCOMMIT
88 [meta] warning count: 0
89
90 [meta] no columns
91
92 [meta] no charset
93
94 [data] no rows
95
96 [end] server status: 0
97 [end] server status:
98 [end] warning count: 0
99 ------------------------------------------------------------------
100 EXECUTING:[COM_INIT_DB][test]
101 ------------------------------------------------------------------
102 EXECUTING:[27][INSERT INTO t1 VALUES (8,4)]
103 [CS_TEXT_REPRESENTATION]
104 [protocol init]
105 [meta] rows: 0
106 [meta] cols: 0
107 [meta] server status: 2
108 [meta] server status: AUTOCOMMIT
109 [meta] warning count: 0
110
111 [meta] no columns
112
113 [meta] no charset
114
115 [data] no rows
116
117 [end] server status: 1
118 [end] server status: IN_TRANS
119 [end] warning count: 0
120 ------------------------------------------------------------------
121 EXECUTING:[COM_INIT_DB][]
122 ------------------------------------------------------------------
123 EXECUTING:[6][COMMIT]
124 [CS_TEXT_REPRESENTATION]
125 [protocol init]
126 [meta] rows: 0
127 [meta] cols: 0
128 [meta] server status: 2
129 [meta] server status: AUTOCOMMIT
130 [meta] warning count: 0
131
132 [meta] no columns
133
134 [meta] no charset
135
136 [data] no rows
137
138 [end] server status: 0
139 [end] server status:
140 [end] warning count: 0
141 ------------------------------------------------------------------
142 EXECUTING:[18][SET AUTOCOMMIT = 1]
143 [CS_TEXT_REPRESENTATION]
144 [protocol init]
145 [meta] rows: 0
146 [meta] cols: 0
147 [meta] server status: 2
148 [meta] server status: AUTOCOMMIT
149 [meta] warning count: 0
150
151 [meta] no columns
152
153 [meta] no charset
154
155 [data] no rows
156
157 [end] server status: 2
158 [end] server status: AUTOCOMMIT
159 [end] warning count: 0
160 ------------------------------------------------------------------
161 EXECUTING:[COM_INIT_DB][test]
162 ------------------------------------------------------------------
163 EXECUTING:[23][SELECT COUNT(*) FROM t1]
164 [CS_TEXT_REPRESENTATION]
165 [protocol init]
166 [meta] rows: 1
167 [meta] cols: 1
168 [meta] server status: 2
169 [meta] server status: AUTOCOMMIT
170 [meta] warning count: 0
171
172 [meta][field] db name:
173 [meta][field] table name:
174 [meta][field] org table name:
175 [meta][field] col name: COUNT(*)
176 [meta][field] org col name:
177 [meta][field] length: 21
178 [meta][field] charsetnr: 8
179 [meta][field] flags: 129 (NOT_NULL BINARY )
180 [meta][field] decimals: 0
181 [meta][field] type: LONGLONG (8)
182
183
184 [meta][charset result] number: 33
185 [meta][charset result] name: utf8mb3
186 [meta][charset result] collation: utf8mb3_general_ci
187 [meta][charset result] sort order:
188
189 [data][.COUNT(*)][ 1][8]
190
191 [end] server status: 2
192 [end] server status: AUTOCOMMIT
193 [end] warning count: 0
194 [CS_BINARY_REPRESENTATION]
195 [protocol init]
196 [meta] rows: 1
197 [meta] cols: 1
198 [meta] server status: 2
199 [meta] server status: AUTOCOMMIT
200 [meta] warning count: 0
201
202 [meta][field] db name:
203 [meta][field] table name:
204 [meta][field] org table name:
205 [meta][field] col name: COUNT(*)
206 [meta][field] org col name:
207 [meta][field] length: 21
208 [meta][field] charsetnr: 8
209 [meta][field] flags: 129 (NOT_NULL BINARY )
210 [meta][field] decimals: 0
211 [meta][field] type: LONGLONG (8)
212
213
214 [meta][charset result] number: 33
215 [meta][charset result] name: utf8mb3
216 [meta][charset result] collation: utf8mb3_general_ci
217 [meta][charset result] sort order:
218
219 [data][.COUNT(*)][ 1][8]
220
221 [end] server status: 2
222 [end] server status: AUTOCOMMIT
223 [end] warning count: 0
224 ------------------------------------------------------------------
225 [srv_session_close]
226 Follows threaded run
227 ========================================================================
228 init thread
229 [srv_session_open]
230 ------------------------------------------------------------------
231 EXECUTING:[35][SELECT 'first complex command' as a]
232 [CS_TEXT_REPRESENTATION]
233 [protocol init]
234 [meta] rows: 1
235 [meta] cols: 1
236 [meta] server status: 2
237 [meta] server status: AUTOCOMMIT
238 [meta] warning count: 0
239
240 [meta][field] db name:
241 [meta][field] table name:
242 [meta][field] org table name:
243 [meta][field] col name: a
244 [meta][field] org col name:
245 [meta][field] length: 63
246 [meta][field] charsetnr: 33
247 [meta][field] flags: 1 (NOT_NULL )
248 [meta][field] decimals: 31
249 [meta][field] type: VARCHAR (15)
250
251
252 [meta][charset result] number: 33
253 [meta][charset result] name: utf8mb3
254 [meta][charset result] collation: utf8mb3_general_ci
255 [meta][charset result] sort order:
256
257 [data][.a][ 21][first complex command]
258
259 [end] server status: 2
260 [end] server status: AUTOCOMMIT
261 [end] warning count: 0
262 [CS_BINARY_REPRESENTATION]
263 [protocol init]
264 [meta] rows: 1
265 [meta] cols: 1
266 [meta] server status: 2
267 [meta] server status: AUTOCOMMIT
268 [meta] warning count: 0
269
270 [meta][field] db name:
271 [meta][field] table name:
272 [meta][field] org table name:
273 [meta][field] col name: a
274 [meta][field] org col name:
275 [meta][field] length: 63
276 [meta][field] charsetnr: 33
277 [meta][field] flags: 1 (NOT_NULL )
278 [meta][field] decimals: 31
279 [meta][field] type: VARCHAR (15)
280
281
282 [meta][charset result] number: 33
283 [meta][charset result] name: utf8mb3
284 [meta][charset result] collation: utf8mb3_general_ci
285 [meta][charset result] sort order:
286
287 [data][.a][ 21][first complex command]
288
289 [end] server status: 2
290 [end] server status: AUTOCOMMIT
291 [end] warning count: 0
292 ------------------------------------------------------------------
293 EXECUTING:[18][SET AUTOCOMMIT = 0]
294 [CS_TEXT_REPRESENTATION]
295 [protocol init]
296 [meta] rows: 0
297 [meta] cols: 0
298 [meta] server status: 2
299 [meta] server status: AUTOCOMMIT
300 [meta] warning count: 0
301
302 [meta] no columns
303
304 [meta] no charset
305
306 [data] no rows
307
308 [end] server status: 0
309 [end] server status:
310 [end] warning count: 0
311 ------------------------------------------------------------------
312 EXECUTING:[COM_INIT_DB][test]
313 ------------------------------------------------------------------
314 EXECUTING:[27][INSERT INTO t1 VALUES (8,4)]
315 [CS_TEXT_REPRESENTATION]
316 [protocol init]
317 [meta] rows: 0
318 [meta] cols: 0
319 [meta] server status: 2
320 [meta] server status: AUTOCOMMIT
321 [meta] warning count: 0
322
323 [meta] no columns
324
325 [meta] no charset
326
327 [data] no rows
328
329 [end] server status: 0
330 [end] server status:
331 [end] warning count: 0
332 ------------------------------------------------------------------
333 EXECUTING:[COM_INIT_DB][]
334 ------------------------------------------------------------------
335 EXECUTING:[6][COMMIT]
336 [CS_TEXT_REPRESENTATION]
337 [protocol init]
338 [meta] rows: 0
339 [meta] cols: 0
340 [meta] server status: 2
341 [meta] server status: AUTOCOMMIT
342 [meta] warning count: 0
343
344 [meta] no columns
345
346 [meta] no charset
347
348 [data] no rows
349
350 [end] server status: 0
351 [end] server status:
352 [end] warning count: 0
353 ------------------------------------------------------------------
354 EXECUTING:[18][SET AUTOCOMMIT = 1]
355 [CS_TEXT_REPRESENTATION]
356 [protocol init]
357 [meta] rows: 0
358 [meta] cols: 0
359 [meta] server status: 2
360 [meta] server status: AUTOCOMMIT
361 [meta] warning count: 0
362
363 [meta] no columns
364
365 [meta] no charset
366
367 [data] no rows
368
369 [end] server status: 2
370 [end] server status: AUTOCOMMIT
371 [end] warning count: 0
372 ------------------------------------------------------------------
373 EXECUTING:[COM_INIT_DB][test]
374 ------------------------------------------------------------------
375 EXECUTING:[23][SELECT COUNT(*) FROM t1]
376 [CS_TEXT_REPRESENTATION]
377 [protocol init]
378 [meta] rows: 1
379 [meta] cols: 1
380 [meta] server status: 2
381 [meta] server status: AUTOCOMMIT
382 [meta] warning count: 0
383
384 [meta][field] db name:
385 [meta][field] table name:
386 [meta][field] org table name:
387 [meta][field] col name: COUNT(*)
388 [meta][field] org col name:
389 [meta][field] length: 21
390 [meta][field] charsetnr: 8
391 [meta][field] flags: 129 (NOT_NULL BINARY )
392 [meta][field] decimals: 0
393 [meta][field] type: LONGLONG (8)
394
395
396 [meta][charset result] number: 33
397 [meta][charset result] name: utf8mb3
398 [meta][charset result] collation: utf8mb3_general_ci
399 [meta][charset result] sort order:
400
401 [data][.COUNT(*)][ 1][8]
402
403 [end] server status: 2
404 [end] server status: AUTOCOMMIT
405 [end] warning count: 0
406 [CS_BINARY_REPRESENTATION]
407 [protocol init]
408 [meta] rows: 1
409 [meta] cols: 1
410 [meta] server status: 2
411 [meta] server status: AUTOCOMMIT
412 [meta] warning count: 0
413
414 [meta][field] db name:
415 [meta][field] table name:
416 [meta][field] org table name:
417 [meta][field] col name: COUNT(*)
418 [meta][field] org col name:
419 [meta][field] length: 21
420 [meta][field] charsetnr: 8
421 [meta][field] flags: 129 (NOT_NULL BINARY )
422 [meta][field] decimals: 0
423 [meta][field] type: LONGLONG (8)
424
425
426 [meta][charset result] number: 33
427 [meta][charset result] name: utf8mb3
428 [meta][charset result] collation: utf8mb3_general_ci
429 [meta][charset result] sort order:
430
431 [data][.COUNT(*)][ 1][8]
432
433 [end] server status: 2
434 [end] server status: AUTOCOMMIT
435 [end] warning count: 0
436 ------------------------------------------------------------------
437 [srv_session_close]
438 deinit thread
439 SET AUTOCOMMIT = 1;
440 # Dropping the created table
441 DROP TABLE t1;