db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fuzzylo...@apache.org
Subject svn commit: r179696 [5/8] - in /incubator/derby/code/trunk/java: engine/org/apache/derby/loc/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/master/DerbyNet/ testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/ testing/org/apache/derbyTesting/functionTests/master/jdk14/
Date Fri, 03 Jun 2005 01:54:33 GMT
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/procedure.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/procedure.out?rev=179696&r1=179695&r2=179696&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/procedure.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/procedure.out Thu Jun  2 18:54:29 2005
@@ -1,8 +1,8 @@
 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 dot separated list. 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 dot separated list. 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'.
 create procedure asdf language java external name java.lang.Thread.currentThread parameter style java
@@ -55,11 +55,11 @@
 call noclass()
 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 to be able to match method call java.lang.Integer.asdf(), even tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have.  It may be that the method exists, but it is not public and/or static, or that 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 to be able to match method call java.lang.Integer.equals(), even tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have.  It may be that the method exists, but it is not public and/or static, or that 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 to be able to match method call void java.lang.Runtime.getRuntime(), even tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have.  It may be that the method exists, but it is not public and/or static, or that 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.
@@ -82,7 +82,7 @@
 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.)
 call AMBIGIOUS02(?, ?)
-EXPECTED SQL Exception: (42X50) No method was found to be able to match method call org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious2(int, int, java.sql.ResultSet[]), even tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have.  It may be that the method exists, but it is not public and/or static, or that 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.
 ambigious2(int,Integer) called
 UPDATE COUNT 0
 ambigious2(Integer,int) called
@@ -189,9 +189,9 @@
 ---------------------------
 selectRows - 2 arg - 2 rs
 pass 1 got result set true
-EXPECTED : ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+EXPECTED : ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
 pass 2 got result set true
-EXPECTED : ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+EXPECTED : ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
 pass 3 got result set false
 auto commit is true
 lock count before execution 0
@@ -220,10 +220,10 @@
 lock count after next on first rs 3
 executing statement to force auto commit on open CALL statement
 lock count after statement execution 0
-Expected - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+Expected - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
 Is there a second result ? true
 lock count after first getMoreResults() 0
-Expected - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+Expected - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
 lock count after next on second rs 0
 more results (should be false) false
 lock count after second getMoreResults() 0
@@ -236,16 +236,16 @@
 6          |'012345678     
 7          |int            
 CALL IRDRS(?)
-EXPECTED SQL Exception: (42X50) No method was found to be able to match method call org.apache.derbyTesting.functionTests.util.ProcedureTest.missingDynamicParameter(int, java.sql.ResultSet[]), even tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have.  It may be that the method exists, but it is not public and/or static, or that 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 to be able to match method call org.apache.derbyTesting.functionTests.util.ProcedureTest.badDynamicParameter(int, java.sql.ResultSet[]), even tried all combinations of object and primitive types and any possible type conversion for any parameters the method call may have.  It may be that the method exists, but it is not public and/or static, or that 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
 zeroArgDynamicResult called
 UPDATE COUNT 0
 Testing too many result sets
 ... too many result sets
 selectRows - 2 arg - 2 rs
-WARNING 0100E: XX Attepmt to return too many result sets
+WARNING 0100E: XX Attempt to return too many result sets. 
 I          |B              
 ---------------------------
 2          |int            

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/procedureJdbc30.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/procedureJdbc30.out?rev=179696&r1=179695&r2=179696&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/procedureJdbc30.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/procedureJdbc30.out Thu Jun  2 18:54:29 2005
@@ -2,80 +2,80 @@
   PASS 1 got result set true
      RS (1) val 2
   PASS 2 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (2) val 3
   PASS 3 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (3) val 4
   PASS 4 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (4) val 5
   PASS 5 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (5) val 6
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
 Fetching result sets with getMoreResults(Statement.CLOSE_CURRENT_RESULT)
   PASS 1 got result set true
      RS (1) val 2
   PASS 2 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (2) val 3
   PASS 3 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (3) val 4
   PASS 4 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (4) val 5
   PASS 5 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (5) val 6
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
 Fetching result sets with getMoreResults(Statement.CLOSE_ALL_RESULTS)
   PASS 1 got result set true
      RS (1) val 2
   PASS 2 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (2) val 3
   PASS 3 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (3) val 4
   PASS 4 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (4) val 5
   PASS 5 got result set true
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (5) val 6
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
 Fetching result sets with getMoreResults(Statement.KEEP_CURRENT_RESULT)
   PASS 1 got result set true
      RS (1) val 2
@@ -108,24 +108,24 @@
      RS (2) val 3
  third with CLOSE_CURRENT_RESULT
      RS (1) val 3
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (3) val 4
  fourth with KEEP_CURRENT_RESULT
      RS (1) val 4
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (3) val 5
      RS (4) val 5
  fifth with CLOSE_ALL_RESULTS
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (5) val 6
  no more results with with KEEP_CURRENT_RESULT
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
      RS (5) val 7
 Fetching result sets with getMoreResults(Statement.KEEP_CURRENT_RESULT) and checking that cs.execute() closes them
   PASS 1 got result set true
@@ -155,11 +155,11 @@
      RS (4) val 7
      RS (5) val 7
  executing statement
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
 Fetching result sets with getMoreResults(Statement.KEEP_CURRENT_RESULT) and checking that cs.close() closes them
   PASS 1 got result set true
      RS (1) val 2
@@ -188,8 +188,8 @@
      RS (4) val 7
      RS (5) val 7
  closing statement
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-     Exception - ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+     Exception - ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions1.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions1.out?rev=179696&r1=179695&r2=179696&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions1.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions1.out Thu Jun  2 18:54:29 2005
@@ -371,7 +371,7 @@
 15         |SAM2      |ROGER     |K52 
 7          |TRUONG    |HAMID     |K55 
 ij> delete from db2test.vemp;
-ERROR 42Y24: View 'DB2TEST.VEMP' is not updatable. (Views are currently not updateable.)
+ERROR 42Y24: View 'DB2TEST.VEMP' is not updatable. (Views are currently not updatable.) 
 ij> select * from db2test.emp order by name, mgrname, dno;
 C0         |NAME      |MGRNAME   |DNO 
 --------------------------------------
@@ -2773,7 +2773,7 @@
                   where e.mgrname = e2.mgrname group by dno having
                   e2.dno in (select dno from db2test.emp  e1
                    where db2test.emp.mgrname = 'JOHN'))))) order by 2,3,4;
-ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
+ERROR 42X04: Column 'DB2TEST.EMP.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
 ij> delete from db2test.emp 
   where dno in (select dno from db2test.emp5 e5
    where e5.dno in (select dno from db2test.emp4 e4 where
@@ -2783,7 +2783,7 @@
                   where e.mgrname = e2.mgrname group by dno having
                   e2.dno in (select dno from db2test.emp  e1
                    where e.mgrname = 'JOHN')))));
-ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
+ERROR 42X04: Column 'DB2TEST.EMP.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
 ij> select * from db2test.emp order by dno, name, mgrname;
 C0         |NAME      |MGRNAME   |DNO 
 --------------------------------------
@@ -2941,7 +2941,7 @@
                   where e4.dno = e2.dno group by dno having
                   e2.dno in (select dno from db2test.emp  e1
                    where e.mgrname = 'JOHN'))))) order by 2, 3, 4;
-ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'E.NAME' is not a column in the target table.
+ERROR 42X04: Column 'E.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'E.NAME' is not a column in the target table.
 ij> delete from db2test.emp 
   where dno in (select dno from db2test.emp5 e5
    where e5.dno in (select dno from db2test.emp4 e4 where
@@ -2951,7 +2951,7 @@
                   where e4.dno = e2.dno group by dno having
                   e2.dno in (select dno from db2test.emp  e1
                    where db2test.emp.mgrname = 'JOHN')))));
-ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
+ERROR 42X04: Column 'DB2TEST.EMP.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
 ij> select * from db2test.emp order by dno, name, mgrname;
 C0         |NAME      |MGRNAME   |DNO 
 --------------------------------------
@@ -3109,7 +3109,7 @@
                   where e4.name = e2.mgrname group by dno having
                   e2.dno in (select dno from db2test.emp  e1
                    where e.mgrname = 'JOHN'))))) order by 2, 3, 4;
-ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'E.NAME' is not a column in the target table.
+ERROR 42X04: Column 'E.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'E.NAME' is not a column in the target table.
 ij> -- select should get -119;
 delete from db2test.emp 
   where dno in (select dno from db2test.emp5 e5
@@ -3120,7 +3120,7 @@
                   where e4.name = e2.mgrname group by dno having
                   e2.dno in (select dno from db2test.emp  e1
                   where db2test.emp.mgrname = 'JOHN')))));
-ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
+ERROR 42X04: Column 'DB2TEST.EMP.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
 ij> select * from db2test.emp order by dno, name, mgrname;
 C0         |NAME      |MGRNAME   |DNO 
 --------------------------------------
@@ -3278,7 +3278,7 @@
                   where e4.dno = e2.dno group by dno having
                   e2.dno in (select dno from db2test.emp  e1
                    where e.mgrname = 'JOHN'))))) order by 2, 3, 4;
-ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'E.NAME' is not a column in the target table.
+ERROR 42X04: Column 'E.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'E.NAME' is not a column in the target table.
 ij> delete from db2test.emp 
   where dno in (select dno from db2test.emp5 e5
    where e5.dno in (select dno from db2test.emp4 e4 where
@@ -3288,7 +3288,7 @@
                   where e4.dno = e2.dno group by dno having
                   e2.dno in (select dno from db2test.emp  e1
                    where e.mgrname = 'JOHN')))));
-ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
+ERROR 42X04: Column 'DB2TEST.EMP.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
 ij> select * from db2test.emp order by dno, name, mgrname;
 C0         |NAME      |MGRNAME   |DNO 
 --------------------------------------
@@ -4453,7 +4453,7 @@
 15         |SAM2      |ROGER     |K52 
 7          |TRUONG    |HAMID     |K55 
 ij> delete from db2test.vemp;
-ERROR 42Y24: View 'DB2TEST.VEMP' is not updatable. (Views are currently not updateable.)
+ERROR 42Y24: View 'DB2TEST.VEMP' is not updatable. (Views are currently not updatable.) 
 ij> select * from db2test.emp order by name, mgrname, dno;
 C0         |NAME      |MGRNAME   |DNO 
 --------------------------------------
@@ -7575,7 +7575,7 @@
                   e2.dno in (select dno from db2test.emp e1
                   where e1.name = e.mgrname and e1.mgrname = 'JOHN')))))
    order by 2,3,4;
-ERROR 42X04: Column 'E5.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'E5.NAME' is not a column in the target table.
+ERROR 42X04: Column 'E5.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'E5.NAME' is not a column in the target table.
 ij> delete from db2test.emp e
   where dno in (select dno from db2test.emp5 e5
    where e5.dno in (select dno from db2test.emp4 e4 where
@@ -7743,7 +7743,7 @@
                   where e.name = e2.mgrname group by dno having
                   e2.dno in (select dno from db2test.emp  e1
                    where e.mgrname = 'JOHN'))))) order by 2,3,4;
-ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'E.NAME' is not a column in the target table.
+ERROR 42X04: Column 'E.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'E.NAME' is not a column in the target table.
 ij> delete from db2test.emp e
   where dno in (select dno from db2test.emp5 e5
    where e5.dno in (select dno from db2test.emp4 e4 where
@@ -7911,7 +7911,7 @@
                   where e4.dno = e2.dno group by dno having
                   e2.dno in (select dno from db2test.emp  e1
                    where e.mgrname = 'JOHN'))))) order by 2,3,4;
-ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'E.NAME' is not a column in the target table.
+ERROR 42X04: Column 'E.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'E.NAME' is not a column in the target table.
 ij> delete from db2test.emp
   where dno in (select dno from db2test.emp5 e5
    where e5.dno in (select dno from db2test.emp4 e4 where
@@ -7921,7 +7921,7 @@
                   where e4.dno = e2.dno group by dno having
                   e2.dno in (select dno from db2test.emp  e1
                    where db2test.emp.mgrname = 'JOHN')))));
-ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
+ERROR 42X04: Column 'DB2TEST.EMP.NAME' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'DB2TEST.EMP.NAME' is not a column in the target table.
 ij> select * from db2test.emp order by dno, name, mgrname;
 C0         |NAME      |MGRNAME   |DNO 
 --------------------------------------

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions2.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions2.out?rev=179696&r1=179695&r2=179696&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions2.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/refActions2.out Thu Jun  2 18:54:29 2005
@@ -67,7 +67,7 @@
 0 rows inserted/updated/deleted
 ij> alter table t3 add constraint c4 foreign key (k)
                               references t2(y) on delete set null;
-ERROR 42915: Foreign  Key 'C4' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'C4' is invalid because 'the delete rule of foreign key  must be CASCADE. (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
 ij> alter table t2 drop constraint c1;
 0 rows inserted/updated/deleted
 ij> alter table t1 drop constraint c2;
@@ -173,43 +173,43 @@
 -- case sql0633-01 (t1 creation should fail)
 create table t1(a int not null primary key , b int references t1(a) ON DELETE CASCADE, 
                 c int references t1(a) ON DELETE SET NULL);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be CASCADE. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> create table tself( a int not null primary key, b int not null  unique,
                   x int references tself(a) ON DELETE RESTRICT, 
                   z int references tself(b) ON DELETE CASCADE);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "RESTRICT". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be RESTRICT. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> create table tself( a int not null primary key, b int not null  unique,
                   x int references tself(a) ON DELETE RESTRICT, 
                   z int references tself(b) ON DELETE NO ACTION);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "RESTRICT". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be RESTRICT. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> create table tself( a int not null primary key, b int not null  unique,
                   x int references tself(a) ON DELETE RESTRICT, 
                   z int references tself(b) ON DELETE SET NULL);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "RESTRICT". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be RESTRICT. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> create table tself( a int not null primary key, b int not null  unique,
                   x int references tself(a) ON DELETE NO ACTION, 
                   z int references tself(b) ON DELETE CASCADE);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "NO ACTION". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be NO ACTION. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> create table tself( a int not null primary key, b int not null  unique,
                   x int references tself(a) ON DELETE NO ACTION, 
                   z int references tself(b) ON DELETE RESTRICT);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "NO ACTION". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be NO ACTION. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> create table tself( a int not null primary key, b int not null  unique,
                   x int references tself(a) ON DELETE NO ACTION, 
                   z int references tself(b) ON DELETE SET NULL);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "NO ACTION". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be NO ACTION. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> create table tself( a int not null primary key, b int not null  unique,
                   x int references tself(a) ON DELETE CASCADE, 
                   z int references tself(b) ON DELETE SET NULL);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be CASCADE. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> create table tself( a int not null primary key, b int not null  unique,
                   x int references tself(a) ON DELETE CASCADE, 
                   z int references tself(b) ON DELETE NO ACTION);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be CASCADE. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> create table tself( a int not null primary key, b int not null  unique,
                   x int references tself(a) ON DELETE CASCADE, 
                   z int references tself(b) ON DELETE RESTRICT);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be CASCADE. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> --FOLLOWING CASES SHOULD PASS
 create table tself( a int not null primary key, b int not null  unique,
                   x int references tself(a) ON DELETE NO ACTION, 
@@ -235,13 +235,13 @@
 0 rows inserted/updated/deleted
 ij> create table t2(x int references t1(a) ON DELETE CASCADE, 
                 y int not null unique, z int references t2(y) ON DELETE SET NULL);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The referential constraint is self-referencing and the table is dependent in a relationship with a delete rule of CASCADE.)'. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be CASCADE. (The referential constraint is self-referencing and the table is dependent in a relationship with a delete rule of CASCADE.)'. 
 ij> create table t2(x int references t1(a) ON DELETE CASCADE, 
                 y int not null unique, z int references t2(y) ON DELETE NO ACTION);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The referential constraint is self-referencing and the table is dependent in a relationship with a delete rule of CASCADE.)'. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be CASCADE. (The referential constraint is self-referencing and the table is dependent in a relationship with a delete rule of CASCADE.)'. 
 ij> create table t2(x int references t1(a) ON DELETE CASCADE, 
                 y int not null unique, z int references t2(y) ON DELETE RESTRICT);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The referential constraint is self-referencing and the table is dependent in a relationship with a delete rule of CASCADE.)'. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be CASCADE. (The referential constraint is self-referencing and the table is dependent in a relationship with a delete rule of CASCADE.)'. 
 ij> --START  PASS CASES
 --These cases is to make sure we don;t throw errors for the valid cases.
 create table t2(x int references t1(a) ON DELETE CASCADE, 
@@ -327,7 +327,7 @@
 0 rows inserted/updated/deleted
 ij> alter table t3 add constraint c3 foreign key (m) 
                               references t2(y) on delete set null;
-ERROR 42915: Foreign  Key 'C3' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'C3' is invalid because 'the delete rule of foreign key  must be CASCADE. (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
 ij> alter table t2 drop constraint c1;
 0 rows inserted/updated/deleted
 ij> alter table t3 drop constraint c2;
@@ -346,7 +346,7 @@
 0 rows inserted/updated/deleted
 ij> create table t3(l int references t1(a) ON DELETE CASCADE , 
                          m int references t2(y) ON DELETE SET NULL);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be CASCADE. (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
 ij> alter table t2 drop constraint c1;
 0 rows inserted/updated/deleted
 ij> drop table t1;
@@ -382,13 +382,13 @@
 0 rows inserted/updated/deleted
 ij> create table t2(x int not null unique, y int references t2(x) ON DELETE SET NULL, 
        		                       z int references t1(a) ON DELETE CASCADE);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key can not be CASCADE. (A self-referencing constraint exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key cannot be CASCADE. (A self-referencing constraint exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '. 
 ij> create table t2(x int not null unique, y int references t2(x) ON DELETE NO ACTION, 
        		                       z int references t1(a) ON DELETE CASCADE);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key can not be CASCADE. (A self-referencing constraint exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key cannot be CASCADE. (A self-referencing constraint exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '. 
 ij> create table t2(x int not null unique, y int references t2(x) ON DELETE RESTRICT, 
        		                       z int references t1(a) ON DELETE CASCADE);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key can not be CASCADE. (A self-referencing constraint exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key cannot be CASCADE. (A self-referencing constraint exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '. 
 ij> --START  SHOULD PASS CASES
 create table t2(x int not null unique, y int references t2(x) ON DELETE CASCADE, 
        		                       z int references t1(a) ON DELETE SET NULL);
@@ -453,7 +453,7 @@
 0 rows inserted/updated/deleted
 ij> alter table t1 add constraint c1 foreign key (b)
                              references t2(x) on delete cascade;
-ERROR 42915: Foreign  Key 'C1' is invalid because 'the delete rule of foreign key can not be CASCADE. (The relationship would form a cycle that would cause a table to be delete-connected to itself. One of the existing delete rules in the cycle is not CASCADE, so this relationship may be definable if the delete rule is not CASCADE.) '. 
+ERROR 42915: Foreign  Key 'C1' is invalid because 'The delete rule of foreign key cannot be CASCADE. (The relationship would form a cycle that would cause a table to be delete-connected to itself. One of the existing delete rules in the cycle is not CASCADE, so this relationship may be definable if the delete rule is not CASCADE.) '. 
 ij> alter table t2 drop constraint c2;
 0 rows inserted/updated/deleted
 ij> drop table t1;
@@ -707,7 +707,7 @@
 0 rows inserted/updated/deleted
 ij> create table t3(l int references t1(a) ON DELETE CASCADE , 
                          m int references t2(y) ON DELETE SET NULL);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be CASCADE. (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
 ij> drop table t3 ;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T3' because it does not exist.
 ij> drop table t2 ;
@@ -782,13 +782,13 @@
 0 rows inserted/updated/deleted
 ij> alter table t3 add constraint c3 foreign key (m) 
                               references t2(y) on delete set null;
-ERROR 42915: Foreign  Key 'C3' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'C3' is invalid because 'the delete rule of foreign key  must be CASCADE. (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
 ij> alter table t2 drop constraint c1;
 0 rows inserted/updated/deleted
 ij> alter table t3 drop constraint c2;
 0 rows inserted/updated/deleted
 ij> alter table t3 drop constraint c3;
-ERROR 42X86: ALTER table failed. There is no constraint 'APP.C3' on table 'APP.T3'.
+ERROR 42X86: ALTER TABLE failed. There is no constraint 'APP.C3' on table 'APP.T3'. 
 ij> -- c3 fails; sql0632N - 3 
 alter table t2 add constraint c1 foreign key (x) 
                              references t1(a) on delete CASCADE;
@@ -804,7 +804,7 @@
 ij> alter table t3 drop constraint c2;
 0 rows inserted/updated/deleted
 ij> alter table t3 drop constraint c3;
-ERROR 42X86: ALTER table failed. There is no constraint 'APP.C3' on table 'APP.T3'.
+ERROR 42X86: ALTER TABLE failed. There is no constraint 'APP.C3' on table 'APP.T3'. 
 ij> -- passes
 alter table t2 add constraint c1 foreign key (x) 
                              references t1(a) on delete set null;
@@ -884,7 +884,7 @@
 ij> alter table t3 drop constraint c2;
 0 rows inserted/updated/deleted
 ij> alter table t3 drop constraint c3;
-ERROR 42X86: ALTER table failed. There is no constraint 'APP.C3' on table 'APP.T3'.
+ERROR 42X86: ALTER TABLE failed. There is no constraint 'APP.C3' on table 'APP.T3'. 
 ij> drop table t1;
 0 rows inserted/updated/deleted
 ij> drop table t2;
@@ -912,11 +912,11 @@
 0 rows inserted/updated/deleted
 ij> alter table t2 add constraint c2 foreign key (y)
                               references t1(b) on delete cascade;
-ERROR 42915: Foreign  Key 'C2' is invalid because 'the delete rule of foreign key can not be CASCADE. (The relationship would form a cycle that would cause a table to be delete-connected to itself. One of the existing delete rules in the cycle is not CASCADE, so this relationship may be definable if the delete rule is not CASCADE.) '. 
+ERROR 42915: Foreign  Key 'C2' is invalid because 'The delete rule of foreign key cannot be CASCADE. (The relationship would form a cycle that would cause a table to be delete-connected to itself. One of the existing delete rules in the cycle is not CASCADE, so this relationship may be definable if the delete rule is not CASCADE.) '. 
 ij> alter table t1 drop constraint c1;
 0 rows inserted/updated/deleted
 ij> alter table t2 drop constraint c2;
-ERROR 42X86: ALTER table failed. There is no constraint 'APP.C2' on table 'APP.T2'.
+ERROR 42X86: ALTER TABLE failed. There is no constraint 'APP.C2' on table 'APP.T2'. 
 ij> --c2 fails - sql0632N - reason code 2
 alter table t1 add constraint c1 foreign key (b)
                              references t2(x) on delete cascade;
@@ -927,16 +927,16 @@
 ij> alter table t1 drop constraint c1;
 0 rows inserted/updated/deleted
 ij> alter table t2 drop constraint c2;
-ERROR 42X86: ALTER table failed. There is no constraint 'APP.C2' on table 'APP.T2'.
+ERROR 42X86: ALTER TABLE failed. There is no constraint 'APP.C2' on table 'APP.T2'. 
 ij> --c1 fails - sql0634N - reason code 2
 alter table t2 add constraint c2 foreign key (y)
                               references t1(b) on delete set null;
 0 rows inserted/updated/deleted
 ij> alter table t1 add constraint c1 foreign key (b)
                              references t2(x) on delete cascade;
-ERROR 42915: Foreign  Key 'C1' is invalid because 'the delete rule of foreign key can not be CASCADE. (The relationship would form a cycle that would cause a table to be delete-connected to itself. One of the existing delete rules in the cycle is not CASCADE, so this relationship may be definable if the delete rule is not CASCADE.) '. 
+ERROR 42915: Foreign  Key 'C1' is invalid because 'The delete rule of foreign key cannot be CASCADE. (The relationship would form a cycle that would cause a table to be delete-connected to itself. One of the existing delete rules in the cycle is not CASCADE, so this relationship may be definable if the delete rule is not CASCADE.) '. 
 ij> alter table t1 drop constraint c1;
-ERROR 42X86: ALTER table failed. There is no constraint 'APP.C1' on table 'APP.T1'.
+ERROR 42X86: ALTER TABLE failed. There is no constraint 'APP.C1' on table 'APP.T1'. 
 ij> alter table t2 drop constraint c2;
 0 rows inserted/updated/deleted
 ij> -- c1 fails : column b can not contain null values
@@ -976,7 +976,7 @@
 0 rows inserted/updated/deleted
 ij> create table t2(x int references t1(a) ON DELETE CASCADE ,
                 y int references t3(l) ON DELETE RESTRICT);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be CASCADE. (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
 ij> drop table t2;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'T2' because it does not exist.
 ij> drop table t3;
@@ -1029,7 +1029,7 @@
 ij> alter table t2 drop constraint c2;
 0 rows inserted/updated/deleted
 ij> alter table t3 drop constraint c3;
-ERROR 42X86: ALTER table failed. There is no constraint 'APP.C3' on table 'APP.T3'.
+ERROR 42X86: ALTER TABLE failed. There is no constraint 'APP.C3' on table 'APP.T3'. 
 ij> --c3 should fail SQL0634N - 2 -- PROBLEMATIC CASE
 -- DELETE CONNECTED CYCLE
 alter table t1 add constraint c1 foreign key (b)
@@ -1040,13 +1040,13 @@
 0 rows inserted/updated/deleted
 ij> alter table t3 add constraint c3 foreign key (k)
                               references t2(y) on delete cascade;
-ERROR 42915: Foreign  Key 'C3' is invalid because 'the delete rule of foreign key can not be CASCADE. (The relationship would form a cycle that would cause a table to be delete-connected to itself. One of the existing delete rules in the cycle is not CASCADE, so this relationship may be definable if the delete rule is not CASCADE.) '. 
+ERROR 42915: Foreign  Key 'C3' is invalid because 'The delete rule of foreign key cannot be CASCADE. (The relationship would form a cycle that would cause a table to be delete-connected to itself. One of the existing delete rules in the cycle is not CASCADE, so this relationship may be definable if the delete rule is not CASCADE.) '. 
 ij> alter table t1 drop constraint c1;
 0 rows inserted/updated/deleted
 ij> alter table t2 drop constraint c2;
 0 rows inserted/updated/deleted
 ij> alter table t3 drop constraint c3;
-ERROR 42X86: ALTER table failed. There is no constraint 'APP.C3' on table 'APP.T3'.
+ERROR 42X86: ALTER TABLE failed. There is no constraint 'APP.C3' on table 'APP.T3'. 
 ij> --c3 should fail - SQL0634N - 2
 --DELETE CONNECTED CYCLE
 alter table t1 add constraint c1 foreign key (b)
@@ -1057,13 +1057,13 @@
 0 rows inserted/updated/deleted
 ij> alter table t3 add constraint c3 foreign key (k)
                               references t2(y) on delete cascade;
-ERROR 42915: Foreign  Key 'C3' is invalid because 'the delete rule of foreign key can not be CASCADE. (The relationship would form a cycle that would cause a table to be delete-connected to itself. One of the existing delete rules in the cycle is not CASCADE, so this relationship may be definable if the delete rule is not CASCADE.) '. 
+ERROR 42915: Foreign  Key 'C3' is invalid because 'The delete rule of foreign key cannot be CASCADE. (The relationship would form a cycle that would cause a table to be delete-connected to itself. One of the existing delete rules in the cycle is not CASCADE, so this relationship may be definable if the delete rule is not CASCADE.) '. 
 ij> alter table t1 drop constraint c1;
 0 rows inserted/updated/deleted
 ij> alter table t2 drop constraint c2;
 0 rows inserted/updated/deleted
 ij> alter table t3 drop constraint c3;
-ERROR 42X86: ALTER table failed. There is no constraint 'APP.C3' on table 'APP.T3'.
+ERROR 42X86: ALTER TABLE failed. There is no constraint 'APP.C3' on table 'APP.T3'. 
 ij> -- passes
 alter table t1 add constraint c1 foreign key (b)
                               references t3(m) on delete set null;
@@ -1126,7 +1126,7 @@
 ij> create table tself(a int not null primary key , 
                b int references tself(a) ON DELETE CASCADE,  
                c int references tself(a) ON DELETE SET NULL);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be CASCADE. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> create table tself(a int not null primary key , 
                b int references tself(a) ON DELETE SET NULL,  
                c int references tself(a) ON DELETE CASCADE);
@@ -1134,7 +1134,7 @@
 ij> create table tself(a int not null primary key , 
                b int references tself(a) ,  
                c int references tself(a) ON DELETE CASCADE);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "NO ACTION". (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be NO ACTION. (The referential constraint is self-referencing and an existing self-referencing constraint has the indicated delete rule (NO ACTION, RESTRICT or CASCADE).)'. 
 ij> create table tparent( a int not null  primary key);
 0 rows inserted/updated/deleted
 ij> --THIS ONE SHOULD PASS , but currently we are throwing ERRROR
@@ -1155,7 +1155,7 @@
 create table tself(a int not null primary key , 
                b int references tparent(a) ON DELETE CASCADE ,  
                c int references tself(a) ON DELETE SET NULL);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "CASCADE". (The referential constraint is self-referencing and the table is dependent in a relationship with a delete rule of CASCADE.)'. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'The delete rule of foreign key must be CASCADE. (The referential constraint is self-referencing and the table is dependent in a relationship with a delete rule of CASCADE.)'. 
 ij> drop table tself;
 ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TSELF' because it does not exist.
 ij> --should pass
@@ -1251,7 +1251,7 @@
 0 rows inserted/updated/deleted
 ij> create table t2(x int references t1(a) ON DELETE RESTRICT, 
                 y int not null unique, z int references t1(b) ON DELETE CASCADE);
-ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be "RESTRICT". (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
+ERROR 42915: Foreign  Key 'xxxxGENERATED-IDxxxx' is invalid because 'the delete rule of foreign key  must be RESTRICT. (The relationship would cause the table to be delete-connected to the same table through multiple relationships and such relationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).) '. 
 ij> drop table t1;
 0 rows inserted/updated/deleted
 ij> create table  t1(a int not null unique , b int not null unique);

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/savepointJdbc30.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/savepointJdbc30.out?rev=179696&r1=179695&r2=179696&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/savepointJdbc30.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/savepointJdbc30.out Thu Jun  2 18:54:29 2005
@@ -85,10 +85,10 @@
 Test 45 reuse savepoint name after rollback - should not work
 Expected Exception is A SAVEPOINT with the passed name already exists in the current transaction.
 Test 46 Cursors declared before and within the savepoint unit will be closed when rolling back the savepoint
-Expected Exception is ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-Expected Exception is ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-Expected Exception is ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
-Expected Exception is ResultSet not open, operation 'next' not permitted. Verify that autocommit is OFF.
+Expected Exception is ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+Expected Exception is ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+Expected Exception is ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
+Expected Exception is ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.
 Test 47 multiple tests for getSavepointId()
 8
 9

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schema5.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schema5.out?rev=179696&r1=179695&r2=179696&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schema5.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schema5.out Thu Jun  2 18:54:29 2005
@@ -104,7 +104,7 @@
    --   UNIQUE (C1,C2), UNIQUE (C3), UNIQUE (C2,C1))
    CREATE TABLE T0512 (C1 INT NOT NULL, C2 INT NOT NULL, C3 INT NOT NULL,
    UNIQUE (C1,C2), UNIQUE (C3), UNIQUE (C2,C1));
-ERROR 42Z93: Constraints 'xxxxGENERATED-IDxxxx' and 'xxxxGENERATED-IDxxxx' have same set of columns, which is not allowed.
+ERROR 42Z93: Constraints 'xxxxGENERATED-IDxxxx' and 'xxxxGENERATED-IDxxxx' have the same set of columns, which is not allowed. 
 ij> --0 PASS: if there was an error for a duplicate unique constraint
    -- Check for erratum which allowed recursive view definitions.
    -- Reference ISO/IEC JTC1/SC21 N6789 section 11.19 <view definition> SR4

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out?rev=179696&r1=179695&r2=179696&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/schemas.out Thu Jun  2 18:54:29 2005
@@ -91,7 +91,7 @@
 3          
 ij> -- syntax errors on catalog names
 select nocatalogs.APP.mytab.i from mytab2;
-ERROR 42X04: Column 'NOCATALOGS.APP.MYTAB' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'NOCATALOGS.APP.MYTAB' is not a column in the target table.
+ERROR 42X04: Column 'NOCATALOGS.APP.MYTAB' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'NOCATALOGS.APP.MYTAB' is not a column in the target table.
 ij> drop table mytab;
 0 rows inserted/updated/deleted
 ij> drop table APP.mytab2;
@@ -727,19 +727,19 @@
 ERROR 42X03: Column name 'I' is in more than one table in the FROM list.
 ij> -- match is against base table, but not derived column list
 select * from test.s ss (c1, c2, c3, c4) where exists (select i from test.tt);
-ERROR 42X04: Column 'I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'I' is not a column in the target table.
+ERROR 42X04: Column 'I' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'I' is not a column in the target table.
 ij> select * from test.s ss (c1, c2, c3, c4) where exists (select ss.i from test.tt);
-ERROR 42X04: Column 'SS.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'SS.I' is not a column in the target table.
+ERROR 42X04: Column 'SS.I' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'SS.I' is not a column in the target table.
 ij> -- correlation name exists at both levels, but only column match is at
 -- parent level
 select * from test.s where exists (select s.i from test.tt s);
-ERROR 42X04: Column 'S.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'S.I' is not a column in the target table.
+ERROR 42X04: Column 'S.I' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'S.I' is not a column in the target table.
 ij> -- only match is at peer level
 select * from test.s where exists (select * from test.tt) and exists (select ii from test.t);
-ERROR 42X04: Column 'II' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'II' is not a column in the target table.
+ERROR 42X04: Column 'II' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'II' is not a column in the target table.
 ij> -- correlated column in a derived table
 select * from test.s, (select * from test.tt where test.s.i = ii) a;
-ERROR 42X04: Column 'TEST.S.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'TEST.S.I' is not a column in the target table.
+ERROR 42X04: Column 'TEST.S.I' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TEST.S.I' is not a column in the target table.
 ij> -- positive tests
 -- skip levels to find match
 select * from test.s where exists (select * from test.ttt where iii = 

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/select.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/select.out?rev=179696&r1=179695&r2=179696&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/select.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/select.out Thu Jun  2 18:54:29 2005
@@ -180,7 +180,7 @@
 ij> select "S1.T1".d1 from "S1.T1", APP."S1.T1";
 ERROR 42X09: The table or alias name 'APP.S1.T1' is used more than once in the FROM list.
 ij> select SYS."S1.T1".d1 from "S1.T1";
-ERROR 42X04: Column 'SYS.S1.T1.D1' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'SYS.S1.T1.D1' is not a column in the target table.
+ERROR 42X04: Column 'SYS.S1.T1.D1' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'SYS.S1.T1.D1' is not a column in the target table.
 ij> select SYS."S1.T1".d1 from "S1.T1" t1;
-ERROR 42X04: Column 'SYS.S1.T1.D1' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'SYS.S1.T1.D1' is not a column in the target table.
+ERROR 42X04: Column 'SYS.S1.T1.D1' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'SYS.S1.T1.D1' is not a column in the target table.
 ij> 

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery.out?rev=179696&r1=179695&r2=179696&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/subquery.out Thu Jun  2 18:54:29 2005
@@ -65,7 +65,7 @@
 ERROR 42X39: Subquery is only allowed to return a single column.
 ij> -- invalid column reference in select list
 select * from s where exists (select nosuchcolumn from t);
-ERROR 42X04: Column 'NOSUCHCOLUMN' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'NOSUCHCOLUMN' is not a column in the target table.
+ERROR 42X04: Column 'NOSUCHCOLUMN' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'NOSUCHCOLUMN' is not a column in the target table.
 ij> -- multiple matches at subquery level
 select * from s where exists (select i from s, t);
 ERROR 42X03: Column name 'I' is in more than one table in the FROM list.
@@ -520,23 +520,23 @@
 ERROR 42X03: Column name 'I' is in more than one table in the FROM list.
 ij> -- match is against base table, but not derived column list
 select * from s ss (c1, c2, c3, c4, c5) where exists (select i from tt);
-ERROR 42X04: Column 'I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'I' is not a column in the target table.
+ERROR 42X04: Column 'I' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'I' is not a column in the target table.
 ij> select * from s ss (c1, c2, c3, c4, c5) where exists (select ss.i from tt);
-ERROR 42X04: Column 'SS.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'SS.I' is not a column in the target table.
+ERROR 42X04: Column 'SS.I' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'SS.I' is not a column in the target table.
 ij> -- correlation name exists at both levels, but only column match is at
 -- parent level
 select * from s where exists (select s.i from tt s);
-ERROR 42X04: Column 'S.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'S.I' is not a column in the target table.
+ERROR 42X04: Column 'S.I' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'S.I' is not a column in the target table.
 ij> -- only match is at peer level
 select * from s where exists (select * from tt) and exists (select ii from t);
-ERROR 42X04: Column 'II' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'II' is not a column in the target table.
+ERROR 42X04: Column 'II' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'II' is not a column in the target table.
 ij> select * from s where exists (select * from tt) and exists (select tt.ii from t);
-ERROR 42X04: Column 'TT.II' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'TT.II' is not a column in the target table.
+ERROR 42X04: Column 'TT.II' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'TT.II' is not a column in the target table.
 ij> -- correlated column in a derived table
 select * from s, (select * from tt where i = ii) a;
-ERROR 42X04: Column 'I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'I' is not a column in the target table.
+ERROR 42X04: Column 'I' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'I' is not a column in the target table.
 ij> select * from s, (select * from tt where s.i = ii) a;
-ERROR 42X04: Column 'S.I' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'S.I' is not a column in the target table.
+ERROR 42X04: Column 'S.I' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'S.I' is not a column in the target table.
 ij> -- positive tests
 -- simple correlated subqueries
 select (select i from tt where ii = i and ii <> 1) from s;

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/syscat.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/syscat.out?rev=179696&r1=179695&r2=179696&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/syscat.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/syscat.out Thu Jun  2 18:54:29 2005
@@ -26,7 +26,7 @@
 ij> insert into sys.systables select * from sys.systables;
 ERROR 42Y25: 'SYS.SYSTABLES' is a system table.  Users are not allowed to modify the contents of this table.
 ij> get cursor c as 'select tablename from sys.systables for update of tablename';
-ERROR 42Y90: FOR UPDATE is not permitted on this type of statement.
+ERROR 42Y90: FOR UPDATE is not permitted in this type of statement.  
 ij> -- users not allowed to do ddl in sys schema
 create table sys.usertable(c1 int);
 ERROR 42X62: 'CREATE TABLE' is not allowed in the 'SYS' schema.

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerBeforeTrig.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerBeforeTrig.out?rev=179696&r1=179695&r2=179696&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerBeforeTrig.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/triggerBeforeTrig.out Thu Jun  2 18:54:29 2005
@@ -90,7 +90,7 @@
 create trigger t1 NO CASCADE before update on x referencing old_table as oldtable for each statement mode db2sql select * from old;
 ERROR 42Y92: BEFORE triggers may only reference row transition variables/tables.
 ij> create trigger t1 NO CASCADE before update on x referencing old as oldtable for each row mode db2sql values old.x;
-ERROR 42X04: Column 'OLD.X' is not in any table in the FROM list or it appears within a join specification and is outside the scope of the join specification or it appears in a HAVING clause and is not in the GROUP BY list.  If this is a CREATE or ALTER TABLE statement then 'OLD.X' is not a column in the target table.
+ERROR 42X04: Column 'OLD.X' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'OLD.X' is not a column in the target table.
 ij> -- try some other likely uses
 create table y (x int);
 0 rows inserted/updated/deleted



Mime
View raw message