From derby-commits-return-927-apmail-db-derby-commits-archive=db.apache.org@db.apache.org Fri Jun 03 02:02:12 2005 Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 72963 invoked from network); 3 Jun 2005 02:02:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 3 Jun 2005 02:02:12 -0000 Received: (qmail 89096 invoked by uid 500); 3 Jun 2005 02:02:12 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 89068 invoked by uid 500); 3 Jun 2005 02:02:11 -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 89054 invoked by uid 500); 3 Jun 2005 02:02:11 -0000 Delivered-To: apmail-incubator-derby-cvs@incubator.apache.org Received: (qmail 89043 invoked by uid 99); 3 Jun 2005 02:02:11 -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:02:10 -0700 Received: (qmail 70944 invoked by uid 65534); 3 Jun 2005 01:54:48 -0000 Message-ID: <20050603015448.70942.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Subject: svn commit: r179696 [6/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/triggerGeneral.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/triggerGeneral.out?rev=3D17969= 6&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/triggerGeneral.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/triggerGeneral.out Thu Jun 2 18:54:29 2005 @@ -1024,7 +1024,7 @@ ij(CONN2)> call app.notifyDMLDone(); =2E..nested thread running using expired tec =2E..trying to loop through stale result set -Got expected exception: SQL Exception: ResultSet not open, operation 'next= ' not permitted. Verify that autocommit is OFF. +Got expected exception: SQL Exception: ResultSet not open. Operation 'next= ' not permitted. Verify that autocommit is OFF. Got expected exception: java.sql.SQLException: Statement closed. Got expected exception: java.sql.SQLException: Statement closed. 0 rows inserted/updated/deleted Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/triggerRefClause.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/triggerRefClause.out?rev=3D179= 696&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/triggerRefClause.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/triggerRefClause.out Thu Jun 2 18:54:29 2005 @@ -39,13 +39,13 @@ ERROR 42Y92: DELETE triggers may only reference old transition variables/t= ables. ij> -- cannot reference columns that don't exist, not bound as normal stmts create trigger t1 after delete on x referencing old as old for each row mo= de db2sql values old.badcol; -ERROR 42X04: Column 'OLD.BADCOL' is not in any table in the FROM list or i= t 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 l= ist. If this is a CREATE or ALTER TABLE statement then 'OLD.BADCOL' is not= a column in the target table. +ERROR 42X04: Column 'OLD.BADCOL' is either not in any table in the FROM li= st or appears within a join specification and is outside the scope of the j= oin 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.BADCOL' is no= t a column in the target table. ij> create trigger t1 after delete on x referencing old as old for each ro= w mode db2sql values old; -ERROR 42X04: Column 'OLD' 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 'OLD' is not a column in t= he target table. +ERROR 42X04: Column 'OLD' 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 'OLD' is not a column in = the target table. ij> create trigger t1 after delete on x referencing old as oldrow for each= row mode db2sql values oldrow.badcol; -ERROR 42X04: Column 'OLDROW.BADCOL' is not in any table in the FROM list o= r it appears within a join specification and is outside the scope of the jo= in specification or it appears in a HAVING clause and is not in the GROUP B= Y list. If this is a CREATE or ALTER TABLE statement then 'OLDROW.BADCOL' = is not a column in the target table. +ERROR 42X04: Column 'OLDROW.BADCOL' is either not in any table in the FROM= list or appears within a join specification and is outside the scope of th= e 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 'OLDROW.BADCOL'= is not a column in the target table. ij> create trigger t1 after delete on x referencing old as oldrow for each= row mode db2sql values oldrow; -ERROR 42X04: Column 'OLDROW' 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 'OLDROW' is not a colum= n in the target table. +ERROR 42X04: Column 'OLDROW' 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 'OLDROW' is not a colu= mn in the target table. ij> -- lets try some basics with old/new table create table y (x int); 0 rows inserted/updated/deleted Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/ungroupedAggregatesNegative.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/ungroupedAggregatesNegative.ou= t?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/ungroupedAggregatesNegative.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/ungroupedAggregatesNegative.out Thu Jun 2 18:54:29 2005 @@ -8,9 +8,9 @@ 3 rows inserted/updated/deleted ij> -- mix aggregate and non-aggregate expressions in the select list select c1, max(c1) from t1; -ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contai= ns at least 1 aggregate then all entries must be valid aggregate expression= s=2E +ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contai= ns at least one aggregate then all entries must be valid aggregate expressi= ons. =20 ij> select c1 * max(c1) from t1; -ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contai= ns at least 1 aggregate then all entries must be valid aggregate expression= s=2E +ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contai= ns at least one aggregate then all entries must be valid aggregate expressi= ons. =20 ij> -- aggregate in where clause select c1 from t1 where max(c1) =3D 1; ERROR 42903: Invalid use of an aggregate function. @@ -19,7 +19,7 @@ ERROR 42Z07: Aggregates are not permitted in the ON clause. ij> -- correlated subquery in select list select max(c1), (select t2.c1 from t2 where t1.c1 =3D t2.c1) from t1; -ERROR 42Y29: The SELECT list of a non-grouped query contains at least 1 in= valid expression. When the SELECT list contains at least 1 aggregate then = all entries must be valid aggregate expressions. +ERROR 42Y29: The SELECT list of a non-grouped query contains at least one = invalid expression. When the SELECT list contains at least one aggregate th= en all entries must be valid aggregate expressions. ij> -- noncorrelated subquery that returns more than 1 row select max(c1), (select t2.c1 from t2) from t1; ERROR 21000: Scalar subquery is only allowed to return a single row.