diff options
| author | acurtis@xiphis.org <> | 2006-05-09 13:31:46 -0700 |
|---|---|---|
| committer | acurtis@xiphis.org <> | 2006-05-09 13:31:46 -0700 |
| commit | 47e89f208a25652ec93529eb7dc4944ec5a73659 (patch) | |
| tree | 1fed1caed61ab2e91c6c91ac94cad060494a7492 /mysql-test/t/merge.test | |
| parent | ec4211923320e398b3ebdef4fdde7f55fe93dd55 (diff) | |
| download | mariadb-git-47e89f208a25652ec93529eb7dc4944ec5a73659.tar.gz | |
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.
Diffstat (limited to 'mysql-test/t/merge.test')
| -rw-r--r-- | mysql-test/t/merge.test | 12 |
1 files changed, 12 insertions, 0 deletions
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 |