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

On Wed, 17 Dec 2025 at 09:51, Greg Sabino Mullane <htamfids@gmail.com> wrote:

Possibly because JDBC does everything using the V3 protocol whereas psql does not. psql uses simple query.

Maybe JDBC is doing something else? I cannot duplicate the error when doing it via the protocol (DBD::Pg) or via psql. Even forcing non-server-side prepares (i.e. making the driver replace the vars itself) fails to fail.

Logs from the server. I can replicate it.

2025-12-17 10:31:07.860 EST [27985] LOG:  duration: 5.875 ms  statement: SET application_name = 'PostgreSQL JDBC Driver'
2025-12-17 10:31:07.880 EST [27985] LOG:  duration: 0.945 ms  parse <unnamed>: SET plan_cache_mode = force_generic_plan
2025-12-17 10:31:07.880 EST [27985] LOG:  duration: 0.057 ms  bind <unnamed>: SET plan_cache_mode = force_generic_plan
2025-12-17 10:31:07.880 EST [27985] LOG:  duration: 0.019 ms  execute <unnamed>: SET plan_cache_mode = force_generic_plan
2025-12-17 10:31:07.885 EST [27985] LOG:  duration: 3.442 ms  parse <unnamed>: CREATE TABLE t0(c0 int4range)
2025-12-17 10:31:07.885 EST [27985] LOG:  duration: 0.023 ms  bind <unnamed>: CREATE TABLE t0(c0 int4range)
2025-12-17 10:31:07.939 EST [27985] LOG:  duration: 54.701 ms  execute <unnamed>: CREATE TABLE t0(c0 int4range)
2025-12-17 10:31:07.944 EST [27985] LOG:  duration: 2.667 ms  parse <unnamed>: INSERT INTO t0(c0) VALUES('[-1920846305,-1018839689)'::int4range)
2025-12-17 10:31:07.945 EST [27985] LOG:  duration: 0.695 ms  bind <unnamed>: INSERT INTO t0(c0) VALUES('[-1920846305,-1018839689)'::int4range)
2025-12-17 10:31:07.946 EST [27985] LOG:  duration: 1.593 ms  execute <unnamed>: INSERT INTO t0(c0) VALUES('[-1920846305,-1018839689)'::int4range)
2025-12-17 10:31:07.947 EST [27985] LOG:  duration: 0.311 ms  parse <unnamed>: PREPARE prepare_query (int8, int8) AS SELECT ((((((upper(t0.c0))))/($1)))*(($2::int8))) FROM ONLY t0
2025-12-17 10:31:07.947 EST [27985] LOG:  duration: 0.006 ms  bind <unnamed>: PREPARE prepare_query (int8, int8) AS SELECT ((((((upper(t0.c0))))/($1)))*(($2::int8))) FROM ONLY t0
2025-12-17 10:31:07.952 EST [27985] LOG:  duration: 4.653 ms  execute <unnamed>: PREPARE prepare_query (int8, int8) AS SELECT ((((((upper(t0.c0))))/($1)))*(($2::int8))) FROM ONLY t0
2025-12-17 10:31:07.953 EST [27985] LOG:  duration: 0.020 ms  parse <unnamed>: EXECUTE prepare_query(0, NULL)
2025-12-17 10:31:07.953 EST [27985] LOG:  duration: 0.005 ms  bind <unnamed>: EXECUTE prepare_query(0, NULL)

2025-12-17 10:31:07.954 EST [27985] ERROR:  division by zero 

Dave Cramer

www.postgres.rocks