1# 2# Basic testing of replicate_ignore_table. 3# 4SET @save_replicate_ignore_table = @@GLOBAL.replicate_ignore_table; 5SELECT @save_replicate_ignore_table; 6@save_replicate_ignore_table 7 8# Scope. 9SET @@SESSION.replicate_ignore_table = ""; 10ERROR HY000: Variable 'replicate_ignore_table' is a GLOBAL variable and should be set with SET GLOBAL 11SELECT @@SESSION.replicate_ignore_table; 12ERROR HY000: Variable 'replicate_ignore_table' is a GLOBAL variable 13# Incorrect type. 14SET @@GLOBAL.replicate_ignore_table=1; 15ERROR 42000: Incorrect argument type to variable 'replicate_ignore_table' 16SET @@GLOBAL.replicate_ignore_table=1.1; 17ERROR 42000: Incorrect argument type to variable 'replicate_ignore_table' 18SET @@GLOBAL.replicate_ignore_table=1e1; 19ERROR 42000: Incorrect argument type to variable 'replicate_ignore_table' 20# Incorrect arguments. 21SET @@GLOBAL.replicate_ignore_table="t1"; 22ERROR HY000: Incorrect arguments to SET 23SET @@GLOBAL.replicate_ignore_table="test.t1, t2"; 24ERROR HY000: Incorrect arguments to SET 25SET @@GLOBAL.replicate_ignore_table="test.,t1"; 26ERROR HY000: Incorrect arguments to SET 27# Argument syntax. 28SET @@GLOBAL.replicate_ignore_table="test.t1,,,,,test.t3"; 29SELECT @@GLOBAL.replicate_ignore_table; 30@@GLOBAL.replicate_ignore_table 31test.t3,test.t1 32SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_ignore_table'; 33VARIABLE_NAME VARIABLE_VALUE 34REPLICATE_IGNORE_TABLE test.t3,test.t1 35SET @@GLOBAL.replicate_ignore_table="test.t1,,,test2.t2,,,test.t3"; 36SELECT @@GLOBAL.replicate_ignore_table; 37@@GLOBAL.replicate_ignore_table 38test.t3,test.t1,test2.t2 39SET @@GLOBAL.replicate_ignore_table=""; 40SELECT @@GLOBAL.replicate_ignore_table; 41@@GLOBAL.replicate_ignore_table 42 43SET @@GLOBAL.replicate_ignore_table=null; 44SELECT @@GLOBAL.replicate_ignore_table; 45@@GLOBAL.replicate_ignore_table 46 47# Cleanup. 48SET @@GLOBAL.replicate_ignore_table = @save_replicate_ignore_table; 49# 50# MDEV-20101 Assertion failure on select @@global.'m2'.replicate_ignore_table 51# 52SET NAMES latin1; 53SELECT @@global.'m2'.replicate_ignore_table; 54@@global.'m2'.replicate_ignore_table 55NULL 56Warnings: 57Warning 1617 There is no master connection 'm2' 58Warning 1617 There is no master connection 'm2' 59