Re: Regression tests fail with PG12 - Mailing list pgsql-odbc

Hi Christoph,

Sorry for the late reply.
Could you try the attached patch?

regards,
Hiroshi Inoue

On 2019/11/08 10:48, Inoue, Hiroshi wrote:
> 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