← Back to branch summary

~ubuntu-branches/ubuntu/wily/mysql-5.6/wily

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/datadict/processlist_val.inc

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2015-04-16 20:07:10 UTC
  • mto: (1.3.9 vivid-proposed)
  • mto: This revision was merged to the branch mainline in revision 11.
  • Revision ID: package-import@ubuntu.com-20150416200710-pcrsa022082zj46k
Tags: upstream-5.6.24
Import upstream version 5.6.24

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/datadict/processlist_val.inc
93
93
#
94
94
# 1. Just dump what we get
95
95
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
 
96
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
96
97
--sorted_result
97
98
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
98
99
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
 
100
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
99
101
--sorted_result
100
102
SHOW FULL PROCESSLIST;
101
103
#
168
170
--source include/wait_condition.inc
169
171
# 1. Just dump what we get
170
172
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
 
173
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
171
174
--sorted_result
172
175
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
173
176
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
 
177
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
174
178
--sorted_result
175
179
SHOW FULL PROCESSLIST;
176
180
#
215
219
;
216
220
connection con1;
217
221
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
 
222
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
218
223
--sorted_result
219
224
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
220
225
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
 
226
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
221
227
--sorted_result
222
228
SHOW FULL PROCESSLIST;
223
229
 
251
257
connection con2;
252
258
# Just dump what we get
253
259
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
 
260
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
254
261
--sorted_result
255
262
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
256
263
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
 
264
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
257
265
--sorted_result
258
266
SHOW FULL PROCESSLIST;
259
267
#
313
321
--source include/wait_condition.inc
314
322
# 1. Just dump what we get
315
323
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
 
324
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
316
325
--sorted_result
317
326
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
318
327
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
 
328
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
319
329
--sorted_result
320
330
SHOW FULL PROCESSLIST;
321
331
#
386
396
# Expect to see the state 'Waiting for table metadata lock' for the third
387
397
# connection because the SELECT collides with the WRITE TABLE LOCK.
388
398
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
 
399
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
389
400
--sorted_result
390
401
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
391
402
UNLOCK TABLES;
446
457
# SHOW PROCESSLIST                               statement truncated after 100 char
447
458
;
448
459
--replace_column 1 <ID> 3 <HOST_NAME> 5 <COMMAND> 6 <TIME> 7 <STATE>
 
460
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
449
461
--sorted_result
450
462
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
451
463
--replace_column 1 <ID> 3 <HOST_NAME> 5 <COMMAND> 6 <TIME> 7 <STATE>
 
464
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
452
465
--sorted_result
453
466
SHOW FULL PROCESSLIST;
454
467
--replace_column 1 <ID> 3 <HOST_NAME> 5 <COMMAND> 6 <TIME> 7 <STATE>
 
468
--replace_result "init" STATE "starting" STATE "cleaning up" STATE
455
469
--sorted_result
456
470
SHOW PROCESSLIST;
457
471
UNLOCK TABLES;