Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 72880 invoked from network); 3 Jun 2005 02:01:42 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 3 Jun 2005 02:01:42 -0000 Received: (qmail 88370 invoked by uid 500); 3 Jun 2005 02:01:41 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 88346 invoked by uid 500); 3 Jun 2005 02:01:41 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 88333 invoked by uid 500); 3 Jun 2005 02:01:40 -0000 Delivered-To: apmail-incubator-derby-cvs@incubator.apache.org Received: (qmail 88330 invoked by uid 99); 3 Jun 2005 02:01:40 -0000 X-ASF-Spam-Status: No, hits=-9.8 required=10.0 tests=ALL_TRUSTED,NO_REAL_NAME X-Spam-Check-By: apache.org Received: from minotaur.apache.org (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.28) with SMTP; Thu, 02 Jun 2005 19:01:35 -0700 Received: (qmail 70941 invoked by uid 65534); 3 Jun 2005 01:54:47 -0000 Message-ID: <20050603015447.70939.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable 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 -0000 To: derby-cvs@incubator.apache.org From: fuzzylogic@apache.org X-Mailer: svnmailer-1.0.0-dev X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/procedure.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/procedure.out?rev=3D179696&r1= =3D179695&r2=3D179696&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/procedure.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/procedure.out Thu Jun 2 18:54:29 2005 @@ -1,8 +1,8 @@ testNegative create procedure asdf() language java external name 'asdfasdf' parameter s= tyle java -EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with= EXTERNAL NAME 'asdfasdf' because it is not a dot separated list. The expec= ted format is . . +EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with= EXTERNAL NAME 'asdfasdf' because it is not a list separated by periods. Th= e expected format is .. 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 expe= cted format is . . +EXPECTED SQL Exception: (42Y04) Cannot create a procedure or function with= EXTERNAL NAME 'asdfasdf.' because it is not a list separated by periods. T= he expected format is .. create procedure a23456789012345678901234567890123456789012345678901234567= 890123456789012345678901234567890123456789012345678901234567890123456789() = language java external name 'asdf.asdf' parameter style java EXPECTED SQL Exception: (42622) The name 'A2345678901234567890123456789012= 345678901234567890123456789012345678901234567890123456789012345678901234567= 8901234567890123456789' is too long. The maximum length is '128'. create procedure asdf language java external name java.lang.Thread.current= Thread parameter style java @@ -55,11 +55,11 @@ call noclass() EXPECTED SQL Exception: (42X51) The class 'asdf' does not exist or is inac= cessible. This can happen if the class is not public. call nomethod() -EXPECTED SQL Exception: (42X50) No method was found to be able to match me= thod call java.lang.Integer.asdf(), even tried all combinations of object a= nd 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 publ= ic and/or static, or that the parameter types are not method invocation con= vertible. +EXPECTED SQL Exception: (42X50) No method was found that matched the metho= d call java.lang.Integer.asdf(), tried all combinations of object and primi= tive 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, o= r the parameter types are not method invocation convertible. call notstatic() -EXPECTED SQL Exception: (42X50) No method was found to be able to match me= thod call java.lang.Integer.equals(), even tried all combinations of object= and primitive types and any possible type conversion for any parameters th= e method call may have. It may be that the method exists, but it is not pu= blic and/or static, or that the parameter types are not method invocation c= onvertible. +EXPECTED SQL Exception: (42X50) No method was found that matched the metho= d call java.lang.Integer.equals(), tried all combinations of object and pri= mitive types and any possible type conversion for any parameters the metho= d 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 me= thod call void java.lang.Runtime.getRuntime(), even tried all combinations = of object and primitive types and any possible type conversion for any para= meters 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 inv= ocation convertible. +EXPECTED SQL Exception: (42X50) No method was found that matched the metho= d call void java.lang.Runtime.getRuntime(), tried all combinations of objec= t 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/o= r static, or the parameter types are not method invocation convertible. testDuplicates create procedure PROCDUP() language java external name 'failAPP.fail0' par= ameter 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.St= ring, [Ljava.sql.ResultSet;) was ambiguous. (No single maximally specific m= ethod.) call AMBIGIOUS02(?, ?) -EXPECTED SQL Exception: (42X50) No method was found to be able to match me= thod call org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigiou= s2(int, int, java.sql.ResultSet[]), even tried all combinations of object a= nd 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 publ= ic and/or static, or that the parameter types are not method invocation con= vertible. +EXPECTED SQL Exception: (42X50) No method was found that matched the metho= d call org.apache.derbyTesting.functionTests.util.ProcedureTest.ambigious2(= int, int, java.sql.ResultSet[]), tried all combinations of object and primi= tive 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, o= r 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 =20 7 |int =20 CALL IRDRS(?) -EXPECTED SQL Exception: (42X50) No method was found to be able to match me= thod call org.apache.derbyTesting.functionTests.util.ProcedureTest.missingD= ynamicParameter(int, java.sql.ResultSet[]), even tried all combinations of = object and primitive types and any possible type conversion for any paramet= ers 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 invoca= tion convertible. +EXPECTED SQL Exception: (42X50) No method was found that matched the metho= d call org.apache.derbyTesting.functionTests.util.ProcedureTest.missingDyna= micParameter(int, java.sql.ResultSet[]), tried all combinations of object a= nd 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 s= tatic, or the parameter types are not method invocation convertible. CALL rsi(?) -EXPECTED SQL Exception: (42X50) No method was found to be able to match me= thod call org.apache.derbyTesting.functionTests.util.ProcedureTest.badDynam= icParameter(int, java.sql.ResultSet[]), even tried all combinations of obje= ct 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 metho= d call org.apache.derbyTesting.functionTests.util.ProcedureTest.badDynamicP= arameter(int, java.sql.ResultSet[]), tried all combinations of object and p= rimitive types and any possible type conversion for any parameters the met= hod call may have. The method might exist but it is not public and/or stati= c, or the parameter types are not method invocation convertible. no dynamic result sets zeroArgDynamicResult called UPDATE COUNT 0 Testing too many result sets =2E.. 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.=20 I |B =20 --------------------------- 2 |int =20 Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/procedureJdbc30.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/procedureJdbc30.out?rev=3D1796= 96&r1=3D179695&r2=3D179696&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/procedureJdbc30.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/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. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (2) val 3 PASS 3 got result set true - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (3) val 4 PASS 4 got result set true - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (4) val 5 PASS 5 got result set true - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (5) val 6 - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y 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. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (2) val 3 PASS 3 got result set true - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (3) val 4 PASS 4 got result set true - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (4) val 5 PASS 5 got result set true - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (5) val 6 - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y 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. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (2) val 3 PASS 3 got result set true - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (3) val 4 PASS 4 got result set true - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (4) val 5 PASS 5 got result set true - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (5) val 6 - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y 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. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y 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. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y 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. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (5) val 6 no more results with with KEEP_CURRENT_RESULT - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. RS (5) val 7 Fetching result sets with getMoreResults(Statement.KEEP_CURRENT_RESULT) an= d 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. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. Fetching result sets with getMoreResults(Statement.KEEP_CURRENT_RESULT) an= d 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. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. - Exception - ResultSet not open, operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. + Exception - ResultSet not open. Operation 'next' not permitted. Verif= y that autocommit is OFF. Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/refActions1.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/refActions1.out?rev=3D179696&r= 1=3D179695&r2=3D179696&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/refActions1.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/refActions1.out Thu Jun 2 18:54:29 2005 @@ -371,7 +371,7 @@ 15 |SAM2 |ROGER |K52=20 7 |TRUONG |HAMID |K55=20 ij> delete from db2test.vemp; -ERROR 42Y24: View 'DB2TEST.VEMP' is not updatable. (Views are currently no= t updateable.) +ERROR 42Y24: View 'DB2TEST.VEMP' is not updatable. (Views are currently no= t updatable.)=20 ij> select * from db2test.emp order by name, mgrname, dno; C0 |NAME |MGRNAME |DNO=20 -------------------------------------- @@ -2773,7 +2773,7 @@ where e.mgrname =3D e2.mgrname group by dno having e2.dno in (select dno from db2test.emp e1 where db2test.emp.mgrname =3D 'JOHN'))))) order by 2,3,= 4; -ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM lis= t 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 GROU= P 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 F= ROM 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 GRO= UP 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=20 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 =3D e2.mgrname group by dno having e2.dno in (select dno from db2test.emp e1 where e.mgrname =3D 'JOHN'))))); -ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM lis= t 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 GROU= P 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 F= ROM 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 GRO= UP 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=20 -------------------------------------- @@ -2941,7 +2941,7 @@ where e4.dno =3D e2.dno group by dno having e2.dno in (select dno from db2test.emp e1 where e.mgrname =3D 'JOHN'))))) order by 2, 3, 4; -ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it ap= pears within a join specification and is outside the scope of the join spec= ification 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 colum= n in the target table. +ERROR 42X04: Column 'E.NAME' is either not in any table in the FROM list o= r 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 colu= mn in the target table. ij> delete from db2test.emp=20 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 =3D e2.dno group by dno having e2.dno in (select dno from db2test.emp e1 where db2test.emp.mgrname =3D 'JOHN'))))); -ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM lis= t 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 GROU= P 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 F= ROM 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 GRO= UP 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=20 -------------------------------------- @@ -3109,7 +3109,7 @@ where e4.name =3D e2.mgrname group by dno having e2.dno in (select dno from db2test.emp e1 where e.mgrname =3D 'JOHN'))))) order by 2, 3, 4; -ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it ap= pears within a join specification and is outside the scope of the join spec= ification 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 colum= n in the target table. +ERROR 42X04: Column 'E.NAME' is either not in any table in the FROM list o= r 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 colu= mn in the target table. ij> -- select should get -119; delete from db2test.emp=20 where dno in (select dno from db2test.emp5 e5 @@ -3120,7 +3120,7 @@ where e4.name =3D e2.mgrname group by dno having e2.dno in (select dno from db2test.emp e1 where db2test.emp.mgrname =3D 'JOHN'))))); -ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM lis= t 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 GROU= P 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 F= ROM 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 GRO= UP 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=20 -------------------------------------- @@ -3278,7 +3278,7 @@ where e4.dno =3D e2.dno group by dno having e2.dno in (select dno from db2test.emp e1 where e.mgrname =3D 'JOHN'))))) order by 2, 3, 4; -ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it ap= pears within a join specification and is outside the scope of the join spec= ification 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 colum= n in the target table. +ERROR 42X04: Column 'E.NAME' is either not in any table in the FROM list o= r 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 colu= mn in the target table. ij> delete from db2test.emp=20 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 =3D e2.dno group by dno having e2.dno in (select dno from db2test.emp e1 where e.mgrname =3D 'JOHN'))))); -ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM lis= t 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 GROU= P 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 F= ROM 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 GRO= UP 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=20 -------------------------------------- @@ -4453,7 +4453,7 @@ 15 |SAM2 |ROGER |K52=20 7 |TRUONG |HAMID |K55=20 ij> delete from db2test.vemp; -ERROR 42Y24: View 'DB2TEST.VEMP' is not updatable. (Views are currently no= t updateable.) +ERROR 42Y24: View 'DB2TEST.VEMP' is not updatable. (Views are currently no= t updatable.)=20 ij> select * from db2test.emp order by name, mgrname, dno; C0 |NAME |MGRNAME |DNO=20 -------------------------------------- @@ -7575,7 +7575,7 @@ e2.dno in (select dno from db2test.emp e1 where e1.name =3D e.mgrname and e1.mgrname =3D 'JOHN')))= )) order by 2,3,4; -ERROR 42X04: Column 'E5.NAME' is not in any table in the FROM list or it a= ppears within a join specification and is outside the scope of the join spe= cification 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 col= umn 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 lis= t=2E 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 =3D e2.mgrname group by dno having e2.dno in (select dno from db2test.emp e1 where e.mgrname =3D 'JOHN'))))) order by 2,3,4; -ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it ap= pears within a join specification and is outside the scope of the join spec= ification 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 colum= n in the target table. +ERROR 42X04: Column 'E.NAME' is either not in any table in the FROM list o= r 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 colu= mn 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 =3D e2.dno group by dno having e2.dno in (select dno from db2test.emp e1 where e.mgrname =3D 'JOHN'))))) order by 2,3,4; -ERROR 42X04: Column 'E.NAME' is not in any table in the FROM list or it ap= pears within a join specification and is outside the scope of the join spec= ification 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 colum= n in the target table. +ERROR 42X04: Column 'E.NAME' is either not in any table in the FROM list o= r 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 colu= mn 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 =3D e2.dno group by dno having e2.dno in (select dno from db2test.emp e1 where db2test.emp.mgrname =3D 'JOHN'))))); -ERROR 42X04: Column 'DB2TEST.EMP.NAME' is not in any table in the FROM lis= t 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 GROU= P 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 F= ROM 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 GRO= UP 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=20 -------------------------------------- Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/refActions2.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/refActions2.out?rev=3D179696&r= 1=3D179695&r2=3D179696&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/refActions2.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/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 fore= ign key must be "CASCADE". (The relationship would cause the table to be d= elete-connected to the same table through multiple relationships and such r= elationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE= )=2E) '.=20 +ERROR 42915: Foreign Key 'C4' is invalid because 'the delete rule of fore= ign key must be CASCADE. (The relationship would cause the table to be del= ete-connected to the same table through multiple relationships and such rel= ationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).= ) '.=20 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 DEL= ETE CASCADE,=20 c int references t1(a) ON DELETE SET NULL); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "CASCADE". (The referential constraint i= s self-referencing and an existing self-referencing constraint has the indi= cated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be CASCADE. (The referential constraint is s= elf-referencing and an existing self-referencing constraint has the indicat= ed delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 ij> create table tself( a int not null primary key, b int not null unique, x int references tself(a) ON DELETE RESTRICT,=20 z int references tself(b) ON DELETE CASCADE); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "RESTRICT". (The referential constraint = is self-referencing and an existing self-referencing constraint has the ind= icated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be RESTRICT. (The referential constraint is = self-referencing and an existing self-referencing constraint has the indica= ted delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 ij> create table tself( a int not null primary key, b int not null unique, x int references tself(a) ON DELETE RESTRICT,=20 z int references tself(b) ON DELETE NO ACTION); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "RESTRICT". (The referential constraint = is self-referencing and an existing self-referencing constraint has the ind= icated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be RESTRICT. (The referential constraint is = self-referencing and an existing self-referencing constraint has the indica= ted delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 ij> create table tself( a int not null primary key, b int not null unique, x int references tself(a) ON DELETE RESTRICT,=20 z int references tself(b) ON DELETE SET NULL); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "RESTRICT". (The referential constraint = is self-referencing and an existing self-referencing constraint has the ind= icated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be RESTRICT. (The referential constraint is = self-referencing and an existing self-referencing constraint has the indica= ted delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 ij> create table tself( a int not null primary key, b int not null unique, x int references tself(a) ON DELETE NO ACTION,=20 z int references tself(b) ON DELETE CASCADE); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "NO ACTION". (The referential constraint= is self-referencing and an existing self-referencing constraint has the in= dicated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be NO ACTION. (The referential constraint is= self-referencing and an existing self-referencing constraint has the indic= ated delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 ij> create table tself( a int not null primary key, b int not null unique, x int references tself(a) ON DELETE NO ACTION,=20 z int references tself(b) ON DELETE RESTRICT); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "NO ACTION". (The referential constraint= is self-referencing and an existing self-referencing constraint has the in= dicated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be NO ACTION. (The referential constraint is= self-referencing and an existing self-referencing constraint has the indic= ated delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 ij> create table tself( a int not null primary key, b int not null unique, x int references tself(a) ON DELETE NO ACTION,=20 z int references tself(b) ON DELETE SET NULL); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "NO ACTION". (The referential constraint= is self-referencing and an existing self-referencing constraint has the in= dicated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be NO ACTION. (The referential constraint is= self-referencing and an existing self-referencing constraint has the indic= ated delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 ij> create table tself( a int not null primary key, b int not null unique, x int references tself(a) ON DELETE CASCADE,=20 z int references tself(b) ON DELETE SET NULL); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "CASCADE". (The referential constraint i= s self-referencing and an existing self-referencing constraint has the indi= cated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be CASCADE. (The referential constraint is s= elf-referencing and an existing self-referencing constraint has the indicat= ed delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 ij> create table tself( a int not null primary key, b int not null unique, x int references tself(a) ON DELETE CASCADE,=20 z int references tself(b) ON DELETE NO ACTION); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "CASCADE". (The referential constraint i= s self-referencing and an existing self-referencing constraint has the indi= cated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be CASCADE. (The referential constraint is s= elf-referencing and an existing self-referencing constraint has the indicat= ed delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 ij> create table tself( a int not null primary key, b int not null unique, x int references tself(a) ON DELETE CASCADE,=20 z int references tself(b) ON DELETE RESTRICT); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "CASCADE". (The referential constraint i= s self-referencing and an existing self-referencing constraint has the indi= cated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be CASCADE. (The referential constraint is s= elf-referencing and an existing self-referencing constraint has the indicat= ed delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 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,=20 @@ -235,13 +235,13 @@ 0 rows inserted/updated/deleted ij> create table t2(x int references t1(a) ON DELETE CASCADE,=20 y int not null unique, z int references t2(y) ON DELETE SE= T NULL); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "CASCADE". (The referential constraint i= s self-referencing and the table is dependent in a relationship with a dele= te rule of CASCADE.)'.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be CASCADE. (The referential constraint is s= elf-referencing and the table is dependent in a relationship with a delete = rule of CASCADE.)'.=20 ij> create table t2(x int references t1(a) ON DELETE CASCADE,=20 y int not null unique, z int references t2(y) ON DELETE NO= ACTION); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "CASCADE". (The referential constraint i= s self-referencing and the table is dependent in a relationship with a dele= te rule of CASCADE.)'.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be CASCADE. (The referential constraint is s= elf-referencing and the table is dependent in a relationship with a delete = rule of CASCADE.)'.=20 ij> create table t2(x int references t1(a) ON DELETE CASCADE,=20 y int not null unique, z int references t2(y) ON DELETE RE= STRICT); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "CASCADE". (The referential constraint i= s self-referencing and the table is dependent in a relationship with a dele= te rule of CASCADE.)'.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be CASCADE. (The referential constraint is s= elf-referencing and the table is dependent in a relationship with a delete = rule of CASCADE.)'.=20 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,=20 @@ -327,7 +327,7 @@ 0 rows inserted/updated/deleted ij> alter table t3 add constraint c3 foreign key (m)=20 references t2(y) on delete set null; -ERROR 42915: Foreign Key 'C3' is invalid because 'the delete rule of fore= ign key must be "CASCADE". (The relationship would cause the table to be d= elete-connected to the same table through multiple relationships and such r= elationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE= )=2E) '.=20 +ERROR 42915: Foreign Key 'C3' is invalid because 'the delete rule of fore= ign key must be CASCADE. (The relationship would cause the table to be del= ete-connected to the same table through multiple relationships and such rel= ationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).= ) '.=20 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 ,=20 m int references t2(y) ON DELETE SET NULL); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "CASCADE". (The relationship would cause= the table to be delete-connected to the same table through multiple relati= onships and such relationships must have the same delete rule (NO ACTION, R= ESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be CASCADE. (The relationship would cause t= he table to be delete-connected to the same table through multiple relation= ships and such relationships must have the same delete rule (NO ACTION, RES= TRICT or CASCADE).) '.=20 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 DELET= E SET NULL,=20 z int references t1(a) ON DELETE CASCADE); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key can not be CASCADE. (A self-referencing constrain= t exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key cannot be CASCADE. (A self-referencing constraint= exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '.=20 ij> create table t2(x int not null unique, y int references t2(x) ON DELET= E NO ACTION,=20 z int references t1(a) ON DELETE CASCADE); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key can not be CASCADE. (A self-referencing constrain= t exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key cannot be CASCADE. (A self-referencing constraint= exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '.=20 ij> create table t2(x int not null unique, y int references t2(x) ON DELET= E RESTRICT,=20 z int references t1(a) ON DELETE CASCADE); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key can not be CASCADE. (A self-referencing constrain= t exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key cannot be CASCADE. (A self-referencing constraint= exists with a delete rule of SET NULL, NO ACTION or RESTRICT.) '.=20 ij> --START SHOULD PASS CASES create table t2(x int not null unique, y int references t2(x) ON DELETE CA= SCADE,=20 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 fore= ign 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 i= f the delete rule is not CASCADE.) '.=20 +ERROR 42915: Foreign Key 'C1' is invalid because 'The delete rule of fore= ign 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.) '.=20 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 ,=20 m int references t2(y) ON DELETE SET NULL); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "CASCADE". (The relationship would cause= the table to be delete-connected to the same table through multiple relati= onships and such relationships must have the same delete rule (NO ACTION, R= ESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be CASCADE. (The relationship would cause t= he table to be delete-connected to the same table through multiple relation= ships and such relationships must have the same delete rule (NO ACTION, RES= TRICT or CASCADE).) '.=20 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)=20 references t2(y) on delete set null; -ERROR 42915: Foreign Key 'C3' is invalid because 'the delete rule of fore= ign key must be "CASCADE". (The relationship would cause the table to be d= elete-connected to the same table through multiple relationships and such r= elationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE= )=2E) '.=20 +ERROR 42915: Foreign Key 'C3' is invalid because 'the delete rule of fore= ign key must be CASCADE. (The relationship would cause the table to be del= ete-connected to the same table through multiple relationships and such rel= ationships must have the same delete rule (NO ACTION, RESTRICT or CASCADE).= ) '.=20 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'.=20 ij> -- c3 fails; sql0632N - 3=20 alter table t2 add constraint c1 foreign key (x)=20 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'.=20 ij> -- passes alter table t2 add constraint c1 foreign key (x)=20 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'.=20 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 fore= ign 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 i= f the delete rule is not CASCADE.) '.=20 +ERROR 42915: Foreign Key 'C2' is invalid because 'The delete rule of fore= ign 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.) '.=20 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'.=20 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'.=20 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 fore= ign 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 i= f the delete rule is not CASCADE.) '.=20 +ERROR 42915: Foreign Key 'C1' is invalid because 'The delete rule of fore= ign 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.) '.=20 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'.=20 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 d= elete rule of foreign key must be "CASCADE". (The relationship would cause= the table to be delete-connected to the same table through multiple relati= onships and such relationships must have the same delete rule (NO ACTION, R= ESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be CASCADE. (The relationship would cause t= he table to be delete-connected to the same table through multiple relation= ships and such relationships must have the same delete rule (NO ACTION, RES= TRICT or CASCADE).) '.=20 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'.=20 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 fore= ign 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 i= f the delete rule is not CASCADE.) '.=20 +ERROR 42915: Foreign Key 'C3' is invalid because 'The delete rule of fore= ign 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.) '.=20 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'.=20 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 fore= ign 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 i= f the delete rule is not CASCADE.) '.=20 +ERROR 42915: Foreign Key 'C3' is invalid because 'The delete rule of fore= ign 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.) '.=20 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'.=20 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 ,=20 b int references tself(a) ON DELETE CASCADE, =20 c int references tself(a) ON DELETE SET NULL); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "CASCADE". (The referential constraint i= s self-referencing and an existing self-referencing constraint has the indi= cated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be CASCADE. (The referential constraint is s= elf-referencing and an existing self-referencing constraint has the indicat= ed delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 ij> create table tself(a int not null primary key ,=20 b int references tself(a) ON DELETE SET NULL, =20 c int references tself(a) ON DELETE CASCADE); @@ -1134,7 +1134,7 @@ ij> create table tself(a int not null primary key ,=20 b int references tself(a) , =20 c int references tself(a) ON DELETE CASCADE); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "NO ACTION". (The referential constraint= is self-referencing and an existing self-referencing constraint has the in= dicated delete rule (NO ACTION, RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be NO ACTION. (The referential constraint is= self-referencing and an existing self-referencing constraint has the indic= ated delete rule (NO ACTION, RESTRICT or CASCADE).)'.=20 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 ,=20 b int references tparent(a) ON DELETE CASCADE , =20 c int references tself(a) ON DELETE SET NULL); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "CASCADE". (The referential constraint i= s self-referencing and the table is dependent in a relationship with a dele= te rule of CASCADE.)'.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'The d= elete rule of foreign key must be CASCADE. (The referential constraint is s= elf-referencing and the table is dependent in a relationship with a delete = rule of CASCADE.)'.=20 ij> drop table tself; ERROR 42Y55: 'DROP TABLE' cannot be performed on 'TSELF' because it does n= ot 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,=20 y int not null unique, z int references t1(b) ON DELETE CA= SCADE); -ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be "RESTRICT". (The relationship would caus= e the table to be delete-connected to the same table through multiple relat= ionships and such relationships must have the same delete rule (NO ACTION, = RESTRICT or CASCADE).) '.=20 +ERROR 42915: Foreign Key 'xxxxGENERATED-IDxxxx' is invalid because 'the d= elete rule of foreign key must be RESTRICT. (The relationship would cause = the table to be delete-connected to the same table through multiple relatio= nships and such relationships must have the same delete rule (NO ACTION, RE= STRICT or CASCADE).) '.=20 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/f= unctionTests/master/savepointJdbc30.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/savepointJdbc30.out?rev=3D1796= 96&r1=3D179695&r2=3D179696&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/savepointJdbc30.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/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 t= he current transaction. Test 46 Cursors declared before and within the savepoint unit will be clos= ed 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/f= unctionTests/master/schema5.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/schema5.out?rev=3D179696&r1=3D= 179695&r2=3D179696&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/schema5.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/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.=20 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 SR4 Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/schemas.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/schemas.out?rev=3D179696&r1=3D= 179695&r2=3D179696&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/schemas.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/schemas.out Thu Jun 2 18:54:29 2005 @@ -91,7 +91,7 @@ 3 =20 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 'NOCATALO= GS.APP.MYTAB' is not a column in the target table. +ERROR 42X04: Column 'NOCATALOGS.APP.MYTAB' is either not in any table in t= he FROM list or appears within a join specification and is outside the scop= e 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 'NOCATAL= OGS.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 specifica= tion 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 t= arget table. +ERROR 42X04: Column 'I' is either not in any table in the FROM list or app= ears within a join specification and is outside the scope of the join speci= fication 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 fro= m test.tt); -ERROR 42X04: Column 'SS.I' is not in any table in the FROM list or it appe= ars within a join specification and is outside the scope of the join specif= ication 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 sp= ecification 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 i= n 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 appea= rs within a join specification and is outside the scope of the join specifi= cation or it appears in a HAVING clause and is not in the GROUP BY list. I= f this is a CREATE or ALTER TABLE statement then 'S.I' is not a column in t= he target table. +ERROR 42X04: Column 'S.I' is either not in any table in the FROM list or a= ppears within a join specification and is outside the scope of the join spe= cification or appears in a HAVING clause and is not in the GROUP BY list. I= f 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 (sele= ct ii from test.t); -ERROR 42X04: Column 'II' is not in any table in the FROM list or it appear= s within a join specification and is outside the scope of the join specific= ation 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 ap= pears within a join specification and is outside the scope of the join spec= ification 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 th= e target table. ij> -- correlated column in a derived table select * from test.s, (select * from test.tt where test.s.i =3D 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 sp= ecification or it appears in a HAVING clause and is not in the GROUP BY lis= t=2E 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 joi= n specification or appears in a HAVING clause and is not in the GROUP BY li= st. 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 =3D=20 Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/select.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/select.out?rev=3D179696&r1=3D1= 79695&r2=3D179696&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/select.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/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 joi= n 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 B= Y list. If this is a CREATE or ALTER TABLE statement then 'SYS.S1.T1.D1' i= s 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 joi= n 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 B= Y list. If this is a CREATE or ALTER TABLE statement then 'SYS.S1.T1.D1' i= s not a column in the target table. ij>=20 Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/subquery.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/subquery.out?rev=3D179696&r1= =3D179695&r2=3D179696&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/subquery.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/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 joi= n 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 B= Y list. If this is a CREATE or ALTER TABLE statement then 'NOSUCHCOLUMN' i= s 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 specifica= tion 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 t= arget table. +ERROR 42X04: Column 'I' is either not in any table in the FROM list or app= ears within a join specification and is outside the scope of the join speci= fication 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 appe= ars within a join specification and is outside the scope of the join specif= ication 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 sp= ecification 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 i= n 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 appea= rs within a join specification and is outside the scope of the join specifi= cation or it appears in a HAVING clause and is not in the GROUP BY list. I= f this is a CREATE or ALTER TABLE statement then 'S.I' is not a column in t= he target table. +ERROR 42X04: Column 'S.I' is either not in any table in the FROM list or a= ppears within a join specification and is outside the scope of the join spe= cification or appears in a HAVING clause and is not in the GROUP BY list. I= f 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 appear= s within a join specification and is outside the scope of the join specific= ation 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 ap= pears within a join specification and is outside the scope of the join spec= ification 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 th= e 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 app= ears within a join specification and is outside the scope of the join speci= fication 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 s= pecification 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 =3D 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 specifica= tion 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 t= arget table. +ERROR 42X04: Column 'I' is either not in any table in the FROM list or app= ears within a join specification and is outside the scope of the join speci= fication 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 =3D ii) a; -ERROR 42X04: Column 'S.I' is not in any table in the FROM list or it appea= rs within a join specification and is outside the scope of the join specifi= cation or it appears in a HAVING clause and is not in the GROUP BY list. I= f this is a CREATE or ALTER TABLE statement then 'S.I' is not a column in t= he target table. +ERROR 42X04: Column 'S.I' is either not in any table in the FROM list or a= ppears within a join specification and is outside the scope of the join spe= cification or appears in a HAVING clause and is not in the GROUP BY list. I= f 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 =3D i and ii <> 1) from s; Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/syscat.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/syscat.out?rev=3D179696&r1=3D1= 79695&r2=3D179696&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/syscat.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/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 tab= lename'; -ERROR 42Y90: FOR UPDATE is not permitted on this type of statement. +ERROR 42Y90: FOR UPDATE is not permitted in this type of statement. =20 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/f= unctionTests/master/triggerBeforeTrig.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/triggerBeforeTrig.out?rev=3D17= 9696&r1=3D179695&r2=3D179696&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/triggerBeforeTrig.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/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 o= ldtable for each statement mode db2sql select * from old; ERROR 42Y92: BEFORE triggers may only reference row transition variables/t= ables. ij> create trigger t1 NO CASCADE before update on x referencing old as old= table for each row mode db2sql values old.x; -ERROR 42X04: Column 'OLD.X' is not in any table in the FROM list or it app= ears within a join specification and is outside the scope of the join speci= fication 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 s= pecification 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