Debian Codegraph @

mysql-test/suite/sys_vars/t/replicate_wild_do_table_basic.test

raw
1 --source include/have_sequence.inc
2 # have show_slave_status
3 --source include/not_embedded.inc
4 CHANGE MASTER TO master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
5 --let $status_items= Replicate_Wild_Do_Table
6
7 --echo #
8 --echo # Basic testing of replicate_wild_do_table.
9 --echo #
10
11 SET @save_replicate_wild_do_table = @@GLOBAL.replicate_wild_do_table;
12 SELECT @save_replicate_wild_do_table;
13
14 --echo # Scope.
15
16 --error ER_GLOBAL_VARIABLE
17 SET @@SESSION.replicate_wild_do_table = "";
18 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
19 SELECT @@SESSION.replicate_wild_do_table;
20
21 --echo # Incorrect type.
22
23 --error ER_WRONG_TYPE_FOR_VAR
24 SET @@GLOBAL.replicate_wild_do_table=1;
25 --error ER_WRONG_TYPE_FOR_VAR
26 SET @@GLOBAL.replicate_wild_do_table=1.1;
27 --error ER_WRONG_TYPE_FOR_VAR
28 SET @@GLOBAL.replicate_wild_do_table=1e1;
29
30 --echo # Incorrect arguments.
31
32 --error ER_WRONG_ARGUMENTS
33 SET @@GLOBAL.replicate_wild_do_table="t1";
34 --error ER_WRONG_ARGUMENTS
35 SET @@GLOBAL.replicate_wild_do_table="test.t, t2";
36 --error ER_WRONG_ARGUMENTS
37 SET @@GLOBAL.replicate_wild_do_table="test.,t1";
38
39 # MDEV-35693 Replicate_* fields of Show-Slave-Status display truncated
40 --echo # Argument size acceptance.
41
42 SELECT GROUP_CONCAT(CONCAT("database_name.long_table_name_", seq) SEPARATOR ",")
43 INTO @name FROM seq_1_to_8;
44 SELECT LENGTH(@name);
45 SET @@GLOBAL.replicate_wild_do_table= @name;
46 SELECT @@GLOBAL.replicate_wild_do_table;
47 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_wild_do_table';
48 --source include/show_slave_status.inc
49
50 --echo # Argument syntax.
51
52 SET @@GLOBAL.replicate_wild_do_table="test.%,,,,,test.t3";
53 SELECT @@GLOBAL.replicate_wild_do_table;
54 SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_wild_do_table';
55 --source include/show_slave_status.inc
56
57 SET @@GLOBAL.replicate_wild_do_table="test.t1,,,test2.%,,,test.t3";
58 SELECT @@GLOBAL.replicate_wild_do_table;
59
60 SET @@GLOBAL.replicate_wild_do_table="";
61 SELECT @@GLOBAL.replicate_wild_do_table;
62
63 SET @@GLOBAL.replicate_wild_do_table=null;
64 SELECT @@GLOBAL.replicate_wild_do_table;
65
66 --echo # Cleanup.
67 SET @@GLOBAL.replicate_wild_do_table = @save_replicate_wild_do_table;