← Back to branch summary

~jlukas79/+junk/mysql-server

« back to all changes in this revision

Viewing changes to mysql-test/suite/funcs_1/r/processlist_val_no_prot.result

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/r/processlist_val_no_prot.result
17
17
  `TIME` bigint(7) NOT NULL DEFAULT '0',
18
18
  `STATE` varchar(64) DEFAULT NULL,
19
19
  `INFO` longtext
20
 
) ENGINE=MyISAM DEFAULT CHARSET=utf8
 
20
)  DEFAULT CHARSET=utf8
21
21
SELECT COUNT(*) FROM INFORMATION_SCHEMA.PROCESSLIST;
22
22
COUNT(*)
23
23
1
31
31
USE information_schema;
32
32
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
33
33
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
34
 
<ID>    root    localhost       information_schema      Query   <TIME>  executing       SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
 
34
<ID>    root    <HOST_NAME>     information_schema      Query   <TIME>  executing       SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
35
35
SHOW FULL PROCESSLIST;
36
36
Id      User    Host    db      Command Time    State   Info
37
 
<ID>    root    localhost       information_schema      Query   <TIME>  NULL    SHOW FULL PROCESSLIST
 
37
<ID>    root    <HOST_NAME>     information_schema      Query   <TIME>  NULL    SHOW FULL PROCESSLIST
38
38
SELECT INFO FROM INFORMATION_SCHEMA.PROCESSLIST;
39
39
INFO
40
40
SELECT INFO FROM INFORMATION_SCHEMA.PROCESSLIST
58
58
----- switch to connection ddicttestuser1 (user = ddicttestuser1) -----
59
59
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
60
60
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
61
 
<ID>    ddicttestuser1  localhost       information_schema      Query   <TIME>  executing       SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
 
61
<ID>    ddicttestuser1  <HOST_NAME>     information_schema      Query   <TIME>  executing       SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
62
62
SHOW FULL PROCESSLIST;
63
63
Id      User    Host    db      Command Time    State   Info
64
 
<ID>    ddicttestuser1  localhost       information_schema      Query   <TIME>  NULL    SHOW FULL PROCESSLIST
 
64
<ID>    ddicttestuser1  <HOST_NAME>     information_schema      Query   <TIME>  NULL    SHOW FULL PROCESSLIST
65
65
 
66
66
----- establish connection con2 (user = ddicttestuser1) ------
67
67
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
68
68
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
69
 
<ID>    ddicttestuser1  localhost       information_schema      Query   <TIME>  executing       SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
70
 
<ID>    ddicttestuser1  localhost       information_schema      Sleep   <TIME>  NULL    NULL
 
69
<ID>    ddicttestuser1  <HOST_NAME>     information_schema      Query   <TIME>  executing       SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
 
70
<ID>    ddicttestuser1  <HOST_NAME>     information_schema      Sleep   <TIME>  NULL    NULL
71
71
SHOW FULL PROCESSLIST;
72
72
Id      User    Host    db      Command Time    State   Info
73
 
<ID>    ddicttestuser1  localhost       information_schema      Sleep   <TIME>  NULL    NULL
74
 
<ID>    ddicttestuser1  localhost       information_schema      Query   <TIME>  NULL    SHOW FULL PROCESSLIST
 
73
<ID>    ddicttestuser1  <HOST_NAME>     information_schema      Sleep   <TIME>  NULL    NULL
 
74
<ID>    ddicttestuser1  <HOST_NAME>     information_schema      Query   <TIME>  NULL    SHOW FULL PROCESSLIST
75
75
 
76
76
----- switch to connection default (user = root) -----
77
77
----- close connection con2 -----
137
137
WHERE INFO IS NOT NULL AND STATE = 'Locked'
138
138
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
139
139
ID      USER    HOST    DB      COMMAND TIME    STATE   INFO
140
 
<ID>    ddicttestuser1  localhost       information_schema      Query   <TIME>  Table lock      SELECT COUNT(*) FROM test.t1
141
 
<ID>    root    localhost       information_schema      Query   <TIME>  executing       SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
 
140
<ID>    ddicttestuser1  <HOST_NAME>     information_schema      Query   <TIME>  Table lock      SELECT COUNT(*) FROM test.t1
 
141
<ID>    root    <HOST_NAME>     information_schema      Query   <TIME>  executing       SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST
142
142
SHOW FULL PROCESSLIST;
143
143
Id      User    Host    db      Command Time    State   Info
144
 
<ID>    root    localhost       information_schema      Query   <TIME>  NULL    SHOW FULL PROCESSLIST
145
 
<ID>    ddicttestuser1  localhost       information_schema      Query   <TIME>  Table lock      SELECT COUNT(*) FROM test.t1
 
144
<ID>    root    <HOST_NAME>     information_schema      Query   <TIME>  NULL    SHOW FULL PROCESSLIST
 
145
<ID>    ddicttestuser1  <HOST_NAME>     information_schema      Query   <TIME>  Table lock      SELECT COUNT(*) FROM test.t1
146
146
UNLOCK TABLES;
147
147
 
148
148
----- switch to connection ddicttestuser1 (user = ddicttestuser1) -----