MOON
Server: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4
System: Linux vps.panamaemb.org.sg 3.10.0-1160.80.1.vz7.191.4 #1 SMP Thu Dec 15 20:31:06 MSK 2022 x86_64
User: panama (500)
PHP: 5.2.17
Disabled: NONE
Upload Files
File: //usr/share/mysql-test/suite/ndb/t/ndbinfo_cache.test
--source include/have_query_cache.inc
--source include/have_ndb.inc

--source ndbinfo_create.inc

USE ndbinfo;

# BUG#59831 ndbinfo - counters not increasing after first query
# - ndbinfo tables should never be cached in query cache

# Turn on and reset query cache
set GLOBAL query_cache_type=on;
set GLOBAL query_cache_size=1355776;
reset query cache;
flush status;

# Perform same query several times, which were inserted
# in the cache  before fix but not inserted anymore
--disable_result_log
select * from counters;
select * from counters;
select * from counters;
--enable_result_log
show status like "Qcache_queries_in_cache";
show status like "Qcache_inserts";

# Turn off query cache
SET GLOBAL query_cache_size=default;
SET GLOBAL query_cache_type=default;

--source ndbinfo_drop.inc