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 CAKFQuwbbk7_5vFzkKM+b52xVjJ+p8Wz8UwP5sFWeBnKi69D0-A@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, 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.

pgsql-bugs by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: BUG #19339: odbc_fdw extension, Not able to read data from foreign tables
Next
From: "ZhangChi"
Date:
Subject: Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC