db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r393239 [2/4] - in /db/derby/code/trunk/java: drda/org/apache/derby/impl/drda/ engine/org/apache/derby/impl/jdbc/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ testing/o...
Date Tue, 11 Apr 2006 14:49:53 GMT
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/ieptests.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/ieptests.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/ieptests.out Tue Apr 11 07:49:30 2006
@@ -291,7 +291,7 @@
 ij> --file not found error should rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/nofile.del' , 
                                  null, null, null, 0) ;
-ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE04Data file not found: extinout/nofile.del : 
+ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 ij> commit;
 ij> select * from t1 ;
 A          
@@ -307,7 +307,7 @@
 ij> --table not found error should issue a implicit rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'NOTABLE' , 'extinout/t1.del' , 
                                  null, null, null, 0) ;
-ERROR XIE0M: Table 'NOTABLE' does not exist.   : 
+ERROR XIE0M: Table 'NOTABLE' does not exist.  
 ij> commit ;
 ij> select * from t1 ;
 A          
@@ -350,7 +350,7 @@
 ij> --file not found error should rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/nofile.del' , 
                                  null, null, null, 1) ;
-ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE04Data file not found: extinout/nofile.del : 
+ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 ij> commit;
 ij> select * from t1 ;
 A          
@@ -364,7 +364,7 @@
 ij> --table not found error should issue a implicit rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'NOTABLE' , 'extinout/t1.del' , 
                                  null, null, null, 1) ;
-ERROR XIE0M: Table 'NOTABLE' does not exist.   : 
+ERROR XIE0M: Table 'NOTABLE' does not exist.  
 ij> commit ;
 ij> ---check IMPORT_DATA calls commit/rollback
 select * from t1 ;
@@ -401,7 +401,7 @@
 ij> --file not found error should rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1', 'A' , '1'  , 'extinout/nofile.del' , 
                                  null, null, null, 0) ;
-ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE04Data file not found: extinout/nofile.del : 
+ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 ij> commit;
 ij> select * from t1 ;
 A          
@@ -417,7 +417,7 @@
 ij> --table not found error should issue a implicit rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'NOTABLE' , 'A' , '1', 'extinout/t1.del' , 
                                  null, null, null, 1) ;
-ERROR XIE0M: Table 'NOTABLE' does not exist.   : 
+ERROR XIE0M: Table 'NOTABLE' does not exist.  
 ij> commit ;
 ij> select * from t1 ;
 A          
@@ -453,7 +453,7 @@
 ij> --following import will back , but should not have any impact on inserts
 call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1', 'A' , '1'  , 'extinout/nofile.del' , 
                                  null, null, null, 0) ;
-ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE04Data file not found: extinout/nofile.del : 
+ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 ij> select * from t1 ;
 A          
 -----
@@ -563,7 +563,7 @@
 3 rows inserted/updated/deleted
 ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ALLTYPES' , 'extinout/alltypes.del' , 
                                  null, null, null, 1) ;
-ERROR 38000: The exception 'SQL Exception: Bulk insert replace is not permitted on 'APP.ALLTYPES' because it has an enabled trigger (TRIG_IMPORT).' was thrown while evaluating an expression.::SQLSTATE: 42Z08Bulk insert replace is not permitted on 'APP.ALLTYPES' because it has an enabled trigger (TRIG_IMPORT). : 
+ERROR 38000: The exception 'SQL Exception: Bulk insert replace is not permitted on 'APP.ALLTYPES' because it has an enabled trigger (TRIG_IMPORT).' was thrown while evaluating an expression.
 ij> select count(*) from alltypes;
 1          
 -----
@@ -606,7 +606,7 @@
 Statement executed.
 ij> --following import should fail becuase of inserting into identity column.
 CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'TABLE1', 'extinout/import.del',null, null, null,1);
-ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'C2'.' was thrown while evaluating an expression.::SQLSTATE: 42Z23Attempt to modify an identity column 'C2'.  : 
+ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'C2'.' was thrown while evaluating an expression.
 ij> --following import should be succesful
 CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(NULL, 'TABLE1', 'C1,C3,C4' , '1,3,4', 'extinout/import.del',null, null, null,1);
 Statement executed.
@@ -623,7 +623,7 @@
                                  null, null, null) ;
 Statement executed.
 ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'TABLE1', 'extinout/import.del',null, null, null,1);
-ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'C2'.' was thrown while evaluating an expression.::SQLSTATE: 42Z23Attempt to modify an identity column 'C2'.  : 
+ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'C2'.' was thrown while evaluating an expression.
 ij> select * from table1;
 C1 |C2 |C3 |C4  
 -----
@@ -645,7 +645,7 @@
 Statement executed.
 ij> --replace should fail because of dependent table
 CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'PARENT', 'extinout/parent.del',null, null, null,1);
-ERROR 38000: The exception 'SQL Exception: INSERT on table 'PARENT' caused a violation of foreign key constraint 'xxxxGENERATED-IDxxxx' for key (3).  The statement has been rolled back.' was thrown while evaluating an expression.::SQLSTATE: 23503INSERT on table 'PARENT' caused a violation of foreign key constraint 'xxxxGENERATED-IDxxxx' for key (3).  The statement has been rolled back. : 
+ERROR 38000: The exception 'SQL Exception: INSERT on table 'PARENT' caused a violation of foreign key constraint 'xxxxGENERATED-IDxxxx' for key (3).  The statement has been rolled back.' was thrown while evaluating an expression.
 ij> select * from parent;
 A          
 -----
@@ -726,7 +726,7 @@
 ij> create table dest_by_default(i int generated by default as identity);
 0 rows inserted/updated/deleted
 ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','DEST_ALWAYS','extinout/autoinc.dat',null,null,null,0);
-ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'I'.' was thrown while evaluating an expression.::SQLSTATE: 42Z23Attempt to modify an identity column 'I'.  : 
+ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'I'.' was thrown while evaluating an expression.
 ij> select * from dest_always;
 I          
 -----
@@ -747,7 +747,7 @@
 ij> create table dest_by_default(i int generated by default as identity);
 0 rows inserted/updated/deleted
 ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','DEST_ALWAYS','extinout/autoinc.dat',null,null,null,1);
-ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'I'.' was thrown while evaluating an expression.::SQLSTATE: 42Z23Attempt to modify an identity column 'I'.  : 
+ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'I'.' was thrown while evaluating an expression.
 ij> select * from dest_always;
 I          
 -----
@@ -777,13 +777,13 @@
 1 row inserted/updated/deleted
 ij> --following export should fail because schema name is not matching the way it is defined using delimited quotes.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('GROUP', 'Order' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Schema 'GROUP' does not exist' was thrown while evaluating an expression.::SQLSTATE: 42Y07Schema 'GROUP' does not exist : 
+ERROR 38000: The exception 'SQL Exception: Schema 'GROUP' does not exist' was thrown while evaluating an expression.
 ij> --following export should fail because table name is not matching the way it is defined in the quotes.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('Group', 'ORDER' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Table 'Group.ORDER' does not exist.' was thrown while evaluating an expression.::SQLSTATE: 42X05Table 'Group.ORDER' does not exist. : 
+ERROR 38000: The exception 'SQL Exception: Table 'Group.ORDER' does not exist.' was thrown while evaluating an expression.
 ij> --following export should fail because of unquoted table name that is a reserved word.
 call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from "Group".Order' , 'extinout/order.dat' ,    null , null , null ) ;
-ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "Order" at line 1, column 23.' was thrown while evaluating an expression.::SQLSTATE: 42X01Syntax error: Encountered "Order" at line 1, column 23. : 
+ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "Order" at line 1, column 23.' was thrown while evaluating an expression.
 ij> --following exports should pass.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('Group', 'Order' , 'extinout/order.dat', null, null, null) ;
 Statement executed.
@@ -794,19 +794,19 @@
 Statement executed.
 ij> --following import should fail because schema name is not matching the way it is defined using delimited quotes.
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('GROUP', 'Order' , 'extinout/order.dat', null, null, null, 0) ;
-ERROR XIE0M: Table 'GROUP.Order' does not exist.   : 
+ERROR XIE0M: Table 'GROUP.Order' does not exist.  
 ij> --following import should fail because table name is not matching the way it is defined in the quotes.
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('Group', 'ORDER' , 'extinout/order.dat', null, null, null, 0) ;
-ERROR XIE0M: Table 'Group.ORDER' does not exist.   : 
+ERROR XIE0M: Table 'Group.ORDER' does not exist.  
 ij> --following import should fail because table name is not matching the way it is defined in the quotes.
 call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'ORDER' , null , null ,   'extinout/order.dat'   , null , null , null, 1) ;
-ERROR XIE0M: Table 'Group.ORDER' does not exist.   : 
+ERROR XIE0M: Table 'Group.ORDER' does not exist.  
 ij> --following import should fail because column name is not matching the way it is defined in the quotes.
 call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'Order' , 'DELETE, ITEMNAME' , '2, 3' ,   'extinout/order.dat'   , null , null , null, 1) ;
-ERROR XIE08: There is no column named: DELETE.   : 
+ERROR XIE08: There is no column named: DELETE.  
 ij> --following import should fail because undelimited column name is not in upper case.
 call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'Order' , 'delete, itemName' , '2, 3' ,   'extinout/order.dat'   , null , null , null, 1) ;
-ERROR XIE08: There is no column named: itemName.   : 
+ERROR XIE08: There is no column named: itemName.  
 ij> --following imports should pass
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('Group', 'Order' , 'extinout/order.dat', null, null, null, 0) ;
 Statement executed.
@@ -860,25 +860,25 @@
 1 row inserted/updated/deleted
 ij> --following export should fail because schema name is not in upper case.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('inventory', 'ORDERTABLE' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Schema 'inventory' does not exist' was thrown while evaluating an expression.::SQLSTATE: 42Y07Schema 'inventory' does not exist : 
+ERROR 38000: The exception 'SQL Exception: Schema 'inventory' does not exist' was thrown while evaluating an expression.
 ij> --following export should fail because table name is not in upper case.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ordertable' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Table 'INVENTORY.ordertable' does not exist.' was thrown while evaluating an expression.::SQLSTATE: 42X05Table 'INVENTORY.ordertable' does not exist. : 
+ERROR 38000: The exception 'SQL Exception: Table 'INVENTORY.ordertable' does not exist.' was thrown while evaluating an expression.
 ij> --following export should pass.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ORDERTABLE' , 'extinout/order.dat', null, null, null) ;
 Statement executed.
 ij> --following import should fail because schema name is not in upper case
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('inventory', 'ORDERTABLE' , 'extinout/order.dat', null, null, null, 0) ;
-ERROR XIE0M: Table 'inventory.ORDERTABLE' does not exist.   : 
+ERROR XIE0M: Table 'inventory.ORDERTABLE' does not exist.  
 ij> --following import should fail because table name is not in upper case.
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('INVENTORY', 'ordertable' , 'extinout/order.dat', null, null, null, 0) ;
-ERROR XIE0M: Table 'INVENTORY.ordertable' does not exist.   : 
+ERROR XIE0M: Table 'INVENTORY.ordertable' does not exist.  
 ij> --following import should fail because table name is not in upper case .
 call SYSCS_UTIL.SYSCS_IMPORT_DATA('INVENTORY', 'ordertable' , null , null ,   'extinout/order.dat'   , null , null , null, 1) ;
-ERROR XIE0M: Table 'INVENTORY.ordertable' does not exist.   : 
+ERROR XIE0M: Table 'INVENTORY.ordertable' does not exist.  
 ij> --following import should fail because column name is not in upper case.
 call SYSCS_UTIL.SYSCS_IMPORT_DATA('INVENTORY', 'ORDERTABLE' , 'amount, ITEMNAME' , '2, 3' ,   'extinout/order.dat'   , null , null , null, 1) ;
-ERROR XIE08: There is no column named: amount.   : 
+ERROR XIE08: There is no column named: amount.  
 ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('INVENTORY', 'ORDERTABLE' , null , null ,   'extinout/order.dat'   , null , null , null, 1) ;
 Statement executed.
 ij> select * from inventory.orderTable;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/importExport.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/importExport.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/importExport.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/importExport.out Tue Apr 11 07:49:30 2006
@@ -1,8 +1,8 @@
 Test importExport starting
 testing non-existing data file
-The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE04Data file not found: extinout/Z.dat : 
+The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 testing null data file
-The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE05Data file cannot be null.  : 
+The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 testing empty table
 testing empty table with Delimited format
 testing empty table import Field/Char Delimiters
@@ -13,11 +13,11 @@
 testing IE with delimiters(%, &) and Cp1252
 testing IE with delimiters(%, &) and UTF-16
 testing IE with delimiters(^, #) and WRONG ENCODEINGH
-An IOException occurred while writing data to the file. : 
+An IOException occurred while writing data to the file.
 testing datatypes that does not have Export Supprt
-Column 'C1' in the table is of type BLOB, it is not supported by the import/export feature.    : 
-Column 'C1' in the table is of type BLOB, it is not supported by the import/export feature.    : 
-The exception 'SQL Exception: Read endOfFile at unexpected place on line 2.' was thrown while evaluating an expression.::SQLSTATE: XIE0ERead endOfFile at unexpected place on line 2. : 
+Column 'C1' in the table is of type BLOB, it is not supported by the import/export feature.   
+Column 'C1' in the table is of type BLOB, it is not supported by the import/export feature.   
+The exception 'SQL Exception: Read endOfFile at unexpected place on line 2.' was thrown while evaluating an expression.
 PASS: finished testing import and export
 PASS: teardown complete
 PASS: finished cleaning up the temporary objects from database

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/procedure.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/procedure.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/procedure.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/procedure.out Tue Apr 11 07:49:30 2006
@@ -1,95 +1,95 @@
 testNegative
 create procedure asdf() language java external name 'asdfasdf' parameter style java
-EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with EXTERNAL NAME 'asdfasdf' because it is not a list separated by periods. The expected format is <full java path>.<method name>. : 
+EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with EXTERNAL NAME 'asdfasdf' because it is not a list separated by periods. The expected format is <full java path>.<method name>.
 create procedure asdf() language java external name 'asdfasdf.' parameter style java
-EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with EXTERNAL NAME 'asdfasdf.' because it is not a list separated by periods. The expected format is <full java path>.<method name>. : 
+EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with EXTERNAL NAME 'asdfasdf.' because it is not a list separated by periods. The expected format is <full java path>.<method name>.
 create procedure a23456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789() language java external name 'asdf.asdf' parameter style java
-EXPECTED SQL Exception: (42622) The name 'A23456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789' is too long. The maximum length is '128'. : 
+EXPECTED SQL Exception: (42622) The name 'A23456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789' is too long. The maximum length is '128'.
 create procedure asdf language java external name java.lang.Thread.currentThread parameter style java
-EXPECTED SQL Exception: (42X01) Syntax error: Encountered "language" at line 1, column 23. : 
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "language" at line 1, column 23.
 CREATE PROCEDURE ASSEMBLY_PARTS (IN ASSEMBLY_NUM INTEGER, OUT NUM_PARTS INTEGER, OUT COST DOUBLE) EXTERNAL NAME 'parts!assembly' DYNAMIC RESULT SETS 1 LANGUAGE C PARAMETER STYLE GENERAL
-EXPECTED SQL Exception: (42X01) Syntax error: Encountered "C" at line 1, column 161. : 
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "C" at line 1, column 161.
 create procedure sys.proc1() language java external name 'java.lang.System.gc' parameter style java
-EXPECTED SQL Exception: (42X62) 'CREATE PROCEDURE' is not allowed in the 'SYS' schema. : 
+EXPECTED SQL Exception: (42X62) 'CREATE PROCEDURE' is not allowed in the 'SYS' schema.
 create procedure noclass() language java external name 'asdf.asdf' parameter style java language java
-EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'LANGUAGE' clause are present. : 
+EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'LANGUAGE' clause are present.
 create procedure noclass() parameter style java language java external name 'asdf.asdf' parameter style java
-EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'PARAMETER STYLE' clause are present. : 
+EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'PARAMETER STYLE' clause are present.
 create procedure noclass() external name 'asdf.xxxx' language java external name 'asdf.asdf' parameter style java
-EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'EXTERNAL NAME' clause are present. : 
+EXPECTED SQL Exception: (42613) Multiple or conflicting keywords involving the 'EXTERNAL NAME' clause are present.
 create procedure noclass() parameter style java language java external name 'asdf.asdf' parameter style derby_rs_collection
-EXPECTED SQL Exception: (42X01) Syntax error: Encountered "derby_rs_collection" at line 1, column 105. : 
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "derby_rs_collection" at line 1, column 105.
 create procedure missing01()
-EXPECTED SQL Exception: (42X01) Syntax error: Encountered "<EOF>" at line 1, column 28. : 
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "<EOF>" at line 1, column 28.
 create procedure missing02() language java
-EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME. : 
+EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME.
 create procedure missing03() language java parameter style java
-EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME. : 
+EXPECTED SQL Exception: (42X01) Syntax error: EXTERNAL NAME.
 create procedure missing04() language java external name 'foo.bar'
-EXPECTED SQL Exception: (42X01) Syntax error: PARAMETER STYLE. : 
+EXPECTED SQL Exception: (42X01) Syntax error: PARAMETER STYLE.
 create procedure missing05() parameter style java
-EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. : 
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
 create procedure missing06() parameter style java external name 'foo.bar'
-EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. : 
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
 create procedure missing07() external name 'goo.bar'
-EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. : 
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
 create procedure missing08() dynamic result sets 1
-EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE. : 
+EXPECTED SQL Exception: (42X01) Syntax error: LANGUAGE.
 create procedure nullinput2() returns null on null input language java parameter style java external name 'foo.bar'
-EXPECTED SQL Exception: (42X01) Syntax error: RETURNS NULL ON NULL INPUT. : 
+EXPECTED SQL Exception: (42X01) Syntax error: RETURNS NULL ON NULL INPUT.
 create procedure NO_BLOB(IN P1 BLOB(3k)) language java parameter style java external name 'no.blob'
-EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions.  : 
+EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions. 
 create procedure NO_CLOB(IN P1 CLOB(3k)) language java parameter style java external name 'no.clob'
-EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions.  : 
+EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions. 
 create procedure NO_LVC(IN P1 LONG VARCHAR) language java parameter style java external name 'no.lvc'
-EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions.  : 
+EXPECTED SQL Exception: (42962) Long column type column or parameter 'P1' not permitted in declared global temporary tables or procedure definitions. 
 create procedure DUP_P1(IN FRED INT, OUT RON CHAR(10), IN FRED INT) language java parameter style java external name 'no.dup1'
-EXPECTED SQL Exception: (42734) Name 'FRED' specified in context 'DUP_P1' is not unique. : 
+EXPECTED SQL Exception: (42734) Name 'FRED' specified in context 'DUP_P1' is not unique.
 create procedure D2.DUP_P2(IN "FreD" INT, OUT RON CHAR(10), IN "FreD" INT) language java parameter style java external name 'no.dup2'
-EXPECTED SQL Exception: (42734) Name 'FreD' specified in context 'D2.DUP_P2' is not unique. : 
+EXPECTED SQL Exception: (42734) Name 'FreD' specified in context 'D2.DUP_P2' is not unique.
 create procedure D3.DUP_P3(IN "FRED" INT, OUT RON CHAR(10), IN fred INT) language java parameter style java external name 'no.dup3'
-EXPECTED SQL Exception: (42734) Name 'FRED' specified in context 'D3.DUP_P3' is not unique. : 
+EXPECTED SQL Exception: (42734) Name 'FRED' specified in context 'D3.DUP_P3' is not unique.
 CALL APP.NSP(?, ?)
-EXPECTED SQL Exception: (42Y03) 'APP.NSP' is not recognized as a function or procedure. : 
+EXPECTED SQL Exception: (42Y03) 'APP.NSP' is not recognized as a function or procedure.
 call syscs_util.syscs_set_database_property("foo", "bar")
-EXPECTED SQL Exception: (42X15) Column name 'foo' appears in a statement without a FROM list. : 
+EXPECTED SQL Exception: (42X15) Column name 'foo' appears in a statement without a FROM list.
 signature mismatched types
 CALL APP.SIGNATURE_BUG_DERBY_258_A(4)
-EXPECTED SQL Exception: (22005) An attempt was made to get a data value of type 'java.lang.String' from a data value of type 'INTEGER'. : 
+EXPECTED SQL Exception: (22005) An attempt was made to get a data value of type 'java.lang.String' from a data value of type 'INTEGER'.
 signature too many parameters
 VALUES APP.SIGNATURE_BUG_DERBY_258_B(4)
-EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (2) of parameters, expected 1. : 
+EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (2) of parameters, expected 1.
 signature too few parameters
 CALL APP.SIGNATURE_BUG_DERBY_258_C(4)
-EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (0) of parameters, expected 1. : 
+EXPECTED SQL Exception: (46J02) Java method signature contains incorrect number (0) of parameters, expected 1.
 signature invalid format
 CALL APP.SIGNATURE_BUG_DERBY_258_F(4)
-EXPECTED SQL Exception: (46J01) Java method signature has invalid format. : 
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
 signature invalid format
 CALL APP.SIGNATURE_BUG_DERBY_258_G(4)
-EXPECTED SQL Exception: (46J01) Java method signature has invalid format. : 
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
 signature invalid format
 CALL APP.SIGNATURE_BUG_DERBY_258_H(4)
-EXPECTED SQL Exception: (46J01) Java method signature has invalid format. : 
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
 signature invalid format
 CALL APP.SIGNATURE_BUG_DERBY_258_I(4)
-EXPECTED SQL Exception: (46J01) Java method signature has invalid format. : 
+EXPECTED SQL Exception: (46J01) Java method signature has invalid format.
 testDelayedClassChecking
 call noclass()
-EXPECTED SQL Exception: (42X51) The class 'asdf' does not exist or is inaccessible. This can happen if the class is not public.::SQLSTATE: XJ001Java exception: 'asdf: java.lang.ClassNotFoundException'. : 
+EXPECTED SQL Exception: (42X51) The class 'asdf' does not exist or is inaccessible. This can happen if the class is not public.
 call nomethod()
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call java.lang.Integer.asdf(), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. : 
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call java.lang.Integer.asdf(), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
 call notstatic()
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call java.lang.Integer.equals(), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. : 
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call java.lang.Integer.equals(), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
 call notvoid()
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call void java.lang.Runtime.getRuntime(), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. : 
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call void java.lang.Runtime.getRuntime(), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
 testDuplicates
 create procedure PROCDUP() language java external name 'failAPP.fail0' parameter style java
-EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists. : 
+EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists.
 create procedure s1.PROCDUP() language java external name 'fails1.fail0' parameter style java
-EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists. : 
+EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists.
 create procedure s2.PROCDUP() language java external name 'fails2.fail0' parameter style java
-EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists. : 
+EXPECTED SQL Exception: (X0Y68) PROCEDURE 'PROCDUP' already exists.
 DEFINED PROCEDURES FOR PROCDUP
   APP.PROCDUP AS okAPP.ok0() LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
   S1.PROCDUP AS oks1.ok0() LANGUAGE JAVA PARAMETER STYLE JAVA MODIFIES SQL DATA
@@ -100,12 +100,12 @@
   S2.PROCDUP AS oks2.ok0 type procedureNoResult
 -----
 create procedure S1.NOTYET() SPECIFIC fred language java external name 'failAPP.fail0' parameter style java
-EXPECTED SQL Exception: (0A000) Feature not implemented: SPECIFIC identifier. : 
+EXPECTED SQL Exception: (0A000) Feature not implemented: SPECIFIC identifier.
 ambigiousMethods
 call AMBIGIOUS01(?, ?)
-EXPECTED SQL Exception: (42X73) Method resolution for signature org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious1(int, java.lang.String, [Ljava.sql.ResultSet;) was ambiguous. (No single maximally specific method.) : 
+EXPECTED SQL Exception: (42X73) Method resolution for signature org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious1(int, java.lang.String, [Ljava.sql.ResultSet;) was ambiguous. (No single maximally specific method.)
 call AMBIGIOUS02(?, ?)
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious2(int, int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. : 
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious2(int, int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
 No ResultSet or update count returned
 No ResultSet or update count returned
 zeroArgProcedures
@@ -135,10 +135,10 @@
     procedureColumnIn P2 CHAR
 -----
 CALL IR()
-EXPECTED SQL Exception: (42Y03) 'IR' is not recognized as a function or procedure. : 
+EXPECTED SQL Exception: (42Y03) 'IR' is not recognized as a function or procedure.
 No ResultSet or update count returned
 No ResultSet or update count returned
-EXPECTED SQL Exception: The exception 'SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'.' was thrown while evaluating an expression.::SQLSTATE: 23505The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'. : 
+EXPECTED SQL Exception: The exception 'SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'.' was thrown while evaluating an expression.
 No ResultSet or update count returned
 No ResultSet or update count returned
 No ResultSet or update count returned
@@ -154,14 +154,14 @@
 5 |ir2            
 6 |'012345678     
 CALL IR2(2, 'no way')
-EXPECTED SQL Exception: (38000) The exception 'SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'.' was thrown while evaluating an expression.::SQLSTATE: 23505The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'. : 
+EXPECTED SQL Exception: (38000) The exception 'SQL Exception: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'xxxxGENERATED-IDxxxx' defined on 'T1'.' was thrown while evaluating an expression.
 CALL IR2(?, 'no way')
-EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized. : 
+EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
 CALL IR2(2, ?)
-EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized. : 
+EXPECTED SQL Exception: (07000) At least one parameter to the current statement is uninitialized.
 dynamicResultSets - parameter style JAVA
 create procedure DRS(p1 int) parameter style JAVA READS SQL DATA dynamic result sets -1 language java external name 'org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows'
-EXPECTED SQL Exception: (42X01) Syntax error: Encountered "-" at line 1, column 86. : 
+EXPECTED SQL Exception: (42X01) Syntax error: Encountered "-" at line 1, column 86.
 DEFINED PROCEDURES FOR DRS
   APP.DRS AS org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows(IN P1 INTEGER) LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA DYNAMIC RESULT SETS 1
 DATABASE METATDATA PROCEDURES FOR DRS
@@ -169,9 +169,9 @@
     procedureColumnIn P1 INTEGER
 -----
 CALL DRS()
-EXPECTED SQL Exception: (42Y03) 'DRS' is not recognized as a function or procedure. : 
+EXPECTED SQL Exception: (42Y03) 'DRS' is not recognized as a function or procedure.
 CALL DRS(?,?)
-EXPECTED SQL Exception: (42Y03) 'DRS' is not recognized as a function or procedure. : 
+EXPECTED SQL Exception: (42Y03) 'DRS' is not recognized as a function or procedure.
 I |B              
 -----
 3 |int            
@@ -205,9 +205,9 @@
 6 |'012345678     
 7 |int            
 CALL IRDRS(?)
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.missingDynamicParameter(int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. : 
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.missingDynamicParameter(int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
 CALL rsi(?)
-EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.badDynamicParameter(int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible. : 
+EXPECTED SQL Exception: (42X50) No method was found that matched the method call org.apache.derbyTesting.functionTests.util.ProcedureTest.badDynamicParameter(int, java.sql.ResultSet[]), tried all combinations of object and primitive types and any possible type conversion for any  parameters the method call may have. The method might exist but it is not public and/or static, or the parameter types are not method invocation convertible.
 no dynamic result sets
 No ResultSet or update count returned
 Testing too many result sets
@@ -283,8 +283,8 @@
     procedureColumnInOut P_INOUT SMALLINT
     procedureColumnOut P_OUT SMALLINT
 -----
-EXPECTED SQL Exception: (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'. : 
-EXPECTED SQL Exception: (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'. : 
+EXPECTED SQL Exception: (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'.
+EXPECTED SQL Exception: (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'.
 p_inout 9 p_out 6
 p_inout 9 null?false p_out 6 null?false
 p_inout 9 null?false p_out 6 null?false
@@ -331,7 +331,7 @@
 OP4 11.3 >28.30< null ? false
 No ResultSet or update count returned
 OP4 39.345 >56.34< null ? false
-EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2). : 
+EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2).
 No ResultSet or update count returned
 OP4 49.345 >66.34< null ? false
 EXPECTED SQL Exception: Invalid argument: parameter index 2 is not an OUT or INOUT parameter.
@@ -351,7 +351,7 @@
 OP4INOUT 14+23.5 >37.50< null ? false
 No ResultSet or update count returned
 OP4INOUT 9+23.505 >32.50< null ? false
-EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2). : 
+EXPECTED SQL Exception: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,2).
 EXPECTED SQL Exception: BigDecimal conversion exception [ibm][db2][jcc][converters] Overflow occurred during numeric data type conversion of "102.33".. See attached Throwable.
 EXPECTED SQL Exception: (<NULL>) Invalid operation: parameter 1 not set or registered
 SQL Control
@@ -858,7 +858,7 @@
          CREATE SCHEMA S-UPDATE 0-EXECUTE OK
          DROP SCHEMA SQL-UPDATE 0-EXECUTE OK
 CALL SQLCONTROL3_0 (?, ?, ?, ?, ?, ?, ?)
-EXPECTED SQL Exception: (07004) Parameter 1 is an OUT procedure parameter and must be registered with CallableStatement.registerOutParameter before execution. : 
+EXPECTED SQL Exception: (07004) Parameter 1 is an OUT procedure parameter and must be registered with CallableStatement.registerOutParameter before execution.
 literals
 DEFINED PROCEDURES FOR TY_%
   LITT.TY_BIGINT AS org.apache.derbyTesting.functionTests.util.ProcedureTest.literalTest(IN P1 BIGINT,OUT P2 VARCHAR(256)) LANGUAGE JAVA PARAMETER STYLE JAVA NO SQL
@@ -895,11 +895,11 @@
     procedureColumnIn P1 VARCHAR
     procedureColumnOut P2 VARCHAR
 -----
-CALL LITT.TY_SMALLINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'. : 
-CALL LITT.TY_INTEGER (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'int'. : 
-CALL LITT.TY_BIGINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'long'. : 
-CALL LITT.TY_REAL (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'float'. : 
-CALL LITT.TY_DOUBLE (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'. : 
+CALL LITT.TY_SMALLINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'short'.
+CALL LITT.TY_INTEGER (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'int'.
+CALL LITT.TY_BIGINT (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'long'.
+CALL LITT.TY_REAL (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'float'.
+CALL LITT.TY_DOUBLE (null, ?) (39004) A NULL value cannot be passed to a method which takes a parameter of primitive type 'double'.
 CALL LITT.TY_DECIMAL (null, ?)=>NULL<
 CALL LITT.TY_CHAR (null, ?)=>NULL<
 CALL LITT.TY_VARCHAR (null, ?)=>NULL<
@@ -909,30 +909,30 @@
 CALL LITT.TY_REAL (12, ?)=>12.0<
 CALL LITT.TY_DOUBLE (12, ?)=>12.0<
 CALL LITT.TY_DECIMAL (12, ?)=>12.00<
-CALL LITT.TY_CHAR (12, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'INTEGER'.  : 
-CALL LITT.TY_VARCHAR (12, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'INTEGER'.  : 
+CALL LITT.TY_CHAR (12, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'INTEGER'. 
+CALL LITT.TY_VARCHAR (12, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'INTEGER'. 
 CALL LITT.TY_SMALLINT (23.43e1, ?)=>234<
 CALL LITT.TY_INTEGER (23.43e1, ?)=>234<
 CALL LITT.TY_BIGINT (23.43e1, ?)=>234<
 CALL LITT.TY_REAL (23.43e1, ?)=>234.3<
 CALL LITT.TY_DOUBLE (23.43e1, ?)=>234.3<
 CALL LITT.TY_DECIMAL (23.43e1, ?)=>234.30<
-CALL LITT.TY_CHAR (23.43e1, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DOUBLE'.  : 
-CALL LITT.TY_VARCHAR (23.43e1, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DOUBLE'.  : 
+CALL LITT.TY_CHAR (23.43e1, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DOUBLE'. 
+CALL LITT.TY_VARCHAR (23.43e1, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DOUBLE'. 
 CALL LITT.TY_SMALLINT (176.3, ?)=>176<
 CALL LITT.TY_INTEGER (176.3, ?)=>176<
 CALL LITT.TY_BIGINT (176.3, ?)=>176<
 CALL LITT.TY_REAL (176.3, ?)=>176.3<
 CALL LITT.TY_DOUBLE (176.3, ?)=>176.3<
 CALL LITT.TY_DECIMAL (176.3, ?)=>176.30<
-CALL LITT.TY_CHAR (176.3, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DECIMAL'.  : 
-CALL LITT.TY_VARCHAR (176.3, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DECIMAL'.  : 
-CALL LITT.TY_SMALLINT ('12.34', ?) (42821) Columns of type 'SMALLINT' cannot hold values of type 'CHAR'.  : 
-CALL LITT.TY_INTEGER ('12.34', ?) (42821) Columns of type 'INTEGER' cannot hold values of type 'CHAR'.  : 
-CALL LITT.TY_BIGINT ('12.34', ?) (42821) Columns of type 'BIGINT' cannot hold values of type 'CHAR'.  : 
-CALL LITT.TY_REAL ('12.34', ?) (42821) Columns of type 'REAL' cannot hold values of type 'CHAR'.  : 
-CALL LITT.TY_DOUBLE ('12.34', ?) (42821) Columns of type 'DOUBLE' cannot hold values of type 'CHAR'.  : 
-CALL LITT.TY_DECIMAL ('12.34', ?) (42821) Columns of type 'DECIMAL' cannot hold values of type 'CHAR'.  : 
+CALL LITT.TY_CHAR (176.3, ?) (42821) Columns of type 'CHAR' cannot hold values of type 'DECIMAL'. 
+CALL LITT.TY_VARCHAR (176.3, ?) (42821) Columns of type 'VARCHAR' cannot hold values of type 'DECIMAL'. 
+CALL LITT.TY_SMALLINT ('12.34', ?) (42821) Columns of type 'SMALLINT' cannot hold values of type 'CHAR'. 
+CALL LITT.TY_INTEGER ('12.34', ?) (42821) Columns of type 'INTEGER' cannot hold values of type 'CHAR'. 
+CALL LITT.TY_BIGINT ('12.34', ?) (42821) Columns of type 'BIGINT' cannot hold values of type 'CHAR'. 
+CALL LITT.TY_REAL ('12.34', ?) (42821) Columns of type 'REAL' cannot hold values of type 'CHAR'. 
+CALL LITT.TY_DOUBLE ('12.34', ?) (42821) Columns of type 'DOUBLE' cannot hold values of type 'CHAR'. 
+CALL LITT.TY_DECIMAL ('12.34', ?) (42821) Columns of type 'DECIMAL' cannot hold values of type 'CHAR'. 
 CALL LITT.TY_CHAR ('12.34', ?)=>12.34     <
 CALL LITT.TY_VARCHAR ('12.34', ?)=>12.34<
 JIRA-491 Successful.

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/blobclob4BLOB.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/blobclob4BLOB.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/blobclob4BLOB.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/blobclob4BLOB.out Tue Apr 11 07:49:30 2006
@@ -421,7 +421,7 @@
 START: clobTest53
 clobTest53 finished
 START: clobTest54
-EXPECTED SQLSTATE(22018): Invalid character string format for type INTEGER. : 
+EXPECTED SQLSTATE(22018): Invalid character string format for type INTEGER.
 end clobTest54
 START: clobTest6
  negative tests for clob.getSubstring won't run  for network server  until 5243 is fixed
@@ -710,7 +710,7 @@
 START: blobTest53
 blobTest53 finished
 START: blobTest54
-EXPECTED SQLSTATE(XCL12): An attempt was made to put a data value of type 'byte[]' into a data value of type 'INTEGER'. : 
+EXPECTED SQLSTATE(XCL12): An attempt was made to put a data value of type 'byte[]' into a data value of type 'INTEGER'.
 START: blobTest6
 EXPECTED SQLSTATE(XJ070): Negative or zero position argument '0' passed in a Blob or Clob method.
 EXPECTED SQLSTATE(XJ071): Zero or negative length argument '-76' passed in a BLOB or CLOB method.
@@ -763,9 +763,9 @@
 clobTestSelfDestructive2 finished
 START: clobNegativeTest_Derby265
 -----
-EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'java.sql.String' from an InputStream.::SQLSTATE: XJ001Java exception: 'ERROR 40XD0: Container has been closed: java.io.IOException'. : 
+EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'java.sql.String' from an InputStream.
 START: blobTestNegativeTest_Derby265
 -----
-EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'BLOB' from an InputStream.::SQLSTATE: XJ001Java exception: 'ERROR 40XD0: Container has been closed: java.io.IOException'. : 
+EXPECTED SQLSTATE(XCL30): An IOException was thrown when reading a 'BLOB' from an InputStream.
 FINISHED TEST blobclob :-)
 Test blobclob finished

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/checkSecMgr.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/checkSecMgr.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/checkSecMgr.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/checkSecMgr.out Tue Apr 11 07:49:30 2006
@@ -1,4 +1,4 @@
 testIllegalPropertySet
 execute the procedure setting illegal property
 Expected Security Exception
-ERROR 38000: The exception 'java.security.AccessControlException: access denied (java.util.PropertyPermission notAllowed write)' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: 'access denied (java.util.PropertyPermission notAllowed write): java.security.AccessControlException'. : 
+ERROR 38000: The exception 'java.security.AccessControlException: access denied (java.util.PropertyPermission notAllowed write)' was thrown while evaluating an expression.

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/ieptests.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/ieptests.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/ieptests.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/ieptests.out Tue Apr 11 07:49:30 2006
@@ -291,7 +291,7 @@
 ij> --file not found error should rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/nofile.del' , 
                                  null, null, null, 0) ;
-ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE04Data file not found: extinout/nofile.del : 
+ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 ij> commit;
 ij> select * from t1 ;
 A          
@@ -307,7 +307,7 @@
 ij> --table not found error should issue a implicit rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'NOTABLE' , 'extinout/t1.del' , 
                                  null, null, null, 0) ;
-ERROR XIE0M: Table 'NOTABLE' does not exist.   : 
+ERROR XIE0M: Table 'NOTABLE' does not exist.  
 ij> commit ;
 ij> select * from t1 ;
 A          
@@ -350,7 +350,7 @@
 ij> --file not found error should rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'T1' , 'extinout/nofile.del' , 
                                  null, null, null, 1) ;
-ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE04Data file not found: extinout/nofile.del : 
+ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 ij> commit;
 ij> select * from t1 ;
 A          
@@ -364,7 +364,7 @@
 ij> --table not found error should issue a implicit rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'NOTABLE' , 'extinout/t1.del' , 
                                  null, null, null, 1) ;
-ERROR XIE0M: Table 'NOTABLE' does not exist.   : 
+ERROR XIE0M: Table 'NOTABLE' does not exist.  
 ij> commit ;
 ij> ---check IMPORT_DATA calls commit/rollback
 select * from t1 ;
@@ -401,7 +401,7 @@
 ij> --file not found error should rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1', 'A' , '1'  , 'extinout/nofile.del' , 
                                  null, null, null, 0) ;
-ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE04Data file not found: extinout/nofile.del : 
+ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 ij> commit;
 ij> select * from t1 ;
 A          
@@ -417,7 +417,7 @@
 ij> --table not found error should issue a implicit rollback 
 call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'NOTABLE' , 'A' , '1', 'extinout/t1.del' , 
                                  null, null, null, 1) ;
-ERROR XIE0M: Table 'NOTABLE' does not exist.   : 
+ERROR XIE0M: Table 'NOTABLE' does not exist.  
 ij> commit ;
 ij> select * from t1 ;
 A          
@@ -453,7 +453,7 @@
 ij> --following import will back , but should not have any impact on inserts
 call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'T1', 'A' , '1'  , 'extinout/nofile.del' , 
                                  null, null, null, 0) ;
-ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE04Data file not found: extinout/nofile.del : 
+ERROR 38000: The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 ij> select * from t1 ;
 A          
 -----
@@ -563,7 +563,7 @@
 3 rows inserted/updated/deleted
 ij> call SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'ALLTYPES' , 'extinout/alltypes.del' , 
                                  null, null, null, 1) ;
-ERROR 38000: The exception 'SQL Exception: Bulk insert replace is not permitted on 'APP.ALLTYPES' because it has an enabled trigger (TRIG_IMPORT).' was thrown while evaluating an expression.::SQLSTATE: 42Z08Bulk insert replace is not permitted on 'APP.ALLTYPES' because it has an enabled trigger (TRIG_IMPORT). : 
+ERROR 38000: The exception 'SQL Exception: Bulk insert replace is not permitted on 'APP.ALLTYPES' because it has an enabled trigger (TRIG_IMPORT).' was thrown while evaluating an expression.
 ij> select count(*) from alltypes;
 1          
 -----
@@ -606,7 +606,7 @@
 Statement executed.
 ij> --following import should fail becuase of inserting into identity column.
 CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'TABLE1', 'extinout/import.del',null, null, null,1);
-ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'C2'.' was thrown while evaluating an expression.::SQLSTATE: 42Z23Attempt to modify an identity column 'C2'.  : 
+ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'C2'.' was thrown while evaluating an expression.
 ij> --following import should be succesful
 CALL SYSCS_UTIL.SYSCS_IMPORT_DATA(NULL, 'TABLE1', 'C1,C3,C4' , '1,3,4', 'extinout/import.del',null, null, null,1);
 Statement executed.
@@ -623,7 +623,7 @@
                                  null, null, null) ;
 Statement executed.
 ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'TABLE1', 'extinout/import.del',null, null, null,1);
-ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'C2'.' was thrown while evaluating an expression.::SQLSTATE: 42Z23Attempt to modify an identity column 'C2'.  : 
+ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'C2'.' was thrown while evaluating an expression.
 ij> select * from table1;
 C1 |C2 |C3 |C4  
 -----
@@ -645,7 +645,7 @@
 Statement executed.
 ij> --replace should fail because of dependent table
 CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE(NULL, 'PARENT', 'extinout/parent.del',null, null, null,1);
-ERROR 38000: The exception 'SQL Exception: INSERT on table 'PARENT' caused a violation of foreign key constraint 'xxxxGENERATED-IDxxxx' for key (3).  The statement has been rolled back.' was thrown while evaluating an expression.::SQLSTATE: 23503INSERT on table 'PARENT' caused a violation of foreign key constraint 'xxxxGENERATED-IDxxxx' for key (3).  The statement has been rolled back. : 
+ERROR 38000: The exception 'SQL Exception: INSERT on table 'PARENT' caused a violation of foreign key constraint 'xxxxGENERATED-IDxxxx' for key (3).  The statement has been rolled back.' was thrown while evaluating an expression.
 ij> select * from parent;
 A          
 -----
@@ -726,7 +726,7 @@
 ij> create table dest_by_default(i int generated by default as identity);
 0 rows inserted/updated/deleted
 ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','DEST_ALWAYS','extinout/autoinc.dat',null,null,null,0);
-ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'I'.' was thrown while evaluating an expression.::SQLSTATE: 42Z23Attempt to modify an identity column 'I'.  : 
+ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'I'.' was thrown while evaluating an expression.
 ij> select * from dest_always;
 I          
 -----
@@ -747,7 +747,7 @@
 ij> create table dest_by_default(i int generated by default as identity);
 0 rows inserted/updated/deleted
 ij> CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE('APP','DEST_ALWAYS','extinout/autoinc.dat',null,null,null,1);
-ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'I'.' was thrown while evaluating an expression.::SQLSTATE: 42Z23Attempt to modify an identity column 'I'.  : 
+ERROR 38000: The exception 'SQL Exception: Attempt to modify an identity column 'I'.' was thrown while evaluating an expression.
 ij> select * from dest_always;
 I          
 -----
@@ -777,13 +777,13 @@
 1 row inserted/updated/deleted
 ij> --following export should fail because schema name is not matching the way it is defined using delimited quotes.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('GROUP', 'Order' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Schema 'GROUP' does not exist' was thrown while evaluating an expression.::SQLSTATE: 42Y07Schema 'GROUP' does not exist : 
+ERROR 38000: The exception 'SQL Exception: Schema 'GROUP' does not exist' was thrown while evaluating an expression.
 ij> --following export should fail because table name is not matching the way it is defined in the quotes.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('Group', 'ORDER' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Table 'Group.ORDER' does not exist.' was thrown while evaluating an expression.::SQLSTATE: 42X05Table 'Group.ORDER' does not exist. : 
+ERROR 38000: The exception 'SQL Exception: Table 'Group.ORDER' does not exist.' was thrown while evaluating an expression.
 ij> --following export should fail because of unquoted table name that is a reserved word.
 call SYSCS_UTIL.SYSCS_EXPORT_QUERY('select * from "Group".Order' , 'extinout/order.dat' ,    null , null , null ) ;
-ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "Order" at line 1, column 23.' was thrown while evaluating an expression.::SQLSTATE: 42X01Syntax error: Encountered "Order" at line 1, column 23. : 
+ERROR 38000: The exception 'SQL Exception: Syntax error: Encountered "Order" at line 1, column 23.' was thrown while evaluating an expression.
 ij> --following exports should pass.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('Group', 'Order' , 'extinout/order.dat', null, null, null) ;
 Statement executed.
@@ -794,19 +794,19 @@
 Statement executed.
 ij> --following import should fail because schema name is not matching the way it is defined using delimited quotes.
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('GROUP', 'Order' , 'extinout/order.dat', null, null, null, 0) ;
-ERROR XIE0M: Table 'GROUP.Order' does not exist.   : 
+ERROR XIE0M: Table 'GROUP.Order' does not exist.  
 ij> --following import should fail because table name is not matching the way it is defined in the quotes.
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('Group', 'ORDER' , 'extinout/order.dat', null, null, null, 0) ;
-ERROR XIE0M: Table 'Group.ORDER' does not exist.   : 
+ERROR XIE0M: Table 'Group.ORDER' does not exist.  
 ij> --following import should fail because table name is not matching the way it is defined in the quotes.
 call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'ORDER' , null , null ,   'extinout/order.dat'   , null , null , null, 1) ;
-ERROR XIE0M: Table 'Group.ORDER' does not exist.   : 
+ERROR XIE0M: Table 'Group.ORDER' does not exist.  
 ij> --following import should fail because column name is not matching the way it is defined in the quotes.
 call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'Order' , 'DELETE, ITEMNAME' , '2, 3' ,   'extinout/order.dat'   , null , null , null, 1) ;
-ERROR XIE08: There is no column named: DELETE.   : 
+ERROR XIE08: There is no column named: DELETE.  
 ij> --following import should fail because undelimited column name is not in upper case.
 call SYSCS_UTIL.SYSCS_IMPORT_DATA('Group', 'Order' , 'delete, itemName' , '2, 3' ,   'extinout/order.dat'   , null , null , null, 1) ;
-ERROR XIE08: There is no column named: itemName.   : 
+ERROR XIE08: There is no column named: itemName.  
 ij> --following imports should pass
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('Group', 'Order' , 'extinout/order.dat', null, null, null, 0) ;
 Statement executed.
@@ -860,25 +860,25 @@
 1 row inserted/updated/deleted
 ij> --following export should fail because schema name is not in upper case.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('inventory', 'ORDERTABLE' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Schema 'inventory' does not exist' was thrown while evaluating an expression.::SQLSTATE: 42Y07Schema 'inventory' does not exist : 
+ERROR 38000: The exception 'SQL Exception: Schema 'inventory' does not exist' was thrown while evaluating an expression.
 ij> --following export should fail because table name is not in upper case.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ordertable' , 'extinout/order.dat', null, null, null) ;
-ERROR 38000: The exception 'SQL Exception: Table 'INVENTORY.ordertable' does not exist.' was thrown while evaluating an expression.::SQLSTATE: 42X05Table 'INVENTORY.ordertable' does not exist. : 
+ERROR 38000: The exception 'SQL Exception: Table 'INVENTORY.ordertable' does not exist.' was thrown while evaluating an expression.
 ij> --following export should pass.
 call SYSCS_UTIL.SYSCS_EXPORT_TABLE ('INVENTORY', 'ORDERTABLE' , 'extinout/order.dat', null, null, null) ;
 Statement executed.
 ij> --following import should fail because schema name is not in upper case
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('inventory', 'ORDERTABLE' , 'extinout/order.dat', null, null, null, 0) ;
-ERROR XIE0M: Table 'inventory.ORDERTABLE' does not exist.   : 
+ERROR XIE0M: Table 'inventory.ORDERTABLE' does not exist.  
 ij> --following import should fail because table name is not in upper case.
 call SYSCS_UTIL.SYSCS_IMPORT_TABLE ('INVENTORY', 'ordertable' , 'extinout/order.dat', null, null, null, 0) ;
-ERROR XIE0M: Table 'INVENTORY.ordertable' does not exist.   : 
+ERROR XIE0M: Table 'INVENTORY.ordertable' does not exist.  
 ij> --following import should fail because table name is not in upper case .
 call SYSCS_UTIL.SYSCS_IMPORT_DATA('INVENTORY', 'ordertable' , null , null ,   'extinout/order.dat'   , null , null , null, 1) ;
-ERROR XIE0M: Table 'INVENTORY.ordertable' does not exist.   : 
+ERROR XIE0M: Table 'INVENTORY.ordertable' does not exist.  
 ij> --following import should fail because column name is not in upper case.
 call SYSCS_UTIL.SYSCS_IMPORT_DATA('INVENTORY', 'ORDERTABLE' , 'amount, ITEMNAME' , '2, 3' ,   'extinout/order.dat'   , null , null , null, 1) ;
-ERROR XIE08: There is no column named: amount.   : 
+ERROR XIE08: There is no column named: amount.  
 ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA('INVENTORY', 'ORDERTABLE' , null , null ,   'extinout/order.dat'   , null , null , null, 1) ;
 Statement executed.
 ij> select * from inventory.orderTable;

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/importExport.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/importExport.out?rev=393239&r1=393238&r2=393239&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/importExport.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/jdk16/importExport.out Tue Apr 11 07:49:30 2006
@@ -1,8 +1,8 @@
 Test importExport starting
 testing non-existing data file
-The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE04Data file not found: extinout/Z.dat : 
+The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 testing null data file
-The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.::SQLSTATE: 38000The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.::SQLSTATE: XJ001Java exception: ': java.lang.reflect.InvocationTargetException'.::SQLSTATE: XIE05Data file cannot be null.  : 
+The exception 'SQL Exception: The exception 'java.lang.reflect.InvocationTargetException' was thrown while evaluating an expression.' was thrown while evaluating an expression.
 testing empty table
 testing empty table with Delimited format
 testing empty table import Field/Char Delimiters
@@ -13,11 +13,11 @@
 testing IE with delimiters(%, &) and Cp1252
 testing IE with delimiters(%, &) and UTF-16
 testing IE with delimiters(^, #) and WRONG ENCODEINGH
-An IOException occurred while writing data to the file. : 
+An IOException occurred while writing data to the file.
 testing datatypes that does not have Export Supprt
-Column 'C1' in the table is of type BLOB, it is not supported by the import/export feature.    : 
-Column 'C1' in the table is of type BLOB, it is not supported by the import/export feature.    : 
-The exception 'SQL Exception: Read endOfFile at unexpected place on line 2.' was thrown while evaluating an expression.::SQLSTATE: XIE0ERead endOfFile at unexpected place on line 2. : 
+Column 'C1' in the table is of type BLOB, it is not supported by the import/export feature.   
+Column 'C1' in the table is of type BLOB, it is not supported by the import/export feature.   
+The exception 'SQL Exception: Read endOfFile at unexpected place on line 2.' was thrown while evaluating an expression.
 PASS: finished testing import and export
 PASS: teardown complete
 PASS: finished cleaning up the temporary objects from database



Mime
View raw message