Regression in driver version 13

Поиск
Список
Период
Сортировка
От
Тема Regression in driver version 13
Дата
Msg-id 75313fc75a7344d5a5301201ceef1665@chamac49.amacaerospace.com
обсуждение исходный текст
Список pgsql-odbc

Dear PGSQL-ODBC Team,

 

We’ve noticed a regression in the latest ODBC driver (version 13).

 

The environment this occurs in consists of:

-          ODBC driver: 32 and 64 bit, Unicode, Version 13

-          DB Engine: PGSQL 12.5, 64 bits under Windows 2019

-          Query executed from within an SSIS (MS SQL Server Integration Services) package

 

When running a very simple query like SELECT TO_CHAR(('DEC 31 1971'::DATE + 10000),'YYYY-MM-DD')::VARCHAR(10) AS "DateText" , the driver seems to return wrong table metadata.

Returned metadata: varchar(255)

Expected metadata: varchar(10)

 

Previous version of the driver (e.g. 12.2) do not expose this error and work just fine.

Is this a known issue and is there a fix for it ?

 

Fiddling the various driver options (unknown length or “Parse Statement”) have no effect on the described behavior.

 

Best regards,

Fabian

 

 

Best regards, Freundliche Grüsse, Meilleures salutations,

Fabian Mangold
IT Project Engineer


AMAC Aerospace Switzerland AG
Sternengasse 18
CH-4051 Basel

Tel:

   +41 58 310 35 93

Email:

   fabian.mangold@amacaerospace.com

Web:

   www.amacaerospace.com



https://www.amacaerospace.com/wp-content/uploads/2021/01/210104_Small-Acts-Big-Impact-Email-Signature-Poster.jpg

AMAC Aerospace AG Standard email Terms & Conditions (1-6 inclusive)
1 – Confidentiality Notice – The information included in this email and any attachment(s) are intended for the sole use of the individual or entity to whom they are addressed.  The email may also be privileged and confidential and if you are not the intended recipient,
you have no grounds for action and as a result of receiving it, included but not limited to copying it, distributing and changing it.  If the communication has been sent as a mistake, please contact us and do not, at any time, show this email to any other party.
2 – AMAC Aerospace AG shall have no liability in any regard of the content of the communication and makes no claim to its accuracy.  Any points of view OR opinions presented are those solely of the author.
3 – Although we have taken steps to ensure that the email and its attachments are free from viruses, AMAC Aerospace AG cannot accept any responsibility for any loss or damage arising from the use of this email and/or attachment(s).
4 – AMAC Aerospace AG, Sternengasse 18, 4051 BASEL, Switzerland.  VAT ID: CHE 113.783.062
5 –
Maintenance Organisation Approval – Federal Office of Civil Aviation (FOCA) – Ref: CH.145.0363
6 – Continuing Airworthiness Management Organisation (CAMO) – Federal Office of Civil Aviation (FOCA) – Ref: CH.MG.7011

 

Вложения

В списке pgsql-odbc по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: PostgreSQLとpsqlodbcドライバーの互換性について
Следующее
От: "oki.ichikawa@ctc-g.co.jp"
Дата:
Сообщение: RE: psql-odbc-driver log