diff options
| author | unknown <mskold/marty@mysql.com/linux.site> | 2006-09-12 16:04:52 +0200 |
|---|---|---|
| committer | unknown <mskold/marty@mysql.com/linux.site> | 2006-09-12 16:04:52 +0200 |
| commit | c9b9209fb4a4ba8590b614924fc02c58410c7901 (patch) | |
| tree | 209b269b51bd055a553842f00920ae16bb0e6e5c /mysql-test/r/ndb_multi.result | |
| parent | 43dd7c7b4c52a97c44e86f330d3ccf5d1fb3f874 (diff) | |
| download | mariadb-git-c9b9209fb4a4ba8590b614924fc02c58410c7901.tar.gz | |
Bug #21378 Alter table from X storage engine to NDB could cause data loss: Added warning if local table shadows ndb table
Diffstat (limited to 'mysql-test/r/ndb_multi.result')
| -rw-r--r-- | mysql-test/r/ndb_multi.result | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_multi.result b/mysql-test/r/ndb_multi.result index bd3af223a65..068d86b83e2 100644 --- a/mysql-test/r/ndb_multi.result +++ b/mysql-test/r/ndb_multi.result @@ -69,3 +69,35 @@ t3 t4 drop table t1, t2, t3, t4; drop table t1, t3, t4; +create table t1(c1 int key)ENGINE=MyISAM; +insert into t1 values(1),(3),(5); +select * from t1 order by c1; +c1 +1 +3 +5 +create table t1(c1 int key)ENGINE=MyISAM; +insert into t1 values(100),(344),(533); +select * from t1 order by c1; +c1 +100 +344 +533 +alter table t1 engine=ndb; +show tables; +Tables_in_test +t1 +Warnings: +Warning 1050 Local table t1 shadows cluster table +select * from t1 order by c1; +c1 +100 +344 +533 +drop table t1; +select * from t1 order by c1; +c1 +1 +3 +5 +drop table t1; |