DROP TABLE IF EXISTS t1,t2,t3, t4;
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;
INSERT INTO t1 SET f1 = 1.175494345e-15, mysql_version = VERSION();
INSERT INTO t2 SET f1 = 1.175494345e-15, mysql_version = VERSION();
SELECT pk, f1, mysql_version FROM t1;
pk	f1	mysql_version
1	1.175494345e-15	4.1.16-debug-log
SELECT pk, f1, mysql_version FROM t2;
pk	f1	mysql_version
1	1.175494345e-15	4.1.16-debug-log
SELECT f1, pk, mysql_version  FROM t1 WHERE f1 = 1.175494345e-15;
f1	pk	mysql_version
1.175494345e-15	1	4.1.16-debug-log
SELECT f1, pk, mysql_version  FROM t2 WHERE f1 = 1.175494345e-15;
f1	pk	mysql_version
1.175494345e-15	1	4.1.16-debug-log
SELECT A.f1, A.pk, A.mysql_version, B.pk, B.mysql_version
FROM t1 A,t2 B WHERE A.f1 = B.f1;
f1	pk	mysql_version	pk	mysql_version
1.175494345e-15	1	4.1.16-debug-log	1	4.1.16-debug-log