← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

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

manual merge 6.0-main --> 6.0-bka-review

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/funcs_1/datadict/processlist_val.inc
34
34
#                   WL#3982 Test information_schema.processlist        #
35
35
# 2008-01-05 HHunger Changed time test and long statement test.        #
36
36
#                    It could happen that the long statement test      #
37
 
#                    fail due to timing problems.                      #          #                                                                      #
 
37
#                    fail due to timing problems.                      #
 
38
# 2008-04-14 pcrews Changed --replace_columns to include host          #
 
39
#                   this is due to failure occurring on Windows        #
 
40
#                   Win results included port number as well causing   #
 
41
#                   test failures                                      # 
38
42
########################################################################
39
43
 
40
44
# Basic preparations
53
57
 
54
58
# Show the definition of the PROCESSLIST table
55
59
#--------------------------------------------------------------------------
 
60
--replace_result ENGINE=MyISAM "" ENGINE=MARIA "" " PAGE_CHECKSUM=1" "" " PAGE_CHECKSUM=0" ""
56
61
SHOW CREATE TABLE INFORMATION_SCHEMA.PROCESSLIST;
57
62
 
58
63
 
76
81
#
77
82
# Expect to see now DB = 'information_schema'
78
83
USE information_schema;
79
 
--replace_column 1 <ID> 6 <TIME>
 
84
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
80
85
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
81
 
--replace_column 1 <ID> 6 <TIME>
 
86
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
82
87
SHOW FULL PROCESSLIST;
83
88
#
84
89
# Expect to see now INFO = 'SELECT INFO FROM INFORMATION_SCHEMA.PROCESSLIST;'
123
128
let $wait_condition= SELECT id,user,host,db,command,@time2:=time,state,info FROM INFORMATION_SCHEMA.PROCESSLIST
124
129
        WHERE TIME > @time;
125
130
--source include/wait_condition.inc
126
 
# 
 
131
#
127
132
# Expect to hit TIME > @time
128
133
SELECT @time < @time2;
129
134
#
139
144
--echo
140
145
--echo ----- switch to connection ddicttestuser1 (user = ddicttestuser1) -----
141
146
connection ddicttestuser1;
142
 
--replace_column 1 <ID> 6 <TIME>
 
147
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
143
148
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
144
 
--replace_column 1 <ID> 6 <TIME>
 
149
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
145
150
SHOW FULL PROCESSLIST;
146
151
 
147
152
 
156
161
let $wait_condition= SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST
157
162
        WHERE COMMAND = 'Sleep';
158
163
--source include/wait_condition.inc
159
 
--replace_column 1 <ID> 6 <TIME>
 
164
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
160
165
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
161
 
--replace_column 1 <ID> 6 <TIME>
 
166
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
162
167
SHOW FULL PROCESSLIST;
163
168
#
164
169
--echo
285
290
#
286
291
# Expect to see the state 'Locked' for the second connection because the SELECT
287
292
# collides with the WRITE TABLE LOCK.
288
 
--replace_column 1 <ID> 6 <TIME>
 
293
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
289
294
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
290
 
--replace_column 1 <ID> 6 <TIME>
 
295
--replace_column 1 <ID> 3 <HOST_NAME> 6 <TIME>
291
296
SHOW FULL PROCESSLIST;
292
297
UNLOCK TABLES;
293
298
#