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