Skip to content

Incorrect results in less-than comparison between INT4 and INTT

Summary

Less-than comparisons < between INT4 and INTT give wrong results.

Steps to reproduce

SELECT 4::INT4 < 5::INTT AS result;

Expected result

┌────────┐
│ result │
├────────┤
│ t      │
└────────┘
(1 row)

Actual result

┌────────┐
│ result │
├────────┤
│ f      │
└────────┘
(1 row)

Possible fixes

Check the int32_intt_lt function in intt.c for errors.

Additional information

OS Ubuntu 22.04.5 LTS
PostgreSQL 18beta3
ids4nulls 0.3