[MDEV-17724] Wrong result for BETWEEN 0 AND 18446744073709551615 Created: 2018-11-15  Updated: 2018-11-16  Resolved: 2018-11-15

Status: Closed
Project: MariaDB Server
Component/s: Data types
Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.3, 10.4
Fix Version/s: 10.3.11, 10.4.1, 10.1.38, 5.5.63, 10.0.38, 10.2.20

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-17698 MEMORY engine performance regression Closed
Problem/Incident
causes MDEV-17747 engines/iuds.update_delete_number and... Closed

 Description    

CREATE OR REPLACE TABLE t1 (
 
  c1 bigint(20) unsigned NOT NULL
 
);
 
INSERT INTO t1 VALUES (0),(101),(255);
 
SELECT * FROM t1 WHERE c1 BETWEEN 0 AND 18446744073709551615 ORDER BY c1;


Empty set (0.00 sec)

Looks wrong. The expected result is to return all 3 records.

 Comments   
Comment by Alexander Barkov [ 2018-11-15 ]

The fix for MDEV-17698 fixed this problem as well.

Generated at Thu Feb 08 08:38:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.