Edit File: simplified_binlog_gtid_recovery_basic.result
SELECT @@GLOBAL.simplified_binlog_gtid_recovery; @@GLOBAL.simplified_binlog_gtid_recovery 0 Warnings: Warning 1287 '@@simplified_binlog_gtid_recovery' is deprecated and will be removed in a future release. Please use '@@binlog_gtid_simple_recovery' instead SELECT COUNT(@@GLOBAL.simplified_binlog_gtid_recovery); COUNT(@@GLOBAL.simplified_binlog_gtid_recovery) 1 Warnings: Warning 1287 '@@simplified_binlog_gtid_recovery' is deprecated and will be removed in a future release. Please use '@@binlog_gtid_simple_recovery' instead SELECT COUNT(@@simplified_binlog_gtid_recovery); COUNT(@@simplified_binlog_gtid_recovery) 1 Warnings: Warning 1287 '@@simplified_binlog_gtid_recovery' is deprecated and will be removed in a future release. Please use '@@binlog_gtid_simple_recovery' instead SELECT @@SESSION.simplified_binlog_gtid_recovery; ERROR HY000: Variable 'simplified_binlog_gtid_recovery' is a GLOBAL variable SHOW GLOBAL VARIABLES LIKE 'simplified_binlog_gtid_recovery'; Variable_name Value simplified_binlog_gtid_recovery OFF SHOW SESSION VARIABLES LIKE 'simplified_binlog_gtid_recovery'; Variable_name Value simplified_binlog_gtid_recovery OFF SELECT * FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='simplified_binlog_gtid_recovery'; VARIABLE_NAME VARIABLE_VALUE SIMPLIFIED_BINLOG_GTID_RECOVERY OFF SELECT * FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='simplified_binlog_gtid_recovery'; VARIABLE_NAME VARIABLE_VALUE SIMPLIFIED_BINLOG_GTID_RECOVERY OFF SET GLOBAL simplified_binlog_gtid_recovery=1; ERROR HY000: Variable 'simplified_binlog_gtid_recovery' is a read only variable SET SESSION simplified_binlog_gtid_recovery=1; ERROR HY000: Variable 'simplified_binlog_gtid_recovery' is a read only variable