Debian Codegraph @

mysql-test/suite/rpl/t/rpl_perfschema_order_by.test

raw
1 # === Purpose ===
2 #
3 # This test verifies that ORDER BY on replication pfs tables returns
4 # the correct data set.
5 #
6 # === Implementation ===
7 #
8 # 1) Setup a multi-source replication topology.
9 # 2) With STS, execute DDLs on both the masters and use SQL ordering
10 # on PFS tables on slave.
11 # 3) Repeat step 2 with Multi-threaded Slave.
12 #
13 # === References ===
14 # Bug #22958077: ORDER BY LAST_SEEN_TRANSACTION RESULTS IN EMPTY SET (OR DEBUG
15 # ASSERTION)
16
17 # Test requires master-info-repository=TABLE, relay-log-info-repository=TABLE
18 --source include/have_slave_repository_type_table.inc
19 --let $rpl_topology= 3->2,1->2
20 --let $rpl_multi_source= 1
21 --let $rpl_skip_start_slave= 1
22 --source include/rpl_init.inc
23
24 --let $rpl_connection_name= server_2
25 --source include/rpl_connection.inc
26 SET @save.replica_parallel_workers= @@global.replica_parallel_workers;
27
28 --echo # Test for Single Threaded Slave
29 SET GLOBAL replica_parallel_workers= 0;
30 START SLAVE;
31 --source extra/rpl_tests/rpl_perfschema_order_by.test
32
33 --echo # Test for Multi Threaded Slave
34 STOP SLAVE;
35 SET GLOBAL replica_parallel_workers = 2;
36 START SLAVE;
37 --source extra/rpl_tests/rpl_perfschema_order_by.test
38
39 #Cleanup
40 STOP SLAVE;
41 --disable_warnings
42 SET @@global.replica_parallel_workers= @save.replica_parallel_workers;
43 --enable_warnings
44 START SLAVE;
45
46 --let $rpl_skip_sync= 1
47 --source include/rpl_end.inc