db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bakk...@apache.org
Subject svn commit: r329187 [31/66] - in /db/derby/code/trunk: ./ frameworks/NetworkServer/ frameworks/NetworkServer/bin/ frameworks/embedded/bin/ java/build/ java/build/org/apache/derbyBuild/ java/build/org/apache/derbyBuild/eclipse/ java/build/org/apache/der...
Date Fri, 28 Oct 2005 12:52:21 GMT
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out?rev=329187&r1=329186&r2=329187&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out Fri Oct 28 04:51:50 2005
@@ -1,3873 +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' )
-	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' )
-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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Date.)
-	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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
-=== 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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Date.)
-	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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
-=== 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
-	ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
-select cast( col_1 as char (8) for bit data ) from bit_table
-	ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
-select cast( col_2 as char (8) for bit data ) from bit_table
-	ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
-select cast( col_3 as char (8) for bit data ) from bit_table
-	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
-	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
-	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
-	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
-	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
-select cast( typecol as char(10) ) from bit_table
-	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
-select cast( typecol as varchar(80) ) from bit_table
-	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
-select cast( typecol as long varchar ) from bit_table
-	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
-	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' )
-	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' )
-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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Date.)
-	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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
-=== 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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Date.)
-	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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
-=== 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
-	ERROR 42846: Cannot convert types 'INTEGER' to 'CHAR () FOR BIT DATA'.
-select cast( col_1 as char (8) for bit data ) from bit_table
-	ERROR 42846: Cannot convert types 'CHAR' to 'CHAR () FOR BIT DATA'.
-select cast( col_2 as char (8) for bit data ) from bit_table
-	ERROR 42846: Cannot convert types 'VARCHAR' to 'CHAR () FOR BIT DATA'.
-select cast( col_3 as char (8) for bit data ) from bit_table
-	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
-	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
-	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
-	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
-	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'INTEGER'.
-select cast( typecol as char(10) ) from bit_table
-	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CHAR'.
-select cast( typecol as varchar(80) ) from bit_table
-	ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'VARCHAR'.
-select cast( typecol as long varchar ) from bit_table
-	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
-	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' )
-	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' )
-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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Date.)
-	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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
-=== 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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Date.)
-	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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
-=== 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
-	ERROR 42846: Cannot convert types 'INTEGER' to 'BLOB'.
-select cast( col_1 as blob(2 M) ) from blob_table
-	ERROR 42846: Cannot convert types 'CHAR' to 'BLOB'.
-select cast( col_2 as blob(2 M) ) from blob_table
-	ERROR 42846: Cannot convert types 'VARCHAR' to 'BLOB'.
-select cast( col_3 as blob(2 M) ) from blob_table
-	ERROR 42846: 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
-	ERROR 42846: Cannot convert types 'BLOB' to 'INTEGER'.
-select cast( typecol as char(10) ) from blob_table
-	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR'.
-select cast( typecol as varchar(80) ) from blob_table
-	ERROR 42846: Cannot convert types 'BLOB' to 'VARCHAR'.
-select cast( typecol as long varchar ) from blob_table
-	ERROR 42846: Cannot convert types 'BLOB' to 'LONG VARCHAR'.
-select cast( typecol as char(10) for bit data ) from blob_table
-	ERROR 42846: Cannot convert types 'BLOB' to 'CHAR () FOR BIT DATA'.
-select cast( typecol as long varchar for bit data ) from blob_table
-	ERROR 42846: 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' )
-	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' )
-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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Date.)
-	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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
-=== 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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Date.)
-	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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
-=== 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.)

[... 5896 lines stripped ...]


Mime
View raw message