Debian Codegraph @

mysql-test/suite/engines/funcs/r/rpl_loaddata_m.result

raw
1 include/master-slave.inc
2 [connection master]
3 drop database if exists mysqltest;
4 connection master;
5 USE test;
6 CREATE TABLE t1(a INT, b INT, UNIQUE(b));
7 LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE test.t1;
8 SELECT COUNT(*) FROM test.t1;
9 COUNT(*)
10 2
11 CREATE DATABASE mysqltest;
12 USE mysqltest;
13 CREATE TABLE t1(a INT, b INT, UNIQUE(b));
14 LOAD DATA INFILE '../../std_data/rpl_loaddata.dat' INTO TABLE mysqltest.t1;
15 SELECT COUNT(*) FROM mysqltest.t1;
16 COUNT(*)
17 2
18 connection slave;
19 SHOW DATABASES;
20 Database
21 information_schema
22 mtr
23 mysql
24 mysqltest
25 performance_schema
26 sys
27 test
28 USE test;
29 SHOW TABLES;
30 Tables_in_test
31 USE mysqltest;
32 SHOW TABLES;
33 Tables_in_mysqltest
34 t1
35 SELECT COUNT(*) FROM mysqltest.t1;
36 COUNT(*)
37 2
38 connection master;
39 DROP DATABASE mysqltest;
40 DROP TABLE IF EXISTS test.t1;
41 connection slave;
42 include/rpl_end.inc