[MDEV-9372] select 100 between 1 and 9223372036854775808 returns false Created: 2016-01-06  Updated: 2018-11-14  Resolved: 2016-04-22

Status: Closed
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 5.3.13, 5.5, 10.0, 10.1
Fix Version/s: 5.5.50

Type: Bug Priority: Major
Reporter: Dylan Su Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: upstream-fixed

Issue Links:
Relates
relates to MDEV-17698 MEMORY engine performance regression Closed
Sprint: 10.0.25

 Description   

Output:

mysql> select 100 between 1 and 9223372036854775808;
 
+---------------------------------------+
 
| 100 between 1 and 9223372036854775808 |
 
+---------------------------------------+
 
|                                     0 |
 
+---------------------------------------+
 
1 row in set (0.00 sec)

Recreate:

select 100 between 1 and 9223372036854775808;

Problem:
========
1 is expected

 Comments   
Comment by Elena Stepanova [ 2016-01-11 ]

Thanks for the report and the test case.
Also reproducible with MySQL 5.6, seems to be fixed in MySQL 5.7.

Comment by Sergei Golubchik [ 2016-04-20 ]

bar, push it into 5.5, please

Generated at Thu Feb 08 07:34:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.