Request a Demo
Home   >   mailing lists

Re: BUG #19350: Short circuit optimization missed when running sql scriptes in JDBC - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #19350: Short circuit optimization missed when running sql scriptes in JDBC
Date
Msg-id CAKFQuwYR8P-BMX_=z6OmzGoFg1CO6Gu+hA1JMO+2GOV_7DQe0w@mail.gmail.com
Whole thread Raw
In response to BUG #19350: Short circuit optimization missed when running sql scriptes in JDBC  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC
List pgsql-bugs
Tree view


On Wednesday, December 10, 2025, ZhangChi <798604270@qq.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. 

pgsql-bugs by date:

Previous
From: "ZhangChi"
Date:
Subject: Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC
Next
From: "ZhangChi"
Date:
Subject: Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC