# HG changeset patch
# User Martin van Dinther <martin.van.dinther@monetdbsolutions.com>
# Date 1489079516 -3600
# Node ID 8b13d0941c61f272f9850739a1d880ee850f6fcd
# Parent  65b27b29ca711da8a5eb6c810879f2cc12602813
Extended test for pstmt.setBigDecimal() with two more decmal values which will be rounded.

diff --git a/tests/BugDecimalRound_Bug_3561.java b/tests/BugDecimalRound_Bug_3561.java
--- a/tests/BugDecimalRound_Bug_3561.java
+++ b/tests/BugDecimalRound_Bug_3561.java
@@ -13,22 +13,28 @@ public class BugDecimalRound_Bug_3561 {
 	public static void main(String[] args) throws Exception {
 		// Class.forName("nl.cwi.monetdb.jdbc.MonetDriver");	// not needed anymore for self registering JDBC drivers
 		Connection con = DriverManager.getConnection(args[0]);
+
 		Statement stmt1 = con.createStatement();
-		PreparedStatement st;
-		Statement stmt2;
-		ResultSet rs;
-		BigDecimal bd = new BigDecimal("112.125");
+		stmt1.executeUpdate("CREATE TABLE bug3561 (d decimal(14,4))");
 
-		stmt1.executeUpdate("CREATE TABLE bug3561 (d decimal(14,4))");
-		st = con.prepareStatement("INSERT INTO bug3561 VALUES (?)");
-		st.setBigDecimal(1, bd);
+		PreparedStatement st = con.prepareStatement("INSERT INTO bug3561 VALUES (?)");
+		st.setBigDecimal(1, new BigDecimal("112.125"));
+		st.executeUpdate();
+		st.setBigDecimal(1, new BigDecimal("212.12345"));
 		st.executeUpdate();
-		stmt2 = con.createStatement();
-		rs = stmt2.executeQuery("SELECT d FROM bug3561");
+		st.setBigDecimal(1, new BigDecimal("0.012345"));
+		st.executeUpdate();
+		st.close();
+
+		Statement stmt2 = con.createStatement();
+		ResultSet rs = stmt2.executeQuery("SELECT d FROM bug3561");
 		while (rs.next())
 			System.out.println(rs.getString(1));
 		rs.close();
+		stmt2.close();
+
 		stmt1.executeUpdate("DROP TABLE bug3561");
+		stmt1.close();
 		con.close();
 	}
 }