# # wsrep_provider # # save the initial value SET @wsrep_provider_global_saved = @@global.wsrep_provider; # default SELECT @@global.wsrep_provider; @@global.wsrep_provider none # scope SELECT @@session.wsrep_provider; ERROR HY000: Variable 'wsrep_provider' is a GLOBAL variable SELECT @@global.wsrep_provider; @@global.wsrep_provider none # valid values SET @@global.wsrep_provider=default; SELECT @@global.wsrep_provider; @@global.wsrep_provider none # invalid values SET @@global.wsrep_provider='/invalid/libgalera_smm.so'; ERROR 42000: Variable 'wsrep_provider' can't be set to the value of '/invalid/libgalera_smm.so' SET @@global.wsrep_provider=NULL; ERROR 42000: Variable 'wsrep_provider' can't be set to the value of 'NULL' SELECT @@global.wsrep_provider; @@global.wsrep_provider none SET @@global.wsrep_provider=1; ERROR 42000: Incorrect argument type to variable 'wsrep_provider' SELECT @@global.wsrep_provider; @@global.wsrep_provider none # restore the initial value SET @@global.wsrep_provider = @wsrep_provider_global_saved; # End of test