The incorrect result of the WHERE condition which contains the IN operation between the unsigned double value with the index and the negative value in String type.

mysql> DROP TABLE IF EXISTS t1;

Query OK, 0 rows affected (0.00 sec)

mysql> CREATE TABLE `t1` (

    ->   `c2` double unsigned NOT NULL,

    ->   KEY `ic3` (`c2`)

    -> );

Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO t1 VALUES (0);

Query OK, 1 row affected (0.00 sec)

mysql> SELECT c2,(c2 IN ('-1758183929')) FROM t1 WHERE (c2 IN ('-1758183929'));

+----+-------------------------+

| c2 | (c2 IN ('-1758183929')) |

+----+-------------------------+

|  0 |                       0 |

+----+-------------------------+