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
|
| Список | 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 по дате отправления: