db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From davi...@apache.org
Subject svn commit: r386169 [13/36] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master: DerbyNet/jdk16/ DerbyNetClient/jdk16/ jdk16/
Date Wed, 15 Mar 2006 21:31:59 GMT
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/LOBTest.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/LOBTest.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/LOBTest.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/LOBTest.out Wed Mar 15 13:31:53 2006
@@ -0,0 +1,3874 @@
+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 as col_0_1, col_0 as col_0_2, col_0 as col_0_3, col_0 as col_0_4, col_0 as col_0_5, col_0 as col_0_6, col_0 as col_0_7, col_0 as col_0_8, col_0 as col_0_9, col_0 as col_0_10, col_0 as col_0_11, col_0 as col_0_12, col_0 as col_0_13, col_0 as col_0_14, col_0 as col_0_15, col_0 as col_0_16, col_0 as col_0_17, col_0 as col_0_18, col_0 as col_0_19, col_0 as col_0_20, col_0 as col_0_21 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 as col_1_1, col_1 as col_1_2, col_1 as col_1_3, col_1 as col_1_4, col_1 as col_1_5, col_1 as col_1_6, col_1 as col_1_7, col_1 as col_1_8, col_1 as col_1_9, col_1 as col_1_10, col_1 as col_1_11, col_1 as col_1_12, col_1 as col_1_13, col_1 as col_1_14, col_1 as col_1_15, col_1 as col_1_16, col_1 as col_1_17, col_1 as col_1_18, col_1 as col_1_19, col_1 as col_1_20, col_1 as col_1_21 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 as col_2_1, col_2 as col_2_2, col_2 as col_2_3, col_2 as col_2_4, col_2 as col_2_5, col_2 as col_2_6, col_2 as col_2_7, col_2 as col_2_8, col_2 as col_2_9, col_2 as col_2_10, col_2 as col_2_11, col_2 as col_2_12, col_2 as col_2_13, col_2 as col_2_14, col_2 as col_2_15, col_2 as col_2_16, col_2 as col_2_17, col_2 as col_2_18, col_2 as col_2_19, col_2 as col_2_20, col_2 as col_2_21 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 as col_3_1, col_3 as col_3_2, col_3 as col_3_3, col_3 as col_3_4, col_3 as col_3_5, col_3 as col_3_6, col_3 as col_3_7, col_3 as col_3_8, col_3 as col_3_9, col_3 as col_3_10, col_3 as col_3_11, col_3 as col_3_12, col_3 as col_3_13, col_3 as col_3_14, col_3 as col_3_15, col_3 as col_3_16, col_3 as col_3_17, col_3 as col_3_18, col_3 as col_3_19, col_3 as col_3_20, col_3 as col_3_21 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 as col_4_1, col_4 as col_4_2, col_4 as col_4_3, col_4 as col_4_4, col_4 as col_4_5, col_4 as col_4_6, col_4 as col_4_7, col_4 as col_4_8, col_4 as col_4_9, col_4 as col_4_10, col_4 as col_4_11, col_4 as col_4_12, col_4 as col_4_13, col_4 as col_4_14, col_4 as col_4_15, col_4 as col_4_16, col_4 as col_4_17, col_4 as col_4_18, col_4 as col_4_19, col_4 as col_4_20, col_4 as col_4_21 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 as col_5_1, col_5 as col_5_2, col_5 as col_5_3, col_5 as col_5_4, col_5 as col_5_5, col_5 as col_5_6, col_5 as col_5_7, col_5 as col_5_8, col_5 as col_5_9, col_5 as col_5_10, col_5 as col_5_11, col_5 as col_5_12, col_5 as col_5_13, col_5 as col_5_14, col_5 as col_5_15, col_5 as col_5_16, col_5 as col_5_17, col_5 as col_5_18, col_5 as col_5_19, col_5 as col_5_20, col_5 as col_5_21 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 as col_6_1, col_6 as col_6_2, col_6 as col_6_3, col_6 as col_6_4, col_6 as col_6_5, col_6 as col_6_6, col_6 as col_6_7, col_6 as col_6_8, col_6 as col_6_9, col_6 as col_6_10, col_6 as col_6_11, col_6 as col_6_12, col_6 as col_6_13, col_6 as col_6_14, col_6 as col_6_15, col_6 as col_6_16, col_6 as col_6_17, col_6 as col_6_18, col_6 as col_6_19, col_6 as col_6_20, col_6 as col_6_21 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 as typecol_1, typecol as typecol_2, typecol as typecol_3, typecol as typecol_4, typecol as typecol_5, typecol as typecol_6, typecol as typecol_7, typecol as typecol_8, typecol as typecol_9, typecol as typecol_10, typecol as typecol_11, typecol as typecol_12, typecol as typecol_13, typecol as typecol_14, typecol as typecol_15, typecol as typecol_16, typecol as typecol_17, typecol as typecol_18, typecol as typecol_19, typecol as typecol_20, typecol as typecol_21 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 as col_0_1, col_0 as col_0_2, col_0 as col_0_3, col_0 as col_0_4, col_0 as col_0_5, col_0 as col_0_6, col_0 as col_0_7, col_0 as col_0_8, col_0 as col_0_9, col_0 as col_0_10, col_0 as col_0_11, col_0 as col_0_12, col_0 as col_0_13, col_0 as col_0_14, col_0 as col_0_15, col_0 as col_0_16, col_0 as col_0_17, col_0 as col_0_18, col_0 as col_0_19, col_0 as col_0_20, col_0 as col_0_21 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 as col_1_1, col_1 as col_1_2, col_1 as col_1_3, col_1 as col_1_4, col_1 as col_1_5, col_1 as col_1_6, col_1 as col_1_7, col_1 as col_1_8, col_1 as col_1_9, col_1 as col_1_10, col_1 as col_1_11, col_1 as col_1_12, col_1 as col_1_13, col_1 as col_1_14, col_1 as col_1_15, col_1 as col_1_16, col_1 as col_1_17, col_1 as col_1_18, col_1 as col_1_19, col_1 as col_1_20, col_1 as col_1_21 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 as col_2_1, col_2 as col_2_2, col_2 as col_2_3, col_2 as col_2_4, col_2 as col_2_5, col_2 as col_2_6, col_2 as col_2_7, col_2 as col_2_8, col_2 as col_2_9, col_2 as col_2_10, col_2 as col_2_11, col_2 as col_2_12, col_2 as col_2_13, col_2 as col_2_14, col_2 as col_2_15, col_2 as col_2_16, col_2 as col_2_17, col_2 as col_2_18, col_2 as col_2_19, col_2 as col_2_20, col_2 as col_2_21 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 as col_3_1, col_3 as col_3_2, col_3 as col_3_3, col_3 as col_3_4, col_3 as col_3_5, col_3 as col_3_6, col_3 as col_3_7, col_3 as col_3_8, col_3 as col_3_9, col_3 as col_3_10, col_3 as col_3_11, col_3 as col_3_12, col_3 as col_3_13, col_3 as col_3_14, col_3 as col_3_15, col_3 as col_3_16, col_3 as col_3_17, col_3 as col_3_18, col_3 as col_3_19, col_3 as col_3_20, col_3 as col_3_21 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 as col_4_1, col_4 as col_4_2, col_4 as col_4_3, col_4 as col_4_4, col_4 as col_4_5, col_4 as col_4_6, col_4 as col_4_7, col_4 as col_4_8, col_4 as col_4_9, col_4 as col_4_10, col_4 as col_4_11, col_4 as col_4_12, col_4 as col_4_13, col_4 as col_4_14, col_4 as col_4_15, col_4 as col_4_16, col_4 as col_4_17, col_4 as col_4_18, col_4 as col_4_19, col_4 as col_4_20, col_4 as col_4_21 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 as col_5_1, col_5 as col_5_2, col_5 as col_5_3, col_5 as col_5_4, col_5 as col_5_5, col_5 as col_5_6, col_5 as col_5_7, col_5 as col_5_8, col_5 as col_5_9, col_5 as col_5_10, col_5 as col_5_11, col_5 as col_5_12, col_5 as col_5_13, col_5 as col_5_14, col_5 as col_5_15, col_5 as col_5_16, col_5 as col_5_17, col_5 as col_5_18, col_5 as col_5_19, col_5 as col_5_20, col_5 as col_5_21 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 as col_6_1, col_6 as col_6_2, col_6 as col_6_3, col_6 as col_6_4, col_6 as col_6_5, col_6 as col_6_6, col_6 as col_6_7, col_6 as col_6_8, col_6 as col_6_9, col_6 as col_6_10, col_6 as col_6_11, col_6 as col_6_12, col_6 as col_6_13, col_6 as col_6_14, col_6 as col_6_15, col_6 as col_6_16, col_6 as col_6_17, col_6 as col_6_18, col_6 as col_6_19, col_6 as col_6_20, col_6 as col_6_21 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 as typecol_1, typecol as typecol_2, typecol as typecol_3, typecol as typecol_4, typecol as typecol_5, typecol as typecol_6, typecol as typecol_7, typecol as typecol_8, typecol as typecol_9, typecol as typecol_10, typecol as typecol_11, typecol as typecol_12, typecol as typecol_13, typecol as typecol_14, typecol as typecol_15, typecol as typecol_16, typecol as typecol_17, typecol as typecol_18, typecol as typecol_19, typecol as typecol_20, typecol as typecol_21 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 as col_0_1, col_0 as col_0_2, col_0 as col_0_3, col_0 as col_0_4, col_0 as col_0_5, col_0 as col_0_6, col_0 as col_0_7, col_0 as col_0_8, col_0 as col_0_9, col_0 as col_0_10, col_0 as col_0_11, col_0 as col_0_12, col_0 as col_0_13, col_0 as col_0_14, col_0 as col_0_15, col_0 as col_0_16, col_0 as col_0_17, col_0 as col_0_18, col_0 as col_0_19, col_0 as col_0_20, col_0 as col_0_21 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 as col_1_1, col_1 as col_1_2, col_1 as col_1_3, col_1 as col_1_4, col_1 as col_1_5, col_1 as col_1_6, col_1 as col_1_7, col_1 as col_1_8, col_1 as col_1_9, col_1 as col_1_10, col_1 as col_1_11, col_1 as col_1_12, col_1 as col_1_13, col_1 as col_1_14, col_1 as col_1_15, col_1 as col_1_16, col_1 as col_1_17, col_1 as col_1_18, col_1 as col_1_19, col_1 as col_1_20, col_1 as col_1_21 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 as col_2_1, col_2 as col_2_2, col_2 as col_2_3, col_2 as col_2_4, col_2 as col_2_5, col_2 as col_2_6, col_2 as col_2_7, col_2 as col_2_8, col_2 as col_2_9, col_2 as col_2_10, col_2 as col_2_11, col_2 as col_2_12, col_2 as col_2_13, col_2 as col_2_14, col_2 as col_2_15, col_2 as col_2_16, col_2 as col_2_17, col_2 as col_2_18, col_2 as col_2_19, col_2 as col_2_20, col_2 as col_2_21 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 as col_3_1, col_3 as col_3_2, col_3 as col_3_3, col_3 as col_3_4, col_3 as col_3_5, col_3 as col_3_6, col_3 as col_3_7, col_3 as col_3_8, col_3 as col_3_9, col_3 as col_3_10, col_3 as col_3_11, col_3 as col_3_12, col_3 as col_3_13, col_3 as col_3_14, col_3 as col_3_15, col_3 as col_3_16, col_3 as col_3_17, col_3 as col_3_18, col_3 as col_3_19, col_3 as col_3_20, col_3 as col_3_21 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 as col_4_1, col_4 as col_4_2, col_4 as col_4_3, col_4 as col_4_4, col_4 as col_4_5, col_4 as col_4_6, col_4 as col_4_7, col_4 as col_4_8, col_4 as col_4_9, col_4 as col_4_10, col_4 as col_4_11, col_4 as col_4_12, col_4 as col_4_13, col_4 as col_4_14, col_4 as col_4_15, col_4 as col_4_16, col_4 as col_4_17, col_4 as col_4_18, col_4 as col_4_19, col_4 as col_4_20, col_4 as col_4_21 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 as col_5_1, col_5 as col_5_2, col_5 as col_5_3, col_5 as col_5_4, col_5 as col_5_5, col_5 as col_5_6, col_5 as col_5_7, col_5 as col_5_8, col_5 as col_5_9, col_5 as col_5_10, col_5 as col_5_11, col_5 as col_5_12, col_5 as col_5_13, col_5 as col_5_14, col_5 as col_5_15, col_5 as col_5_16, col_5 as col_5_17, col_5 as col_5_18, col_5 as col_5_19, col_5 as col_5_20, col_5 as col_5_21 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 as col_6_1, col_6 as col_6_2, col_6 as col_6_3, col_6 as col_6_4, col_6 as col_6_5, col_6 as col_6_6, col_6 as col_6_7, col_6 as col_6_8, col_6 as col_6_9, col_6 as col_6_10, col_6 as col_6_11, col_6 as col_6_12, col_6 as col_6_13, col_6 as col_6_14, col_6 as col_6_15, col_6 as col_6_16, col_6 as col_6_17, col_6 as col_6_18, col_6 as col_6_19, col_6 as col_6_20, col_6 as col_6_21 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 as typecol_1, typecol as typecol_2, typecol as typecol_3, typecol as typecol_4, typecol as typecol_5, typecol as typecol_6, typecol as typecol_7, typecol as typecol_8, typecol as typecol_9, typecol as typecol_10, typecol as typecol_11, typecol as typecol_12, typecol as typecol_13, typecol as typecol_14, typecol as typecol_15, typecol as typecol_16, typecol as typecol_17, typecol as typecol_18, typecol as typecol_19, typecol as typecol_20, typecol as typecol_21 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 as col_0_1, col_0 as col_0_2, col_0 as col_0_3, col_0 as col_0_4, col_0 as col_0_5, col_0 as col_0_6, col_0 as col_0_7, col_0 as col_0_8, col_0 as col_0_9, col_0 as col_0_10, col_0 as col_0_11, col_0 as col_0_12, col_0 as col_0_13, col_0 as col_0_14, col_0 as col_0_15, col_0 as col_0_16, col_0 as col_0_17, col_0 as col_0_18, col_0 as col_0_19, col_0 as col_0_20, col_0 as col_0_21 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 as col_1_1, col_1 as col_1_2, col_1 as col_1_3, col_1 as col_1_4, col_1 as col_1_5, col_1 as col_1_6, col_1 as col_1_7, col_1 as col_1_8, col_1 as col_1_9, col_1 as col_1_10, col_1 as col_1_11, col_1 as col_1_12, col_1 as col_1_13, col_1 as col_1_14, col_1 as col_1_15, col_1 as col_1_16, col_1 as col_1_17, col_1 as col_1_18, col_1 as col_1_19, col_1 as col_1_20, col_1 as col_1_21 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 as col_2_1, col_2 as col_2_2, col_2 as col_2_3, col_2 as col_2_4, col_2 as col_2_5, col_2 as col_2_6, col_2 as col_2_7, col_2 as col_2_8, col_2 as col_2_9, col_2 as col_2_10, col_2 as col_2_11, col_2 as col_2_12, col_2 as col_2_13, col_2 as col_2_14, col_2 as col_2_15, col_2 as col_2_16, col_2 as col_2_17, col_2 as col_2_18, col_2 as col_2_19, col_2 as col_2_20, col_2 as col_2_21 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

[... 2129 lines stripped ...]


Mime
View raw message