2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
7
'#--------------------FN_DYNVARS_037_01-------------------------#'
8
SET @@global.init_slave = "SET @a = 10";
9
'connect (con1,localhost,root,,)'
11
SELECT @@global.init_slave;
15
'#--------------------FN_DYNVARS_037_02-------------------------#'
16
'check if value in slave opt file is executed'
18
show variables like 'init_slave';
20
init_slave set global max_connections=500
21
show variables like 'max_connections';
25
'check if value in slave opt file doesnt apply to master'
27
show variables like 'init_slave';
29
init_slave SET @a = 10
30
show variables like 'max_connections';
34
'try creating a temporary variable in init_slave'
35
SET @@global.init_slave = "SET @a=5";
38
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
40
SHOW VARIABLES LIKE 'init_slave';
46
'Bug#35365 SET statement in init_slave not execute if slave is restarted'
47
set global max_connections= default;