From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | Christoph Berg <myon(at)debian(dot)org> |
Cc: | PostgreSQL ODBC <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Regression tests fail with PG12 |
Date: | 2019-11-08 01:48:14 |
Message-ID: | 25b933cb-25d4-7a5b-e11f-403a1c55db0f@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Christoph,
I would take care of this issue.
Thansks.
Hiroshi Inoue
On 2019/11/07 17:51, Christoph Berg wrote:
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Inoue, Hiroshi | 2019-11-12 04:45:51 | Re: Regression tests fail with PG12 |
Previous Message | Christoph Berg | 2019-11-07 08:51:53 | Regression tests fail with PG12 |