diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/wsrep_strict_ddl_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/wsrep_strict_ddl_basic.result | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/wsrep_strict_ddl_basic.result b/mysql-test/suite/sys_vars/r/wsrep_strict_ddl_basic.result new file mode 100644 index 00000000000..6d686f9de2e --- /dev/null +++ b/mysql-test/suite/sys_vars/r/wsrep_strict_ddl_basic.result @@ -0,0 +1,45 @@ +# +# wsrep_strict_ddl +# +# save the initial value +SET @wsrep_strict_ddl_global_saved = @@global.wsrep_strict_ddl; +# default +SELECT @@global.wsrep_strict_ddl; +@@global.wsrep_strict_ddl +0 + +# scope +SELECT @@session.wsrep_strict_ddl; +ERROR HY000: Variable 'wsrep_strict_ddl' is a GLOBAL variable +SET @@global.wsrep_strict_ddl=OFF; +SELECT @@global.wsrep_strict_ddl; +@@global.wsrep_strict_ddl +0 +SET @@global.wsrep_strict_ddl=ON; +SELECT @@global.wsrep_strict_ddl; +@@global.wsrep_strict_ddl +1 + +# valid values +SET @@global.wsrep_strict_ddl='OFF'; +SELECT @@global.wsrep_strict_ddl; +@@global.wsrep_strict_ddl +0 +SET @@global.wsrep_strict_ddl=ON; +SELECT @@global.wsrep_strict_ddl; +@@global.wsrep_strict_ddl +1 +SET @@global.wsrep_strict_ddl=default; +SELECT @@global.wsrep_strict_ddl; +@@global.wsrep_strict_ddl +0 + +# invalid values +SET @@global.wsrep_strict_ddl=NULL; +ERROR 42000: Variable 'wsrep_strict_ddl' can't be set to the value of 'NULL' +SET @@global.wsrep_strict_ddl='junk'; +ERROR 42000: Variable 'wsrep_strict_ddl' can't be set to the value of 'junk' + +# restore the initial value +SET @@global.wsrep_strict_ddl = @wsrep_strict_ddl_global_saved; +# End of test |