diff options
author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-09-11 18:01:31 +0300 |
---|---|---|
committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-09-11 18:01:31 +0300 |
commit | 4be366111b5bca25643574737b6a0ee17c05cce3 (patch) | |
tree | 5194b04fc95e4c52723cdaaac764f696cae918fb /mysql-test/suite/galera_3nodes/r | |
parent | 76149650764ea9660ae05d4987ea6c91534851ab (diff) | |
parent | 15139964d52539a8bb96d090fa1b5b26921eab3e (diff) | |
download | mariadb-git-4be366111b5bca25643574737b6a0ee17c05cce3.tar.gz |
Merge 10.6 into 10.7
Diffstat (limited to 'mysql-test/suite/galera_3nodes/r')
-rw-r--r-- | mysql-test/suite/galera_3nodes/r/galera_wsrep_schema.result | 44 |
1 files changed, 19 insertions, 25 deletions
diff --git a/mysql-test/suite/galera_3nodes/r/galera_wsrep_schema.result b/mysql-test/suite/galera_3nodes/r/galera_wsrep_schema.result index 23ced3ba734..ba01eab0e26 100644 --- a/mysql-test/suite/galera_3nodes/r/galera_wsrep_schema.result +++ b/mysql-test/suite/galera_3nodes/r/galera_wsrep_schema.result @@ -24,20 +24,20 @@ wsrep_cluster_members CREATE TABLE `wsrep_cluster_members` ( `node_incoming_address` varchar(256) NOT NULL, PRIMARY KEY (`node_uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 -SELECT COUNT(*) = 1 FROM mysql.wsrep_cluster; -COUNT(*) = 1 +SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_cluster; +EXPECT_1 1 SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster; cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') 1 -SELECT COUNT(*) = 3 FROM mysql.wsrep_cluster_members; -COUNT(*) = 3 -1 +SELECT COUNT(*) AS EXPECT_3 FROM mysql.wsrep_cluster_members; +EXPECT_3 +3 SELECT COUNT(*) = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size') FROM mysql.wsrep_cluster_members; COUNT(*) = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size') 1 -SELECT COUNT(*) = 1 FROM mysql.wsrep_cluster_members WHERE node_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_gcomm_uuid'); -COUNT(*) = 1 +SELECT COUNT(*) AS EXPECT_1 FROM mysql.wsrep_cluster_members WHERE node_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_gcomm_uuid'); +EXPECT_1 1 SELECT node_incoming_address LIKE '127.0.0.1:%' from mysql.wsrep_cluster_members; node_incoming_address LIKE '127.0.0.1:%' @@ -49,34 +49,28 @@ cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHER 1 1 1 -SELECT COUNT(*) = 1 FROM mysql.wsrep_cluster_members WHERE node_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_gcomm_uuid'); -COUNT(*) = 1 -1 connection node_2; +SELECT COUNT(*) AS EXPECT_3 FROM mysql.wsrep_cluster_members; +EXPECT_3 +3 connection node_1; SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster; cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') 1 -SELECT COUNT(*) = 2 FROM mysql.wsrep_cluster_members; -COUNT(*) = 2 -1 +SELECT COUNT(*) AS EXPECT_2 FROM mysql.wsrep_cluster_members; +EXPECT_2 +2 connection node_2; SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster; cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') 1 -SELECT COUNT(*) = 3 FROM mysql.wsrep_cluster_members; -COUNT(*) = 3 -1 +SELECT COUNT(*) AS EXPECT_3 FROM mysql.wsrep_cluster_members; +EXPECT_3 +3 connection node_1; SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster; cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') 1 -SELECT COUNT(*) = 3 FROM mysql.wsrep_cluster_members; -COUNT(*) = 3 -1 -connection node_1; -CALL mtr.add_suppression("SYNC message from member"); -connection node_2; -CALL mtr.add_suppression("SYNC message from member"); -connection node_3; -CALL mtr.add_suppression("SYNC message from member"); +SELECT COUNT(*) AS EXPECT_3 FROM mysql.wsrep_cluster_members; +EXPECT_3 +3 |