Description:
Output:
=======
mysql> select -9223372036854775808 in (-9223372036854775809,9223372036854775808);
+--------------------------------------------------------------------+
| -9223372036854775808 in (-9223372036854775809,9223372036854775808) |
+--------------------------------------------------------------------+
| 1 |
+--------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select -9223372036854775808 in (-9223372036854775809);
+------------------------------------------------+
| -9223372036854775808 in (-9223372036854775809) |
+------------------------------------------------+
| 0 |
+------------------------------------------------+
1 row in set (0.00 sec)
mysql> select -9223372036854775808 in (9223372036854775808);
+-----------------------------------------------+
| -9223372036854775808 in (9223372036854775808) |
+-----------------------------------------------+
| 0 |
+-----------------------------------------------+
1 row in set (0.00 sec)
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.8-rc |
+-----------+
1 row in set (0.00 sec)
Problem:
========
How to repeat:
select -9223372036854775808 in (-9223372036854775809,9223372036854775808);
select -9223372036854775808 in (-9223372036854775809);
select -9223372036854775808 in (9223372036854775808);
Suggested fix:
select -9223372036854775808 in (-9223372036854775809,9223372036854775808) returns false.