MySQL Lists are EOL. Please join:

List:Commits« Previous MessageNext Message »
From:mleich Date:November 22 2007 4:35pm
Subject:bk commit into 6.0 tree (mleich:1.2685) BUG#32233
View as plain text  
Below is the list of changes that have just been committed into a local
6.0 repository of mleich. When mleich does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet@stripped, 2007-11-22 17:35:37+01:00, mleich@stripped +2 -0
  Fix for
     Bug#32233 NULL "state" field of SHOW PROCESSLIST makes tests fail

  mysql-test/suite/funcs_1/r/a_processlist_priv_no_prot.result@stripped, 2007-11-22 17:35:36+01:00, mleich@stripped +84 -84
    Updated results

  mysql-test/suite/funcs_1/r/b_processlist_priv_ps.result@stripped, 2007-11-22 17:35:36+01:00, mleich@stripped +84 -84
    Updated results

diff -Nrup a/mysql-test/suite/funcs_1/r/a_processlist_priv_no_prot.result b/mysql-test/suite/funcs_1/r/a_processlist_priv_no_prot.result
--- a/mysql-test/suite/funcs_1/r/a_processlist_priv_no_prot.result	2007-10-29 09:31:11 +01:00
+++ b/mysql-test/suite/funcs_1/r/a_processlist_priv_no_prot.result	2007-11-22 17:35:36 +01:00
@@ -36,15 +36,15 @@ PROCESSLIST	CREATE TEMPORARY TABLE `PROC
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
 1	root	localhost	information_schema	Query	TIME	NULL	SHOW processlist
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 SELECT * FROM processlist  ORDER BY id;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 1	root	localhost	information_schema	Query	TIME	preparing	SELECT * FROM processlist  ORDER BY id
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist  ORDER BY id;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 1	root	localhost	information_schema	Query	TIME	preparing	SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist  ORDER BY id
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 CREATE TEMPORARY TABLE test.t_processlist AS SELECT * FROM processlist;
 UPDATE test.t_processlist SET user='horst' WHERE id=1  ;
 INSERT INTO processlist SELECT * FROM test.t_processlist;
@@ -183,14 +183,14 @@ Grants for ddicttestuser1@localhost
 GRANT PROCESS ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-1	root	localhost	information_schema	Sleep	TIME		NULL
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+1	root	localhost	information_schema	Sleep	TIME	NULL	NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 3	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 3	ddicttestuser1	localhost	information_schema	Query	TIME	preparing	SELECT * FROM information_schema.processlist
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-1	root	localhost	information_schema	Sleep	TIME		NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+1	root	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 5 Grant PROCESS privilege to anonymous user.
 connection default (user=root)
@@ -206,16 +206,16 @@ Grants for @localhost
 GRANT PROCESS ON *.* TO ''@'localhost'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-1	root	localhost	information_schema	Sleep	TIME		NULL
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+1	root	localhost	information_schema	Sleep	TIME	NULL	NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 4		localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 4		localhost	information_schema	Query	TIME	preparing	SELECT * FROM information_schema.processlist
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-1	root	localhost	information_schema	Sleep	TIME		NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+1	root	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 6 Revoke PROCESS privilege from ddicttestuser1
 connection default (user=root)
@@ -231,14 +231,14 @@ Grants for ddicttestuser1@localhost
 GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 5	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 5	ddicttestuser1	localhost	information_schema	Query	TIME	preparing	SELECT * FROM information_schema.processlist
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 7 Revoke PROCESS privilege from anonymous user + disconnect ddicttestuser1
 connection default (user=root)
@@ -255,7 +255,7 @@ GRANT USAGE ON *.* TO ''@'localhost'
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 6		localhost	information_schema	Query	TIME	preparing	SELECT * FROM information_schema.processlist
-4		localhost	information_schema	Sleep	TIME		NULL
+4		localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 8 Grant SUPER (does not imply PROCESS) privilege to ddicttestuser1
 connection default (user=root)
@@ -270,16 +270,16 @@ Grants for ddicttestuser1@localhost
 GRANT SUPER ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 7	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 7	ddicttestuser1	localhost	information_schema	Query	TIME	preparing	SELECT * FROM information_schema.processlist
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 9 Revoke SUPER privilege from user ddicttestuser1
 connection default (user=root)
@@ -295,18 +295,18 @@ Grants for ddicttestuser1@localhost
 GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 8	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 8	ddicttestuser1	localhost	information_schema	Query	TIME	preparing	SELECT * FROM information_schema.processlist
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 10 Grant SUPER privilege with grant option to user ddicttestuser1.
 connection default (user=root)
@@ -343,30 +343,30 @@ Grants for ddicttestuser2@localhost
 GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-1	root	localhost	information_schema	Sleep	TIME		NULL
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-4		localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-6		localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-8	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+1	root	localhost	information_schema	Sleep	TIME	NULL	NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+4		localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+6		localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+8	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 11	ddicttestuser2	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 11	ddicttestuser2	localhost	information_schema	Query	TIME	preparing	SELECT * FROM information_schema.processlist
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-8	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-6		localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-4		localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-1	root	localhost	information_schema	Sleep	TIME		NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+8	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+6		localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+4		localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+1	root	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 11 User ddicttestuser1 revokes PROCESS privilege from user ddicttestuser2
 connection ddicttestuser1;
@@ -381,12 +381,12 @@ Grants for ddicttestuser2@localhost
 GRANT USAGE ON *.* TO 'ddicttestuser2'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-11	ddicttestuser2	localhost	information_schema	Sleep	TIME		NULL
+11	ddicttestuser2	localhost	information_schema	Sleep	TIME	NULL	NULL
 12	ddicttestuser2	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 12	ddicttestuser2	localhost	information_schema	Query	TIME	preparing	SELECT * FROM information_schema.processlist
-11	ddicttestuser2	localhost	information_schema	Sleep	TIME		NULL
+11	ddicttestuser2	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 11.2 Revoke SUPER,PROCESS,GRANT OPTION privilege from user ddicttestuser1
 connection default (user=root)
@@ -404,24 +404,24 @@ GRANT PROCESS ON *.* TO 'ddicttestuser2'
 ERROR 28000: Access denied for user 'ddicttestuser1'@'localhost' (using password: YES)
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-8	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+8	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 13	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 13	ddicttestuser1	localhost	information_schema	Query	TIME	preparing	SELECT * FROM information_schema.processlist
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-8	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+8	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 12 Revoke the SELECT privilege from user ddicttestuser1
 connection default (user=root)
@@ -439,26 +439,26 @@ Grants for ddicttestuser1@localhost
 GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-8	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-13	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+8	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+13	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 14	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 14	ddicttestuser1	localhost	information_schema	Query	TIME	preparing	SELECT * FROM information_schema.processlist
-13	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-8	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-2	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+13	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+8	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+2	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 12.2 Revoke only the SELECT privilege on the information_schema from ddicttestuser1.
 connection default (user=root)
diff -Nrup a/mysql-test/suite/funcs_1/r/b_processlist_priv_ps.result b/mysql-test/suite/funcs_1/r/b_processlist_priv_ps.result
--- a/mysql-test/suite/funcs_1/r/b_processlist_priv_ps.result	2007-10-29 09:31:11 +01:00
+++ b/mysql-test/suite/funcs_1/r/b_processlist_priv_ps.result	2007-11-22 17:35:36 +01:00
@@ -36,15 +36,15 @@ PROCESSLIST	CREATE TEMPORARY TABLE `PROC
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
 3	root	localhost	information_schema	Query	TIME	NULL	SHOW processlist
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 SELECT * FROM processlist  ORDER BY id;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 3	root	localhost	information_schema	Execute	TIME	preparing	SELECT * FROM processlist  ORDER BY id
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist  ORDER BY id;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 3	root	localhost	information_schema	Execute	TIME	preparing	SELECT ID, USER, HOST, DB, COMMAND, TIME, STATE, INFO FROM processlist  ORDER BY id
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 CREATE TEMPORARY TABLE test.t_processlist AS SELECT * FROM processlist;
 UPDATE test.t_processlist SET user='horst' WHERE id=1  ;
 INSERT INTO processlist SELECT * FROM test.t_processlist;
@@ -183,14 +183,14 @@ Grants for ddicttestuser1@localhost
 GRANT PROCESS ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-3	root	localhost	information_schema	Sleep	TIME		NULL
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+3	root	localhost	information_schema	Sleep	TIME	NULL	NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 5	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 5	ddicttestuser1	localhost	information_schema	Execute	TIME	preparing	SELECT * FROM information_schema.processlist
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	root	localhost	information_schema	Sleep	TIME		NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	root	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 5 Grant PROCESS privilege to anonymous user.
 connection default (user=root)
@@ -206,16 +206,16 @@ Grants for @localhost
 GRANT PROCESS ON *.* TO ''@'localhost'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-3	root	localhost	information_schema	Sleep	TIME		NULL
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+3	root	localhost	information_schema	Sleep	TIME	NULL	NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 6		localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 6		localhost	information_schema	Execute	TIME	preparing	SELECT * FROM information_schema.processlist
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	root	localhost	information_schema	Sleep	TIME		NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	root	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 6 Revoke PROCESS privilege from ddicttestuser1
 connection default (user=root)
@@ -231,14 +231,14 @@ Grants for ddicttestuser1@localhost
 GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 7	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 7	ddicttestuser1	localhost	information_schema	Execute	TIME	preparing	SELECT * FROM information_schema.processlist
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 7 Revoke PROCESS privilege from anonymous user + disconnect ddicttestuser1
 connection default (user=root)
@@ -255,7 +255,7 @@ GRANT USAGE ON *.* TO ''@'localhost'
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 8		localhost	information_schema	Execute	TIME	preparing	SELECT * FROM information_schema.processlist
-6		localhost	information_schema	Sleep	TIME		NULL
+6		localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 8 Grant SUPER (does not imply PROCESS) privilege to ddicttestuser1
 connection default (user=root)
@@ -270,16 +270,16 @@ Grants for ddicttestuser1@localhost
 GRANT SUPER ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 9	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 9	ddicttestuser1	localhost	information_schema	Execute	TIME	preparing	SELECT * FROM information_schema.processlist
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 9 Revoke SUPER privilege from user ddicttestuser1
 connection default (user=root)
@@ -295,18 +295,18 @@ Grants for ddicttestuser1@localhost
 GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 10	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 10	ddicttestuser1	localhost	information_schema	Execute	TIME	preparing	SELECT * FROM information_schema.processlist
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 10 Grant SUPER privilege with grant option to user ddicttestuser1.
 connection default (user=root)
@@ -343,30 +343,30 @@ Grants for ddicttestuser2@localhost
 GRANT PROCESS ON *.* TO 'ddicttestuser2'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-3	root	localhost	information_schema	Sleep	TIME		NULL
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-6		localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-8		localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-11	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-12	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+3	root	localhost	information_schema	Sleep	TIME	NULL	NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+6		localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+8		localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+11	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+12	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 13	ddicttestuser2	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 13	ddicttestuser2	localhost	information_schema	Execute	TIME	preparing	SELECT * FROM information_schema.processlist
-12	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-11	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-8		localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-6		localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-3	root	localhost	information_schema	Sleep	TIME		NULL
+12	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+11	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+8		localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+6		localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+3	root	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 11 User ddicttestuser1 revokes PROCESS privilege from user ddicttestuser2
 connection ddicttestuser1;
@@ -381,12 +381,12 @@ Grants for ddicttestuser2@localhost
 GRANT USAGE ON *.* TO 'ddicttestuser2'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-13	ddicttestuser2	localhost	information_schema	Sleep	TIME		NULL
+13	ddicttestuser2	localhost	information_schema	Sleep	TIME	NULL	NULL
 14	ddicttestuser2	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 14	ddicttestuser2	localhost	information_schema	Execute	TIME	preparing	SELECT * FROM information_schema.processlist
-13	ddicttestuser2	localhost	information_schema	Sleep	TIME		NULL
+13	ddicttestuser2	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 11.2 Revoke SUPER,PROCESS,GRANT OPTION privilege from user ddicttestuser1
 connection default (user=root)
@@ -404,24 +404,24 @@ GRANT PROCESS ON *.* TO 'ddicttestuser2'
 ERROR 28000: Access denied for user 'ddicttestuser1'@'localhost' (using password: YES)
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-11	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-12	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+11	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+12	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 15	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 15	ddicttestuser1	localhost	information_schema	Execute	TIME	preparing	SELECT * FROM information_schema.processlist
-12	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-11	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+12	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+11	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 12 Revoke the SELECT privilege from user ddicttestuser1
 connection default (user=root)
@@ -439,26 +439,26 @@ Grants for ddicttestuser1@localhost
 GRANT USAGE ON *.* TO 'ddicttestuser1'@'localhost' IDENTIFIED BY PASSWORD '*22DA61451703738F203CDB9DB041ACBA1F4760B1'
 SHOW processlist;
 Id	User	Host	db	Command	Time	State	Info
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-11	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-12	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-15	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+11	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+12	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+15	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 16	ddicttestuser1	localhost	information_schema	Query	TIME	NULL	SHOW processlist
 SELECT * FROM information_schema.processlist;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 16	ddicttestuser1	localhost	information_schema	Execute	TIME	preparing	SELECT * FROM information_schema.processlist
-15	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-12	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-11	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-10	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-9	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-7	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-5	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
-4	ddicttestuser1	localhost	information_schema	Sleep	TIME		NULL
+15	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+12	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+11	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+10	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+9	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+7	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+5	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
+4	ddicttestuser1	localhost	information_schema	Sleep	TIME	NULL	NULL
 ####################################################################################
 12.2 Revoke only the SELECT privilege on the information_schema from ddicttestuser1.
 connection default (user=root)
Thread
bk commit into 6.0 tree (mleich:1.2685) BUG#32233mleich22 Nov