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 [3/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/LOBTest.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBTest.out?rev=357435&r1=357434&r2=357435&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/LOBTest.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/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 (Feature not implemented: no details.)
 	0 getAsciiStream       ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream(ASCII)' from a data value of type 'INTEGER'.)
@@ -33,7 +33,7 @@
 	0 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.)
 	0 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.)
 === 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 (Feature not implemented: no details.)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -56,7 +56,7 @@
 	1 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	1 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	2 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -79,7 +79,7 @@
 	2 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	2 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	3 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -102,7 +102,7 @@
 	3 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	3 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	4 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -125,7 +125,7 @@
 	4 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'CHAR () FOR BIT DATA'.)
 	4 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'CHAR () FOR BIT DATA'.)
 === 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 (Feature not implemented: no details.)
 	5 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -148,7 +148,7 @@
 	5 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
 	5 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
 === 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 (Feature not implemented: no details.)
 	6 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -171,7 +171,7 @@
 	6 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BLOB'.)
 	6 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BLOB'.)
 === 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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	0 getAsciiStream       ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream(ASCII)' from a data value of type 'INTEGER'.)
@@ -595,7 +595,7 @@
 	0 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.)
 	0 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.)
 === 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 (Feature not implemented: no details.)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -618,7 +618,7 @@
 	1 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	1 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	2 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -641,7 +641,7 @@
 	2 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	2 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	3 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -664,7 +664,7 @@
 	3 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	3 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	4 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -687,7 +687,7 @@
 	4 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'CHAR () FOR BIT DATA'.)
 	4 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'CHAR () FOR BIT DATA'.)
 === 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 (Feature not implemented: no details.)
 	5 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -710,7 +710,7 @@
 	5 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
 	5 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
 === 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 (Feature not implemented: no details.)
 	6 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -733,7 +733,7 @@
 	6 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BLOB'.)
 	6 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BLOB'.)
 === 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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	0 getAsciiStream       ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream(ASCII)' from a data value of type 'INTEGER'.)
@@ -1157,7 +1157,7 @@
 	0 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.)
 	0 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.)
 === 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 (Feature not implemented: no details.)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1180,7 +1180,7 @@
 	1 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	1 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	2 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1203,7 +1203,7 @@
 	2 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	2 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	3 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1226,7 +1226,7 @@
 	3 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	3 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	4 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1249,7 +1249,7 @@
 	4 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'CHAR () FOR BIT DATA'.)
 	4 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'CHAR () FOR BIT DATA'.)
 === 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 (Feature not implemented: no details.)
 	5 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1272,7 +1272,7 @@
 	5 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
 	5 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
 === 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 (Feature not implemented: no details.)
 	6 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1295,7 +1295,7 @@
 	6 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BLOB'.)
 	6 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BLOB'.)
 === 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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	0 getAsciiStream       ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream(ASCII)' from a data value of type 'INTEGER'.)
@@ -1698,7 +1698,7 @@
 	0 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.)
 	0 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.)
 === 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 (Feature not implemented: no details.)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1721,7 +1721,7 @@
 	1 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	1 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	2 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1744,7 +1744,7 @@
 	2 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	2 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	3 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1767,7 +1767,7 @@
 	3 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	3 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	4 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1790,7 +1790,7 @@
 	4 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'CHAR () FOR BIT DATA'.)
 	4 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'CHAR () FOR BIT DATA'.)
 === 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 (Feature not implemented: no details.)
 	5 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1813,7 +1813,7 @@
 	5 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
 	5 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
 === 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 (Feature not implemented: no details.)
 	6 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -1836,7 +1836,7 @@
 	6 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BLOB'.)
 	6 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BLOB'.)
 === 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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	0 getAsciiStream       ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream(ASCII)' from a data value of type 'INTEGER'.)
@@ -2239,7 +2239,7 @@
 	0 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'INTEGER'.)
 	0 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'INTEGER'.)
 === 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 (Feature not implemented: no details.)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -2262,7 +2262,7 @@
 	1 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	1 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	2 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -2285,7 +2285,7 @@
 	2 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	2 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	3 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -2308,7 +2308,7 @@
 	3 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	3 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	4 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -2331,7 +2331,7 @@
 	4 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'CHAR () FOR BIT DATA'.)
 	4 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'CHAR () FOR BIT DATA'.)
 === 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 (Feature not implemented: no details.)
 	5 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -2354,7 +2354,7 @@
 	5 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
 	5 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'LONG VARCHAR FOR BIT DATA'.)
 === 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 (Feature not implemented: no details.)
 	6 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -2377,7 +2377,7 @@
 	6 getTime              ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Time' from a data value of type 'BLOB'.)
 	6 getTimeStamp         ->		EXCEPTION (An attempt was made to get a data value of type 'java.sql.Timestamp' from a data value of type 'BLOB'.)
 === 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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	0 getAsciiStream       ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream(ASCII)' from a data value of type 'INTEGER'.)
@@ -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 (Feature not implemented: no details.)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -2805,7 +2805,7 @@
 	1 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	1 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	0 getAsciiStream       ->		EXCEPTION (An attempt was made to get a data value of type 'java.io.InputStream(ASCII)' from a data value of type 'INTEGER'.)
@@ -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 (Feature not implemented: no details.)
 	1 getAsciiStream       ->Object'   	: java.io.InputStream
@@ -3358,7 +3358,7 @@
 	1 getTime              ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 	1 getTimeStamp         ->		EXCEPTION (The syntax of the string representation of a datetime value is incorrect.)
 === 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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	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 (Feature not implemented: no details.)
 	7 getAsciiStream       ->		EXCEPTION (null)

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Stream.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Stream.out?rev=357435&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/Stream.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/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.
+SQL Exception: 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.
+SQL Exception: 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.
+SQL Exception: 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.
+SQL Exception: Stream of column value in result cannot be retrieved twice
\ No newline at end of file

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/connectionJdbc20.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/connectionJdbc20.out?rev=357435&r1=357434&r2=357435&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/connectionJdbc20.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/connectionJdbc20.out Sat Dec 17 21:15:39 2005
@@ -17,13 +17,13 @@
 x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
 x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
 x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
-getBinaryStream(1)
+getBinaryStream(7)
 x43x31x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
 x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
 x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
-getBytes(1)
+getBytes(7)
 x43x31x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
@@ -40,11 +40,11 @@
 x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58
-getBinaryStream(2)
+getBinaryStream(8)
 x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58
-getBytes(2)
+getBytes(8)
 x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58
@@ -59,11 +59,11 @@
 x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58
-getBinaryStream(3)
+getBinaryStream(9)
 x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58
-getBytes(3)
+getBytes(9)
 x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58
@@ -112,13 +112,13 @@
 x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
 x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
 x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
-getBinaryStream(1)
+getBinaryStream(7)
 x43x31x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
 x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
 x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
-getBytes(1)
+getBytes(7)
 x43x31x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20x20
@@ -135,11 +135,11 @@
 x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58
-getBinaryStream(2)
+getBinaryStream(8)
 x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58
-getBytes(2)
+getBytes(8)
 x43x32x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58
@@ -154,11 +154,11 @@
 x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58
-getBinaryStream(3)
+getBinaryStream(9)
 x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58
-getBytes(3)
+getBytes(9)
 x43x33x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58x58
 x58x58

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/jdbcapi.runall
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/jdbcapi.runall?rev=357435&r1=357434&r2=357435&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/jdbcapi.runall (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/jdbcapi.runall Sat Dec 17 21:15:39 2005
@@ -18,4 +18,4 @@
 jdbcapi/prepStmtNull.java
 jdbcapi/testRelative.java
 jdbcapi/rsgetXXXcolumnNames.java
-
+jdbcapi/Stream.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java?rev=357435&r1=357434&r2=357435&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/LOBTest.java Sat Dec 17 21:15:39 2005
@@ -354,12 +354,38 @@
     public void testGetters() throws SQLException {
         for(int i=0; i<columns; i++) {
             System.out.println("\n\n=== Columntype "+colTypes[i]);
-            String s = "select "+colNames[i]+" from "+table;
+	    
+            String s = 
+		"select "+
+		colNames[i] + " as " + colNames[i] + "_1, " +
+		colNames[i] + " as " + colNames[i] + "_2, " +
+		colNames[i] + " as " + colNames[i] + "_3, " +
+		colNames[i] + " as " + colNames[i] + "_4, " +
+		colNames[i] + " as " + colNames[i] + "_5, " +
+		colNames[i] + " as " + colNames[i] + "_6, " +
+		colNames[i] + " as " + colNames[i] + "_7, " +
+		colNames[i] + " as " + colNames[i] + "_8, " +
+		colNames[i] + " as " + colNames[i] + "_9, " +
+		colNames[i] + " as " + colNames[i] + "_10, " +
+		colNames[i] + " as " + colNames[i] + "_11, " +
+		colNames[i] + " as " + colNames[i] + "_12, " +
+		colNames[i] + " as " + colNames[i] + "_13, " +
+		colNames[i] + " as " + colNames[i] + "_14, " +
+		colNames[i] + " as " + colNames[i] + "_15, " +
+		colNames[i] + " as " + colNames[i] + "_16, " +
+		colNames[i] + " as " + colNames[i] + "_17, " +
+		colNames[i] + " as " + colNames[i] + "_18, " +
+		colNames[i] + " as " + colNames[i] + "_19, " +
+		colNames[i] + " as " + colNames[i] + "_20, " +
+		colNames[i] + " as " + colNames[i] + "_21 " +
+		"from "+
+		table;
+	    
             ResultSet rs = X(s);
             rs.next(); // goto first
             int getno = 0;
             String r;
-            while(null!=(r = getter(rs, getno, 1))) {
+            while(null!=(r = getter(rs, getno, getno + 1 ))) {
                 System.out.println("\t"+i+" "+r);
                 getno++;
             }

Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/Stream.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/Stream.java?rev=357435&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/Stream.java (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/Stream.java Sat Dec 17 21:15:39 2005
@@ -0,0 +1,465 @@
+/*
+
+Derby - Class org.apache.derbyTesting.functionTests.tests.jdbcapi.Stream
+
+Copyright 1999, 2005 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed under the Apache License, Version 2.0 (the "License");
+you may not use this file except in compliance with the License.
+You may obtain a copy of the License at
+
+http://www.apache.org/licenses/LICENSE-2.0
+
+Unless required by applicable law or agreed to in writing, software
+distributed under the License is distributed on an "AS IS" BASIS,
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+See the License for the specific language governing permissions and
+limitations under the License.
+
+*/
+
+package org.apache.derbyTesting.functionTests.tests.jdbcapi;
+
+import java.io.InputStream;
+import java.io.Reader;
+import java.sql.Connection;
+import java.sql.Statement;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+
+import java.io.IOException;
+import java.sql.SQLException;
+
+import org.apache.derby.tools.ij;
+
+
+public class Stream {
+    
+    public static void main(String[] args){
+	
+	Connection conn = null;
+
+	try{
+	    ij.getPropertyArg(args);
+	    conn = ij.startJBMS();
+	    
+	    createTestTables(conn);
+	    executeTests(conn);
+	    dropTestTables(conn);
+	    
+	}catch(Throwable t){
+	    t.printStackTrace();
+	    
+	}finally{
+	    if(conn != null){
+		try{
+		    conn.close();
+		    
+		}catch(SQLException e){
+		    e.printStackTrace();
+		}
+		
+	    }
+	}
+	
+    }
+
+    
+    private static void createTestTables(Connection conn) 
+	throws SQLException,IOException {
+	
+	createTable(conn);
+	createTestData(conn);
+	
+    }
+    
+    
+    private static void createTable(Connection conn) throws SQLException {
+	
+	Statement st = null;
+	
+	try{
+	    
+	    st = conn.createStatement();
+	    st.execute("create table SMALL_BLOB_TABLE( SMALL_BLOB blob( 512 ))");
+	    st.execute("create table LARGE_BLOB_TABLE( LARGE_BLOB blob( 512k ))");
+	    st.execute("create table SMALL_CLOB_TABLE( SMALL_CLOB clob( 512 ))");
+	    st.execute("create table LARGE_CLOB_TABLE( LARGE_CLOB clob( 512k ))");
+
+	}finally{
+	    if(st != null)
+		st.close();
+	}
+	
+    }
+
+    
+    private static void createTestData(Connection conn) 
+	throws SQLException,IOException {
+
+	createSmallBlobTestData( conn );
+	createLargeBlobTestData( conn );
+	createSmallClobTestData( conn );
+	createLargeClobTestData( conn );
+	
+    }
+    
+    
+    private static void createSmallBlobTestData(Connection conn) 
+	throws SQLException,IOException {
+	
+	PreparedStatement st = null;
+	TestDataStream stream = null;
+
+	try{
+	    st = conn.prepareStatement("insert into SMALL_BLOB_TABLE(SMALL_BLOB) values(?)");
+	    stream = new TestDataStream(512);
+	    st.setBinaryStream(1, stream, 512);
+	    st.executeUpdate();
+	    
+	}finally{
+	    if(st != null){
+		st.close();
+	    }
+
+	    if(stream != null){
+		stream.close();
+	    }
+	    
+	}
+
+    }
+    
+    
+    private static void createLargeBlobTestData(Connection conn) 
+	throws SQLException,IOException {
+	
+	PreparedStatement st = null;
+	TestDataStream stream = null;
+	
+	try{
+	    st = conn.prepareStatement("insert into LARGE_BLOB_TABLE(LARGE_BLOB) values(?)");
+	    stream = new TestDataStream( 512 * 1024);
+	    st.setBinaryStream(1,stream, 512 * 1024);
+
+	    st.executeUpdate();
+	    
+	}finally{
+	    if(st != null){
+		st.close();
+	    }
+
+	    if(stream != null){
+		stream.close();
+	    }
+	}
+    }
+    
+    
+    private static void createSmallClobTestData(Connection conn)
+	throws SQLException,IOException {
+	
+	PreparedStatement st = null;
+	TestDataReader reader = null;
+	
+	try{
+	    st = conn.prepareStatement("insert into SMALL_CLOB_TABLE( SMALL_CLOB ) values(?)");
+
+	    reader = new TestDataReader( 512 );
+	    st.setCharacterStream(1,
+				  reader, 
+				  512);
+	    
+	    st.executeUpdate();
+	    
+	    
+	}finally{
+	    if(st != null)
+		st.close();
+	    
+	    if(reader != null)
+		reader.close();
+	    
+	}
+	
+    }   
+    
+
+    private static void createLargeClobTestData(Connection conn)
+	throws SQLException, IOException {
+	
+	PreparedStatement st = null;
+	TestDataReader reader = null;
+
+	try{
+	    st = conn.prepareStatement("insert into LARGE_CLOB_TABLE( LARGE_CLOB ) values(?)");
+	    
+	    reader = new TestDataReader( 512 * 1024 );
+	    st.setCharacterStream(1,
+				  reader,
+				  512 * 1024 );
+	    
+	    st.executeUpdate();
+	    
+	    
+	} finally {
+	    if(st != null)
+		st.close();
+	    
+	    if(reader != null)
+		reader.close();
+	}
+    }
+
+    private static void executeTests(Connection conn) 
+	throws SQLException, IOException {
+	
+	executeTestOnSmallBlob( conn );
+	executeTestOnLargeBlob( conn );
+	executeTestOnSmallClob( conn );
+	executeTestOnLargeClob( conn );
+	
+    }
+    
+    
+    private static void executeTestOnSmallBlob( Connection conn ) 
+	throws SQLException, IOException {
+	
+	BlobTester tester = new BlobTester( "SMALL_BLOB_TABLE", 
+					    "SMALL_BLOB" );
+	tester.testGetStreamTwice( conn );
+	
+    }
+
+
+    private static void executeTestOnLargeBlob( Connection conn ) 
+	throws SQLException, IOException {
+	
+	BlobTester tester = new BlobTester( "LARGE_BLOB_TABLE", 
+					    "LARGE_BLOB" );
+	tester.testGetStreamTwice( conn );
+	
+    }
+    
+    
+    private static void executeTestOnSmallClob( Connection conn ) 
+	throws SQLException, IOException {
+	
+	ClobTester tester = new ClobTester( "SMALL_CLOB_TABLE",
+					    "SMALL_CLOB" );
+	tester.testGetReaderTwice( conn );
+
+    }
+
+
+    private static void executeTestOnLargeClob( Connection conn ) 
+	throws SQLException, IOException {
+	
+	ClobTester tester = new ClobTester( "LARGE_CLOB_TABLE",
+					    "LARGE_CLOB" );
+	tester.testGetReaderTwice( conn );
+
+    }
+    
+
+    private static void dropTestTables( Connection conn ) throws SQLException {
+	
+	Statement st = null;
+	
+	try{
+	    st = conn.createStatement();
+	    st.execute("drop table SMALL_BLOB_TABLE");
+	    st.execute("drop table LARGE_BLOB_TABLE");
+
+	}finally{
+	    if(st != null)
+		st.close();
+	}
+	
+    }
+    
+    
+    static class TestDataStream extends InputStream {
+	
+	private long streamedLength = 0;
+	private final long total;
+	
+	
+	public TestDataStream(long length){
+	    total = length;
+	}
+	
+	
+	public int read(){
+	    
+	    if(streamedLength >= total){
+		return -1;
+	    }
+
+	    return (int) ((streamedLength ++) % 256L);
+	    
+	}
+	
+	
+	public void close(){
+	    streamedLength = total;
+	}
+	
+    }
+    
+
+    static class TestDataReader extends Reader {
+	
+	private long wroteLength = 0;
+	private final long total;
+
+	
+	public TestDataReader(long length){
+	    total = length;
+	}
+
+	
+	public void close(){
+	    wroteLength = total;
+	}
+
+	
+	public int read( char[] cbuf,
+			 int off,
+			 int len ){
+	    
+	    if(wroteLength >= total)
+		return -1;
+	    
+	    int i;
+	    for(i = off ;
+		i < off + len &&
+		    wroteLength <= total ;
+		i++, wroteLength ++){
+		
+		cbuf[i] = (char) (wroteLength % 0x10000L);
+		
+	    }
+
+	    return i - off;
+	}
+	
+    }
+    
+    
+    static class BlobTester {
+	
+	final String tableName;
+	final String colName;
+	
+	
+	BlobTester(String tableName,
+		   String colName){
+	    
+	    this.tableName  = tableName;
+	    this.colName = colName;
+	    
+	}
+	
+	
+	public void testGetStreamTwice(Connection conn) 
+	    throws SQLException, IOException {
+	    
+	    Statement st = null;
+	    ResultSet rs = null;
+	    InputStream is = null;
+
+	    try{
+		st = conn.createStatement();
+		
+		rs = st.executeQuery("select " + 
+				     colName + " "+ 
+				     "from " + 
+				     tableName);
+		rs.next();
+		
+		System.out.println("get stream from " + tableName + "." + colName + " ...");
+		is = rs.getBinaryStream(1);
+		is.close();
+		
+		System.out.println("get stream from " + tableName + "." + colName + " again ...");
+		is = rs.getBinaryStream(1);
+		
+		System.out.println("Expected exception did not happen.");
+		
+	    }catch(SQLException e){
+		System.out.println("Expected exception may happen.");
+		e.printStackTrace(System.out);
+		
+	    }finally{
+		if( st != null )
+		    st.close();
+		
+		if( rs != null )
+		    rs.close();
+		
+		if( is != null )
+		    is.close();
+		
+	    }
+	}
+    }
+
+
+    static class ClobTester {
+	
+	final String tableName;
+	final String colName;
+
+	public ClobTester( String tableName ,
+			   String colName ){
+	    
+	    this.tableName = tableName;
+	    this.colName = colName;
+	    
+	}
+	
+	
+	public void testGetReaderTwice( Connection conn ) 
+	    throws SQLException, IOException {
+	    
+	    Statement st = null;
+	    ResultSet rs = null;
+	    Reader reader = null;
+
+	    try{
+		st = conn.createStatement();
+		
+		rs = st.executeQuery( "select " + 
+				      colName + " " + 
+				      "from " + 
+				      tableName );
+		rs.next();
+		
+		System.out.println("get reader from " + tableName + "." + colName + " ...");
+		reader = rs.getCharacterStream(1);
+		reader.close();
+		
+		System.out.println("get reader from " + tableName + "." + colName + "again ...");
+		reader = rs.getCharacterStream(1);
+		
+		System.out.println("Expected exception did not happen.");
+		
+	    }catch(SQLException e){
+		System.out.println("Expected exception may happen.");
+		e.printStackTrace(System.out);
+
+	    }finally{
+		if(st != null)
+		    st.close();
+		
+		if(rs != null)
+		    rs.close();
+
+		if(reader != null)
+		    reader.close();
+
+	    }
+	}
+    }
+}

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/connectionJdbc20.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/connectionJdbc20.java?rev=357435&r1=357434&r2=357435&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/connectionJdbc20.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/connectionJdbc20.java Sat Dec 17 21:15:39 2005
@@ -77,7 +77,17 @@
             load_data(connreturn);
             
 			// read the data   of each type with all the possible functions
-			ResultSet rs = stmt.executeQuery("select * from tab1");
+			ResultSet rs = stmt.executeQuery("select " + 
+							 "c1," + 
+							 "c2," + 
+							 "c3," + 
+							 "c4," + 
+							 "c5," + 
+							 "c6," + 
+							 "c1 as c1_spare," + 
+							 "c2 as c2_spare,"  +
+							 "c3 as c3_spare "  +
+							 "from tab1");
             int loop = 0;
             while(loop < 2 )
             {
@@ -87,11 +97,13 @@
                     {
                         get_using_object(rs, i);
                         get_using_string(rs, i);
-						get_using_ascii_stream(rs, i);
+			
+			get_using_ascii_stream(rs, i);
+
                         if(i < 4 ) // only c1 , c2, c3
                         {
-                            get_using_binary_stream(rs, i);
-                            get_using_bytes(rs, i);
+                            get_using_binary_stream(rs, i + 6);
+                            get_using_bytes(rs, i + 6);
                         }
                     } 
                 }
@@ -103,11 +115,21 @@
                     System.out.println("Got Different Statement Object");
                 
                 rs.close();
-			    rs = stmt.executeQuery("select * from tab1");
-                loop++;
+		rs = stmt.executeQuery("select " + 
+				       "c1," + 
+				       "c2," + 
+				       "c3," + 
+				       "c4," + 
+				       "c5," + 
+				       "c6," + 
+				       "c1 as c1_spare," + 
+				       "c2 as c2_spare,"  +
+				       "c3 as c3_spare "  +
+				       "from tab1");
+		loop++;
             }
 
-			stmt.close();
+	    stmt.close();
 
             // Try to get the connection object thro database meta data
             DatabaseMetaData dbmeta = conn.getMetaData();

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultsetStream.java
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultsetStream.java?rev=357435&r1=357434&r2=357435&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultsetStream.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultsetStream.java Sat Dec 17 21:15:39 2005
@@ -379,7 +379,11 @@
 			ResultSet rs = null;
 			
 			try{
-				st = conn.prepareStatement("select text_data from t3");
+				st = conn.prepareStatement("select " + 
+							   "text_data as text_data_col1," + 
+							   "text_data as text_data_col2 " + 
+							   "from " + 
+							   "t3");
 				rs = st.executeQuery();
 				
 				while(rs.next()){
@@ -435,7 +439,7 @@
 			Reader reader = null;
 			
 			try{
-				reader = rs.getCharacterStream(1);
+				reader = rs.getCharacterStream(2);
 
 				for(int c = reader.read();
 				    c > -1;



Mime
View raw message