MySQL Bugs: #44961: Test "information_schema" not fit for community configuration

Bug #44961	Test "information_schema" not fit for community configuration
Submitted:	19 May 2009 19:30	Modified:	14 May 2010 20:45
Reporter:	Joerg Bruehe	Email Updates:
Status:	Verified	Impact on me:	None
Category:	Tests: Server	Severity:	S3 (Non-critical)
Version:	5.0.82	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
Since the unification of the "community" and the "enterprise" code base,
the output of test "information_schema" differs by the configuration built.

While the test passes in all "commercial" configurations,
it fails in the "community" build with this symptom:

=====
information_schema             [ fail ]

--- /PATH/mysql-test/r/information_schema.result
+++ /PATH/mysql-test/r/information_schema.reject
@@ -1320,9 +1320,11 @@
 VIEWS  information_schema.VIEWS        1
 show global status like "Uptime_%";
 Variable_name  Value
+Uptime_since_flush_status      #
 flush status;
 show global status like "Uptime_%";
 Variable_name  Value
+Uptime_since_flush_status      #
 create table t1(f1 int);
 create view v1 as select f1+1 as a from t1;
 create table t2 (f1 int, f2 int);

mysqltest: Result content mismatch

Stopping All Servers
=====

How to repeat:
Do a community build, run the tests.

Suggested fix:
Introduce two result files, a commercial and a community one,
and use an include file in the tests to split properly.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/75558

2764 Patrick Crews	2009-06-03
      Bug#44961 - Test "information_schema" not fit for community configuration
      
      Fixed the test to actually check the variable behavior and altered it
      so that it can be skipped gracefully in the event the variable is not present.
      
      Added a helper file to std_data and re-recorded the .result file to account 
      for the changes to the test.
      
      NOTE:  5.1 will have a different fix as it provides functionality 
             not present in 5.0 (will be easier / simpler)

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/77251

2786 Patrick Crews	2009-06-25
      Bug#44961: Test "information_schema" not fit for community configuration
      
      Wrote a separate and more comprehensive test for this variable.
      The test will skip if the variable is not present and more of the variable's
      behavior is checked.
      
      The 5.1+ fixes will be very different as we will have access to information_schema
      tables to make testing easier.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/77466

2788 Patrick Crews	2009-06-29
      Bug#44961: Test "information_schema" not fit for community configuration
      
      Wrote a separate and more comprehensive test for this variable.
      The test will skip if the variable is not present and more of the variable's
      behavior is checked.
      
      The 5.1+ fixes will be very different as we will have access to information_schema tables to
      make testing easier.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/77478

2788 Patrick Crews	2009-06-29
      Bug#44961: Test "information_schema" not fit for community configuration
      
      Wrote a separate and more comprehensive test for this variable.
      The test will skip if the variable is not present and more of the variable's
      behavior is checked.  This patch incorporates review feedback.
      
      The 5.1+ fixes will be different as access to information_schema tables
      will make testing easier.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/77485

2789 Patrick Crews	2009-06-29
      Bug#44961: Test "information_schema" not fit for community configuration.
      
      Incremental patch incorporating feedback review - formatting and file name changes.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/77486

2790 Patrick Crews	2009-06-29
      Bug#44961: Test "information_schema" not fit for community configuration
      
      Incremental patch - added checks to ensure no rogue connections remain 
      at the end of the test per review feedback.

Isn't this fixed? Then why is the status still verified?