Re: Inconsistent results from seqscan and gist indexscan

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Richard Guo <guofenglinux(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
Subject: Re: Inconsistent results from seqscan and gist indexscan
Date: 2021-11-26 09:23:12
Message-ID: CAOBaU_aU4YaQZ6ydWFSVbUbamyAGxtpOKFv-nhUR5c+5WU4uZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Fri, Nov 26, 2021 at 2:10 PM Richard Guo <guofenglinux(at)gmail(dot)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(at)mail(dot)gmail(dot)com
[2]: https://www.postgresql.org/message-id/20210330095751.x5hnqbqcxilzwjlm%40nol

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2021-11-26 10:17:30 Re: pg_waldump stucks with options --follow or -f and --stats or -z
Previous Message Amul Sul 2021-11-26 09:18:13 Re: Deduplicate code updating ControleFile's DBState.