diff options
| author | unknown <ingo@mysql.com> | 2005-09-29 13:37:30 +0200 |
|---|---|---|
| committer | unknown <ingo@mysql.com> | 2005-09-29 13:37:30 +0200 |
| commit | a671075d3e11a30a117a919a7b9b32de08e0265a (patch) | |
| tree | 58b3d86bd50a7f40cac68a0c216a642c5eb78987 /mysql-test | |
| parent | 629697e59406aa32e7e43371e767269ff98e6161 (diff) | |
| download | mariadb-git-a671075d3e11a30a117a919a7b9b32de08e0265a.tar.gz | |
Bug#9112 - Merge table with composite index producing invalid results with some queries
Second platform fix for floating point rounding.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/merge.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/merge.test | 2 |
2 files changed, 4 insertions, 4 deletions
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; diff --git a/mysql-test/t/merge.test b/mysql-test/t/merge.test index 429013af56f..a3e3d487c67 100644 --- a/mysql-test/t/merge.test +++ b/mysql-test/t/merge.test @@ -291,7 +291,7 @@ create table t3 ( ) 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; flush tables; |