Re: [PostgresJDBCDriver 42.2.2 Strange Behavior] Observed precisionand scale being set as 17 for 'Double Precision data type'

On 19-4-2018 05:36, Sachin Kumar wrote:

Hi Postgres Team,

I have observed PostgresJDBCDriver 42.2.2 returning precision and scale both same as 17 for 'double precision' data type.

Scale has no meaning for double precision, as such it should return 0 always (from the javadoc of ResultSetMetaData.getScale(..): "Gets the designated column's number of digits to right of the decimal point. 0 is returned for data types where the scale is not applicable.".

It sounds like a bug to me, to be honest.

Ideally scale should not be same as precision otherwise it will indicate only value between o and 1(exclusive) are allowed to load in it.

Can you please look in to this issue and please let me understand why precision and scale has been set as 17(hardcoded value) for postgres 'double precision' data type?

GIT Src code link for reference[Hardcoded '17']:
https://github.com/pgjdbc/pgjdbc/blob/d5f1cf7c35b05318947021d41e73b6953f623256/pgjdbc/src/main/java/org/postgresql/jdbc/TypeInfoCache.java#L659

--
Mark Rotteveel