Message-ID: <gh-postgresql-interfaces-psqlodbc-141@github.com>
From: "OldManYellsAtCloud (@OldManYellsAtCloud)" <noreply+OldManYellsAtCloud@github.com>
To: "postgresql-interfaces/psqlodbc" <noreply+postgresql-interfaces-psqlodbc@github.com>
Date: Thu, 23 Oct 2025 14:23:35 +0000
Subject: [postgresql-interfaces/psqlodbc] issue #141: failing tests - misconfiguration debugging
List-Id: <gh-postgresql-interfaces-psqlodbc.github.com>
X-GitHub-Author-Id: 17875704
X-GitHub-Author-Login: OldManYellsAtCloud
X-GitHub-Issue: 141
X-GitHub-Repo: postgresql-interfaces/psqlodbc
X-GitHub-State: open
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/postgresql-interfaces/psqlodbc/issues/141
Content-Type: text/plain; charset=utf-8

This is not a bug (I think), I'm looking for a bit of tech support.

I'm using postgresql 17.6 along with psqlodbc 17.00.0006, using Yocto. I try to execute the testsuite - I managed to run most, but two tests (lfconversion and result-conversions) fail, and I'm a bit lost. Not sure where to start debugging it.

Both tests complain about "Received an unsupported type from Postgres"

<details>
<summary>lfconversion logs</summary>

```
connected
reading to char buffer...
strlen 22, SQLGetData claims 22

reading to char buffer, with truncation...
strlen 9, SQLGetData claims 22

reading to SQLWCHAR buffer...
SQLGetData failed
07006=Received an unsupported type from Postgres.
```

</details>

<details>
<summary>result-conversions logs</summary>

```

connected
Executed: SET intervalstyle=postgres
Executed: SET bytea_output=escape
Executed: SET lc_monetary='C'
'true' (boolean) as SQL_C_CHAR: 1
'true' (boolean) as SQL_C_WCHAR: SQLGetData failed
07006=Received an unsupported type from Postgres.
'true' (boolean) as SQL_C_SSHORT: 1
'true' (boolean) as SQL_C_USHORT: 1
'true' (boolean) as SQL_C_SLONG: 1
'true' (boolean) as SQL_C_ULONG: 1
'true' (boolean) as SQL_C_FLOAT: 1.000000

<... had to truncate because of github size limits, but can upload the full logs upon request...>

'' (text) as SQL_C_TYPE_TIMESTAMP: y: 0 m: 0 d: 0 h: 0 m: 0 s: 0 f: 0
'foobar' (text) as SQL_C_CHAR: foob (truncated)
'foobar' (text) as SQL_C_CHAR: fooba (truncated)
'foobar' (text) as SQL_C_CHAR: foobar
'foobar' (text) as SQL_C_WCHAR: SQLGetData failed
07006=Received an unsupported type from Postgres.
'foobar' (text) as SQL_C_WCHAR: SQLGetData failed
07006=Received an unsupported type from Postgres.
'foobar' (text) as SQL_C_WCHAR: SQLGetData failed
07006=Received an unsupported type from Postgres.
'foobar' (text) as SQL_C_WCHAR: SQLGetData failed
07006=Received an unsupported type from Postgres.
'foobar' (text) as SQL_C_WCHAR: SQLGetData failed
07006=Received an unsupported type from Postgres.
'' (text) as SQL_C_CHAR: 
'' (text) as SQL_C_WCHAR: SQLGetData failed
07006=Received an unsupported type from Postgres.
'2011-02-15 15:49:18' (timestamp) as SQL_C_CHAR: 2011-02-15 15:49:1 (truncated)
'2011-02-15 15:49:18 BC' (timestamp) as SQL_C_CHAR: 2011-02-15 15:49:18 (truncated)
'NaN' (float4) as SQL_C_FLOAT: nan
'Infinity' (float4) as SQL_C_FLOAT: inf
'-Infinity' (float4) as SQL_C_FLOAT: -inf
'NaN' (float8) as SQL_C_FLOAT: nan
'Infinity' (float8) as SQL_C_FLOAT: inf
'-Infinity' (float8) as SQL_C_FLOAT: -inf
'NaN' (float4) as SQL_C_DOUBLE: nan
'Infinity' (float4) as SQL_C_DOUBLE: inf
'-Infinity' (float4) as SQL_C_DOUBLE: -inf
'NaN' (float8) as SQL_C_DOUBLE: nan
'Infinity' (float8) as SQL_C_DOUBLE: inf
'-Infinity' (float8) as SQL_C_DOUBLE: -inf
disconnecting

```

</details>


I guess I have some wrong configuration somewhere or missing/wrong environment variable, but I'm not really sure where to start looking, what should I try. Could someone please give some pointers?