Postgres explain plan is not correctly optimezed if the data is a "double" but the collumn is a "numeric"

From: charles Lgn <charles(dot)ligony(at)gmail(dot)com>
To: pgsql-jdbc(at)lists(dot)postgresql(dot)org
Subject: Postgres explain plan is not correctly optimezed if the data is a "double" but the collumn is a "numeric"
Date: 2024-06-14 12:00:30
Message-ID: CA+qS9LjZHNFaT=vKSM_Eu17TPg=oc0M1qLd9HFozJi-mvXTSqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

I opened a pull request on the postgres jdbc, because the execution plan
could be false when calculating, leading to performance issues.

There's more on the subject here :
https://github.com/pgjdbc/pgjdbc/pull/3285

thank you in advance
Charles

Browse pgsql-jdbc by date

  From Date Subject
Previous Message Dave Cramer 2024-03-31 10:05:48 Re: cached plan must not change result type