Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue
Дата
Msg-id CAKFQuwY3-0uQqhpBPfUz9_SQ7Z5b=LqG1CHy-=b7GHyR1SfLBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue  (Andres Freund <andres@anarazel.de>)
Список pgsql-bugs
On Fri, Oct 16, 2020 at 6:32 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Friday, October 16, 2020, Thangavel, Parameswaran <Parameswaran.Thangavel@rsa.com> wrote:

Any thoughts on why this behavior, Is this expected?

 
Not immediately, can you demonstrate the problem without using JDBC?  The JDBC project has its own issues setup on GitHub.

So, confirming the following query result on head.

select '1234567'::float4::numeric; -- 1234570

Not tested on 9.4.1 (or the last current 9.4.26 release.

The open question is whether the change in result is a bug.  I'll agree it is not expected; but then again floating point and numeric compatibility is not something that I am expecting to make sense at a high-level; the devil is in the details.

David J.

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: invalid alloc size error possible in shm_mq
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: ECPG bug: "unterminated quoted identifier"