MIME-Version: 1.0
References: <CADK3HHJX0XeJQO9gqhLbywcJgXskezPE9p-jaVLUFB5N2wR_KQ@mail.gmail.com>
In-Reply-To: <CADK3HHJX0XeJQO9gqhLbywcJgXskezPE9p-jaVLUFB5N2wR_KQ@mail.gmail.com>
From: David Rowley <dgrowleyml@gmail.com>
Date: Thu, 28 Mar 2024 10:56:54 +1300
Message-ID: <CAApHDvqp-Cy3sY8dGPL-zyECCVBjrBN+WrCGg-k5cqU1NegGSA@mail.gmail.com>
Subject: Re: incorrect results and different plan with 2 very similar queries
To: Dave Cramer <davecramer@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAApHDvqp-Cy3sY8dGPL-zyECCVBjrBN%2BWrCGg-k5cqU1NegGSA%40mail.gmail.com>
Precedence: bulk

On Thu, 28 Mar 2024 at 10:33, Dave Cramer <davecramer@gmail.com> wrote:
> There is a report on the pgjdbc github JDBC Driver shows erratic behavior=
 when filtering on CURRENT_DATE =C2=B7 pgjdbc/pgjdbc =C2=B7 Discussion #318=
4 (github.com)
>
> Here are the plans.
>
> JDBC - Nested Loop (incorrect result)
>
>                     Index Cond: (mutation >=3D ((CURRENT_DATE - '1971-12-=
31'::date) - 28))

> JDBC - Hash Right (correct result)
>
>                     Recheck Cond: (mutation >=3D ((CURRENT_DATE - '1971-1=
2-31'::date) - 29))

I don't see any version details or queries, but going by the
conditions above, the queries don't appear to be the same, so
different results aren't too surprising and not a demonstration that
there's any sort of bug.

David