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/04/07 22:39:23 UTC
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/
Author: fuzzylogic
Date: Thu Apr 7 13:39:20 2005
New Revision: 160466
URL: http://svn.apache.org/viewcvs?view=rev&rev=160466
Log:
Modify 3 tests and their expected output files - jdbcapi/LOBTest, jdbcapi/odbc_metadata, and
lang/updatableResultSet.java - to overcome some false failures when running with newer versions of
the IBM Universal Driver.
Committed for Myrna Van Lunteran <my...@golux.com>
Added:
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/odbc_metadata_sed.properties (with props)
Modified:
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/odbc_metadata.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/updatableResultSet.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBTest.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/updatableResultSet.java
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/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=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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 values of type 'CHAR'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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 () 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
- 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 'CHAR () FOR BIT DATA'.
+ ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_4 as char (8) for bit data ) from bit_table
---- 1
Column : 1
@@ -434,7 +434,7 @@
OUT = NULL
OUT = 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 () 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 = 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 DATA' 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 DATA' 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 DATA' 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 DATA' to 'LONG VARCHAR'.
+ ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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 values of type 'CHAR'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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 () 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
- 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 'CHAR () FOR BIT DATA'.
+ ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_4 as char (8) for bit data ) from bit_table
---- 1
Column : 1
@@ -996,7 +996,7 @@
OUT = NULL
OUT = 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 () 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 = 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 DATA' 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 DATA' 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 DATA' 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 DATA' to 'LONG VARCHAR'.
+ ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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 values of type 'CHAR'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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 '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 = 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 VARCHAR'.
+ 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 () 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
- com.ibm.db2.jcc.c.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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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 values of type 'CHAR'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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 '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 = 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 VARCHAR'.
+ 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 () 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
- com.ibm.db2.jcc.c.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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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 values of type 'CHAR'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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 '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 = 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 VARCHAR'.
+ 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 () 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
- com.ibm.db2.jcc.c.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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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 DATA' 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 values of type 'CHAR'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 long varchar for bit data)
insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS clob (2 K))
- com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+ ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
=== Columntype int
select col_0 from clob_table
0 getObject -> EXCEPTION (null)
@@ -3113,7 +3113,7 @@
OUT = 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 = NULL
OUT = NULL
select cast( col_4 as clob(2 K) ) from clob_table
- com.ibm.db2.jcc.c.SqlException: 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
- com.ibm.db2.jcc.c.SqlException: 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
- 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 = 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 = NULL
OUT = 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 () 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
- com.ibm.db2.jcc.c.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
- 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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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 DATA' 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 values of type 'CHAR'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 long varchar for bit data)
insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS clob (64 ))
- com.ibm.db2.jcc.c.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+ ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
=== Columntype int
select col_0 from clob_table
0 getObject -> EXCEPTION (null)
@@ -3666,7 +3666,7 @@
OUT = 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 = NULL
OUT = NULL
select cast( col_4 as clob(64 ) ) from clob_table
- com.ibm.db2.jcc.c.SqlException: 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
- com.ibm.db2.jcc.c.SqlException: 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
- 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 = 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 = NULL
OUT = 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 () 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
- com.ibm.db2.jcc.c.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
- 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))
insert into blobCheck (bl ) values ('string' )
- com.ibm.db2.jcc.c.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.
insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(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'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
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'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
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'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.
insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(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'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
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'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) )
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/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?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/odbc_metadata.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/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 = 5.55000000000000000000000
dc / 2 = 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 (EXPECTED VERSION)
The URL is: jdbc:derby:net://localhost:1527/wombat;create=true
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/functionTests/master/DerbyNet/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/updatableResultSet.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/updatableResultSet.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/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 give a read only scroll insensitive resultset
-warnings on connection = com.ibm.db2.jcc.c.SqlWarning: Insensitive updatable 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 supported
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/functionTests/master/DerbyNetClient/LOBTest.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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' 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
- 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' 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
- org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
+ ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_4 as char (8) for bit data ) from bit_table
---- 1
Column : 1
@@ -434,7 +434,7 @@
OUT = NULL
OUT = 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 = 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 () 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
- org.apache.derby.client.am.SqlException: 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
- org.apache.derby.client.am.SqlException: 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
- org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
+ ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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' 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
- 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' 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
- org.apache.derby.client.am.SqlException: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
+ ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_4 as char (8) for bit data ) from bit_table
---- 1
Column : 1
@@ -996,7 +996,7 @@
OUT = NULL
OUT = 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 = 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 () 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
- org.apache.derby.client.am.SqlException: 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
- org.apache.derby.client.am.SqlException: 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
- org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
+ ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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' to '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' to '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 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 = 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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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' to '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' to '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 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 = 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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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' to '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' to '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 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 = 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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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 () FOR 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 long varchar for bit data)
insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS clob (2 K))
- org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+ ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
=== Columntype int
select col_0 from clob_table
0 getObject -> EXCEPTION (null)
@@ -3113,7 +3113,7 @@
OUT = 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' 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 = NULL
OUT = NULL
select cast( col_4 as clob(2 K) ) from clob_table
- org.apache.derby.client.am.SqlException: 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
- org.apache.derby.client.am.SqlException: 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
- 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 = 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 = NULL
OUT = 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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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 () FOR 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 long varchar for bit data)
insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS clob (64 ))
- org.apache.derby.client.am.SqlException: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
+ ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
=== Columntype int
select col_0 from clob_table
0 getObject -> EXCEPTION (null)
@@ -3666,7 +3666,7 @@
OUT = 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' 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 = NULL
OUT = NULL
select cast( col_4 as clob(64 ) ) from clob_table
- org.apache.derby.client.am.SqlException: 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
- org.apache.derby.client.am.SqlException: 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
- 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 = 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 = NULL
OUT = 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))
insert into blobCheck (bl ) values ('string' )
- org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.
insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(80)) )
insert into blobCheck (bl ) values (X'48' )
- org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
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 hold values of type 'CHAR () FOR BIT DATA'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
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 hold values of type 'CHAR'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.
insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(80)) )
insert into blobCheck (bl ) values (X'48' )
- org.apache.derby.client.am.SqlException: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
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 hold values of type 'CHAR () FOR BIT DATA'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) )
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/updatableResultSet.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/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 give a read only scroll insensitive resultset
-warnings on connection = org.apache.derby.client.am.SqlWarning: Insensitive updatable 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 supported
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/functionTests/master/LOBTest.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBTest.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBTest.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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 DATA'.
+ ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_4 as char (8) for bit data ) from bit_table
---- 1
Column : 1
@@ -434,7 +434,7 @@
OUT = NULL
OUT = 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 = 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 VARCHAR'.
+ ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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 DATA'.
+ ERROR 42846: Cannot convert types 'LONG VARCHAR' to 'CHAR () FOR BIT DATA'.
select cast( col_4 as char (8) for bit data ) from bit_table
---- 1
Column : 1
@@ -996,7 +996,7 @@
OUT = NULL
OUT = 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 = 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 VARCHAR'.
+ ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'LONG VARCHAR'.
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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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 = 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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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 = 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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 = 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 = 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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 long varchar for bit data)
insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
insert into clob_table ( typecol ) values cast ( X'0074007200750065' 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'.
=== Columntype int
select col_0 from clob_table
0 getObject -> EXCEPTION (null)
@@ -3113,7 +3113,7 @@
OUT = 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 = NULL
OUT = 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 = 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 = NULL
OUT = 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 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar 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'.
+ ERROR 42821: Columns of type 'INTEGER' cannot hold values of type 'CHAR'.
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 long varchar for bit data)
insert into clob_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
insert into clob_table ( typecol ) values cast ( X'0074007200750065' 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'.
=== Columntype int
select col_0 from clob_table
0 getObject -> EXCEPTION (null)
@@ -3666,7 +3666,7 @@
OUT = 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 = NULL
OUT = 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 = 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 = NULL
OUT = 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))
insert into blobCheck (bl ) values ('string' )
- SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.
insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(80)) )
insert into blobCheck (bl ) values (X'48' )
- SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
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'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
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'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR'.
insert into blobCheck (bl ) values (cast (X'0073007400720069006e0067' as blob(80)) )
insert into blobCheck (bl ) values (X'48' )
- SQL Exception: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
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'.
+ ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) )
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/jdk14/updatableResultSet.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/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 give a read only scroll insensitive resultset
-warnings on connection = SQL Warning: Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented.
+WARNING 01J03: Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented.
requested TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE but that is not supported
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/functionTests/master/updatableResultSet.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/updatableResultSet.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/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 give a read only scroll insensitive resultset
-warnings on connection = SQL Warning: Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented.
+WARNING 01J03: Scroll sensitive and scroll insensitive updatable ResultSets are not currently implemented.
requested TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE but that is not supported
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/functionTests/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=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/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;
/**
* @author Jonas S Karlsson
@@ -66,8 +67,8 @@
}
public static void printSQLError(SQLException e) {
while (e != null) {
- System.out.print("\t");
- System.out.println(e.toString());
+ System.out.print("\t");
+ JDBCDisplayUtil.ShowSQLException(System.out, e);
e = e.getNextException();
}
}
@@ -468,11 +469,14 @@
{
for(int i=0; i<columns; i++) {
String insert = "insert into "+table+" ( "+colNames[i];
+
if (isBitColumn(i))
// have to cast for blob columns.
+ {
insert += " ) values cast ( " +
TestUtil.stringToHexLiteral("true") +
" AS " + colTypes[i] + ")";
+ }
else
insert += " ) values ( 'true' )";
Xprint(insert);
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant?view=diff&r1=160465&r2=160466
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/copyfiles.ant Thu Apr 7 13:39:20 2005
@@ -18,6 +18,7 @@
metadataJdbc20_app.properties
metadataJdbc20_derby.properties
metadataJdbc20_sed.properties
+odbc_metadata_sed.properties
resultsetJdbc30_app.properties
resultsetJdbc30_sed.properties
resultsetStream.gif