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

[Davi Arnaut]

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

 2967 Davi Arnaut	2009-01-20
      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 simply remove the test case as there is no
      obvious explanation other then the fluctuation of the values.
      Also, bugs reveled by this test case that are now covered with
      other tests, so no harm is done.
modified:
  mysql-test/r/status.result
  mysql-test/t/status.test

per-file messages:
  mysql-test/r/status.result
    Remove test case result
  mysql-test/t/status.test
    Remove test case
=== 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-20 23:22:03 +0000
@@ -234,18 +234,6 @@ SELECT 9;
 9
 DROP PROCEDURE p1;
 DROP FUNCTION f1;
-DROP VIEW IF EXISTS v1;
-CREATE VIEW v1 AS SELECT VARIABLE_NAME AS NAME, CONVERT(VARIABLE_VALUE, UNSIGNED) AS VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS;
-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
 CONVERT(VARIABLE_VALUE, UNSIGNED) > 0;

=== 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-20 23:22:03 +0000
@@ -332,27 +332,6 @@ DROP FUNCTION f1;
 # End of 5.1 tests
 
 #
-# Bug #17954: Threads_connected > Threads_created
-#
-
---disable_warnings
-DROP VIEW IF EXISTS v1;
---enable_warnings
-
-CREATE VIEW v1 AS SELECT VARIABLE_NAME AS NAME, CONVERT(VARIABLE_VALUE, UNSIGNED) AS VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS;
-
-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;
-
-#
 # Bug#39916: pool-of-threads fails to increment the number of created threads
 #