--disable_abort_on_errror
# let $FLOAT_VAL= 1.175494345e-38;
# good let $FLOAT_VAL= 1.175494345e-14;
# bad let $FLOAT_VAL= 1.175494345e-15;
let $FLOAT_VAL= 1.175494345e-15;

##### Basic preparations
--disable_warnings
DROP TABLE IF EXISTS t1,t2,t3, t4;
--enable_warnings

CREATE TABLE t1 (f1 DOUBLE, mysql_version VARCHAR(20));
ALTER TABLE t1 ADD pk BIGINT AUTO_INCREMENT, ADD PRIMARY KEY (pk) ;
CREATE TABLE t2 LIKE t1;
eval INSERT INTO t1 SET f1 = $FLOAT_VAL, mysql_version = VERSION();
eval INSERT INTO t2 SET f1 = $FLOAT_VAL, mysql_version = VERSION();

##### The test
SELECT pk, f1, mysql_version FROM t1;
SELECT pk, f1, mysql_version FROM t2;

# Select via WHERE f1 = <constant>
eval SELECT f1, pk, mysql_version  FROM t1 WHERE f1 = $FLOAT_VAL;
eval SELECT f1, pk, mysql_version  FROM t2 WHERE f1 = $FLOAT_VAL;

# Join in "Universe created with 4.1 history"
SELECT A.f1, A.pk, A.mysql_version, B.pk, B.mysql_version
FROM t1 A,t2 B WHERE A.f1 = B.f1;