Message-ID: <gh-pgjdbc-pgjdbc-3838-rc2483735147@github.com>
From: "bokken (@bokken)" <noreply+bokken@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Sat, 01 Nov 2025 13:58:45 +0000
Subject: Re: [pgjdbc/pgjdbc] PR #3838: fix: Issue #3784 pgjdbc can't decode numeric arrays containing special numbers like NaN
In-Reply-To: <gh-pgjdbc-pgjdbc-3838-rc2483043414@github.com>
References: <gh-pgjdbc-pgjdbc-3838@github.com> <gh-pgjdbc-pgjdbc-3838-rc2483043414@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: bokken
X-GitHub-Comment-Id: 2483735147
X-GitHub-Comment-Type: review_comment
X-GitHub-Commit: 0e6edd19503efda441f7e6c1e016067dbf520109
X-GitHub-Issue: 3838
X-GitHub-Line: 118
X-GitHub-Path: pgjdbc/src/test/java/org/postgresql/test/jdbc2/ArrayTest.java
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: review_comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/pull/3838#discussion_r2483735147
Content-Type: text/plain; charset=utf-8

(on pgjdbc/src/test/java/org/postgresql/test/jdbc2/ArrayTest.java:118)

It passes the tests after changing them.
The existing (unchanged) tests failed with a class cast exception.
I think it does need to be reverted.

We have discussed the lack of support for these special values in the past. It has been longstanding.

There are not great options.
1 would be a config for how to support/map numeric arrays.
2 would be to dynamically adjust the array type based on presence of these special values