Bug #43389 main.query_cache fails with embedded server

• Submitted: 4 Mar 2009 18:47
• Modified: 1 Dec 2009 18:37
• Reporter: Matthias Leich
• Status: No Feedback
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0
• OS: Any
• CPU Architecture: Any

[4 Mar 2009 18:47] Matthias Leich

Description:
mysql-5.0-bugteam last changeset March 2009
./mysql-test-run --embedded query_cache
....
TEST         RESULT     TIME (ms)
---------------------------------

query_cache  [ fail ]

--- .../r/query_cache.result
+++ .../r/query_cache.reject
@@ -1641,13 +1641,13 @@
 5
 show status like 'Qcache_queries_in_cache';
 Variable_name  Value
-Qcache_queries_in_cache        0
+Qcache_queries_in_cache        1
 SELECT id FROM view1 WHERE id>2;
 id
 5
 show status like 'Qcache_queries_in_cache';
 Variable_name  Value
-Qcache_queries_in_cache        1
+Qcache_queries_in_cache        2
 DROP DATABASE bug30269;
 DROP USER 'bug30269'@'localhost';
 set GLOBAL query_cache_type=default;

mysqltest: Result content mismatch

This bug does not apply to MySQL 5.1 and 6.0.

How to repeat:
./mysql-test-run --embedded query_cache

[1 Nov 2009 18:37] Valeriy Kravchuk

I can not repeat this with recent 5.0.88 from bzr on Linux. Maybe this bug is not releveant any more or somehow fixed?

[2 Dec 2009 0:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".