select 100 between 1 and 9223372036854775808 returns false

mysql> select 100 between 1 and 9223372036854775808;

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

| 100 between 1 and 9223372036854775808 |

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

|                                     0 |

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

1 row in set (0.00 sec)

select 100 between 1 and 9223372036854775808;