1# 2# wsrep_node_address 3# 4# save the initial value 5SET @wsrep_node_address_global_saved = @@global.wsrep_node_address; 6# default 7SELECT @@global.wsrep_node_address; 8@@global.wsrep_node_address 9 10 11# scope 12SELECT @@session.wsrep_node_address; 13ERROR HY000: Variable 'wsrep_node_address' is a GLOBAL variable 14SELECT @@global.wsrep_node_address; 15@@global.wsrep_node_address 16 17 18# valid values 19SET @@global.wsrep_node_address='127.0.0.1'; 20SELECT @@global.wsrep_node_address; 21@@global.wsrep_node_address 22127.0.0.1 23SET @@global.wsrep_node_address=default; 24SELECT @@global.wsrep_node_address; 25@@global.wsrep_node_address 26 27 28# invalid values 29SET @@global.wsrep_node_address=NULL; 30ERROR 42000: Variable 'wsrep_node_address' can't be set to the value of 'NULL' 31SELECT @@global.wsrep_node_address; 32@@global.wsrep_node_address 33 34SET @@global.wsrep_node_address=ON; 35SELECT @@global.wsrep_node_address; 36@@global.wsrep_node_address 37ON 38SET @@global.wsrep_node_address='OFF'; 39SELECT @@global.wsrep_node_address; 40@@global.wsrep_node_address 41OFF 42SET @@global.wsrep_node_address='junk'; 43SELECT @@global.wsrep_node_address; 44@@global.wsrep_node_address 45junk 46 47# restore the initial value 48SET @@global.wsrep_node_address = @wsrep_node_address_global_saved; 49# End of test 50