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/02/02 06:47:09 UTC
svn commit: r149487 [2/3] - in
incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests:
master/DerbyNet/LOBTest.out master/DerbyNet/ieptests.out
master/DerbyNet/importExport.out suites/derbynetmats.properties
suites/derbynetmats.runall suites/j9derbynetmats.properties
suites/j9derbynetmats.runall
Added: 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=auto&rev=149487
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out (added)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out Tue Feb 1 21:47:06 2005
@@ -0,0 +1,3873 @@
+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'.
+insert into bit_table ( col_1 ) values ( 'true' )
+insert into bit_table ( col_2 ) values ( 'true' )
+insert into bit_table ( col_3 ) values ( 'true' )
+insert into bit_table ( col_4 ) values cast ( X'0074007200750065' AS char(10) for bit data)
+insert into bit_table ( col_5 ) values cast ( X'0074007200750065' AS long varchar for bit data)
+insert into bit_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
+insert into bit_table ( typecol ) values cast ( X'0074007200750065' AS char (8 ) for bit data)
+=== Columntype int
+select col_0 from bit_table
+ 0 getObject ->'100' : java.lang.Integer
+ 0 getArray -> EXCEPTION (not yet implemented)
+ 0 getAsciiStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBigDecimal ->'100' : java.math.BigDecimal
+ 0 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBoolean ->'true' : java.lang.Boolean
+ 0 getByte ->'100' : java.lang.Byte
+ 0 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getCharacterStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getDouble ->'100.0' : java.lang.Double
+ 0 getFloat ->'100.0' : java.lang.Float
+ 0 getInt ->'100' : java.lang.Integer
+ 0 getLong ->'100' : java.lang.Long
+ 0 getRef -> EXCEPTION (not yet implemented)
+ 0 getShort ->'100' : java.lang.Short
+ 0 getString ->'100' : java.lang.String
+ 0 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype char(10)
+select col_1 from bit_table
+ 1 getObject ->'101 ' : java.lang.String
+ 1 getArray -> EXCEPTION (not yet implemented)
+ 1 getAsciiStream ->Object' : java.io.InputStream
+ 1 getBigDecimal ->'101' : java.math.BigDecimal
+ 1 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getBoolean ->'true' : java.lang.Boolean
+ 1 getByte ->'101' : java.lang.Byte
+ 1 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getCharacterStream ->Object' : java.io.Reader
+ 1 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getDate -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Date.)
+ 1 getDouble ->'101.0' : java.lang.Double
+ 1 getFloat ->'101.0' : java.lang.Float
+ 1 getInt ->'101' : java.lang.Integer
+ 1 getLong ->'101' : java.lang.Long
+ 1 getRef -> EXCEPTION (not yet implemented)
+ 1 getShort ->'101' : java.lang.Short
+ 1 getString ->'101 ' : java.lang.String
+ 1 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Time.)
+ 1 getTimeStamp -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Timestamp.)
+=== Columntype varchar(80)
+select col_2 from bit_table
+ 2 getObject ->'102' : java.lang.String
+ 2 getArray -> EXCEPTION (not yet implemented)
+ 2 getAsciiStream ->Object' : java.io.InputStream
+ 2 getBigDecimal ->'102' : java.math.BigDecimal
+ 2 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getBoolean ->'true' : java.lang.Boolean
+ 2 getByte ->'102' : java.lang.Byte
+ 2 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getCharacterStream ->Object' : java.io.Reader
+ 2 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getDate -> EXCEPTION (String index out of range: 3)
+ 2 getDouble ->'102.0' : java.lang.Double
+ 2 getFloat ->'102.0' : java.lang.Float
+ 2 getInt ->'102' : java.lang.Integer
+ 2 getLong ->'102' : java.lang.Long
+ 2 getRef -> EXCEPTION (not yet implemented)
+ 2 getShort ->'102' : java.lang.Short
+ 2 getString ->'102' : java.lang.String
+ 2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
+ 2 getTimeStamp -> EXCEPTION (String index out of range: 3)
+=== Columntype long varchar
+select col_3 from bit_table
+ 3 getObject ->'103' : java.lang.String
+ 3 getArray -> EXCEPTION (not yet implemented)
+ 3 getAsciiStream ->Object' : java.io.InputStream
+ 3 getBigDecimal ->'103' : java.math.BigDecimal
+ 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getBoolean ->'true' : java.lang.Boolean
+ 3 getByte ->'103' : java.lang.Byte
+ 3 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getCharacterStream ->Object' : java.io.Reader
+ 3 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getDate -> EXCEPTION (String index out of range: 3)
+ 3 getDouble ->'103.0' : java.lang.Double
+ 3 getFloat ->'103.0' : java.lang.Float
+ 3 getInt ->'103' : java.lang.Integer
+ 3 getLong ->'103' : java.lang.Long
+ 3 getRef -> EXCEPTION (not yet implemented)
+ 3 getShort ->'103' : java.lang.Short
+ 3 getString ->'103' : java.lang.String
+ 3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
+ 3 getTimeStamp -> EXCEPTION (String index out of range: 3)
+=== Columntype char(10) for bit data
+select col_4 from bit_table
+ 4 getObject ->Object' : byte[]
+ 4 getArray -> EXCEPTION (not yet implemented)
+ 4 getAsciiStream ->Object' : java.io.InputStream
+ 4 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBinaryStream ->Object' : java.io.InputStream
+ 4 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBytes ->Object' : byte[]
+ 4 getCharacterStream ->Object' : java.io.Reader
+ 4 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getRef -> EXCEPTION (not yet implemented)
+ 4 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getString ->'00310030003420202020' : java.lang.String
+ 4 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype long varchar for bit data
+select col_5 from bit_table
+ 5 getObject ->Object' : byte[]
+ 5 getArray -> EXCEPTION (not yet implemented)
+ 5 getAsciiStream ->Object' : java.io.InputStream
+ 5 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBinaryStream ->Object' : java.io.InputStream
+ 5 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBytes ->Object' : byte[]
+ 5 getCharacterStream ->Object' : java.io.Reader
+ 5 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getRef -> EXCEPTION (not yet implemented)
+ 5 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getString ->'003100300035' : java.lang.String
+ 5 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype blob(80)
+select col_6 from bit_table
+ 6 getObject ->Object' : java.sql.Blob
+ 6 getArray -> EXCEPTION (not yet implemented)
+ 6 getAsciiStream ->Object' : java.io.InputStream
+ 6 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getBinaryStream ->Object' : java.io.InputStream
+ 6 getBlob ->Object' : java.sql.Blob
+ 6 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getBytes ->Object' : byte[]
+ 6 getCharacterStream ->Object' : java.io.Reader
+ 6 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getRef -> EXCEPTION (not yet implemented)
+ 6 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getString ->'003100300036' : java.lang.String
+ 6 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype char (8 ) for bit data
+select typecol from bit_table
+ 7 getObject ->Object' : byte[]
+ 7 getArray -> EXCEPTION (not yet implemented)
+ 7 getAsciiStream ->Object' : java.io.InputStream
+ 7 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getBinaryStream ->Object' : java.io.InputStream
+ 7 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getBytes ->Object' : byte[]
+ 7 getCharacterStream ->Object' : java.io.Reader
+ 7 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getRef -> EXCEPTION (not yet implemented)
+ 7 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getString ->'0031003000372020' : java.lang.String
+ 7 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+-----< METADATA TESTS
+select col_0 from bit_table
+ ---- 1
+ Column : COL_0
+ Type : 4
+ TypeName : INTEGER
+ ClassName : java.lang.Integer
+ Label : COL_0
+ DisplaySz : 11
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '100' : java.lang.Integer
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_1 from bit_table
+ ---- 1
+ Column : COL_1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : COL_1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '101 ' : java.lang.String
+ OUT = 'true ' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_2 from bit_table
+ ---- 1
+ Column : COL_2
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : COL_2
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '102' : java.lang.String
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_3 from bit_table
+ ---- 1
+ Column : COL_3
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : COL_3
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '103' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_4 from bit_table
+ ---- 1
+ Column : COL_4
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_4
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_5 from bit_table
+ ---- 1
+ Column : COL_5
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_5
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+select col_6 from bit_table
+ ---- 1
+ Column : COL_6
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : COL_6
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select typecol from bit_table
+ ---- 1
+ Column : TYPECOL
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : TYPECOL
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+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'.
+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'.
+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'.
+select cast( col_4 as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_5 as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ 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'.
+select cast( typecol as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( typecol as char(10) ) from bit_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+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'.
+select cast( typecol as char(10) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+select cast( typecol as long varchar for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+select cast( typecol as blob(80) ) from bit_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+select cast( typecol as char (8 ) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+drop table bit_table
+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'.
+insert into bit_table ( col_1 ) values ( 'true' )
+insert into bit_table ( col_2 ) values ( 'true' )
+insert into bit_table ( col_3 ) values ( 'true' )
+insert into bit_table ( col_4 ) values cast ( X'0074007200750065' AS char(10) for bit data)
+insert into bit_table ( col_5 ) values cast ( X'0074007200750065' AS long varchar for bit data)
+insert into bit_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
+insert into bit_table ( typecol ) values cast ( X'0074007200750065' AS char (8 ) for bit data)
+=== Columntype int
+select col_0 from bit_table
+ 0 getObject ->'100' : java.lang.Integer
+ 0 getArray -> EXCEPTION (not yet implemented)
+ 0 getAsciiStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBigDecimal ->'100' : java.math.BigDecimal
+ 0 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBoolean ->'true' : java.lang.Boolean
+ 0 getByte ->'100' : java.lang.Byte
+ 0 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getCharacterStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getDouble ->'100.0' : java.lang.Double
+ 0 getFloat ->'100.0' : java.lang.Float
+ 0 getInt ->'100' : java.lang.Integer
+ 0 getLong ->'100' : java.lang.Long
+ 0 getRef -> EXCEPTION (not yet implemented)
+ 0 getShort ->'100' : java.lang.Short
+ 0 getString ->'100' : java.lang.String
+ 0 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype char(10)
+select col_1 from bit_table
+ 1 getObject ->'101 ' : java.lang.String
+ 1 getArray -> EXCEPTION (not yet implemented)
+ 1 getAsciiStream ->Object' : java.io.InputStream
+ 1 getBigDecimal ->'101' : java.math.BigDecimal
+ 1 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getBoolean ->'true' : java.lang.Boolean
+ 1 getByte ->'101' : java.lang.Byte
+ 1 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getCharacterStream ->Object' : java.io.Reader
+ 1 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getDate -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Date.)
+ 1 getDouble ->'101.0' : java.lang.Double
+ 1 getFloat ->'101.0' : java.lang.Float
+ 1 getInt ->'101' : java.lang.Integer
+ 1 getLong ->'101' : java.lang.Long
+ 1 getRef -> EXCEPTION (not yet implemented)
+ 1 getShort ->'101' : java.lang.Short
+ 1 getString ->'101 ' : java.lang.String
+ 1 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Time.)
+ 1 getTimeStamp -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Timestamp.)
+=== Columntype varchar(80)
+select col_2 from bit_table
+ 2 getObject ->'102' : java.lang.String
+ 2 getArray -> EXCEPTION (not yet implemented)
+ 2 getAsciiStream ->Object' : java.io.InputStream
+ 2 getBigDecimal ->'102' : java.math.BigDecimal
+ 2 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getBoolean ->'true' : java.lang.Boolean
+ 2 getByte ->'102' : java.lang.Byte
+ 2 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getCharacterStream ->Object' : java.io.Reader
+ 2 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getDate -> EXCEPTION (String index out of range: 3)
+ 2 getDouble ->'102.0' : java.lang.Double
+ 2 getFloat ->'102.0' : java.lang.Float
+ 2 getInt ->'102' : java.lang.Integer
+ 2 getLong ->'102' : java.lang.Long
+ 2 getRef -> EXCEPTION (not yet implemented)
+ 2 getShort ->'102' : java.lang.Short
+ 2 getString ->'102' : java.lang.String
+ 2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
+ 2 getTimeStamp -> EXCEPTION (String index out of range: 3)
+=== Columntype long varchar
+select col_3 from bit_table
+ 3 getObject ->'103' : java.lang.String
+ 3 getArray -> EXCEPTION (not yet implemented)
+ 3 getAsciiStream ->Object' : java.io.InputStream
+ 3 getBigDecimal ->'103' : java.math.BigDecimal
+ 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getBoolean ->'true' : java.lang.Boolean
+ 3 getByte ->'103' : java.lang.Byte
+ 3 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getCharacterStream ->Object' : java.io.Reader
+ 3 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getDate -> EXCEPTION (String index out of range: 3)
+ 3 getDouble ->'103.0' : java.lang.Double
+ 3 getFloat ->'103.0' : java.lang.Float
+ 3 getInt ->'103' : java.lang.Integer
+ 3 getLong ->'103' : java.lang.Long
+ 3 getRef -> EXCEPTION (not yet implemented)
+ 3 getShort ->'103' : java.lang.Short
+ 3 getString ->'103' : java.lang.String
+ 3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
+ 3 getTimeStamp -> EXCEPTION (String index out of range: 3)
+=== Columntype char(10) for bit data
+select col_4 from bit_table
+ 4 getObject ->Object' : byte[]
+ 4 getArray -> EXCEPTION (not yet implemented)
+ 4 getAsciiStream ->Object' : java.io.InputStream
+ 4 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBinaryStream ->Object' : java.io.InputStream
+ 4 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBytes ->Object' : byte[]
+ 4 getCharacterStream ->Object' : java.io.Reader
+ 4 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getRef -> EXCEPTION (not yet implemented)
+ 4 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getString ->'00310030003420202020' : java.lang.String
+ 4 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype long varchar for bit data
+select col_5 from bit_table
+ 5 getObject ->Object' : byte[]
+ 5 getArray -> EXCEPTION (not yet implemented)
+ 5 getAsciiStream ->Object' : java.io.InputStream
+ 5 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBinaryStream ->Object' : java.io.InputStream
+ 5 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBytes ->Object' : byte[]
+ 5 getCharacterStream ->Object' : java.io.Reader
+ 5 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getRef -> EXCEPTION (not yet implemented)
+ 5 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getString ->'003100300035' : java.lang.String
+ 5 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype blob(80)
+select col_6 from bit_table
+ 6 getObject ->Object' : java.sql.Blob
+ 6 getArray -> EXCEPTION (not yet implemented)
+ 6 getAsciiStream ->Object' : java.io.InputStream
+ 6 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getBinaryStream ->Object' : java.io.InputStream
+ 6 getBlob ->Object' : java.sql.Blob
+ 6 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getBytes ->Object' : byte[]
+ 6 getCharacterStream ->Object' : java.io.Reader
+ 6 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getRef -> EXCEPTION (not yet implemented)
+ 6 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getString ->'003100300036' : java.lang.String
+ 6 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype char (8 ) for bit data
+select typecol from bit_table
+ 7 getObject ->Object' : byte[]
+ 7 getArray -> EXCEPTION (not yet implemented)
+ 7 getAsciiStream ->Object' : java.io.InputStream
+ 7 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getBinaryStream ->Object' : java.io.InputStream
+ 7 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getBytes ->Object' : byte[]
+ 7 getCharacterStream ->Object' : java.io.Reader
+ 7 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getRef -> EXCEPTION (not yet implemented)
+ 7 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getString ->'0031003000372020' : java.lang.String
+ 7 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+-----< METADATA TESTS
+select col_0 from bit_table
+ ---- 1
+ Column : COL_0
+ Type : 4
+ TypeName : INTEGER
+ ClassName : java.lang.Integer
+ Label : COL_0
+ DisplaySz : 11
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '100' : java.lang.Integer
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_1 from bit_table
+ ---- 1
+ Column : COL_1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : COL_1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '101 ' : java.lang.String
+ OUT = 'true ' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_2 from bit_table
+ ---- 1
+ Column : COL_2
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : COL_2
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '102' : java.lang.String
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_3 from bit_table
+ ---- 1
+ Column : COL_3
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : COL_3
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '103' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_4 from bit_table
+ ---- 1
+ Column : COL_4
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_4
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_5 from bit_table
+ ---- 1
+ Column : COL_5
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_5
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+select col_6 from bit_table
+ ---- 1
+ Column : COL_6
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : COL_6
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select typecol from bit_table
+ ---- 1
+ Column : TYPECOL
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : TYPECOL
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+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'.
+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'.
+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'.
+select cast( col_4 as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_5 as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ 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'.
+select cast( typecol as char (8) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( typecol as char(10) ) from bit_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+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'.
+select cast( typecol as char(10) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+select cast( typecol as long varchar for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+select cast( typecol as blob(80) ) from bit_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+select cast( typecol as char (8 ) for bit data ) from bit_table
+ ---- 1
+ Column : 1
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : 1
+ DisplaySz : 16
+ Precision : 8
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+drop table bit_table
+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'.
+insert into blob_table ( col_1 ) values ( 'true' )
+insert into blob_table ( col_2 ) values ( 'true' )
+insert into blob_table ( col_3 ) values ( 'true' )
+insert into blob_table ( col_4 ) values cast ( X'0074007200750065' AS char(10) for bit data)
+insert into blob_table ( col_5 ) values cast ( X'0074007200750065' AS long varchar for bit data)
+insert into blob_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
+insert into blob_table ( typecol ) values cast ( X'0074007200750065' AS blob (2 M))
+=== Columntype int
+select col_0 from blob_table
+ 0 getObject ->'100' : java.lang.Integer
+ 0 getArray -> EXCEPTION (not yet implemented)
+ 0 getAsciiStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBigDecimal ->'100' : java.math.BigDecimal
+ 0 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBoolean ->'true' : java.lang.Boolean
+ 0 getByte ->'100' : java.lang.Byte
+ 0 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getCharacterStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getDouble ->'100.0' : java.lang.Double
+ 0 getFloat ->'100.0' : java.lang.Float
+ 0 getInt ->'100' : java.lang.Integer
+ 0 getLong ->'100' : java.lang.Long
+ 0 getRef -> EXCEPTION (not yet implemented)
+ 0 getShort ->'100' : java.lang.Short
+ 0 getString ->'100' : java.lang.String
+ 0 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype char(10)
+select col_1 from blob_table
+ 1 getObject ->'101 ' : java.lang.String
+ 1 getArray -> EXCEPTION (not yet implemented)
+ 1 getAsciiStream ->Object' : java.io.InputStream
+ 1 getBigDecimal ->'101' : java.math.BigDecimal
+ 1 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getBoolean ->'true' : java.lang.Boolean
+ 1 getByte ->'101' : java.lang.Byte
+ 1 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getCharacterStream ->Object' : java.io.Reader
+ 1 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getDate -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Date.)
+ 1 getDouble ->'101.0' : java.lang.Double
+ 1 getFloat ->'101.0' : java.lang.Float
+ 1 getInt ->'101' : java.lang.Integer
+ 1 getLong ->'101' : java.lang.Long
+ 1 getRef -> EXCEPTION (not yet implemented)
+ 1 getShort ->'101' : java.lang.Short
+ 1 getString ->'101 ' : java.lang.String
+ 1 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Time.)
+ 1 getTimeStamp -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Timestamp.)
+=== Columntype varchar(80)
+select col_2 from blob_table
+ 2 getObject ->'102' : java.lang.String
+ 2 getArray -> EXCEPTION (not yet implemented)
+ 2 getAsciiStream ->Object' : java.io.InputStream
+ 2 getBigDecimal ->'102' : java.math.BigDecimal
+ 2 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getBoolean ->'true' : java.lang.Boolean
+ 2 getByte ->'102' : java.lang.Byte
+ 2 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getCharacterStream ->Object' : java.io.Reader
+ 2 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getDate -> EXCEPTION (String index out of range: 3)
+ 2 getDouble ->'102.0' : java.lang.Double
+ 2 getFloat ->'102.0' : java.lang.Float
+ 2 getInt ->'102' : java.lang.Integer
+ 2 getLong ->'102' : java.lang.Long
+ 2 getRef -> EXCEPTION (not yet implemented)
+ 2 getShort ->'102' : java.lang.Short
+ 2 getString ->'102' : java.lang.String
+ 2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
+ 2 getTimeStamp -> EXCEPTION (String index out of range: 3)
+=== Columntype long varchar
+select col_3 from blob_table
+ 3 getObject ->'103' : java.lang.String
+ 3 getArray -> EXCEPTION (not yet implemented)
+ 3 getAsciiStream ->Object' : java.io.InputStream
+ 3 getBigDecimal ->'103' : java.math.BigDecimal
+ 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getBoolean ->'true' : java.lang.Boolean
+ 3 getByte ->'103' : java.lang.Byte
+ 3 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getCharacterStream ->Object' : java.io.Reader
+ 3 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getDate -> EXCEPTION (String index out of range: 3)
+ 3 getDouble ->'103.0' : java.lang.Double
+ 3 getFloat ->'103.0' : java.lang.Float
+ 3 getInt ->'103' : java.lang.Integer
+ 3 getLong ->'103' : java.lang.Long
+ 3 getRef -> EXCEPTION (not yet implemented)
+ 3 getShort ->'103' : java.lang.Short
+ 3 getString ->'103' : java.lang.String
+ 3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
+ 3 getTimeStamp -> EXCEPTION (String index out of range: 3)
+=== Columntype char(10) for bit data
+select col_4 from blob_table
+ 4 getObject ->Object' : byte[]
+ 4 getArray -> EXCEPTION (not yet implemented)
+ 4 getAsciiStream ->Object' : java.io.InputStream
+ 4 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBinaryStream ->Object' : java.io.InputStream
+ 4 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBytes ->Object' : byte[]
+ 4 getCharacterStream ->Object' : java.io.Reader
+ 4 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getRef -> EXCEPTION (not yet implemented)
+ 4 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getString ->'00310030003420202020' : java.lang.String
+ 4 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype long varchar for bit data
+select col_5 from blob_table
+ 5 getObject ->Object' : byte[]
+ 5 getArray -> EXCEPTION (not yet implemented)
+ 5 getAsciiStream ->Object' : java.io.InputStream
+ 5 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBinaryStream ->Object' : java.io.InputStream
+ 5 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBytes ->Object' : byte[]
+ 5 getCharacterStream ->Object' : java.io.Reader
+ 5 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getRef -> EXCEPTION (not yet implemented)
+ 5 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getString ->'003100300035' : java.lang.String
+ 5 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype blob(80)
+select col_6 from blob_table
+ 6 getObject ->Object' : java.sql.Blob
+ 6 getArray -> EXCEPTION (not yet implemented)
+ 6 getAsciiStream ->Object' : java.io.InputStream
+ 6 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getBinaryStream ->Object' : java.io.InputStream
+ 6 getBlob ->Object' : java.sql.Blob
+ 6 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getBytes ->Object' : byte[]
+ 6 getCharacterStream ->Object' : java.io.Reader
+ 6 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getRef -> EXCEPTION (not yet implemented)
+ 6 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getString ->'003100300036' : java.lang.String
+ 6 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype blob (2 M)
+select typecol from blob_table
+ 7 getObject ->Object' : java.sql.Blob
+ 7 getArray -> EXCEPTION (not yet implemented)
+ 7 getAsciiStream ->Object' : java.io.InputStream
+ 7 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getBinaryStream ->Object' : java.io.InputStream
+ 7 getBlob ->Object' : java.sql.Blob
+ 7 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getBytes ->Object' : byte[]
+ 7 getCharacterStream ->Object' : java.io.Reader
+ 7 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getRef -> EXCEPTION (not yet implemented)
+ 7 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getString ->'003100300037' : java.lang.String
+ 7 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+-----< METADATA TESTS
+select col_0 from blob_table
+ ---- 1
+ Column : COL_0
+ Type : 4
+ TypeName : INTEGER
+ ClassName : java.lang.Integer
+ Label : COL_0
+ DisplaySz : 11
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '100' : java.lang.Integer
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_1 from blob_table
+ ---- 1
+ Column : COL_1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : COL_1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '101 ' : java.lang.String
+ OUT = 'true ' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_2 from blob_table
+ ---- 1
+ Column : COL_2
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : COL_2
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '102' : java.lang.String
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_3 from blob_table
+ ---- 1
+ Column : COL_3
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : COL_3
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '103' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_4 from blob_table
+ ---- 1
+ Column : COL_4
+ Type : -2
+ TypeName : CHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_4
+ DisplaySz : 20
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_5 from blob_table
+ ---- 1
+ Column : COL_5
+ Type : -4
+ TypeName : LONG VARCHAR FOR BIT DATA
+ ClassName : byte[]
+ Label : COL_5
+ DisplaySz : 65400
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : byte[]
+ OUT = NULL
+ OUT = NULL
+select col_6 from blob_table
+ ---- 1
+ Column : COL_6
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : COL_6
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select typecol from blob_table
+ ---- 1
+ Column : TYPECOL
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : TYPECOL
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( col_1 as blob(2 M) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+select cast( col_3 as blob(2 M) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: Cannot convert types 'LONG VARCHAR' to 'BLOB'.
+select cast( col_4 as blob(2 M) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select cast( col_5 as blob(2 M) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+select cast( col_6 as blob(2 M) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+select cast( typecol as blob(2 M) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ 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'.
+select cast( typecol as char(10) ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+select cast( typecol as long varchar ) from blob_table
+ com.ibm.db2.jcc.c.SqlException: 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'.
+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'.
+select cast( typecol as blob(80) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 160
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+select cast( typecol as blob (2 M) ) from blob_table
+ ---- 1
+ Column : 1
+ Type : 2004
+ TypeName : BLOB
+ ClassName : java.sql.Blob
+ Label : 1
+ DisplaySz : 4194304
+ Precision : 2097152
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = Object : java.sql.Blob
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = Object : java.sql.Blob
+drop table blob_table
+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'.
+insert into blob_table ( col_1 ) values ( 'true' )
+insert into blob_table ( col_2 ) values ( 'true' )
+insert into blob_table ( col_3 ) values ( 'true' )
+insert into blob_table ( col_4 ) values cast ( X'0074007200750065' AS char(10) for bit data)
+insert into blob_table ( col_5 ) values cast ( X'0074007200750065' AS long varchar for bit data)
+insert into blob_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
+insert into blob_table ( typecol ) values cast ( X'0074007200750065' AS blob (2 K))
+=== Columntype int
+select col_0 from blob_table
+ 0 getObject ->'100' : java.lang.Integer
+ 0 getArray -> EXCEPTION (not yet implemented)
+ 0 getAsciiStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBigDecimal ->'100' : java.math.BigDecimal
+ 0 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getBoolean ->'true' : java.lang.Boolean
+ 0 getByte ->'100' : java.lang.Byte
+ 0 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getCharacterStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getDouble ->'100.0' : java.lang.Double
+ 0 getFloat ->'100.0' : java.lang.Float
+ 0 getInt ->'100' : java.lang.Integer
+ 0 getLong ->'100' : java.lang.Long
+ 0 getRef -> EXCEPTION (not yet implemented)
+ 0 getShort ->'100' : java.lang.Short
+ 0 getString ->'100' : java.lang.String
+ 0 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 0 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype char(10)
+select col_1 from blob_table
+ 1 getObject ->'101 ' : java.lang.String
+ 1 getArray -> EXCEPTION (not yet implemented)
+ 1 getAsciiStream ->Object' : java.io.InputStream
+ 1 getBigDecimal ->'101' : java.math.BigDecimal
+ 1 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getBoolean ->'true' : java.lang.Boolean
+ 1 getByte ->'101' : java.lang.Byte
+ 1 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getCharacterStream ->Object' : java.io.Reader
+ 1 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 1 getDate -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Date.)
+ 1 getDouble ->'101.0' : java.lang.Double
+ 1 getFloat ->'101.0' : java.lang.Float
+ 1 getInt ->'101' : java.lang.Integer
+ 1 getLong ->'101' : java.lang.Long
+ 1 getRef -> EXCEPTION (not yet implemented)
+ 1 getShort ->'101' : java.lang.Short
+ 1 getString ->'101 ' : java.lang.String
+ 1 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Time.)
+ 1 getTimeStamp -> EXCEPTION (Invalid data conversion: Parameter instance 101 is invalid for requested conversion to java.sql.Timestamp.)
+=== Columntype varchar(80)
+select col_2 from blob_table
+ 2 getObject ->'102' : java.lang.String
+ 2 getArray -> EXCEPTION (not yet implemented)
+ 2 getAsciiStream ->Object' : java.io.InputStream
+ 2 getBigDecimal ->'102' : java.math.BigDecimal
+ 2 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getBoolean ->'true' : java.lang.Boolean
+ 2 getByte ->'102' : java.lang.Byte
+ 2 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getCharacterStream ->Object' : java.io.Reader
+ 2 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 2 getDate -> EXCEPTION (String index out of range: 3)
+ 2 getDouble ->'102.0' : java.lang.Double
+ 2 getFloat ->'102.0' : java.lang.Float
+ 2 getInt ->'102' : java.lang.Integer
+ 2 getLong ->'102' : java.lang.Long
+ 2 getRef -> EXCEPTION (not yet implemented)
+ 2 getShort ->'102' : java.lang.Short
+ 2 getString ->'102' : java.lang.String
+ 2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
+ 2 getTimeStamp -> EXCEPTION (String index out of range: 3)
+=== Columntype long varchar
+select col_3 from blob_table
+ 3 getObject ->'103' : java.lang.String
+ 3 getArray -> EXCEPTION (not yet implemented)
+ 3 getAsciiStream ->Object' : java.io.InputStream
+ 3 getBigDecimal ->'103' : java.math.BigDecimal
+ 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getBoolean ->'true' : java.lang.Boolean
+ 3 getByte ->'103' : java.lang.Byte
+ 3 getBytes -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getCharacterStream ->Object' : java.io.Reader
+ 3 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 3 getDate -> EXCEPTION (String index out of range: 3)
+ 3 getDouble ->'103.0' : java.lang.Double
+ 3 getFloat ->'103.0' : java.lang.Float
+ 3 getInt ->'103' : java.lang.Integer
+ 3 getLong ->'103' : java.lang.Long
+ 3 getRef -> EXCEPTION (not yet implemented)
+ 3 getShort ->'103' : java.lang.Short
+ 3 getString ->'103' : java.lang.String
+ 3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
+ 3 getTimeStamp -> EXCEPTION (String index out of range: 3)
+=== Columntype char(10) for bit data
+select col_4 from blob_table
+ 4 getObject ->Object' : byte[]
+ 4 getArray -> EXCEPTION (not yet implemented)
+ 4 getAsciiStream ->Object' : java.io.InputStream
+ 4 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBinaryStream ->Object' : java.io.InputStream
+ 4 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getBytes ->Object' : byte[]
+ 4 getCharacterStream ->Object' : java.io.Reader
+ 4 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getRef -> EXCEPTION (not yet implemented)
+ 4 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getString ->'00310030003420202020' : java.lang.String
+ 4 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 4 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype long varchar for bit data
+select col_5 from blob_table
+ 5 getObject ->Object' : byte[]
+ 5 getArray -> EXCEPTION (not yet implemented)
+ 5 getAsciiStream ->Object' : java.io.InputStream
+ 5 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBinaryStream ->Object' : java.io.InputStream
+ 5 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getBytes ->Object' : byte[]
+ 5 getCharacterStream ->Object' : java.io.Reader
+ 5 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getRef -> EXCEPTION (not yet implemented)
+ 5 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getString ->'003100300035' : java.lang.String
+ 5 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 5 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype blob(80)
+select col_6 from blob_table
+ 6 getObject ->Object' : java.sql.Blob
+ 6 getArray -> EXCEPTION (not yet implemented)
+ 6 getAsciiStream ->Object' : java.io.InputStream
+ 6 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getBinaryStream ->Object' : java.io.InputStream
+ 6 getBlob ->Object' : java.sql.Blob
+ 6 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getBytes ->Object' : byte[]
+ 6 getCharacterStream ->Object' : java.io.Reader
+ 6 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getRef -> EXCEPTION (not yet implemented)
+ 6 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getString ->'003100300036' : java.lang.String
+ 6 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 6 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+=== Columntype blob (2 K)
+select typecol from blob_table
+ 7 getObject ->Object' : java.sql.Blob
+ 7 getArray -> EXCEPTION (not yet implemented)
+ 7 getAsciiStream ->Object' : java.io.InputStream
+ 7 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getBinaryStream ->Object' : java.io.InputStream
+ 7 getBlob ->Object' : java.sql.Blob
+ 7 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getBytes ->Object' : byte[]
+ 7 getCharacterStream ->Object' : java.io.Reader
+ 7 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getRef -> EXCEPTION (not yet implemented)
+ 7 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getString ->'003100300037' : java.lang.String
+ 7 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+ 7 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
+-----< METADATA TESTS
+select col_0 from blob_table
+ ---- 1
+ Column : COL_0
+ Type : 4
+ TypeName : INTEGER
+ ClassName : java.lang.Integer
+ Label : COL_0
+ DisplaySz : 11
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: false
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '100' : java.lang.Integer
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_1 from blob_table
+ ---- 1
+ Column : COL_1
+ Type : 1
+ TypeName : CHAR
+ ClassName : java.lang.String
+ Label : COL_1
+ DisplaySz : 10
+ Precision : 10
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '101 ' : java.lang.String
+ OUT = 'true ' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_2 from blob_table
+ ---- 1
+ Column : COL_2
+ Type : 12
+ TypeName : VARCHAR
+ ClassName : java.lang.String
+ Label : COL_2
+ DisplaySz : 80
+ Precision : 80
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
+ isWrite : false
+ isSearchab: true
+ OUT = '102' : java.lang.String
+ OUT = NULL
+ OUT = 'true' : java.lang.String
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+ OUT = NULL
+select col_3 from blob_table
+ ---- 1
+ Column : COL_3
+ Type : -1
+ TypeName : LONG VARCHAR
+ ClassName : java.lang.String
+ Label : COL_3
+ DisplaySz : 32700
+ Precision : 32700
+ Scale : 0
+ isCurrency: false
+ isCaseSens: true
+ isDefWrite: false
[... 1931 lines stripped ...]