Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 create table t1(a int);
4 select * into outfile 'MYSQLD_DATADIR/rpl_loaddatalocal.select_outfile' from t1;
5 truncate table t1;
6 load data local infile 'MYSQLD_DATADIR/rpl_loaddatalocal.select_outfile' into table t1;
7 connection slave;
8 select a,count(*) from t1 group by a;
9 a count(*)
10 1 10000
11 connection master;
12 drop table t1;
13 connection slave;
14 connection master;
15 create table t1(a int);
16 insert into t1 values (1), (2), (2), (3);
17 select * into outfile 'MYSQLD_DATADIR/rpl_loaddatalocal.select_outfile' from t1;
18 drop table t1;
19 create table t1(a int primary key);
20 load data local infile 'MYSQLD_DATADIR/rpl_loaddatalocal.select_outfile' into table t1;
21 Warnings:
22 Warning 1062 Duplicate entry '2' for key 'PRIMARY'
23 SELECT * FROM t1 ORDER BY a;
24 a
25 1
26 2
27 3
28 connection slave;
29 SELECT * FROM t1 ORDER BY a;
30 a
31 1
32 2
33 3
34 connection master;
35 drop table t1;
36 connection slave;
37 ==== Bug22504 Initialize ====
38 connection master;
39 SET sql_mode='ignore_space';
40 CREATE TABLE t1(a int);
41 insert into t1 values (1), (2), (3), (4);
42 select * into outfile 'MYSQLD_DATADIR/rpl_loaddatalocal.select_outfile' from t1;
43 truncate table t1;
44 load data local infile 'MYSQLD_DATADIR/rpl_loaddatalocal.select_outfile' into table t1;
45 SELECT * FROM t1 ORDER BY a;
46 a
47 1
48 2
49 3
50 4
51 connection slave;
52 SELECT * FROM t1 ORDER BY a;
53 a
54 1
55 2
56 3
57 4
58 ==== Clean up ====
59 connection master;
60 DROP TABLE t1;
61 connection slave;
62
63 Bug #43746:
64 "return wrong query string when parse 'load data infile' sql statement"
65
66 connection master;
67 SELECT @@SESSION.sql_mode INTO @old_mode;
68 SET sql_mode='ignore_space';
69 CREATE TABLE t1(a int);
70 INSERT INTO t1 VALUES (1), (2), (3), (4);
71 SELECT * INTO OUTFILE 'MYSQLD_DATADIR/bug43746.sql' FROM t1;
72 TRUNCATE TABLE t1;
73 LOAD DATA LOCAL INFILE 'MYSQLD_DATADIR/bug43746.sql' INTO TABLE t1;
74 LOAD/* look mum, with comments in weird places! */DATA/* oh hai */LOCAL INFILE 'MYSQLD_DATADIR/bug43746.sql'/* we are */INTO/* from the internets */TABLE t1;
75 LOAD DATA/*!10000 LOCAL */INFILE 'MYSQLD_DATADIR/bug43746.sql' INTO TABLE t1;
76 LOAD DATA LOCAL INFILE 'MYSQLD_DATADIR/bug43746.sql' /*!10000 INTO */ TABLE t1;
77 LOAD DATA LOCAL INFILE 'MYSQLD_DATADIR/bug43746.sql' /*!10000 INTO TABLE */ t1;
78 LOAD DATA /*!10000 LOCAL INFILE 'MYSQLD_DATADIR/bug43746.sql' INTO TABLE */ t1;
79 LOAD DATA/*!10000 LOCAL */INFILE 'MYSQLD_DATADIR/bug43746.sql'/*!10000 INTO*/TABLE t1;
80 LOAD DATA/*!10000 LOCAL */INFILE 'MYSQLD_DATADIR/bug43746.sql'/* empty */INTO TABLE t1;
81 LOAD DATA/*!10000 LOCAL */INFILE 'MYSQLD_DATADIR/bug43746.sql' INTO/* empty */TABLE t1;
82 LOAD/*!999999 special comments that do not expand */DATA/*!999999 code from the future */LOCAL INFILE 'MYSQLD_DATADIR/bug43746.sql'/*!999999 have flux capacitor */INTO/*!999999 will travel */TABLE t1;
83 SET sql_mode='PIPES_AS_CONCAT,ANSI_QUOTES,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER';
84 LOAD DATA LOCAL INFILE 'MYSQLD_DATADIR/bug43746.sql' INTO TABLE t1;
85 connection slave;
86
87 Bug #59267:
88 "LOAD DATA LOCAL INFILE not executed on slave with SBR"
89
90 connection master;
91 SELECT * INTO OUTFILE 'MYSQLD_DATADIR/bug59267.sql' FROM t1;
92 TRUNCATE TABLE t1;
93 LOAD DATA LOCAL INFILE 'MYSQLD_DATADIR/bug59267.sql' INTO TABLE t1;
94 SELECT 'Master', COUNT(*) FROM t1;
95 Master COUNT(*)
96 Master 44
97 connection slave;
98 SELECT 'Slave', COUNT(*) FROM t1;
99 Slave COUNT(*)
100 Slave 44
101 connection master;
102 DROP TABLE t1;
103 SET SESSION sql_mode=@old_mode;
104 connection slave;
105 connection master;
106
107 Bug #60580/#11902767:
108 "statement improperly replicated crashes slave sql thread"
109
110 connection master;
111 CREATE TABLE t1(f1 INT, f2 INT);
112 CREATE TABLE t2(f1 INT, f2 TIMESTAMP);
113 INSERT INTO t2 VALUES(1, '2011-03-22 21:01:28');
114 INSERT INTO t2 VALUES(2, '2011-03-21 21:01:28');
115 INSERT INTO t2 VALUES(3, '2011-03-20 21:01:28');
116 CREATE TABLE t3 AS SELECT * FROM t2;
117 CREATE VIEW v1 AS SELECT * FROM t2
118 WHERE f1 IN (SELECT f1 FROM t3 WHERE (t3.f2 IS NULL));
119 SELECT 1 INTO OUTFILE 'MYSQLD_DATADIR/bug60580.csv' FROM DUAL;
120 LOAD DATA LOCAL INFILE 'MYSQLD_DATADIR/bug60580.csv' INTO TABLE t1 (@f1) SET f2 = (SELECT f1 FROM v1 WHERE f1=@f1);
121 SELECT * FROM t1;
122 f1 f2
123 NULL NULL
124 connection slave;
125 SELECT * FROM t1;
126 f1 f2
127 NULL NULL
128 connection master;
129 DROP VIEW v1;
130 DROP TABLE t1, t2, t3;
131 connection slave;
132 connection master;
133 include/rpl_end.inc
134 # End of 5.1 tests