diff options
author | unknown <ingo@mysql.com> | 2005-09-28 14:10:02 +0200 |
---|---|---|
committer | unknown <ingo@mysql.com> | 2005-09-28 14:10:02 +0200 |
commit | 4ac453e50a8717ca57da600ad5e30aaba0b05e43 (patch) | |
tree | 91d9b9d82ff3c139956a9f057d9cc04d99a52ec9 /mysql-test/r/merge.result | |
parent | ada963e01209a6dc8778010e114944f2438462e9 (diff) | |
parent | e4074a675320399164275e90535d9b03cd5ecedc (diff) | |
download | mariadb-git-4ac453e50a8717ca57da600ad5e30aaba0b05e43.tar.gz |
Merge mysql.com:/home/mydev/mysql-4.1-4100
into mysql.com:/home/mydev/mysql-5.0-5000
mysql-test/r/merge.result:
Auto merged
mysql-test/t/merge.test:
Auto merged
Diffstat (limited to 'mysql-test/r/merge.result')
-rw-r--r-- | mysql-test/r/merge.result | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/merge.result b/mysql-test/r/merge.result index 4ddc1fdab12..f209ff8bd31 100644 --- a/mysql-test/r/merge.result +++ b/mysql-test/r/merge.result @@ -654,30 +654,30 @@ create table t3 engine=merge union=(t1, t2) select (select max(a) from t2); ERROR HY000: You can't specify target table 't2' for update in FROM clause drop table t1, t2; create table t1 ( -a double(16,6), +a double(14,4), b varchar(10), index (a,b) ) engine=merge union=(t2,t3); create table t2 ( -a double(16,6), +a double(14,4), b varchar(10), index (a,b) ) engine=myisam; create table t3 ( -a double(16,6), +a double(14,4), b varchar(10), index (a,b) ) engine=myisam; insert into t2 values ( null, ''); -insert into t2 values ( 9999999999.999999, ''); +insert into t2 values ( 9999999999.9999, ''); insert into t3 select * from t2; select min(a), max(a) from t1; min(a) max(a) -9999999999.999998 9999999999.999998 +9999999999.9999 9999999999.9999 flush tables; select min(a), max(a) from t1; min(a) max(a) -9999999999.999998 9999999999.999998 +9999999999.9999 9999999999.9999 drop table t1, t2, t3; create table t1 (a int,b int,c int, index (a,b,c)); create table t2 (a int,b int,c int, index (a,b,c)); |