summaryrefslogtreecommitdiff
path: root/mysql-test/r/merge.result
diff options
context:
space:
mode:
authorunknown <ingo@mysql.com>2005-09-28 14:10:02 +0200
committerunknown <ingo@mysql.com>2005-09-28 14:10:02 +0200
commit4ac453e50a8717ca57da600ad5e30aaba0b05e43 (patch)
tree91d9b9d82ff3c139956a9f057d9cc04d99a52ec9 /mysql-test/r/merge.result
parentada963e01209a6dc8778010e114944f2438462e9 (diff)
parente4074a675320399164275e90535d9b03cd5ecedc (diff)
downloadmariadb-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.result12
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));