1# ALL_GTIDS at startup: this must return GTID:1
2CREATE TABLE t1 (c1 INT) Engine=InnoDB;
3-- Tracker : SESSION_TRACK_GTIDS
4-- 00000000-1111-0000-1111-000000000000:1
5
6# ALL_GTIDS at startup: this must return GTID:1-2
7DROP TABLE t1;
8-- Tracker : SESSION_TRACK_GTIDS
9-- 00000000-1111-0000-1111-000000000000:1-2
10
11## ALL_GTIDS -> ALL_GTIDS : this must return GTID:1-2 ##
12SET SESSION session_track_gtids='ALL_GTIDS';
13SET SESSION session_track_gtids='ALL_GTIDS';
14-- Tracker : SESSION_TRACK_GTIDS
15-- 00000000-1111-0000-1111-000000000000:1-2
16
17## ALL_GTIDS -> OWN_GTID: this must return GTID:1-2 ##
18SET SESSION session_track_gtids='ALL_GTIDS';
19SET SESSION session_track_gtids='OWN_GTID';
20-- Tracker : SESSION_TRACK_GTIDS
21-- 00000000-1111-0000-1111-000000000000:1-2
22
23## ALL_GTIDS -> OFF : this must return GTID:1-2 ##
24SET SESSION session_track_gtids='ALL_GTIDS';
25SET SESSION session_track_gtids='OFF';
26-- Tracker : SESSION_TRACK_GTIDS
27-- 00000000-1111-0000-1111-000000000000:1-2
28
29## OWN_GTID -> ALL_GTIDS : this must return '' ##
30SET SESSION session_track_gtids='OWN_GTID';
31SET SESSION session_track_gtids='ALL_GTIDS';
32## OWN_GTID -> OWN_GTID: this must return '' ##
33SET SESSION session_track_gtids='OWN_GTID';
34SET SESSION session_track_gtids='OWN_GTID';
35## OWN_GTID -> OFF : this must return '' ##
36SET SESSION session_track_gtids='OWN_GTID';
37SET SESSION session_track_gtids='OFF';
38## OFF -> ALL_GTIDS : this must return '' ##
39SET SESSION session_track_gtids='OFF';
40SET SESSION session_track_gtids='ALL_GTIDS';
41## OFF -> OWN_GTID: this must return '' ##
42SET SESSION session_track_gtids='OFF';
43SET SESSION session_track_gtids='OWN_GTID';
44## OFF -> OFF : this must return '' ##
45SET SESSION session_track_gtids='OFF';
46SET SESSION session_track_gtids='OFF';
47