Upgrading postgres JDBC driver to 42.3.0 breaks big decimal read after 5 reads

[NikolayMetchev]

If you have a numeric column in a postgres table with a value of 20000 and you read it 5 times on the 5th read it will read it as 2 instead of 20000.

This only breaks if you use the postgres jdbc driver version 42.3.0. If you revert to an older JDBC driver for postgres the bug doesn't manifest.

If you use pure JDBC and avoid hikari altogether the bug also doesn't reproduce.

Changing the version of postgres server also seems to have no affect on this bug.

Please find attached a project that reproduces the problem.

postgresBug.zip

I have also reported this to postgresJDBC project: pgjdbc/pgjdbc#2326

[NikolayMetchev]

Looks like it was a bug in the JDBC driver.