MySQL Bugs: #11328: bdb_cache test fails with wrong Qcache_queries_in

Bug #11328	bdb_cache test fails with wrong Qcache_queries_in_cache value
Submitted:	14 Jun 2005 19:37	Modified:	16 Jun 2005 9:01
Reporter:	Lenz Grimmer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.1.13-pre	OS:	Linux (Linux)
Assigned to:	Sergei Golubchik	CPU Architecture:	Any

Description:
In the current 4.1 and 5.x trees, the following BDB test fails:

TEST                            RESULT
-------------------------------------------------------
bdb_cache                      [ fail ]

Errors are (from /data0/mysqldev/my/mysql-4.1.13-20050614-build/mysql-test/var/log/mysqltest-time) :
/data0/mysqldev/my/mysql-4.1.13-20050614-build/client/.libs/mysqltest: At line 54: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/bdb_cache.result  2005-06-14 16:47:23.000000000 +0300
--- r/bdb_cache.reject  2005-06-14 22:34:12.000000000 +0300
***************
*** 24,30 ****
  3
  show status like "Qcache_queries_in_cache";
  Variable_name Value
! Qcache_queries_in_cache       0
  drop table t1;
  commit;
  create table t1 (a int not null) engine=bdb;
--- 24,30 ----
  3
  show status like "Qcache_queries_in_cache";
  Variable_name Value
! Qcache_queries_in_cache       1
  drop table t1;
  commit;
  create table t1 (a int not null) engine=bdb;
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.

How to repeat:
Compile with BDB, run the bdb_cache test.

fixed in 4.1.13, 5.0.8

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/internals/26071