1SELECT @@GLOBAL.binlogging_impossible_mode;
2@@GLOBAL.binlogging_impossible_mode
3IGNORE_ERROR
4Warnings:
5Warning	1287	'@@binlogging_impossible_mode' is deprecated and will be removed in a future release. Please use '@@binlog_error_action' instead
6IGNORE_ERROR Expected
7SELECT @@SESSION.binlogging_impossible_mode;
8ERROR HY000: Variable 'binlogging_impossible_mode' is a GLOBAL variable
9SET @start_value= @@global.binlogging_impossible_mode;
10Warnings:
11Warning	1287	'@@binlogging_impossible_mode' is deprecated and will be removed in a future release. Please use '@@binlog_error_action' instead
12SHOW GLOBAL VARIABLES LIKE 'binlogging_impossible_mode';
13Variable_name	Value
14binlogging_impossible_mode	IGNORE_ERROR
15SET @@GLOBAL.binlogging_impossible_mode=IGNORE_ERROR;
16Warnings:
17Warning	1287	'@@binlogging_impossible_mode' is deprecated and will be removed in a future release. Please use '@@binlog_error_action' instead
18SELECT @@GLOBAL.binlogging_impossible_mode;
19@@GLOBAL.binlogging_impossible_mode
20IGNORE_ERROR
21Warnings:
22Warning	1287	'@@binlogging_impossible_mode' is deprecated and will be removed in a future release. Please use '@@binlog_error_action' instead
23IGNORE_ERROR Expected
24SET @@GLOBAL.binlogging_impossible_mode=ABORT_SERVER;
25Warnings:
26Warning	1287	'@@binlogging_impossible_mode' is deprecated and will be removed in a future release. Please use '@@binlog_error_action' instead
27SELECT @@GLOBAL.binlogging_impossible_mode;
28@@GLOBAL.binlogging_impossible_mode
29ABORT_SERVER
30Warnings:
31Warning	1287	'@@binlogging_impossible_mode' is deprecated and will be removed in a future release. Please use '@@binlog_error_action' instead
32ABORT_SERVER Expected
33SELECT @@GLOBAL.binlogging_impossible_mode = VARIABLE_VALUE
34FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
35WHERE VARIABLE_NAME='binlogging_impossible_mode';
36@@GLOBAL.binlogging_impossible_mode = VARIABLE_VALUE
371
38Warnings:
39Warning	1287	'@@binlogging_impossible_mode' is deprecated and will be removed in a future release. Please use '@@binlog_error_action' instead
401 Expected
41SELECT COUNT(@@GLOBAL.binlogging_impossible_mode);
42COUNT(@@GLOBAL.binlogging_impossible_mode)
431
44Warnings:
45Warning	1287	'@@binlogging_impossible_mode' is deprecated and will be removed in a future release. Please use '@@binlog_error_action' instead
461 Expected
47SELECT COUNT(VARIABLE_VALUE)
48FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
49WHERE VARIABLE_NAME='binlogging_impossible_mode';
50COUNT(VARIABLE_VALUE)
511
521 Expected
53SELECT COUNT(@@binlogging_impossible_mode);
54COUNT(@@binlogging_impossible_mode)
551
56Warnings:
57Warning	1287	'@@binlogging_impossible_mode' is deprecated and will be removed in a future release. Please use '@@binlog_error_action' instead
581 Expected
59SELECT COUNT(@@GLOBAL.binlogging_impossible_mode);
60COUNT(@@GLOBAL.binlogging_impossible_mode)
611
62Warnings:
63Warning	1287	'@@binlogging_impossible_mode' is deprecated and will be removed in a future release. Please use '@@binlog_error_action' instead
641 Expected
65SET @@global.binlogging_impossible_mode= @start_value;
66Warnings:
67Warning	1287	'@@binlogging_impossible_mode' is deprecated and will be removed in a future release. Please use '@@binlog_error_action' instead
68