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