Regression tests fail with PG12

From: Christoph Berg <myon(at)debian(dot)org>
To: PostgreSQL ODBC <pgsql-odbc(at)postgresql(dot)org>
Subject: Regression tests fail with PG12
Date: 2019-11-07 08:51:53
Message-ID: 20191107085153.GA3717@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

the psqlodbc regression tests need updating for PG12's new floating
point output format. Also, "abstime" got removed as type.

*** ./expected/result-conversions.out Fri Oct 11 15:03:22 2019
--- results/result-conversions.out Thu Nov 7 09:47:19 2019
***************
*** 638,645 ****
'1.234' (float4) as SQL_C_INTERVAL_HOUR_TO_MINUTE: interval sign: 0 unknown interval type: 0
'1.234' (float4) as SQL_C_INTERVAL_HOUR_TO_SECOND: interval sign: 0 unknown interval type: 0
'1.234' (float4) as SQL_C_INTERVAL_MINUTE_TO_SECOND: interval sign: 0 unknown interval type: 0
! '1.23456789012' (float8) as SQL_C_CHAR: 1.2345678901199999
! '1.23456789012' (float8) as SQL_C_WCHAR: 1.2345678901199999
'1.23456789012' (float8) as SQL_C_SSHORT: 1
'1.23456789012' (float8) as SQL_C_USHORT: 1
'1.23456789012' (float8) as SQL_C_SLONG: 1
--- 638,645 ----
'1.234' (float4) as SQL_C_INTERVAL_HOUR_TO_MINUTE: interval sign: 0 unknown interval type: 0
'1.234' (float4) as SQL_C_INTERVAL_HOUR_TO_SECOND: interval sign: 0 unknown interval type: 0
'1.234' (float4) as SQL_C_INTERVAL_MINUTE_TO_SECOND: interval sign: 0 unknown interval type: 0
! '1.23456789012' (float8) as SQL_C_CHAR: 1.23456789012
! '1.23456789012' (float8) as SQL_C_WCHAR: 1.23456789012
'1.23456789012' (float8) as SQL_C_SSHORT: 1
'1.23456789012' (float8) as SQL_C_USHORT: 1
'1.23456789012' (float8) as SQL_C_SLONG: 1
***************
*** 657,663 ****
'1.23456789012' (float8) as SQL_C_VARBOOKMARK: SQLGetData failed
07006=Received an unsupported type from Postgres.
'1.23456789012' (float8) as SQL_C_TYPE_TIME: h: 0 m: 0 s: 0
! '1.23456789012' (float8) as SQL_C_NUMERIC: precision: 17 scale: 16 sign: 16 val: 7fc46a5d54dc2b000000000000000000
'1.23456789012' (float8) as SQL_C_GUID: SQLGetData failed
07006=Received an unsupported type from Postgres.
'1.23456789012' (float8) as SQL_C_INTERVAL_YEAR: interval sign: 0 unknown interval type: 0
--- 657,663 ----
'1.23456789012' (float8) as SQL_C_VARBOOKMARK: SQLGetData failed
07006=Received an unsupported type from Postgres.
'1.23456789012' (float8) as SQL_C_TYPE_TIME: h: 0 m: 0 s: 0
! '1.23456789012' (float8) as SQL_C_NUMERIC: precision: 12 scale: 11 sign: 11 val: 141a99be1c0000000000000000000000
'1.23456789012' (float8) as SQL_C_GUID: SQLGetData failed
07006=Received an unsupported type from Postgres.
'1.23456789012' (float8) as SQL_C_INTERVAL_YEAR: interval sign: 0 unknown interval type: 0

....

--- 674,679 ----
'1.23456789012' (float8) as SQL_C_INTERVAL_HOUR_TO_MINUTE: interval sign: 0 unknown interval type: 0
'1.23456789012' (float8) as SQL_C_INTERVAL_HOUR_TO_SECOND: interval sign: 0 unknown interval type: 0
'1.23456789012' (float8) as SQL_C_INTERVAL_MINUTE_TO_SECOND: interval sign: 0 unknown interval type: 0
! '2011-01-14 16:49:18+03' (abstime) as SQL_C_CHAR: SQLExecDirect failed
! 42704=ERROR: type "abstime" does not exist;
! Error while executing the query

Spotted by Debian's CI pipeline.

https://salsa.debian.org/postgresql/psqlodbc/-/jobs/402606

Christoph

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Inoue, Hiroshi 2019-11-08 01:48:14 Re: Regression tests fail with PG12
Previous Message Daniel Collins 2019-10-31 22:25:11 Compiling ODBC 12.0 on mac