You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by my...@apache.org on 2006/11/21 07:27:33 UTC
svn commit: r477526 [1/9] - in
/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet:
./ ibm15/ ibm15/ver2.8/ ver2.8/
Author: myrnavl
Date: Mon Nov 20 22:27:32 2006
New Revision: 477526
URL: http://svn.apache.org/viewvc?view=rev&rev=477526
Log:
DERBY-2059 - LOBTest, parameterMapping, and resultset fail with jcc 2.8.
- added additional masters.
- also fixed up mistakenly modified DerbyNet/LobTest.out
Added:
db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/ver2.8/
db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/ver2.8/LOBTest.out (with props)
db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/ver2.8/parameterMapping.out (with props)
db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/
db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/LOBTest.out (with props)
db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/parameterMapping.out (with props)
db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ver2.8/resultset.out (with props)
Modified:
db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/LOBTest.out
Modified: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out?view=diff&rev=477526&r1=477525&r2=477526
==============================================================================
--- db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out (original)
+++ db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/LOBTest.out Mon Nov 20 22:27:32 2006
@@ -68,7 +68,7 @@
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 (null)
+ 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
@@ -77,7 +77,7 @@
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 (null)
+ 2 getTimeStamp -> EXCEPTION (String index out of range: 3)
=== Columntype long varchar
select col_3 from bit_table
3 getObject ->'103' : java.lang.String
@@ -91,7 +91,7 @@
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 (null)
+ 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
@@ -100,7 +100,7 @@
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 (null)
+ 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[]
@@ -630,7 +630,7 @@
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 (null)
+ 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
@@ -639,7 +639,7 @@
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 (null)
+ 2 getTimeStamp -> EXCEPTION (String index out of range: 3)
=== Columntype long varchar
select col_3 from bit_table
3 getObject ->'103' : java.lang.String
@@ -653,7 +653,7 @@
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 (null)
+ 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
@@ -662,7 +662,7 @@
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 (null)
+ 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[]
@@ -1192,7 +1192,7 @@
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 (null)
+ 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
@@ -1201,7 +1201,7 @@
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 (null)
+ 2 getTimeStamp -> EXCEPTION (String index out of range: 3)
=== Columntype long varchar
select col_3 from blob_table
3 getObject ->'103' : java.lang.String
@@ -1215,7 +1215,7 @@
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 (null)
+ 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
@@ -1224,7 +1224,7 @@
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 (null)
+ 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[]
@@ -1733,7 +1733,7 @@
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 (null)
+ 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
@@ -1742,7 +1742,7 @@
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 (null)
+ 2 getTimeStamp -> EXCEPTION (String index out of range: 3)
=== Columntype long varchar
select col_3 from blob_table
3 getObject ->'103' : java.lang.String
@@ -1756,7 +1756,7 @@
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 (null)
+ 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
@@ -1765,7 +1765,7 @@
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 (null)
+ 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[]
@@ -2274,7 +2274,7 @@
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 (null)
+ 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
@@ -2283,7 +2283,7 @@
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 (null)
+ 2 getTimeStamp -> EXCEPTION (String index out of range: 3)
=== Columntype long varchar
select col_3 from blob_table
3 getObject ->'103' : java.lang.String
@@ -2297,7 +2297,7 @@
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 (null)
+ 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
@@ -2306,7 +2306,7 @@
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 (null)
+ 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[]
Modified: db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/LOBTest.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/LOBTest.out?view=diff&rev=477526&r1=477525&r2=477526
==============================================================================
--- db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/LOBTest.out (original)
+++ db/derby/code/branches/10.1/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ibm15/LOBTest.out Mon Nov 20 22:27:32 2006
@@ -10,7 +10,7 @@
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
+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.)
@@ -33,7 +33,7 @@
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
+select col_1 from bit_table
1 getObject ->'101 ' : java.lang.String
1 getArray -> EXCEPTION (not yet implemented)
1 getAsciiStream ->Object' : java.io.InputStream
@@ -56,7 +56,7 @@
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
+select col_2 from bit_table
2 getObject ->'102' : java.lang.String
2 getArray -> EXCEPTION (not yet implemented)
2 getAsciiStream ->Object' : java.io.InputStream
@@ -79,7 +79,7 @@
2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
2 getTimeStamp -> EXCEPTION (null)
=== 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
+select col_3 from bit_table
3 getObject ->'103' : java.lang.String
3 getArray -> EXCEPTION (not yet implemented)
3 getAsciiStream ->Object' : java.io.InputStream
@@ -102,7 +102,7 @@
3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
3 getTimeStamp -> EXCEPTION (null)
=== 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
+select col_4 from bit_table
4 getObject ->Object' : byte[]
4 getArray -> EXCEPTION (not yet implemented)
4 getAsciiStream ->Object' : java.io.InputStream
@@ -125,7 +125,7 @@
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
+select col_5 from bit_table
5 getObject ->Object' : byte[]
5 getArray -> EXCEPTION (not yet implemented)
5 getAsciiStream ->Object' : java.io.InputStream
@@ -148,7 +148,7 @@
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
+select col_6 from bit_table
6 getObject ->Object' : java.sql.Blob
6 getArray -> EXCEPTION (not yet implemented)
6 getAsciiStream ->Object' : java.io.InputStream
@@ -171,7 +171,7 @@
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
+select typecol from bit_table
7 getObject ->Object' : byte[]
7 getArray -> EXCEPTION (not yet implemented)
7 getAsciiStream ->Object' : java.io.InputStream
@@ -572,7 +572,7 @@
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
+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.)
@@ -595,7 +595,7 @@
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
+select col_1 from bit_table
1 getObject ->'101 ' : java.lang.String
1 getArray -> EXCEPTION (not yet implemented)
1 getAsciiStream ->Object' : java.io.InputStream
@@ -618,7 +618,7 @@
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
+select col_2 from bit_table
2 getObject ->'102' : java.lang.String
2 getArray -> EXCEPTION (not yet implemented)
2 getAsciiStream ->Object' : java.io.InputStream
@@ -641,7 +641,7 @@
2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
2 getTimeStamp -> EXCEPTION (null)
=== 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
+select col_3 from bit_table
3 getObject ->'103' : java.lang.String
3 getArray -> EXCEPTION (not yet implemented)
3 getAsciiStream ->Object' : java.io.InputStream
@@ -664,7 +664,7 @@
3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
3 getTimeStamp -> EXCEPTION (null)
=== 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
+select col_4 from bit_table
4 getObject ->Object' : byte[]
4 getArray -> EXCEPTION (not yet implemented)
4 getAsciiStream ->Object' : java.io.InputStream
@@ -687,7 +687,7 @@
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
+select col_5 from bit_table
5 getObject ->Object' : byte[]
5 getArray -> EXCEPTION (not yet implemented)
5 getAsciiStream ->Object' : java.io.InputStream
@@ -710,7 +710,7 @@
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
+select col_6 from bit_table
6 getObject ->Object' : java.sql.Blob
6 getArray -> EXCEPTION (not yet implemented)
6 getAsciiStream ->Object' : java.io.InputStream
@@ -733,7 +733,7 @@
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
+select typecol from bit_table
7 getObject ->Object' : byte[]
7 getArray -> EXCEPTION (not yet implemented)
7 getAsciiStream ->Object' : java.io.InputStream
@@ -1134,7 +1134,7 @@
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
+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.)
@@ -1157,7 +1157,7 @@
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
+select col_1 from blob_table
1 getObject ->'101 ' : java.lang.String
1 getArray -> EXCEPTION (not yet implemented)
1 getAsciiStream ->Object' : java.io.InputStream
@@ -1180,7 +1180,7 @@
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
+select col_2 from blob_table
2 getObject ->'102' : java.lang.String
2 getArray -> EXCEPTION (not yet implemented)
2 getAsciiStream ->Object' : java.io.InputStream
@@ -1203,7 +1203,7 @@
2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
2 getTimeStamp -> EXCEPTION (null)
=== 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
+select col_3 from blob_table
3 getObject ->'103' : java.lang.String
3 getArray -> EXCEPTION (not yet implemented)
3 getAsciiStream ->Object' : java.io.InputStream
@@ -1226,7 +1226,7 @@
3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
3 getTimeStamp -> EXCEPTION (null)
=== 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
+select col_4 from blob_table
4 getObject ->Object' : byte[]
4 getArray -> EXCEPTION (not yet implemented)
4 getAsciiStream ->Object' : java.io.InputStream
@@ -1249,7 +1249,7 @@
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
+select col_5 from blob_table
5 getObject ->Object' : byte[]
5 getArray -> EXCEPTION (not yet implemented)
5 getAsciiStream ->Object' : java.io.InputStream
@@ -1272,7 +1272,7 @@
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
+select col_6 from blob_table
6 getObject ->Object' : java.sql.Blob
6 getArray -> EXCEPTION (not yet implemented)
6 getAsciiStream ->Object' : java.io.InputStream
@@ -1295,7 +1295,7 @@
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
+select typecol from blob_table
7 getObject ->Object' : java.sql.Blob
7 getArray -> EXCEPTION (not yet implemented)
7 getAsciiStream ->Object' : java.io.InputStream
@@ -1675,7 +1675,7 @@
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
+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.)
@@ -1698,7 +1698,7 @@
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
+select col_1 from blob_table
1 getObject ->'101 ' : java.lang.String
1 getArray -> EXCEPTION (not yet implemented)
1 getAsciiStream ->Object' : java.io.InputStream
@@ -1721,7 +1721,7 @@
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
+select col_2 from blob_table
2 getObject ->'102' : java.lang.String
2 getArray -> EXCEPTION (not yet implemented)
2 getAsciiStream ->Object' : java.io.InputStream
@@ -1744,7 +1744,7 @@
2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
2 getTimeStamp -> EXCEPTION (null)
=== 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
+select col_3 from blob_table
3 getObject ->'103' : java.lang.String
3 getArray -> EXCEPTION (not yet implemented)
3 getAsciiStream ->Object' : java.io.InputStream
@@ -1767,7 +1767,7 @@
3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
3 getTimeStamp -> EXCEPTION (null)
=== 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
+select col_4 from blob_table
4 getObject ->Object' : byte[]
4 getArray -> EXCEPTION (not yet implemented)
4 getAsciiStream ->Object' : java.io.InputStream
@@ -1790,7 +1790,7 @@
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
+select col_5 from blob_table
5 getObject ->Object' : byte[]
5 getArray -> EXCEPTION (not yet implemented)
5 getAsciiStream ->Object' : java.io.InputStream
@@ -1813,7 +1813,7 @@
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
+select col_6 from blob_table
6 getObject ->Object' : java.sql.Blob
6 getArray -> EXCEPTION (not yet implemented)
6 getAsciiStream ->Object' : java.io.InputStream
@@ -1836,7 +1836,7 @@
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 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
+select typecol from blob_table
7 getObject ->Object' : java.sql.Blob
7 getArray -> EXCEPTION (not yet implemented)
7 getAsciiStream ->Object' : java.io.InputStream
@@ -2216,7 +2216,7 @@
insert into blob_table ( col_6 ) values cast ( X'0074007200750065' AS blob(80))
insert into blob_table ( typecol ) values cast ( X'0074007200750065' AS blob (64 ))
=== 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
+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.)
@@ -2239,7 +2239,7 @@
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
+select col_1 from blob_table
1 getObject ->'101 ' : java.lang.String
1 getArray -> EXCEPTION (not yet implemented)
1 getAsciiStream ->Object' : java.io.InputStream
@@ -2262,7 +2262,7 @@
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
+select col_2 from blob_table
2 getObject ->'102' : java.lang.String
2 getArray -> EXCEPTION (not yet implemented)
2 getAsciiStream ->Object' : java.io.InputStream
@@ -2285,7 +2285,7 @@
2 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Time.)
2 getTimeStamp -> EXCEPTION (null)
=== 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
+select col_3 from blob_table
3 getObject ->'103' : java.lang.String
3 getArray -> EXCEPTION (not yet implemented)
3 getAsciiStream ->Object' : java.io.InputStream
@@ -2308,7 +2308,7 @@
3 getTime -> EXCEPTION (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Time.)
3 getTimeStamp -> EXCEPTION (null)
=== 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
+select col_4 from blob_table
4 getObject ->Object' : byte[]
4 getArray -> EXCEPTION (not yet implemented)
4 getAsciiStream ->Object' : java.io.InputStream
@@ -2331,7 +2331,7 @@
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
+select col_5 from blob_table
5 getObject ->Object' : byte[]
5 getArray -> EXCEPTION (not yet implemented)
5 getAsciiStream ->Object' : java.io.InputStream
@@ -2354,7 +2354,7 @@
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
+select col_6 from blob_table
6 getObject ->Object' : java.sql.Blob
6 getArray -> EXCEPTION (not yet implemented)
6 getAsciiStream ->Object' : java.io.InputStream
@@ -2377,7 +2377,7 @@
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 (64 )
-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
+select typecol from blob_table
7 getObject ->Object' : java.sql.Blob
7 getArray -> EXCEPTION (not yet implemented)
7 getAsciiStream ->Object' : java.io.InputStream
@@ -2759,7 +2759,7 @@
insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS clob (2 K))
ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
=== 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 clob_table
+select col_0 from clob_table
0 getObject -> EXCEPTION (null)
0 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
0 getAsciiStream -> EXCEPTION (null)
@@ -2782,7 +2782,7 @@
0 getTime -> EXCEPTION (null)
0 getTimeStamp -> EXCEPTION (null)
=== 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 clob_table
+select col_1 from clob_table
1 getObject ->'true ' : java.lang.String
1 getArray -> EXCEPTION (not yet implemented)
1 getAsciiStream ->Object' : java.io.InputStream
@@ -2805,7 +2805,7 @@
1 getTime -> EXCEPTION (Invalid data conversion: Parameter instance true is invalid for requested conversion to java.sql.Time.)
1 getTimeStamp -> EXCEPTION (Invalid data conversion: Parameter instance true 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 clob_table
+select col_2 from clob_table
2 getObject -> EXCEPTION (null)
2 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
2 getAsciiStream -> EXCEPTION (null)
@@ -2828,7 +2828,7 @@
2 getTime -> EXCEPTION (null)
2 getTimeStamp -> EXCEPTION (null)
=== 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 clob_table
+select col_3 from clob_table
3 getObject -> EXCEPTION (null)
3 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
3 getAsciiStream -> EXCEPTION (null)
@@ -2851,7 +2851,7 @@
3 getTime -> EXCEPTION (null)
3 getTimeStamp -> EXCEPTION (null)
=== 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 clob_table
+select col_4 from clob_table
4 getObject -> EXCEPTION (null)
4 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
4 getAsciiStream -> EXCEPTION (null)
@@ -2874,7 +2874,7 @@
4 getTime -> EXCEPTION (null)
4 getTimeStamp -> EXCEPTION (null)
=== 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 clob_table
+select col_5 from clob_table
5 getObject -> EXCEPTION (null)
5 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
5 getAsciiStream -> EXCEPTION (null)
@@ -2897,7 +2897,7 @@
5 getTime -> EXCEPTION (null)
5 getTimeStamp -> EXCEPTION (null)
=== 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 clob_table
+select col_6 from clob_table
6 getObject -> EXCEPTION (null)
6 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
6 getAsciiStream -> EXCEPTION (null)
@@ -2920,7 +2920,7 @@
6 getTime -> EXCEPTION (null)
6 getTimeStamp -> EXCEPTION (null)
=== Columntype clob (2 K)
-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 clob_table
+select typecol from clob_table
7 getObject -> EXCEPTION (null)
7 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
7 getAsciiStream -> EXCEPTION (null)
@@ -3312,7 +3312,7 @@
insert into clob_table ( typecol ) values cast ( X'0074007200750065' AS clob (64 ))
ERROR 42846: Cannot convert types 'CHAR () FOR BIT DATA' to 'CLOB'.
=== 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 clob_table
+select col_0 from clob_table
0 getObject -> EXCEPTION (null)
0 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
0 getAsciiStream -> EXCEPTION (null)
@@ -3335,7 +3335,7 @@
0 getTime -> EXCEPTION (null)
0 getTimeStamp -> EXCEPTION (null)
=== 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 clob_table
+select col_1 from clob_table
1 getObject ->'true ' : java.lang.String
1 getArray -> EXCEPTION (not yet implemented)
1 getAsciiStream ->Object' : java.io.InputStream
@@ -3358,7 +3358,7 @@
1 getTime -> EXCEPTION (Invalid data conversion: Parameter instance true is invalid for requested conversion to java.sql.Time.)
1 getTimeStamp -> EXCEPTION (Invalid data conversion: Parameter instance true 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 clob_table
+select col_2 from clob_table
2 getObject -> EXCEPTION (null)
2 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
2 getAsciiStream -> EXCEPTION (null)
@@ -3381,7 +3381,7 @@
2 getTime -> EXCEPTION (null)
2 getTimeStamp -> EXCEPTION (null)
=== 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 clob_table
+select col_3 from clob_table
3 getObject -> EXCEPTION (null)
3 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
3 getAsciiStream -> EXCEPTION (null)
@@ -3404,7 +3404,7 @@
3 getTime -> EXCEPTION (null)
3 getTimeStamp -> EXCEPTION (null)
=== 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 clob_table
+select col_4 from clob_table
4 getObject -> EXCEPTION (null)
4 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
4 getAsciiStream -> EXCEPTION (null)
@@ -3427,7 +3427,7 @@
4 getTime -> EXCEPTION (null)
4 getTimeStamp -> EXCEPTION (null)
=== 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 clob_table
+select col_5 from clob_table
5 getObject -> EXCEPTION (null)
5 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
5 getAsciiStream -> EXCEPTION (null)
@@ -3450,7 +3450,7 @@
5 getTime -> EXCEPTION (null)
5 getTimeStamp -> EXCEPTION (null)
=== 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 clob_table
+select col_6 from clob_table
6 getObject -> EXCEPTION (null)
6 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
6 getAsciiStream -> EXCEPTION (null)
@@ -3473,7 +3473,7 @@
6 getTime -> EXCEPTION (null)
6 getTimeStamp -> EXCEPTION (null)
=== Columntype clob (64 )
-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 clob_table
+select typecol from clob_table
7 getObject -> EXCEPTION (null)
7 getArray -> EXCEPTION (jdbc 2 method not yet implemented)
7 getAsciiStream -> EXCEPTION (null)
@@ -3871,4 +3871,3 @@
insert into blobCheck (bl ) values ( X'a78a' )
ERROR 42821: Columns of type 'BLOB' cannot hold values of type 'CHAR () FOR BIT DATA'.
insert into blobCheck (bl ) values (cast (X'a78a' as blob(80)) )
-drop table blobCheck