Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue
Date
Msg-id CAKFQuwY3-0uQqhpBPfUz9_SQ7Z5b=LqG1CHy-=b7GHyR1SfLBQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue  (Andres Freund <andres@anarazel.de>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: invalid alloc size error possible in shm_mq
Next
From: "David G. Johnston"
Date:
Subject: Re: ECPG bug: "unterminated quoted identifier"