postgresql-interfaces/psqlodbc GitHub issues and pull requests (mirror)
help / color / mirror / Atom feedFrom: OldManYellsAtCloud (@OldManYellsAtCloud) <[email protected]>
To: postgresql-interfaces/psqlodbc <[email protected]>
Subject: [postgresql-interfaces/psqlodbc] issue #141: failing tests - misconfiguration debugging
Date: Thu, 23 Oct 2025 14:23:35 +0000
Message-ID: <[email protected]> (raw)
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?
view thread (3+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: github://postgresql-interfaces/psqlodbc
Cc: [email protected], [email protected]
Subject: Re: [postgresql-interfaces/psqlodbc] issue #141: failing tests - misconfiguration debugging
In-Reply-To: <<[email protected]>>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox