Hi Søren,
thank you for your patch, I have added it to the MonetDB repository.
https://dev.monetdb.org/hg/MonetDB/rev/3ea8fee77829
Hannes
On 29 Oct 2015, at 13:46, Søren Haagerup sh@sigmaanalytics.dk wrote:
Hello developers,
I found a bug when using BigDecimals in prepared statements with MonetDB¹s JDBC driver.
If I have a column of type DECIMAL(15,2) and insert a big decimal with the value 627000.00 through a PreparedStatement, it will turn out as 630000.00 in the DB, since the MonetDB JDBC driver currently mixes up "precision" and "scale", and rounds 627000.00 to a precision of 2 ciphers.
I made a bugfix for it, and it can be seen here: https://github.com/shaagerup/monet-jdbc/commit/ ebc5e654dc28e3b56d4c4b610d3d339e675d6c2c
I¹m sorry for not committing it directly to your repository, but since I am not a Mercurial user, I hope someone else will use this information to improve the official JDBC driver.
Best regards Søren Haagerup
developers-list mailing list developers-list@monetdb.org https://www.monetdb.org/mailman/listinfo/developers-list