Re: BUG #19705: One NaN box makes a BRIN box_inclusion_ops index omit unrelated rows - Mailing list pgsql-bugs

From shihao zhong
Subject Re: BUG #19705: One NaN box makes a BRIN box_inclusion_ops index omit unrelated rows
Date
Msg-id CAGRkXqRbimqBSg9GYMGDSp7bpaDWed91Tyb6WHcr4Yw50bU8Rg@mail.gmail.com
Whole thread
In response to Re: BUG #19705: One NaN box makes a BRIN box_inclusion_ops index omit unrelated rows  (John Naylor <johncnaylorls@gmail.com>)
List pgsql-bugs
> The following might be relevant as a different perspective:
>
> https://www.postgresql.org/message-id/1122078.1741378100@sss.pgh.pa.us

Hi John,

Thanks. I don't think v6 conflicts with Tom's idea. Banning NaN
would reject input that works today, so it can't be back-patched. And
in master, NaN boxes already on disk stay there after pg_upgrade. So
the indexes need fixing either way.

If you want less code, I can drop 0004 and use the v6-REL_18-0001
check on master too. That leaves no catalog change.

Thanks,
Shihao

pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: BUG #19672: int8shl/int8shr Undefined Behavior on Out-of-Range Shift Amounts
Next
From: Ajin Cherian
Date:
Subject: Re: BUG #19728: A logical replication apply worker segfaults dereferencing a NULL `MyLogicalRepWorker->stream_filese