diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-13 12:24:36 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-13 12:24:36 +0000 |
commit | 06eaf7232e9a920468c0f8d74dcf2fe8b555501c (patch) | |
tree | e2c7b5777f728320e5b5542b6213fd3591ba51e2 /mysql-test/suite/galera/r/galera_var_wsrep_mode.result | |
parent | Initial commit. (diff) | |
download | mariadb-06eaf7232e9a920468c0f8d74dcf2fe8b555501c.tar.xz mariadb-06eaf7232e9a920468c0f8d74dcf2fe8b555501c.zip |
Adding upstream version 1:10.11.6.upstream/1%10.11.6
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'mysql-test/suite/galera/r/galera_var_wsrep_mode.result')
-rw-r--r-- | mysql-test/suite/galera/r/galera_var_wsrep_mode.result | 79 |
1 files changed, 79 insertions, 0 deletions
diff --git a/mysql-test/suite/galera/r/galera_var_wsrep_mode.result b/mysql-test/suite/galera/r/galera_var_wsrep_mode.result new file mode 100644 index 00000000..b5b33fe8 --- /dev/null +++ b/mysql-test/suite/galera/r/galera_var_wsrep_mode.result @@ -0,0 +1,79 @@ +connection node_2; +connection node_1; +SELECT @@wsrep_mode; +@@wsrep_mode + +SET GLOBAL wsrep_mode=DEFAULT; +SELECT @@wsrep_mode; +@@wsrep_mode + +SET SESSION wsrep_mode=DEFAULT; +ERROR HY000: Variable 'wsrep_mode' is a GLOBAL variable and should be set with SET GLOBAL +SELECT @@global.wsrep_mode; +@@global.wsrep_mode + +SELECT @@session.wsrep_mode; +ERROR HY000: Variable 'wsrep_mode' is a GLOBAL variable +SET GLOBAL wsrep_mode=A; +ERROR 42000: Variable 'wsrep_mode' can't be set to the value of 'A' +SET GLOBAL wsrep_mode='A'; +ERROR 42000: Variable 'wsrep_mode' can't be set to the value of 'A' +SET GLOBAL wsrep_mode=NULL; +ERROR 42000: Variable 'wsrep_mode' can't be set to the value of 'NULL' +SET GLOBAL wsrep_mode=128; +ERROR 42000: Variable 'wsrep_mode' can't be set to the value of '128' +SET GLOBAL wsrep_mode=REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 +SET GLOBAL wsrep_mode=1; +SELECT @@wsrep_mode; +@@wsrep_mode +STRICT_REPLICATION +SET GLOBAL wsrep_mode=32; +SELECT @@wsrep_mode; +@@wsrep_mode +DISALLOW_LOCAL_GTID +SET GLOBAL wsrep_mode=''; +SELECT @@wsrep_mode; +@@wsrep_mode + +SET GLOBAL wsrep_mode=STRICT_REPLICATION; +SELECT @@wsrep_mode; +@@wsrep_mode +STRICT_REPLICATION +SET GLOBAL wsrep_mode=BINLOG_ROW_FORMAT_ONLY; +SELECT @@wsrep_mode; +@@wsrep_mode +BINLOG_ROW_FORMAT_ONLY +SET GLOBAL wsrep_mode=REQUIRED_PRIMARY_KEY; +SELECT @@wsrep_mode; +@@wsrep_mode +REQUIRED_PRIMARY_KEY +SET GLOBAL wsrep_mode=REPLICATE_MYISAM; +SELECT @@wsrep_mode; +@@wsrep_mode +REPLICATE_MYISAM +SET GLOBAL wsrep_mode=REPLICATE_ARIA; +SELECT @@wsrep_mode; +@@wsrep_mode +REPLICATE_ARIA +SET GLOBAL wsrep_mode=DISALLOW_LOCAL_GTID; +SELECT @@wsrep_mode; +@@wsrep_mode +DISALLOW_LOCAL_GTID +SET GLOBAL wsrep_mode='STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY'; +SELECT @@wsrep_mode; +@@wsrep_mode +STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY +SET GLOBAL wsrep_mode='STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY,REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA,DISALLOW_LOCAL_GTID'; +SELECT @@wsrep_mode; +@@wsrep_mode +STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY,REQUIRED_PRIMARY_KEY,REPLICATE_MYISAM,REPLICATE_ARIA,DISALLOW_LOCAL_GTID +SET GLOBAL wsrep_mode='BINLOG_ROW_FORMAT_ONLY,STRICT_REPLICATION'; +SELECT @@wsrep_mode; +@@wsrep_mode +STRICT_REPLICATION,BINLOG_ROW_FORMAT_ONLY +SET GLOBAL wsrep_mode='STRICT_REPLICATION,REQUIRED_PRIMARY_KEY,REPLICATE_ARIA,DISALLOW_LOCAL_GTID'; +SELECT @@wsrep_mode; +@@wsrep_mode +STRICT_REPLICATION,REQUIRED_PRIMARY_KEY,REPLICATE_ARIA,DISALLOW_LOCAL_GTID +SET GLOBAL wsrep_mode=DEFAULT; |