Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5, 10.0, 10.1, 10.2, 10.3, 10.4
-
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