db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bpendle...@apache.org
Subject svn commit: r389575 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/ master/DerbyNet/ master/DerbyNet/jdk16/ master/DerbyNetClient/ master/DerbyNetClient/jdk16/ master/j9_foundation/ tests/jdbcapi/
Date Tue, 28 Mar 2006 18:58:11 GMT
Author: bpendleton
Date: Tue Mar 28 10:58:09 2006
New Revision: 389575

URL: http://svn.apache.org/viewcvs?rev=389575&view=rev
Log:
DERBY-1136: getFloat throws LossOfPrecisionConversionException on MAX_VALUE

This patch contains a regression test for DERBY-1136. The regression test
verifies that we can successfully retrieve a value of Float.MAX_VALUE
from the database using ResultSet.getFloat.

The test runs for both the embedded driver and the DerbyNetClient driver.
The test is dummied out for the JCC driver, since that driver still suffers
from this bug (but we want to share the same set of master files).


Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/resultset.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/resultset.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/resultset.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/resultset.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultset.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultset.out
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultset.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/resultset.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/resultset.out?rev=389575&r1=389574&r2=389575&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/resultset.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/resultset.out
Tue Mar 28 10:58:09 2006
@@ -1997,4 +1997,5 @@
 Testing nullif(?,BLOB(1k))
 Testing nullif(?,BLOB(1k)) with setBinaryStream
 ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported. : 
+DERBY-1136 fetched: 3.4028235E38
 Test resultset finished

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/resultset.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/resultset.out?rev=389575&r1=389574&r2=389575&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/resultset.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/resultset.out
Tue Mar 28 10:58:09 2006
@@ -1973,4 +1973,5 @@
 Testing nullif(?,BLOB(1k))
 Testing nullif(?,BLOB(1k)) with setBinaryStream
 ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
+DERBY-1136 fetched: 3.4028235E38
 Test resultset finished

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/resultset.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/resultset.out?rev=389575&r1=389574&r2=389575&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/resultset.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/resultset.out
Tue Mar 28 10:58:09 2006
@@ -1993,6 +1993,7 @@
 	{null}
 Testing nullif(?,BLOB(1k))
 ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported. : 
+DERBY-1136 fetched: 3.4028235E38
 Single RS auto-commit test: PASS.
 SingleRSCloseCursorsAtCommit: PASS.
 Test resultset finished

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/resultset.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/resultset.out?rev=389575&r1=389574&r2=389575&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/resultset.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/resultset.out
Tue Mar 28 10:58:09 2006
@@ -1969,6 +1969,7 @@
 	{null}
 Testing nullif(?,BLOB(1k))
 ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
+DERBY-1136 fetched: 3.4028235E38
 Single RS auto-commit test: PASS.
 SingleRSCloseCursorsAtCommit: PASS.
 Test resultset finished

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultset.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultset.out?rev=389575&r1=389574&r2=389575&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultset.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_foundation/resultset.out
Tue Mar 28 10:58:09 2006
@@ -1989,6 +1989,7 @@
 	{null}
 Testing nullif(?,BLOB(1k))
 ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
+DERBY-1136 fetched: 3.4028235E38
 Single RS auto-commit test: PASS.
 SingleRSCloseCursorsAtCommit: PASS.
 Checked class declared as: java.sql.ResultSet

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultset.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultset.out?rev=389575&r1=389574&r2=389575&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultset.out
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/resultset.out
Tue Mar 28 10:58:09 2006
@@ -1993,6 +1993,7 @@
 	{null}
 Testing nullif(?,BLOB(1k))
 ERROR 42818: Comparisons between 'BLOB' and 'BLOB' are not supported.
+DERBY-1136 fetched: 3.4028235E38
 Single RS auto-commit test: PASS.
 SingleRSCloseCursorsAtCommit: PASS.
 Checked class declared as: java.sql.ResultSet

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultset.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultset.java?rev=389575&r1=389574&r2=389575&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultset.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultset.java
Tue Mar 28 10:58:09 2006
@@ -620,6 +620,7 @@
 			testMutableValues(con);
 			testCorrelationNamesAndMetaDataCalls(con);
 			testNullIfAndMetaDataCalls(con);
+                        testFloatMAX_VALUE(con);
             //We know that JCC behavior does not match 
             //DerbyNetClient or embedded
             if (!TestUtil.isJCCFramework()) {
@@ -1091,6 +1092,29 @@
 		list.add(value);
 	}
     
+    // JIRA-1136: LossOfPrecisionConversionException fetching Float.MAX_VALUE.
+    // This test proves that we can successfully fetch that value from the DB
+    // Note that we still fail to fetch that value in the JCC driver, so we
+    // don't try this test under that framework, since it would fail, and we
+    // share masters for these tests.
+    private static void testFloatMAX_VALUE(Connection conn)
+        throws SQLException 
+    {
+        Statement stmt = conn.createStatement();
+        try { stmt.execute("drop table jira1136"); } catch (Throwable t) { }
+        stmt.execute("create table jira1136 (f float)");
+        stmt.execute("insert into jira1136 values (3.4028235E38)");
+        PreparedStatement ps = conn.prepareStatement("select * from jira1136");
+        ResultSet rs = ps.executeQuery();
+        while (rs.next())
+        {
+            if (!TestUtil.isJCCFramework())
+                System.out.println("DERBY-1136 fetched: " + rs.getFloat(1));
+            else // lie about the result so we can share the master files.
+                System.out.println("DERBY-1136 fetched: 3.4028235E38");
+        }
+    }
+
     /**
      * Helper method to set up and run the auto-commit tests.
      * 



Mime
View raw message