MySQL Bugs: #6193: query_cache_merge.test is skipped

Bug #6193	query_cache_merge.test is skipped
Submitted:	21 Oct 2004 5:50	Modified:	15 May 2005 18:42
Reporter:	Shuichi Tamagawa	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.1.6	OS:	Any (all)
Assigned to:	Kent Boortz	CPU Architecture:	Any

Description:
query_cache_merge.test is skipped even if it meets the requirement to do the test.

If I comment out the line --source include/check_var_limit.inc in query_cache_merge.test, it passes the test. The file "check_var_limit.inc" looks like for checking if the value of 
"open_files_limit" is BETWEEN 600 AND 65535 and if it returns 1 which is true. Actually it returns 1 and meet the requirement. But the test is skipped after executing the next query.

How to repeat:
./mysql-test-run query_cache_merge      # [skipped]

#Open query_cache_merge.test and comment out --source include/check_var_limit.inc.
./mysql-test-run query_cache_merge      # [pass]

#create test case file by copying the first 5 commands. and save as aaa.test.
  --source include/have_query_cache.inc
  let $LIMIT=`SHOW VARIABLES LIKE 'open_files_limit'`;
  let $MIN_LIMIT=600;
  let $MAX_LIMIT=65536;
  --source include/check_var_limit.inc

#run the test and compare the result with check_var_limit.require
./mysql-test-run --record aaa.test
diff r/aaa.result r/check_var_limit.require

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

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/24911