1 2# 3# exists as a global only 4# 5# 2010-01-21 OBN - Added 6# 7# 8source include/not_embedded.inc; 9select @@global.rpl_semi_sync_slave_enabled; 10SET @start_global_value = @@global.rpl_semi_sync_slave_enabled; 11 12select @@global.rpl_semi_sync_slave_enabled in (0,1); 13--error ER_INCORRECT_GLOBAL_LOCAL_VAR 14select @@session.rpl_semi_sync_slave_enabled; 15show global variables like 'rpl_semi_sync_slave_enabled'; 16show session variables like 'rpl_semi_sync_slave_enabled'; 17select * from information_schema.global_variables where variable_name='rpl_semi_sync_slave_enabled'; 18select * from information_schema.session_variables where variable_name='rpl_semi_sync_slave_enabled'; 19 20# 21# show that it's writable 22# 23set global rpl_semi_sync_slave_enabled=0; 24--error ER_GLOBAL_VARIABLE 25set session rpl_semi_sync_slave_enabled=0; 26select @@global.rpl_semi_sync_slave_enabled; 27--error ER_INCORRECT_GLOBAL_LOCAL_VAR 28select @@session.rpl_semi_sync_slave_enabled; 29show global variables like 'rpl_semi_sync_slave_enabled'; 30show session variables like 'rpl_semi_sync_slave_enabled'; 31select * from information_schema.global_variables where variable_name='rpl_semi_sync_slave_enabled'; 32select * from information_schema.session_variables where variable_name='rpl_semi_sync_slave_enabled'; 33set global rpl_semi_sync_slave_enabled=1; 34--error ER_GLOBAL_VARIABLE 35set session rpl_semi_sync_slave_enabled=1; 36select @@global.rpl_semi_sync_slave_enabled; 37--error ER_INCORRECT_GLOBAL_LOCAL_VAR 38select @@session.rpl_semi_sync_slave_enabled; 39show global variables like 'rpl_semi_sync_slave_enabled'; 40show session variables like 'rpl_semi_sync_slave_enabled'; 41select * from information_schema.global_variables where variable_name='rpl_semi_sync_slave_enabled'; 42select * from information_schema.session_variables where variable_name='rpl_semi_sync_slave_enabled'; 43 44# 45# incorrect types 46# 47--error ER_WRONG_TYPE_FOR_VAR 48set global rpl_semi_sync_slave_enabled=1.1; 49--error ER_WRONG_TYPE_FOR_VAR 50set global rpl_semi_sync_slave_enabled=1e1; 51--error ER_WRONG_VALUE_FOR_VAR 52set global rpl_semi_sync_slave_enabled="some text"; 53--error ER_WRONG_VALUE_FOR_VAR 54 55 56# 57# Cleanup 58# 59SET @@global.rpl_semi_sync_slave_enabled = @start_global_value; 60select @@global.rpl_semi_sync_slave_enabled; 61