Re: Regression tests fail with PG12 - Mailing list pgsql-odbc
From | Inoue, Hiroshi |
---|---|
Subject | Re: Regression tests fail with PG12 |
Date | |
Msg-id | 25b933cb-25d4-7a5b-e11f-403a1c55db0f@dream.email.ne.jp Whole thread Raw |
In response to | Regression tests fail with PG12 (Christoph Berg <myon@debian.org>) |
Responses |
Re: Regression tests fail with PG12
("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
|
List | 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
pgsql-odbc by date: