DBeaver with AWS Redshift

[alexvto]

DBeaver does not report currently the INOUT parameters of Redshift procedures (nor is the DDL correct in this respect).

This is the SP DDL as created (and reported by the AWS RS query editor v2):

CREATE OR REPLACE PROCEDURE ohrs.av_proc(p1 integer, INOUT p2 integer, INOUT p3 character varying(256))
LANGUAGE plpgsql
AS $$
begin
p2 := p1;
p3 := to_char(p1);
end;
$$

In DBeaver, both the parameters tab and the Source (DDL) tab report all parameters as IN only:

-- DROP PROCEDURE ohrs.av_proc(int4, int4, varchar);

CREATE OR REPLACE PROCEDURE ohrs.av_proc(p1 int4, p2 int4, p3 varchar)
LANGUAGE plpgsql
AS $$

begin
p2 := p1;
p3 := to_char(p1);
end;

$$
;

I am attaching a few screenshots as proof:

Thank you everyone!

[E1izabeth]

Thank you for highlighting this flaw. I created the issue from this discussion #34971