1# 2# Basic testing of replicate_do_db. 3# 4SET @save_replicate_do_db = @@GLOBAL.replicate_do_db; 5SELECT @save_replicate_do_db; 6@save_replicate_do_db 7 8# Scope. 9SET @@SESSION.replicate_do_db = ""; 10ERROR HY000: Variable 'replicate_do_db' is a GLOBAL variable and should be set with SET GLOBAL 11SELECT @@SESSION.replicate_do_db; 12ERROR HY000: Variable 'replicate_do_db' is a GLOBAL variable 13# Incorrect type. 14SET @@GLOBAL.replicate_do_db=1; 15ERROR 42000: Incorrect argument type to variable 'replicate_do_db' 16SET @@GLOBAL.replicate_do_db=1.1; 17ERROR 42000: Incorrect argument type to variable 'replicate_do_db' 18SET @@GLOBAL.replicate_do_db=1e1; 19ERROR 42000: Incorrect argument type to variable 'replicate_do_db' 20# Argument syntax. 21SET @@GLOBAL.replicate_do_db="db1,,,,,db3"; 22SELECT @@GLOBAL.replicate_do_db; 23@@GLOBAL.replicate_do_db 24db1,db3 25SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_do_db'; 26VARIABLE_NAME VARIABLE_VALUE 27REPLICATE_DO_DB db1,db3 28SET @@GLOBAL.replicate_do_db="db1,,,db2,,,db3"; 29SELECT @@GLOBAL.replicate_do_db; 30@@GLOBAL.replicate_do_db 31db1,db2,db3 32SET @@GLOBAL.replicate_do_db=""; 33SELECT @@GLOBAL.replicate_do_db; 34@@GLOBAL.replicate_do_db 35 36SET @@GLOBAL.replicate_do_db=null; 37SELECT @@GLOBAL.replicate_do_db; 38@@GLOBAL.replicate_do_db 39 40SET @@GLOBAL.replicate_do_db=DEFAULT; 41SELECT @@GLOBAL.replicate_do_db; 42@@GLOBAL.replicate_do_db 43 44# Cleanup. 45SET @@GLOBAL.replicate_do_db = @save_replicate_do_db; 46