BUG #19705: One NaN box makes BRIN and GiST box indexes omit unrelated rows

Edit
ID 7370
Title BUG #19705: One NaN box makes BRIN and GiST box indexes omit unrelated rows
CI (CFBot) Summary
Stats (from CFBot) Patch version: v6, Patch count: 4, First patch: +185−2, All patches: +573−39
Tags Bugfix
Created 2026-09-30 05:29:19
Last modified 2026-09-30 05:29:19 (1 hour ago)
Latest email 2026-09-30 05:30:12 (1 hour ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version
Authors Kirill Reshke (reshke), shihao zhong (zhong950419)
Reviewers Become reviewer
Committer
Links
Emails
BUG #19705: One NaN box makes a BRIN box_inclusion_ops index omit unrelated rows
First at 2026-09-19 17:37:52 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-09-30 05:30:12 by shihao zhong <zhong950419 at gmail.com>
Latest attachment (v6-0002-Fix-GiST-box-indexes-hiding-rows-next-to-a-NaN-bo.patch) at 2026-09-28 07:01:52 from shihao zhong <zhong950419 at gmail.com>
    Attachment (v6-0002-Fix-GiST-box-indexes-hiding-rows-next-to-a-NaN-bo.patch) at 2026-09-28 07:01:52 from shihao zhong <zhong950419 at gmail.com> (Patch: No)
    Attachment (nocfbot-19705-v5-nan-matrix.txt) at 2026-09-26 00:09:35 from Manu <manuelreyesbravo at gmail.com> (Patch: No)
    Attachment (v5-0002-Fix-GiST-box-indexes-hiding-rows-next-to-a-NaN-bo.patch) at 2026-09-24 06:22:32 from Kirill Reshke <reshkekirill at gmail.com> (Patch: No)
    Attachment (v4-REL_18-0001-Fix-BRIN-box_inclusion_ops-hiding-rows-next-to-a-.patch.nocfbot) at 2026-09-24 02:43:58 from shihao zhong <zhong950419 at gmail.com> (Patch: No)
    Attachment (v3-0001-Fix-NaN-handling-in-BRIN-box_inclusion_ops-and-Gi.patch) at 2026-09-23 03:43:02 from shihao zhong <zhong950419 at gmail.com> (Patch: No)
    Attachment (v2-0001-Fix-NaN-handling-in-BRIN-box_inclusion_ops-and-Gi.patch) at 2026-09-22 12:12:56 from Kirill Reshke <reshkekirill at gmail.com> (Patch: No)
    Attachment (v1-0002-Add-tests-for-NaN-handling-in-bound_box-and-BRIN-.patch) at 2026-09-21 23:49:51 from shihao zhong <zhong950419 at gmail.com> (Patch: No)
History
When Who What
2026-09-30 05:29:19 shihao zhong (zhong950419) Attached mail thread 19705-548fda77321e062d@postgresql.org
2026-09-30 05:29:19 shihao zhong (zhong950419) Created patch record
Edit