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

Hi David J.


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


         Original
         
       
From: David G. Johnston <david.g.johnston@gmail.com&gt;
Date: 2025-12-10 21:33
To: 798604270@qq.com <798604270@qq.com&gt;, pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org&gt;
Subject: Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC



       On Wednesday, December 10, 2025, PG Bug reporting form <noreply@postgresql.org&gt; wrote:
The following bug has been logged on the website:
 
 Bug reference:&nbsp; &nbsp; &nbsp; 19350
 Logged by:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Chi Zhang
 Email address:&nbsp; &nbsp; &nbsp; 798604270@qq.com
 PostgreSQL version: 17.6
 Operating system:&nbsp; &nbsp;ubuntu 24.04 with docker
 Description:&nbsp; &nbsp; &nbsp; &nbsp;
 
 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.&nbsp; The expectation of short-circuiting is flawed - the non-failure outcome is not something than can be relied upon.


David J.