1--source include/not_embedded.inc 2 3SET @start_global_value = @@global.enforce_gtid_consistency; 4SELECT @start_global_value; 5 6# 7# exists as global only 8# 9select @@global.enforce_gtid_consistency; 10--error ER_INCORRECT_GLOBAL_LOCAL_VAR 11select @@session.enforce_gtid_consistency; 12show global variables like 'enforce_gtid_consistency'; 13show session variables like 'enforce_gtid_consistency'; 14select * from information_schema.global_variables where variable_name='enforce_gtid_consistency'; 15select * from information_schema.session_variables where variable_name='enforce_gtid_consistency'; 16 17# 18# show that it isn't writable now 19# 20--error ER_INCORRECT_GLOBAL_LOCAL_VAR 21set global enforce_gtid_consistency= 1; 22select @@global.enforce_gtid_consistency; 23--error ER_INCORRECT_GLOBAL_LOCAL_VAR 24set session enforce_gtid_consistency= 1; 25SELECT @@global.enforce_gtid_consistency; 26 27# 28# See binlog_enforce_gtid_consistency.test for a comprehensive test case. 29# 30