[MDEV-17724] Wrong result for BETWEEN 0 AND 18446744073709551615 - Jira

XML

Word

Printable

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.

causes

MDEV-17747 engines/iuds.update_delete_number and engines/iuds.insert_number fail in buildbot with wrong result

duplicates

MDEV-17698 MEMORY engine performance regression