summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--mysql-test/suite/galera/r/galera_var_dirty_reads.result15
-rw-r--r--mysql-test/suite/galera/suite.pm1
-rw-r--r--mysql-test/suite/galera/t/galera_var_dirty_reads.test12
3 files changed, 19 insertions, 9 deletions
diff --git a/mysql-test/suite/galera/r/galera_var_dirty_reads.result b/mysql-test/suite/galera/r/galera_var_dirty_reads.result
index 6a2aa1eb5e7..c0ffb2d4860 100644
--- a/mysql-test/suite/galera/r/galera_var_dirty_reads.result
+++ b/mysql-test/suite/galera/r/galera_var_dirty_reads.result
@@ -18,19 +18,22 @@ SET @@session.wsrep_dirty_reads=ON;
SELECT * FROM t1;
i
1
+#
+# MDEV-11016: wsrep_node_is_ready() check is too strict
+#
SET @@session.wsrep_dirty_reads=OFF;
SELECT 2;
2
2
-SELECT @@max_allowed_packet;
-@@max_allowed_packet
-4194304
SELECT 2+2 from DUAL;
2+2
4
-SELECT sysdate() from DUAL;
-sysdate()
-2016-10-28 23:13:06
+SET @VAR=1;
+SELECT @VAR;
+@VAR
+1
+SELECT @@max_allowed_packet;
+SELECT SYSDATE() from DUAL;
SELECT * FROM t1;
i
1
diff --git a/mysql-test/suite/galera/suite.pm b/mysql-test/suite/galera/suite.pm
index fdaf64580c7..a790e951762 100644
--- a/mysql-test/suite/galera/suite.pm
+++ b/mysql-test/suite/galera/suite.pm
@@ -37,6 +37,7 @@ push @::global_suppressions,
qr|WSREP: access file\(.*gvwstate.dat\) failed\(No such file or directory\)|,
qr|WSREP: no nodes coming from prim view, prim not possible|,
qr(WSREP: SYNC message from member .* in non-primary configuration. Ignored.),
+ qr(WSREP: discarding established .*),
);
diff --git a/mysql-test/suite/galera/t/galera_var_dirty_reads.test b/mysql-test/suite/galera/t/galera_var_dirty_reads.test
index dd7bc88cb1c..48fbe37139c 100644
--- a/mysql-test/suite/galera/t/galera_var_dirty_reads.test
+++ b/mysql-test/suite/galera/t/galera_var_dirty_reads.test
@@ -39,12 +39,18 @@ SET @@session.wsrep_dirty_reads=ON;
SELECT * FROM t1;
-#Select query which does not access table should be allowed MDEV-11016
+--echo #
+--echo # MDEV-11016: wsrep_node_is_ready() check is too strict
+--echo #
SET @@session.wsrep_dirty_reads=OFF;
SELECT 2;
-SELECT @@max_allowed_packet;
SELECT 2+2 from DUAL;
-SELECT sysdate() from DUAL;
+SET @VAR=1;
+SELECT @VAR;
+--disable_result_log
+SELECT @@max_allowed_packet;
+SELECT SYSDATE() from DUAL;
+--enable_result_log
--disable_query_log
--eval SET @@global.wsrep_cluster_address = '$wsrep_cluster_address_saved'