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 dj...@apache.org on 2005/09/19 21:25:11 UTC
svn commit: r290244 [4/6] - in
/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests:
master/ master/DerbyNet/ master/DerbyNet/ver2.6/ master/DerbyNetClient/
master/j9_13/ tests/jdbcapi/
Modified: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/parameterMapping.out
URL: http://svn.apache.org/viewcvs/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/parameterMapping.out?rev=290244&r1=290243&r2=290244&view=diff
==============================================================================
--- db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/parameterMapping.out (original)
+++ db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/parameterMapping.out Mon Sep 19 12:25:04 2005
@@ -114,43 +114,71 @@
setString(null) getShort=0 was null true JDBC MATCH(OK)
setString(null) as batch getShort=0 was null true JDBC MATCH(OK)
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
@@ -325,43 +353,71 @@
setString(null) getInt=0 was null true JDBC MATCH(OK)
setString(null) as batch getInt=0 was null true JDBC MATCH(OK)
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
@@ -536,43 +592,71 @@
setString(null) getLong=0 was null true JDBC MATCH(OK)
setString(null) as batch getLong=0 was null true JDBC MATCH(OK)
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
@@ -747,43 +831,71 @@
setString(null) getFloat=0.0 was null true JDBC MATCH(OK)
setString(null) as batch getFloat=0.0 was null true JDBC MATCH(OK)
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
@@ -959,43 +1071,71 @@
setString(null) getDouble=0.0 was null true JDBC MATCH(OK)
setString(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
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
@@ -1170,43 +1310,71 @@
setString(null) getDouble=0.0 was null true JDBC MATCH(OK)
setString(null) as batch getDouble=0.0 was null true JDBC MATCH(OK)
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
@@ -1381,43 +1549,71 @@
setString(null) getBigDecimal=null was null true JDBC MATCH(OK)
setString(null) as batch getBigDecimal=null was null true JDBC MATCH(OK)
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
@@ -1598,43 +1794,71 @@
setString(null) getString=null was null true JDBC MATCH(OK)
setString(null) as batch getString=null was null true JDBC MATCH(OK)
setBytes() getString=EncodedString: > 1027 64963 29440 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was null false CLOUD EXT (OK)
+ setBytes() as batchgetString=EncodedString: > 1027 64963 29440 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was null false CLOUD EXT (OK)
setBytes(null) getString=null was null true CLOUD EXT (OK)
+ setBytes(null) as batchgetString=null was null true CLOUD EXT (OK)
setDate() getString=2004-02-14 was null false JDBC MATCH(OK)
setDate() as batch getString=2004-02-14 was null false JDBC MATCH(OK)
setDate(null) getString=null was null true JDBC MATCH(OK)
setDate(null) as batch getString=null was null true JDBC MATCH(OK)
setTime() getString=13:26:42 was null false JDBC MATCH(OK)
+ setTime() as batch getString=13:26:42 was null false JDBC MATCH(OK)
setTime(null) getString=null was null true JDBC MATCH(OK)
+ setTime(null) as batch getString=null was null true JDBC MATCH(OK)
setTimestamp() getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
setTimestamp() as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
setTimestamp(null) getString=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getString=null was null true JDBC MATCH(OK)
setAsciiStream() getString=eg012d was null false JDBC MATCH(OK)
+ setAsciiStream() as batch getString=eg012d was null false JDBC MATCH(OK)
setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
+ setAsciiStream(null) as batch getString=null was null true JDBC MATCH(OK)
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() getString=89 was null false JDBC MATCH(OK)
+ setCharacterStream() as batch getString=89 was null false JDBC MATCH(OK)
setCharacterStream(null) getString=null was null true JDBC MATCH(OK)
+ setCharacterStream(null) as batch getString=null was null true JDBC MATCH(OK)
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 'CHAR' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'CHAR' from a data value of type 'null'.
setObject(java.lang.String) getString=46 was null false JDBC MATCH(OK)
+ setObject(java.lang.String) as batch getString=46 was null false JDBC MATCH(OK)
setObject(java.math.BigDecimal) getString=72 was null false JDBC MATCH(OK)
+ setObject(java.math.BigDecimal) as batch getString=72 was null false JDBC MATCH(OK)
setObject(java.lang.Boolean) getString=1 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) as batch getString=1 was null false JDBC MATCH(OK)
setObject(java.lang.Integer) getString=74 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) as batch getString=74 was null false JDBC MATCH(OK)
setObject(java.lang.Long) getString=79 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) as batch getString=79 was null false JDBC MATCH(OK)
setObject(java.lang.Float) getString=76.3 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) as batch getString=76.3 was null false JDBC MATCH(OK)
setObject(java.lang.Double) getString=12.33 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) as batch getString=12.33 was null false JDBC MATCH(OK)
setObject(byte[]) getString=EncodedString: > 12857 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was null false CLOUD EXT (OK)
+ setObject(byte[]) as batch getString=EncodedString: > 12857 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 32 < was null false CLOUD EXT (OK)
setObject(java.sql.Date) getString=2004-02-14 was null false JDBC MATCH(OK)
+ setObject(java.sql.Date) as batch getString=2004-02-14 was null false JDBC MATCH(OK)
setObject(java.sql.Time) getString=13:26:42 was null false JDBC MATCH(OK)
+ setObject(java.sql.Time) as batch getString=13:26:42 was null false JDBC MATCH(OK)
setObject(java.sql.Timestamp) getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+ setObject(java.sql.Timestamp) as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
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 CHAR(60), INOUT P2 CHAR(60), OUT P3 CHAR(60)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
INOUT CHAR(60) registerOutParameter(Types.TINYINT) -- OK
OUT CHAR(60) registerOutParameter(Types.TINYINT) -- OK
@@ -1804,43 +2028,71 @@
setString(null) getString=null was null true JDBC MATCH(OK)
setString(null) as batch getString=null was null true JDBC MATCH(OK)
setBytes() getString=EncodedString: > 1027 64963 29440 < was null false CLOUD EXT (OK)
+ setBytes() as batchgetString=EncodedString: > 1027 64963 29440 < was null false CLOUD EXT (OK)
setBytes(null) getString=null was null true CLOUD EXT (OK)
+ setBytes(null) as batchgetString=null was null true CLOUD EXT (OK)
setDate() getString=2004-02-14 was null false JDBC MATCH(OK)
setDate() as batch getString=2004-02-14 was null false JDBC MATCH(OK)
setDate(null) getString=null was null true JDBC MATCH(OK)
setDate(null) as batch getString=null was null true JDBC MATCH(OK)
setTime() getString=13:26:42 was null false JDBC MATCH(OK)
+ setTime() as batch getString=13:26:42 was null false JDBC MATCH(OK)
setTime(null) getString=null was null true JDBC MATCH(OK)
+ setTime(null) as batch getString=null was null true JDBC MATCH(OK)
setTimestamp() getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
setTimestamp() as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
setTimestamp(null) getString=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getString=null was null true JDBC MATCH(OK)
setAsciiStream() getString=eg012d was null false JDBC MATCH(OK)
+ setAsciiStream() as batch getString=eg012d was null false JDBC MATCH(OK)
setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
+ setAsciiStream(null) as batch getString=null was null true JDBC MATCH(OK)
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() getString=89 was null false JDBC MATCH(OK)
+ setCharacterStream() as batch getString=89 was null false JDBC MATCH(OK)
setCharacterStream(null) getString=null was null true JDBC MATCH(OK)
+ setCharacterStream(null) as batch getString=null was null true JDBC MATCH(OK)
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 'VARCHAR' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'VARCHAR' from a data value of type 'null'.
setObject(java.lang.String) getString=46 was null false JDBC MATCH(OK)
+ setObject(java.lang.String) as batch getString=46 was null false JDBC MATCH(OK)
setObject(java.math.BigDecimal) getString=72 was null false JDBC MATCH(OK)
+ setObject(java.math.BigDecimal) as batch getString=72 was null false JDBC MATCH(OK)
setObject(java.lang.Boolean) getString=1 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) as batch getString=1 was null false JDBC MATCH(OK)
setObject(java.lang.Integer) getString=74 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) as batch getString=74 was null false JDBC MATCH(OK)
setObject(java.lang.Long) getString=79 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) as batch getString=79 was null false JDBC MATCH(OK)
setObject(java.lang.Float) getString=76.3 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) as batch getString=76.3 was null false JDBC MATCH(OK)
setObject(java.lang.Double) getString=12.33 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) as batch getString=12.33 was null false JDBC MATCH(OK)
setObject(byte[]) getString=EncodedString: > 12857 < was null false CLOUD EXT (OK)
+ setObject(byte[]) as batch getString=EncodedString: > 12857 < was null false CLOUD EXT (OK)
setObject(java.sql.Date) getString=2004-02-14 was null false JDBC MATCH(OK)
+ setObject(java.sql.Date) as batch getString=2004-02-14 was null false JDBC MATCH(OK)
setObject(java.sql.Time) getString=13:26:42 was null false JDBC MATCH(OK)
+ setObject(java.sql.Time) as batch getString=13:26:42 was null false JDBC MATCH(OK)
setObject(java.sql.Timestamp) getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+ setObject(java.sql.Timestamp) as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
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 VARCHAR(60), INOUT P2 VARCHAR(60), OUT P3 VARCHAR(60)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
INOUT VARCHAR(60) registerOutParameter(Types.TINYINT) -- OK
OUT VARCHAR(60) registerOutParameter(Types.TINYINT) -- OK
@@ -2010,43 +2262,71 @@
setString(null) getString=null was null true JDBC MATCH(OK)
setString(null) as batch getString=null was null true JDBC MATCH(OK)
setBytes() getString=EncodedString: > 1027 64963 29440 < was null false CLOUD EXT (OK)
+ setBytes() as batchgetString=EncodedString: > 1027 64963 29440 < was null false CLOUD EXT (OK)
setBytes(null) getString=null was null true CLOUD EXT (OK)
+ setBytes(null) as batchgetString=null was null true CLOUD EXT (OK)
setDate() getString=2004-02-14 was null false JDBC MATCH(OK)
setDate() as batch getString=2004-02-14 was null false JDBC MATCH(OK)
setDate(null) getString=null was null true JDBC MATCH(OK)
setDate(null) as batch getString=null was null true JDBC MATCH(OK)
setTime() getString=13:26:42 was null false JDBC MATCH(OK)
+ setTime() as batch getString=13:26:42 was null false JDBC MATCH(OK)
setTime(null) getString=null was null true JDBC MATCH(OK)
+ setTime(null) as batch getString=null was null true JDBC MATCH(OK)
setTimestamp() getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
setTimestamp() as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
setTimestamp(null) getString=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getString=null was null true JDBC MATCH(OK)
setAsciiStream() getString=eg012d was null false JDBC MATCH(OK)
+ setAsciiStream() as batch getString=eg012d was null false JDBC MATCH(OK)
setAsciiStream(null) getString=null was null true JDBC MATCH(OK)
+ setAsciiStream(null) as batch getString=null was null true JDBC MATCH(OK)
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() getString=89 was null false JDBC MATCH(OK)
+ setCharacterStream() as batch getString=89 was null false JDBC MATCH(OK)
setCharacterStream(null) getString=null was null true JDBC MATCH(OK)
+ setCharacterStream(null) as batch getString=null was null true JDBC MATCH(OK)
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 'LONG VARCHAR' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'LONG VARCHAR' from a data value of type 'null'.
setObject(java.lang.String) getString=46 was null false JDBC MATCH(OK)
+ setObject(java.lang.String) as batch getString=46 was null false JDBC MATCH(OK)
setObject(java.math.BigDecimal) getString=72 was null false JDBC MATCH(OK)
+ setObject(java.math.BigDecimal) as batch getString=72 was null false JDBC MATCH(OK)
setObject(java.lang.Boolean) getString=1 was null false JDBC MATCH(OK)
+ setObject(java.lang.Boolean) as batch getString=1 was null false JDBC MATCH(OK)
setObject(java.lang.Integer) getString=74 was null false JDBC MATCH(OK)
+ setObject(java.lang.Integer) as batch getString=74 was null false JDBC MATCH(OK)
setObject(java.lang.Long) getString=79 was null false JDBC MATCH(OK)
+ setObject(java.lang.Long) as batch getString=79 was null false JDBC MATCH(OK)
setObject(java.lang.Float) getString=76.3 was null false JDBC MATCH(OK)
+ setObject(java.lang.Float) as batch getString=76.3 was null false JDBC MATCH(OK)
setObject(java.lang.Double) getString=12.33 was null false JDBC MATCH(OK)
+ setObject(java.lang.Double) as batch getString=12.33 was null false JDBC MATCH(OK)
setObject(byte[]) getString=EncodedString: > 12857 < was null false CLOUD EXT (OK)
+ setObject(byte[]) as batch getString=EncodedString: > 12857 < was null false CLOUD EXT (OK)
setObject(java.sql.Date) getString=2004-02-14 was null false JDBC MATCH(OK)
+ setObject(java.sql.Date) as batch getString=2004-02-14 was null false JDBC MATCH(OK)
setObject(java.sql.Time) getString=13:26:42 was null false JDBC MATCH(OK)
+ setObject(java.sql.Time) as batch getString=13:26:42 was null false JDBC MATCH(OK)
setObject(java.sql.Timestamp) getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+ setObject(java.sql.Timestamp) as batch getString=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
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 LONG VARCHAR, INOUT P2 LONG VARCHAR, OUT P3 LONG VARCHAR) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
42962:Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions.
getXXX on : CHAR(60) FOR BIT DATA
@@ -2162,43 +2442,71 @@
setString(null) IC JDBC MATCH (INVALID)
setString(null) as batch IC JDBC MATCH (INVALID)
setBytes() getBytes=0x4,0x3 was null false JDBC MATCH(OK)
+ setBytes() as batchgetBytes=0x4,0x3 was null false JDBC MATCH(OK)
setBytes(null) getBytes=null was null true JDBC MATCH(OK)
+ setBytes(null) as batchgetBytes=null was null true JDBC MATCH(OK)
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() getBytes=0x82,0x43 was null false JDBC MATCH(OK)
+ setBinaryStream() as batch getBytes=0x82,0x43 was null false JDBC MATCH(OK)
setBinaryStream(null) getBytes=null was null true JDBC MATCH(OK)
+ setBinaryStream(null) as batch getBytes=null was null true JDBC MATCH(OK)
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 FAIL VARCHAR(60) FOR BIT DATA
setUnicodeStream(null) (0A000):Feature not implemented: setUnicodeStream. JDBC FAIL VARCHAR(60) FOR BIT DATA
setObject(null) OK An attempt was made to get a data value of type 'VARCHAR () FOR BIT DATA' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'VARCHAR () FOR BIT DATA' from a data value of type 'null'.
setObject(java.lang.String) (XCL12):An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. JDBC FAIL VARCHAR(60) FOR BIT DATA
+ setObject(java.lang.String) as batch (XCL12):An attempt was made to put a data value of type 'java.lang.String' into a data value of type 'VARCHAR () FOR BIT DATA'. JDBC FAIL VARCHAR(60) FOR BIT DATA
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
+ setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Boolean) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Integer) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Integer) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Long) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Long) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Float) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Float) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Double) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Double) as batch IC JDBC MATCH (INVALID)
setObject(byte[]) getBytes=0x32,0x39 was null false JDBC MATCH(OK)
+ setObject(byte[]) as batch getBytes=0x32,0x39 was null false JDBC MATCH(OK)
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 VARCHAR(60) FOR BIT DATA, INOUT P2 VARCHAR(60) FOR BIT DATA, OUT P3 VARCHAR(60) FOR BIT DATA) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
INOUT VARCHAR(60) FOR BIT DATA registerOutParameter(Types.TINYINT) -- XCL25
OUT VARCHAR(60) FOR BIT DATA registerOutParameter(Types.TINYINT) -- XCL25
@@ -2353,43 +2661,71 @@
setString(null) getDate=null was null true JDBC MATCH(OK)
setString(null) as batch getDate=null was null true JDBC MATCH(OK)
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() getDate=2004-02-14 was null false JDBC MATCH(OK)
setDate() as batch getDate=2004-02-14 was null false JDBC MATCH(OK)
setDate(null) getDate=null was null true JDBC MATCH(OK)
setDate(null) as batch getDate=null was null true JDBC MATCH(OK)
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() getDate=2004-02-23 was null false JDBC MATCH(OK)
setTimestamp() as batch getDate=2004-02-23 was null false JDBC MATCH(OK)
setTimestamp(null) getDate=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getDate=null was null true JDBC MATCH(OK)
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 'DATE' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'DATE' from a data value of type 'null'.
setObject(java.lang.String) (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
+ setObject(java.lang.String) as batch (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
+ setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Boolean) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Integer) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Integer) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Long) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Long) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Float) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Float) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Double) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Double) as batch IC JDBC MATCH (INVALID)
setObject(byte[]) IC JDBC MATCH (INVALID)
+ setObject(byte[]) as batch IC JDBC MATCH (INVALID)
setObject(java.sql.Date) getDate=2004-02-14 was null false JDBC MATCH(OK)
+ setObject(java.sql.Date) as batch getDate=2004-02-14 was null false JDBC MATCH(OK)
setObject(java.sql.Time) IC JDBC MATCH (INVALID)
+ setObject(java.sql.Time) as batch IC JDBC MATCH (INVALID)
setObject(java.sql.Timestamp) getDate=2004-02-23 was null false JDBC MATCH(OK)
+ setObject(java.sql.Timestamp) as batch getDate=2004-02-23 was null false JDBC MATCH(OK)
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 DATE, INOUT P2 DATE, OUT P3 DATE) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
INOUT DATE registerOutParameter(Types.TINYINT) -- XCL25
OUT DATE registerOutParameter(Types.TINYINT) -- XCL25
@@ -2546,43 +2882,71 @@
setString(null) getTime=null was null true JDBC MATCH(OK)
setString(null) as batch getTime=null was null true JDBC MATCH(OK)
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() getTime=13:26:42 was null false JDBC MATCH(OK)
+ setTime() as batch getTime=13:26:42 was null false JDBC MATCH(OK)
setTime(null) getTime=null was null true JDBC MATCH(OK)
+ setTime(null) as batch getTime=null was null true JDBC MATCH(OK)
setTimestamp() getTime=17:14:24 was null false JDBC MATCH(OK)
setTimestamp() as batch getTime=17:14:24 was null false JDBC MATCH(OK)
setTimestamp(null) getTime=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getTime=null was null true JDBC MATCH(OK)
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 'TIME' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'TIME' from a data value of type 'null'.
setObject(java.lang.String) (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
+ setObject(java.lang.String) as batch (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
+ setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Boolean) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Integer) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Integer) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Long) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Long) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Float) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Float) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Double) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Double) as batch IC JDBC MATCH (INVALID)
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) getTime=13:26:42 was null false JDBC MATCH(OK)
+ setObject(java.sql.Time) as batch getTime=13:26:42 was null false JDBC MATCH(OK)
setObject(java.sql.Timestamp) getTime=17:14:24 was null false JDBC MATCH(OK)
+ setObject(java.sql.Timestamp) as batch getTime=17:14:24 was null false JDBC MATCH(OK)
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 TIME, INOUT P2 TIME, OUT P3 TIME) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
INOUT TIME registerOutParameter(Types.TINYINT) -- XCL25
OUT TIME registerOutParameter(Types.TINYINT) -- XCL25
@@ -2740,43 +3104,71 @@
setString(null) getTimestamp=null was null true JDBC MATCH(OK)
setString(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
setBytes() IC JDBC MATCH (INVALID)
+ setBytes() as batchIC JDBC MATCH (INVALID)
setBytes(null) IC JDBC MATCH (INVALID)
- setDate() getTimestamp=00:00:00 was null false JDBC MATCH(OK)
- setDate() as batch getTimestamp=00:00:00 was null false JDBC MATCH(OK)
+ setBytes(null) as batchIC JDBC MATCH (INVALID)
+ setDate() getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+ setDate() as batch getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
setDate(null) getTimestamp=null was null true JDBC MATCH(OK)
setDate(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
- setTime() getTimestamp=13:26:42 was null false JDBC MATCH(OK)
+ setTime() getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+ setTime() as batch getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
setTime(null) getTimestamp=null was null true JDBC MATCH(OK)
- setTimestamp() getTimestamp=17:14:24 was null false JDBC MATCH(OK)
- setTimestamp() as batch getTimestamp=17:14:24 was null false JDBC MATCH(OK)
+ setTime(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
+ setTimestamp() getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+ setTimestamp() as batch getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
setTimestamp(null) getTimestamp=null was null true JDBC MATCH(OK)
setTimestamp(null) as batch getTimestamp=null was null true JDBC MATCH(OK)
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 'TIMESTAMP' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'TIMESTAMP' from a data value of type 'null'.
setObject(java.lang.String) (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
+ setObject(java.lang.String) as batch (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
+ setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Boolean) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Integer) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Integer) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Long) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Long) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Float) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Float) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Double) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Double) as batch IC JDBC MATCH (INVALID)
setObject(byte[]) IC JDBC MATCH (INVALID)
- setObject(java.sql.Date) getTimestamp=00:00:00 was null false JDBC MATCH(OK)
- setObject(java.sql.Time) getTimestamp=13:26:42 was null false CLOUD EXT (OK)
- setObject(java.sql.Timestamp) getTimestamp=17:14:24 was null false JDBC MATCH(OK)
+ setObject(byte[]) as batch IC JDBC MATCH (INVALID)
+ setObject(java.sql.Date) getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+ setObject(java.sql.Date) as batch getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+ setObject(java.sql.Time) getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false CLOUD EXT (OK)
+ setObject(java.sql.Time) as batch getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false CLOUD EXT (OK)
+ setObject(java.sql.Timestamp) getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
+ setObject(java.sql.Timestamp) as batch getTimestamp=xxxxxxFILTERED-TIMESTAMPxxxxxwas null false JDBC MATCH(OK)
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 TIMESTAMP, INOUT P2 TIMESTAMP, OUT P3 TIMESTAMP) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
INOUT TIMESTAMP registerOutParameter(Types.TINYINT) -- XCL25
OUT TIMESTAMP registerOutParameter(Types.TINYINT) -- XCL25
@@ -2934,43 +3326,71 @@
setString(null) getClob=null was null true CLOUD EXT (OK)
setString(null) as batch getClob=null was null true CLOUD EXT (OK)
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() getClob=0x65,0x67 was null false JDBC MATCH(OK)
+ setAsciiStream() as batch getClob=0x65,0x67 was null false JDBC MATCH(OK)
setAsciiStream(null) getClob=null was null true JDBC MATCH(OK)
+ setAsciiStream(null) as batch getClob=null was null true JDBC MATCH(OK)
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() getClob=0x38,0x39 was null false JDBC MATCH(OK)
+ setCharacterStream() as batch getClob=0x38,0x39 was null false JDBC MATCH(OK)
setCharacterStream(null) getClob=null was null true JDBC MATCH(OK)
+ setCharacterStream(null) as batch getClob=null was null true JDBC MATCH(OK)
setClob() getClob=0x37,0x32 was null false JDBC MATCH(OK)
+ setClob() as batch getClob=0x37,0x32 was null false JDBC MATCH(OK)
setClob(null) getClob=null was null true JDBC MATCH(OK)
+ setClob(null) as batch getClob=null was null true JDBC MATCH(OK)
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 'CLOB' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'CLOB' from a data value of type 'null'.
setObject(java.lang.String) getClob=0x34,0x36 was null false CLOUD EXT (OK)
+ setObject(java.lang.String) as batch getClob=0x34,0x36 was null false CLOUD EXT (OK)
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
+ setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Boolean) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Integer) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Integer) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Long) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Long) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Float) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Float) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Double) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Double) as batch IC JDBC MATCH (INVALID)
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) getClob=0x37,0x32 was null false JDBC MATCH(OK)
+ setObject(java.sql.Clob) as batch getClob=0x37,0x32 was null false JDBC MATCH(OK)
CREATE PROCEDURE PMP.TYPE_AS(IN P1 CLOB(1k), INOUT P2 CLOB(1k), OUT P3 CLOB(1k)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
42962:Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions.
getXXX on : BLOB(1k)
@@ -3084,42 +3504,70 @@
setString(null) IC JDBC MATCH (INVALID)
setString(null) as batch IC JDBC MATCH (INVALID)
setBytes() getBlob=0x4,0x3 was null false CLOUD EXT (OK)
+ setBytes() as batchgetBlob=0x4,0x3 was null false CLOUD EXT (OK)
setBytes(null) getBlob=null was null true CLOUD EXT (OK)
+ setBytes(null) as batchgetBlob=null was null true CLOUD EXT (OK)
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() getBlob=0x82,0x43 was null false JDBC MATCH(OK)
+ setBinaryStream() as batch getBlob=0x82,0x43 was null false JDBC MATCH(OK)
setBinaryStream(null) getBlob=null was null true JDBC MATCH(OK)
+ setBinaryStream(null) as batch getBlob=null was null true JDBC MATCH(OK)
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() getBlob=0x32,0x43 was null false JDBC MATCH(OK)
+ setBlob() as batch getBlob=0x32,0x43 was null false JDBC MATCH(OK)
setBlob(null) getBlob=null was null true JDBC MATCH(OK)
+ setBlob(null) as batch getBlob=null was null true JDBC MATCH(OK)
setUnicodeStream() (0A000):Feature not implemented: setUnicodeStream. JDBC FAIL BLOB(1k)
setUnicodeStream(null) (0A000):Feature not implemented: setUnicodeStream. JDBC FAIL BLOB(1k)
setObject(null) OK An attempt was made to get a data value of type 'BLOB' from a data value of type 'null'.
+ setObject(null) as batch OK An attempt was made to get a data value of type 'BLOB' from a data value of type 'null'.
setObject(java.lang.String) IC JDBC MATCH (INVALID)
+ setObject(java.lang.String) as batch IC JDBC MATCH (INVALID)
setObject(java.math.BigDecimal) IC JDBC MATCH (INVALID)
+ setObject(java.math.BigDecimal) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Boolean) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Boolean) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Integer) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Integer) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Long) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Long) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Float) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Float) as batch IC JDBC MATCH (INVALID)
setObject(java.lang.Double) IC JDBC MATCH (INVALID)
+ setObject(java.lang.Double) as batch IC JDBC MATCH (INVALID)
setObject(byte[]) getBlob=0x32,0x39 was null false CLOUD EXT (OK)
+ setObject(byte[]) as batch getBlob=0x32,0x39 was null false CLOUD EXT (OK)
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) getBlob=0x32,0x43 was null false JDBC MATCH(OK)
+ setObject(java.sql.Blob) as batch getBlob=0x32,0x43 was null false JDBC MATCH(OK)
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 BLOB(1k), INOUT P2 BLOB(1k), OUT P3 BLOB(1k)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.pmap'
42962:Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions.