Debian Codegraph @

mysql-test/suite/sys_vars/r/replicate_wild_ignore_table_basic.result

raw
1 CHANGE MASTER TO master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
2 #
3 # Basic testing of replicate_wild_ignore_table.
4 #
5 SET @save_replicate_wild_ignore_table = @@GLOBAL.replicate_wild_ignore_table;
6 SELECT @save_replicate_wild_ignore_table;
7 @save_replicate_wild_ignore_table
8
9 # Scope.
10 SET @@SESSION.replicate_wild_ignore_table = "";
11 ERROR HY000: Variable 'replicate_wild_ignore_table' is a GLOBAL variable and should be set with SET GLOBAL
12 SELECT @@SESSION.replicate_wild_ignore_table;
13 ERROR HY000: Variable 'replicate_wild_ignore_table' is a GLOBAL variable
14 # Incorrect type.
15 SET @@GLOBAL.replicate_wild_ignore_table=1;
16 ERROR 42000: Incorrect argument type to variable 'replicate_wild_ignore_table'
17 SET @@GLOBAL.replicate_wild_ignore_table=1.1;
18 ERROR 42000: Incorrect argument type to variable 'replicate_wild_ignore_table'
19 SET @@GLOBAL.replicate_wild_ignore_table=1e1;
20 ERROR 42000: Incorrect argument type to variable 'replicate_wild_ignore_table'
21 # Incorrect arguments.
22 SET @@GLOBAL.replicate_wild_ignore_table="t1";
23 ERROR HY000: Incorrect arguments to SET
24 SET @@GLOBAL.replicate_wild_ignore_table="test.t, t2";
25 ERROR HY000: Incorrect arguments to SET
26 SET @@GLOBAL.replicate_wild_ignore_table="test.,t1";
27 ERROR HY000: Incorrect arguments to SET
28 # Argument size acceptance.
29 SELECT GROUP_CONCAT(CONCAT("database_name.long_table_name_", seq) SEPARATOR ",")
30 INTO @name FROM seq_1_to_8;
31 SELECT LENGTH(@name);
32 LENGTH(@name)
33 255
34 SET @@GLOBAL.replicate_wild_ignore_table= @name;
35 SELECT @@GLOBAL.replicate_wild_ignore_table;
36 @@GLOBAL.replicate_wild_ignore_table
37 database_name.long_table_name_1,database_name.long_table_name_2,database_name.long_table_name_3,database_name.long_table_name_4,database_name.long_table_name_5,database_name.long_table_name_6,database_name.long_table_name_7,database_name.long_table_name_8
38 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_wild_ignore_table';
39 VARIABLE_VALUE
40 database_name.long_table_name_1,database_name.long_table_name_2,database_name.long_table_name_3,database_name.long_table_name_4,database_name.long_table_name_5,database_name.long_table_name_6,database_name.long_table_name_7,database_name.long_table_name_8
41 Replicate_Wild_Ignore_Table = 'database_name.long_table_name_1,database_name.long_table_name_2,database_name.long_table_name_3,database_name.long_table_name_4,database_name.long_table_name_5,database_name.long_table_name_6,database_name.long_table_name_7,database_name.long_table_name_8'
42 # Argument syntax.
43 SET @@GLOBAL.replicate_wild_ignore_table="test.%,,,,,test.t3";
44 SELECT @@GLOBAL.replicate_wild_ignore_table;
45 @@GLOBAL.replicate_wild_ignore_table
46 test.%,test.t3
47 SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_wild_ignore_table';
48 VARIABLE_NAME VARIABLE_VALUE
49 REPLICATE_WILD_IGNORE_TABLE test.%,test.t3
50 Replicate_Wild_Ignore_Table = 'test.%,test.t3'
51 SET @@GLOBAL.replicate_wild_ignore_table="test.t1,,,test2.%,,,test.t3";
52 SELECT @@GLOBAL.replicate_wild_ignore_table;
53 @@GLOBAL.replicate_wild_ignore_table
54 test.t1,test2.%,test.t3
55 SET @@GLOBAL.replicate_wild_ignore_table="";
56 SELECT @@GLOBAL.replicate_wild_ignore_table;
57 @@GLOBAL.replicate_wild_ignore_table
58
59 SET @@GLOBAL.replicate_wild_ignore_table=null;
60 SELECT @@GLOBAL.replicate_wild_ignore_table;
61 @@GLOBAL.replicate_wild_ignore_table
62
63 # Cleanup.
64 SET @@GLOBAL.replicate_wild_ignore_table = @save_replicate_wild_ignore_table;