summaryrefslogtreecommitdiff
path: root/mysql-test/r/merge.result
diff options
context:
space:
mode:
authorunknown <svoj@april.(none)>2006-09-27 18:58:23 +0500
committerunknown <svoj@april.(none)>2006-09-27 18:58:23 +0500
commitd119810cca8bdddc9ed7bef17c2742f6bf512f23 (patch)
treee80bfc86692affe997adce61f718b7b13026f001 /mysql-test/r/merge.result
parentffa4a1e05ae6ecb2951bfdd117bf6df404834f7c (diff)
parentd6d1176eed9f249107410bc981f931dac81757ca (diff)
downloadmariadb-git-d119810cca8bdddc9ed7bef17c2742f6bf512f23.tar.gz
Merge mysql.com:/home/svoj/devel/mysql/merge/mysql-5.0-engines
into mysql.com:/home/svoj/devel/mysql/merge/mysql-5.1-engines mysql-test/r/repair.result: Auto merged mysql-test/t/merge.test: Auto merged sql/table.cc: Auto merged storage/myisammrg/myrg_open.c: Auto merged mysql-test/r/merge.result: Manual merge. sql/share/errmsg.txt: Manual merge.
Diffstat (limited to 'mysql-test/r/merge.result')
-rw-r--r--mysql-test/r/merge.result15
1 files changed, 12 insertions, 3 deletions
diff --git a/mysql-test/r/merge.result b/mysql-test/r/merge.result
index db2c462398f..6e2da3126cd 100644
--- a/mysql-test/r/merge.result
+++ b/mysql-test/r/merge.result
@@ -178,12 +178,12 @@ t3 CREATE TABLE `t3` (
) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 UNION=(`t1`,`t2`)
create table t4 (a int not null, b char(10), key(a)) engine=MERGE UNION=(t1,t2);
select * from t4;
-ERROR HY000: All tables in the MERGE table are not identically defined
+ERROR HY000: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exists
alter table t4 add column c int;
-ERROR HY000: All tables in the MERGE table are not identically defined
+ERROR HY000: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exists
flush tables;
select * from t4;
-ERROR HY000: All tables in the MERGE table are not identically defined
+ERROR HY000: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exists
create database mysqltest;
create table mysqltest.t6 (a int not null primary key auto_increment, message char(20));
create table t5 (a int not null, b char(20), key(a)) engine=MERGE UNION=(test.t1,mysqltest.t6);
@@ -771,6 +771,15 @@ Table Op Msg_type Msg_text
test.t1 check status OK
test.t2 check status OK
drop table t1, t2, t3;
+CREATE TABLE t1(a INT) ENGINE=MEMORY;
+CREATE TABLE t2(a INT) ENGINE=MERGE UNION=(t1);
+SELECT * FROM t2;
+ERROR HY000: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exists
+DROP TABLE t1, t2;
+CREATE TABLE t2(a INT) ENGINE=MERGE UNION=(t3);
+SELECT * FROM t2;
+ERROR HY000: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exists
+DROP TABLE t2;
create table t1 (b bit(1));
create table t2 (b bit(1));
create table tm (b bit(1)) engine = merge union = (t1,t2);