main.query_cache_executable_comments unreliable

CURRENT_TEST: main.query_cache_executable_comments

--- /home/buildbot/x86-debian-12-fulltest/build/mysql-test/main/query_cache_executable_comments.result	2026-06-02 17:54:43.000000000 +0000

+++ /home/buildbot/x86-debian-12-fulltest/build/mysql-test/main/query_cache_executable_comments.reject	2026-06-02 18:31:03.295121735 +0000

@@ -30,10 +30,10 @@

 SELECT /*!50300 c1 */ FROM t1;

 SHOW STATUS LIKE 'Qcache_inserts';

 Variable_name	Value

-Qcache_inserts	1

+Qcache_inserts	7

 SHOW STATUS LIKE 'Qcache_hits';

 Variable_name	Value

-Qcache_hits	1

+Qcache_hits	3

 SHOW STATUS LIKE 'Qcache_queries_in_cache';

 Variable_name	Value

 Qcache_queries_in_cache	1

@@ -49,10 +49,10 @@

 SELECT /*M!50300 c1 */ FROM t1;

 SHOW STATUS LIKE 'Qcache_inserts';

 Variable_name	Value

-Qcache_inserts	2

+Qcache_inserts	8

 SHOW STATUS LIKE 'Qcache_hits';

 Variable_name	Value

-Qcache_hits	2

+Qcache_hits	4

 SHOW STATUS LIKE 'Qcache_queries_in_cache';

 Variable_name	Value

 Qcache_queries_in_cache	1

@@ -70,10 +70,10 @@

 SELECT /*!!999999 c1 */ FROM t1;

 SHOW STATUS LIKE 'Qcache_inserts';

 Variable_name	Value

-Qcache_inserts	2

+Qcache_inserts	8

 SHOW STATUS LIKE 'Qcache_hits';

 Variable_name	Value

-Qcache_hits	2

+Qcache_hits	4

 SHOW STATUS LIKE 'Qcache_queries_in_cache';

 Variable_name	Value

 Qcache_queries_in_cache	0

@@ -89,10 +89,10 @@

 SELECT /*M!!999999 c1 */ FROM t1;

 SHOW STATUS LIKE 'Qcache_inserts';

 Variable_name	Value

-Qcache_inserts	2

+Qcache_inserts	8

 SHOW STATUS LIKE 'Qcache_hits';

 Variable_name	Value

-Qcache_hits	2

+Qcache_hits	4

 SHOW STATUS LIKE 'Qcache_queries_in_cache';

 Variable_name	Value

 Qcache_queries_in_cache	0

@@ -109,10 +109,10 @@

 SELECT c1 /*!999999 + 1 */ FROM t1;

 SHOW STATUS LIKE 'Qcache_inserts';

 Variable_name	Value

-Qcache_inserts	2

+Qcache_inserts	8

 SHOW STATUS LIKE 'Qcache_hits';

 Variable_name	Value

-Qcache_hits	2

+Qcache_hits	4

 SHOW STATUS LIKE 'Qcache_queries_in_cache';

 Variable_name	Value

 Qcache_queries_in_cache	0

@@ -128,10 +128,10 @@

 SELECT c1 /*!!100000 + 1 */ FROM t1;

 SHOW STATUS LIKE 'Qcache_inserts';

 Variable_name	Value

-Qcache_inserts	2

+Qcache_inserts	8

 SHOW STATUS LIKE 'Qcache_hits';

 Variable_name	Value

-Qcache_hits	2

+Qcache_hits	4

 SHOW STATUS LIKE 'Qcache_queries_in_cache';

 Variable_name	Value

 Qcache_queries_in_cache	0

@@ -153,10 +153,10 @@

 SELECT c1 /*!!100000 + 1 */ FROM t1;

 SHOW STATUS LIKE 'Qcache_inserts';

 Variable_name	Value

-Qcache_inserts	6

+Qcache_inserts	12

 SHOW STATUS LIKE 'Qcache_hits';

 Variable_name	Value

-Qcache_hits	6

+Qcache_hits	8

 SHOW STATUS LIKE 'Qcache_queries_in_cache';

 Variable_name	Value

 Qcache_queries_in_cache	4

Result length mismatch