Debian Codegraph @

mysql-test/suite/rpl/r/rpl_system_versioning_partitions.result

raw
1 include/master-slave.inc
2 [connection master]
3 #
4 # Initialize system-versioned and partitioned table and its data
5 connection master;
6 SET timestamp=UNIX_TIMESTAMP('2025-01-01 01:00:00.000000');
7 RESET MASTER;
8 create table t1 (x int) engine=InnoDB with system versioning partition by system_time limit 3 partitions 5;
9 insert into t1 values(1);
10 insert into t1 values(2);
11 insert into t1 values(3);
12 insert into t1 values(4);
13 insert into t1 values(5);
14 # Verifying master partitions are correct after data insertion..
15 # .. done
16 connection slave;
17 connection slave;
18 # Verifying partitions of master and slave match on data setup..
19 # .. done
20 #
21 # "Delete" each row -- these are the BINLOG commands generated by
22 # mysqlbinlog from `delete from t1 where x=<n>` statments. Because the
23 # table uses system versioning and system_time partition, the actual
24 # events are updates, with added fields for the `row_start` and `row_end`
25 # columns.
26 connection master;
27 # BINLOG for Format Description event
28 BINLOG '
29 APZ0Zw8BAAAA/AAAAAABAAAAAAQAMTEuNy4yLU1hcmlhREItZGVidWctbG9nAAAAAAAAAAAAAAAA
30 AAAAAAAAAAAAAAAAAAAA9nRnEzgNAAgAEgAEBAQEEgAA5AAEGggAAAAICAgCAAAACgoKAAAAAAAA
31 CgoKAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
32 AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
33 AAAAAAAAAAAEEwQADQgICAoKCgGuUmo6
34 ';
35 # BINLOG for delete from t1 where x=1;
36 BINLOG '
37 APZ0ZxMBAAAAMQAAAAAAAAAAACEAAAAAAAEABHRlc3QAAnQxAAMDERECBgYBoCHyJQ==
38 APZ0ZxgBAAAASAAAAAAAAAAAACEAAAAAAAEAAwcH+AEAAABndPYAAAAA/////w9CP/gBAAAAZ3T2
39 AAAAAGd09gAAAAAuqwNP
40 ';
41 # BINLOG for delete from t1 where x=2;
42 BINLOG '
43 APZ0ZxMBAAAAMQAAAAAAAAAAACEAAAAAAAEABHRlc3QAAnQxAAMDERECBgYBoCHyJQ==
44 APZ0ZxgBAAAASAAAAAAAAAAAACEAAAAAAAEAAwcH+AIAAABndPYAAAAA/////w9CP/gCAAAAZ3T2
45 AAAAAGd09gAAAAAsSeT/
46 ';
47 # BINLOG for delete from t1 where x=3;
48 BINLOG '
49 APZ0ZxMBAAAAMQAAAAAAAAAAACEAAAAAAAEABHRlc3QAAnQxAAMDERECBgYBoCHyJQ==
50 APZ0ZxgBAAAASAAAAAAAAAAAACEAAAAAAAEAAwcH+AMAAABndPYAAAAA/////w9CP/gDAAAAZ3T2
51 AAAAAGd09gAAAADS6EaQ
52 ';
53 # BINLOG for delete from t1 where x=4;
54 BINLOG '
55 APZ0ZxMBAAAAMQAAAAAAAAAAACEAAAAAAAEABHRlc3QAAnQxAAMDERECBgYBoCHyJQ==
56 APZ0ZxgBAAAASAAAAAAAAAAAACEAAAAAAAEAAwcH+AQAAABndPYAAAAA/////w9CP/gEAAAAZ3T2
57 AAAAAGd09gAAAABpi1pF
58 ';
59 # BINLOG for delete from t1 where x=5;
60 BINLOG '
61 APZ0ZxMBAAAAMQAAAAAAAAAAACEAAAAAAAEABHRlc3QAAnQxAAMDERECBgYBoCHyJQ==
62 APZ0ZxgBAAAASAAAAAAAAAAAACEAAAAAAAEAAwcH+AUAAABndPYAAAAA/////w9CP/gFAAAAZ3T2
63 AAAAAGd09gAAAACXKvgq
64 ';
65 # Verifying master partitions are correct after deletion BINLOG stmts..
66 # .. done
67 connection slave;
68 connection slave;
69 connection master;
70 drop table t1;
71 include/rpl_end.inc