From derby-commits-return-925-apmail-db-derby-commits-archive=db.apache.org@db.apache.org Fri Jun 03 02:01:37 2005 Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 72826 invoked from network); 3 Jun 2005 02:01:37 -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:37 -0000 Received: (qmail 88228 invoked by uid 500); 3 Jun 2005 02:01:37 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 88211 invoked by uid 500); 3 Jun 2005 02:01:36 -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 88186 invoked by uid 500); 3 Jun 2005 02:01:36 -0000 Delivered-To: apmail-incubator-derby-cvs@incubator.apache.org Received: (qmail 88180 invoked by uid 99); 3 Jun 2005 02:01:36 -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 70950 invoked by uid 65534); 3 Jun 2005 01:54:48 -0000 Message-ID: <20050603015448.70948.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Subject: svn commit: r179696 [8/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/update.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/update.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/update.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/update.out Thu Jun 2 18:54:29 2005 @@ -64,7 +64,7 @@ 6 |5 |varchar_50_col |char_30_col = =20 ij> -- Negative test - column in SET clause twice update t1 set int_col =3D 1, int_col =3D 2; -ERROR 42X16: Column name 'INT_COL' appears multiple times in the SET claus= e of an update statement. +ERROR 42X16: Column name 'INT_COL' appears multiple times in the SET claus= e of an UPDATE statement. ij> -- Negative test - non-existent column in SET clause update t1 set notacolumn =3D int_col + 1; ERROR 42X14: 'NOTACOLUMN' is not a column in table or VTI 'APP.T1'. Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/valuesclause.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/valuesclause.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/valuesclause.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/valuesclause.out Thu Jun 2 18:54:29 2005 @@ -126,7 +126,7 @@ ERROR 42X59: The number of columns in each VALUES constructor must be the = same. ij> -- empty element values 1, , 2; -ERROR 42X80: VALUES clause must contain at least 1 element and all element= s must be non-empty. +ERROR 42X80: VALUES clause must contain at least one element. Empty elemen= ts are not allowed.=20 ij> -- all ? parameters in a column position prepare v1 as 'values (1, ?, 2), (3, ?, 4), (5, ?, 7)'; ERROR 42Y10: A table constructor that is not in an INSERT statement has al= l ? parameters in one of its columns. For each column, at least one of the= rows must have a non-parameter. @@ -491,13 +491,13 @@ select exists (values 1) from t1; ERROR 42X01: Syntax error: Encountered "exists" at line 2, column 8. ij> values exists (values 2); -ERROR 42X80: VALUES clause must contain at least 1 element and all element= s must be non-empty. +ERROR 42X80: VALUES clause must contain at least one element. Empty elemen= ts are not allowed.=20 ij> -- boolean expression EXISTS diallowed in update set clause too update t1 set c11 =3D exists(values 1); ERROR 42X01: Syntax error: Encountered "exists" at line 2, column 21. ij> -- ?: not supported anymore values not true ? false : true; -ERROR 42X80: VALUES clause must contain at least 1 element and all element= s must be non-empty. +ERROR 42X80: VALUES clause must contain at least one element. Empty elemen= ts are not allowed.=20 ij> -- this test runs in SPS mode too, hence adding a comment line before = the sql, so we get correct column number in error message in both SPS and n= on-SPS mode select not true ? false : true from t1; ERROR 42X01: Syntax error: Encountered "not" at line 2, column 8. Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/views.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/views.out?rev=3D179696&r1=3D17= 9695&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/views.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/views.out Thu Jun 2 18:54:29 2005 @@ -75,7 +75,7 @@ ERROR X0X05: Table 'NOTEXISTS' does not exist. ij> -- duplicate column name in view's column list create view shouldntwork (c1, c2, c1) as select i, s, f from t1; -ERROR 42Y13: Column name 'C1' appears more than once in the create view st= atement. +ERROR 42Y13: Column name 'C1' appears more than once in the CREATE VIEW st= atement. ij> -- # of columns in view's column list does not match that in view defi= nition create view shouldntwork (c1, c2, c3) as select i, s from t1; ERROR 42X56: The number of columns in the view column list does not match = the number of columns in the underlying query expression in the view defini= tion for 'SHOULDNTWORK'. @@ -121,13 +121,13 @@ ij> -- view updateability -- (No views are currently updateable) insert into sv1 values 1; -ERROR 42Y24: View 'SV1' is not updatable. (Views are currently not updatea= ble.) +ERROR 42Y24: View 'SV1' is not updatable. (Views are currently not updatab= le.)=20 ij> delete from sv1; -ERROR 42Y24: View 'SV1' is not updatable. (Views are currently not updatea= ble.) +ERROR 42Y24: View 'SV1' is not updatable. (Views are currently not updatab= le.)=20 ij> update sv1 set s_was_i =3D 0; -ERROR 42Y24: View 'SV1' is not updatable. (Views are currently not updatea= ble.) +ERROR 42Y24: View 'SV1' is not updatable. (Views are currently not updatab= le.)=20 ij> get cursor c2 as 'select * from sv1 for update of s_was_i'; -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> -- create index on a view create index i1 on sv2(i); ERROR 42Y62: 'CREATE INDEX' is not allowed on 'APP.SV2' because it is a vi= ew. Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/f= unctionTests/master/xab2354.out URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/= org/apache/derbyTesting/functionTests/master/xab2354.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/xab2354.out (original) +++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functio= nTests/master/xab2354.out Thu Jun 2 18:54:29 2005 @@ -18,12 +18,12 @@ ij(XA)> insert into foo values (2); 1 row inserted/updated/deleted ij(XA)> select cast(global_xid as char(2)) as gxid, status from new org.ap= ache.derby.diag.TransactionTable() t where gxid is not null order by gxid, = status; -ERROR 42X04: Column 'GXID' 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 'GXID' is not a column in= the target table. +ERROR 42X04: Column 'GXID' 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 'GXID' is not a column i= n the target table. ij(XA)> xa_end xa_success 1; ij(XA)> xa_prepare 1; ij(XA)> xa_getconnection ; ij(XA)> select cast(global_xid as char(2)) as gxid, status from new org.ap= ache.derby.diag.TransactionTable() t where gxid is not null order by gxid, = status; -ERROR 42X04: Column 'GXID' 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 'GXID' is not a column in= the target table. +ERROR 42X04: Column 'GXID' 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 'GXID' is not a column i= n the target table. ij(XA)> xa_datasource 'wombat' shutdown; ERROR 08006: Database 'wombat' shutdown. ij(XA)> xa_datasource 'wombat'; @@ -37,5 +37,5 @@ IJ ERROR: XAER_DUPID=20 ij(XA)> -- should see two transactions, one global transaction and one loc= al select cast(global_xid as char(2)) as gxid, status from new org.apache.der= by.diag.TransactionTable() t where gxid is not null order by gxid, status; -ERROR 42X04: Column 'GXID' 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 'GXID' is not a column in= the target table. +ERROR 42X04: Column 'GXID' 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 'GXID' is not a column i= n the target table. ij(XA)>=20