diff options
| author | Tatjana Azundris Nuernberg <tatjana.nuernberg@oracle.com> | 2011-05-12 06:23:16 +0100 |
|---|---|---|
| committer | Tatjana Azundris Nuernberg <tatjana.nuernberg@oracle.com> | 2011-05-12 06:23:16 +0100 |
| commit | c2257fc5832bd3dea8679602338464be810a1a22 (patch) | |
| tree | 6eb210de7d9cd368a1d703374ca95d93f828ed93 /mysql-test/suite/rpl/r | |
| parent | 99a8398f42270ac106b8b7893b76deb0603d2b70 (diff) | |
| parent | 5047a6382c59370b27b66d63c1bb432cd5de743e (diff) | |
| download | mariadb-git-c2257fc5832bd3dea8679602338464be810a1a22.tar.gz | |
auto-merge
Diffstat (limited to 'mysql-test/suite/rpl/r')
| -rw-r--r-- | mysql-test/suite/rpl/r/rpl_loaddatalocal.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_loaddatalocal.result b/mysql-test/suite/rpl/r/rpl_loaddatalocal.result index 2fd9dc6294e..902bc1cda00 100644 --- a/mysql-test/suite/rpl/r/rpl_loaddatalocal.result +++ b/mysql-test/suite/rpl/r/rpl_loaddatalocal.result @@ -93,4 +93,31 @@ Slave 44 DROP TABLE t1; SET SESSION sql_mode=@old_mode; [slave] + +Bug #60580/#11902767: +"statement improperly replicated crashes slave sql thread" + +[master] +CREATE TABLE t1(f1 INT, f2 INT); +CREATE TABLE t2(f1 INT, f2 TIMESTAMP); +INSERT INTO t2 VALUES(1, '2011-03-22 21:01:28'); +INSERT INTO t2 VALUES(2, '2011-03-21 21:01:28'); +INSERT INTO t2 VALUES(3, '2011-03-20 21:01:28'); +CREATE TABLE t3 AS SELECT * FROM t2; +CREATE VIEW v1 AS SELECT * FROM t2 +WHERE f1 IN (SELECT f1 FROM t3 WHERE (t3.f2 IS NULL)); +SELECT 1 INTO OUTFILE 'MYSQLD_DATADIR/bug60580.csv' FROM DUAL; +LOAD DATA LOCAL INFILE 'MYSQLD_DATADIR/bug60580.csv' INTO TABLE t1 (@f1) SET f2 = (SELECT f1 FROM v1 WHERE f1=@f1); +SELECT * FROM t1; +f1 f2 +NULL NULL +[slave] +SELECT * FROM t1; +f1 f2 +NULL NULL +[master] +DROP VIEW v1; +DROP TABLE t1, t2, t3; +[slave] include/rpl_end.inc +# End of 5.1 tests |