Changeset: 8b13d0941c61 for monetdb-java
URL: http://dev.monetdb.org/hg/monetdb-java?cmd=changeset;node=8b13d0941c61
Modified Files:
tests/BugDecimalRound_Bug_3561.java
Branch: default
Log Message:
Extended test for pstmt.setBigDecimal() with two more decmal values which will
be rounded.
diffs (41 lines):
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();
- stmt2 = con.createStatement();
- rs = stmt2.executeQuery("SELECT d FROM bug3561");
+ st.setBigDecimal(1, new BigDecimal("212.12345"));
+ st.executeUpdate();
+ 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();
}
}
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
