BUG #16557: getProcedureColumns() function returns columns, when there is no existing Stored Procedure in the DB

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: adarshdeep(dot)cheema(at)ibm(dot)com
Subject: BUG #16557: getProcedureColumns() function returns columns, when there is no existing Stored Procedure in the DB
Date: 2020-07-27 17:07:39
Message-ID: 16557-92b633963d43f893@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16557
Logged by: Adarshdeep Cheema
Email address: adarshdeep(dot)cheema(at)ibm(dot)com
PostgreSQL version: 12.2
Operating system: Windows
Description:

Create any user defined function using Postgres 12.3 Server, we are using
postgresql-42.2.11 JDBC driver

DDLs:
CREATE FUNCTION findec(pdec numeric) RETURNS numeric
LANGUAGE plpgsql
AS $$
declare r decimal(7,2);
begin
r = PDEC;
return r;
end;
$$;

a) When we use the following Java code, then we get nothing as we do no have
any Stored Procedure defined, which is expected
resultSet= metadata.getProcedures(null , "public", null); ,
while (resultSet.next()){

System.out.print(resultSet.getString(1)+" ");
System.out.print(resultSet.getString(2)+" ");
System.out.print(resultSet.getString(3)+" ");
System.out.print(resultSet.getString(4)+" ");
System.out.print(resultSet.getString(5)+" ");
System.out.println(resultSet.getString(6)+" ");
}

b) Now change the JAVA code to the following and you will get two columns in
the resultSet, which is a bug as there is no StoredProcedure Defined in the
database

resultSet= metadata.getProcedureColumns(null , "public", "findec", null);
,
while (resultSet.next()){

System.out.print(resultSet.getString(1)+" ");
System.out.print(resultSet.getString(2)+" ");
System.out.print(resultSet.getString(3)+" ");
System.out.print(resultSet.getString(4)+" ");
System.out.print(resultSet.getString(5)+" ");
System.out.println(resultSet.getString(6)+" ");
}

OUTPUT:
null public findec returnValue 5 2
null public findec pdec 1 2

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message tutiluren 2020-07-27 23:15:12 Re: pg_dump seems to be broken in regards to the "--exclude-table-data" option on Windows.
Previous Message Michael Paquier 2020-07-27 07:16:35 Re: BUG #16476: pgp_sym_encrypt_bytea with compress-level=6 : Wrong key or corrupt data