diff options
| author | unknown <monty@mashka.mysql.fi> | 2003-07-01 15:49:32 +0300 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2003-07-01 15:49:32 +0300 |
| commit | 14c8a0e536b6326a4ba759ba30377e8a9654b513 (patch) | |
| tree | bae354dc2e20ca3c0b40b1b4c4625e5c52d4ea00 /mysql-test/r/merge.result | |
| parent | 48272222a7e4013073f51825f996b2c979f29b6a (diff) | |
| download | mariadb-git-14c8a0e536b6326a4ba759ba30377e8a9654b513.tar.gz | |
Fix needed to support MERGE tables in different databases
mysql-test/r/merge.result:
Test of MERGE table patch
mysql-test/t/merge.test:
Test of MERGE table patch
Diffstat (limited to 'mysql-test/r/merge.result')
| -rw-r--r-- | mysql-test/r/merge.result | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/mysql-test/r/merge.result b/mysql-test/r/merge.result index f970aafe516..413277fee43 100644 --- a/mysql-test/r/merge.result +++ b/mysql-test/r/merge.result @@ -194,7 +194,7 @@ t5 CREATE TABLE `t5` ( alter table t5 type=myisam; drop table t5, mysqltest.t6; drop database mysqltest; -drop table if exists t4,t3,t1,t2; +drop table t4,t3,t1,t2; create table t1 (c char(10)) type=myisam; create table t2 (c char(10)) type=myisam; create table t3 (c char(10)) union=(t1,t2) type=merge; @@ -540,7 +540,11 @@ a b 6 1 6 2 6 3 -drop table if exists t6, t5, t4, t3, t2, t1; +insert into t1 values (99,NULL); +select * from t4 where a+0 > 90; +a b +99 1 +drop table t6, t5, t4, t3, t2, t1; CREATE TABLE t1 ( a int(11) NOT NULL default '0', b int(11) NOT NULL default '0', PRIMARY KEY (a,b)) TYPE=MyISAM; INSERT INTO t1 VALUES (1,1), (2,1); CREATE TABLE t2 ( a int(11) NOT NULL default '0', b int(11) NOT NULL default '0', PRIMARY KEY (a,b)) TYPE=MyISAM; @@ -552,7 +556,7 @@ max(b) select max(b) from t1 where a = 2; max(b) 1 -drop table if exists t3,t1,t2; +drop table t3,t1,t2; create table t1 (a int not null); create table t2 (a int not null); insert into t1 values (1); @@ -571,7 +575,7 @@ select * from t6; a 1 2 -drop table if exists t6, t3, t1, t2, t4, t5; +drop table t6, t3, t1, t2, t4, t5; CREATE TABLE t1 ( fileset_id tinyint(3) unsigned NOT NULL default '0', file_code varchar(32) NOT NULL default '', |