Horton

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

Greg Sabino Mullane <htamfids@gmail.com>

View thread
From: Greg Sabino Mullane <htamfids@gmail.com>
To: Dave Cramer <davecramer@postgres.rocks>
Cc: ZhangChi <798604270@qq.com>, "David G. Johnston" <david.g.johnston@gmail.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2025-12-17T14:51:08Z
Lists: pgsql-bugs 
>
> 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.