Debian Codegraph @

mysql-test/suite/sys_vars/t/replicate_ignore_db_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_Ignore_DB
6
7 --echo #
8 --echo # Basic testing of replicate_ignore_db.
9 --echo #
10
11 SET @save_replicate_ignore_db = @@GLOBAL.replicate_ignore_db;
12 SELECT @save_replicate_ignore_db;
13
14 --echo # Scope.
15
16 --error ER_GLOBAL_VARIABLE
17 SET @@SESSION.replicate_ignore_db = "";
18 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
19 SELECT @@SESSION.replicate_ignore_db;
20
21 --echo # Incorrect type.
22
23 --error ER_WRONG_TYPE_FOR_VAR
24 SET @@GLOBAL.replicate_ignore_db=1;
25 --error ER_WRONG_TYPE_FOR_VAR
26 SET @@GLOBAL.replicate_ignore_db=1.1;
27 --error ER_WRONG_TYPE_FOR_VAR
28 SET @@GLOBAL.replicate_ignore_db=1e1;
29
30 # MDEV-35693 Replicate_* fields of Show-Slave-Status display truncated
31 --echo # Argument size acceptance.
32
33 SELECT GROUP_CONCAT(CONCAT("database_name_", seq) SEPARATOR ",")
34 INTO @name FROM seq_1_to_8;
35 SELECT LENGTH(@name);
36 SET @@GLOBAL.replicate_ignore_db= @name;
37 SELECT @@GLOBAL.replicate_ignore_db;
38 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_ignore_db';
39 --source include/show_slave_status.inc
40
41 --echo # Argument syntax.
42
43 SET @@GLOBAL.replicate_ignore_db="db1,,,,,db3";
44 SELECT @@GLOBAL.replicate_ignore_db;
45 SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_ignore_db';
46 --source include/show_slave_status.inc
47
48 SET @@GLOBAL.replicate_ignore_db="db1,,,db2,,,db3";
49 SELECT @@GLOBAL.replicate_ignore_db;
50
51 SET @@GLOBAL.replicate_ignore_db="";
52 SELECT @@GLOBAL.replicate_ignore_db;
53
54 SET @@GLOBAL.replicate_ignore_db=null;
55 SELECT @@GLOBAL.replicate_ignore_db;
56
57 --echo # Cleanup.
58 SET @@GLOBAL.replicate_ignore_db = @save_replicate_ignore_db;