diff options
| author | Sergey Vojtovich <svoj@mysql.com> | 2009-02-04 17:00:40 +0400 |
|---|---|---|
| committer | Sergey Vojtovich <svoj@mysql.com> | 2009-02-04 17:00:40 +0400 |
| commit | aa13a4b95ef7cc5fbc656b3a05807596f8eb06bd (patch) | |
| tree | 0fcd4cc22c791faeee761dc99ebffd2456455ca9 /mysql-test/r/merge.result | |
| parent | 7957622bfde87af5bbe880bb53c9544c5578be38 (diff) | |
| parent | 97bd763544bbaf882a083b1952b47901bc9a335b (diff) | |
| download | mariadb-git-aa13a4b95ef7cc5fbc656b3a05807596f8eb06bd.tar.gz | |
Merge 5.0-bugteam -> 5.1-bugteam.
Diffstat (limited to 'mysql-test/r/merge.result')
| -rw-r--r-- | mysql-test/r/merge.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/merge.result b/mysql-test/r/merge.result index cc05efded02..9ab982a6688 100644 --- a/mysql-test/r/merge.result +++ b/mysql-test/r/merge.result @@ -988,6 +988,17 @@ m1 CREATE TABLE `m1` ( `a` int(11) DEFAULT NULL ) ENGINE=MRG_MyISAM DEFAULT CHARSET=latin1 DROP TABLE t1, m1; +CREATE TABLE t1(a INT); +CREATE TABLE t2(a VARCHAR(10)); +CREATE TABLE m1(a INT) ENGINE=MERGE UNION=(t1, t2); +CREATE TABLE m2(a INT) ENGINE=MERGE UNION=(t1); +SELECT * FROM t1; +a +SELECT * FROM m1; +ERROR HY000: Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist +SELECT * FROM m2; +a +DROP TABLE t1, t2, m1, m2; End of 5.0 tests create table t1 (c1 int, index(c1)); create table t2 (c1 int, index(c1)) engine=merge union=(t1); |