C:\dbs>c:\dbs\5.0\bin\mysql -uroot --port=3500 --prompt="mysql 5.0 > " Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.0.97-Win X64 Source distribution Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 5.0 > select -9223372036854775808 in (-9223372036854775809,9223372036854775808); +--------------------------------------------------------------------+ | -9223372036854775808 in (-9223372036854775809,9223372036854775808) | +--------------------------------------------------------------------+ | 0 | +--------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql 5.0 > select -9223372036854775808 in (-9223372036854775809); +------------------------------------------------+ | -9223372036854775808 in (-9223372036854775809) | +------------------------------------------------+ | 0 | +------------------------------------------------+ 1 row in set (0.01 sec) mysql 5.0 > select -9223372036854775808 in (9223372036854775808); +-----------------------------------------------+ | -9223372036854775808 in (9223372036854775808) | +-----------------------------------------------+ | 0 | +-----------------------------------------------+ 1 row in set (0.00 sec) C:\dbs>c:\dbs\5.1\bin\mysql -uroot --port=3510 --debug-info --prompt="mysql 5.1 > " Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.1.74-Win X64 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 5.1 > select -9223372036854775808 in (-9223372036854775809,9223372036854775808); +--------------------------------------------------------------------+ | -9223372036854775808 in (-9223372036854775809,9223372036854775808) | +--------------------------------------------------------------------+ | 1 | +--------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql 5.1 > select -9223372036854775808 in (-9223372036854775809); +------------------------------------------------+ | -9223372036854775808 in (-9223372036854775809) | +------------------------------------------------+ | 0 | +------------------------------------------------+ 1 row in set (0.00 sec) mysql 5.1 > select -9223372036854775808 in (9223372036854775808); +-----------------------------------------------+ | -9223372036854775808 in (9223372036854775808) | +-----------------------------------------------+ | 0 | +-----------------------------------------------+ 1 row in set (0.00 sec) C:\dbs>c:\dbs\5.5\bin\mysql -uroot --port=3550 --prompt="mysql 5.5 > " Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.5.48 Source distribution PULL: 2015-DEC-27 Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 5.5 > select -9223372036854775808 in (-9223372036854775809,9223372036854775808); +--------------------------------------------------------------------+ | -9223372036854775808 in (-9223372036854775809,9223372036854775808) | +--------------------------------------------------------------------+ | 1 | +--------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql 5.5 > select -9223372036854775808 in (-9223372036854775809); +------------------------------------------------+ | -9223372036854775808 in (-9223372036854775809) | +------------------------------------------------+ | 0 | +------------------------------------------------+ 1 row in set (0.00 sec) mysql 5.5 > select -9223372036854775808 in (9223372036854775808); +-----------------------------------------------+ | -9223372036854775808 in (9223372036854775808) | +-----------------------------------------------+ | 0 | +-----------------------------------------------+ 1 row in set (0.00 sec) C:\dbs>c:\dbs\5.6\bin\mysql -uroot --port=3560 -p --prompt="mysql 5.6 > " Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.6.29 Source distribution PULL: 2015-DEC-27 Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 5.6 > select -9223372036854775808 in (-9223372036854775809,9223372036854775808); +--------------------------------------------------------------------+ | -9223372036854775808 in (-9223372036854775809,9223372036854775808) | +--------------------------------------------------------------------+ | 1 | +--------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql 5.6 > select -9223372036854775808 in (-9223372036854775809); +------------------------------------------------+ | -9223372036854775808 in (-9223372036854775809) | +------------------------------------------------+ | 0 | +------------------------------------------------+ 1 row in set (0.00 sec) mysql 5.6 > select -9223372036854775808 in (9223372036854775808); +-----------------------------------------------+ | -9223372036854775808 in (9223372036854775808) | +-----------------------------------------------+ | 0 | +-----------------------------------------------+ 1 row in set (0.00 sec) C:\dbs>c:\dbs\5.7\bin\mysql -uroot -p --port=3570 --prompt="mysql 5.7 > " Enter password: ****** Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 10 Server version: 5.7.11 Source distribution PULL: 2015-DEC-27 Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 5.7 > select -9223372036854775808 in (-9223372036854775809,9223372036854775808); +--------------------------------------------------------------------+ | -9223372036854775808 in (-9223372036854775809,9223372036854775808) | +--------------------------------------------------------------------+ | 1 | +--------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql 5.7 > select -9223372036854775808 in (-9223372036854775809); +------------------------------------------------+ | -9223372036854775808 in (-9223372036854775809) | +------------------------------------------------+ | 0 | +------------------------------------------------+ 1 row in set (0.00 sec) mysql 5.7 > select -9223372036854775808 in (9223372036854775808); +-----------------------------------------------+ | -9223372036854775808 in (9223372036854775808) | +-----------------------------------------------+ | 0 | +-----------------------------------------------+ 1 row in set (0.00 sec)