Debian Codegraph @

mysql-test/suite/sys_vars/r/slave_ddl_exec_mode_basic.result

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