Message-ID: <gh-pgjdbc-pgjdbc-3564@github.com>
From: "DmitriyGod (@DmitriyGod)" <noreply+DmitriyGod@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 10 Mar 2025 15:48:53 +0000
Subject: [pgjdbc/pgjdbc] issue #3564: CallableStatement.getParameterMetadata returns wrong parameter mode
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Id: 44647125
X-GitHub-Author-Login: DmitriyGod
X-GitHub-Issue: 3564
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-State: open
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3564
Content-Type: text/plain; charset=utf-8

**Describe the issue**
CallableStatement.getParameterMetadata returns wrong parameter mode

**Driver Version?** 
latest

**Java Version?**
any

**OS Version?**
any

**PostgreSQL Version?**
latest

**To Reproduce**
```SQL
create procedure p_date(in a date, out b date)
language plpgsql AS $$ begin b = a; end; $$;
```

```Java
var call = cn.prepareCall("call p_date(?, ?)");

call.getParameterMetaData().getParameterMode(1); // 1 as expected
call.getParameterMetaData().getParameterMode(2); // 1 but 4 expected
```
**Expected behaviour**
```Java
var call = cn.prepareCall("call p_date(?, ?)");

call.getParameterMetaData().getParameterMode(1); // 1 as expected
call.getParameterMetaData().getParameterMode(2); // 1 but 4 expected
```

**Logs**
No exceptions