db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From davi...@apache.org
Subject svn commit: r386169 [35/36] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master: DerbyNet/jdk16/ DerbyNetClient/jdk16/ jdk16/
Date Wed, 15 Mar 2006 21:31:59 GMT
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/parameterMapping.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/parameterMapping.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/parameterMapping.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk16/parameterMapping.out Wed Mar 15 13:31:53 2006
@@ -0,0 +1,3585 @@
+Test parameterMapping starting
+STILL TO RESOLVE -- Cloudscape getBoolean() allow conversion on strings to match JCC
+STILL TO RESOLVE -- Cloudscape getXXX() disable on LOBs.
+getXXX on : -6
+  skipping
+getXXX on : SMALLINT
+ NULL VALUE
+  getByte=0 was null true JDBC MATCH(OK)
+  getShort=0 was null true JDBC MATCH(OK)
+  getInt=0 was null true JDBC MATCH(OK)
+  getLong=0 was null true JDBC MATCH(OK)
+  getFloat=0.0 was null true JDBC MATCH(OK)
+  getDouble=0.0 was null true JDBC MATCH(OK)
+  getBigDecimal=null was null true JDBC MATCH(OK)
+  getBoolean=false was null true JDBC MATCH(OK)
+  getString=null was null true JDBC MATCH(OK)
+  getBytes=null was null true CLOUD EXT (OK)
+  getDate=null was null true CLOUD EXT (OK)
+  getTime=null was null true CLOUD EXT (OK)
+  getTimestamp=null was null true CLOUD EXT (OK)
+  getAsciiStream=SPECIFIC CHECK OK
+  getBinaryStream=SPECIFIC CHECK OK
+  getCharacterStream=SPECIFIC CHECK OK
+  getClob=SPECIFIC CHECK OK
+  getBlob=SPECIFIC CHECK OK
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=null was null true
+ VALID VALUE
+  getByte=32 was null false JDBC MATCH(OK)
+  getShort=32 was null false JDBC MATCH(OK)
+  getInt=32 was null false JDBC MATCH(OK)
+  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)
+  getBoolean=true was null false JDBC MATCH(OK)
+  getString=32 was null false JDBC MATCH(OK)
+  getBytes=IC JDBC MATCH (INVALID)
+  getDate=IC JDBC MATCH (INVALID)
+  getTime=IC JDBC MATCH (INVALID)
+  getTimestamp=IC JDBC MATCH (INVALID)
+  getAsciiStream=IC JDBC MATCH (INVALID)
+  getBinaryStream=IC JDBC MATCH (INVALID)
+  getCharacterStream=IC JDBC MATCH (INVALID)
+  getClob=IC JDBC MATCH (INVALID)
+  getBlob=IC JDBC MATCH (INVALID)
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=CORRECT :java.lang.Integer was null false
+setNull() with all JDBC Types on SMALLINT
+  setNull(Types.TINYINT) getShort=0 was null true
+  setNull with batching support(Types.TINYINT) getShort=0 was null true
+  setNull(SMALLINT) getShort=0 was null true
+  setNull with batching support(SMALLINT) getShort=0 was null true
+  setNull(INTEGER) getShort=0 was null true
+  setNull with batching support(INTEGER) getShort=0 was null true
+  setNull(BIGINT) getShort=0 was null true
+  setNull with batching support(BIGINT) getShort=0 was null true
+  setNull(REAL) getShort=0 was null true
+  setNull with batching support(REAL) getShort=0 was null true
+  setNull(Types.FLOAT) getShort=0 was null true
+  setNull with batching support(Types.FLOAT) getShort=0 was null true
+  setNull(DOUBLE) getShort=0 was null true
+  setNull with batching support(DOUBLE) getShort=0 was null true
+  setNull(DECIMAL) getShort=0 was null true
+  setNull with batching support(DECIMAL) getShort=0 was null true
+  setNull(Types.NUMERIC) getShort=0 was null true
+  setNull with batching support(Types.NUMERIC) getShort=0 was null true
+  setNull(Types.BIT) getShort=0 was null true
+  setNull with batching support(Types.BIT) getShort=0 was null true
+  setNull(CHAR) getShort=0 was null true
+  setNull with batching support(CHAR) getShort=0 was null true
+  setNull(VARCHAR) getShort=0 was null true
+  setNull with batching support(VARCHAR) getShort=0 was null true
+  setNull(LONG VARCHAR) getShort=0 was null true
+  setNull with batching support(LONG VARCHAR) getShort=0 was null true
+  setNull(VARCHAR () FOR BIT DATA) IC
+  setNull with batching support(VARCHAR () FOR BIT DATA) IC
+  setNull(DATE) IC
+  setNull with batching support(DATE) IC
+  setNull(TIME) IC
+  setNull with batching support(TIME) IC
+  setNull(TIMESTAMP) IC
+  setNull with batching support(TIMESTAMP) IC
+  setNull(CLOB) IC
+  setNull with batching support(CLOB) IC
+  setNull(BLOB) IC
+  setNull with batching support(BLOB) IC
+  setNull(Types.NULL) IC
+  setNull with batching support(Types.NULL) IC
+  setNull(235350345) IC
+  setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on SMALLINT
+For setXXX() methods that pass an object, a null and valid values are checked
+  setByte() getShort=98 was null false JDBC MATCH(OK)
+  setByte() as batch getShort=98 was null false JDBC MATCH(OK)
+  setShort() getShort=98 was null false JDBC MATCH(OK)
+  setShort() as batch getShort=98 was null false JDBC MATCH(OK)
+  setInt() getShort=98 was null false JDBC MATCH(OK)
+  setInt() as batch getShort=98 was null false JDBC MATCH(OK)
+  setLong() getShort=98 was null false JDBC MATCH(OK)
+  setLong() as batch getShort=98 was null false JDBC MATCH(OK)
+  setFloat() getShort=98 was null false JDBC MATCH(OK)
+  setFloat() as batch getShort=98 was null false JDBC MATCH(OK)
+  setDouble() getShort=98 was null false JDBC MATCH(OK)
+  setDouble() as batch getShort=98 was null false JDBC MATCH(OK)
+  setBigDecimal() getShort=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getShort=99 was null false JDBC MATCH(OK)
+  setBigDecimal(null) getShort=0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getShort=0 was null true JDBC MATCH(OK)
+  setBoolean() getShort=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getShort=1 was null false JDBC MATCH(OK)
+  setString() getShort=97 was null false JDBC MATCH(OK)
+  setString() as batch getShort=97 was null false JDBC MATCH(OK)
+  setString(null) getShort=0 was null true JDBC MATCH(OK)
+  setString(null) as batch getShort=0 was null true JDBC MATCH(OK)
+ setString("Invalid Value")  IC (Expected)
+  setBytes() IC JDBC MATCH (INVALID)
+  setBytes() as batchIC JDBC MATCH (INVALID)
+  setBytes(null) IC JDBC MATCH (INVALID)
+  setBytes(null) as batchIC JDBC MATCH (INVALID)
+  setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
+  setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
+  setTime() IC JDBC MATCH (INVALID)
+  setTime() as batch IC JDBC MATCH (INVALID)
+  setTime(null) IC JDBC MATCH (INVALID)
+  setTime(null) as batch IC JDBC MATCH (INVALID)
+  setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
+  setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream() as batch IC JDBC MATCH (INVALID)
+  setAsciiStream(null) IC JDBC MATCH (INVALID)
+  setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+  setBinaryStream() IC JDBC MATCH (INVALID)
+  setBinaryStream() as batch IC JDBC MATCH (INVALID)
+  setBinaryStream(null) IC JDBC MATCH (INVALID)
+  setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() as batch IC JDBC MATCH (INVALID)
+  setCharacterStream(null) IC JDBC MATCH (INVALID)
+  setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+  setClob() IC JDBC MATCH (INVALID)
+  setClob() as batch IC JDBC MATCH (INVALID)
+  setClob(null) IC JDBC MATCH (INVALID)
+  setClob(null) as batch IC JDBC MATCH (INVALID)
+  setBlob() IC JDBC MATCH (INVALID)
+  setBlob() as batch IC JDBC MATCH (INVALID)
+  setBlob(null) IC JDBC MATCH (INVALID)
+  setBlob(null) as batch IC JDBC MATCH (INVALID)
+  setUnicodeStream()  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setUnicodeStream(null)  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setObject(null)  OK An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'null'.
+  setObject(null) as batch  OK An attempt was made to get a data value of type 'SMALLINT' from a data value of type 'null'.
+  setObject(java.lang.String) getShort=46 was null false JDBC MATCH(OK)
+  setObject(java.lang.String) as batch getShort=46 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) getShort=72 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) as batch getShort=72 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) getShort=1 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) as batch getShort=1 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) getShort=74 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) as batch getShort=74 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) getShort=79 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) as batch getShort=79 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) getShort=76 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) as batch getShort=76 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) getShort=12 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) as batch getShort=12 was null false JDBC MATCH(OK)
+  setObject(byte[]) IC JDBC MATCH (INVALID)
+  setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 SMALLINT, INOUT P2 SMALLINT, OUT P3 SMALLINT) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
+INOUT SMALLINT registerOutParameter(Types.TINYINT) -- OK
+OUT SMALLINT registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=38 was null false
+P3=cs.getByte=77 was null false
+INOUT SMALLINT registerOutParameter(Types.SMALLINT) -- OK
+OUT SMALLINT registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=38 was null false
+P3=cs.getShort=77 was null false
+INOUT SMALLINT registerOutParameter(Types.INTEGER) -- OK
+OUT SMALLINT registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=38 was null false
+P3=cs.getInt=77 was null false
+INOUT SMALLINT registerOutParameter(Types.BIGINT) -- OK
+OUT SMALLINT registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=38 was null false
+P3=cs.getLong=77 was null false
+INOUT SMALLINT registerOutParameter(Types.REAL) -- OK
+OUT SMALLINT registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=38.0 was null false
+P3=cs.getFloat=77.0 was null false
+INOUT SMALLINT registerOutParameter(Types.FLOAT) -- OK
+OUT SMALLINT registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=38.0 was null false
+P3=cs.getDouble=77.0 was null false
+INOUT SMALLINT registerOutParameter(Types.DOUBLE) -- OK
+OUT SMALLINT registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=38.0 was null false
+P3=cs.getDouble=77.0 was null false
+INOUT SMALLINT registerOutParameter(Types.DECIMAL) -- OK
+OUT SMALLINT registerOutParameter(Types.DECIMAL) -- OK
+P2=cs.getBigDecimal=38 was null false
+P3=cs.getBigDecimal=77 was null false
+INOUT SMALLINT registerOutParameter(Types.NUMERIC) -- OK
+OUT SMALLINT registerOutParameter(Types.NUMERIC) -- OK
+INOUT SMALLINT registerOutParameter(Types.BIT) -- OK
+OUT SMALLINT registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT SMALLINT registerOutParameter(Types.CHAR) -- OK
+OUT SMALLINT registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=38 was null false
+P3=cs.getString=77 was null false
+INOUT SMALLINT registerOutParameter(Types.VARCHAR) -- OK
+OUT SMALLINT registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=38 was null false
+P3=cs.getString=77 was null false
+INOUT SMALLINT registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT SMALLINT registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=38 was null false
+P3=cs.getString=77 was null false
+INOUT SMALLINT registerOutParameter(Types.VARBINARY) -- XCL25
+OUT SMALLINT registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT SMALLINT registerOutParameter(Types.DATE) -- XCL25
+OUT SMALLINT registerOutParameter(Types.DATE) -- XCL25
+INOUT SMALLINT registerOutParameter(Types.TIME) -- XCL25
+OUT SMALLINT registerOutParameter(Types.TIME) -- XCL25
+INOUT SMALLINT registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT SMALLINT registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT SMALLINT registerOutParameter(Types.CLOB) -- XCL25
+OUT SMALLINT registerOutParameter(Types.CLOB) -- XCL25
+INOUT SMALLINT registerOutParameter(Types.BLOB) -- XCL25
+OUT SMALLINT registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : INTEGER
+ NULL VALUE
+  getByte=0 was null true JDBC MATCH(OK)
+  getShort=0 was null true JDBC MATCH(OK)
+  getInt=0 was null true JDBC MATCH(OK)
+  getLong=0 was null true JDBC MATCH(OK)
+  getFloat=0.0 was null true JDBC MATCH(OK)
+  getDouble=0.0 was null true JDBC MATCH(OK)
+  getBigDecimal=null was null true JDBC MATCH(OK)
+  getBoolean=false was null true JDBC MATCH(OK)
+  getString=null was null true JDBC MATCH(OK)
+  getBytes=null was null true CLOUD EXT (OK)
+  getDate=null was null true CLOUD EXT (OK)
+  getTime=null was null true CLOUD EXT (OK)
+  getTimestamp=null was null true CLOUD EXT (OK)
+  getAsciiStream=SPECIFIC CHECK OK
+  getBinaryStream=SPECIFIC CHECK OK
+  getCharacterStream=SPECIFIC CHECK OK
+  getClob=SPECIFIC CHECK OK
+  getBlob=SPECIFIC CHECK OK
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=null was null true
+ VALID VALUE
+  getByte=32 was null false JDBC MATCH(OK)
+  getShort=32 was null false JDBC MATCH(OK)
+  getInt=32 was null false JDBC MATCH(OK)
+  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)
+  getBoolean=true was null false JDBC MATCH(OK)
+  getString=32 was null false JDBC MATCH(OK)
+  getBytes=IC JDBC MATCH (INVALID)
+  getDate=IC JDBC MATCH (INVALID)
+  getTime=IC JDBC MATCH (INVALID)
+  getTimestamp=IC JDBC MATCH (INVALID)
+  getAsciiStream=IC JDBC MATCH (INVALID)
+  getBinaryStream=IC JDBC MATCH (INVALID)
+  getCharacterStream=IC JDBC MATCH (INVALID)
+  getClob=IC JDBC MATCH (INVALID)
+  getBlob=IC JDBC MATCH (INVALID)
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=CORRECT :java.lang.Integer was null false
+setNull() with all JDBC Types on INTEGER
+  setNull(Types.TINYINT) getInt=0 was null true
+  setNull with batching support(Types.TINYINT) getInt=0 was null true
+  setNull(SMALLINT) getInt=0 was null true
+  setNull with batching support(SMALLINT) getInt=0 was null true
+  setNull(INTEGER) getInt=0 was null true
+  setNull with batching support(INTEGER) getInt=0 was null true
+  setNull(BIGINT) getInt=0 was null true
+  setNull with batching support(BIGINT) getInt=0 was null true
+  setNull(REAL) getInt=0 was null true
+  setNull with batching support(REAL) getInt=0 was null true
+  setNull(Types.FLOAT) getInt=0 was null true
+  setNull with batching support(Types.FLOAT) getInt=0 was null true
+  setNull(DOUBLE) getInt=0 was null true
+  setNull with batching support(DOUBLE) getInt=0 was null true
+  setNull(DECIMAL) getInt=0 was null true
+  setNull with batching support(DECIMAL) getInt=0 was null true
+  setNull(Types.NUMERIC) getInt=0 was null true
+  setNull with batching support(Types.NUMERIC) getInt=0 was null true
+  setNull(Types.BIT) getInt=0 was null true
+  setNull with batching support(Types.BIT) getInt=0 was null true
+  setNull(CHAR) getInt=0 was null true
+  setNull with batching support(CHAR) getInt=0 was null true
+  setNull(VARCHAR) getInt=0 was null true
+  setNull with batching support(VARCHAR) getInt=0 was null true
+  setNull(LONG VARCHAR) getInt=0 was null true
+  setNull with batching support(LONG VARCHAR) getInt=0 was null true
+  setNull(VARCHAR () FOR BIT DATA) IC
+  setNull with batching support(VARCHAR () FOR BIT DATA) IC
+  setNull(DATE) IC
+  setNull with batching support(DATE) IC
+  setNull(TIME) IC
+  setNull with batching support(TIME) IC
+  setNull(TIMESTAMP) IC
+  setNull with batching support(TIMESTAMP) IC
+  setNull(CLOB) IC
+  setNull with batching support(CLOB) IC
+  setNull(BLOB) IC
+  setNull with batching support(BLOB) IC
+  setNull(Types.NULL) IC
+  setNull with batching support(Types.NULL) IC
+  setNull(235350345) IC
+  setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on INTEGER
+For setXXX() methods that pass an object, a null and valid values are checked
+  setByte() getInt=98 was null false JDBC MATCH(OK)
+  setByte() as batch getInt=98 was null false JDBC MATCH(OK)
+  setShort() getInt=98 was null false JDBC MATCH(OK)
+  setShort() as batch getInt=98 was null false JDBC MATCH(OK)
+  setInt() getInt=98 was null false JDBC MATCH(OK)
+  setInt() as batch getInt=98 was null false JDBC MATCH(OK)
+  setLong() getInt=98 was null false JDBC MATCH(OK)
+  setLong() as batch getInt=98 was null false JDBC MATCH(OK)
+  setFloat() getInt=98 was null false JDBC MATCH(OK)
+  setFloat() as batch getInt=98 was null false JDBC MATCH(OK)
+  setDouble() getInt=98 was null false JDBC MATCH(OK)
+  setDouble() as batch getInt=98 was null false JDBC MATCH(OK)
+  setBigDecimal() getInt=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getInt=99 was null false JDBC MATCH(OK)
+  setBigDecimal(null) getInt=0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getInt=0 was null true JDBC MATCH(OK)
+  setBoolean() getInt=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getInt=1 was null false JDBC MATCH(OK)
+  setString() getInt=97 was null false JDBC MATCH(OK)
+  setString() as batch getInt=97 was null false JDBC MATCH(OK)
+  setString(null) getInt=0 was null true JDBC MATCH(OK)
+  setString(null) as batch getInt=0 was null true JDBC MATCH(OK)
+ setString("Invalid Value")  IC (Expected)
+  setBytes() IC JDBC MATCH (INVALID)
+  setBytes() as batchIC JDBC MATCH (INVALID)
+  setBytes(null) IC JDBC MATCH (INVALID)
+  setBytes(null) as batchIC JDBC MATCH (INVALID)
+  setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
+  setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
+  setTime() IC JDBC MATCH (INVALID)
+  setTime() as batch IC JDBC MATCH (INVALID)
+  setTime(null) IC JDBC MATCH (INVALID)
+  setTime(null) as batch IC JDBC MATCH (INVALID)
+  setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
+  setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream() as batch IC JDBC MATCH (INVALID)
+  setAsciiStream(null) IC JDBC MATCH (INVALID)
+  setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+  setBinaryStream() IC JDBC MATCH (INVALID)
+  setBinaryStream() as batch IC JDBC MATCH (INVALID)
+  setBinaryStream(null) IC JDBC MATCH (INVALID)
+  setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() as batch IC JDBC MATCH (INVALID)
+  setCharacterStream(null) IC JDBC MATCH (INVALID)
+  setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+  setClob() IC JDBC MATCH (INVALID)
+  setClob() as batch IC JDBC MATCH (INVALID)
+  setClob(null) IC JDBC MATCH (INVALID)
+  setClob(null) as batch IC JDBC MATCH (INVALID)
+  setBlob() IC JDBC MATCH (INVALID)
+  setBlob() as batch IC JDBC MATCH (INVALID)
+  setBlob(null) IC JDBC MATCH (INVALID)
+  setBlob(null) as batch IC JDBC MATCH (INVALID)
+  setUnicodeStream()  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setUnicodeStream(null)  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setObject(null)  OK An attempt was made to get a data value of type 'INTEGER' from a data value of type 'null'.
+  setObject(null) as batch  OK An attempt was made to get a data value of type 'INTEGER' from a data value of type 'null'.
+  setObject(java.lang.String) getInt=46 was null false JDBC MATCH(OK)
+  setObject(java.lang.String) as batch getInt=46 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) getInt=72 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) as batch getInt=72 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) getInt=1 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) as batch getInt=1 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) getInt=74 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) as batch getInt=74 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) getInt=79 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) as batch getInt=79 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) getInt=76 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) as batch getInt=76 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) getInt=12 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) as batch getInt=12 was null false JDBC MATCH(OK)
+  setObject(byte[]) IC JDBC MATCH (INVALID)
+  setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 INTEGER, INOUT P2 INTEGER, OUT P3 INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
+INOUT INTEGER registerOutParameter(Types.TINYINT) -- OK
+OUT INTEGER registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=41 was null false
+P3=cs.getByte=88 was null false
+INOUT INTEGER registerOutParameter(Types.SMALLINT) -- OK
+OUT INTEGER registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=41 was null false
+P3=cs.getShort=88 was null false
+INOUT INTEGER registerOutParameter(Types.INTEGER) -- OK
+OUT INTEGER registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=41 was null false
+P3=cs.getInt=88 was null false
+INOUT INTEGER registerOutParameter(Types.BIGINT) -- OK
+OUT INTEGER registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=41 was null false
+P3=cs.getLong=88 was null false
+INOUT INTEGER registerOutParameter(Types.REAL) -- OK
+OUT INTEGER registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=41.0 was null false
+P3=cs.getFloat=88.0 was null false
+INOUT INTEGER registerOutParameter(Types.FLOAT) -- OK
+OUT INTEGER registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=41.0 was null false
+P3=cs.getDouble=88.0 was null false
+INOUT INTEGER registerOutParameter(Types.DOUBLE) -- OK
+OUT INTEGER registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=41.0 was null false
+P3=cs.getDouble=88.0 was null false
+INOUT INTEGER registerOutParameter(Types.DECIMAL) -- OK
+OUT INTEGER registerOutParameter(Types.DECIMAL) -- OK
+P2=cs.getBigDecimal=41 was null false
+P3=cs.getBigDecimal=88 was null false
+INOUT INTEGER registerOutParameter(Types.NUMERIC) -- OK
+OUT INTEGER registerOutParameter(Types.NUMERIC) -- OK
+INOUT INTEGER registerOutParameter(Types.BIT) -- OK
+OUT INTEGER registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT INTEGER registerOutParameter(Types.CHAR) -- OK
+OUT INTEGER registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=41 was null false
+P3=cs.getString=88 was null false
+INOUT INTEGER registerOutParameter(Types.VARCHAR) -- OK
+OUT INTEGER registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=41 was null false
+P3=cs.getString=88 was null false
+INOUT INTEGER registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT INTEGER registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=41 was null false
+P3=cs.getString=88 was null false
+INOUT INTEGER registerOutParameter(Types.VARBINARY) -- XCL25
+OUT INTEGER registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT INTEGER registerOutParameter(Types.DATE) -- XCL25
+OUT INTEGER registerOutParameter(Types.DATE) -- XCL25
+INOUT INTEGER registerOutParameter(Types.TIME) -- XCL25
+OUT INTEGER registerOutParameter(Types.TIME) -- XCL25
+INOUT INTEGER registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT INTEGER registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT INTEGER registerOutParameter(Types.CLOB) -- XCL25
+OUT INTEGER registerOutParameter(Types.CLOB) -- XCL25
+INOUT INTEGER registerOutParameter(Types.BLOB) -- XCL25
+OUT INTEGER registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : BIGINT
+ NULL VALUE
+  getByte=0 was null true JDBC MATCH(OK)
+  getShort=0 was null true JDBC MATCH(OK)
+  getInt=0 was null true JDBC MATCH(OK)
+  getLong=0 was null true JDBC MATCH(OK)
+  getFloat=0.0 was null true JDBC MATCH(OK)
+  getDouble=0.0 was null true JDBC MATCH(OK)
+  getBigDecimal=null was null true JDBC MATCH(OK)
+  getBoolean=false was null true JDBC MATCH(OK)
+  getString=null was null true JDBC MATCH(OK)
+  getBytes=null was null true CLOUD EXT (OK)
+  getDate=null was null true CLOUD EXT (OK)
+  getTime=null was null true CLOUD EXT (OK)
+  getTimestamp=null was null true CLOUD EXT (OK)
+  getAsciiStream=SPECIFIC CHECK OK
+  getBinaryStream=SPECIFIC CHECK OK
+  getCharacterStream=SPECIFIC CHECK OK
+  getClob=SPECIFIC CHECK OK
+  getBlob=SPECIFIC CHECK OK
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=null was null true
+ VALID VALUE
+  getByte=32 was null false JDBC MATCH(OK)
+  getShort=32 was null false JDBC MATCH(OK)
+  getInt=32 was null false JDBC MATCH(OK)
+  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)
+  getBoolean=true was null false JDBC MATCH(OK)
+  getString=32 was null false JDBC MATCH(OK)
+  getBytes=IC JDBC MATCH (INVALID)
+  getDate=IC JDBC MATCH (INVALID)
+  getTime=IC JDBC MATCH (INVALID)
+  getTimestamp=IC JDBC MATCH (INVALID)
+  getAsciiStream=IC JDBC MATCH (INVALID)
+  getBinaryStream=IC JDBC MATCH (INVALID)
+  getCharacterStream=IC JDBC MATCH (INVALID)
+  getClob=IC JDBC MATCH (INVALID)
+  getBlob=IC JDBC MATCH (INVALID)
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=CORRECT :java.lang.Long was null false
+setNull() with all JDBC Types on BIGINT
+  setNull(Types.TINYINT) getLong=0 was null true
+  setNull with batching support(Types.TINYINT) getLong=0 was null true
+  setNull(SMALLINT) getLong=0 was null true
+  setNull with batching support(SMALLINT) getLong=0 was null true
+  setNull(INTEGER) getLong=0 was null true
+  setNull with batching support(INTEGER) getLong=0 was null true
+  setNull(BIGINT) getLong=0 was null true
+  setNull with batching support(BIGINT) getLong=0 was null true
+  setNull(REAL) getLong=0 was null true
+  setNull with batching support(REAL) getLong=0 was null true
+  setNull(Types.FLOAT) getLong=0 was null true
+  setNull with batching support(Types.FLOAT) getLong=0 was null true
+  setNull(DOUBLE) getLong=0 was null true
+  setNull with batching support(DOUBLE) getLong=0 was null true
+  setNull(DECIMAL) getLong=0 was null true
+  setNull with batching support(DECIMAL) getLong=0 was null true
+  setNull(Types.NUMERIC) getLong=0 was null true
+  setNull with batching support(Types.NUMERIC) getLong=0 was null true
+  setNull(Types.BIT) getLong=0 was null true
+  setNull with batching support(Types.BIT) getLong=0 was null true
+  setNull(CHAR) getLong=0 was null true
+  setNull with batching support(CHAR) getLong=0 was null true
+  setNull(VARCHAR) getLong=0 was null true
+  setNull with batching support(VARCHAR) getLong=0 was null true
+  setNull(LONG VARCHAR) getLong=0 was null true
+  setNull with batching support(LONG VARCHAR) getLong=0 was null true
+  setNull(VARCHAR () FOR BIT DATA) IC
+  setNull with batching support(VARCHAR () FOR BIT DATA) IC
+  setNull(DATE) IC
+  setNull with batching support(DATE) IC
+  setNull(TIME) IC
+  setNull with batching support(TIME) IC
+  setNull(TIMESTAMP) IC
+  setNull with batching support(TIMESTAMP) IC
+  setNull(CLOB) IC
+  setNull with batching support(CLOB) IC
+  setNull(BLOB) IC
+  setNull with batching support(BLOB) IC
+  setNull(Types.NULL) IC
+  setNull with batching support(Types.NULL) IC
+  setNull(235350345) IC
+  setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on BIGINT
+For setXXX() methods that pass an object, a null and valid values are checked
+  setByte() getLong=98 was null false JDBC MATCH(OK)
+  setByte() as batch getLong=98 was null false JDBC MATCH(OK)
+  setShort() getLong=98 was null false JDBC MATCH(OK)
+  setShort() as batch getLong=98 was null false JDBC MATCH(OK)
+  setInt() getLong=98 was null false JDBC MATCH(OK)
+  setInt() as batch getLong=98 was null false JDBC MATCH(OK)
+  setLong() getLong=98 was null false JDBC MATCH(OK)
+  setLong() as batch getLong=98 was null false JDBC MATCH(OK)
+  setFloat() getLong=98 was null false JDBC MATCH(OK)
+  setFloat() as batch getLong=98 was null false JDBC MATCH(OK)
+  setDouble() getLong=98 was null false JDBC MATCH(OK)
+  setDouble() as batch getLong=98 was null false JDBC MATCH(OK)
+  setBigDecimal() getLong=99 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getLong=99 was null false JDBC MATCH(OK)
+  setBigDecimal(null) getLong=0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getLong=0 was null true JDBC MATCH(OK)
+  setBoolean() getLong=1 was null false JDBC MATCH(OK)
+  setBoolean() as batch getLong=1 was null false JDBC MATCH(OK)
+  setString() getLong=97 was null false JDBC MATCH(OK)
+  setString() as batch getLong=97 was null false JDBC MATCH(OK)
+  setString(null) getLong=0 was null true JDBC MATCH(OK)
+  setString(null) as batch getLong=0 was null true JDBC MATCH(OK)
+ setString("Invalid Value")  IC (Expected)
+  setBytes() IC JDBC MATCH (INVALID)
+  setBytes() as batchIC JDBC MATCH (INVALID)
+  setBytes(null) IC JDBC MATCH (INVALID)
+  setBytes(null) as batchIC JDBC MATCH (INVALID)
+  setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
+  setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
+  setTime() IC JDBC MATCH (INVALID)
+  setTime() as batch IC JDBC MATCH (INVALID)
+  setTime(null) IC JDBC MATCH (INVALID)
+  setTime(null) as batch IC JDBC MATCH (INVALID)
+  setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
+  setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream() as batch IC JDBC MATCH (INVALID)
+  setAsciiStream(null) IC JDBC MATCH (INVALID)
+  setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+  setBinaryStream() IC JDBC MATCH (INVALID)
+  setBinaryStream() as batch IC JDBC MATCH (INVALID)
+  setBinaryStream(null) IC JDBC MATCH (INVALID)
+  setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() as batch IC JDBC MATCH (INVALID)
+  setCharacterStream(null) IC JDBC MATCH (INVALID)
+  setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+  setClob() IC JDBC MATCH (INVALID)
+  setClob() as batch IC JDBC MATCH (INVALID)
+  setClob(null) IC JDBC MATCH (INVALID)
+  setClob(null) as batch IC JDBC MATCH (INVALID)
+  setBlob() IC JDBC MATCH (INVALID)
+  setBlob() as batch IC JDBC MATCH (INVALID)
+  setBlob(null) IC JDBC MATCH (INVALID)
+  setBlob(null) as batch IC JDBC MATCH (INVALID)
+  setUnicodeStream()  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setUnicodeStream(null)  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setObject(null)  OK An attempt was made to get a data value of type 'BIGINT' from a data value of type 'null'.
+  setObject(null) as batch  OK An attempt was made to get a data value of type 'BIGINT' from a data value of type 'null'.
+  setObject(java.lang.String) getLong=46 was null false JDBC MATCH(OK)
+  setObject(java.lang.String) as batch getLong=46 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) getLong=72 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) as batch getLong=72 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) getLong=1 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) as batch getLong=1 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) getLong=74 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) as batch getLong=74 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) getLong=79 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) as batch getLong=79 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) getLong=76 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) as batch getLong=76 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) getLong=12 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) as batch getLong=12 was null false JDBC MATCH(OK)
+  setObject(byte[]) IC JDBC MATCH (INVALID)
+  setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 BIGINT, INOUT P2 BIGINT, OUT P3 BIGINT) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
+INOUT BIGINT registerOutParameter(Types.TINYINT) -- OK
+OUT BIGINT registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=40 was null false
+P3=cs.getByte=99 was null false
+INOUT BIGINT registerOutParameter(Types.SMALLINT) -- OK
+OUT BIGINT registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=40 was null false
+P3=cs.getShort=99 was null false
+INOUT BIGINT registerOutParameter(Types.INTEGER) -- OK
+OUT BIGINT registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=40 was null false
+P3=cs.getInt=99 was null false
+INOUT BIGINT registerOutParameter(Types.BIGINT) -- OK
+OUT BIGINT registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=40 was null false
+P3=cs.getLong=99 was null false
+INOUT BIGINT registerOutParameter(Types.REAL) -- OK
+OUT BIGINT registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=40.0 was null false
+P3=cs.getFloat=99.0 was null false
+INOUT BIGINT registerOutParameter(Types.FLOAT) -- OK
+OUT BIGINT registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=40.0 was null false
+P3=cs.getDouble=99.0 was null false
+INOUT BIGINT registerOutParameter(Types.DOUBLE) -- OK
+OUT BIGINT registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=40.0 was null false
+P3=cs.getDouble=99.0 was null false
+INOUT BIGINT registerOutParameter(Types.DECIMAL) -- OK
+OUT BIGINT registerOutParameter(Types.DECIMAL) -- OK
+P2=cs.getBigDecimal=40 was null false
+P3=cs.getBigDecimal=99 was null false
+INOUT BIGINT registerOutParameter(Types.NUMERIC) -- OK
+OUT BIGINT registerOutParameter(Types.NUMERIC) -- OK
+INOUT BIGINT registerOutParameter(Types.BIT) -- OK
+OUT BIGINT registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT BIGINT registerOutParameter(Types.CHAR) -- OK
+OUT BIGINT registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=40 was null false
+P3=cs.getString=99 was null false
+INOUT BIGINT registerOutParameter(Types.VARCHAR) -- OK
+OUT BIGINT registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=40 was null false
+P3=cs.getString=99 was null false
+INOUT BIGINT registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT BIGINT registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=40 was null false
+P3=cs.getString=99 was null false
+INOUT BIGINT registerOutParameter(Types.VARBINARY) -- XCL25
+OUT BIGINT registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT BIGINT registerOutParameter(Types.DATE) -- XCL25
+OUT BIGINT registerOutParameter(Types.DATE) -- XCL25
+INOUT BIGINT registerOutParameter(Types.TIME) -- XCL25
+OUT BIGINT registerOutParameter(Types.TIME) -- XCL25
+INOUT BIGINT registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT BIGINT registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT BIGINT registerOutParameter(Types.CLOB) -- XCL25
+OUT BIGINT registerOutParameter(Types.CLOB) -- XCL25
+INOUT BIGINT registerOutParameter(Types.BLOB) -- XCL25
+OUT BIGINT registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : REAL
+ NULL VALUE
+  getByte=0 was null true JDBC MATCH(OK)
+  getShort=0 was null true JDBC MATCH(OK)
+  getInt=0 was null true JDBC MATCH(OK)
+  getLong=0 was null true JDBC MATCH(OK)
+  getFloat=0.0 was null true JDBC MATCH(OK)
+  getDouble=0.0 was null true JDBC MATCH(OK)
+  getBigDecimal=null was null true JDBC MATCH(OK)
+  getBoolean=false was null true JDBC MATCH(OK)
+  getString=null was null true JDBC MATCH(OK)
+  getBytes=null was null true CLOUD EXT (OK)
+  getDate=null was null true CLOUD EXT (OK)
+  getTime=null was null true CLOUD EXT (OK)
+  getTimestamp=null was null true CLOUD EXT (OK)
+  getAsciiStream=SPECIFIC CHECK OK
+  getBinaryStream=SPECIFIC CHECK OK
+  getCharacterStream=SPECIFIC CHECK OK
+  getClob=SPECIFIC CHECK OK
+  getBlob=SPECIFIC CHECK OK
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=null was null true
+ VALID VALUE
+  getByte=32 was null false JDBC MATCH(OK)
+  getShort=32 was null false JDBC MATCH(OK)
+  getInt=32 was null false JDBC MATCH(OK)
+  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.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)
+  getDate=IC JDBC MATCH (INVALID)
+  getTime=IC JDBC MATCH (INVALID)
+  getTimestamp=IC JDBC MATCH (INVALID)
+  getAsciiStream=IC JDBC MATCH (INVALID)
+  getBinaryStream=IC JDBC MATCH (INVALID)
+  getCharacterStream=IC JDBC MATCH (INVALID)
+  getClob=IC JDBC MATCH (INVALID)
+  getBlob=IC JDBC MATCH (INVALID)
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=CORRECT :java.lang.Float was null false
+setNull() with all JDBC Types on REAL
+  setNull(Types.TINYINT) getFloat=0.0 was null true
+  setNull with batching support(Types.TINYINT) getFloat=0.0 was null true
+  setNull(SMALLINT) getFloat=0.0 was null true
+  setNull with batching support(SMALLINT) getFloat=0.0 was null true
+  setNull(INTEGER) getFloat=0.0 was null true
+  setNull with batching support(INTEGER) getFloat=0.0 was null true
+  setNull(BIGINT) getFloat=0.0 was null true
+  setNull with batching support(BIGINT) getFloat=0.0 was null true
+  setNull(REAL) getFloat=0.0 was null true
+  setNull with batching support(REAL) getFloat=0.0 was null true
+  setNull(Types.FLOAT) getFloat=0.0 was null true
+  setNull with batching support(Types.FLOAT) getFloat=0.0 was null true
+  setNull(DOUBLE) getFloat=0.0 was null true
+  setNull with batching support(DOUBLE) getFloat=0.0 was null true
+  setNull(DECIMAL) getFloat=0.0 was null true
+  setNull with batching support(DECIMAL) getFloat=0.0 was null true
+  setNull(Types.NUMERIC) getFloat=0.0 was null true
+  setNull with batching support(Types.NUMERIC) getFloat=0.0 was null true
+  setNull(Types.BIT) getFloat=0.0 was null true
+  setNull with batching support(Types.BIT) getFloat=0.0 was null true
+  setNull(CHAR) getFloat=0.0 was null true
+  setNull with batching support(CHAR) getFloat=0.0 was null true
+  setNull(VARCHAR) getFloat=0.0 was null true
+  setNull with batching support(VARCHAR) getFloat=0.0 was null true
+  setNull(LONG VARCHAR) getFloat=0.0 was null true
+  setNull with batching support(LONG VARCHAR) getFloat=0.0 was null true
+  setNull(VARCHAR () FOR BIT DATA) IC
+  setNull with batching support(VARCHAR () FOR BIT DATA) IC
+  setNull(DATE) IC
+  setNull with batching support(DATE) IC
+  setNull(TIME) IC
+  setNull with batching support(TIME) IC
+  setNull(TIMESTAMP) IC
+  setNull with batching support(TIMESTAMP) IC
+  setNull(CLOB) IC
+  setNull with batching support(CLOB) IC
+  setNull(BLOB) IC
+  setNull with batching support(BLOB) IC
+  setNull(Types.NULL) IC
+  setNull with batching support(Types.NULL) IC
+  setNull(235350345) IC
+  setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on REAL
+For setXXX() methods that pass an object, a null and valid values are checked
+  setByte() getFloat=98.0 was null false JDBC MATCH(OK)
+  setByte() as batch getFloat=98.0 was null false JDBC MATCH(OK)
+  setShort() getFloat=98.0 was null false JDBC MATCH(OK)
+  setShort() as batch getFloat=98.0 was null false JDBC MATCH(OK)
+  setInt() getFloat=98.0 was null false JDBC MATCH(OK)
+  setInt() as batch getFloat=98.0 was null false JDBC MATCH(OK)
+  setLong() getFloat=98.0 was null false JDBC MATCH(OK)
+  setLong() as batch getFloat=98.0 was null false JDBC MATCH(OK)
+  setFloat() getFloat=98.4 was null false JDBC MATCH(OK)
+  setFloat() as batch getFloat=98.4 was null false JDBC MATCH(OK)
+  setDouble() getFloat=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getFloat=98.5 was null false JDBC MATCH(OK)
+  setBigDecimal() getFloat=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getFloat=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal(null) getFloat=0.0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getFloat=0.0 was null true JDBC MATCH(OK)
+  setBoolean() getFloat=1.0 was null false JDBC MATCH(OK)
+  setBoolean() as batch getFloat=1.0 was null false JDBC MATCH(OK)
+  setString() getFloat=97.0 was null false JDBC MATCH(OK)
+  setString() as batch getFloat=97.0 was null false JDBC MATCH(OK)
+  setString(null) getFloat=0.0 was null true JDBC MATCH(OK)
+  setString(null) as batch getFloat=0.0 was null true JDBC MATCH(OK)
+ setString("Invalid Value")  IC (Expected)
+  setBytes() IC JDBC MATCH (INVALID)
+  setBytes() as batchIC JDBC MATCH (INVALID)
+  setBytes(null) IC JDBC MATCH (INVALID)
+  setBytes(null) as batchIC JDBC MATCH (INVALID)
+  setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
+  setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
+  setTime() IC JDBC MATCH (INVALID)
+  setTime() as batch IC JDBC MATCH (INVALID)
+  setTime(null) IC JDBC MATCH (INVALID)
+  setTime(null) as batch IC JDBC MATCH (INVALID)
+  setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
+  setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream() as batch IC JDBC MATCH (INVALID)
+  setAsciiStream(null) IC JDBC MATCH (INVALID)
+  setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+  setBinaryStream() IC JDBC MATCH (INVALID)
+  setBinaryStream() as batch IC JDBC MATCH (INVALID)
+  setBinaryStream(null) IC JDBC MATCH (INVALID)
+  setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() as batch IC JDBC MATCH (INVALID)
+  setCharacterStream(null) IC JDBC MATCH (INVALID)
+  setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+  setClob() IC JDBC MATCH (INVALID)
+  setClob() as batch IC JDBC MATCH (INVALID)
+  setClob(null) IC JDBC MATCH (INVALID)
+  setClob(null) as batch IC JDBC MATCH (INVALID)
+  setBlob() IC JDBC MATCH (INVALID)
+  setBlob() as batch IC JDBC MATCH (INVALID)
+  setBlob(null) IC JDBC MATCH (INVALID)
+  setBlob(null) as batch IC JDBC MATCH (INVALID)
+  setUnicodeStream()  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setUnicodeStream(null)  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setObject(null)  OK An attempt was made to get a data value of type 'REAL' from a data value of type 'null'.
+  setObject(null) as batch  OK An attempt was made to get a data value of type 'REAL' from a data value of type 'null'.
+  setObject(java.lang.String) getFloat=46.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.String) as batch getFloat=46.0 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) getFloat=72.0 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) as batch getFloat=72.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) getFloat=1.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) as batch getFloat=1.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) getFloat=74.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) as batch getFloat=74.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) getFloat=79.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) as batch getFloat=79.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) getFloat=76.3 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) as batch getFloat=76.3 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) getFloat=12.33 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) as batch getFloat=12.33 was null false JDBC MATCH(OK)
+  setObject(byte[]) IC JDBC MATCH (INVALID)
+  setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 REAL, INOUT P2 REAL, OUT P3 REAL) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
+INOUT REAL registerOutParameter(Types.TINYINT) -- OK
+OUT REAL registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=41 was null false
+P3=cs.getByte=88 was null false
+INOUT REAL registerOutParameter(Types.SMALLINT) -- OK
+OUT REAL registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=41 was null false
+P3=cs.getShort=88 was null false
+INOUT REAL registerOutParameter(Types.INTEGER) -- OK
+OUT REAL registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=41 was null false
+P3=cs.getInt=88 was null false
+INOUT REAL registerOutParameter(Types.BIGINT) -- OK
+OUT REAL registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=41 was null false
+P3=cs.getLong=88 was null false
+INOUT REAL registerOutParameter(Types.REAL) -- OK
+OUT REAL registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=41.9 was null false
+P3=cs.getFloat=88.8 was null false
+INOUT REAL registerOutParameter(Types.FLOAT) -- OK
+OUT REAL registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=41.900001525878906 was null false
+P3=cs.getDouble=88.80000305175781 was null false
+INOUT REAL registerOutParameter(Types.DOUBLE) -- OK
+OUT REAL registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=41.900001525878906 was null false
+P3=cs.getDouble=88.80000305175781 was null false
+INOUT REAL registerOutParameter(Types.DECIMAL) -- OK
+OUT REAL registerOutParameter(Types.DECIMAL) -- OK
+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
+OUT REAL registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT REAL registerOutParameter(Types.CHAR) -- OK
+OUT REAL registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=41.9 was null false
+P3=cs.getString=88.8 was null false
+INOUT REAL registerOutParameter(Types.VARCHAR) -- OK
+OUT REAL registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=41.9 was null false
+P3=cs.getString=88.8 was null false
+INOUT REAL registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT REAL registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=41.9 was null false
+P3=cs.getString=88.8 was null false
+INOUT REAL registerOutParameter(Types.VARBINARY) -- XCL25
+OUT REAL registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT REAL registerOutParameter(Types.DATE) -- XCL25
+OUT REAL registerOutParameter(Types.DATE) -- XCL25
+INOUT REAL registerOutParameter(Types.TIME) -- XCL25
+OUT REAL registerOutParameter(Types.TIME) -- XCL25
+INOUT REAL registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT REAL registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT REAL registerOutParameter(Types.CLOB) -- XCL25
+OUT REAL registerOutParameter(Types.CLOB) -- XCL25
+INOUT REAL registerOutParameter(Types.BLOB) -- XCL25
+OUT REAL registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : FLOAT
+FAIL - mismatch column type 8 expected 6
+ NULL VALUE
+  getByte=0 was null true JDBC MATCH(OK)
+  getShort=0 was null true JDBC MATCH(OK)
+  getInt=0 was null true JDBC MATCH(OK)
+  getLong=0 was null true JDBC MATCH(OK)
+  getFloat=0.0 was null true JDBC MATCH(OK)
+  getDouble=0.0 was null true JDBC MATCH(OK)
+  getBigDecimal=null was null true JDBC MATCH(OK)
+  getBoolean=false was null true JDBC MATCH(OK)
+  getString=null was null true JDBC MATCH(OK)
+  getBytes=null was null true CLOUD EXT (OK)
+  getDate=null was null true CLOUD EXT (OK)
+  getTime=null was null true CLOUD EXT (OK)
+  getTimestamp=null was null true CLOUD EXT (OK)
+  getAsciiStream=SPECIFIC CHECK OK
+  getBinaryStream=SPECIFIC CHECK OK
+  getCharacterStream=SPECIFIC CHECK OK
+  getClob=SPECIFIC CHECK OK
+  getBlob=SPECIFIC CHECK OK
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=null was null true
+ VALID VALUE
+  getByte=32 was null false JDBC MATCH(OK)
+  getShort=32 was null false JDBC MATCH(OK)
+  getInt=32 was null false JDBC MATCH(OK)
+  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.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)
+  getDate=IC JDBC MATCH (INVALID)
+  getTime=IC JDBC MATCH (INVALID)
+  getTimestamp=IC JDBC MATCH (INVALID)
+  getAsciiStream=IC JDBC MATCH (INVALID)
+  getBinaryStream=IC JDBC MATCH (INVALID)
+  getCharacterStream=IC JDBC MATCH (INVALID)
+  getClob=IC JDBC MATCH (INVALID)
+  getBlob=IC JDBC MATCH (INVALID)
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=CORRECT :java.lang.Double was null false
+setNull() with all JDBC Types on FLOAT
+  setNull(Types.TINYINT) getDouble=0.0 was null true
+  setNull with batching support(Types.TINYINT) getDouble=0.0 was null true
+  setNull(SMALLINT) getDouble=0.0 was null true
+  setNull with batching support(SMALLINT) getDouble=0.0 was null true
+  setNull(INTEGER) getDouble=0.0 was null true
+  setNull with batching support(INTEGER) getDouble=0.0 was null true
+  setNull(BIGINT) getDouble=0.0 was null true
+  setNull with batching support(BIGINT) getDouble=0.0 was null true
+  setNull(REAL) getDouble=0.0 was null true
+  setNull with batching support(REAL) getDouble=0.0 was null true
+  setNull(Types.FLOAT) getDouble=0.0 was null true
+  setNull with batching support(Types.FLOAT) getDouble=0.0 was null true
+  setNull(DOUBLE) getDouble=0.0 was null true
+  setNull with batching support(DOUBLE) getDouble=0.0 was null true
+  setNull(DECIMAL) getDouble=0.0 was null true
+  setNull with batching support(DECIMAL) getDouble=0.0 was null true
+  setNull(Types.NUMERIC) getDouble=0.0 was null true
+  setNull with batching support(Types.NUMERIC) getDouble=0.0 was null true
+  setNull(Types.BIT) getDouble=0.0 was null true
+  setNull with batching support(Types.BIT) getDouble=0.0 was null true
+  setNull(CHAR) getDouble=0.0 was null true
+  setNull with batching support(CHAR) getDouble=0.0 was null true
+  setNull(VARCHAR) getDouble=0.0 was null true
+  setNull with batching support(VARCHAR) getDouble=0.0 was null true
+  setNull(LONG VARCHAR) getDouble=0.0 was null true
+  setNull with batching support(LONG VARCHAR) getDouble=0.0 was null true
+  setNull(VARCHAR () FOR BIT DATA) IC
+  setNull with batching support(VARCHAR () FOR BIT DATA) IC
+  setNull(DATE) IC
+  setNull with batching support(DATE) IC
+  setNull(TIME) IC
+  setNull with batching support(TIME) IC
+  setNull(TIMESTAMP) IC
+  setNull with batching support(TIMESTAMP) IC
+  setNull(CLOB) IC
+  setNull with batching support(CLOB) IC
+  setNull(BLOB) IC
+  setNull with batching support(BLOB) IC
+  setNull(Types.NULL) IC
+  setNull with batching support(Types.NULL) IC
+  setNull(235350345) IC
+  setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on FLOAT
+For setXXX() methods that pass an object, a null and valid values are checked
+  setByte() getDouble=98.0 was null false JDBC MATCH(OK)
+  setByte() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+  setShort() getDouble=98.0 was null false JDBC MATCH(OK)
+  setShort() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+  setInt() getDouble=98.0 was null false JDBC MATCH(OK)
+  setInt() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+  setLong() getDouble=98.0 was null false JDBC MATCH(OK)
+  setLong() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+  setFloat() getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+  setFloat() as batch getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+  setDouble() getDouble=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getDouble=98.5 was null false JDBC MATCH(OK)
+  setBigDecimal() getDouble=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getDouble=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
+  setBoolean() getDouble=1.0 was null false JDBC MATCH(OK)
+  setBoolean() as batch getDouble=1.0 was null false JDBC MATCH(OK)
+  setString() getDouble=97.0 was null false JDBC MATCH(OK)
+  setString() as batch getDouble=97.0 was null false JDBC MATCH(OK)
+  setString(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setString(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
+ setString("Invalid Value")  IC (Expected)
+  setBytes() IC JDBC MATCH (INVALID)
+  setBytes() as batchIC JDBC MATCH (INVALID)
+  setBytes(null) IC JDBC MATCH (INVALID)
+  setBytes(null) as batchIC JDBC MATCH (INVALID)
+  setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
+  setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
+  setTime() IC JDBC MATCH (INVALID)
+  setTime() as batch IC JDBC MATCH (INVALID)
+  setTime(null) IC JDBC MATCH (INVALID)
+  setTime(null) as batch IC JDBC MATCH (INVALID)
+  setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
+  setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream() as batch IC JDBC MATCH (INVALID)
+  setAsciiStream(null) IC JDBC MATCH (INVALID)
+  setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+  setBinaryStream() IC JDBC MATCH (INVALID)
+  setBinaryStream() as batch IC JDBC MATCH (INVALID)
+  setBinaryStream(null) IC JDBC MATCH (INVALID)
+  setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() as batch IC JDBC MATCH (INVALID)
+  setCharacterStream(null) IC JDBC MATCH (INVALID)
+  setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+  setClob() IC JDBC MATCH (INVALID)
+  setClob() as batch IC JDBC MATCH (INVALID)
+  setClob(null) IC JDBC MATCH (INVALID)
+  setClob(null) as batch IC JDBC MATCH (INVALID)
+  setBlob() IC JDBC MATCH (INVALID)
+  setBlob() as batch IC JDBC MATCH (INVALID)
+  setBlob(null) IC JDBC MATCH (INVALID)
+  setBlob(null) as batch IC JDBC MATCH (INVALID)
+  setUnicodeStream()  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setUnicodeStream(null)  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setObject(null)  OK An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'null'.
+  setObject(null) as batch  OK An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'null'.
+  setObject(java.lang.String) getDouble=46.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.String) as batch getDouble=46.0 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) getDouble=72.0 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) as batch getDouble=72.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) getDouble=1.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) as batch getDouble=1.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) getDouble=74.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) as batch getDouble=74.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) getDouble=79.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) as batch getDouble=79.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) getDouble=76.30000305175781 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) as batch getDouble=76.30000305175781 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) getDouble=12.33 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) as batch getDouble=12.33 was null false JDBC MATCH(OK)
+  setObject(byte[]) IC JDBC MATCH (INVALID)
+  setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 FLOAT, INOUT P2 FLOAT, OUT P3 FLOAT) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
+INOUT FLOAT registerOutParameter(Types.TINYINT) -- OK
+OUT FLOAT registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=35 was null false
+P3=cs.getByte=66 was null false
+INOUT FLOAT registerOutParameter(Types.SMALLINT) -- OK
+OUT FLOAT registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=35 was null false
+P3=cs.getShort=66 was null false
+INOUT FLOAT registerOutParameter(Types.INTEGER) -- OK
+OUT FLOAT registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=35 was null false
+P3=cs.getInt=66 was null false
+INOUT FLOAT registerOutParameter(Types.BIGINT) -- OK
+OUT FLOAT registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=35 was null false
+P3=cs.getLong=66 was null false
+INOUT FLOAT registerOutParameter(Types.REAL) -- OK
+OUT FLOAT registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=35.9 was null false
+P3=cs.getFloat=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.FLOAT) -- OK
+OUT FLOAT registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=35.9 was null false
+P3=cs.getDouble=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.DOUBLE) -- OK
+OUT FLOAT registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=35.9 was null false
+P3=cs.getDouble=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.DECIMAL) -- OK
+OUT FLOAT registerOutParameter(Types.DECIMAL) -- OK
+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
+OUT FLOAT registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT FLOAT registerOutParameter(Types.CHAR) -- OK
+OUT FLOAT registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.VARCHAR) -- OK
+OUT FLOAT registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT FLOAT registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT FLOAT registerOutParameter(Types.VARBINARY) -- XCL25
+OUT FLOAT registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT FLOAT registerOutParameter(Types.DATE) -- XCL25
+OUT FLOAT registerOutParameter(Types.DATE) -- XCL25
+INOUT FLOAT registerOutParameter(Types.TIME) -- XCL25
+OUT FLOAT registerOutParameter(Types.TIME) -- XCL25
+INOUT FLOAT registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT FLOAT registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT FLOAT registerOutParameter(Types.CLOB) -- XCL25
+OUT FLOAT registerOutParameter(Types.CLOB) -- XCL25
+INOUT FLOAT registerOutParameter(Types.BLOB) -- XCL25
+OUT FLOAT registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : DOUBLE
+ NULL VALUE
+  getByte=0 was null true JDBC MATCH(OK)
+  getShort=0 was null true JDBC MATCH(OK)
+  getInt=0 was null true JDBC MATCH(OK)
+  getLong=0 was null true JDBC MATCH(OK)
+  getFloat=0.0 was null true JDBC MATCH(OK)
+  getDouble=0.0 was null true JDBC MATCH(OK)
+  getBigDecimal=null was null true JDBC MATCH(OK)
+  getBoolean=false was null true JDBC MATCH(OK)
+  getString=null was null true JDBC MATCH(OK)
+  getBytes=null was null true CLOUD EXT (OK)
+  getDate=null was null true CLOUD EXT (OK)
+  getTime=null was null true CLOUD EXT (OK)
+  getTimestamp=null was null true CLOUD EXT (OK)
+  getAsciiStream=SPECIFIC CHECK OK
+  getBinaryStream=SPECIFIC CHECK OK
+  getCharacterStream=SPECIFIC CHECK OK
+  getClob=SPECIFIC CHECK OK
+  getBlob=SPECIFIC CHECK OK
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=null was null true
+ VALID VALUE
+  getByte=32 was null false JDBC MATCH(OK)
+  getShort=32 was null false JDBC MATCH(OK)
+  getInt=32 was null false JDBC MATCH(OK)
+  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.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)
+  getDate=IC JDBC MATCH (INVALID)
+  getTime=IC JDBC MATCH (INVALID)
+  getTimestamp=IC JDBC MATCH (INVALID)
+  getAsciiStream=IC JDBC MATCH (INVALID)
+  getBinaryStream=IC JDBC MATCH (INVALID)
+  getCharacterStream=IC JDBC MATCH (INVALID)
+  getClob=IC JDBC MATCH (INVALID)
+  getBlob=IC JDBC MATCH (INVALID)
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=CORRECT :java.lang.Double was null false
+setNull() with all JDBC Types on DOUBLE
+  setNull(Types.TINYINT) getDouble=0.0 was null true
+  setNull with batching support(Types.TINYINT) getDouble=0.0 was null true
+  setNull(SMALLINT) getDouble=0.0 was null true
+  setNull with batching support(SMALLINT) getDouble=0.0 was null true
+  setNull(INTEGER) getDouble=0.0 was null true
+  setNull with batching support(INTEGER) getDouble=0.0 was null true
+  setNull(BIGINT) getDouble=0.0 was null true
+  setNull with batching support(BIGINT) getDouble=0.0 was null true
+  setNull(REAL) getDouble=0.0 was null true
+  setNull with batching support(REAL) getDouble=0.0 was null true
+  setNull(Types.FLOAT) getDouble=0.0 was null true
+  setNull with batching support(Types.FLOAT) getDouble=0.0 was null true
+  setNull(DOUBLE) getDouble=0.0 was null true
+  setNull with batching support(DOUBLE) getDouble=0.0 was null true
+  setNull(DECIMAL) getDouble=0.0 was null true
+  setNull with batching support(DECIMAL) getDouble=0.0 was null true
+  setNull(Types.NUMERIC) getDouble=0.0 was null true
+  setNull with batching support(Types.NUMERIC) getDouble=0.0 was null true
+  setNull(Types.BIT) getDouble=0.0 was null true
+  setNull with batching support(Types.BIT) getDouble=0.0 was null true
+  setNull(CHAR) getDouble=0.0 was null true
+  setNull with batching support(CHAR) getDouble=0.0 was null true
+  setNull(VARCHAR) getDouble=0.0 was null true
+  setNull with batching support(VARCHAR) getDouble=0.0 was null true
+  setNull(LONG VARCHAR) getDouble=0.0 was null true
+  setNull with batching support(LONG VARCHAR) getDouble=0.0 was null true
+  setNull(VARCHAR () FOR BIT DATA) IC
+  setNull with batching support(VARCHAR () FOR BIT DATA) IC
+  setNull(DATE) IC
+  setNull with batching support(DATE) IC
+  setNull(TIME) IC
+  setNull with batching support(TIME) IC
+  setNull(TIMESTAMP) IC
+  setNull with batching support(TIMESTAMP) IC
+  setNull(CLOB) IC
+  setNull with batching support(CLOB) IC
+  setNull(BLOB) IC
+  setNull with batching support(BLOB) IC
+  setNull(Types.NULL) IC
+  setNull with batching support(Types.NULL) IC
+  setNull(235350345) IC
+  setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on DOUBLE
+For setXXX() methods that pass an object, a null and valid values are checked
+  setByte() getDouble=98.0 was null false JDBC MATCH(OK)
+  setByte() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+  setShort() getDouble=98.0 was null false JDBC MATCH(OK)
+  setShort() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+  setInt() getDouble=98.0 was null false JDBC MATCH(OK)
+  setInt() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+  setLong() getDouble=98.0 was null false JDBC MATCH(OK)
+  setLong() as batch getDouble=98.0 was null false JDBC MATCH(OK)
+  setFloat() getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+  setFloat() as batch getDouble=98.4000015258789 was null false JDBC MATCH(OK)
+  setDouble() getDouble=98.5 was null false JDBC MATCH(OK)
+  setDouble() as batch getDouble=98.5 was null false JDBC MATCH(OK)
+  setBigDecimal() getDouble=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getDouble=99.0 was null false JDBC MATCH(OK)
+  setBigDecimal(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
+  setBoolean() getDouble=1.0 was null false JDBC MATCH(OK)
+  setBoolean() as batch getDouble=1.0 was null false JDBC MATCH(OK)
+  setString() getDouble=97.0 was null false JDBC MATCH(OK)
+  setString() as batch getDouble=97.0 was null false JDBC MATCH(OK)
+  setString(null) getDouble=0.0 was null true JDBC MATCH(OK)
+  setString(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
+ setString("Invalid Value")  IC (Expected)
+  setBytes() IC JDBC MATCH (INVALID)
+  setBytes() as batchIC JDBC MATCH (INVALID)
+  setBytes(null) IC JDBC MATCH (INVALID)
+  setBytes(null) as batchIC JDBC MATCH (INVALID)
+  setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
+  setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
+  setTime() IC JDBC MATCH (INVALID)
+  setTime() as batch IC JDBC MATCH (INVALID)
+  setTime(null) IC JDBC MATCH (INVALID)
+  setTime(null) as batch IC JDBC MATCH (INVALID)
+  setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
+  setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream() as batch IC JDBC MATCH (INVALID)
+  setAsciiStream(null) IC JDBC MATCH (INVALID)
+  setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+  setBinaryStream() IC JDBC MATCH (INVALID)
+  setBinaryStream() as batch IC JDBC MATCH (INVALID)
+  setBinaryStream(null) IC JDBC MATCH (INVALID)
+  setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() as batch IC JDBC MATCH (INVALID)
+  setCharacterStream(null) IC JDBC MATCH (INVALID)
+  setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+  setClob() IC JDBC MATCH (INVALID)
+  setClob() as batch IC JDBC MATCH (INVALID)
+  setClob(null) IC JDBC MATCH (INVALID)
+  setClob(null) as batch IC JDBC MATCH (INVALID)
+  setBlob() IC JDBC MATCH (INVALID)
+  setBlob() as batch IC JDBC MATCH (INVALID)
+  setBlob(null) IC JDBC MATCH (INVALID)
+  setBlob(null) as batch IC JDBC MATCH (INVALID)
+  setUnicodeStream()  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setUnicodeStream(null)  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setObject(null)  OK An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'null'.
+  setObject(null) as batch  OK An attempt was made to get a data value of type 'DOUBLE' from a data value of type 'null'.
+  setObject(java.lang.String) getDouble=46.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.String) as batch getDouble=46.0 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) getDouble=72.0 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) as batch getDouble=72.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) getDouble=1.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) as batch getDouble=1.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) getDouble=74.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) as batch getDouble=74.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) getDouble=79.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) as batch getDouble=79.0 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) getDouble=76.30000305175781 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) as batch getDouble=76.30000305175781 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) getDouble=12.33 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) as batch getDouble=12.33 was null false JDBC MATCH(OK)
+  setObject(byte[]) IC JDBC MATCH (INVALID)
+  setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 DOUBLE, INOUT P2 DOUBLE, OUT P3 DOUBLE) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
+INOUT DOUBLE registerOutParameter(Types.TINYINT) -- OK
+OUT DOUBLE registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=35 was null false
+P3=cs.getByte=66 was null false
+INOUT DOUBLE registerOutParameter(Types.SMALLINT) -- OK
+OUT DOUBLE registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=35 was null false
+P3=cs.getShort=66 was null false
+INOUT DOUBLE registerOutParameter(Types.INTEGER) -- OK
+OUT DOUBLE registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=35 was null false
+P3=cs.getInt=66 was null false
+INOUT DOUBLE registerOutParameter(Types.BIGINT) -- OK
+OUT DOUBLE registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=35 was null false
+P3=cs.getLong=66 was null false
+INOUT DOUBLE registerOutParameter(Types.REAL) -- OK
+OUT DOUBLE registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=35.9 was null false
+P3=cs.getFloat=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.FLOAT) -- OK
+OUT DOUBLE registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=35.9 was null false
+P3=cs.getDouble=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.DOUBLE) -- OK
+OUT DOUBLE registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=35.9 was null false
+P3=cs.getDouble=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.DECIMAL) -- OK
+OUT DOUBLE registerOutParameter(Types.DECIMAL) -- OK
+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
+OUT DOUBLE registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT DOUBLE registerOutParameter(Types.CHAR) -- OK
+OUT DOUBLE registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.VARCHAR) -- OK
+OUT DOUBLE registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT DOUBLE registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=35.9 was null false
+P3=cs.getString=66.8 was null false
+INOUT DOUBLE registerOutParameter(Types.VARBINARY) -- XCL25
+OUT DOUBLE registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT DOUBLE registerOutParameter(Types.DATE) -- XCL25
+OUT DOUBLE registerOutParameter(Types.DATE) -- XCL25
+INOUT DOUBLE registerOutParameter(Types.TIME) -- XCL25
+OUT DOUBLE registerOutParameter(Types.TIME) -- XCL25
+INOUT DOUBLE registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT DOUBLE registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT DOUBLE registerOutParameter(Types.CLOB) -- XCL25
+OUT DOUBLE registerOutParameter(Types.CLOB) -- XCL25
+INOUT DOUBLE registerOutParameter(Types.BLOB) -- XCL25
+OUT DOUBLE registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : DECIMAL(10,5)
+ NULL VALUE
+  getByte=0 was null true JDBC MATCH(OK)
+  getShort=0 was null true JDBC MATCH(OK)
+  getInt=0 was null true JDBC MATCH(OK)
+  getLong=0 was null true JDBC MATCH(OK)
+  getFloat=0.0 was null true JDBC MATCH(OK)
+  getDouble=0.0 was null true JDBC MATCH(OK)
+  getBigDecimal=null was null true JDBC MATCH(OK)
+  getBoolean=false was null true JDBC MATCH(OK)
+  getString=null was null true JDBC MATCH(OK)
+  getBytes=null was null true CLOUD EXT (OK)
+  getDate=null was null true CLOUD EXT (OK)
+  getTime=null was null true CLOUD EXT (OK)
+  getTimestamp=null was null true CLOUD EXT (OK)
+  getAsciiStream=SPECIFIC CHECK OK
+  getBinaryStream=SPECIFIC CHECK OK
+  getCharacterStream=SPECIFIC CHECK OK
+  getClob=SPECIFIC CHECK OK
+  getBlob=SPECIFIC CHECK OK
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=null was null true
+ VALID VALUE
+  getByte=32 was null false JDBC MATCH(OK)
+  getShort=32 was null false JDBC MATCH(OK)
+  getInt=32 was null false JDBC MATCH(OK)
+  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.00000 was null false JDBC MATCH(OK)
+  getBoolean=true was null false JDBC MATCH(OK)
+  getString=32.00000 was null false JDBC MATCH(OK)
+  getBytes=IC JDBC MATCH (INVALID)
+  getDate=IC JDBC MATCH (INVALID)
+  getTime=IC JDBC MATCH (INVALID)
+  getTimestamp=IC JDBC MATCH (INVALID)
+  getAsciiStream=IC JDBC MATCH (INVALID)
+  getBinaryStream=IC JDBC MATCH (INVALID)
+  getCharacterStream=IC JDBC MATCH (INVALID)
+  getClob=IC JDBC MATCH (INVALID)
+  getBlob=IC JDBC MATCH (INVALID)
+  getUnicodeStream= (0A000):Feature not implemented: getUnicodeStream. JDBC MATCH (INVALID)
+  getObject=CORRECT :java.math.BigDecimal was null false
+setNull() with all JDBC Types on DECIMAL(10,5)
+  setNull(Types.TINYINT) getBigDecimal=null was null true
+  setNull with batching support(Types.TINYINT) getBigDecimal=null was null true
+  setNull(SMALLINT) getBigDecimal=null was null true
+  setNull with batching support(SMALLINT) getBigDecimal=null was null true
+  setNull(INTEGER) getBigDecimal=null was null true
+  setNull with batching support(INTEGER) getBigDecimal=null was null true
+  setNull(BIGINT) getBigDecimal=null was null true
+  setNull with batching support(BIGINT) getBigDecimal=null was null true
+  setNull(REAL) getBigDecimal=null was null true
+  setNull with batching support(REAL) getBigDecimal=null was null true
+  setNull(Types.FLOAT) getBigDecimal=null was null true
+  setNull with batching support(Types.FLOAT) getBigDecimal=null was null true
+  setNull(DOUBLE) getBigDecimal=null was null true
+  setNull with batching support(DOUBLE) getBigDecimal=null was null true
+  setNull(DECIMAL) getBigDecimal=null was null true
+  setNull with batching support(DECIMAL) getBigDecimal=null was null true
+  setNull(Types.NUMERIC) getBigDecimal=null was null true
+  setNull with batching support(Types.NUMERIC) getBigDecimal=null was null true
+  setNull(Types.BIT) getBigDecimal=null was null true
+  setNull with batching support(Types.BIT) getBigDecimal=null was null true
+  setNull(CHAR) getBigDecimal=null was null true
+  setNull with batching support(CHAR) getBigDecimal=null was null true
+  setNull(VARCHAR) getBigDecimal=null was null true
+  setNull with batching support(VARCHAR) getBigDecimal=null was null true
+  setNull(LONG VARCHAR) getBigDecimal=null was null true
+  setNull with batching support(LONG VARCHAR) getBigDecimal=null was null true
+  setNull(VARCHAR () FOR BIT DATA) IC
+  setNull with batching support(VARCHAR () FOR BIT DATA) IC
+  setNull(DATE) IC
+  setNull with batching support(DATE) IC
+  setNull(TIME) IC
+  setNull with batching support(TIME) IC
+  setNull(TIMESTAMP) IC
+  setNull with batching support(TIMESTAMP) IC
+  setNull(CLOB) IC
+  setNull with batching support(CLOB) IC
+  setNull(BLOB) IC
+  setNull with batching support(BLOB) IC
+  setNull(Types.NULL) IC
+  setNull with batching support(Types.NULL) IC
+  setNull(235350345) IC
+  setNull with batching support(235350345) IC
+setXXX() with all JDBC Types on DECIMAL(10,5)
+For setXXX() methods that pass an object, a null and valid values are checked
+  setByte() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setByte() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setShort() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setShort() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setInt() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setInt() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setLong() getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setLong() as batch getBigDecimal=98.00000 was null false JDBC MATCH(OK)
+  setFloat() getBigDecimal=98.40000 was null false JDBC MATCH(OK)
+  setFloat() as batch getBigDecimal=98.40000 was null false JDBC MATCH(OK)
+  setDouble() getBigDecimal=98.50000 was null false JDBC MATCH(OK)
+  setDouble() as batch getBigDecimal=98.50000 was null false JDBC MATCH(OK)
+  setBigDecimal() getBigDecimal=99.00000 was null false JDBC MATCH(OK)
+  setBigDecimal() as batch getBigDecimal=99.00000 was null false JDBC MATCH(OK)
+  setBigDecimal(null) getBigDecimal=null was null true JDBC MATCH(OK)
+  setBigDecimal(null) as batch getBigDecimal=null was null true JDBC MATCH(OK)
+  setBoolean() getBigDecimal=1.00000 was null false JDBC MATCH(OK)
+  setBoolean() as batch getBigDecimal=1.00000 was null false JDBC MATCH(OK)
+  setString() getBigDecimal=97.00000 was null false JDBC MATCH(OK)
+  setString() as batch getBigDecimal=97.00000 was null false JDBC MATCH(OK)
+  setString(null) getBigDecimal=null was null true JDBC MATCH(OK)
+  setString(null) as batch getBigDecimal=null was null true JDBC MATCH(OK)
+ setString("Invalid Value")  IC (Expected)
+  setBytes() IC JDBC MATCH (INVALID)
+  setBytes() as batchIC JDBC MATCH (INVALID)
+  setBytes(null) IC JDBC MATCH (INVALID)
+  setBytes(null) as batchIC JDBC MATCH (INVALID)
+  setDate() IC JDBC MATCH (INVALID)
+  setDate() as batch IC JDBC MATCH (INVALID)
+  setDate(null) IC JDBC MATCH (INVALID)
+  setDate(null) as batch IC JDBC MATCH (INVALID)
+  setTime() IC JDBC MATCH (INVALID)
+  setTime() as batch IC JDBC MATCH (INVALID)
+  setTime(null) IC JDBC MATCH (INVALID)
+  setTime(null) as batch IC JDBC MATCH (INVALID)
+  setTimestamp() IC JDBC MATCH (INVALID)
+  setTimestamp() as batch IC JDBC MATCH (INVALID)
+  setTimestamp(null) IC JDBC MATCH (INVALID)
+  setTimestamp(null) as batch IC JDBC MATCH (INVALID)
+  setAsciiStream() IC JDBC MATCH (INVALID)
+  setAsciiStream() as batch IC JDBC MATCH (INVALID)
+  setAsciiStream(null) IC JDBC MATCH (INVALID)
+  setAsciiStream(null) as batch IC JDBC MATCH (INVALID)
+  setBinaryStream() IC JDBC MATCH (INVALID)
+  setBinaryStream() as batch IC JDBC MATCH (INVALID)
+  setBinaryStream(null) IC JDBC MATCH (INVALID)
+  setBinaryStream(null) as batch IC JDBC MATCH (INVALID)
+  setCharacterStream() IC JDBC MATCH (INVALID)
+  setCharacterStream() as batch IC JDBC MATCH (INVALID)
+  setCharacterStream(null) IC JDBC MATCH (INVALID)
+  setCharacterStream(null) as batch IC JDBC MATCH (INVALID)
+  setClob() IC JDBC MATCH (INVALID)
+  setClob() as batch IC JDBC MATCH (INVALID)
+  setClob(null) IC JDBC MATCH (INVALID)
+  setClob(null) as batch IC JDBC MATCH (INVALID)
+  setBlob() IC JDBC MATCH (INVALID)
+  setBlob() as batch IC JDBC MATCH (INVALID)
+  setBlob(null) IC JDBC MATCH (INVALID)
+  setBlob(null) as batch IC JDBC MATCH (INVALID)
+  setUnicodeStream()  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setUnicodeStream(null)  (0A000):Feature not implemented: setUnicodeStream. JDBC MATCH (INVALID)
+  setObject(null)  OK An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'null'.
+  setObject(null) as batch  OK An attempt was made to get a data value of type 'DECIMAL' from a data value of type 'null'.
+  setObject(java.lang.String) getBigDecimal=46.00000 was null false JDBC MATCH(OK)
+  setObject(java.lang.String) as batch getBigDecimal=46.00000 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) getBigDecimal=72.00000 was null false JDBC MATCH(OK)
+  setObject(java.math.BigDecimal) as batch getBigDecimal=72.00000 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) getBigDecimal=1.00000 was null false JDBC MATCH(OK)
+  setObject(java.lang.Boolean) as batch getBigDecimal=1.00000 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) getBigDecimal=74.00000 was null false JDBC MATCH(OK)
+  setObject(java.lang.Integer) as batch getBigDecimal=74.00000 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) getBigDecimal=79.00000 was null false JDBC MATCH(OK)
+  setObject(java.lang.Long) as batch getBigDecimal=79.00000 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) getBigDecimal=76.30000 was null false JDBC MATCH(OK)
+  setObject(java.lang.Float) as batch getBigDecimal=76.30000 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) getBigDecimal=12.33000 was null false JDBC MATCH(OK)
+  setObject(java.lang.Double) as batch getBigDecimal=12.33000 was null false JDBC MATCH(OK)
+  setObject(byte[]) IC JDBC MATCH (INVALID)
+  setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Date) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Timestamp) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Blob) as batch IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) IC JDBC MATCH (INVALID)
+  setObject(java.sql.Clob) as batch IC JDBC MATCH (INVALID)
+CREATE PROCEDURE PMP.TYPE_AS(IN P1 DECIMAL(10,5), INOUT P2 DECIMAL(10,5), OUT P3 DECIMAL(10,5)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL  EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
+INOUT DECIMAL(10,5) registerOutParameter(Types.TINYINT) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.TINYINT) -- OK
+P2=cs.getByte=34 was null false
+P3=cs.getByte=84 was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.SMALLINT) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.SMALLINT) -- OK
+P2=cs.getShort=34 was null false
+P3=cs.getShort=84 was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.INTEGER) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.INTEGER) -- OK
+P2=cs.getInt=34 was null false
+P3=cs.getInt=84 was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.BIGINT) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.BIGINT) -- OK
+P2=cs.getLong=34 was null false
+P3=cs.getLong=84 was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.REAL) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.REAL) -- OK
+P2=cs.getFloat=34.29999 was null false
+P3=cs.getFloat=84.09999 was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.FLOAT) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.FLOAT) -- OK
+P2=cs.getDouble=34.29999 was null false
+P3=cs.getDouble=84.09999 was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.DOUBLE) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.DOUBLE) -- OK
+P2=cs.getDouble=34.29999 was null false
+P3=cs.getDouble=84.09999 was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.DECIMAL) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.DECIMAL) -- OK
+P2=cs.getBigDecimal=34.29999 was null false
+P3=cs.getBigDecimal=84.09999 was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.NUMERIC) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.NUMERIC) -- OK
+INOUT DECIMAL(10,5) registerOutParameter(Types.BIT) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.BIT) -- OK
+P2=cs.getBoolean=true was null false
+P3=cs.getBoolean=true was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.CHAR) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.CHAR) -- OK
+P2=cs.getString=34.29999 was null false
+P3=cs.getString=84.09999 was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.VARCHAR) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.VARCHAR) -- OK
+P2=cs.getString=34.29999 was null false
+P3=cs.getString=84.09999 was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.LONGVARCHAR) -- OK
+OUT DECIMAL(10,5) registerOutParameter(Types.LONGVARCHAR) -- OK
+P2=cs.getString=34.29999 was null false
+P3=cs.getString=84.09999 was null false
+INOUT DECIMAL(10,5) registerOutParameter(Types.VARBINARY) -- XCL25
+OUT DECIMAL(10,5) registerOutParameter(Types.VARBINARY) -- XCL25
+INOUT DECIMAL(10,5) registerOutParameter(Types.DATE) -- XCL25
+OUT DECIMAL(10,5) registerOutParameter(Types.DATE) -- XCL25
+INOUT DECIMAL(10,5) registerOutParameter(Types.TIME) -- XCL25
+OUT DECIMAL(10,5) registerOutParameter(Types.TIME) -- XCL25
+INOUT DECIMAL(10,5) registerOutParameter(Types.TIMESTAMP) -- XCL25
+OUT DECIMAL(10,5) registerOutParameter(Types.TIMESTAMP) -- XCL25
+INOUT DECIMAL(10,5) registerOutParameter(Types.CLOB) -- XCL25
+OUT DECIMAL(10,5) registerOutParameter(Types.CLOB) -- XCL25
+INOUT DECIMAL(10,5) registerOutParameter(Types.BLOB) -- XCL25
+OUT DECIMAL(10,5) registerOutParameter(Types.BLOB) -- XCL25
+getXXX on : 2
+  skipping
+getXXX on : -7
+  skipping
+getXXX on : 0
+  skipping
+getXXX on : CHAR(60)
+ NULL VALUE
+  getByte=0 was null true JDBC MATCH(OK)
+  getShort=0 was null true JDBC MATCH(OK)

[... 1890 lines stripped ...]


Mime
View raw message