Debian Codegraph @

mysql-test/suite/binlog_gtid/r/binlog_gtid_mix_ok_packet_all_gtids.result

raw
1 # ALL_GTIDS at startup: this must return GTID:1
2 CREATE 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
7 DROP 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 ##
12 SET SESSION session_track_gtids='ALL_GTIDS';
13 SET 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 ##
18 SET SESSION session_track_gtids='ALL_GTIDS';
19 SET 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 ##
24 SET SESSION session_track_gtids='ALL_GTIDS';
25 SET 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 '' ##
30 SET SESSION session_track_gtids='OWN_GTID';
31 SET SESSION session_track_gtids='ALL_GTIDS';
32 ## OWN_GTID -> OWN_GTID: this must return '' ##
33 SET SESSION session_track_gtids='OWN_GTID';
34 SET SESSION session_track_gtids='OWN_GTID';
35 ## OWN_GTID -> OFF : this must return '' ##
36 SET SESSION session_track_gtids='OWN_GTID';
37 SET SESSION session_track_gtids='OFF';
38 ## OFF -> ALL_GTIDS : this must return '' ##
39 SET SESSION session_track_gtids='OFF';
40 SET SESSION session_track_gtids='ALL_GTIDS';
41 ## OFF -> OWN_GTID: this must return '' ##
42 SET SESSION session_track_gtids='OFF';
43 SET SESSION session_track_gtids='OWN_GTID';
44 ## OFF -> OFF : this must return '' ##
45 SET SESSION session_track_gtids='OFF';
46 SET SESSION session_track_gtids='OFF';
47 RESET MASTER;