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.