From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dave Cramer <davecramer@postgres.rocks>
cc: ZhangChi <798604270@qq.com>, Greg Sabino Mullane <htamfids@gmail.com>,
        "David G. Johnston" <david.g.johnston@gmail.com>,
        "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #19350: Short circuit optimization missed when
 runningsqlscriptes in JDBC
In-reply-to: 
 <CADK3HH+EK4qM74YVGobr+oWcpe-EFoKGtQDDtt+Yd87nsVeHsQ@mail.gmail.com>
References: <19350-aed90efec73c66cc@postgresql.org>
 <CAKFQuwbbk7_5vFzkKM+b52xVjJ+p8Wz8UwP5sFWeBnKi69D0-A@mail.gmail.com>
 <tencent_6A625E6BCFAF916999E0C64185022D99ED0A@qq.com>
 <CAKAnmmJ=SfR-C3f9Y6Soi=g-QPRqaxzY5pbUa3QMZsStHMJP6A@mail.gmail.com>
 <tencent_D9E4BA699E83ACD964358E23B46C29753705@qq.com>
 <CADK3HH+EK4qM74YVGobr+oWcpe-EFoKGtQDDtt+Yd87nsVeHsQ@mail.gmail.com>
Comments: In-reply-to Dave Cramer <davecramer@postgres.rocks>
	message dated "Wed, 17 Dec 2025 07:55:25 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2629414.1765986243.1@sss.pgh.pa.us>
Date: Wed, 17 Dec 2025 10:44:03 -0500
Message-ID: <2629415.1765986243@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2629415.1765986243%40sss.pgh.pa.us>
Precedence: bulk

Dave Cramer <davecramer@postgres.rocks> writes:
> On Tue, 16 Dec 2025 at 20:40, ZhangChi <798604270@qq.com> wrote:
>> But my question is that in the CLI, the test case (like foo2) I showed can
>> return the results. But when I run the same test case in JDBC, the test
>> case triggers an error. I wonder why there is an inconsistency.

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

The error will occur if we try to build a "custom plan" for the
prepared query.  I suspect a discrepancy in the plan_cache_mode
settings between JDBC and the user's psql setup.

			regards, tom lane