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 [7/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/parameterMapping.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/parameterMapping.out?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/parameterMapping.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/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) IC 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(null) 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(null) IC JDBC MATCH (INVALID)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -288,24 +303,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) IC 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(null) 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(null) IC JDBC MATCH (INVALID)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -484,24 +514,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) IC 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(null) 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(null) IC JDBC MATCH (INVALID)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -680,24 +725,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) IC 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(null) 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(null) IC JDBC MATCH (INVALID)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -877,24 +937,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) IC 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(null) 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(null) IC JDBC MATCH (INVALID)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1073,24 +1148,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) IC 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(null) 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(null) IC JDBC MATCH (INVALID)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1269,24 +1359,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) IC 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(null) 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(null) IC JDBC MATCH (INVALID)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -1471,24 +1576,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() IC JDBC MATCH (INVALID)
@@ -1662,24 +1782,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() IC JDBC MATCH (INVALID)
@@ -1853,24 +1988,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() IC JDBC MATCH (INVALID)
@@ -1990,24 +2140,39 @@
setXXX() with all JDBC Types on VARCHAR(60) FOR BIT DATA
For setXXX() methods that pass an object, a null and valid values are checked
setByte() IC JDBC MATCH (INVALID)
+ setByte() as batch IC JDBC MATCH (INVALID)
setShort() IC JDBC MATCH (INVALID)
+ setShort() as batch IC JDBC MATCH (INVALID)
setInt() IC JDBC MATCH (INVALID)
+ setInt() as batch IC JDBC MATCH (INVALID)
setLong() IC JDBC MATCH (INVALID)
+ setLong() as batch IC JDBC MATCH (INVALID)
setFloat() IC JDBC MATCH (INVALID)
+ setFloat() as batch IC JDBC MATCH (INVALID)
setDouble() IC JDBC MATCH (INVALID)
+ setDouble() as batch IC JDBC MATCH (INVALID)
setBigDecimal() IC JDBC MATCH (INVALID)
+ setBigDecimal() as batch IC JDBC MATCH (INVALID)
setBigDecimal(null) IC JDBC MATCH (INVALID)
+ setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
setBoolean() IC JDBC MATCH (INVALID)
+ setBoolean() as batch IC JDBC MATCH (INVALID)
setString() IC JDBC MATCH (INVALID)
+ setString() as batch IC JDBC MATCH (INVALID)
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(null) getBytes=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(null) 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(null) IC JDBC MATCH (INVALID)
setBinaryStream() getBytes=0x82,0x43 was null false JDBC MATCH(OK)
@@ -2166,24 +2331,39 @@
setXXX() with all JDBC Types on DATE
For setXXX() methods that pass an object, a null and valid values are checked
setByte() IC JDBC MATCH (INVALID)
+ setByte() as batch IC JDBC MATCH (INVALID)
setShort() IC JDBC MATCH (INVALID)
+ setShort() as batch IC JDBC MATCH (INVALID)
setInt() IC JDBC MATCH (INVALID)
+ setInt() as batch IC JDBC MATCH (INVALID)
setLong() IC JDBC MATCH (INVALID)
+ setLong() as batch IC JDBC MATCH (INVALID)
setFloat() IC JDBC MATCH (INVALID)
+ setFloat() as batch IC JDBC MATCH (INVALID)
setDouble() IC JDBC MATCH (INVALID)
+ setDouble() as batch IC JDBC MATCH (INVALID)
setBigDecimal() IC JDBC MATCH (INVALID)
+ setBigDecimal() as batch IC JDBC MATCH (INVALID)
setBigDecimal(null) IC JDBC MATCH (INVALID)
+ setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
setBoolean() IC JDBC MATCH (INVALID)
+ setBoolean() as batch IC JDBC MATCH (INVALID)
setString() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
+ setString() as batch (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL DATE
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(null) IC 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(null) 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(null) IC JDBC MATCH (INVALID)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2344,24 +2524,39 @@
setXXX() with all JDBC Types on TIME
For setXXX() methods that pass an object, a null and valid values are checked
setByte() IC JDBC MATCH (INVALID)
+ setByte() as batch IC JDBC MATCH (INVALID)
setShort() IC JDBC MATCH (INVALID)
+ setShort() as batch IC JDBC MATCH (INVALID)
setInt() IC JDBC MATCH (INVALID)
+ setInt() as batch IC JDBC MATCH (INVALID)
setLong() IC JDBC MATCH (INVALID)
+ setLong() as batch IC JDBC MATCH (INVALID)
setFloat() IC JDBC MATCH (INVALID)
+ setFloat() as batch IC JDBC MATCH (INVALID)
setDouble() IC JDBC MATCH (INVALID)
+ setDouble() as batch IC JDBC MATCH (INVALID)
setBigDecimal() IC JDBC MATCH (INVALID)
+ setBigDecimal() as batch IC JDBC MATCH (INVALID)
setBigDecimal(null) IC JDBC MATCH (INVALID)
+ setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
setBoolean() IC JDBC MATCH (INVALID)
+ setBoolean() as batch IC JDBC MATCH (INVALID)
setString() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
+ setString() as batch (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIME
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(null) IC 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(null) 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(null) IC JDBC MATCH (INVALID)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2523,24 +2718,39 @@
setXXX() with all JDBC Types on TIMESTAMP
For setXXX() methods that pass an object, a null and valid values are checked
setByte() IC JDBC MATCH (INVALID)
+ setByte() as batch IC JDBC MATCH (INVALID)
setShort() IC JDBC MATCH (INVALID)
+ setShort() as batch IC JDBC MATCH (INVALID)
setInt() IC JDBC MATCH (INVALID)
+ setInt() as batch IC JDBC MATCH (INVALID)
setLong() IC JDBC MATCH (INVALID)
+ setLong() as batch IC JDBC MATCH (INVALID)
setFloat() IC JDBC MATCH (INVALID)
+ setFloat() as batch IC JDBC MATCH (INVALID)
setDouble() IC JDBC MATCH (INVALID)
+ setDouble() as batch IC JDBC MATCH (INVALID)
setBigDecimal() IC JDBC MATCH (INVALID)
+ setBigDecimal() as batch IC JDBC MATCH (INVALID)
setBigDecimal(null) IC JDBC MATCH (INVALID)
+ setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
setBoolean() IC JDBC MATCH (INVALID)
+ setBoolean() as batch IC JDBC MATCH (INVALID)
setString() (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
+ setString() as batch (22007):The syntax of the string representation of a datetime value is incorrect. JDBC FAIL TIMESTAMP
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(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)
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(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)
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(null) IC JDBC MATCH (INVALID)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2702,24 +2912,39 @@
setXXX() with all JDBC Types on CLOB(1k)
For setXXX() methods that pass an object, a null and valid values are checked
setByte() IC JDBC MATCH (INVALID)
+ setByte() as batch IC JDBC MATCH (INVALID)
setShort() IC JDBC MATCH (INVALID)
+ setShort() as batch IC JDBC MATCH (INVALID)
setInt() IC JDBC MATCH (INVALID)
+ setInt() as batch IC JDBC MATCH (INVALID)
setLong() IC JDBC MATCH (INVALID)
+ setLong() as batch IC JDBC MATCH (INVALID)
setFloat() IC JDBC MATCH (INVALID)
+ setFloat() as batch IC JDBC MATCH (INVALID)
setDouble() IC JDBC MATCH (INVALID)
+ setDouble() as batch IC JDBC MATCH (INVALID)
setBigDecimal() IC JDBC MATCH (INVALID)
+ setBigDecimal() as batch IC JDBC MATCH (INVALID)
setBigDecimal(null) IC JDBC MATCH (INVALID)
+ setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
setBoolean() IC JDBC MATCH (INVALID)
+ setBoolean() as batch IC JDBC MATCH (INVALID)
setString() getClob=0x39,0x37 was null false CLOUD EXT (OK)
+ setString() as batch getClob=0x39,0x37 was null false CLOUD EXT (OK)
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(null) IC 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(null) 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(null) getClob=null was null true JDBC MATCH(OK)
setBinaryStream() IC JDBC MATCH (INVALID)
@@ -2837,24 +3062,39 @@
setXXX() with all JDBC Types on BLOB(1k)
For setXXX() methods that pass an object, a null and valid values are checked
setByte() IC JDBC MATCH (INVALID)
+ setByte() as batch IC JDBC MATCH (INVALID)
setShort() IC JDBC MATCH (INVALID)
+ setShort() as batch IC JDBC MATCH (INVALID)
setInt() IC JDBC MATCH (INVALID)
+ setInt() as batch IC JDBC MATCH (INVALID)
setLong() IC JDBC MATCH (INVALID)
+ setLong() as batch IC JDBC MATCH (INVALID)
setFloat() IC JDBC MATCH (INVALID)
+ setFloat() as batch IC JDBC MATCH (INVALID)
setDouble() IC JDBC MATCH (INVALID)
+ setDouble() as batch IC JDBC MATCH (INVALID)
setBigDecimal() IC JDBC MATCH (INVALID)
+ setBigDecimal() as batch IC JDBC MATCH (INVALID)
setBigDecimal(null) IC JDBC MATCH (INVALID)
+ setBigDecimal(null) as batch IC JDBC MATCH (INVALID)
setBoolean() IC JDBC MATCH (INVALID)
+ setBoolean() as batch IC JDBC MATCH (INVALID)
setString() IC JDBC MATCH (INVALID)
+ setString() as batch IC JDBC MATCH (INVALID)
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(null) getBlob=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(null) 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(null) IC JDBC MATCH (INVALID)
setBinaryStream() getBlob=0x82,0x43 was null false JDBC MATCH(OK)
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/procedure.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/procedure.out?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/procedure.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/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.
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/synonym.out Mon Jun 13 14:41:33 2005
@@ -219,6 +219,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/tests/jdbcapi/parameterMapping.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/parameterMapping.java?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/parameterMapping.java (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/parameterMapping.java Mon Jun 13 14:41:33 2005
@@ -1077,6 +1077,28 @@
}
private static void setXXX(Statement s, PreparedStatement psi, PreparedStatement psq, int type) throws SQLException, java.io.IOException {
+ boolean executeBatchTests = true;
+
+ // DERBY-349 - Disable executeBatch on these target types as invald conversions
+ // using setByte() and executeBatch lead to the test hanging.
+ if (TestUtil.isDerbyNetClientFramework())
+ {
+ switch (jdbcTypes[type])
+ {
+ case Types.BINARY:
+ case Types.VARBINARY:
+ case Types.LONGVARBINARY:
+ case Types.DATE:
+ case Types.TIMESTAMP:
+ case Types.TIME:
+ case Types.CLOB:
+ case Types.BLOB:
+ executeBatchTests = false;
+ break;
+ }
+ }
+
+
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1097,7 +1119,28 @@
}
judge_setXXX(worked, sqleResult, 0, type);
}
-
+ // and as a batch
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setByte() as batch ");
+ psi.setByte(1, (byte) 98);
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 0, type);
+ }
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1118,7 +1161,28 @@
}
judge_setXXX(worked, sqleResult, 1, type);
}
+ // and as a batch
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setShort() as batch ");
+ psi.setShort(1, (short) 98);
+ psi.addBatch();
+ psi.executeBatch();
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 1, type);
+ }
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1139,7 +1203,28 @@
}
judge_setXXX(worked, sqleResult, 2, type);
}
-
+ // and as a batch
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setInt() as batch ");
+ psi.setInt(1, 98);
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 2, type);
+ }
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1160,7 +1245,29 @@
}
judge_setXXX(worked, sqleResult, 3, type);
}
-
+ // as a batch
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setLong() as batch ");
+ psi.setLong(1, 98L);
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 3, type);
+ }
+
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1181,6 +1288,29 @@
}
judge_setXXX(worked, sqleResult, 4, type);
}
+
+ // and as a batch
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setFloat() as batch ");
+ psi.setFloat(1, 98.4f);
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 4, type);
+ }
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1202,6 +1332,30 @@
}
judge_setXXX(worked, sqleResult, 5, type);
}
+
+ // as a batch
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setDouble() as batch ");
+ psi.setDouble(1, 98.5);
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 5, type);
+ }
+
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1223,6 +1377,28 @@
}
judge_setXXX(worked, sqleResult, 6, type);
}
+ // as a batch
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setBigDecimal() as batch ");
+ psi.setBigDecimal(1, new BigDecimal(99.0));
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 6, type);
+ }
// null BigDecimal
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1245,6 +1421,29 @@
judge_setXXX(worked, sqleResult, 6, type);
}
+ // null BigDecimal
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setBigDecimal(null) as batch ");
+ psi.setBigDecimal(1, null);
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 6, type);
+ }
+
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1265,7 +1464,27 @@
}
judge_setXXX(worked, sqleResult, 7, type);
}
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setBoolean() as batch ");
+ psi.setBoolean(1, true);
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 7, type);
+ }
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1292,7 +1511,35 @@
}
judge_setXXX(worked, sqleResult, 8, type);
}
-
+ // as batch
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setString() as batch ");
+ psi.setString(1, "97");
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ } catch (Throwable t) {
+ // JCC has some bugs
+ System.out.println(t.getMessage());
+ worked = false;
+ sqleResult = null;
+
+ }
+ judge_setXXX(worked, sqleResult, 8, type);
+ }
+
// null String
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1320,7 +1567,34 @@
}
judge_setXXX(worked, sqleResult, 8, type);
}
+ // null String as batch
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setString(null) as batch ");
+ psi.setString(1, null);
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ } catch (Throwable t) {
+ // JCC has some bugs
+ System.out.println(t.getMessage());
+ worked = false;
+ sqleResult = null;
+
+ }
+ judge_setXXX(worked, sqleResult, 8, type);
+ }
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1384,6 +1658,27 @@
}
judge_setXXX(worked, sqleResult, 10, type);
}
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setDate() as batch ");
+ psi.setDate(1, java.sql.Date.valueOf("2004-02-14"));
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 10, type);
+ }
// null Date
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1405,7 +1700,30 @@
}
judge_setXXX(worked, sqleResult, 10, type);
}
+
+ // null Date
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setDate(null) as batch ");
+ psi.setDate(1, null);
+ psi.addBatch();
+ psi.executeBatch();
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 10, type);
+ }
+
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1467,6 +1785,29 @@
}
judge_setXXX(worked, sqleResult, 12, type);
}
+ // as batch
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setTimestamp() as batch ");
+ psi.setTimestamp(1, java.sql.Timestamp.valueOf("2004-02-23 17:14:24.097625551"));
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 12, type);
+ }
+
{
s.execute("DELETE FROM PM.TYPE_AS");
@@ -1487,7 +1828,29 @@
}
judge_setXXX(worked, sqleResult, 12, type);
}
-
+ // as batch
+ if (executeBatchTests) {
+ s.execute("DELETE FROM PM.TYPE_AS");
+
+ SQLException sqleResult = null;
+ boolean worked;
+ try {
+ System.out.print(" setTimestamp(null) as batch ");
+ psi.setTimestamp(1, null);
+ psi.addBatch();
+ psi.executeBatch();
+
+ getValidValue(psq, jdbcTypes[type]);
+
+ worked = true;
+
+ } catch (SQLException sqle) {
+ sqleResult = sqle;
+ worked = false;
+ }
+ judge_setXXX(worked, sqleResult, 12, type);
+ }
+
{
s.execute("DELETE FROM PM.TYPE_AS");
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/copyfiles.ant
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/copyfiles.ant?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/copyfiles.ant (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/copyfiles.ant Mon Jun 13 14:41:33 2005
@@ -76,6 +76,8 @@
emptyStatistics.sql
errorCode.sql
errorCode_app.properties
+errorStream.sql
+errorStream_app.properties
fk_nonSPS.sql
fk_nonSPS_derby.properties
floattypes.sql
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/functions.sql Mon Jun 13 14:41:33 2005
@@ -199,3 +199,30 @@
EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.ProcedureTest.countRows'
LANGUAGE JAVA PARAMETER STYLE JAVA;
+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)';
+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';
+CREATE FUNCTION SIGNATURE_BUG_DERBY_258_E() RETURNS VARCHAR(20)
+LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
+EXTERNAL NAME 'java.lang.Integer.toXXString()';
+
+-- these are ok
+VALUES SIGNATURE_BUG_DERBY_258_NS(2356, 16);
+VALUES SIGNATURE_BUG_DERBY_258_NS(2356, 10);
+VALUES SIGNATURE_BUG_DERBY_258_NS(2356, 2);
+
+-- Must resolve as above
+VALUES SIGNATURE_BUG_DERBY_258_D(2356, 16);
+-- no method to resolve to (with specified signature)
+VALUES SIGNATURE_BUG_DERBY_258_E();
+
+DROP FUNCTION SIGNATURE_BUG_DERBY_258_D;
+DROP FUNCTION SIGNATURE_BUG_DERBY_258_E;
+DROP FUNCTION SIGNATURE_BUG_DERBY_258_NS;
+
+
+
+
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/miscerrors.sql Mon Jun 13 14:41:33 2005
@@ -29,5 +29,3 @@
-- set isolation to repeatable read
set isolation serializable;
--- Print the output of the ErrorLogVTI, make sure it's valid
-SELECT * FROM new org.apache.derby.diag.ErrorLogReader() vti;
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure.java
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure.java?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure.java (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure.java Mon Jun 13 14:41:33 2005
@@ -149,8 +149,51 @@
// bug 5760 - this caused a null pointer exception at one time.
statementExceptionExpected(s, "call syscs_util.syscs_set_database_property(\"foo\", \"bar\")");
+
+ // Derby-258 specific signatures with types not matching JDBC spec.
+ System.out.println("signature mismatched types");
+ s.execute("CREATE PROCEDURE SIGNATURE_BUG_DERBY_258_A(IN A INT) LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME 'java.lang.System.load(java.lang.String)'");
+ statementExceptionExpected(s, "CALL APP.SIGNATURE_BUG_DERBY_258_A(4)");
+ s.execute("DROP PROCEDURE SIGNATURE_BUG_DERBY_258_A");
+ // signature with wrong number of arguments, too many
+ System.out.println("signature too many parameters");
+ s.execute("CREATE FUNCTION SIGNATURE_BUG_DERBY_258_B(A INT) RETURNS VARCHAR(128) LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME 'java.lang.Integer.toString(int, int)'");
+ statementExceptionExpected(s, "VALUES APP.SIGNATURE_BUG_DERBY_258_B(4)");
+ s.execute("DROP FUNCTION SIGNATURE_BUG_DERBY_258_B");
+
+ // and too few
+ System.out.println("signature too few parameters");
+ s.execute("CREATE PROCEDURE SIGNATURE_BUG_DERBY_258_C(IN A INT) LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME 'java.lang.System.gc()'");
+ statementExceptionExpected(s, "CALL APP.SIGNATURE_BUG_DERBY_258_C(4)");
+ s.execute("DROP PROCEDURE SIGNATURE_BUG_DERBY_258_C");
+
+ // only a leading paren
+ System.out.println("signature invalid format");
+ s.execute("CREATE PROCEDURE SIGNATURE_BUG_DERBY_258_F(IN A INT) LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME 'java.lang.System.gc('");
+ statementExceptionExpected(s, "CALL APP.SIGNATURE_BUG_DERBY_258_F(4)");
+ s.execute("DROP PROCEDURE SIGNATURE_BUG_DERBY_258_F");
+
+ // signature of (,,)
+ System.out.println("signature invalid format");
+ s.execute("CREATE PROCEDURE SIGNATURE_BUG_DERBY_258_G(IN A INT) LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME 'java.lang.System.gc(,,)'");
+ statementExceptionExpected(s, "CALL APP.SIGNATURE_BUG_DERBY_258_G(4)");
+ s.execute("DROP PROCEDURE SIGNATURE_BUG_DERBY_258_G");
+
+ // signature of (, ,)
+ System.out.println("signature invalid format");
+ s.execute("CREATE PROCEDURE SIGNATURE_BUG_DERBY_258_H(IN A INT) LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME 'java.lang.System.gc(, ,)'");
+ statementExceptionExpected(s, "CALL APP.SIGNATURE_BUG_DERBY_258_H(4)");
+ s.execute("DROP PROCEDURE SIGNATURE_BUG_DERBY_258_H");
+
+ // signature of (int,)
+ System.out.println("signature invalid format");
+ s.execute("CREATE PROCEDURE SIGNATURE_BUG_DERBY_258_I(IN A INT) LANGUAGE JAVA PARAMETER STYLE JAVA EXTERNAL NAME 'java.lang.System.gc(int ,)'");
+ statementExceptionExpected(s, "CALL APP.SIGNATURE_BUG_DERBY_258_I(4)");
+ s.execute("DROP PROCEDURE SIGNATURE_BUG_DERBY_258_I");
+
s.close();
+
}
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/synonym.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/synonym.sql?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/synonym.sql (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/lang/synonym.sql Mon Jun 13 14:41:33 2005
@@ -139,6 +139,35 @@
drop table primaryTab;
drop synonym synPrimary;
+-- Tests with non existant schemas
+-- Implicitly creates junkSchema
+create synonym junkSchema.syn1 for table2;
+select * from junkSchema.syn1;
+set schema junkSchema;
+create table table2(c char(10));
+select * from syn1;
+set schema APP;
+
+-- Should resolve to junkSchema.table2
+select * from junkSchema.syn1;
+drop table junkSchema.table2;
+
+-- Should fail. Need to drop synonym first
+drop schema junkSchema restrict;
+drop synonym junkSchema.syn1;
+drop schema junkSchema restrict;
+
+-- Test with target schema missing
+create synonym mySynonym for notPresent.t1;
+select * from mySynonym;
+create table notPresent.t1(j int, c char(10));
+insert into notPresent.t1 values (100, 'satheesh');
+-- Should resolve now
+select * from mySynonym;
+
+drop table notPresent.t1;
+drop synonym mySynonym;
+
-- Positive test case with three levels of synonym chaining
create schema synonymSchema;
Modified: incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_makeDB_2.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_makeDB_2.sql?rev=190514&r1=190513&r2=190514&view=diff
==============================================================================
--- incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_makeDB_2.sql (original)
+++ incubator/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_makeDB_2.sql Mon Jun 13 14:41:33 2005
@@ -61,6 +61,12 @@
create view v1 (dum, dee, dokie) as select a.c, a.i, a.vc from bar.t1 as a;
-- ----------------------------------------------
+-- Synonyms
+-- ----------------------------------------------
+
+create synonym syn1 for bar.t1;
+
+-- ----------------------------------------------
-- Triggers
-- ----------------------------------------------