You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ba...@apache.org on 2005/02/09 20:29:49 UTC
svn commit: r153109 - in incubator/derby/code/trunk/java:
engine/org/apache/derby/iapi/types/
testing/org/apache/derbyTesting/functionTests/master/
Author: bandaram
Date: Wed Feb 9 11:29:47 2005
New Revision: 153109
URL: http://svn.apache.org/viewcvs?view=rev&rev=153109
Log:
Derby-123: Derby incorrectly rounds double/real values during conversion to DECIMAL types.
Patch contributed by Shreyas Kaushik. (Shreyas.Kaushik@Sun.COM)
Modified:
incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLDecimal.java
incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLDouble.java
incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLReal.java
incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/UserType.java
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/outparams.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMapping.out
Modified: incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLDecimal.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLDecimal.java?view=diff&r1=153108&r2=153109
==============================================================================
--- incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLDecimal.java (original)
+++ incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLDecimal.java Wed Feb 9 11:29:47 2005
@@ -371,7 +371,7 @@
}
else if (theValue instanceof Number)
{
- value = new BigDecimal(((Number)theValue).doubleValue());
+ value = new BigDecimal(Double.toString(((Number)theValue).doubleValue()));
}
else
{
@@ -720,7 +720,7 @@
}
private void setCoreValue(double theValue) {
- value = new BigDecimal(theValue);
+ value = new BigDecimal(Double.toString(theValue));
rawData = null;
}
Modified: incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLDouble.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLDouble.java?view=diff&r1=153108&r2=153109
==============================================================================
--- incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLDouble.java (original)
+++ incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLDouble.java Wed Feb 9 11:29:47 2005
@@ -153,7 +153,7 @@
public BigDecimal getBigDecimal()
{
if (isNull()) return null;
- return new BigDecimal(value);
+ return new BigDecimal(Double.toString(value));
}
// for lack of a specification: getDouble()==0 gives true
Modified: incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLReal.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLReal.java?view=diff&r1=153108&r2=153109
==============================================================================
--- incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLReal.java (original)
+++ incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLReal.java Wed Feb 9 11:29:47 2005
@@ -161,7 +161,7 @@
public BigDecimal getBigDecimal()
{
if (isNull()) return null;
- return new BigDecimal(value);
+ return new BigDecimal(Float.toString(value));
}
// for lack of a specification: 0 or null is false,
Modified: incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/UserType.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/UserType.java?view=diff&r1=153108&r2=153109
==============================================================================
--- incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/UserType.java (original)
+++ incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/UserType.java Wed Feb 9 11:29:47 2005
@@ -195,7 +195,7 @@
if (value instanceof BigDecimal) return ((BigDecimal)value);
if (value instanceof Number)
- return new BigDecimal(((Number) value).doubleValue());
+ return new BigDecimal(Double.toString(((Number) value).doubleValue()));
}
return super.getBigDecimal();
}
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out?view=diff&r1=153108&r2=153109
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dml099.out Wed Feb 9 11:29:47 2005
@@ -47,7 +47,7 @@
SELECT C1, C2, C3 FROM ICAST2;
C1 |C2 |C3
-------------------------------------------
-2 |2.1 |9.099
+2 |2.1 |9.100
ij> -- PASS:0582 If 1 row is selected with C1 = 2 and C3 = 9.100?
ROLLBACK WORK;
ij> --O DROP TABLE ICAST2 CASCADE;
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out?view=diff&r1=153108&r2=153109
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/ejbql.out Wed Feb 9 11:29:47 2005
@@ -868,8 +868,8 @@
100000000
-100000000
NULL
-1000000000000000019884624838656
--1000000000000000019884624838656
+1000000000000000000000000000000
+-1000000000000000000000000000000
ij> select -a from myDecimal;
1
--------------------------------
@@ -881,8 +881,8 @@
-100000000
100000000
NULL
--1000000000000000019884624838656
-1000000000000000019884624838656
+-1000000000000000000000000000000
+1000000000000000000000000000000
ij> select b from myDecimal;
B
----------------------------------
@@ -891,8 +891,8 @@
0.0000000000000000000000000000000
0.0000000000000000000000000000000
0.0000000000000000000000000000000
-0.1000000000000000055511151231257
--0.1000000000000000055511151231257
+0.1000000000000000000000000000000
+-0.1000000000000000000000000000000
NULL
0.0000000000000000000000000000010
-0.0000000000000000000000000000010
@@ -904,8 +904,8 @@
0.0000000000000000000000000000000
0.0000000000000000000000000000000
0.0000000000000000000000000000000
--0.1000000000000000055511151231257
-0.1000000000000000055511151231257
+-0.1000000000000000000000000000000
+0.1000000000000000000000000000000
NULL
-0.0000000000000000000000000000010
0.0000000000000000000000000000010
@@ -920,8 +920,8 @@
100000000
100000000
NULL
-1000000000000000019884624838656
-1000000000000000019884624838656
+1000000000000000000000000000000
+1000000000000000000000000000000
ij> select abs(-a) from myDecimal;
1
--------------------------------
@@ -933,8 +933,8 @@
100000000
100000000
NULL
-1000000000000000019884624838656
-1000000000000000019884624838656
+1000000000000000000000000000000
+1000000000000000000000000000000
ij> select -abs(a) from myDecimal;
1
--------------------------------
@@ -946,8 +946,8 @@
-100000000
-100000000
NULL
--1000000000000000019884624838656
--1000000000000000019884624838656
+-1000000000000000000000000000000
+-1000000000000000000000000000000
ij> select abs(abs(-abs(-abs(a)))) from myDecimal;
1
--------------------------------
@@ -959,8 +959,8 @@
100000000
100000000
NULL
-1000000000000000019884624838656
-1000000000000000019884624838656
+1000000000000000000000000000000
+1000000000000000000000000000000
ij> SELECT ABSVAL(ABSVAL(-ABSVAL(-ABSVAL(A)))) FROM MYDECIMAL;
1
--------------------------------
@@ -972,15 +972,15 @@
100000000
100000000
NULL
-1000000000000000019884624838656
-1000000000000000019884624838656
+1000000000000000000000000000000
+1000000000000000000000000000000
ij> select distinct abs(a) from myDecimal;
1
--------------------------------
0
1
100000000
-1000000000000000019884624838656
+1000000000000000000000000000000
NULL
ij> select abs(b) from myDecimal;
1
@@ -990,8 +990,8 @@
0.0000000000000000000000000000000
0.0000000000000000000000000000000
0.0000000000000000000000000000000
-0.1000000000000000055511151231257
-0.1000000000000000055511151231257
+0.1000000000000000000000000000000
+0.1000000000000000000000000000000
NULL
0.0000000000000000000000000000010
0.0000000000000000000000000000010
@@ -1003,8 +1003,8 @@
0.0000000000000000000000000000000
0.0000000000000000000000000000000
0.0000000000000000000000000000000
-0.1000000000000000055511151231257
-0.1000000000000000055511151231257
+0.1000000000000000000000000000000
+0.1000000000000000000000000000000
NULL
0.0000000000000000000000000000010
0.0000000000000000000000000000010
@@ -1016,8 +1016,8 @@
0.0000000000000000000000000000000
0.0000000000000000000000000000000
0.0000000000000000000000000000000
--0.1000000000000000055511151231257
--0.1000000000000000055511151231257
+-0.1000000000000000000000000000000
+-0.1000000000000000000000000000000
NULL
-0.0000000000000000000000000000010
-0.0000000000000000000000000000010
@@ -1029,8 +1029,8 @@
0.0000000000000000000000000000000
0.0000000000000000000000000000000
0.0000000000000000000000000000000
-0.1000000000000000055511151231257
-0.1000000000000000055511151231257
+0.1000000000000000000000000000000
+0.1000000000000000000000000000000
NULL
0.0000000000000000000000000000010
0.0000000000000000000000000000010
@@ -1042,8 +1042,8 @@
0.0000000000000000000000000000000
0.0000000000000000000000000000000
0.0000000000000000000000000000000
-0.1000000000000000055511151231257
-0.1000000000000000055511151231257
+0.1000000000000000000000000000000
+0.1000000000000000000000000000000
NULL
0.0000000000000000000000000000010
0.0000000000000000000000000000010
@@ -1052,7 +1052,7 @@
----------------------------------
0.0000000000000000000000000000000
0.0000000000000000000000000000010
-0.1000000000000000055511151231257
+0.1000000000000000000000000000000
NULL
ij> -- There is nothing wrong with returning 1.0. The decimal overflows and this is just the way it behaves. Needs to make this compatible with jdk1.1.8(which had a bug).
select abs(-abs(a)) + 1 from myDecimal;
@@ -1066,8 +1066,8 @@
100000001
100000001
NULL
-1000000000000000019884624838657
-1000000000000000019884624838657
+1000000000000000000000000000001
+1000000000000000000000000000001
ij> drop table myDecimal;
0 rows inserted/updated/deleted
ij> -- End of Decimal test
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out?view=diff&r1=153108&r2=153109
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/floattypes.out Wed Feb 9 11:29:47 2005
@@ -606,7 +606,7 @@
ij> values cast(1.7e30 as dec(31));
1
--------------------------------
-1700000000000000118246355238912
+1700000000000000000000000000000
ij> --try a tiny number
-- the following seems to be asking a bit
-- too much of poor old biginteger, so try
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/outparams.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/outparams.out?view=diff&r1=153108&r2=153109
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/outparams.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/outparams.out Wed Feb 9 11:29:47 2005
@@ -946,8 +946,8 @@
getFloat(1) = 2.0
getFloat(1) = 2.0
getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
+ getBigDecimal(1) = 2.0
+ getBigDecimal(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
@@ -970,8 +970,8 @@
getFloat(1) = 2.0
getFloat(1) = 2.0
getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
+ getBigDecimal(1) = 2.0
+ getBigDecimal(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
@@ -994,8 +994,8 @@
getFloat(1) = 12.0
getFloat(1) = 12.0
getDouble(1) = 12.0
- getBigDecimal(1) = 12
- getBigDecimal(1) = 12
+ getBigDecimal(1) = 12.0
+ getBigDecimal(1) = 12.0
getString(1) = 12.0
getString(1) = 12.0
getString(1) = 12.0
@@ -1018,8 +1018,8 @@
getFloat(1) = 132.0
getFloat(1) = 132.0
getDouble(1) = 132.0
- getBigDecimal(1) = 132
- getBigDecimal(1) = 132
+ getBigDecimal(1) = 132.0
+ getBigDecimal(1) = 132.0
getString(1) = 132.0
getString(1) = 132.0
getString(1) = 132.0
@@ -1042,8 +1042,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -1066,8 +1066,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -1090,8 +1090,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -1114,8 +1114,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -1138,8 +1138,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -1162,8 +1162,8 @@
getFloat(1) = 1333.332
getFloat(1) = 1333.332
getDouble(1) = 1333.33203125
- getBigDecimal(1) = 1333.33203125
- getBigDecimal(1) = 1333.33203125
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
@@ -1186,8 +1186,8 @@
getFloat(1) = 1333.332
getFloat(1) = 1333.332
getDouble(1) = 1333.33203125
- getBigDecimal(1) = 1333.33203125
- getBigDecimal(1) = 1333.33203125
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
@@ -1235,8 +1235,8 @@
getFloat(1) = 2.0
getFloat(1) = 2.0
getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
+ getBigDecimal(1) = 2.0
+ getBigDecimal(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
@@ -1259,8 +1259,8 @@
getFloat(1) = 2.0
getFloat(1) = 2.0
getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
+ getBigDecimal(1) = 2.0
+ getBigDecimal(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
@@ -1283,8 +1283,8 @@
getFloat(1) = 12.0
getFloat(1) = 12.0
getDouble(1) = 12.0
- getBigDecimal(1) = 12
- getBigDecimal(1) = 12
+ getBigDecimal(1) = 12.0
+ getBigDecimal(1) = 12.0
getString(1) = 12.0
getString(1) = 12.0
getString(1) = 12.0
@@ -1307,8 +1307,8 @@
getFloat(1) = 132.0
getFloat(1) = 132.0
getDouble(1) = 132.0
- getBigDecimal(1) = 132
- getBigDecimal(1) = 132
+ getBigDecimal(1) = 132.0
+ getBigDecimal(1) = 132.0
getString(1) = 132.0
getString(1) = 132.0
getString(1) = 132.0
@@ -1331,8 +1331,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -1355,8 +1355,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -1379,8 +1379,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -1403,8 +1403,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -1427,8 +1427,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -1451,8 +1451,8 @@
getFloat(1) = 1333.332
getFloat(1) = 1333.332
getDouble(1) = 1333.332
- getBigDecimal(1) = 1333.332000000000107320374809205532073974609375
- getBigDecimal(1) = 1333.332000000000107320374809205532073974609375
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
@@ -1475,8 +1475,8 @@
getFloat(1) = 1333.332
getFloat(1) = 1333.332
getDouble(1) = 1333.332
- getBigDecimal(1) = 1333.332000000000107320374809205532073974609375
- getBigDecimal(1) = 1333.332000000000107320374809205532073974609375
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
@@ -3506,8 +3506,8 @@
getFloat(1) = 2.0
getFloat(1) = 2.0
getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
+ getBigDecimal(1) = 2.0
+ getBigDecimal(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
@@ -3530,8 +3530,8 @@
getFloat(1) = 2.0
getFloat(1) = 2.0
getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
+ getBigDecimal(1) = 2.0
+ getBigDecimal(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
@@ -3554,8 +3554,8 @@
getFloat(1) = 12.0
getFloat(1) = 12.0
getDouble(1) = 12.0
- getBigDecimal(1) = 12
- getBigDecimal(1) = 12
+ getBigDecimal(1) = 12.0
+ getBigDecimal(1) = 12.0
getString(1) = 12.0
getString(1) = 12.0
getString(1) = 12.0
@@ -3578,8 +3578,8 @@
getFloat(1) = 132.0
getFloat(1) = 132.0
getDouble(1) = 132.0
- getBigDecimal(1) = 132
- getBigDecimal(1) = 132
+ getBigDecimal(1) = 132.0
+ getBigDecimal(1) = 132.0
getString(1) = 132.0
getString(1) = 132.0
getString(1) = 132.0
@@ -3602,8 +3602,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -3626,8 +3626,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -3650,8 +3650,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -3674,8 +3674,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -3698,8 +3698,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -3722,8 +3722,8 @@
getFloat(1) = 1333.332
getFloat(1) = 1333.332
getDouble(1) = 1333.33203125
- getBigDecimal(1) = 1333.33203125
- getBigDecimal(1) = 1333.33203125
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
@@ -3746,8 +3746,8 @@
getFloat(1) = 1333.332
getFloat(1) = 1333.332
getDouble(1) = 1333.33203125
- getBigDecimal(1) = 1333.33203125
- getBigDecimal(1) = 1333.33203125
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
@@ -3795,8 +3795,8 @@
getFloat(1) = 2.0
getFloat(1) = 2.0
getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
+ getBigDecimal(1) = 2.0
+ getBigDecimal(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
@@ -3819,8 +3819,8 @@
getFloat(1) = 2.0
getFloat(1) = 2.0
getDouble(1) = 2.0
- getBigDecimal(1) = 2
- getBigDecimal(1) = 2
+ getBigDecimal(1) = 2.0
+ getBigDecimal(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
getString(1) = 2.0
@@ -3843,8 +3843,8 @@
getFloat(1) = 12.0
getFloat(1) = 12.0
getDouble(1) = 12.0
- getBigDecimal(1) = 12
- getBigDecimal(1) = 12
+ getBigDecimal(1) = 12.0
+ getBigDecimal(1) = 12.0
getString(1) = 12.0
getString(1) = 12.0
getString(1) = 12.0
@@ -3867,8 +3867,8 @@
getFloat(1) = 132.0
getFloat(1) = 132.0
getDouble(1) = 132.0
- getBigDecimal(1) = 132
- getBigDecimal(1) = 132
+ getBigDecimal(1) = 132.0
+ getBigDecimal(1) = 132.0
getString(1) = 132.0
getString(1) = 132.0
getString(1) = 132.0
@@ -3891,8 +3891,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -3915,8 +3915,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -3939,8 +3939,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -3963,8 +3963,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -3987,8 +3987,8 @@
getFloat(1) = 1332.0
getFloat(1) = 1332.0
getDouble(1) = 1332.0
- getBigDecimal(1) = 1332
- getBigDecimal(1) = 1332
+ getBigDecimal(1) = 1332.0
+ getBigDecimal(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
getString(1) = 1332.0
@@ -4011,8 +4011,8 @@
getFloat(1) = 1333.332
getFloat(1) = 1333.332
getDouble(1) = 1333.332
- getBigDecimal(1) = 1333.332000000000107320374809205532073974609375
- getBigDecimal(1) = 1333.332000000000107320374809205532073974609375
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
@@ -4035,8 +4035,8 @@
getFloat(1) = 1333.332
getFloat(1) = 1333.332
getDouble(1) = 1333.332
- getBigDecimal(1) = 1333.332000000000107320374809205532073974609375
- getBigDecimal(1) = 1333.332000000000107320374809205532073974609375
+ getBigDecimal(1) = 1333.332
+ getBigDecimal(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
getString(1) = 1333.332
@@ -6426,8 +6426,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6449,8 +6449,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6472,8 +6472,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6495,8 +6495,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6518,8 +6518,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6541,8 +6541,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6564,8 +6564,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6587,8 +6587,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6610,8 +6610,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6633,8 +6633,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6656,8 +6656,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6679,8 +6679,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6702,8 +6702,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6725,8 +6725,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6764,8 +6764,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6787,8 +6787,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6810,8 +6810,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6833,8 +6833,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6856,8 +6856,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6879,8 +6879,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6902,8 +6902,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6925,8 +6925,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6948,8 +6948,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6971,8 +6971,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -6994,8 +6994,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -7017,8 +7017,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -7040,8 +7040,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
@@ -7063,8 +7063,8 @@
getFloat(1) = 666.0
getFloat(1) = 666.0
getDouble(1) = 666.0
- getBigDecimal(1) = 666
- getBigDecimal(1) = 666
+ getBigDecimal(1) = 666.0
+ getBigDecimal(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
getString(1) = 666.0
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMapping.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMapping.out?view=diff&r1=153108&r2=153109
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMapping.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/parameterMapping.out Wed Feb 9 11:29:47 2005
@@ -557,7 +557,7 @@
getLong=32 was null false JDBC MATCH(OK)
getFloat=32.0 was null false JDBC MATCH(OK)
getDouble=32.0 was null false JDBC MATCH(OK)
- getBigDecimal=32 was null false JDBC MATCH(OK)
+ getBigDecimal=32.0 was null false JDBC MATCH(OK)
getBoolean=true was null false JDBC MATCH(OK)
getString=32.0 was null false JDBC MATCH(OK)
getBytes=IC JDBC MATCH (INVALID)
@@ -671,8 +671,8 @@
P3=cs.getDouble=88.80000305175781 was null false
INOUT REAL registerOutParameter(Types.DECIMAL) -- OK
OUT REAL registerOutParameter(Types.DECIMAL) -- OK
-P2=cs.getBigDecimal=41.90000152587890625 was null false
-P3=cs.getBigDecimal=88.8000030517578125 was null false
+P2=cs.getBigDecimal=41.9 was null false
+P3=cs.getBigDecimal=88.8 was null false
INOUT REAL registerOutParameter(Types.NUMERIC) -- OK
OUT REAL registerOutParameter(Types.NUMERIC) -- OK
INOUT REAL registerOutParameter(Types.BIT) -- OK
@@ -733,7 +733,7 @@
getLong=32 was null false JDBC MATCH(OK)
getFloat=32.0 was null false JDBC MATCH(OK)
getDouble=32.0 was null false JDBC MATCH(OK)
- getBigDecimal=32 was null false JDBC MATCH(OK)
+ getBigDecimal=32.0 was null false JDBC MATCH(OK)
getBoolean=true was null false JDBC MATCH(OK)
getString=32.0 was null false JDBC MATCH(OK)
getBytes=IC JDBC MATCH (INVALID)
@@ -847,8 +847,8 @@
P3=cs.getDouble=66.8 was null false
INOUT FLOAT registerOutParameter(Types.DECIMAL) -- OK
OUT FLOAT registerOutParameter(Types.DECIMAL) -- OK
-P2=cs.getBigDecimal=35.89999999999999857891452847979962825775146484375 was null false
-P3=cs.getBigDecimal=66.7999999999999971578290569595992565155029296875 was null false
+P2=cs.getBigDecimal=35.9 was null false
+P3=cs.getBigDecimal=66.8 was null false
INOUT FLOAT registerOutParameter(Types.NUMERIC) -- OK
OUT FLOAT registerOutParameter(Types.NUMERIC) -- OK
INOUT FLOAT registerOutParameter(Types.BIT) -- OK
@@ -908,7 +908,7 @@
getLong=32 was null false JDBC MATCH(OK)
getFloat=32.0 was null false JDBC MATCH(OK)
getDouble=32.0 was null false JDBC MATCH(OK)
- getBigDecimal=32 was null false JDBC MATCH(OK)
+ getBigDecimal=32.0 was null false JDBC MATCH(OK)
getBoolean=true was null false JDBC MATCH(OK)
getString=32.0 was null false JDBC MATCH(OK)
getBytes=IC JDBC MATCH (INVALID)
@@ -1022,8 +1022,8 @@
P3=cs.getDouble=66.8 was null false
INOUT DOUBLE registerOutParameter(Types.DECIMAL) -- OK
OUT DOUBLE registerOutParameter(Types.DECIMAL) -- OK
-P2=cs.getBigDecimal=35.89999999999999857891452847979962825775146484375 was null false
-P3=cs.getBigDecimal=66.7999999999999971578290569595992565155029296875 was null false
+P2=cs.getBigDecimal=35.9 was null false
+P3=cs.getBigDecimal=66.8 was null false
INOUT DOUBLE registerOutParameter(Types.NUMERIC) -- OK
OUT DOUBLE registerOutParameter(Types.NUMERIC) -- OK
INOUT DOUBLE registerOutParameter(Types.BIT) -- OK