From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dave Cramer <davecramer@postgres.rocks>
cc: dafoer_x@163.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17728: When jdbc calls the stored procedure,
 portal->stmts in FillPortalStore is null, causing a processing
In-reply-to: 
 <CADK3HHKhf5CDXeDNT4YOjv28jNvuOUeP4o2_Hx+LyjMYhjV1-w@mail.gmail.com>
References: <17728-64af72bf9747ff0a@postgresql.org>
 <CADK3HHKhf5CDXeDNT4YOjv28jNvuOUeP4o2_Hx+LyjMYhjV1-w@mail.gmail.com>
Comments: In-reply-to Dave Cramer <davecramer@postgres.rocks>
	message dated "Thu, 22 Dec 2022 14:25:57 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2309553.1671770295.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 22 Dec 2022 23:38:15 -0500
Message-ID: <2309554.1671770295@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2309554.1671770295%40sss.pgh.pa.us>
Precedence: bulk

Dave Cramer <davecramer@postgres.rocks> writes:
> On Thu, 22 Dec 2022 at 10:49, PG Bug reporting form <noreply@postgresql.=
org>
> wrote:
>> #0  pgss_store (query=3D0x2d55138 "call p1($1)",
>> queryId=3D16705933007615826313,
>> query_location=3D1702063721, query_len=3D1763734642, kind=3DPGSS_EXEC,
>> total_time=3D3341.1963460000002,
>> rows=3D0, bufusage=3D0x7ffc2e4ddc20, walusage=3D0x7ffc2e4ddcf0, jstate=3D=
0x0)
>> at pg_stat_statements.c:1225

> I just tried the same code with no issues.

This looks very much like the bug fixed by commit 495e73c20 [1].
I wonder whether the server is really 14.6, or something older,
because that fix shipped in 14.6.

			regards, tom lane

[1] https://git.postgresql.org/gitweb/?p=3Dpostgresql.git&a=3Dcommitdiff&h=
=3D495e73c20