Debian Codegraph @

mysql-test/suite/sys_vars/r/gtid_ignore_duplicates_basic.result

raw
1 SET @save_gtid_ignore_duplicates= @@GLOBAL.gtid_ignore_duplicates;
2 SELECT @@GLOBAL.gtid_ignore_duplicates as 'must be zero because of default';
3 must be zero because of default
4 0
5 SELECT @@SESSION.gtid_ignore_duplicates as 'no session var';
6 ERROR HY000: Variable 'gtid_ignore_duplicates' is a GLOBAL variable
7 SET GLOBAL gtid_ignore_duplicates= FALSE;
8 SET GLOBAL gtid_ignore_duplicates= DEFAULT;
9 SET GLOBAL gtid_ignore_duplicates= TRUE;
10 SELECT @@GLOBAL.gtid_ignore_duplicates;
11 @@GLOBAL.gtid_ignore_duplicates
12 1
13 SET GLOBAL gtid_ignore_duplicates = @save_gtid_ignore_duplicates;