Horton

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

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: "798604270@qq.com" <798604270@qq.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2025-12-10T13:33:15Z
Lists: pgsql-bugs 
On Wednesday, December 10, 2025, PG Bug reporting form <
noreply@postgresql.org> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      19350
> Logged by:          Chi Zhang
> Email address:      798604270@qq.com
> PostgreSQL version: 17.6
> Operating system:   ubuntu 24.04 with docker
> Description:
>
> Hi,
>
> In the following test case, if I run it in JDBC, the prepared statement
> will
> trigger a divide by zero error. But if run it in command line, there will
> not be the same error.
>
>
This isn’t a bug in PostgreSQL, it’s a bug in the query you’ve written.
The expectation of short-circuiting is flawed - the non-failure outcome is
not something than can be relied upon.

David J.