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