Debian Codegraph @

mysql-test/suite/sys_vars/t/gtid_executed_basic.test

raw
1
2 RESET MASTER;
3 SET @start_global_value = @@global.gtid_executed;
4 SELECT @start_global_value;
5
6 #
7 # exists as global and session
8 #
9 select @@global.gtid_executed;
10 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
11 select @@session.gtid_executed;
12 show global variables like 'gtid_executed';
13 show session variables like 'gtid_executed';
14 --disable_warnings
15 select * from performance_schema.global_variables where variable_name='gtid_executed';
16 select * from performance_schema.session_variables where variable_name='gtid_executed';
17 --enable_warnings
18
19 #
20 # It is not writable.
21 #
22 select @@global.gtid_executed;
23 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
24 set @@global.gtid_executed = '';
25 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
26 set @@session.gtid_executed = '';
27
28 #
29 # See rpl_gtid_execution.test for a comprehensive test case.
30 #