bk commit into 5.0 tree (konstantin:1.1950)

[konstantin]

Below is the list of changes that have just been committed into a local
5.0 repository of kostja. When kostja 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
  1.1950 05/05/14 14:42:25 konstantin@stripped +2 -0
  More post-merge fixes.

  mysql-test/t/ps_grant.test
    1.5 05/05/14 14:42:20 konstantin@stripped +7 -4
    More post-merge fixes: show processlist must be last.

  mysql-test/r/ps_grant.result
    1.6 05/05/14 14:42:20 konstantin@stripped +5 -4
    More post-merge fixes.

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	konstantin
# Host:	dragonfly.local
# Root:	/media/sda1/mysql/mysql-5.0-merge

--- 1.5/mysql-test/r/ps_grant.result	2005-05-14 13:25:55 +04:00
+++ 1.6/mysql-test/r/ps_grant.result	2005-05-14 14:42:20 +04:00
@@ -75,10 +75,6 @@
 show grants for second_user@localhost ;
 ERROR 42000: There is no such grant defined for user 'second_user' on host 'localhost'
 drop database mysqltest;
-prepare stmt4 from ' show full processlist ';
-execute stmt4;
-Id	User	Host	db	Command	Time	State	Info
-number	root	localhost	test	Query	time	NULL	show full processlist
 prepare stmt3 from ' grant all on test.t1 to drop_user@localhost
 identified by ''looser'' ';
 ERROR HY000: This command is not supported in the prepared statement protocol yet
@@ -91,3 +87,8 @@
 prepare stmt3 from ' drop user drop_user@localhost ';
 ERROR HY000: This command is not supported in the prepared statement protocol yet
 drop user drop_user@localhost;
+prepare stmt4 from ' show full processlist ';
+execute stmt4;
+Id	User	Host	db	Command	Time	State	Info
+number	root	localhost	test	Query	time	NULL	show full processlist
+deallocate prepare stmt4;

--- 1.4/mysql-test/t/ps_grant.test	2005-05-14 12:36:56 +04:00
+++ 1.5/mysql-test/t/ps_grant.test	2005-05-14 14:42:20 +04:00
@@ -112,10 +112,6 @@
 
 drop database mysqltest;
 
-# Tested here simply so it is not tested with embedded server
-prepare stmt4 from ' show full processlist ';
---replace_column 1 number 6 time 3 localhost
-execute stmt4;
 
 ## grant/revoke + drop user
 --error 1295
@@ -131,3 +127,10 @@
 prepare stmt3 from ' drop user drop_user@localhost ';
 drop user drop_user@localhost;
 
+# This test must be the last one, otherwise it may produce extra
+# rows in the processlist under high load.
+# Tested here simply so it is not tested with embedded server
+prepare stmt4 from ' show full processlist ';
+--replace_column 1 number 6 time 3 localhost
+execute stmt4;
+deallocate prepare stmt4;