bzr commit into mysql-6.0-bugteam branch (davi:2986) Bug#37481

[Davi Arnaut]

# At a local mysql-6.0-bugteam repository of davi

 2986 Davi Arnaut	2009-01-29
      Bug#37481: status.test fails randomly
      
      The problem is that there is no reliable way to compare the
      values of Threads_running and Threads_running as threads might
      came and go (spurious) during the execution of the test.
      
      The solution is to only test that Threads_connected is less the
      Threads_created as originally intended.
modified:
  mysql-test/r/status.result
  mysql-test/t/status.test

per-file messages:
  mysql-test/r/status.result
    Update test case result.
  mysql-test/t/status.test
    Remove test Threads_running and Threads_connected.
=== modified file 'mysql-test/r/status.result'
--- a/mysql-test/r/status.result	2009-01-06 10:38:47 +0000
+++ b/mysql-test/r/status.result	2009-01-29 16:33:46 +0000
@@ -239,12 +239,6 @@ CREATE VIEW v1 AS SELECT VARIABLE_NAME A
 SELECT VALUE INTO @tc FROM v1 WHERE NAME = 'Threads_connected';
 SELECT NAME FROM v1 WHERE NAME = 'Threads_created' AND VALUE < @tc;
 NAME
-SELECT VALUE INTO @tr FROM v1 WHERE NAME = 'Threads_running';
-FLUSH STATUS;
-SELECT * FROM v1 WHERE NAME = 'Threads_connected' AND VALUE < @tc;
-NAME	VALUE
-SELECT * FROM v1 WHERE NAME = 'Threads_running' AND VALUE < @tr;
-NAME	VALUE
 DROP VIEW v1;
 SELECT VARIABLE_NAME FROM INFORMATION_SCHEMA.GLOBAL_STATUS
 WHERE VARIABLE_NAME = 'Threads_created' AND

=== modified file 'mysql-test/t/status.test'
--- a/mysql-test/t/status.test	2009-01-06 10:38:47 +0000
+++ b/mysql-test/t/status.test	2009-01-29 16:33:46 +0000
@@ -343,12 +343,6 @@ CREATE VIEW v1 AS SELECT VARIABLE_NAME A
 
 SELECT VALUE INTO @tc FROM v1 WHERE NAME = 'Threads_connected';
 SELECT NAME FROM v1 WHERE NAME = 'Threads_created' AND VALUE < @tc;
-SELECT VALUE INTO @tr FROM v1 WHERE NAME = 'Threads_running';
-
-FLUSH STATUS;
-
-SELECT * FROM v1 WHERE NAME = 'Threads_connected' AND VALUE < @tc;
-SELECT * FROM v1 WHERE NAME = 'Threads_running' AND VALUE < @tr;
 
 DROP VIEW v1;