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 fu...@apache.org on 2005/06/13 23:41:35 UTC
svn commit: r190514 [2/7] - in /incubator/derby/code/branches/10.1/java:
engine/org/apache/derby/iapi/reference/
engine/org/apache/derby/iapi/services/io/
engine/org/apache/derby/iapi/services/loader/
engine/org/apache/derby/iapi/types/ engine/org/apache/derby/impl/jdbc/
engine/org/apache/derby/impl/sql/compile/ engine/org/apache/derby/loc/
testing/org/apache/derbyTesting/functionTests/master/
testing/org/apache/derbyTesting/functionTests/master/DerbyNet/
testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/
testing/org/apache/derbyTesting/functionTests/master/j9_13/
testing/org/apache/derbyTesting/functionTests/master/j9_22/
testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/
testing/org/apache/derbyTesting/functionTests/tests/lang/
testing/org/apache/derbyTesting/functionTests/tests/tools/
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/parameterMapping.out Mon Jun 13 14:41:33 2005
@@ -92,24 +92,39 @@
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)
setBytes() IC JDBC MATCH (INVALID)
setBytes(null) getShort=0 was null true CLOUD EXT (OK)
setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'SMALLINT'. JDBC MATCH (INVALID)
setDate(null) getShort=0 was null true CLOUD EXT (OK)
+ setDate(null) as batch getShort=0 was null true CLOUD EXT (OK)
setTime() IC JDBC MATCH (INVALID)
setTime(null) getShort=0 was null true CLOUD EXT (OK)
setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'SMALLINT'. JDBC MATCH (INVALID)
setTimestamp(null) getShort=0 was null true CLOUD EXT (OK)
+ setTimestamp(null) as batch getShort=0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type SMALLINT. JDBC MATCH (INVALID)
setAsciiStream(null) getShort=0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -223,24 +238,39 @@
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)
setBytes() IC JDBC MATCH (INVALID)
setBytes(null) getInt=0 was null true CLOUD EXT (OK)
setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'INTEGER'. JDBC MATCH (INVALID)
setDate(null) getInt=0 was null true CLOUD EXT (OK)
+ setDate(null) as batch getInt=0 was null true CLOUD EXT (OK)
setTime() IC JDBC MATCH (INVALID)
setTime(null) getInt=0 was null true CLOUD EXT (OK)
setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'INTEGER'. JDBC MATCH (INVALID)
setTimestamp(null) getInt=0 was null true CLOUD EXT (OK)
+ setTimestamp(null) as batch getInt=0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type INTEGER. JDBC MATCH (INVALID)
setAsciiStream(null) getInt=0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -354,24 +384,39 @@
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)
setBytes() IC JDBC MATCH (INVALID)
setBytes(null) getLong=0 was null true CLOUD EXT (OK)
setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'BIGINT'. JDBC MATCH (INVALID)
setDate(null) getLong=0 was null true CLOUD EXT (OK)
+ setDate(null) as batch getLong=0 was null true CLOUD EXT (OK)
setTime() IC JDBC MATCH (INVALID)
setTime(null) getLong=0 was null true CLOUD EXT (OK)
setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'BIGINT'. JDBC MATCH (INVALID)
setTimestamp(null) getLong=0 was null true CLOUD EXT (OK)
+ setTimestamp(null) as batch getLong=0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type BIGINT. JDBC MATCH (INVALID)
setAsciiStream(null) getLong=0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -485,24 +530,39 @@
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)
setBytes() IC JDBC MATCH (INVALID)
setBytes(null) getFloat=0.0 was null true CLOUD EXT (OK)
setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'REAL'. JDBC MATCH (INVALID)
setDate(null) getFloat=0.0 was null true CLOUD EXT (OK)
+ setDate(null) as batch getFloat=0.0 was null true CLOUD EXT (OK)
setTime() IC JDBC MATCH (INVALID)
setTime(null) getFloat=0.0 was null true CLOUD EXT (OK)
setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'REAL'. JDBC MATCH (INVALID)
setTimestamp(null) getFloat=0.0 was null true CLOUD EXT (OK)
+ setTimestamp(null) as batch getFloat=0.0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type REAL. JDBC MATCH (INVALID)
setAsciiStream(null) getFloat=0.0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -617,24 +677,39 @@
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)
setBytes() IC JDBC MATCH (INVALID)
setBytes(null) getDouble=0.0 was null true CLOUD EXT (OK)
setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'DOUBLE'. JDBC MATCH (INVALID)
setDate(null) getDouble=0.0 was null true CLOUD EXT (OK)
+ setDate(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setTime() IC JDBC MATCH (INVALID)
setTime(null) getDouble=0.0 was null true CLOUD EXT (OK)
setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'DOUBLE'. JDBC MATCH (INVALID)
setTimestamp(null) getDouble=0.0 was null true CLOUD EXT (OK)
+ setTimestamp(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
setAsciiStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -748,24 +823,39 @@
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)
setBytes() IC JDBC MATCH (INVALID)
setBytes(null) getDouble=0.0 was null true CLOUD EXT (OK)
setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'DOUBLE'. JDBC MATCH (INVALID)
setDate(null) getDouble=0.0 was null true CLOUD EXT (OK)
+ setDate(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setTime() IC JDBC MATCH (INVALID)
setTime(null) getDouble=0.0 was null true CLOUD EXT (OK)
setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'DOUBLE'. JDBC MATCH (INVALID)
setTimestamp(null) getDouble=0.0 was null true CLOUD EXT (OK)
+ setTimestamp(null) as batch getDouble=0.0 was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type DOUBLE. JDBC MATCH (INVALID)
setAsciiStream(null) getDouble=0.0 was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -879,24 +969,39 @@
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)
setBytes() IC JDBC MATCH (INVALID)
setBytes(null) getBigDecimal=null was null true CLOUD EXT (OK)
setDate() IC JDBC MATCH (INVALID)
+ setDate() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Date' into a data value of type 'DECIMAL'. JDBC MATCH (INVALID)
setDate(null) getBigDecimal=null was null true CLOUD EXT (OK)
+ setDate(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
setTime() IC JDBC MATCH (INVALID)
setTime(null) getBigDecimal=null was null true CLOUD EXT (OK)
setTimestamp() IC JDBC MATCH (INVALID)
+ setTimestamp() as batch (?????):Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch. Use getNextException() to retrieve the exceptions for specific batched elements. (XCL12):Error for batch element #0: An attempt was made to put a data value of type 'java.sql.Timestamp' into a data value of type 'DECIMAL'. JDBC MATCH (INVALID)
setTimestamp(null) getBigDecimal=null was null true CLOUD EXT (OK)
+ setTimestamp(null) as batch getBigDecimal=null was null true CLOUD EXT (OK)
setAsciiStream() (22018):Invalid character string format for type DECIMAL. JDBC MATCH (INVALID)
setAsciiStream(null) getBigDecimal=null was null true CLOUD EXT (OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1016,24 +1121,39 @@
setXXX() with all JDBC Types on CHAR(60)
For setXXX() methods that pass an object, a null and valid values are checked
setByte() getString=98 was null false JDBC MATCH(OK)
+ setByte() as batch getString=98 was null false JDBC MATCH(OK)
setShort() getString=98 was null false JDBC MATCH(OK)
+ setShort() as batch getString=98 was null false JDBC MATCH(OK)
setInt() getString=98 was null false JDBC MATCH(OK)
+ setInt() as batch getString=98 was null false JDBC MATCH(OK)
setLong() getString=98 was null false JDBC MATCH(OK)
+ setLong() as batch getString=98 was null false JDBC MATCH(OK)
setFloat() getString=98.4 was null false JDBC MATCH(OK)
+ setFloat() as batch getString=98.4 was null false JDBC MATCH(OK)
setDouble() getString=98.5 was null false JDBC MATCH(OK)
+ setDouble() as batch getString=98.5 was null false JDBC MATCH(OK)
setBigDecimal() getString=99 was null false JDBC MATCH(OK)
+ setBigDecimal() as batch getString=99 was null false JDBC MATCH(OK)
setBigDecimal(null) getString=null was null true JDBC MATCH(OK)
+ setBigDecimal(null) as batch getString=null was null true JDBC MATCH(OK)
setBoolean() getString=1 was null false JDBC MATCH(OK)
+ setBoolean() as batch getString=1 was null false JDBC MATCH(OK)
setString() getString=97 was null false JDBC MATCH(OK)
+ setString() as batch getString=97 was null false JDBC MATCH(OK)
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(null) getString=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(null) 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(null) getString=null was null true JDBC MATCH(OK)
setBinaryStream() getString=EncodedString: > 33347 51966 50 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)
@@ -1147,24 +1267,39 @@
setXXX() with all JDBC Types on VARCHAR(60)
For setXXX() methods that pass an object, a null and valid values are checked
setByte() getString=98 was null false JDBC MATCH(OK)
+ setByte() as batch getString=98 was null false JDBC MATCH(OK)
setShort() getString=98 was null false JDBC MATCH(OK)
+ setShort() as batch getString=98 was null false JDBC MATCH(OK)
setInt() getString=98 was null false JDBC MATCH(OK)
+ setInt() as batch getString=98 was null false JDBC MATCH(OK)
setLong() getString=98 was null false JDBC MATCH(OK)
+ setLong() as batch getString=98 was null false JDBC MATCH(OK)
setFloat() getString=98.4 was null false JDBC MATCH(OK)
+ setFloat() as batch getString=98.4 was null false JDBC MATCH(OK)
setDouble() getString=98.5 was null false JDBC MATCH(OK)
+ setDouble() as batch getString=98.5 was null false JDBC MATCH(OK)
setBigDecimal() getString=99 was null false JDBC MATCH(OK)
+ setBigDecimal() as batch getString=99 was null false JDBC MATCH(OK)
setBigDecimal(null) getString=null was null true JDBC MATCH(OK)
+ setBigDecimal(null) as batch getString=null was null true JDBC MATCH(OK)
setBoolean() getString=1 was null false JDBC MATCH(OK)
+ setBoolean() as batch getString=1 was null false JDBC MATCH(OK)
setString() getString=97 was null false JDBC MATCH(OK)
+ setString() as batch getString=97 was null false JDBC MATCH(OK)
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(null) getString=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(null) 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(null) getString=null was null true JDBC MATCH(OK)
setBinaryStream() getString=EncodedString: > 33347 51966 50 < was null false CLOUD EXT (OK)
@@ -1278,24 +1413,39 @@
setXXX() with all JDBC Types on LONG VARCHAR
For setXXX() methods that pass an object, a null and valid values are checked
setByte() getString=98 was null false JDBC MATCH(OK)
+ setByte() as batch getString=98 was null false JDBC MATCH(OK)
setShort() getString=98 was null false JDBC MATCH(OK)
+ setShort() as batch getString=98 was null false JDBC MATCH(OK)
setInt() getString=98 was null false JDBC MATCH(OK)
+ setInt() as batch getString=98 was null false JDBC MATCH(OK)
setLong() getString=98 was null false JDBC MATCH(OK)
+ setLong() as batch getString=98 was null false JDBC MATCH(OK)
setFloat() getString=98.4 was null false JDBC MATCH(OK)
+ setFloat() as batch getString=98.4 was null false JDBC MATCH(OK)
setDouble() getString=98.5 was null false JDBC MATCH(OK)
+ setDouble() as batch getString=98.5 was null false JDBC MATCH(OK)
setBigDecimal() getString=99 was null false JDBC MATCH(OK)
+ setBigDecimal() as batch getString=99 was null false JDBC MATCH(OK)
setBigDecimal(null) getString=null was null true JDBC MATCH(OK)
+ setBigDecimal(null) as batch getString=null was null true JDBC MATCH(OK)
setBoolean() getString=1 was null false JDBC MATCH(OK)
+ setBoolean() as batch getString=1 was null false JDBC MATCH(OK)
setString() getString=97 was null false JDBC MATCH(OK)
+ setString() as batch getString=97 was null false JDBC MATCH(OK)
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(null) getString=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(null) 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(null) getString=null was null true JDBC MATCH(OK)
setBinaryStream() getString=EncodedString: > 33347 51966 50 < was null false CLOUD EXT (OK)
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/procedure.out Mon Jun 13 14:41:33 2005
@@ -51,6 +51,27 @@
EXPECTED SQL Exception: (42Y03) 'APP.NSP' is not recognized as a function or procedure.
call syscs_util.syscs_set_database_property("foo", "bar")
EXPECTED SQL Exception: (42X15) Column name 'foo' appears in a statement without a FROM list.
+signature mismatched types
+CALL APP.SIGNATURE_BUG_DERBY_258_A(4)
+EXPECTED SQL Exception: (22005) An attempt was made to get a data value of type 'java.lang.String' from a data value of type 'INTEGER'.
+signature too many parameters
+VALUES APP.SIGNATURE_BUG_DERBY_258_B(4)
+EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (2) of parameters, expected 1.
+signature too few parameters
+CALL APP.SIGNATURE_BUG_DERBY_258_C(4)
+EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (0) of parameters, expected 1.
+signature invalid format
+CALL APP.SIGNATURE_BUG_DERBY_258_F(4)
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
+signature invalid format
+CALL APP.SIGNATURE_BUG_DERBY_258_G(4)
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
+signature invalid format
+CALL APP.SIGNATURE_BUG_DERBY_258_H(4)
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
+signature invalid format
+CALL APP.SIGNATURE_BUG_DERBY_258_I(4)
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
testDelayedClassChecking
call noclass()
EXPECTED SQL Exception: (42X51) The class 'asdf' does not exist or is inaccessible. This can happen if the class is not public. SQLSTATE: XJ001: Java exception: 'asdf: java.lang.ClassNotFoundException'.
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/synonym.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/synonym.out?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/synonym.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/synonym.out Mon Jun 13 14:41:33 2005
@@ -216,6 +216,54 @@
0 rows inserted/updated/deleted
ij> drop synonym synPrimary;
0 rows inserted/updated/deleted
+ij> -- Tests with non existant schemas
+----- Implicitly creates junkSchema
+create synonym junkSchema.syn1 for table2;
+0 rows inserted/updated/deleted
+WARNING 01522: The newly defined synonym 'SYN1' resolved to the object 'JUNKSCHEMA.TABLE2' which is currently undefined. :
+ij> select * from junkSchema.syn1;
+ERROR 42X05: Table 'JUNKSCHEMA.TABLE2' does not exist.
+ij> set schema junkSchema;
+0 rows inserted/updated/deleted
+ij> create table table2(c char(10));
+0 rows inserted/updated/deleted
+ij> select * from syn1;
+C
+-----
+ij> set schema APP;
+0 rows inserted/updated/deleted
+ij> -- Should resolve to junkSchema.table2
+select * from junkSchema.syn1;
+C
+-----
+ij> drop table junkSchema.table2;
+0 rows inserted/updated/deleted
+ij> -- Should fail. Need to drop synonym first
+drop schema junkSchema restrict;
+ERROR X0Y54: Schema 'JUNKSCHEMA' cannot be dropped because it is not empty.
+ij> drop synonym junkSchema.syn1;
+0 rows inserted/updated/deleted
+ij> drop schema junkSchema restrict;
+0 rows inserted/updated/deleted
+ij> -- Test with target schema missing
+create synonym mySynonym for notPresent.t1;
+0 rows inserted/updated/deleted
+WARNING 01522: The newly defined synonym 'MYSYNONYM' resolved to the object 'NOTPRESENT.T1' which is currently undefined. :
+ij> select * from mySynonym;
+ERROR 42Y07: Schema 'NOTPRESENT' does not exist
+ij> create table notPresent.t1(j int, c char(10));
+0 rows inserted/updated/deleted
+ij> insert into notPresent.t1 values (100, 'satheesh');
+1 row inserted/updated/deleted
+ij> -- Should resolve now
+select * from mySynonym;
+J |C
+-----
+100 |satheesh
+ij> drop table notPresent.t1;
+0 rows inserted/updated/deleted
+ij> drop synonym mySynonym;
+0 rows inserted/updated/deleted
ij> -- Positive test case with three levels of synonym chaining
create schema synonymSchema;
0 rows inserted/updated/deleted
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/functions.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/functions.out?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/functions.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/functions.out Mon Jun 13 14:41:33 2005
@@ -488,4 +488,43 @@
EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.countRows'
LANGUAGE JAVA PARAMETER STYLE JAVA;
ERROR 42X01: Syntax error: MODIFIES SQL DATA.
+ij> CREATE FUNCTION SIGNATURE_BUG_DERBY_258_D(P_VAL INT, P_RADIX INT) RETURNS VARCHAR(20)
+LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+EXTERNAL NAME 'java.lang.Integer.toString(int, int)';
+0 rows inserted/updated/deleted
+ij> CREATE FUNCTION SIGNATURE_BUG_DERBY_258_NS(P_VAL INT, P_RADIX INT) RETURNS VARCHAR(20)
+LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+EXTERNAL NAME 'java.lang.Integer.toString';
+0 rows inserted/updated/deleted
+ij> CREATE FUNCTION SIGNATURE_BUG_DERBY_258_E() RETURNS VARCHAR(20)
+LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+EXTERNAL NAME 'java.lang.Integer.toXXString()';
+0 rows inserted/updated/deleted
+ij> -- these are ok
+VALUES SIGNATURE_BUG_DERBY_258_NS(2356, 16);
+1
+--------------------------------------------------------------------------------------------------------------------------------
+934
+ij> VALUES SIGNATURE_BUG_DERBY_258_NS(2356, 10);
+1
+--------------------------------------------------------------------------------------------------------------------------------
+2356
+ij> VALUES SIGNATURE_BUG_DERBY_258_NS(2356, 2);
+1
+--------------------------------------------------------------------------------------------------------------------------------
+100100110100
+ij> -- Must resolve as above
+VALUES SIGNATURE_BUG_DERBY_258_D(2356, 16);
+1
+--------------------------------------------------------------------------------------------------------------------------------
+934
+ij> -- no method to resolve to (with specified signature)
+VALUES SIGNATURE_BUG_DERBY_258_E();
+ERROR 42X50: No method was found that matched the method call java.lang.Integer.toXXString(), tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
+ij> DROP FUNCTION SIGNATURE_BUG_DERBY_258_D;
+0 rows inserted/updated/deleted
+ij> DROP FUNCTION SIGNATURE_BUG_DERBY_258_E;
+0 rows inserted/updated/deleted
+ij> DROP FUNCTION SIGNATURE_BUG_DERBY_258_NS;
+0 rows inserted/updated/deleted
ij>
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/distinct.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/distinct.out?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/distinct.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/distinct.out Mon Jun 13 14:41:33 2005
@@ -2280,9 +2280,9 @@
ij> -- . for update on a select distinct
-- both should get errors, not updatable.
select distinct d from u for update;
-ERROR 42Y90: FOR UPDATE is not permitted on this type of statement.
+ERROR 42Y90: FOR UPDATE is not permitted in this type of statement.
ij> select distinct d from u for update of d;
-ERROR 42Y90: FOR UPDATE is not permitted on this type of statement.
+ERROR 42Y90: FOR UPDATE is not permitted in this type of statement.
ij> -- . positioned update/delete on a select distinct
get cursor c1 as 'select distinct d from u';
ij> next c1;
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out Mon Jun 13 14:41:33 2005
@@ -1083,7 +1083,7 @@
(1.0e31, ,1.0e-31),
(-1.0e31, -1.0e-31 ),
select a from myNumeric;
-ERROR 42X80: VALUES clause must contain at least 1 element and all elements must be non-empty.
+ERROR 42X80: VALUES clause must contain at least one element. Empty elements are not allowed.
ij> select -a from myNumeric;
1
--------------------------------
@@ -1571,7 +1571,7 @@
----------------------
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> values{fn abs(-DOUBLE( NaN) )};
-ERROR 42X04: Column 'NAN' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'NAN' is not a column in the target table.
+ERROR 42X04: Column 'NAN' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'NAN' is not a column in the target table.
ij> values{fn abs( DOUBLE( 4.9E-324) )};
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> values{fn abs( DOUBLE( 1.7976931348623157E308) )};
@@ -1834,15 +1834,15 @@
values{ fn locate( 'hello', 'hello',-1 ) };
1
-----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer. The index to start the search from is '-1'. The string to search for is 'hello'. The string to search from is 'hello'.
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '-1'. The string to search for is 'hello'. The string to search from is 'hello'.
ij> values{ fn locate( 'hello', 'hello',-0 ) };
1
-----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is 'hello'. The string to search from is 'hello'.
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is 'hello'. The string to search from is 'hello'.
ij> values{ fn locate( 'hello', 'hello', 0 ) };
1
-----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is 'hello'. The string to search from is 'hello'.
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is 'hello'. The string to search from is 'hello'.
ij> values{ fn locate( 'hello', 'hello', 1 ) };
1
-----------
@@ -1862,7 +1862,7 @@
ij> values{ fn locate( 'hello', 'hellohello', 0 ) };
1
-----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is 'hello'. The string to search from is 'hellohello'.
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is 'hello'. The string to search from is 'hellohello'.
ij> values{ fn locate( 'hello', 'hellohello', 1 ) };
1
-----------
@@ -1910,15 +1910,15 @@
ij> values{ fn locate( '?', '?',-1 ) };
1
-----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer. The index to start the search from is '-1'. The string to search for is '?'. The string to search from is '?'.
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '-1'. The string to search for is '?'. The string to search from is '?'.
ij> values{ fn locate( '?', '?',-0 ) };
1
-----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is '?'. The string to search from is '?'.
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is '?'. The string to search from is '?'.
ij> values{ fn locate( '?', '?', 0 ) };
1
-----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is '?'. The string to search from is '?'.
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is '?'. The string to search from is '?'.
ij> values{ fn locate( '?', '?', 1 ) };
1
-----------
@@ -1930,7 +1930,7 @@
ij> values{ fn locate( '\', '\\',0) };
1
-----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is '\'. The string to search from is '\\'.
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is '\'. The string to search from is '\\'.
ij> values{ fn locate( '\', '\\',1) };
1
-----------
@@ -1946,7 +1946,7 @@
ij> values{ fn locate( '/', '//',0) };
1
-----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is '/'. The string to search from is '//'.
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is '/'. The string to search from is '//'.
ij> values{ fn locate( '/', '//',1) };
1
-----------
@@ -2747,11 +2747,11 @@
ij> select locate(a, b, 0) from foo;
1
-----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is 'abc'. The string to search from is 'abcd'.
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '0'. The string to search for is 'abc'. The string to search from is 'abcd'.
ij> select locate(a, b, -1) from foo;
1
-----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer. The index to start the search from is '-1'. The string to search for is 'abc'. The string to search from is 'abcd'.
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The index to start the search from is '-1'. The string to search for is 'abc'. The string to search from is 'abcd'.
ij> select locate(a, b, 1) from foo;
1
-----------
@@ -3477,7 +3477,7 @@
----------------------
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> values{fn sqrt(-DOUBLE( NaN) )};
-ERROR 42X04: Column 'NAN' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'NAN' is not a column in the target table.
+ERROR 42X04: Column 'NAN' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'NAN' is not a column in the target table.
ij> values{fn sqrt( DOUBLE( 4.9E-324) )};
ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
ij> values{fn sqrt( DOUBLE( 1.7976931348623157E308) )};
@@ -3598,7 +3598,7 @@
ij> select { fn mod(dbl, 3) } from modfn;
ERROR 42Y95: The 'mod' operator with a left operand type of 'DOUBLE' and a right operand type of 'INTEGER' is not supported.
ij> select { fn mod(67, t) } from modfn where s <> 0;
-ERROR 42X04: Column 'T' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'T' is not a column in the target table.
+ERROR 42X04: Column 'T' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'T' is not a column in the target table.
ij> select { fn mod(67, s) } from modfn where s <> 0;
1
-----------
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out Mon Jun 13 14:41:33 2005
@@ -1619,7 +1619,7 @@
ij> insert into t(r) values '1.0';
ERROR 42821: Columns of type 'REAL' cannot hold values of type 'CHAR'.
ij> update t set r = NaN;
-ERROR 42X04: Column 'NAN' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'NAN' is not a column in the target table.
+ERROR 42X04: Column 'NAN' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'NAN' is not a column in the target table.
ij> update t set r = +3.4021E+38;
0 rows inserted/updated/deleted
ij> update t set r = -3.4021E+38;
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out Mon Jun 13 14:41:33 2005
@@ -10,14 +10,14 @@
ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
ij> -- column in group by list not in from list
select a as d from t1 group by d;
-ERROR 42X04: Column 'D' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'D' is not a column in the target table.
+ERROR 42X04: Column 'D' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'D' is not a column in the target table.
ij> -- column in group by list not in select list
select a as b from t1 group by b;
-ERROR 42Y36: Column reference 'A' is invalid. For a SELECT with a GROUP BY, the SELECT list may only contain grouping columns and valid aggregate expressions.
+ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
ij> select a from t1 group by b;
-ERROR 42Y36: Column reference 'A' is invalid. For a SELECT with a GROUP BY, the SELECT list may only contain grouping columns and valid aggregate expressions.
+ERROR 42Y36: Column reference 'A' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
ij> select a, char(b) from t1 group by a;
-ERROR 42Y36: Column reference 'B' is invalid. For a SELECT with a GROUP BY, the SELECT list may only contain grouping columns and valid aggregate expressions.
+ERROR 42Y36: Column reference 'B' is invalid. For a SELECT list with a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
ij> -- columns in group by list must be unique
select a, b from t1 group by a, a;
ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
@@ -25,19 +25,19 @@
ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list must be unambiguous.
ij> -- cursor with group by is not updatable
get cursor c1 as 'select a from t1 group by a for update';
-ERROR 42Y90: FOR UPDATE is not permitted on this type of statement.
+ERROR 42Y90: FOR UPDATE is not permitted in this type of statement.
ij> -- noncorrelated subquery that returns too many rows
select a, (select a from t2) from t1 group by a;
ERROR 21000: Scalar subquery is only allowed to return a single row.
ij> -- correlation on outer table
select t2.a, (select b from t1 where t1.b = t2.b) from t1 t2 group by t2.a;
-ERROR 42Y30: The SELECT list of a grouped query contains at least 1 invalid expression. For a SELECT with a GROUP BY, the SELECT list may only contain grouping columns and valid aggregate expressions.
+ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression. If a SELECT list has a GROUP BY, the list may only contain grouping columns and valid aggregate expressions.
ij> -- having clause
-- cannot contain column references which are not grouping columns
select a from t1 group by a having c = 1;
-ERROR 42X04: Column 'C' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'C' is not a column in the target table.
+ERROR 42X04: Column 'C' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'C' is not a column in the target table.
ij> select a from t1 o group by a having a = (select a from t1 where b = b.o);
-ERROR 42X04: Column 'B.O' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'B.O' is not a column in the target table.
+ERROR 42X04: Column 'B.O' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'B.O' is not a column in the target table.
ij> -- ?s in group by
select a from t1 group by ?;
ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
@@ -45,7 +45,7 @@
create table unmapped(c1 long varchar);
0 rows inserted/updated/deleted
ij> select c1, max(1) from unmapped group by c1;
-ERROR X0X67: Columns of type 'LONG VARCHAR' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT, because comparisons are not supported for that type.
+ERROR X0X67: Columns of type 'LONG VARCHAR' may not be used in CREATE INDEX, ORDER BY, GROUP BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported for that type.
ij> -- clean up
drop table t1;
0 rows inserted/updated/deleted
@@ -562,13 +562,13 @@
ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is a 'INTEGER' expression. It must be a BOOLEAN expression.
ij> -- column references in having clause not allowed if no group by
select * from t1 having c1 = 1;
-ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least one aggregate then all entries must be valid aggregate expressions.
ij> select 1 from t1 having c1 = 1;
-ERROR 42X04: Column 'C1' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'C1' is not a column in the target table.
+ERROR 42X04: Column 'C1' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'C1' is not a column in the target table.
ij> -- correlated subquery in having clause
select * from t1 t1_outer
having 1 = (select 1 from t1 where c1 = t1_outer.c1);
-ERROR 42Y35: Column reference 'T1_OUTER.C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'T1_OUTER.C1' is invalid. When the SELECT list contains at least one aggregate then all entries must be valid aggregate expressions.
ij> -- drop the table
drop table t1;
0 rows inserted/updated/deleted
@@ -588,22 +588,22 @@
ij> -- all 6 queries below should fail after bug 5653 is fixed
-- select *
select * from t1 having 1=1;
-ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least one aggregate then all entries must be valid aggregate expressions.
ij> -- select column
select c1 from t1 having 1=1;
-ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least one aggregate then all entries must be valid aggregate expressions.
ij> -- select with a built-in function sqrt
select sqrt(c1) from t1 having 1=1;
-ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least one aggregate then all entries must be valid aggregate expressions.
ij> -- non-correlated subquery in having clause
select * from t1 having 1 = (select 1 from t1 where c1 = 0.0);
-ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least one aggregate then all entries must be valid aggregate expressions.
ij> -- expression in select list
select (c1 * c1) / c1 from t1 where c1 <> 0 having 1=1;
-ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least one aggregate then all entries must be valid aggregate expressions.
ij> -- between
select * from t1 having 1 between 1 and 2;
-ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least 1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least one aggregate then all entries must be valid aggregate expressions.
ij> -- drop the table
drop table t1;
0 rows inserted/updated/deleted