CURRENT_TEST: galera.query_cache
|
--- /usr/share/mysql/mysql-test/suite/galera/r/query_cache.result 2019-01-03 15:19:58.000000000 -0500
|
+++ /dev/shm/var/3/log/query_cache.reject 2019-01-03 18:43:55.146718359 -0500
|
@@ -1347,7 +1347,7 @@
|
Qcache_hits 12
|
show status like "Qcache_inserts";
|
Variable_name Value
|
-Qcache_inserts 36
|
+Qcache_inserts 34
|
drop table t1;
|
#
|
# Test of SQL_SELECT_LIMIT
|
@@ -1378,7 +1378,7 @@
|
Qcache_hits 12
|
show status like "Qcache_inserts";
|
Variable_name Value
|
-Qcache_inserts 38
|
+Qcache_inserts 36
|
SET SQL_SELECT_LIMIT=DEFAULT;
|
# On node-2
|
connection node_2;
|
@@ -1425,7 +1425,7 @@
|
Qcache_hits 12
|
show status like "Qcache_inserts";
|
Variable_name Value
|
-Qcache_inserts 40
|
+Qcache_inserts 38
|
lock table t1 write, t2 read;
|
show status like "Qcache_queries_in_cache";
|
Variable_name Value
|
@@ -1451,7 +1451,7 @@
|
Qcache_hits 12
|
show status like "Qcache_inserts";
|
Variable_name Value
|
-Qcache_inserts 41
|
+Qcache_inserts 39
|
unlock table;
|
drop view v1;
|
set query_cache_wlock_invalidate=default;
|
@@ -1533,7 +1533,7 @@
|
Qcache_hits 12
|
show status like "Qcache_inserts";
|
Variable_name Value
|
-Qcache_inserts 43
|
+Qcache_inserts 41
|
set collation_connection=koi8r_bin;
|
SELECT a,'Â','â'='Â' FROM t1;
|
a  'â'='Â'
|
@@ -1547,7 +1547,7 @@
|
Qcache_hits 12
|
show status like "Qcache_inserts";
|
Variable_name Value
|
-Qcache_inserts 44
|
+Qcache_inserts 42
|
set character_set_client=cp1251;
|
SELECT a,'Â','â'='Â' FROM t1;
|
a �? '�?'='�?'
|
@@ -1561,7 +1561,7 @@
|
Qcache_hits 12
|
show status like "Qcache_inserts";
|
Variable_name Value
|
-Qcache_inserts 45
|
+Qcache_inserts 43
|
set character_set_results=cp1251;
|
SELECT a,'Â','â'='Â' FROM t1;
|
a �? 'â'='Â'
|
@@ -1575,7 +1575,7 @@
|
Qcache_hits 12
|
show status like "Qcache_inserts";
|
Variable_name Value
|
-Qcache_inserts 46
|
+Qcache_inserts 44
|
SET NAMES default;
|
# On node-2
|
connection node_2;
|
|
mysqltest: Result content mismatch
|
|
|