Re: BUG #19350: Short circuit optimization missed when running sql scriptes in JDBC

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: ZhangChi <798604270(at)qq(dot)com>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #19350: Short circuit optimization missed when running sql scriptes in JDBC
Date: 2025-12-10 13:46:51
Message-ID: CAKFQuwYR8P-BMX_=z6OmzGoFg1CO6Gu+hA1JMO+2GOV_7DQe0w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wednesday, December 10, 2025, ZhangChi <798604270(at)qq(dot)com> wrote:

> Hi David J.
>
> Thanks for your reply. I wonder why this query triggers an error under
> JDBC but not in the CLI.
>

Because the planner can simplify the expression if it sees a constant null
value but cannot when everything is injected via parameter.

David J.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message ZhangChi 2025-12-10 14:01:22 Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC
Previous Message ZhangChi 2025-12-10 13:41:12 Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC