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