Debian Codegraph @

mysql-test/suite/sys_vars/r/replicate_do_db_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_do_db.
4 #
5 SET @save_replicate_do_db = @@GLOBAL.replicate_do_db;
6 SELECT @save_replicate_do_db;
7 @save_replicate_do_db
8
9 # Scope.
10 SET @@SESSION.replicate_do_db = "";
11 ERROR HY000: Variable 'replicate_do_db' is a GLOBAL variable and should be set with SET GLOBAL
12 SELECT @@SESSION.replicate_do_db;
13 ERROR HY000: Variable 'replicate_do_db' is a GLOBAL variable
14 # Incorrect type.
15 SET @@GLOBAL.replicate_do_db=1;
16 ERROR 42000: Incorrect argument type to variable 'replicate_do_db'
17 SET @@GLOBAL.replicate_do_db=1.1;
18 ERROR 42000: Incorrect argument type to variable 'replicate_do_db'
19 SET @@GLOBAL.replicate_do_db=1e1;
20 ERROR 42000: Incorrect argument type to variable 'replicate_do_db'
21 # Argument size acceptance.
22 SELECT GROUP_CONCAT(CONCAT("database_name_", seq) SEPARATOR ",")
23 INTO @name FROM seq_1_to_8;
24 SELECT LENGTH(@name);
25 LENGTH(@name)
26 127
27 SET @@GLOBAL.replicate_do_db= @name;
28 SELECT @@GLOBAL.replicate_do_db;
29 @@GLOBAL.replicate_do_db
30 database_name_1,database_name_2,database_name_3,database_name_4,database_name_5,database_name_6,database_name_7,database_name_8
31 SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_do_db';
32 VARIABLE_VALUE
33 database_name_1,database_name_2,database_name_3,database_name_4,database_name_5,database_name_6,database_name_7,database_name_8
34 Replicate_Do_DB = 'database_name_1,database_name_2,database_name_3,database_name_4,database_name_5,database_name_6,database_name_7,database_name_8'
35 # Argument syntax.
36 SET @@GLOBAL.replicate_do_db="db1,,,,,db3";
37 SELECT @@GLOBAL.replicate_do_db;
38 @@GLOBAL.replicate_do_db
39 db1,db3
40 SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_do_db';
41 VARIABLE_NAME VARIABLE_VALUE
42 REPLICATE_DO_DB db1,db3
43 Replicate_Do_DB = 'db1,db3'
44 SET @@GLOBAL.replicate_do_db="db1,,,db2,,,db3";
45 SELECT @@GLOBAL.replicate_do_db;
46 @@GLOBAL.replicate_do_db
47 db1,db2,db3
48 SET @@GLOBAL.replicate_do_db="";
49 SELECT @@GLOBAL.replicate_do_db;
50 @@GLOBAL.replicate_do_db
51
52 SET @@GLOBAL.replicate_do_db=null;
53 SELECT @@GLOBAL.replicate_do_db;
54 @@GLOBAL.replicate_do_db
55
56 SET @@GLOBAL.replicate_do_db=DEFAULT;
57 SELECT @@GLOBAL.replicate_do_db;
58 @@GLOBAL.replicate_do_db
59
60 # Cleanup.
61 SET @@GLOBAL.replicate_do_db = @save_replicate_do_db;
62 #
63 # MDEV-35688 UBSAN: SUMMARY: UndefinedBehaviorSanitizer: nullptr-with-offset in my_casedn_utf8mb3
64 #
65 show variables like 'replicate_do_db';
66 Variable_name Value
67 replicate_do_db