db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrn...@apache.org
Subject 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/
Date Tue, 21 Nov 2006 06:27:33 GMT
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



Mime
View raw message