1SET @start_value = @@global.slave_ddl_exec_mode;
2SELECT @@global.slave_ddl_exec_mode;
3@@global.slave_ddl_exec_mode
4IDEMPOTENT
5SELECT @@slave_ddl_exec_mode = @@GLOBAL.slave_ddl_exec_mode;
6@@slave_ddl_exec_mode = @@GLOBAL.slave_ddl_exec_mode
71
81 Expected
9SELECT COUNT(@@slave_ddl_exec_mode);
10COUNT(@@slave_ddl_exec_mode)
111
121 Expected
13SELECT COUNT(@@local.slave_ddl_exec_mode);
14ERROR HY000: Variable 'slave_ddl_exec_mode' is a GLOBAL variable
15Expected error 'Variable is a GLOBAL variable'
16SELECT COUNT(@@SESSION.slave_ddl_exec_mode);
17ERROR HY000: Variable 'slave_ddl_exec_mode' is a GLOBAL variable
18Expected error 'Variable is a GLOBAL variable'
19SELECT COUNT(@@GLOBAL.slave_ddl_exec_mode);
20COUNT(@@GLOBAL.slave_ddl_exec_mode)
211
221 Expected
23SELECT slave_ddl_exec_mode = @@SESSION.version;
24ERROR 42S22: Unknown column 'slave_ddl_exec_mode' in 'field list'
25Expected error 'Readonly variable'
26SET @@GLOBAL.slave_ddl_exec_mode=STRICT;
27SELECT @@GLOBAL.slave_ddl_exec_mode;
28@@GLOBAL.slave_ddl_exec_mode
29STRICT
30SET @@GLOBAL.slave_ddl_exec_mode=IDEMPOTENT;
31SELECT @@GLOBAL.slave_ddl_exec_mode;
32@@GLOBAL.slave_ddl_exec_mode
33IDEMPOTENT
34SET @@GLOBAL.slave_ddl_exec_mode=XXX;
35ERROR 42000: Variable 'slave_ddl_exec_mode' can't be set to the value of 'XXX'
36SELECT @@GLOBAL.slave_ddl_exec_mode;
37@@GLOBAL.slave_ddl_exec_mode
38IDEMPOTENT
39SET @@global.slave_ddl_exec_mode= @start_value;
40