Bug #43389 main.query_cache fails with embedded server
Submitted: 4 Mar 2009 18:47 Modified: 1 Dec 2009 18:37
Reporter: Matthias Leich Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: CPU Architecture:Any

[4 Mar 2009 18:47] Matthias Leich
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 @@
 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;
 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".