summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJulius Goryavsky <julius.goryavsky@mariadb.com>2023-05-02 04:57:30 +0200
committerJulius Goryavsky <julius.goryavsky@mariadb.com>2023-05-02 04:57:30 +0200
commit22623040ccb9d16e6132ac13536fb2457df4b051 (patch)
tree3c353ab1f8fc7dac76b91acc57e3ce394bf4a688
parentfcabf705d87009b98e0d27f90dbec28b3a8a3191 (diff)
downloadmariadb-git-bb-10.6-MDEV-29775-galera.tar.gz
MDEV-29755 correction: running wsrep_replicate_myisam_basic test with wsrep enabledbb-10.6-MDEV-29775-galera
-rw-r--r--mysql-test/suite/sys_vars/r/wsrep_replicate_myisam.result18
-rw-r--r--mysql-test/suite/sys_vars/t/wsrep_replicate_myisam.cnf12
-rw-r--r--mysql-test/suite/sys_vars/t/wsrep_replicate_myisam.test24
3 files changed, 54 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/wsrep_replicate_myisam.result b/mysql-test/suite/sys_vars/r/wsrep_replicate_myisam.result
new file mode 100644
index 00000000000..a20e6593040
--- /dev/null
+++ b/mysql-test/suite/sys_vars/r/wsrep_replicate_myisam.result
@@ -0,0 +1,18 @@
+#
+# wsrep_replicate_myisam
+#
+# save the initial value
+SET @wsrep_mode_saved = @@global.wsrep_mode;
+
+# scope and valid values
+SET @@global.wsrep_mode=REPLICATE_MYISAM;
+SELECT @@global.wsrep_mode;
+@@global.wsrep_mode
+REPLICATE_MYISAM
+
+# restore the initial value
+SET @@global.wsrep_mode = @wsrep_mode_saved;
+# End of test
+CALL mtr.add_suppression("WSREP: Could not open saved state file for reading: .*");
+CALL mtr.add_suppression("WSREP: Could not open state file for reading: .*");
+CALL mtr.add_suppression("WSREP: access file\(.*gvwstate.dat\) failed\(No such file or directory\)");
diff --git a/mysql-test/suite/sys_vars/t/wsrep_replicate_myisam.cnf b/mysql-test/suite/sys_vars/t/wsrep_replicate_myisam.cnf
new file mode 100644
index 00000000000..ef15cfde5dc
--- /dev/null
+++ b/mysql-test/suite/sys_vars/t/wsrep_replicate_myisam.cnf
@@ -0,0 +1,12 @@
+# Use default setting for mysqld processes
+!include include/default_mysqld.cnf
+
+[mysqld.1]
+wsrep-on=1
+#galera_port=@OPT.port
+#ist_port=@OPT.port
+#sst_port=@OPT.port
+wsrep_provider_options='base_port=@mysqld.1.#galera_port;gcache.size=10M'
+wsrep-cluster-address=gcomm://
+wsrep-provider=@ENV.WSREP_PROVIDER
+binlog-format=ROW
diff --git a/mysql-test/suite/sys_vars/t/wsrep_replicate_myisam.test b/mysql-test/suite/sys_vars/t/wsrep_replicate_myisam.test
new file mode 100644
index 00000000000..5c0c07e01a8
--- /dev/null
+++ b/mysql-test/suite/sys_vars/t/wsrep_replicate_myisam.test
@@ -0,0 +1,24 @@
+--source include/have_wsrep.inc
+--source include/have_innodb.inc
+
+--echo #
+--echo # wsrep_replicate_myisam
+--echo #
+
+--echo # save the initial value
+SET @wsrep_mode_saved = @@global.wsrep_mode;
+
+--echo
+--echo # scope and valid values
+SET @@global.wsrep_mode=REPLICATE_MYISAM;
+SELECT @@global.wsrep_mode;
+
+--echo
+--echo # restore the initial value
+SET @@global.wsrep_mode = @wsrep_mode_saved;
+
+--echo # End of test
+
+CALL mtr.add_suppression("WSREP: Could not open saved state file for reading: .*");
+CALL mtr.add_suppression("WSREP: Could not open state file for reading: .*");
+CALL mtr.add_suppression("WSREP: access file\(.*gvwstate.dat\) failed\(No such file or directory\)");