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/r/merge.result | |
| 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/r/merge.result')
| -rw-r--r-- | mysql-test/r/merge.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/merge.result b/mysql-test/r/merge.result index 58e1f86b3f9..9a34d6fba58 100644 --- a/mysql-test/r/merge.result +++ b/mysql-test/r/merge.result @@ -768,3 +768,11 @@ Table Op Msg_type Msg_text test.t1 check status OK test.t2 check status OK drop table t1, t2, t3; +drop table if exists t1; +Warnings: +Note 1051 Unknown table 't1' +create table t1 (c char(20)) engine=MyISAM; +insert into t1 values ("Monty"),("WAX"),("Walrus"); +alter table t1 engine=MERGE; +ERROR HY000: Table storage engine for 't1' doesn't have this option +drop table t1; |