Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 11974 invoked from network); 7 Apr 2005 20:39:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 Apr 2005 20:39:28 -0000 Received: (qmail 76765 invoked by uid 500); 7 Apr 2005 20:39:27 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 76733 invoked by uid 500); 7 Apr 2005 20:39:27 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 76719 invoked by uid 500); 7 Apr 2005 20:39:27 -0000 Delivered-To: apmail-incubator-derby-cvs@incubator.apache.org Received: (qmail 76716 invoked by uid 99); 7 Apr 2005 20:39:27 -0000 X-ASF-Spam-Status: No, hits=-9.8 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from minotaur.apache.org (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.28) with SMTP; Thu, 07 Apr 2005 13:39:24 -0700 Received: (qmail 11891 invoked by uid 65534); 7 Apr 2005 20:39:23 -0000 Message-ID: <20050407203923.11889.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable X-Mailer: svnmailer-1.0.0-dev Date: Thu, 07 Apr 2005 20:39:23 -0000 Subject: svn commit: r160466 [1/2] - in incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/ master/DerbyNet/ master/DerbyNetClient/ master/jdk14/ tests/jdbcapi/ tests/lang/ To: derby-cvs@incubator.apache.org From: fuzzylogic@apache.org X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Author: fuzzylogic Date: Thu Apr 7 13:39:20 2005 New Revision: 160466 URL: http://svn.apache.org/viewcvs?view=3Drev&rev=3D160466 Log: Modify 3 tests and their expected output files - jdbcapi/LOBTest, jdbcapi/o= dbc_metadata, and=20 lang/updatableResultSet.java - to overcome some false failures when running= with newer versions of=20 the IBM Universal Driver. Committed for Myrna Van Lunteran Added: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/tests/jdbcapi/odbc_metadata_sed.properties (with props) Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/LOBTest.out incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/odbc_metadata.out incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/updatableResultSet.out incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/LOBTest.out incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/updatableResultSet.out incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/LOBTest.out incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/jdk14/updatableResultSet.out incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/updatableResultSet.out incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/tests/jdbcapi/LOBTest.java incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/tests/jdbcapi/copyfiles.ant incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/tests/lang/updatableResultSet.java Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/DerbyNet/LOBTest.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out?view=3Ddi= ff&r1=3D160465&r2=3D160466 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/LOBTest.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/LOBTest.out Thu Apr 7 13:39:20 2005 @@ -1,7 +1,7 @@ create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varc= har(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varcha= r for bit data, col_6 blob(80), typecol char (8 ) for bit data ) insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X= '003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS = char (8 ) for bit data) ) insert into bit_table ( col_0 ) values ( 'true' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold val= ues of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into bit_table ( col_1 ) values ( 'true' ) insert into bit_table ( col_2 ) values ( 'true' ) insert into bit_table ( col_3 ) values ( 'true' ) @@ -380,13 +380,13 @@ OUT =3D Object : byte[] -----< columns CAST TO type: METADATA TESTS select cast( col_0 as char (8) for bit data ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'CHAR (= ) FOR BIT DATA'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'. select cast( col_1 as char (8) for bit data ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR' to 'CHAR () F= OR BIT DATA'. + ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select cast( col_2 as char (8) for bit data ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'VARCHAR' to 'CHAR (= ) FOR BIT DATA'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'. select cast( col_3 as char (8) for bit data ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to 'C= HAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA= '=2E select cast( col_4 as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -434,7 +434,7 @@ OUT =3D NULL OUT =3D NULL select cast( col_6 as char (8) for bit data ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR () F= OR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -460,13 +460,13 @@ OUT =3D Object : byte[] -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'INTEGER'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'. select cast( typecol as char(10) ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'CHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. select cast( typecol as varchar(80) ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. select cast( typecol as long varchar ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'LONG VARCHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR= '=2E select cast( typecol as char(10) for bit data ) from bit_table ---- 1 Column : 1 @@ -563,7 +563,7 @@ create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varc= har(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varcha= r for bit data, col_6 blob(80), typecol char (8 ) for bit data ) insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X= '003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS = char (8 ) for bit data) ) insert into bit_table ( col_0 ) values ( 'true' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold val= ues of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into bit_table ( col_1 ) values ( 'true' ) insert into bit_table ( col_2 ) values ( 'true' ) insert into bit_table ( col_3 ) values ( 'true' ) @@ -942,13 +942,13 @@ OUT =3D Object : byte[] -----< columns CAST TO type: METADATA TESTS select cast( col_0 as char (8) for bit data ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'CHAR (= ) FOR BIT DATA'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'. select cast( col_1 as char (8) for bit data ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR' to 'CHAR () F= OR BIT DATA'. + ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select cast( col_2 as char (8) for bit data ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'VARCHAR' to 'CHAR (= ) FOR BIT DATA'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'. select cast( col_3 as char (8) for bit data ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to 'C= HAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA= '=2E select cast( col_4 as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -996,7 +996,7 @@ OUT =3D NULL OUT =3D NULL select cast( col_6 as char (8) for bit data ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR () F= OR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -1022,13 +1022,13 @@ OUT =3D Object : byte[] -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'INTEGER'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'. select cast( typecol as char(10) ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'CHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. select cast( typecol as varchar(80) ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. select cast( typecol as long varchar ) from bit_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'LONG VARCHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR= '=2E select cast( typecol as char(10) for bit data ) from bit_table ---- 1 Column : 1 @@ -1125,7 +1125,7 @@ create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol blob (2 M) ) insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= blob (2 M)) ) insert into blob_table ( col_0 ) values ( 'true' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold val= ues of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into blob_table ( col_1 ) values ( 'true' ) insert into blob_table ( col_2 ) values ( 'true' ) insert into blob_table ( col_3 ) values ( 'true' ) @@ -1504,13 +1504,13 @@ OUT =3D Object : java.sql.Blob -----< columns CAST TO type: METADATA TESTS select cast( col_0 as blob(2 M) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'BLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'. select cast( col_1 as blob(2 M) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'. select cast( col_2 as blob(2 M) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'VARCHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'. select cast( col_3 as blob(2 M) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to 'B= LOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'. select cast( col_4 as blob(2 M) ) from blob_table ---- 1 Column : 1 @@ -1605,17 +1605,17 @@ OUT =3D Object : java.sql.Blob -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'INTEGER'. + ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'. select cast( typecol as char(10) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'. select cast( typecol as varchar(80) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'. select cast( typecol as long varchar ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARC= HAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'. select cast( typecol as char(10) for bit data ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR () F= OR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARC= HAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from blob_table ---- 1 Column : 1 @@ -1666,7 +1666,7 @@ create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol blob (2 K) ) insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= blob (2 K)) ) insert into blob_table ( col_0 ) values ( 'true' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold val= ues of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into blob_table ( col_1 ) values ( 'true' ) insert into blob_table ( col_2 ) values ( 'true' ) insert into blob_table ( col_3 ) values ( 'true' ) @@ -2045,13 +2045,13 @@ OUT =3D Object : java.sql.Blob -----< columns CAST TO type: METADATA TESTS select cast( col_0 as blob(2 K) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'BLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'. select cast( col_1 as blob(2 K) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'. select cast( col_2 as blob(2 K) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'VARCHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'. select cast( col_3 as blob(2 K) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to 'B= LOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'. select cast( col_4 as blob(2 K) ) from blob_table ---- 1 Column : 1 @@ -2146,17 +2146,17 @@ OUT =3D Object : java.sql.Blob -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'INTEGER'. + ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'. select cast( typecol as char(10) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'. select cast( typecol as varchar(80) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'. select cast( typecol as long varchar ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARC= HAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'. select cast( typecol as char(10) for bit data ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR () F= OR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARC= HAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from blob_table ---- 1 Column : 1 @@ -2207,7 +2207,7 @@ create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol blob (64 ) ) insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= blob (64 )) ) insert into blob_table ( col_0 ) values ( 'true' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold val= ues of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into blob_table ( col_1 ) values ( 'true' ) insert into blob_table ( col_2 ) values ( 'true' ) insert into blob_table ( col_3 ) values ( 'true' ) @@ -2586,13 +2586,13 @@ OUT =3D Object : java.sql.Blob -----< columns CAST TO type: METADATA TESTS select cast( col_0 as blob(64 ) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'BLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'. select cast( col_1 as blob(64 ) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'. select cast( col_2 as blob(64 ) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'VARCHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'. select cast( col_3 as blob(64 ) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to 'B= LOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'. select cast( col_4 as blob(64 ) ) from blob_table ---- 1 Column : 1 @@ -2687,17 +2687,17 @@ OUT =3D Object : java.sql.Blob -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'INTEGER'. + ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'. select cast( typecol as char(10) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'. select cast( typecol as varchar(80) ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'. select cast( typecol as long varchar ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARC= HAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'. select cast( typecol as char(10) for bit data ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CHAR () F= OR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from blob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'LONG VARC= HAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from blob_table ---- 1 Column : 1 @@ -2747,9 +2747,9 @@ drop table blob_table create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol clob (2 K) ) insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= clob (2 K)) ) - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. insert into clob_table ( col_0 ) values ( 'true' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold val= ues of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into clob_table ( col_1 ) values ( 'true' ) insert into clob_table ( col_2 ) values ( 'true' ) insert into clob_table ( col_3 ) values ( 'true' ) @@ -2757,7 +2757,7 @@ insert into clob_table ( col_5 ) values cast ( X'0074007200750065' AS lon= g varchar for bit data) insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blo= b(80)) insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS c= lob (2 K)) - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. =3D=3D=3D Columntype int select col_0 from clob_table 0 getObject -> EXCEPTION (null) @@ -3113,7 +3113,7 @@ OUT =3D NULL -----< columns CAST TO type: METADATA TESTS select cast( col_0 as clob(2 K) ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'CLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'. select cast( col_1 as clob(2 K) ) from clob_table ---- 1 Column : 1 @@ -3178,11 +3178,11 @@ OUT =3D NULL OUT =3D NULL select cast( col_4 as clob(2 K) ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. select cast( col_5 as clob(2 K) ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR FOR BI= T DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'. select cast( col_6 as clob(2 K) ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CLOB'. + ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'. select cast( typecol as clob(2 K) ) from clob_table ---- 1 Column : 1 @@ -3206,7 +3206,7 @@ OUT =3D NULL -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'INTEGER'. + ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'. select cast( typecol as char(10) ) from clob_table ---- 1 Column : 1 @@ -3271,11 +3271,11 @@ OUT =3D NULL OUT =3D NULL select cast( typecol as char(10) for bit data ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'CHAR () F= OR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'LONG VARC= HAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'BLOB'. + ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'. select cast( typecol as clob (2 K) ) from clob_table ---- 1 Column : 1 @@ -3300,9 +3300,9 @@ drop table clob_table create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol clob (64 ) ) insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= clob (64 )) ) - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. insert into clob_table ( col_0 ) values ( 'true' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'INTEGER' cannot hold val= ues of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into clob_table ( col_1 ) values ( 'true' ) insert into clob_table ( col_2 ) values ( 'true' ) insert into clob_table ( col_3 ) values ( 'true' ) @@ -3310,7 +3310,7 @@ insert into clob_table ( col_5 ) values cast ( X'0074007200750065' AS lon= g varchar for bit data) insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blo= b(80)) insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS c= lob (64 )) - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. =3D=3D=3D Columntype int select col_0 from clob_table 0 getObject -> EXCEPTION (null) @@ -3666,7 +3666,7 @@ OUT =3D NULL -----< columns CAST TO type: METADATA TESTS select cast( col_0 as clob(64 ) ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'INTEGER' to 'CLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'. select cast( col_1 as clob(64 ) ) from clob_table ---- 1 Column : 1 @@ -3731,11 +3731,11 @@ OUT =3D NULL OUT =3D NULL select cast( col_4 as clob(64 ) ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DAT= A' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. select cast( col_5 as clob(64 ) ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR FOR BI= T DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'. select cast( col_6 as clob(64 ) ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'BLOB' to 'CLOB'. + ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'. select cast( typecol as clob(64 ) ) from clob_table ---- 1 Column : 1 @@ -3759,7 +3759,7 @@ OUT =3D NULL -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'INTEGER'. + ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'. select cast( typecol as char(10) ) from clob_table ---- 1 Column : 1 @@ -3824,11 +3824,11 @@ OUT =3D NULL OUT =3D NULL select cast( typecol as char(10) for bit data ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'CHAR () F= OR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'LONG VARC= HAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from clob_table - com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CLOB' to 'BLOB'. + ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'. select cast( typecol as clob (64 ) ) from clob_table ---- 1 Column : 1 @@ -3854,20 +3854,20 @@ -----< BLOB Insertion Tests create table blobCheck (bl blob(80))=20 insert into blobCheck (bl ) values ('string' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values= of type 'CHAR'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.=20 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as b= lob(80)) ) insert into blobCheck (bl ) values (X'48' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values= of type 'CHAR () FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) ) insert into blobCheck (bl ) values ( X'a78a' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values= of type 'CHAR () FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) ) insert into blobCheck (bl ) values ('string' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values= of type 'CHAR'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.=20 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as b= lob(80)) ) insert into blobCheck (bl ) values (X'48' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values= of type 'CHAR () FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) ) insert into blobCheck (bl ) values ( X'a78a' ) - com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values= of type 'CHAR () FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) ) Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/DerbyNet/odbc_metadata.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/DerbyNet/odbc_metadata.out?vie= w=3Ddiff&r1=3D160465&r2=3D160466 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/odbc_metadata.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/odbc_metadata.out Thu Apr 7 13:39:20 2005 @@ -39,7 +39,7 @@ Column result scale after division is: 23 dc / 2 =3D 5.55000000000000000000000 dc / 2 =3D 5.55500000000000000000000 -JDBC Driver 'IBM DB2 JDBC Universal Driver Architecture', version 2.4 (2.4= .17) +JDBC Driver 'IBM DB2 JDBC Universal Driver Architecture', version (EXPECTE= D VERSION) The URL is: jdbc:derby:net://localhost:1527/wombat;create=3Dtrue allTablesAreSelectable(): true maxColumnNameLength(): 30 @@ -79,7 +79,7 @@ nullsAreSortedAtEnd(): false getDatabaseProductName(): Apache Derby getDatabaseProductVersion(): 10.1.0.0 alpha -getDriverVersion(): 2.4.17 +getDriverVersion(): EXPECTED VERSION usesLocalFiles(): true usesLocalFilePerTable(): true supportsMixedCaseIdentifiers(): false Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/DerbyNet/updatableResultSet.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/DerbyNet/updatableResultSet.ou= t?view=3Ddiff&r1=3D160465&r2=3D160466 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/updatableResultSet.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNet/updatableResultSet.out Thu Apr 7 13:39:20 2005 @@ -1,6 +1,6 @@ Start testing delete and update using JDBC2.0 updateable resultset apis Negative Testl - request for scroll insensitive updatable resultset will g= ive a read only scroll insensitive resultset -warnings on connection =3D com.ibm.db2.jcc.c.SqlWarning: Insensitive updat= able result sets are not supported by server; remapping to insensitive read= -only cursor +WARNING (no SQLState): Insensitive updatable result sets are not supported= by server; remapping to insensitive read-only cursor requested TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE but that is not suppor= ted Make sure that we got TYPE_SCROLL_INSENSITIVE? true Make sure that we got CONCUR_READ_ONLY? true Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/DerbyNetClient/LOBTest.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out?vie= w=3Ddiff&r1=3D160465&r2=3D160466 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/LOBTest.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/LOBTest.out Thu Apr 7 13:39:20 2005 @@ -1,7 +1,7 @@ create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varc= har(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varcha= r for bit data, col_6 blob(80), typecol char (8 ) for bit data ) insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X= '003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS = char (8 ) for bit data) ) insert into bit_table ( col_0 ) values ( 'true' ) - org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot= hold values of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.= =20 insert into bit_table ( col_1 ) values ( 'true' ) insert into bit_table ( col_2 ) values ( 'true' ) insert into bit_table ( col_3 ) values ( 'true' ) @@ -380,13 +380,13 @@ OUT =3D Object : byte[] -----< columns CAST TO type: METADATA TESTS select cast( col_0 as char (8) for bit data ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' t= o 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'. select cast( col_1 as char (8) for bit data ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR' to '= CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select cast( col_2 as char (8) for bit data ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'VARCHAR' t= o 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'. select cast( col_3 as char (8) for bit data ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCH= AR' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA= '=2E select cast( col_4 as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -434,7 +434,7 @@ OUT =3D NULL OUT =3D NULL select cast( col_6 as char (8) for bit data ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -460,13 +460,13 @@ OUT =3D Object : byte[] -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'INTEGER'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'. select cast( typecol as char(10) ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'CHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. select cast( typecol as varchar(80) ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. select cast( typecol as long varchar ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'LONG VARCHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR= '=2E select cast( typecol as char(10) for bit data ) from bit_table ---- 1 Column : 1 @@ -563,7 +563,7 @@ create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varc= har(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varcha= r for bit data, col_6 blob(80), typecol char (8 ) for bit data ) insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X= '003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS = char (8 ) for bit data) ) insert into bit_table ( col_0 ) values ( 'true' ) - org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot= hold values of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.= =20 insert into bit_table ( col_1 ) values ( 'true' ) insert into bit_table ( col_2 ) values ( 'true' ) insert into bit_table ( col_3 ) values ( 'true' ) @@ -942,13 +942,13 @@ OUT =3D Object : byte[] -----< columns CAST TO type: METADATA TESTS select cast( col_0 as char (8) for bit data ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' t= o 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'. select cast( col_1 as char (8) for bit data ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR' to '= CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select cast( col_2 as char (8) for bit data ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'VARCHAR' t= o 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'. select cast( col_3 as char (8) for bit data ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCH= AR' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA= '=2E select cast( col_4 as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -996,7 +996,7 @@ OUT =3D NULL OUT =3D NULL select cast( col_6 as char (8) for bit data ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -1022,13 +1022,13 @@ OUT =3D Object : byte[] -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'INTEGER'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'. select cast( typecol as char(10) ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'CHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. select cast( typecol as varchar(80) ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. select cast( typecol as long varchar ) from bit_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'LONG VARCHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR= '=2E select cast( typecol as char(10) for bit data ) from bit_table ---- 1 Column : 1 @@ -1125,7 +1125,7 @@ create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol blob (2 M) ) insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= blob (2 M)) ) insert into blob_table ( col_0 ) values ( 'true' ) - org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot= hold values of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.= =20 insert into blob_table ( col_1 ) values ( 'true' ) insert into blob_table ( col_2 ) values ( 'true' ) insert into blob_table ( col_3 ) values ( 'true' ) @@ -1504,13 +1504,13 @@ OUT =3D Object : java.sql.Blob -----< columns CAST TO type: METADATA TESTS select cast( col_0 as blob(2 M) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' t= o 'BLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'. select cast( col_1 as blob(2 M) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR' to '= BLOB'. + ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'. select cast( col_2 as blob(2 M) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'VARCHAR' t= o 'BLOB'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'. select cast( col_3 as blob(2 M) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCH= AR' to 'BLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'. select cast( col_4 as blob(2 M) ) from blob_table ---- 1 Column : 1 @@ -1605,17 +1605,17 @@ OUT =3D Object : java.sql.Blob -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= INTEGER'. + ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'. select cast( typecol as char(10) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= CHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'. select cast( typecol as varchar(80) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'. select cast( typecol as long varchar ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= LONG VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'. select cast( typecol as char(10) for bit data ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= LONG VARCHAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from blob_table ---- 1 Column : 1 @@ -1666,7 +1666,7 @@ create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol blob (2 K) ) insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= blob (2 K)) ) insert into blob_table ( col_0 ) values ( 'true' ) - org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot= hold values of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.= =20 insert into blob_table ( col_1 ) values ( 'true' ) insert into blob_table ( col_2 ) values ( 'true' ) insert into blob_table ( col_3 ) values ( 'true' ) @@ -2045,13 +2045,13 @@ OUT =3D Object : java.sql.Blob -----< columns CAST TO type: METADATA TESTS select cast( col_0 as blob(2 K) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' t= o 'BLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'. select cast( col_1 as blob(2 K) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR' to '= BLOB'. + ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'. select cast( col_2 as blob(2 K) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'VARCHAR' t= o 'BLOB'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'. select cast( col_3 as blob(2 K) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCH= AR' to 'BLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'. select cast( col_4 as blob(2 K) ) from blob_table ---- 1 Column : 1 @@ -2146,17 +2146,17 @@ OUT =3D Object : java.sql.Blob -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= INTEGER'. + ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'. select cast( typecol as char(10) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= CHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'. select cast( typecol as varchar(80) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'. select cast( typecol as long varchar ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= LONG VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'. select cast( typecol as char(10) for bit data ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= LONG VARCHAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from blob_table ---- 1 Column : 1 @@ -2207,7 +2207,7 @@ create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol blob (64 ) ) insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= blob (64 )) ) insert into blob_table ( col_0 ) values ( 'true' ) - org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot= hold values of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.= =20 insert into blob_table ( col_1 ) values ( 'true' ) insert into blob_table ( col_2 ) values ( 'true' ) insert into blob_table ( col_3 ) values ( 'true' ) @@ -2586,13 +2586,13 @@ OUT =3D Object : java.sql.Blob -----< columns CAST TO type: METADATA TESTS select cast( col_0 as blob(64 ) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' t= o 'BLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'. select cast( col_1 as blob(64 ) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR' to '= BLOB'. + ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'. select cast( col_2 as blob(64 ) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'VARCHAR' t= o 'BLOB'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'. select cast( col_3 as blob(64 ) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCH= AR' to 'BLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'. select cast( col_4 as blob(64 ) ) from blob_table ---- 1 Column : 1 @@ -2687,17 +2687,17 @@ OUT =3D Object : java.sql.Blob -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= INTEGER'. + ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'. select cast( typecol as char(10) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= CHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'. select cast( typecol as varchar(80) ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'. select cast( typecol as long varchar ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= LONG VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'. select cast( typecol as char(10) for bit data ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from blob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= LONG VARCHAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from blob_table ---- 1 Column : 1 @@ -2747,9 +2747,9 @@ drop table blob_table create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol clob (2 K) ) insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= clob (2 K)) ) - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. insert into clob_table ( col_0 ) values ( 'true' ) - org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot= hold values of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.= =20 insert into clob_table ( col_1 ) values ( 'true' ) insert into clob_table ( col_2 ) values ( 'true' ) insert into clob_table ( col_3 ) values ( 'true' ) @@ -2757,7 +2757,7 @@ insert into clob_table ( col_5 ) values cast ( X'0074007200750065' AS lon= g varchar for bit data) insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blo= b(80)) insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS c= lob (2 K)) - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. =3D=3D=3D Columntype int select col_0 from clob_table 0 getObject -> EXCEPTION (null) @@ -3113,7 +3113,7 @@ OUT =3D NULL -----< columns CAST TO type: METADATA TESTS select cast( col_0 as clob(2 K) ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' t= o 'CLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'. select cast( col_1 as clob(2 K) ) from clob_table ---- 1 Column : 1 @@ -3178,11 +3178,11 @@ OUT =3D NULL OUT =3D NULL select cast( col_4 as clob(2 K) ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. select cast( col_5 as clob(2 K) ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCH= AR FOR BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'. select cast( col_6 as clob(2 K) ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= CLOB'. + ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'. select cast( typecol as clob(2 K) ) from clob_table ---- 1 Column : 1 @@ -3206,7 +3206,7 @@ OUT =3D NULL -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to '= INTEGER'. + ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'. select cast( typecol as char(10) ) from clob_table ---- 1 Column : 1 @@ -3271,11 +3271,11 @@ OUT =3D NULL OUT =3D NULL select cast( typecol as char(10) for bit data ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to '= CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to '= LONG VARCHAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to '= BLOB'. + ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'. select cast( typecol as clob (2 K) ) from clob_table ---- 1 Column : 1 @@ -3300,9 +3300,9 @@ drop table clob_table create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol clob (64 ) ) insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= clob (64 )) ) - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. insert into clob_table ( col_0 ) values ( 'true' ) - org.apache.derby.client.am.SqlException: Columns of type 'INTEGER' cannot= hold values of type 'CHAR'.=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.= =20 insert into clob_table ( col_1 ) values ( 'true' ) insert into clob_table ( col_2 ) values ( 'true' ) insert into clob_table ( col_3 ) values ( 'true' ) @@ -3310,7 +3310,7 @@ insert into clob_table ( col_5 ) values cast ( X'0074007200750065' AS lon= g varchar for bit data) insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blo= b(80)) insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS c= lob (64 )) - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. =3D=3D=3D Columntype int select col_0 from clob_table 0 getObject -> EXCEPTION (null) @@ -3666,7 +3666,7 @@ OUT =3D NULL -----< columns CAST TO type: METADATA TESTS select cast( col_0 as clob(64 ) ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'INTEGER' t= o 'CLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'. select cast( col_1 as clob(64 ) ) from clob_table ---- 1 Column : 1 @@ -3731,11 +3731,11 @@ OUT =3D NULL OUT =3D NULL select cast( col_4 as clob(64 ) ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FO= R BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. select cast( col_5 as clob(64 ) ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCH= AR FOR BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'. select cast( col_6 as clob(64 ) ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'BLOB' to '= CLOB'. + ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'. select cast( typecol as clob(64 ) ) from clob_table ---- 1 Column : 1 @@ -3759,7 +3759,7 @@ OUT =3D NULL -----< type CAST TO types: METADATA TESTS select cast( typecol as int ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to '= INTEGER'. + ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'. select cast( typecol as char(10) ) from clob_table ---- 1 Column : 1 @@ -3824,11 +3824,11 @@ OUT =3D NULL OUT =3D NULL select cast( typecol as char(10) for bit data ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to '= CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to '= LONG VARCHAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from clob_table - org.apache.derby.client.am.SqlException: Cannot convert types 'CLOB' to '= BLOB'. + ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'. select cast( typecol as clob (64 ) ) from clob_table ---- 1 Column : 1 @@ -3854,20 +3854,20 @@ -----< BLOB Insertion Tests create table blobCheck (bl blob(80))=20 insert into blobCheck (bl ) values ('string' ) - org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot ho= ld values of type 'CHAR'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.=20 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as b= lob(80)) ) insert into blobCheck (bl ) values (X'48' ) - org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot ho= ld values of type 'CHAR () FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) ) insert into blobCheck (bl ) values ( X'a78a' ) - org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot ho= ld values of type 'CHAR () FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) ) insert into blobCheck (bl ) values ('string' ) - org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot ho= ld values of type 'CHAR'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.=20 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as b= lob(80)) ) insert into blobCheck (bl ) values (X'48' ) - org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot ho= ld values of type 'CHAR () FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) ) insert into blobCheck (bl ) values ( X'a78a' ) - org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot ho= ld values of type 'CHAR () FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) ) Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/DerbyNetClient/updatableResultSet.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResult= Set.out?view=3Ddiff&r1=3D160465&r2=3D160466 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/updatableResultSet.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/DerbyNetClient/updatableResultSet.out Thu Apr 7 13:39:20 2005 @@ -1,6 +1,6 @@ Start testing delete and update using JDBC2.0 updateable resultset apis Negative Testl - request for scroll insensitive updatable resultset will g= ive a read only scroll insensitive resultset -warnings on connection =3D org.apache.derby.client.am.SqlWarning: Insensit= ive updatable result sets are not supported by server; remapping to insensi= tive read-only cursor +WARNING (no SQLState): Insensitive updatable result sets are not supported= by server; remapping to insensitive read-only cursor requested TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE but that is not suppor= ted Make sure that we got TYPE_SCROLL_INSENSITIVE? true Make sure that we got CONCUR_READ_ONLY? true Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/LOBTest.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/LOBTest.out?view=3Ddiff&r1=3D1= 60465&r2=3D160466 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/LOBTest.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/LOBTest.out Thu Apr 7 13:39:20 2005 @@ -1,7 +1,7 @@ create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varc= har(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varcha= r for bit data, col_6 blob(80), typecol char (8 ) for bit data ) insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X= '003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS = char (8 ) for bit data) ) insert into bit_table ( col_0 ) values ( 'true' ) - SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR= '=2E=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into bit_table ( col_1 ) values ( 'true' ) insert into bit_table ( col_2 ) values ( 'true' ) insert into bit_table ( col_3 ) values ( 'true' ) @@ -380,13 +380,13 @@ OUT =3D Object : byte[] ---< columns CAST TO type: METADATA TESTS select cast( col_0 as char (8) for bit data ) from bit_table - SQL Exception: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'. select cast( col_1 as char (8) for bit data ) from bit_table - SQL Exception: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select cast( col_2 as char (8) for bit data ) from bit_table - SQL Exception: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'. select cast( col_3 as char (8) for bit data ) from bit_table - SQL Exception: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DA= TA'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA= '=2E select cast( col_4 as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -434,7 +434,7 @@ OUT =3D NULL OUT =3D NULL select cast( col_6 as char (8) for bit data ) from bit_table - SQL Exception: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -460,13 +460,13 @@ OUT =3D Object : byte[] ---< type CAST TO types: METADATA TESTS select cast( typecol as int ) from bit_table - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'. select cast( typecol as char(10) ) from bit_table - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. select cast( typecol as varchar(80) ) from bit_table - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. select cast( typecol as long varchar ) from bit_table - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCH= AR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR= '=2E select cast( typecol as char(10) for bit data ) from bit_table ---- 1 Column : 1 @@ -563,7 +563,7 @@ create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varc= har(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varcha= r for bit data, col_6 blob(80), typecol char (8 ) for bit data ) insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X= '003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS = char (8 ) for bit data) ) insert into bit_table ( col_0 ) values ( 'true' ) - SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR= '=2E=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into bit_table ( col_1 ) values ( 'true' ) insert into bit_table ( col_2 ) values ( 'true' ) insert into bit_table ( col_3 ) values ( 'true' ) @@ -942,13 +942,13 @@ OUT =3D Object : byte[] ---< columns CAST TO type: METADATA TESTS select cast( col_0 as char (8) for bit data ) from bit_table - SQL Exception: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'. select cast( col_1 as char (8) for bit data ) from bit_table - SQL Exception: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'. select cast( col_2 as char (8) for bit data ) from bit_table - SQL Exception: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'. select cast( col_3 as char (8) for bit data ) from bit_table - SQL Exception: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DA= TA'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA= '=2E select cast( col_4 as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -996,7 +996,7 @@ OUT =3D NULL OUT =3D NULL select cast( col_6 as char (8) for bit data ) from bit_table - SQL Exception: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as char (8) for bit data ) from bit_table ---- 1 Column : 1 @@ -1022,13 +1022,13 @@ OUT =3D Object : byte[] ---< type CAST TO types: METADATA TESTS select cast( typecol as int ) from bit_table - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'. select cast( typecol as char(10) ) from bit_table - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'. select cast( typecol as varchar(80) ) from bit_table - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'. select cast( typecol as long varchar ) from bit_table - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCH= AR'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR= '=2E select cast( typecol as char(10) for bit data ) from bit_table ---- 1 Column : 1 @@ -1125,7 +1125,7 @@ create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol blob (2 M) ) insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= blob (2 M)) ) insert into blob_table ( col_0 ) values ( 'true' ) - SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR= '=2E=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into blob_table ( col_1 ) values ( 'true' ) insert into blob_table ( col_2 ) values ( 'true' ) insert into blob_table ( col_3 ) values ( 'true' ) @@ -1504,13 +1504,13 @@ OUT =3D Object : java.sql.Blob ---< columns CAST TO type: METADATA TESTS select cast( col_0 as blob(2 M) ) from blob_table - SQL Exception: Cannot convert types 'INTEGER' to 'BLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'. select cast( col_1 as blob(2 M) ) from blob_table - SQL Exception: Cannot convert types 'CHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'. select cast( col_2 as blob(2 M) ) from blob_table - SQL Exception: Cannot convert types 'VARCHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'. select cast( col_3 as blob(2 M) ) from blob_table - SQL Exception: Cannot convert types 'LONG VARCHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'. select cast( col_4 as blob(2 M) ) from blob_table ---- 1 Column : 1 @@ -1605,17 +1605,17 @@ OUT =3D Object : java.sql.Blob ---< type CAST TO types: METADATA TESTS select cast( typecol as int ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'INTEGER'. + ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'. select cast( typecol as char(10) ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'CHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'. select cast( typecol as varchar(80) ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'. select cast( typecol as long varchar ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'. select cast( typecol as char(10) for bit data ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from blob_table ---- 1 Column : 1 @@ -1666,7 +1666,7 @@ create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol blob (2 K) ) insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= blob (2 K)) ) insert into blob_table ( col_0 ) values ( 'true' ) - SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR= '=2E=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into blob_table ( col_1 ) values ( 'true' ) insert into blob_table ( col_2 ) values ( 'true' ) insert into blob_table ( col_3 ) values ( 'true' ) @@ -2045,13 +2045,13 @@ OUT =3D Object : java.sql.Blob ---< columns CAST TO type: METADATA TESTS select cast( col_0 as blob(2 K) ) from blob_table - SQL Exception: Cannot convert types 'INTEGER' to 'BLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'. select cast( col_1 as blob(2 K) ) from blob_table - SQL Exception: Cannot convert types 'CHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'. select cast( col_2 as blob(2 K) ) from blob_table - SQL Exception: Cannot convert types 'VARCHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'. select cast( col_3 as blob(2 K) ) from blob_table - SQL Exception: Cannot convert types 'LONG VARCHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'. select cast( col_4 as blob(2 K) ) from blob_table ---- 1 Column : 1 @@ -2146,17 +2146,17 @@ OUT =3D Object : java.sql.Blob ---< type CAST TO types: METADATA TESTS select cast( typecol as int ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'INTEGER'. + ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'. select cast( typecol as char(10) ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'CHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'. select cast( typecol as varchar(80) ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'. select cast( typecol as long varchar ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'. select cast( typecol as char(10) for bit data ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from blob_table ---- 1 Column : 1 @@ -2207,7 +2207,7 @@ create table blob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol blob (64 ) ) insert into blob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= blob (64 )) ) insert into blob_table ( col_0 ) values ( 'true' ) - SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR= '=2E=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into blob_table ( col_1 ) values ( 'true' ) insert into blob_table ( col_2 ) values ( 'true' ) insert into blob_table ( col_3 ) values ( 'true' ) @@ -2586,13 +2586,13 @@ OUT =3D Object : java.sql.Blob ---< columns CAST TO type: METADATA TESTS select cast( col_0 as blob(64 ) ) from blob_table - SQL Exception: Cannot convert types 'INTEGER' to 'BLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'. select cast( col_1 as blob(64 ) ) from blob_table - SQL Exception: Cannot convert types 'CHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'. select cast( col_2 as blob(64 ) ) from blob_table - SQL Exception: Cannot convert types 'VARCHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'. select cast( col_3 as blob(64 ) ) from blob_table - SQL Exception: Cannot convert types 'LONG VARCHAR' to 'BLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'BLOB'. select cast( col_4 as blob(64 ) ) from blob_table ---- 1 Column : 1 @@ -2687,17 +2687,17 @@ OUT =3D Object : java.sql.Blob ---< type CAST TO types: METADATA TESTS select cast( typecol as int ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'INTEGER'. + ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'. select cast( typecol as char(10) ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'CHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'. select cast( typecol as varchar(80) ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'. select cast( typecol as long varchar ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'. select cast( typecol as char(10) for bit data ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from blob_table - SQL Exception: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from blob_table ---- 1 Column : 1 @@ -2747,9 +2747,9 @@ drop table blob_table create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol clob (2 K) ) insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= clob (2 K)) ) - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. insert into clob_table ( col_0 ) values ( 'true' ) - SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR= '=2E=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into clob_table ( col_1 ) values ( 'true' ) insert into clob_table ( col_2 ) values ( 'true' ) insert into clob_table ( col_3 ) values ( 'true' ) @@ -2757,7 +2757,7 @@ insert into clob_table ( col_5 ) values cast ( X'0074007200750065' AS lon= g varchar for bit data) insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blo= b(80)) insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS c= lob (2 K)) - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. =3D=3D=3D Columntype int select col_0 from clob_table 0 getObject -> EXCEPTION (null) @@ -3113,7 +3113,7 @@ OUT =3D NULL ---< columns CAST TO type: METADATA TESTS select cast( col_0 as clob(2 K) ) from clob_table - SQL Exception: Cannot convert types 'INTEGER' to 'CLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'. select cast( col_1 as clob(2 K) ) from clob_table ---- 1 Column : 1 @@ -3178,11 +3178,11 @@ OUT =3D NULL OUT =3D NULL select cast( col_4 as clob(2 K) ) from clob_table - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. select cast( col_5 as clob(2 K) ) from clob_table - SQL Exception: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'. select cast( col_6 as clob(2 K) ) from clob_table - SQL Exception: Cannot convert types 'BLOB' to 'CLOB'. + ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'. select cast( typecol as clob(2 K) ) from clob_table ---- 1 Column : 1 @@ -3206,7 +3206,7 @@ OUT =3D NULL ---< type CAST TO types: METADATA TESTS select cast( typecol as int ) from clob_table - SQL Exception: Cannot convert types 'CLOB' to 'INTEGER'. + ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'. select cast( typecol as char(10) ) from clob_table ---- 1 Column : 1 @@ -3271,11 +3271,11 @@ OUT =3D NULL OUT =3D NULL select cast( typecol as char(10) for bit data ) from clob_table - SQL Exception: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from clob_table - SQL Exception: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from clob_table - SQL Exception: Cannot convert types 'CLOB' to 'BLOB'. + ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'. select cast( typecol as clob (2 K) ) from clob_table ---- 1 Column : 1 @@ -3300,9 +3300,9 @@ drop table clob_table create table clob_table ( dummy int , col_0 int, col_1 char(10), col_2 var= char(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varch= ar for bit data, col_6 blob(80), typecol clob (64 ) ) insert into clob_table values ( 45 ,100,'101','102','103',X'003100300034',= X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS= clob (64 )) ) - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. insert into clob_table ( col_0 ) values ( 'true' ) - SQL Exception: Columns of type 'INTEGER' cannot hold values of type 'CHAR= '=2E=20 + ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.=20 insert into clob_table ( col_1 ) values ( 'true' ) insert into clob_table ( col_2 ) values ( 'true' ) insert into clob_table ( col_3 ) values ( 'true' ) @@ -3310,7 +3310,7 @@ insert into clob_table ( col_5 ) values cast ( X'0074007200750065' AS lon= g varchar for bit data) insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blo= b(80)) insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS c= lob (64 )) - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. =3D=3D=3D Columntype int select col_0 from clob_table 0 getObject -> EXCEPTION (null) @@ -3666,7 +3666,7 @@ OUT =3D NULL ---< columns CAST TO type: METADATA TESTS select cast( col_0 as clob(64 ) ) from clob_table - SQL Exception: Cannot convert types 'INTEGER' to 'CLOB'. + ERROR 42846: Cannot convert types 'INTEGER' to 'CLOB'. select cast( col_1 as clob(64 ) ) from clob_table ---- 1 Column : 1 @@ -3731,11 +3731,11 @@ OUT =3D NULL OUT =3D NULL select cast( col_4 as clob(64 ) ) from clob_table - SQL Exception: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'. select cast( col_5 as clob(64 ) ) from clob_table - SQL Exception: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'. + ERROR 42846: Cannot convert types 'LONG VARCHAR FOR BIT DATA' to 'CLOB'. select cast( col_6 as clob(64 ) ) from clob_table - SQL Exception: Cannot convert types 'BLOB' to 'CLOB'. + ERROR 42846: Cannot convert types 'BLOB' to 'CLOB'. select cast( typecol as clob(64 ) ) from clob_table ---- 1 Column : 1 @@ -3759,7 +3759,7 @@ OUT =3D NULL ---< type CAST TO types: METADATA TESTS select cast( typecol as int ) from clob_table - SQL Exception: Cannot convert types 'CLOB' to 'INTEGER'. + ERROR 42846: Cannot convert types 'CLOB' to 'INTEGER'. select cast( typecol as char(10) ) from clob_table ---- 1 Column : 1 @@ -3824,11 +3824,11 @@ OUT =3D NULL OUT =3D NULL select cast( typecol as char(10) for bit data ) from clob_table - SQL Exception: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'CHAR () FOR BIT DATA'. select cast( typecol as long varchar for bit data ) from clob_table - SQL Exception: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'. + ERROR 42846: Cannot convert types 'CLOB' to 'LONG VARCHAR FOR BIT DATA'. select cast( typecol as blob(80) ) from clob_table - SQL Exception: Cannot convert types 'CLOB' to 'BLOB'. + ERROR 42846: Cannot convert types 'CLOB' to 'BLOB'. select cast( typecol as clob (64 ) ) from clob_table ---- 1 Column : 1 @@ -3854,20 +3854,20 @@ ---< BLOB Insertion Tests create table blobCheck (bl blob(80))=20 insert into blobCheck (bl ) values ('string' ) - SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.=20 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as b= lob(80)) ) insert into blobCheck (bl ) values (X'48' ) - SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR ()= FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) ) insert into blobCheck (bl ) values ( X'a78a' ) - SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR ()= FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) ) insert into blobCheck (bl ) values ('string' ) - SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.=20 insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as b= lob(80)) ) insert into blobCheck (bl ) values (X'48' ) - SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR ()= FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'C8' as blob(80)) ) insert into blobCheck (bl ) values ( X'a78a' ) - SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR ()= FOR BIT DATA'.=20 + ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () F= OR BIT DATA'.=20 insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) ) Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/jdk14/updatableResultSet.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out?v= iew=3Ddiff&r1=3D160465&r2=3D160466 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/jdk14/updatableResultSet.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/jdk14/updatableResultSet.out Thu Apr 7 13:39:20 2005 @@ -1,6 +1,6 @@ Start testing delete and update using JDBC2.0 updateable resultset apis Negative Testl - request for scroll insensitive updatable resultset will g= ive a read only scroll insensitive resultset -warnings on connection =3D SQL Warning: Scroll sensitive and scroll insens= itive updatable ResultSets are not currently implemented. +WARNING 01J03: Scroll sensitive and scroll insensitive updatable ResultSet= s are not currently implemented. requested TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE but that is not suppor= ted Make sure that we got TYPE_SCROLL_INSENSITIVE? true Make sure that we got CONCUR_READ_ONLY? true Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/updatableResultSet.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/updatableResultSet.out?view=3D= diff&r1=3D160465&r2=3D160466 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/updatableResultSet.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/updatableResultSet.out Thu Apr 7 13:39:20 2005 @@ -1,6 +1,6 @@ Start testing delete and update using JDBC2.0 updateable resultset apis Negative Testl - request for scroll insensitive updatable resultset will g= ive a read only scroll insensitive resultset -warnings on connection =3D SQL Warning: Scroll sensitive and scroll insens= itive updatable ResultSets are not currently implemented. +WARNING 01J03: Scroll sensitive and scroll insensitive updatable ResultSet= s are not currently implemented. requested TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE but that is not suppor= ted Make sure that we got TYPE_SCROLL_INSENSITIVE? true Make sure that we got CONCUR_READ_ONLY? true Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/tests/jdbcapi/LOBTest.java URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java?view=3Ddif= f&r1=3D160465&r2=3D160466 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/tests/jdbcapi/LOBTest.java (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/tests/jdbcapi/LOBTest.java Thu Apr 7 13:39:20 2005 @@ -40,6 +40,7 @@ import java.sql.PreparedStatement; import org.apache.derby.tools.ij; import org.apache.derbyTesting.functionTests.util.TestUtil; +import org.apache.derby.tools.JDBCDisplayUtil; =20 /** * @author Jonas S Karlsson @@ -66,8 +67,8 @@ } public static void printSQLError(SQLException e) { while (e !=3D null) { - System.out.print("\t"); - System.out.println(e.toString()); + System.out.print("\t"); + JDBCDisplayUtil.ShowSQLException(System.out, e); e =3D e.getNextException(); } } @@ -468,11 +469,14 @@ { for(int i=3D0; i