From 47e89f208a25652ec93529eb7dc4944ec5a73659 Mon Sep 17 00:00:00 2001
From: "acurtis@xiphis.org" <>
Date: Tue, 9 May 2006 13:31:46 -0700
Subject: bug#10952   "alter table from MyISAM to MERGE lost data without
 errors and warnings"   Add new handlerton flag which prevent user from
 altering table storage   engine to storage engines which would lose data.
 Both 'blackhole' and   'merge' are marked with the new flag.   Tests
 included.

---
 mysql-test/t/merge.test | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'mysql-test/t/merge.test')

diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test
index 060f1ea167b..7ea14a811ed 100644
--- a/mysql-test/t/merge.test
+++ b/mysql-test/t/merge.test
@@ -379,3 +379,15 @@ check table t1, t2;
 drop table t1, t2, t3;
 
 # End of 4.1 tests
+
+#
+# BUG#10952 - alter table ... lost data without errors and warnings
+#
+drop table if exists t1;
+create table t1 (c char(20)) engine=MyISAM;
+insert into t1 values ("Monty"),("WAX"),("Walrus");
+--error 1031
+alter table t1 engine=MERGE;
+drop table t1;
+
+# End of 5.0 tests
-- 
cgit v1.2.1