From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 14:24:36 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- .../suite/galera/r/galera_query_cache.result | 64 ++++++++++++++++++++++ 1 file changed, 64 insertions(+) create mode 100644 mysql-test/suite/galera/r/galera_query_cache.result (limited to 'mysql-test/suite/galera/r/galera_query_cache.result') diff --git a/mysql-test/suite/galera/r/galera_query_cache.result b/mysql-test/suite/galera/r/galera_query_cache.result new file mode 100644 index 00000000..8f5bc4b6 --- /dev/null +++ b/mysql-test/suite/galera/r/galera_query_cache.result @@ -0,0 +1,64 @@ +connection node_2; +connection node_1; +CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB; +INSERT INTO t1 VALUES (1); +connection node_2; +RESET QUERY CACHE; +FLUSH STATUS; +SELECT COUNT(*) FROM t1; +COUNT(*) +1 +SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache'; +VARIABLE_VALUE = 1 +1 +SELECT COUNT(*) FROM t1; +COUNT(*) +1 +SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits'; +VARIABLE_VALUE = 1 +1 +connection node_1; +INSERT INTO t1 VALUES (2); +connection node_2; +FLUSH STATUS; +SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache'; +VARIABLE_VALUE = 0 +1 +SELECT COUNT(*) FROM t1; +COUNT(*) +2 +SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache'; +VARIABLE_VALUE = 1 +1 +SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits'; +VARIABLE_VALUE = 0 +1 +SELECT COUNT(*) FROM t1; +COUNT(*) +2 +SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits'; +VARIABLE_VALUE = 1 +1 +connection node_1; +ALTER TABLE t1 ADD COLUMN f2 INTEGER; +connection node_2; +FLUSH STATUS; +SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache'; +VARIABLE_VALUE = 0 +1 +SELECT COUNT(*) FROM t1; +COUNT(*) +2 +SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'Qcache_queries_in_cache'; +VARIABLE_VALUE = 1 +1 +SELECT VARIABLE_VALUE = 0 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits'; +VARIABLE_VALUE = 0 +1 +SELECT COUNT(*) FROM t1; +COUNT(*) +2 +SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'Qcache_hits'; +VARIABLE_VALUE = 1 +1 +DROP TABLE t1; -- cgit v1.2.3