1#
2# Basic testing of replicate_do_db.
3#
4SET @save_replicate_do_db = @@GLOBAL.replicate_do_db;
5SELECT @save_replicate_do_db;
6@save_replicate_do_db
7
8# Scope.
9SET @@SESSION.replicate_do_db = "";
10ERROR HY000: Variable 'replicate_do_db' is a GLOBAL variable and should be set with SET GLOBAL
11SELECT @@SESSION.replicate_do_db;
12ERROR HY000: Variable 'replicate_do_db' is a GLOBAL variable
13# Incorrect type.
14SET @@GLOBAL.replicate_do_db=1;
15ERROR 42000: Incorrect argument type to variable 'replicate_do_db'
16SET @@GLOBAL.replicate_do_db=1.1;
17ERROR 42000: Incorrect argument type to variable 'replicate_do_db'
18SET @@GLOBAL.replicate_do_db=1e1;
19ERROR 42000: Incorrect argument type to variable 'replicate_do_db'
20# Argument syntax.
21SET @@GLOBAL.replicate_do_db="db1,,,,,db3";
22SELECT @@GLOBAL.replicate_do_db;
23@@GLOBAL.replicate_do_db
24db1,db3
25SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='replicate_do_db';
26VARIABLE_NAME	VARIABLE_VALUE
27REPLICATE_DO_DB	db1,db3
28SET @@GLOBAL.replicate_do_db="db1,,,db2,,,db3";
29SELECT @@GLOBAL.replicate_do_db;
30@@GLOBAL.replicate_do_db
31db1,db2,db3
32SET @@GLOBAL.replicate_do_db="";
33SELECT @@GLOBAL.replicate_do_db;
34@@GLOBAL.replicate_do_db
35
36SET @@GLOBAL.replicate_do_db=null;
37SELECT @@GLOBAL.replicate_do_db;
38@@GLOBAL.replicate_do_db
39
40SET @@GLOBAL.replicate_do_db=DEFAULT;
41SELECT @@GLOBAL.replicate_do_db;
42@@GLOBAL.replicate_do_db
43
44# Cleanup.
45SET @@GLOBAL.replicate_do_db = @save_replicate_do_db;
46