Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.3, 10.4
-
Component/s: Data types
-
Labels:None
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.
Attachments
Issue Links
- causes
-
MDEV-17747 engines/iuds.update_delete_number and engines/iuds.insert_number fail in buildbot with wrong result
-
- Closed
-
- duplicates
-
MDEV-17698 MEMORY engine performance regression
-
- Closed
-