summaryrefslogtreecommitdiff
path: root/mysql-test/suite/maria/t
diff options
context:
space:
mode:
authorMichael Widenius <monty@askmonty.org>2011-12-14 20:36:51 +0200
committerMichael Widenius <monty@askmonty.org>2011-12-14 20:36:51 +0200
commit2f8de7d2a89eb3c4512eb049de7ff04e3ae73991 (patch)
tree6153b86559951f222470de87b1c387bcde6fbcda /mysql-test/suite/maria/t
parent933a4ece46ddbb199062827a34354ceb4f69f235 (diff)
parent0bb7d6e865d92c20fda46784a7d53ae766ec7054 (diff)
downloadmariadb-git-2f8de7d2a89eb3c4512eb049de7ff04e3ae73991.tar.gz
Merge with 5.2
Diffstat (limited to 'mysql-test/suite/maria/t')
-rw-r--r--mysql-test/suite/maria/t/maria-recovery3.test18
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/t/maria-recovery3.test b/mysql-test/suite/maria/t/maria-recovery3.test
index 192361633ca..c8333a66f30 100644
--- a/mysql-test/suite/maria/t/maria-recovery3.test
+++ b/mysql-test/suite/maria/t/maria-recovery3.test
@@ -109,6 +109,24 @@ truncate table t1;
check table t1 extended;
drop table t1;
+#
+# Test for BUG#887051; Failure in recovery with delete
+#
+
+let $mvr_restore_old_snapshot=0;
+let $mms_compare_physically=0;
+let $mvr_debug_option="+d,maria_flush_whole_log,maria_crash";
+let $mvr_crash_statement= set global aria_checkpoint_interval=1;
+CREATE TABLE t1 ( word VARCHAR(255) PRIMARY KEY ) ENGINE=Aria;
+LOAD DATA INFILE '../../std_data/bug887051.txt' INTO TABLE t1;
+SET AUTOCOMMIT=0;
+DELETE FROM t1;
+LOAD DATA INFILE '../../std_data/bug887051.txt' INTO TABLE t1 IGNORE 1 LINES;
+COMMIT;
+-- source include/maria_verify_recovery.inc
+select * from t1;
+drop table t1;
+
# clean up everything
let $mms_purpose=feeding_recovery;
eval drop database mysqltest_for_$mms_purpose;