Message-ID: <gh-pgjdbc-pgjdbc-3562-c2719038334@github.com>
From: "rtrier (@rtrier)" <noreply+rtrier@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Wed, 12 Mar 2025 20:20:14 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3562: After insert with PreparedStatement into table with complex types querying leads to resultset with incorrect type
In-Reply-To: <gh-pgjdbc-pgjdbc-3562@github.com>
References: <gh-pgjdbc-pgjdbc-3562@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: rtrier
X-GitHub-Comment-Id: 2719038334
X-GitHub-Comment-Type: issue_comment
X-GitHub-Edited-At: 2025-03-12T23:46:44Z
X-GitHub-Issue: 3562
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3562#issuecomment-2719038334
Content-Type: text/plain; charset=utf-8

ready for reproduce:

1. CodeList and JdbcTest are Java-Files
2. adjust DB-Parameter in JdbcTest.main
3. run JdbcTest.main with Line 78 `runInsert(con, uuid);` commented/uncommented

if run with the insert statement the value of status is not an instance of CodeList as expected

As I tried to explain: through the insert statement `TypeInfoCache.getPGType(String)` is called and is setting the cache stuff different then by `TypeInfoCache.getPGType(int)`

[CodeList.txt](https://github.com/user-attachments/files/19217150/CodeList.txt)
[JdbcTest.txt](https://github.com/user-attachments/files/19217151/JdbcTest.txt)
[sql.txt](https://github.com/user-attachments/files/19217149/sql.txt)