db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From t...@apache.org
Subject svn commit: r357435 [2/3] - in /db/derby/code/trunk/java: client/org/apache/derby/client/am/ engine/org/apache/derby/iapi/reference/ engine/org/apache/derby/impl/jdbc/ engine/org/apache/derby/loc/ testing/org/apache/derbyTesting/functionTests/master/ t...
Date Sun, 18 Dec 2005 05:16:03 GMT
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out?rev=357435&r1=357434&r2=357435&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/LOBTest.out Sat Dec 17 21:15:39 2005
@@ -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 from bit_table
+select col_0 as col_0_1, col_0 as col_0_2, col_0 as col_0_3, col_0 as col_0_4, col_0 as col_0_5, col_0 as col_0_6, col_0 as col_0_7, col_0 as col_0_8, col_0 as col_0_9, col_0 as col_0_10, col_0 as col_0_11, col_0 as col_0_12, col_0 as col_0_13, col_0 as col_0_14, col_0 as col_0_15, col_0 as col_0_16, col_0 as col_0_17, col_0 as col_0_18, col_0 as col_0_19, col_0 as col_0_20, col_0 as col_0_21 from bit_table
 	0 getObject            ->'100'    	: java.lang.Integer
 	0 getArray             ->		EXCEPTION (not yet implemented)
 	0 getAsciiStream       ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
@@ -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 from bit_table
+select col_1 as col_1_1, col_1 as col_1_2, col_1 as col_1_3, col_1 as col_1_4, col_1 as col_1_5, col_1 as col_1_6, col_1 as col_1_7, col_1 as col_1_8, col_1 as col_1_9, col_1 as col_1_10, col_1 as col_1_11, col_1 as col_1_12, col_1 as col_1_13, col_1 as col_1_14, col_1 as col_1_15, col_1 as col_1_16, col_1 as col_1_17, col_1 as col_1_18, col_1 as col_1_19, col_1 as col_1_20, col_1 as col_1_21 from bit_table
 	1 getObject            ->'101       '    	: java.lang.String
 	1 getArray             ->		EXCEPTION (not yet implemented)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from bit_table
+select col_2 as col_2_1, col_2 as col_2_2, col_2 as col_2_3, col_2 as col_2_4, col_2 as col_2_5, col_2 as col_2_6, col_2 as col_2_7, col_2 as col_2_8, col_2 as col_2_9, col_2 as col_2_10, col_2 as col_2_11, col_2 as col_2_12, col_2 as col_2_13, col_2 as col_2_14, col_2 as col_2_15, col_2 as col_2_16, col_2 as col_2_17, col_2 as col_2_18, col_2 as col_2_19, col_2 as col_2_20, col_2 as col_2_21 from bit_table
 	2 getObject            ->'102'    	: java.lang.String
 	2 getArray             ->		EXCEPTION (not yet implemented)
 	2 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype long varchar
-select col_3 from bit_table
+select col_3 as col_3_1, col_3 as col_3_2, col_3 as col_3_3, col_3 as col_3_4, col_3 as col_3_5, col_3 as col_3_6, col_3 as col_3_7, col_3 as col_3_8, col_3 as col_3_9, col_3 as col_3_10, col_3 as col_3_11, col_3 as col_3_12, col_3 as col_3_13, col_3 as col_3_14, col_3 as col_3_15, col_3 as col_3_16, col_3 as col_3_17, col_3 as col_3_18, col_3 as col_3_19, col_3 as col_3_20, col_3 as col_3_21 from bit_table
 	3 getObject            ->'103'    	: java.lang.String
 	3 getArray             ->		EXCEPTION (not yet implemented)
 	3 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype char(10) for bit data
-select col_4 from bit_table
+select col_4 as col_4_1, col_4 as col_4_2, col_4 as col_4_3, col_4 as col_4_4, col_4 as col_4_5, col_4 as col_4_6, col_4 as col_4_7, col_4 as col_4_8, col_4 as col_4_9, col_4 as col_4_10, col_4 as col_4_11, col_4 as col_4_12, col_4 as col_4_13, col_4 as col_4_14, col_4 as col_4_15, col_4 as col_4_16, col_4 as col_4_17, col_4 as col_4_18, col_4 as col_4_19, col_4 as col_4_20, col_4 as col_4_21 from bit_table
 	4 getObject            ->Object'   	: byte[]
 	4 getArray             ->		EXCEPTION (not yet implemented)
 	4 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from bit_table
+select col_5 as col_5_1, col_5 as col_5_2, col_5 as col_5_3, col_5 as col_5_4, col_5 as col_5_5, col_5 as col_5_6, col_5 as col_5_7, col_5 as col_5_8, col_5 as col_5_9, col_5 as col_5_10, col_5 as col_5_11, col_5 as col_5_12, col_5 as col_5_13, col_5 as col_5_14, col_5 as col_5_15, col_5 as col_5_16, col_5 as col_5_17, col_5 as col_5_18, col_5 as col_5_19, col_5 as col_5_20, col_5 as col_5_21 from bit_table
 	5 getObject            ->Object'   	: byte[]
 	5 getArray             ->		EXCEPTION (not yet implemented)
 	5 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from bit_table
+select col_6 as col_6_1, col_6 as col_6_2, col_6 as col_6_3, col_6 as col_6_4, col_6 as col_6_5, col_6 as col_6_6, col_6 as col_6_7, col_6 as col_6_8, col_6 as col_6_9, col_6 as col_6_10, col_6 as col_6_11, col_6 as col_6_12, col_6 as col_6_13, col_6 as col_6_14, col_6 as col_6_15, col_6 as col_6_16, col_6 as col_6_17, col_6 as col_6_18, col_6 as col_6_19, col_6 as col_6_20, col_6 as col_6_21 from bit_table
 	6 getObject            ->Object'   	: java.sql.Blob
 	6 getArray             ->		EXCEPTION (not yet implemented)
 	6 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from bit_table
+select typecol as typecol_1, typecol as typecol_2, typecol as typecol_3, typecol as typecol_4, typecol as typecol_5, typecol as typecol_6, typecol as typecol_7, typecol as typecol_8, typecol as typecol_9, typecol as typecol_10, typecol as typecol_11, typecol as typecol_12, typecol as typecol_13, typecol as typecol_14, typecol as typecol_15, typecol as typecol_16, typecol as typecol_17, typecol as typecol_18, typecol as typecol_19, typecol as typecol_20, typecol as typecol_21 from bit_table
 	7 getObject            ->Object'   	: byte[]
 	7 getArray             ->		EXCEPTION (not yet implemented)
 	7 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from bit_table
+select col_0 as col_0_1, col_0 as col_0_2, col_0 as col_0_3, col_0 as col_0_4, col_0 as col_0_5, col_0 as col_0_6, col_0 as col_0_7, col_0 as col_0_8, col_0 as col_0_9, col_0 as col_0_10, col_0 as col_0_11, col_0 as col_0_12, col_0 as col_0_13, col_0 as col_0_14, col_0 as col_0_15, col_0 as col_0_16, col_0 as col_0_17, col_0 as col_0_18, col_0 as col_0_19, col_0 as col_0_20, col_0 as col_0_21 from bit_table
 	0 getObject            ->'100'    	: java.lang.Integer
 	0 getArray             ->		EXCEPTION (not yet implemented)
 	0 getAsciiStream       ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
@@ -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 from bit_table
+select col_1 as col_1_1, col_1 as col_1_2, col_1 as col_1_3, col_1 as col_1_4, col_1 as col_1_5, col_1 as col_1_6, col_1 as col_1_7, col_1 as col_1_8, col_1 as col_1_9, col_1 as col_1_10, col_1 as col_1_11, col_1 as col_1_12, col_1 as col_1_13, col_1 as col_1_14, col_1 as col_1_15, col_1 as col_1_16, col_1 as col_1_17, col_1 as col_1_18, col_1 as col_1_19, col_1 as col_1_20, col_1 as col_1_21 from bit_table
 	1 getObject            ->'101       '    	: java.lang.String
 	1 getArray             ->		EXCEPTION (not yet implemented)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from bit_table
+select col_2 as col_2_1, col_2 as col_2_2, col_2 as col_2_3, col_2 as col_2_4, col_2 as col_2_5, col_2 as col_2_6, col_2 as col_2_7, col_2 as col_2_8, col_2 as col_2_9, col_2 as col_2_10, col_2 as col_2_11, col_2 as col_2_12, col_2 as col_2_13, col_2 as col_2_14, col_2 as col_2_15, col_2 as col_2_16, col_2 as col_2_17, col_2 as col_2_18, col_2 as col_2_19, col_2 as col_2_20, col_2 as col_2_21 from bit_table
 	2 getObject            ->'102'    	: java.lang.String
 	2 getArray             ->		EXCEPTION (not yet implemented)
 	2 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype long varchar
-select col_3 from bit_table
+select col_3 as col_3_1, col_3 as col_3_2, col_3 as col_3_3, col_3 as col_3_4, col_3 as col_3_5, col_3 as col_3_6, col_3 as col_3_7, col_3 as col_3_8, col_3 as col_3_9, col_3 as col_3_10, col_3 as col_3_11, col_3 as col_3_12, col_3 as col_3_13, col_3 as col_3_14, col_3 as col_3_15, col_3 as col_3_16, col_3 as col_3_17, col_3 as col_3_18, col_3 as col_3_19, col_3 as col_3_20, col_3 as col_3_21 from bit_table
 	3 getObject            ->'103'    	: java.lang.String
 	3 getArray             ->		EXCEPTION (not yet implemented)
 	3 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype char(10) for bit data
-select col_4 from bit_table
+select col_4 as col_4_1, col_4 as col_4_2, col_4 as col_4_3, col_4 as col_4_4, col_4 as col_4_5, col_4 as col_4_6, col_4 as col_4_7, col_4 as col_4_8, col_4 as col_4_9, col_4 as col_4_10, col_4 as col_4_11, col_4 as col_4_12, col_4 as col_4_13, col_4 as col_4_14, col_4 as col_4_15, col_4 as col_4_16, col_4 as col_4_17, col_4 as col_4_18, col_4 as col_4_19, col_4 as col_4_20, col_4 as col_4_21 from bit_table
 	4 getObject            ->Object'   	: byte[]
 	4 getArray             ->		EXCEPTION (not yet implemented)
 	4 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from bit_table
+select col_5 as col_5_1, col_5 as col_5_2, col_5 as col_5_3, col_5 as col_5_4, col_5 as col_5_5, col_5 as col_5_6, col_5 as col_5_7, col_5 as col_5_8, col_5 as col_5_9, col_5 as col_5_10, col_5 as col_5_11, col_5 as col_5_12, col_5 as col_5_13, col_5 as col_5_14, col_5 as col_5_15, col_5 as col_5_16, col_5 as col_5_17, col_5 as col_5_18, col_5 as col_5_19, col_5 as col_5_20, col_5 as col_5_21 from bit_table
 	5 getObject            ->Object'   	: byte[]
 	5 getArray             ->		EXCEPTION (not yet implemented)
 	5 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from bit_table
+select col_6 as col_6_1, col_6 as col_6_2, col_6 as col_6_3, col_6 as col_6_4, col_6 as col_6_5, col_6 as col_6_6, col_6 as col_6_7, col_6 as col_6_8, col_6 as col_6_9, col_6 as col_6_10, col_6 as col_6_11, col_6 as col_6_12, col_6 as col_6_13, col_6 as col_6_14, col_6 as col_6_15, col_6 as col_6_16, col_6 as col_6_17, col_6 as col_6_18, col_6 as col_6_19, col_6 as col_6_20, col_6 as col_6_21 from bit_table
 	6 getObject            ->Object'   	: java.sql.Blob
 	6 getArray             ->		EXCEPTION (not yet implemented)
 	6 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from bit_table
+select typecol as typecol_1, typecol as typecol_2, typecol as typecol_3, typecol as typecol_4, typecol as typecol_5, typecol as typecol_6, typecol as typecol_7, typecol as typecol_8, typecol as typecol_9, typecol as typecol_10, typecol as typecol_11, typecol as typecol_12, typecol as typecol_13, typecol as typecol_14, typecol as typecol_15, typecol as typecol_16, typecol as typecol_17, typecol as typecol_18, typecol as typecol_19, typecol as typecol_20, typecol as typecol_21 from bit_table
 	7 getObject            ->Object'   	: byte[]
 	7 getArray             ->		EXCEPTION (not yet implemented)
 	7 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_0 as col_0_1, col_0 as col_0_2, col_0 as col_0_3, col_0 as col_0_4, col_0 as col_0_5, col_0 as col_0_6, col_0 as col_0_7, col_0 as col_0_8, col_0 as col_0_9, col_0 as col_0_10, col_0 as col_0_11, col_0 as col_0_12, col_0 as col_0_13, col_0 as col_0_14, col_0 as col_0_15, col_0 as col_0_16, col_0 as col_0_17, col_0 as col_0_18, col_0 as col_0_19, col_0 as col_0_20, col_0 as col_0_21 from blob_table
 	0 getObject            ->'100'    	: java.lang.Integer
 	0 getArray             ->		EXCEPTION (not yet implemented)
 	0 getAsciiStream       ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
@@ -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 from blob_table
+select col_1 as col_1_1, col_1 as col_1_2, col_1 as col_1_3, col_1 as col_1_4, col_1 as col_1_5, col_1 as col_1_6, col_1 as col_1_7, col_1 as col_1_8, col_1 as col_1_9, col_1 as col_1_10, col_1 as col_1_11, col_1 as col_1_12, col_1 as col_1_13, col_1 as col_1_14, col_1 as col_1_15, col_1 as col_1_16, col_1 as col_1_17, col_1 as col_1_18, col_1 as col_1_19, col_1 as col_1_20, col_1 as col_1_21 from blob_table
 	1 getObject            ->'101       '    	: java.lang.String
 	1 getArray             ->		EXCEPTION (not yet implemented)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_2 as col_2_1, col_2 as col_2_2, col_2 as col_2_3, col_2 as col_2_4, col_2 as col_2_5, col_2 as col_2_6, col_2 as col_2_7, col_2 as col_2_8, col_2 as col_2_9, col_2 as col_2_10, col_2 as col_2_11, col_2 as col_2_12, col_2 as col_2_13, col_2 as col_2_14, col_2 as col_2_15, col_2 as col_2_16, col_2 as col_2_17, col_2 as col_2_18, col_2 as col_2_19, col_2 as col_2_20, col_2 as col_2_21 from blob_table
 	2 getObject            ->'102'    	: java.lang.String
 	2 getArray             ->		EXCEPTION (not yet implemented)
 	2 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype long varchar
-select col_3 from blob_table
+select col_3 as col_3_1, col_3 as col_3_2, col_3 as col_3_3, col_3 as col_3_4, col_3 as col_3_5, col_3 as col_3_6, col_3 as col_3_7, col_3 as col_3_8, col_3 as col_3_9, col_3 as col_3_10, col_3 as col_3_11, col_3 as col_3_12, col_3 as col_3_13, col_3 as col_3_14, col_3 as col_3_15, col_3 as col_3_16, col_3 as col_3_17, col_3 as col_3_18, col_3 as col_3_19, col_3 as col_3_20, col_3 as col_3_21 from blob_table
 	3 getObject            ->'103'    	: java.lang.String
 	3 getArray             ->		EXCEPTION (not yet implemented)
 	3 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype char(10) for bit data
-select col_4 from blob_table
+select col_4 as col_4_1, col_4 as col_4_2, col_4 as col_4_3, col_4 as col_4_4, col_4 as col_4_5, col_4 as col_4_6, col_4 as col_4_7, col_4 as col_4_8, col_4 as col_4_9, col_4 as col_4_10, col_4 as col_4_11, col_4 as col_4_12, col_4 as col_4_13, col_4 as col_4_14, col_4 as col_4_15, col_4 as col_4_16, col_4 as col_4_17, col_4 as col_4_18, col_4 as col_4_19, col_4 as col_4_20, col_4 as col_4_21 from blob_table
 	4 getObject            ->Object'   	: byte[]
 	4 getArray             ->		EXCEPTION (not yet implemented)
 	4 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_5 as col_5_1, col_5 as col_5_2, col_5 as col_5_3, col_5 as col_5_4, col_5 as col_5_5, col_5 as col_5_6, col_5 as col_5_7, col_5 as col_5_8, col_5 as col_5_9, col_5 as col_5_10, col_5 as col_5_11, col_5 as col_5_12, col_5 as col_5_13, col_5 as col_5_14, col_5 as col_5_15, col_5 as col_5_16, col_5 as col_5_17, col_5 as col_5_18, col_5 as col_5_19, col_5 as col_5_20, col_5 as col_5_21 from blob_table
 	5 getObject            ->Object'   	: byte[]
 	5 getArray             ->		EXCEPTION (not yet implemented)
 	5 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_6 as col_6_1, col_6 as col_6_2, col_6 as col_6_3, col_6 as col_6_4, col_6 as col_6_5, col_6 as col_6_6, col_6 as col_6_7, col_6 as col_6_8, col_6 as col_6_9, col_6 as col_6_10, col_6 as col_6_11, col_6 as col_6_12, col_6 as col_6_13, col_6 as col_6_14, col_6 as col_6_15, col_6 as col_6_16, col_6 as col_6_17, col_6 as col_6_18, col_6 as col_6_19, col_6 as col_6_20, col_6 as col_6_21 from blob_table
 	6 getObject            ->Object'   	: java.sql.Blob
 	6 getArray             ->		EXCEPTION (not yet implemented)
 	6 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select typecol as typecol_1, typecol as typecol_2, typecol as typecol_3, typecol as typecol_4, typecol as typecol_5, typecol as typecol_6, typecol as typecol_7, typecol as typecol_8, typecol as typecol_9, typecol as typecol_10, typecol as typecol_11, typecol as typecol_12, typecol as typecol_13, typecol as typecol_14, typecol as typecol_15, typecol as typecol_16, typecol as typecol_17, typecol as typecol_18, typecol as typecol_19, typecol as typecol_20, typecol as typecol_21 from blob_table
 	7 getObject            ->Object'   	: java.sql.Blob
 	7 getArray             ->		EXCEPTION (not yet implemented)
 	7 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_0 as col_0_1, col_0 as col_0_2, col_0 as col_0_3, col_0 as col_0_4, col_0 as col_0_5, col_0 as col_0_6, col_0 as col_0_7, col_0 as col_0_8, col_0 as col_0_9, col_0 as col_0_10, col_0 as col_0_11, col_0 as col_0_12, col_0 as col_0_13, col_0 as col_0_14, col_0 as col_0_15, col_0 as col_0_16, col_0 as col_0_17, col_0 as col_0_18, col_0 as col_0_19, col_0 as col_0_20, col_0 as col_0_21 from blob_table
 	0 getObject            ->'100'    	: java.lang.Integer
 	0 getArray             ->		EXCEPTION (not yet implemented)
 	0 getAsciiStream       ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
@@ -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 from blob_table
+select col_1 as col_1_1, col_1 as col_1_2, col_1 as col_1_3, col_1 as col_1_4, col_1 as col_1_5, col_1 as col_1_6, col_1 as col_1_7, col_1 as col_1_8, col_1 as col_1_9, col_1 as col_1_10, col_1 as col_1_11, col_1 as col_1_12, col_1 as col_1_13, col_1 as col_1_14, col_1 as col_1_15, col_1 as col_1_16, col_1 as col_1_17, col_1 as col_1_18, col_1 as col_1_19, col_1 as col_1_20, col_1 as col_1_21 from blob_table
 	1 getObject            ->'101       '    	: java.lang.String
 	1 getArray             ->		EXCEPTION (not yet implemented)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_2 as col_2_1, col_2 as col_2_2, col_2 as col_2_3, col_2 as col_2_4, col_2 as col_2_5, col_2 as col_2_6, col_2 as col_2_7, col_2 as col_2_8, col_2 as col_2_9, col_2 as col_2_10, col_2 as col_2_11, col_2 as col_2_12, col_2 as col_2_13, col_2 as col_2_14, col_2 as col_2_15, col_2 as col_2_16, col_2 as col_2_17, col_2 as col_2_18, col_2 as col_2_19, col_2 as col_2_20, col_2 as col_2_21 from blob_table
 	2 getObject            ->'102'    	: java.lang.String
 	2 getArray             ->		EXCEPTION (not yet implemented)
 	2 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype long varchar
-select col_3 from blob_table
+select col_3 as col_3_1, col_3 as col_3_2, col_3 as col_3_3, col_3 as col_3_4, col_3 as col_3_5, col_3 as col_3_6, col_3 as col_3_7, col_3 as col_3_8, col_3 as col_3_9, col_3 as col_3_10, col_3 as col_3_11, col_3 as col_3_12, col_3 as col_3_13, col_3 as col_3_14, col_3 as col_3_15, col_3 as col_3_16, col_3 as col_3_17, col_3 as col_3_18, col_3 as col_3_19, col_3 as col_3_20, col_3 as col_3_21 from blob_table
 	3 getObject            ->'103'    	: java.lang.String
 	3 getArray             ->		EXCEPTION (not yet implemented)
 	3 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype char(10) for bit data
-select col_4 from blob_table
+select col_4 as col_4_1, col_4 as col_4_2, col_4 as col_4_3, col_4 as col_4_4, col_4 as col_4_5, col_4 as col_4_6, col_4 as col_4_7, col_4 as col_4_8, col_4 as col_4_9, col_4 as col_4_10, col_4 as col_4_11, col_4 as col_4_12, col_4 as col_4_13, col_4 as col_4_14, col_4 as col_4_15, col_4 as col_4_16, col_4 as col_4_17, col_4 as col_4_18, col_4 as col_4_19, col_4 as col_4_20, col_4 as col_4_21 from blob_table
 	4 getObject            ->Object'   	: byte[]
 	4 getArray             ->		EXCEPTION (not yet implemented)
 	4 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_5 as col_5_1, col_5 as col_5_2, col_5 as col_5_3, col_5 as col_5_4, col_5 as col_5_5, col_5 as col_5_6, col_5 as col_5_7, col_5 as col_5_8, col_5 as col_5_9, col_5 as col_5_10, col_5 as col_5_11, col_5 as col_5_12, col_5 as col_5_13, col_5 as col_5_14, col_5 as col_5_15, col_5 as col_5_16, col_5 as col_5_17, col_5 as col_5_18, col_5 as col_5_19, col_5 as col_5_20, col_5 as col_5_21 from blob_table
 	5 getObject            ->Object'   	: byte[]
 	5 getArray             ->		EXCEPTION (not yet implemented)
 	5 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_6 as col_6_1, col_6 as col_6_2, col_6 as col_6_3, col_6 as col_6_4, col_6 as col_6_5, col_6 as col_6_6, col_6 as col_6_7, col_6 as col_6_8, col_6 as col_6_9, col_6 as col_6_10, col_6 as col_6_11, col_6 as col_6_12, col_6 as col_6_13, col_6 as col_6_14, col_6 as col_6_15, col_6 as col_6_16, col_6 as col_6_17, col_6 as col_6_18, col_6 as col_6_19, col_6 as col_6_20, col_6 as col_6_21 from blob_table
 	6 getObject            ->Object'   	: java.sql.Blob
 	6 getArray             ->		EXCEPTION (not yet implemented)
 	6 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select typecol as typecol_1, typecol as typecol_2, typecol as typecol_3, typecol as typecol_4, typecol as typecol_5, typecol as typecol_6, typecol as typecol_7, typecol as typecol_8, typecol as typecol_9, typecol as typecol_10, typecol as typecol_11, typecol as typecol_12, typecol as typecol_13, typecol as typecol_14, typecol as typecol_15, typecol as typecol_16, typecol as typecol_17, typecol as typecol_18, typecol as typecol_19, typecol as typecol_20, typecol as typecol_21 from blob_table
 	7 getObject            ->Object'   	: java.sql.Blob
 	7 getArray             ->		EXCEPTION (not yet implemented)
 	7 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_0 as col_0_1, col_0 as col_0_2, col_0 as col_0_3, col_0 as col_0_4, col_0 as col_0_5, col_0 as col_0_6, col_0 as col_0_7, col_0 as col_0_8, col_0 as col_0_9, col_0 as col_0_10, col_0 as col_0_11, col_0 as col_0_12, col_0 as col_0_13, col_0 as col_0_14, col_0 as col_0_15, col_0 as col_0_16, col_0 as col_0_17, col_0 as col_0_18, col_0 as col_0_19, col_0 as col_0_20, col_0 as col_0_21 from blob_table
 	0 getObject            ->'100'    	: java.lang.Integer
 	0 getArray             ->		EXCEPTION (not yet implemented)
 	0 getAsciiStream       ->		EXCEPTION (Invalid data conversion: Wrong result column type for requested conversion.)
@@ -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 from blob_table
+select col_1 as col_1_1, col_1 as col_1_2, col_1 as col_1_3, col_1 as col_1_4, col_1 as col_1_5, col_1 as col_1_6, col_1 as col_1_7, col_1 as col_1_8, col_1 as col_1_9, col_1 as col_1_10, col_1 as col_1_11, col_1 as col_1_12, col_1 as col_1_13, col_1 as col_1_14, col_1 as col_1_15, col_1 as col_1_16, col_1 as col_1_17, col_1 as col_1_18, col_1 as col_1_19, col_1 as col_1_20, col_1 as col_1_21 from blob_table
 	1 getObject            ->'101       '    	: java.lang.String
 	1 getArray             ->		EXCEPTION (not yet implemented)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_2 as col_2_1, col_2 as col_2_2, col_2 as col_2_3, col_2 as col_2_4, col_2 as col_2_5, col_2 as col_2_6, col_2 as col_2_7, col_2 as col_2_8, col_2 as col_2_9, col_2 as col_2_10, col_2 as col_2_11, col_2 as col_2_12, col_2 as col_2_13, col_2 as col_2_14, col_2 as col_2_15, col_2 as col_2_16, col_2 as col_2_17, col_2 as col_2_18, col_2 as col_2_19, col_2 as col_2_20, col_2 as col_2_21 from blob_table
 	2 getObject            ->'102'    	: java.lang.String
 	2 getArray             ->		EXCEPTION (not yet implemented)
 	2 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 (Invalid data conversion: Parameter instance 102 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype long varchar
-select col_3 from blob_table
+select col_3 as col_3_1, col_3 as col_3_2, col_3 as col_3_3, col_3 as col_3_4, col_3 as col_3_5, col_3 as col_3_6, col_3 as col_3_7, col_3 as col_3_8, col_3 as col_3_9, col_3 as col_3_10, col_3 as col_3_11, col_3 as col_3_12, col_3 as col_3_13, col_3 as col_3_14, col_3 as col_3_15, col_3 as col_3_16, col_3 as col_3_17, col_3 as col_3_18, col_3 as col_3_19, col_3 as col_3_20, col_3 as col_3_21 from blob_table
 	3 getObject            ->'103'    	: java.lang.String
 	3 getArray             ->		EXCEPTION (not yet implemented)
 	3 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 (Invalid data conversion: Parameter instance 103 is invalid for requested conversion to java.sql.Timestamp.)
 === Columntype char(10) for bit data
-select col_4 from blob_table
+select col_4 as col_4_1, col_4 as col_4_2, col_4 as col_4_3, col_4 as col_4_4, col_4 as col_4_5, col_4 as col_4_6, col_4 as col_4_7, col_4 as col_4_8, col_4 as col_4_9, col_4 as col_4_10, col_4 as col_4_11, col_4 as col_4_12, col_4 as col_4_13, col_4 as col_4_14, col_4 as col_4_15, col_4 as col_4_16, col_4 as col_4_17, col_4 as col_4_18, col_4 as col_4_19, col_4 as col_4_20, col_4 as col_4_21 from blob_table
 	4 getObject            ->Object'   	: byte[]
 	4 getArray             ->		EXCEPTION (not yet implemented)
 	4 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_5 as col_5_1, col_5 as col_5_2, col_5 as col_5_3, col_5 as col_5_4, col_5 as col_5_5, col_5 as col_5_6, col_5 as col_5_7, col_5 as col_5_8, col_5 as col_5_9, col_5 as col_5_10, col_5 as col_5_11, col_5 as col_5_12, col_5 as col_5_13, col_5 as col_5_14, col_5 as col_5_15, col_5 as col_5_16, col_5 as col_5_17, col_5 as col_5_18, col_5 as col_5_19, col_5 as col_5_20, col_5 as col_5_21 from blob_table
 	5 getObject            ->Object'   	: byte[]
 	5 getArray             ->		EXCEPTION (not yet implemented)
 	5 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select col_6 as col_6_1, col_6 as col_6_2, col_6 as col_6_3, col_6 as col_6_4, col_6 as col_6_5, col_6 as col_6_6, col_6 as col_6_7, col_6 as col_6_8, col_6 as col_6_9, col_6 as col_6_10, col_6 as col_6_11, col_6 as col_6_12, col_6 as col_6_13, col_6 as col_6_14, col_6 as col_6_15, col_6 as col_6_16, col_6 as col_6_17, col_6 as col_6_18, col_6 as col_6_19, col_6 as col_6_20, col_6 as col_6_21 from blob_table
 	6 getObject            ->Object'   	: java.sql.Blob
 	6 getArray             ->		EXCEPTION (not yet implemented)
 	6 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from blob_table
+select typecol as typecol_1, typecol as typecol_2, typecol as typecol_3, typecol as typecol_4, typecol as typecol_5, typecol as typecol_6, typecol as typecol_7, typecol as typecol_8, typecol as typecol_9, typecol as typecol_10, typecol as typecol_11, typecol as typecol_12, typecol as typecol_13, typecol as typecol_14, typecol as typecol_15, typecol as typecol_16, typecol as typecol_17, typecol as typecol_18, typecol as typecol_19, typecol as typecol_20, typecol as typecol_21 from blob_table
 	7 getObject            ->Object'   	: java.sql.Blob
 	7 getArray             ->		EXCEPTION (not yet implemented)
 	7 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	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 from clob_table
+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
 	7 getObject            ->		EXCEPTION (null)
 	7 getArray             ->		EXCEPTION (jdbc 2 method not yet implemented)
 	7 getAsciiStream       ->		EXCEPTION (null)

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/Stream.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/Stream.out?rev=357435&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/Stream.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/Stream.out Sat Dec 17 21:15:39 2005
@@ -0,0 +1,16 @@
+get stream from SMALL_BLOB_TABLE.SMALL_BLOB ...
+get stream from SMALL_BLOB_TABLE.SMALL_BLOB again ...
+Expected exception may happen.
+org.apache.derby.client.am.SqlException: Stream of column value in result cannot be retrieved twice
+get stream from LARGE_BLOB_TABLE.LARGE_BLOB ...
+get stream from LARGE_BLOB_TABLE.LARGE_BLOB again ...
+Expected exception may happen.
+org.apache.derby.client.am.SqlException: Stream of column value in result cannot be retrieved twice
+get reader from SMALL_CLOB_TABLE.SMALL_CLOB ...
+get reader from SMALL_CLOB_TABLE.SMALL_CLOBagain ...
+Expected exception may happen.
+org.apache.derby.client.am.SqlException: Stream of column value in result cannot be retrieved twice
+get reader from LARGE_CLOB_TABLE.LARGE_CLOB ...
+get reader from LARGE_CLOB_TABLE.LARGE_CLOBagain ...
+Expected exception may happen.
+org.apache.derby.client.am.SqlException: Stream of column value in result cannot be retrieved twice



Mime
View raw message