Debian Codegraph @

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

raw
1 ################################################################################
2 # Tests for special characters used by LOAD DATA.
3 #
4 # It verifies the special characters can be binlogged into
5 # Begin_load_query_log_event correctly.
6 ################################################################################
7 --source include/not_group_replication_plugin.inc
8 --source include/have_binlog_format_statement.inc
9 --source include/master-slave.inc
10
11 #
12 # It is a coverage test for WL#9218 which removed deprecate load data events.
13 #
14 CREATE TABLE t1(c1 INT, c2 INT);
15 CREATE TABLE t2(c1 INT, c2 INT);
16
17 INSERT INTO t1 VALUES(1, 1), (2, 2);
18
19 --let $data_path= `SELECT @@GLOBAL.secure_file_priv`
20
21 --replace_result $data_path DATA_PATH
22 eval SELECT * FROM t1 INTO OUTFILE "$data_path/wl9218.txt"
23 FIELDS TERMINATED BY '\b' ENCLOSED BY '\0'
24 LINES TERMINATED BY '\n\r';
25
26 --replace_result $data_path DATA_PATH
27 eval LOAD DATA INFILE "$data_path/wl9218.txt" INTO TABLE t2
28 FIELDS TERMINATED BY '\b' ENCLOSED BY '\0'
29 LINES TERMINATED BY '\n\r';
30
31 --source include/sync_slave_sql_with_master.inc
32 --let $diff_tables=master:t1, master:t2, slave:t2
33 --source include/diff_tables.inc
34
35 --source include/rpl_connection_master.inc
36 DROP TABLE t1, t2;
37
38 --remove_file "$data_path/wl9218.txt"
39 --source include/rpl_end.inc