Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 27529 invoked from network); 21 Nov 2006 06:28:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Nov 2006 06:28:37 -0000 Received: (qmail 64013 invoked by uid 500); 21 Nov 2006 06:28:47 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 63953 invoked by uid 500); 21 Nov 2006 06:28:47 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 63942 invoked by uid 99); 21 Nov 2006 06:28:47 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Nov 2006 22:28:47 -0800 X-ASF-Spam-Status: No, hits=-9.4 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO eris.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Nov 2006 22:28:32 -0800 Received: by eris.apache.org (Postfix, from userid 65534) id AF9E91A9859; Mon, 20 Nov 2006 22:27:35 -0800 (PST) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r477526 [6/9] - in /db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet: ./ ibm15/ ibm15/ver2.8/ ver2.8/ Date: Tue, 21 Nov 2006 06:27:33 -0000 To: derby-commits@db.apache.org From: myrnavl@apache.org X-Mailer: svnmailer-1.1.0 Message-Id: <20061121062735.AF9E91A9859@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Added: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/LOBTest.out URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/LOBTest.out?view=auto&rev=477526 ============================================================================== --- db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/LOBTest.out (added) +++ db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/LOBTest.out Mon Nov 20 22:27:32 2006 @@ -0,0 +1,3873 @@ +create table bit_table ( dummy int , col_0 int, col_1 char(10), col_2 varchar(80), col_3 long varchar, col_4 char(10) for bit data, col_5 long varchar for bit data, col_6 blob(80), typecol char (8 ) for bit data ) +insert into bit_table values ( 45 ,100,'101','102','103',X'003100300034',X'003100300035',CAST (X'003100300036' AS blob(80)),CAST (X'003100300037' AS char (8 ) for bit data) ) +insert into bit_table ( col_0 ) values ( 'true' ) + 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 ->Object' : byte[] + 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 ->Object' : byte[] + 2 getCharacterStream ->Object' : java.io.Reader + 2 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 2 getDate -> EXCEPTION (String index out of range: 3) + 2 getDouble ->'102.0' : java.lang.Double + 2 getFloat ->'102.0' : java.lang.Float + 2 getInt ->'102' : java.lang.Integer + 2 getLong ->'102' : java.lang.Long + 2 getRef -> EXCEPTION (not yet implemented) + 2 getShort ->'102' : java.lang.Short + 2 getString ->'102' : java.lang.String + 2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.) + 2 getTimeStamp -> EXCEPTION (String index out of range: 3) +=== Columntype long varchar +select col_3 from bit_table + 3 getObject ->'103' : java.lang.String + 3 getArray -> EXCEPTION (not yet implemented) + 3 getAsciiStream ->Object' : java.io.InputStream + 3 getBigDecimal ->'103' : java.math.BigDecimal + 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getBoolean ->'true' : java.lang.Boolean + 3 getByte ->'103' : java.lang.Byte + 3 getBytes ->Object' : byte[] + 3 getCharacterStream ->Object' : java.io.Reader + 3 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getDate -> EXCEPTION (String index out of range: 3) + 3 getDouble ->'103.0' : java.lang.Double + 3 getFloat ->'103.0' : java.lang.Float + 3 getInt ->'103' : java.lang.Integer + 3 getLong ->'103' : java.lang.Long + 3 getRef -> EXCEPTION (not yet implemented) + 3 getShort ->'103' : java.lang.Short + 3 getString ->'103' : java.lang.String + 3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.) + 3 getTimeStamp -> EXCEPTION (String index out of range: 3) +=== Columntype char(10) for bit data +select col_4 from bit_table + 4 getObject ->Object' : byte[] + 4 getArray -> EXCEPTION (not yet implemented) + 4 getAsciiStream ->Object' : java.io.InputStream + 4 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBinaryStream ->Object' : java.io.InputStream + 4 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBytes ->Object' : byte[] + 4 getCharacterStream ->Object' : java.io.Reader + 4 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getRef -> EXCEPTION (not yet implemented) + 4 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getString ->'00310030003420202020' : java.lang.String + 4 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype long varchar for bit data +select col_5 from bit_table + 5 getObject ->Object' : byte[] + 5 getArray -> EXCEPTION (not yet implemented) + 5 getAsciiStream ->Object' : java.io.InputStream + 5 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBinaryStream ->Object' : java.io.InputStream + 5 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBytes ->Object' : byte[] + 5 getCharacterStream ->Object' : java.io.Reader + 5 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getRef -> EXCEPTION (not yet implemented) + 5 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getString ->'003100300035' : java.lang.String + 5 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype blob(80) +select col_6 from bit_table + 6 getObject ->Object' : java.sql.Blob + 6 getArray -> EXCEPTION (not yet implemented) + 6 getAsciiStream ->Object' : java.io.InputStream + 6 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getBinaryStream ->Object' : java.io.InputStream + 6 getBlob ->Object' : java.sql.Blob + 6 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getBytes ->Object' : byte[] + 6 getCharacterStream ->Object' : java.io.Reader + 6 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getRef -> EXCEPTION (not yet implemented) + 6 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getString ->'003100300036' : java.lang.String + 6 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype char (8 ) for bit data +select typecol from bit_table + 7 getObject ->Object' : byte[] + 7 getArray -> EXCEPTION (not yet implemented) + 7 getAsciiStream ->Object' : java.io.InputStream + 7 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getBinaryStream ->Object' : java.io.InputStream + 7 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getBytes ->Object' : byte[] + 7 getCharacterStream ->Object' : java.io.Reader + 7 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getRef -> EXCEPTION (not yet implemented) + 7 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getString ->'0031003000372020' : java.lang.String + 7 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +-----< METADATA TESTS +select col_0 from bit_table + ---- 1 + Column : COL_0 + Type : 4 + TypeName : INTEGER + ClassName : java.lang.Integer + Label : COL_0 + DisplaySz : 11 + Precision : 10 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '100' : java.lang.Integer + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_1 from bit_table + ---- 1 + Column : COL_1 + Type : 1 + TypeName : CHAR + ClassName : java.lang.String + Label : COL_1 + DisplaySz : 10 + Precision : 10 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '101 ' : java.lang.String + OUT = 'true ' : java.lang.String + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_2 from bit_table + ---- 1 + Column : COL_2 + Type : 12 + TypeName : VARCHAR + ClassName : java.lang.String + Label : COL_2 + DisplaySz : 80 + Precision : 80 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '102' : java.lang.String + OUT = NULL + OUT = 'true' : java.lang.String + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_3 from bit_table + ---- 1 + Column : COL_3 + Type : -1 + TypeName : LONG VARCHAR + ClassName : java.lang.String + Label : COL_3 + DisplaySz : 32700 + Precision : 32700 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '103' : java.lang.String + OUT = NULL + OUT = NULL + OUT = 'true' : java.lang.String + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_4 from bit_table + ---- 1 + Column : COL_4 + Type : -2 + TypeName : CHAR FOR BIT DATA + ClassName : byte[] + Label : COL_4 + DisplaySz : 20 + Precision : 10 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : byte[] + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : byte[] + OUT = NULL + OUT = NULL + OUT = NULL +select col_5 from bit_table + ---- 1 + Column : COL_5 + Type : -4 + TypeName : LONG VARCHAR FOR BIT DATA + ClassName : byte[] + Label : COL_5 + DisplaySz : 65400 + Precision : 32700 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : byte[] + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : byte[] + OUT = NULL + OUT = NULL +select col_6 from bit_table + ---- 1 + Column : COL_6 + Type : 2004 + TypeName : BLOB + ClassName : java.sql.Blob + Label : COL_6 + DisplaySz : 160 + Precision : 80 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : java.sql.Blob + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : java.sql.Blob + OUT = NULL +select typecol from bit_table + ---- 1 + Column : TYPECOL + Type : -2 + TypeName : CHAR FOR BIT DATA + ClassName : byte[] + Label : TYPECOL + DisplaySz : 16 + Precision : 8 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : byte[] + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : byte[] +-----< columns CAST TO type: METADATA TESTS +select cast( col_0 as char (8) for bit data ) from bit_table + 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 ->Object' : byte[] + 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 ->Object' : byte[] + 2 getCharacterStream ->Object' : java.io.Reader + 2 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 2 getDate -> EXCEPTION (String index out of range: 3) + 2 getDouble ->'102.0' : java.lang.Double + 2 getFloat ->'102.0' : java.lang.Float + 2 getInt ->'102' : java.lang.Integer + 2 getLong ->'102' : java.lang.Long + 2 getRef -> EXCEPTION (not yet implemented) + 2 getShort ->'102' : java.lang.Short + 2 getString ->'102' : java.lang.String + 2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.) + 2 getTimeStamp -> EXCEPTION (String index out of range: 3) +=== Columntype long varchar +select col_3 from bit_table + 3 getObject ->'103' : java.lang.String + 3 getArray -> EXCEPTION (not yet implemented) + 3 getAsciiStream ->Object' : java.io.InputStream + 3 getBigDecimal ->'103' : java.math.BigDecimal + 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getBoolean ->'true' : java.lang.Boolean + 3 getByte ->'103' : java.lang.Byte + 3 getBytes ->Object' : byte[] + 3 getCharacterStream ->Object' : java.io.Reader + 3 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getDate -> EXCEPTION (String index out of range: 3) + 3 getDouble ->'103.0' : java.lang.Double + 3 getFloat ->'103.0' : java.lang.Float + 3 getInt ->'103' : java.lang.Integer + 3 getLong ->'103' : java.lang.Long + 3 getRef -> EXCEPTION (not yet implemented) + 3 getShort ->'103' : java.lang.Short + 3 getString ->'103' : java.lang.String + 3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.) + 3 getTimeStamp -> EXCEPTION (String index out of range: 3) +=== Columntype char(10) for bit data +select col_4 from bit_table + 4 getObject ->Object' : byte[] + 4 getArray -> EXCEPTION (not yet implemented) + 4 getAsciiStream ->Object' : java.io.InputStream + 4 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBinaryStream ->Object' : java.io.InputStream + 4 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBytes ->Object' : byte[] + 4 getCharacterStream ->Object' : java.io.Reader + 4 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getRef -> EXCEPTION (not yet implemented) + 4 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getString ->'00310030003420202020' : java.lang.String + 4 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype long varchar for bit data +select col_5 from bit_table + 5 getObject ->Object' : byte[] + 5 getArray -> EXCEPTION (not yet implemented) + 5 getAsciiStream ->Object' : java.io.InputStream + 5 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBinaryStream ->Object' : java.io.InputStream + 5 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBytes ->Object' : byte[] + 5 getCharacterStream ->Object' : java.io.Reader + 5 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getRef -> EXCEPTION (not yet implemented) + 5 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getString ->'003100300035' : java.lang.String + 5 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype blob(80) +select col_6 from bit_table + 6 getObject ->Object' : java.sql.Blob + 6 getArray -> EXCEPTION (not yet implemented) + 6 getAsciiStream ->Object' : java.io.InputStream + 6 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getBinaryStream ->Object' : java.io.InputStream + 6 getBlob ->Object' : java.sql.Blob + 6 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getBytes ->Object' : byte[] + 6 getCharacterStream ->Object' : java.io.Reader + 6 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getRef -> EXCEPTION (not yet implemented) + 6 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getString ->'003100300036' : java.lang.String + 6 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype char (8 ) for bit data +select typecol from bit_table + 7 getObject ->Object' : byte[] + 7 getArray -> EXCEPTION (not yet implemented) + 7 getAsciiStream ->Object' : java.io.InputStream + 7 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getBinaryStream ->Object' : java.io.InputStream + 7 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getBytes ->Object' : byte[] + 7 getCharacterStream ->Object' : java.io.Reader + 7 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getRef -> EXCEPTION (not yet implemented) + 7 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getString ->'0031003000372020' : java.lang.String + 7 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +-----< METADATA TESTS +select col_0 from bit_table + ---- 1 + Column : COL_0 + Type : 4 + TypeName : INTEGER + ClassName : java.lang.Integer + Label : COL_0 + DisplaySz : 11 + Precision : 10 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '100' : java.lang.Integer + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_1 from bit_table + ---- 1 + Column : COL_1 + Type : 1 + TypeName : CHAR + ClassName : java.lang.String + Label : COL_1 + DisplaySz : 10 + Precision : 10 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '101 ' : java.lang.String + OUT = 'true ' : java.lang.String + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_2 from bit_table + ---- 1 + Column : COL_2 + Type : 12 + TypeName : VARCHAR + ClassName : java.lang.String + Label : COL_2 + DisplaySz : 80 + Precision : 80 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '102' : java.lang.String + OUT = NULL + OUT = 'true' : java.lang.String + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_3 from bit_table + ---- 1 + Column : COL_3 + Type : -1 + TypeName : LONG VARCHAR + ClassName : java.lang.String + Label : COL_3 + DisplaySz : 32700 + Precision : 32700 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '103' : java.lang.String + OUT = NULL + OUT = NULL + OUT = 'true' : java.lang.String + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_4 from bit_table + ---- 1 + Column : COL_4 + Type : -2 + TypeName : CHAR FOR BIT DATA + ClassName : byte[] + Label : COL_4 + DisplaySz : 20 + Precision : 10 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : byte[] + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : byte[] + OUT = NULL + OUT = NULL + OUT = NULL +select col_5 from bit_table + ---- 1 + Column : COL_5 + Type : -4 + TypeName : LONG VARCHAR FOR BIT DATA + ClassName : byte[] + Label : COL_5 + DisplaySz : 65400 + Precision : 32700 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : byte[] + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : byte[] + OUT = NULL + OUT = NULL +select col_6 from bit_table + ---- 1 + Column : COL_6 + Type : 2004 + TypeName : BLOB + ClassName : java.sql.Blob + Label : COL_6 + DisplaySz : 160 + Precision : 80 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : java.sql.Blob + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : java.sql.Blob + OUT = NULL +select typecol from bit_table + ---- 1 + Column : TYPECOL + Type : -2 + TypeName : CHAR FOR BIT DATA + ClassName : byte[] + Label : TYPECOL + DisplaySz : 16 + Precision : 8 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : byte[] + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : byte[] +-----< columns CAST TO type: METADATA TESTS +select cast( col_0 as char (8) for bit data ) from bit_table + 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 ->Object' : byte[] + 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 ->Object' : byte[] + 2 getCharacterStream ->Object' : java.io.Reader + 2 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 2 getDate -> EXCEPTION (String index out of range: 3) + 2 getDouble ->'102.0' : java.lang.Double + 2 getFloat ->'102.0' : java.lang.Float + 2 getInt ->'102' : java.lang.Integer + 2 getLong ->'102' : java.lang.Long + 2 getRef -> EXCEPTION (not yet implemented) + 2 getShort ->'102' : java.lang.Short + 2 getString ->'102' : java.lang.String + 2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.) + 2 getTimeStamp -> EXCEPTION (String index out of range: 3) +=== Columntype long varchar +select col_3 from blob_table + 3 getObject ->'103' : java.lang.String + 3 getArray -> EXCEPTION (not yet implemented) + 3 getAsciiStream ->Object' : java.io.InputStream + 3 getBigDecimal ->'103' : java.math.BigDecimal + 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getBoolean ->'true' : java.lang.Boolean + 3 getByte ->'103' : java.lang.Byte + 3 getBytes ->Object' : byte[] + 3 getCharacterStream ->Object' : java.io.Reader + 3 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getDate -> EXCEPTION (String index out of range: 3) + 3 getDouble ->'103.0' : java.lang.Double + 3 getFloat ->'103.0' : java.lang.Float + 3 getInt ->'103' : java.lang.Integer + 3 getLong ->'103' : java.lang.Long + 3 getRef -> EXCEPTION (not yet implemented) + 3 getShort ->'103' : java.lang.Short + 3 getString ->'103' : java.lang.String + 3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.) + 3 getTimeStamp -> EXCEPTION (String index out of range: 3) +=== Columntype char(10) for bit data +select col_4 from blob_table + 4 getObject ->Object' : byte[] + 4 getArray -> EXCEPTION (not yet implemented) + 4 getAsciiStream ->Object' : java.io.InputStream + 4 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBinaryStream ->Object' : java.io.InputStream + 4 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBytes ->Object' : byte[] + 4 getCharacterStream ->Object' : java.io.Reader + 4 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getRef -> EXCEPTION (not yet implemented) + 4 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getString ->'00310030003420202020' : java.lang.String + 4 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype long varchar for bit data +select col_5 from blob_table + 5 getObject ->Object' : byte[] + 5 getArray -> EXCEPTION (not yet implemented) + 5 getAsciiStream ->Object' : java.io.InputStream + 5 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBinaryStream ->Object' : java.io.InputStream + 5 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBytes ->Object' : byte[] + 5 getCharacterStream ->Object' : java.io.Reader + 5 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getRef -> EXCEPTION (not yet implemented) + 5 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getString ->'003100300035' : java.lang.String + 5 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype blob(80) +select col_6 from blob_table + 6 getObject ->Object' : java.sql.Blob + 6 getArray -> EXCEPTION (not yet implemented) + 6 getAsciiStream ->Object' : java.io.InputStream + 6 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getBinaryStream ->Object' : java.io.InputStream + 6 getBlob ->Object' : java.sql.Blob + 6 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getBytes ->Object' : byte[] + 6 getCharacterStream ->Object' : java.io.Reader + 6 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getRef -> EXCEPTION (not yet implemented) + 6 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getString ->'003100300036' : java.lang.String + 6 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype blob (2 M) +select typecol from blob_table + 7 getObject ->Object' : java.sql.Blob + 7 getArray -> EXCEPTION (not yet implemented) + 7 getAsciiStream ->Object' : java.io.InputStream + 7 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getBinaryStream ->Object' : java.io.InputStream + 7 getBlob ->Object' : java.sql.Blob + 7 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getBytes ->Object' : byte[] + 7 getCharacterStream ->Object' : java.io.Reader + 7 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getRef -> EXCEPTION (not yet implemented) + 7 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getString ->'003100300037' : java.lang.String + 7 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +-----< METADATA TESTS +select col_0 from blob_table + ---- 1 + Column : COL_0 + Type : 4 + TypeName : INTEGER + ClassName : java.lang.Integer + Label : COL_0 + DisplaySz : 11 + Precision : 10 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '100' : java.lang.Integer + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_1 from blob_table + ---- 1 + Column : COL_1 + Type : 1 + TypeName : CHAR + ClassName : java.lang.String + Label : COL_1 + DisplaySz : 10 + Precision : 10 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '101 ' : java.lang.String + OUT = 'true ' : java.lang.String + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_2 from blob_table + ---- 1 + Column : COL_2 + Type : 12 + TypeName : VARCHAR + ClassName : java.lang.String + Label : COL_2 + DisplaySz : 80 + Precision : 80 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '102' : java.lang.String + OUT = NULL + OUT = 'true' : java.lang.String + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_3 from blob_table + ---- 1 + Column : COL_3 + Type : -1 + TypeName : LONG VARCHAR + ClassName : java.lang.String + Label : COL_3 + DisplaySz : 32700 + Precision : 32700 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '103' : java.lang.String + OUT = NULL + OUT = NULL + OUT = 'true' : java.lang.String + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_4 from blob_table + ---- 1 + Column : COL_4 + Type : -2 + TypeName : CHAR FOR BIT DATA + ClassName : byte[] + Label : COL_4 + DisplaySz : 20 + Precision : 10 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : byte[] + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : byte[] + OUT = NULL + OUT = NULL + OUT = NULL +select col_5 from blob_table + ---- 1 + Column : COL_5 + Type : -4 + TypeName : LONG VARCHAR FOR BIT DATA + ClassName : byte[] + Label : COL_5 + DisplaySz : 65400 + Precision : 32700 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : byte[] + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : byte[] + OUT = NULL + OUT = NULL +select col_6 from blob_table + ---- 1 + Column : COL_6 + Type : 2004 + TypeName : BLOB + ClassName : java.sql.Blob + Label : COL_6 + DisplaySz : 160 + Precision : 80 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : java.sql.Blob + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : java.sql.Blob + OUT = NULL +select typecol from blob_table + ---- 1 + Column : TYPECOL + Type : 2004 + TypeName : BLOB + ClassName : java.sql.Blob + Label : TYPECOL + DisplaySz : 4194304 + Precision : 2097152 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = Object : java.sql.Blob + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = Object : java.sql.Blob +-----< columns CAST TO type: METADATA TESTS +select cast( col_0 as blob(2 M) ) from blob_table + 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 ->Object' : byte[] + 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 ->Object' : byte[] + 2 getCharacterStream ->Object' : java.io.Reader + 2 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 2 getDate -> EXCEPTION (String index out of range: 3) + 2 getDouble ->'102.0' : java.lang.Double + 2 getFloat ->'102.0' : java.lang.Float + 2 getInt ->'102' : java.lang.Integer + 2 getLong ->'102' : java.lang.Long + 2 getRef -> EXCEPTION (not yet implemented) + 2 getShort ->'102' : java.lang.Short + 2 getString ->'102' : java.lang.String + 2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.) + 2 getTimeStamp -> EXCEPTION (String index out of range: 3) +=== Columntype long varchar +select col_3 from blob_table + 3 getObject ->'103' : java.lang.String + 3 getArray -> EXCEPTION (not yet implemented) + 3 getAsciiStream ->Object' : java.io.InputStream + 3 getBigDecimal ->'103' : java.math.BigDecimal + 3 getBinaryStream -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getBoolean ->'true' : java.lang.Boolean + 3 getByte ->'103' : java.lang.Byte + 3 getBytes ->Object' : byte[] + 3 getCharacterStream ->Object' : java.io.Reader + 3 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 3 getDate -> EXCEPTION (String index out of range: 3) + 3 getDouble ->'103.0' : java.lang.Double + 3 getFloat ->'103.0' : java.lang.Float + 3 getInt ->'103' : java.lang.Integer + 3 getLong ->'103' : java.lang.Long + 3 getRef -> EXCEPTION (not yet implemented) + 3 getShort ->'103' : java.lang.Short + 3 getString ->'103' : java.lang.String + 3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.) + 3 getTimeStamp -> EXCEPTION (String index out of range: 3) +=== Columntype char(10) for bit data +select col_4 from blob_table + 4 getObject ->Object' : byte[] + 4 getArray -> EXCEPTION (not yet implemented) + 4 getAsciiStream ->Object' : java.io.InputStream + 4 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBinaryStream ->Object' : java.io.InputStream + 4 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getBytes ->Object' : byte[] + 4 getCharacterStream ->Object' : java.io.Reader + 4 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getRef -> EXCEPTION (not yet implemented) + 4 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getString ->'00310030003420202020' : java.lang.String + 4 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 4 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype long varchar for bit data +select col_5 from blob_table + 5 getObject ->Object' : byte[] + 5 getArray -> EXCEPTION (not yet implemented) + 5 getAsciiStream ->Object' : java.io.InputStream + 5 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBinaryStream ->Object' : java.io.InputStream + 5 getBlob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getBytes ->Object' : byte[] + 5 getCharacterStream ->Object' : java.io.Reader + 5 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getRef -> EXCEPTION (not yet implemented) + 5 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getString ->'003100300035' : java.lang.String + 5 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 5 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype blob(80) +select col_6 from blob_table + 6 getObject ->Object' : java.sql.Blob + 6 getArray -> EXCEPTION (not yet implemented) + 6 getAsciiStream ->Object' : java.io.InputStream + 6 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getBinaryStream ->Object' : java.io.InputStream + 6 getBlob ->Object' : java.sql.Blob + 6 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getBytes ->Object' : byte[] + 6 getCharacterStream ->Object' : java.io.Reader + 6 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getRef -> EXCEPTION (not yet implemented) + 6 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getString ->'003100300036' : java.lang.String + 6 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 6 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +=== Columntype blob (2 K) +select typecol from blob_table + 7 getObject ->Object' : java.sql.Blob + 7 getArray -> EXCEPTION (not yet implemented) + 7 getAsciiStream ->Object' : java.io.InputStream + 7 getBigDecimal -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getBinaryStream ->Object' : java.io.InputStream + 7 getBlob ->Object' : java.sql.Blob + 7 getBoolean -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getByte -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getBytes ->Object' : byte[] + 7 getCharacterStream ->Object' : java.io.Reader + 7 getClob -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getDate -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getDouble -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getFloat -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getInt -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getLong -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getRef -> EXCEPTION (not yet implemented) + 7 getShort -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getString ->'003100300037' : java.lang.String + 7 getTime -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) + 7 getTimeStamp -> EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.) +-----< METADATA TESTS +select col_0 from blob_table + ---- 1 + Column : COL_0 + Type : 4 + TypeName : INTEGER + ClassName : java.lang.Integer + Label : COL_0 + DisplaySz : 11 + Precision : 10 + Scale : 0 + isCurrency: false + isCaseSens: false + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '100' : java.lang.Integer + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_1 from blob_table + ---- 1 + Column : COL_1 + Type : 1 + TypeName : CHAR + ClassName : java.lang.String + Label : COL_1 + DisplaySz : 10 + Precision : 10 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '101 ' : java.lang.String + OUT = 'true ' : java.lang.String + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_2 from blob_table + ---- 1 + Column : COL_2 + Type : 12 + TypeName : VARCHAR + ClassName : java.lang.String + Label : COL_2 + DisplaySz : 80 + Precision : 80 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + isWrite : false + isSearchab: true + OUT = '102' : java.lang.String + OUT = NULL + OUT = 'true' : java.lang.String + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL + OUT = NULL +select col_3 from blob_table + ---- 1 + Column : COL_3 + Type : -1 + TypeName : LONG VARCHAR + ClassName : java.lang.String + Label : COL_3 + DisplaySz : 32700 + Precision : 32700 + Scale : 0 + isCurrency: false + isCaseSens: true + isDefWrite: false + 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 [... 1856 lines stripped ...]