1# 2# wsrep_node_name 3# 4call mtr.add_suppression("WSREP: Failed to get provider options"); 5# save the initial value 6SET @wsrep_node_name_global_saved = @@global.wsrep_node_name; 7# default (expect 1) 8SELECT COUNT(@@global.wsrep_node_name); 9COUNT(@@global.wsrep_node_name) 101 11 12# scope 13SELECT @@session.wsrep_node_name; 14ERROR HY000: Variable 'wsrep_node_name' is a GLOBAL variable 15SET @@global.wsrep_node_name='node_name'; 16SELECT @@global.wsrep_node_name; 17@@global.wsrep_node_name 18node_name 19 20# valid values 21SET @@global.wsrep_node_name='my_node'; 22SELECT @@global.wsrep_node_name; 23@@global.wsrep_node_name 24my_node 25SET @@global.wsrep_node_name='hyphenated-node-name'; 26SELECT @@global.wsrep_node_name; 27@@global.wsrep_node_name 28hyphenated-node-name 29SET @@global.wsrep_node_name=default; 30# default (expect 1) 31SELECT COUNT(@@global.wsrep_node_name); 32COUNT(@@global.wsrep_node_name) 331 34 35# invalid values 36SET @@global.wsrep_node_name=NULL; 37ERROR 42000: Variable 'wsrep_node_name' can't be set to the value of 'NULL' 38SELECT COUNT(@@global.wsrep_node_name); 39COUNT(@@global.wsrep_node_name) 401 41SET @@global.wsrep_node_name=1; 42ERROR 42000: Incorrect argument type to variable 'wsrep_node_name' 43SELECT COUNT(@@global.wsrep_node_name); 44COUNT(@@global.wsrep_node_name) 451 46# 47# MDEV-6699 : wsrep_node_name not automaticly set to hostname 48# 49SET @@global.wsrep_node_name=default; 50SELECT @@GLOBAL.wsrep_node_name = VARIABLE_VALUE FROM 51INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='hostname'; 52@@GLOBAL.wsrep_node_name = VARIABLE_VALUE 531 54SELECT @@GLOBAL.wsrep_node_name = VARIABLE_VALUE FROM 55INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='wsrep_node_name'; 56@@GLOBAL.wsrep_node_name = VARIABLE_VALUE 571 58 59# restore the initial value 60SET @@global.wsrep_node_name = @wsrep_node_name_global_saved; 61# End of test 62