bzr commit into mysql-5.1-bugteam branch (alik:2735) Bug#31222

[Alexander Nozdrin]

#At file:///mnt/raid/alik/MySQL/bzr/bug31222/5.1-bugteam-bug31222/ based on revid:joro@stripped

 2735 Alexander Nozdrin	2009-01-15 [merge]
      Merge backport of patch for Bug#31222 from 5.0 to 5.1
modified:
  mysql-test/r/change_user.result
  mysql-test/r/not_embedded_server.result
  mysql-test/t/change_user.test
  mysql-test/t/not_embedded_server.test

=== modified file 'mysql-test/r/change_user.result'
--- a/mysql-test/r/change_user.result	2008-03-28 10:14:27 +0000
+++ b/mysql-test/r/change_user.result	2009-01-15 09:56:05 +0000
@@ -44,3 +44,10 @@ IS_FREE_LOCK('bug31418')
 SELECT IS_USED_LOCK('bug31418');
 IS_USED_LOCK('bug31418')
 NULL
+FLUSH STATUS;
+SHOW GLOBAL STATUS LIKE 'com_select';
+Variable_name	Value
+Com_select	112
+SHOW GLOBAL STATUS LIKE 'com_select';
+Variable_name	Value
+Com_select	112

=== modified file 'mysql-test/r/not_embedded_server.result'
--- a/mysql-test/r/not_embedded_server.result	2008-02-13 10:00:24 +0000
+++ b/mysql-test/r/not_embedded_server.result	2009-01-15 09:56:05 +0000
@@ -3,10 +3,3 @@ execute stmt1;
 ID	USER	HOST	DB	COMMAND	TIME	STATE	INFO
 number	root	localhost	test	Query	time	executing	SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE COMMAND!='Daemon'
 deallocate prepare stmt1;
-FLUSH STATUS;
-SHOW GLOBAL STATUS LIKE 'com_select';
-Variable_name	Value
-Com_select	102
-SHOW GLOBAL STATUS LIKE 'com_select';
-Variable_name	Value
-Com_select	102

=== modified file 'mysql-test/t/change_user.test'
--- a/mysql-test/t/change_user.test	2008-03-28 10:14:27 +0000
+++ b/mysql-test/t/change_user.test	2009-01-15 09:56:05 +0000
@@ -45,9 +45,26 @@ SELECT IS_USED_LOCK('bug31418');
 # Bug#31222: com_% global status counters behave randomly with
 # mysql_change_user.
 #
-# Moved to not_embedded_server.test due to Bug#34517: SHOW GLOBAL STATUS does
-# not work properly in embedded server.
-#
-# TODO: move it back when Bug#34517 is fixed (don't forget to add
-# --force-restart into change_user-master.opt).
-#
+
+FLUSH STATUS;
+
+--disable_result_log
+--disable_query_log
+
+let $i = 100;
+
+while ($i)
+{
+  dec $i;
+
+  SELECT 1;
+}
+
+--enable_query_log
+--enable_result_log
+
+SHOW GLOBAL STATUS LIKE 'com_select';
+
+--change_user
+
+SHOW GLOBAL STATUS LIKE 'com_select';

=== modified file 'mysql-test/t/not_embedded_server.test'
--- a/mysql-test/t/not_embedded_server.test	2008-02-13 10:00:24 +0000
+++ b/mysql-test/t/not_embedded_server.test	2009-01-15 09:56:05 +0000
@@ -20,38 +20,4 @@ prepare stmt1 from ' SELECT * FROM INFOR
 execute stmt1;
 deallocate prepare stmt1;
 
-
-#
-# Bug#31222: com_% global status counters behave randomly with
-# mysql_change_user.
-#
-# Moved from change_user.test due to Bug#34517: SHOW GLOBAL STATUS does not
-# work properly in embedded server.
-#
-# TODO: move it back when Bug#34517 is fixed.
-#
-
-FLUSH STATUS;
-
---disable_result_log
---disable_query_log
-
-let $i = 100;
-
-while ($i)
-{
-  dec $i;
-
-  SELECT 1;
-}
-
---enable_query_log
---enable_result_log
-
-SHOW GLOBAL STATUS LIKE 'com_select';
-
---change_user
-
-SHOW GLOBAL STATUS LIKE 'com_select';
-
 # End of 5.1 tests