Debian Codegraph @

mysql-test/suite/rpl_nogtid/t/rpl_parallel_load_data.test

raw
1 #
2 # Bug#12982188 MTS: SBR ABORTS WITH ERROR 1742 ON LOAD DATA WITH TRIGGER MYISAM TO INNODB
3 #
4
5 --source include/set_privilege_checks_user_as_system_user.inc
6 --source include/master-slave.inc
7 --source include/have_binlog_format_statement.inc
8 --source include/force_myisam_default.inc
9 --source include/have_myisam.inc
10
11 let $max_workers= 4;
12
13 --write_file $MYSQLTEST_VARDIR/load_bug12982188.txt
14 1
15 2
16 3
17 4
18 5
19 6
20 7
21 8
22 9
23 10
24 EOF
25
26 --connection slave
27 --source include/stop_slave.inc
28 SET @save_replica_parallel_workers= @@replica_parallel_workers;
29 eval SET @@global.replica_parallel_workers=$max_workers;
30 --source include/start_slave.inc
31
32 --connection master
33 --disable_warnings
34 DROP DATABASE IF EXISTS db1;
35 DROP DATABASE IF EXISTS db2;
36 --enable_warnings
37 CREATE DATABASE db1;
38 CREATE DATABASE db2;
39 CREATE TABLE db1.tb1 (f1 int) ENGINE=MyISAM;
40 CREATE TABLE db2.tb2 (f1 int) ENGINE=InnoDB;
41 CREATE TRIGGER db1.tr AFTER INSERT ON tb1 FOR EACH ROW INSERT INTO db2.tb2
42 (f1) VALUES (new.f1);
43 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
44 eval LOAD DATA LOCAL INFILE '$MYSQLTEST_VARDIR/load_bug12982188.txt' INTO TABLE db1.tb1;
45 --sync_slave_with_master
46 SELECT COUNT(*) FROM db2.tb2;
47
48 # cleanup
49 --connection master
50 DROP DATABASE db1;
51 DROP DATABASE db2;
52 --remove_file $MYSQLTEST_VARDIR/load_bug12982188.txt
53
54 --sync_slave_with_master
55 --disable_warnings
56 SET @@global.replica_parallel_workers= @save_replica_parallel_workers;
57 --enable_warnings
58
59 --source include/rpl_end.inc