Re: PostgresSQL 10 | Driver 42.2.5 | Float Conversion Issue

Specifically this behavior can be readily observed using the following query:

SELECT '1.234567+e06'::float4::numeric;

As I mentioned in the original -bugs report for this issue [1] I don't know whether the above is correct or not.  What I can say is the regression demonstrated in the example Java program could be readily avoided by not passing around floating point values when the database storage is numeric.

Since the confusing behavior can be shown using just PostgreSQL the original bug report suffices as a place to get the final explanation as to what is going on here.

David J.

[1] https://www.postgresql.org/message-id/flat/CH2PR19MB3798B24BCC34D3F9949F629C83000%40CH2PR19MB3798.namprd19.prod.outlook.com