Debian Codegraph @

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

raw
1 set @saved_session_rbr_exec_mode = @@session.rbr_exec_mode;
2 SET global rbr_exec_mode=DEFAULT;
3 ERROR HY000: Variable 'rbr_exec_mode' is a SESSION variable and can't be used with SET GLOBAL
4 SELECT @@global.rbr_exec_mode;
5 @@global.rbr_exec_mode
6 STRICT
7 SET global rbr_exec_mode='IDEMPOTENT';
8 ERROR HY000: Variable 'rbr_exec_mode' is a SESSION variable and can't be used with SET GLOBAL
9 SELECT @@global.rbr_exec_mode;
10 @@global.rbr_exec_mode
11 STRICT
12 SET global rbr_exec_mode='STRICT';
13 ERROR HY000: Variable 'rbr_exec_mode' is a SESSION variable and can't be used with SET GLOBAL
14 SELECT @@global.rbr_exec_mode;
15 @@global.rbr_exec_mode
16 STRICT
17 SELECT @@session.rbr_exec_mode;
18 @@session.rbr_exec_mode
19 STRICT
20 SET session rbr_exec_mode=DEFAULT;
21 SELECT @@session.rbr_exec_mode;
22 @@session.rbr_exec_mode
23 STRICT
24 SET session rbr_exec_mode='IDEMPOTENT';
25 SELECT @@session.rbr_exec_mode;
26 @@session.rbr_exec_mode
27 IDEMPOTENT
28 SET session rbr_exec_mode='STRICT';
29 SELECT @@session.rbr_exec_mode;
30 @@session.rbr_exec_mode
31 STRICT
32 SET session rbr_exec_mode='STIRCT';
33 ERROR 42000: Variable 'rbr_exec_mode' can't be set to the value of 'STIRCT'
34 SELECT @@session.rbr_exec_mode;
35 @@session.rbr_exec_mode
36 STRICT
37 SET session rbr_exec_mode='';
38 ERROR 42000: Variable 'rbr_exec_mode' can't be set to the value of ''
39 SELECT @@session.rbr_exec_mode;
40 @@session.rbr_exec_mode
41 STRICT
42 SET session rbr_exec_mode='1';
43 ERROR 42000: Variable 'rbr_exec_mode' can't be set to the value of '1'
44 SELECT @@session.rbr_exec_mode;
45 @@session.rbr_exec_mode
46 STRICT
47 SET session rbr_exec_mode=NULL;
48 ERROR 42000: Variable 'rbr_exec_mode' can't be set to the value of 'NULL'
49 SELECT @@session.rbr_exec_mode;
50 @@session.rbr_exec_mode
51 STRICT
52 set session rbr_exec_mode = @saved_session_rbr_exec_mode;