Debian Codegraph @

mysql-test/suite/sys_vars/t/rbr_exec_mode_basic.test

raw
1 ###############################################################################
2 # This test checks the basics of setting the variable rbr_exec_mode
3 #
4 ################################################################################
5
6 set @saved_session_rbr_exec_mode = @@session.rbr_exec_mode;
7
8 # GLOBAL SETTINGS
9 --error ER_LOCAL_VARIABLE
10 SET global rbr_exec_mode=DEFAULT;
11 SELECT @@global.rbr_exec_mode;
12
13 --error ER_LOCAL_VARIABLE
14 SET global rbr_exec_mode='IDEMPOTENT';
15 SELECT @@global.rbr_exec_mode;
16
17 --error ER_LOCAL_VARIABLE
18 SET global rbr_exec_mode='STRICT';
19 SELECT @@global.rbr_exec_mode;
20
21 # SESSION SETTINGS
22 SELECT @@session.rbr_exec_mode;
23
24 SET session rbr_exec_mode=DEFAULT;
25 SELECT @@session.rbr_exec_mode;
26
27 SET session rbr_exec_mode='IDEMPOTENT';
28 SELECT @@session.rbr_exec_mode;
29
30 SET session rbr_exec_mode='STRICT';
31 SELECT @@session.rbr_exec_mode;
32
33 # checking that setting variable to a non existing value raises error
34 # INVALID SESSION SETTINGS
35 --error ER_WRONG_VALUE_FOR_VAR
36 SET session rbr_exec_mode='STIRCT';
37 SELECT @@session.rbr_exec_mode;
38
39 --error ER_WRONG_VALUE_FOR_VAR
40 SET session rbr_exec_mode='';
41 SELECT @@session.rbr_exec_mode;
42
43 --error ER_WRONG_VALUE_FOR_VAR
44 SET session rbr_exec_mode='1';
45 SELECT @@session.rbr_exec_mode;
46
47 --error ER_WRONG_VALUE_FOR_VAR
48 SET session rbr_exec_mode=NULL;
49 SELECT @@session.rbr_exec_mode;
50
51 set session rbr_exec_mode = @saved_session_rbr_exec_mode;