Debian Codegraph @

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

raw
1 SELECT @@GLOBAL.binlog_error_action;
2 @@GLOBAL.binlog_error_action
3 ABORT_SERVER
4 ABORT_SERVER Expected
5 SELECT @@SESSION.binlog_error_action;
6 ERROR HY000: Variable 'binlog_error_action' is a GLOBAL variable
7 SET @start_value= @@global.binlog_error_action;
8 SHOW GLOBAL VARIABLES LIKE 'binlog_error_action';
9 Variable_name Value
10 binlog_error_action ABORT_SERVER
11 SET @@GLOBAL.binlog_error_action=IGNORE_ERROR;
12 SELECT @@GLOBAL.binlog_error_action;
13 @@GLOBAL.binlog_error_action
14 IGNORE_ERROR
15 IGNORE_ERROR Expected
16 SET @@GLOBAL.binlog_error_action=ABORT_SERVER;
17 SELECT @@GLOBAL.binlog_error_action;
18 @@GLOBAL.binlog_error_action
19 ABORT_SERVER
20 ABORT_SERVER Expected
21 SELECT @@GLOBAL.binlog_error_action = VARIABLE_VALUE
22 FROM performance_schema.global_variables
23 WHERE VARIABLE_NAME='binlog_error_action';
24 @@GLOBAL.binlog_error_action = VARIABLE_VALUE
25 1
26 1 Expected
27 SELECT COUNT(@@GLOBAL.binlog_error_action);
28 COUNT(@@GLOBAL.binlog_error_action)
29 1
30 1 Expected
31 SELECT COUNT(VARIABLE_VALUE)
32 FROM performance_schema.global_variables
33 WHERE VARIABLE_NAME='binlog_error_action';
34 COUNT(VARIABLE_VALUE)
35 1
36 1 Expected
37 SELECT COUNT(@@binlog_error_action);
38 COUNT(@@binlog_error_action)
39 1
40 1 Expected
41 SELECT COUNT(@@GLOBAL.binlog_error_action);
42 COUNT(@@GLOBAL.binlog_error_action)
43 1
44 1 Expected
45 SET @@global.binlog_error_action= @start_value;