| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "798604270(at)qq(dot)com" <798604270(at)qq(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #19350: Short circuit optimization missed when running sql scriptes in JDBC |
| Date: | 2025-12-10 13:33:15 |
| Message-ID: | CAKFQuwbbk7_5vFzkKM+b52xVjJ+p8Wz8UwP5sFWeBnKi69D0-A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wednesday, December 10, 2025, PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 19350
> Logged by: Chi Zhang
> Email address: 798604270(at)qq(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ZhangChi | 2025-12-10 13:41:12 | Re: BUG #19350: Short circuit optimization missed when running sqlscriptes in JDBC |
| Previous Message | Etsuro Fujita | 2025-12-10 11:41:27 | Re: BUG #19339: odbc_fdw extension, Not able to read data from foreign tables |