From 1af69fca943181b4eb0501bb2113ff2b9ec4fc69 Mon Sep 17 00:00:00 2001 From: "ingo@mysql.com" <> Date: Thu, 29 Sep 2005 13:37:30 +0200 Subject: Bug#9112 - Merge table with composite index producing invalid results with some queries Second platform fix for floating point rounding. --- mysql-test/r/merge.result | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'mysql-test/r/merge.result') diff --git a/mysql-test/r/merge.result b/mysql-test/r/merge.result index d00423ea4bf..ffb715e3903 100644 --- a/mysql-test/r/merge.result +++ b/mysql-test/r/merge.result @@ -635,13 +635,13 @@ b varchar(10), index (a,b) ) engine=myisam; insert into t2 values ( null, ''); -insert into t2 values ( 9999999999.9999, ''); +insert into t2 values ( 9999999999.999, ''); insert into t3 select * from t2; select min(a), max(a) from t1; min(a) max(a) -9999999999.9999 9999999999.9999 +9999999999.9990 9999999999.9990 flush tables; select min(a), max(a) from t1; min(a) max(a) -9999999999.9999 9999999999.9999 +9999999999.9990 9999999999.9990 drop table t1, t2, t3; -- cgit v1.2.1