Postgres Pro
Downloads
Home   >   mailing lists

Re: Inconsistent results from seqscan and gist indexscan - Mailing list pgsql-hackers

From Julien Rouhaud
Subject Re: Inconsistent results from seqscan and gist indexscan
Date
Msg-id CAOBaU_aU4YaQZ6ydWFSVbUbamyAGxtpOKFv-nhUR5c+5WU4uZA@mail.gmail.com
Whole thread Raw
In response to Inconsistent results from seqscan and gist indexscan  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: Inconsistent results from seqscan and gist indexscan
List pgsql-hackers
Tree view 
Hi,

On Fri, Nov 26, 2021 at 2:10 PM Richard Guo <guofenglinux@gmail.com> wrote:
>
> Seems point_inside() does not handle NaN properly.

This is unfortunately a known issue, which was reported twice ([1] and
[2]) already.  There's a patch proposed for it:
https://commitfest.postgresql.org/32/2710/ (adding Horiguchi-san in
Cc).

[1]: https://www.postgresql.org/message-id/flat/CAGf+fX70rWFOk5cd00uMfa__0yP+vtQg5ck7c2Onb-Yczp0URA@mail.gmail.com
[2]: https://www.postgresql.org/message-id/20210330095751.x5hnqbqcxilzwjlm%40nol

pgsql-hackers by date:

Previous
From: Amul Sul
Date:
Subject: Re: Deduplicate code updating ControleFile's DBState.
Next
From: Bharath Rupireddy
Date:
Subject: Re: pg_waldump stucks with options --follow or -f and --stats or -z