db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fuzzylo...@apache.org
Subject svn commit: r190512 [1/4] - in /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/j9_13/distinct.out master/j9_13/ejbql.out master/j9_13/floattypes.out master/j9_13/groupBy.out master/j9_13/outparams.out master/j9_22/distinct.out master/j9_22/groupBy.out tests/lang/copyfiles.ant
Date Mon, 13 Jun 2005 21:37:35 GMT
Author: fuzzylogic
Date: Mon Jun 13 14:37:34 2005
New Revision: 190512

URL: http://svn.apache.org/viewcvs?rev=190512&view=rev
Log:
Update j9 masters.

Modified:
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/distinct.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/outparams.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_22/distinct.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_22/groupBy.out
    incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/copyfiles.ant

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/distinct.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/distinct.out?rev=190512&r1=190511&r2=190512&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/distinct.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/distinct.out
Mon Jun 13 14:37:34 2005
@@ -2280,9 +2280,9 @@
 ij> -- . for update on a select distinct
 -- both should get errors, not updatable.
 select distinct d from u for update;
-ERROR 42Y90: FOR UPDATE is not permitted on this type of statement.
+ERROR 42Y90: FOR UPDATE is not permitted in this type of statement.  
 ij> select distinct d from u for update of d;
-ERROR 42Y90: FOR UPDATE is not permitted on this type of statement.
+ERROR 42Y90: FOR UPDATE is not permitted in this type of statement.  
 ij> -- . positioned update/delete on a select distinct
 get cursor c1 as 'select distinct d from u';
 ij> next c1;

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out?rev=190512&r1=190511&r2=190512&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/ejbql.out
Mon Jun 13 14:37:34 2005
@@ -1083,7 +1083,7 @@
 (1.0e31, ,1.0e-31),
 (-1.0e31, -1.0e-31 ), 
 select a from myNumeric;
-ERROR 42X80: VALUES clause must contain at least 1 element and all elements must be non-empty.
+ERROR 42X80: VALUES clause must contain at least one element. Empty elements are not allowed.

 ij> select -a from myNumeric;
 1                               
 --------------------------------
@@ -1571,7 +1571,7 @@
 ----------------------
 ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
 ij> values{fn abs(-DOUBLE( NaN)                    )};
-ERROR 42X04: Column 'NAN' 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
'NAN' is not a column in the target table.
+ERROR 42X04: Column 'NAN' is either not in any table in the FROM list or appears within a
join specification and is outside the scope of the join specification or appears in a HAVING
clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then
'NAN' is not a column in the target table.
 ij> values{fn abs( DOUBLE( 4.9E-324)               )};
 ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
 ij> values{fn abs( DOUBLE( 1.7976931348623157E308) )};
@@ -1834,15 +1834,15 @@
 values{ fn locate( 'hello', 'hello',-1 ) };
 1          
 -----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer.  The
index to start the search from is '-1'.  The string to search for is 'hello'.  The string
to search from is 'hello'. 
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The
index  to start the search from is '-1'.  The string to search for is 'hello'.  The string
to search from is 'hello'. 
 ij> values{ fn locate( 'hello', 'hello',-0 ) };
 1          
 -----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer.  The
index to start the search from is '0'.  The string to search for is 'hello'.  The string to
search from is 'hello'. 
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The
index  to start the search from is '0'.  The string to search for is 'hello'.  The string
to search from is 'hello'. 
 ij> values{ fn locate( 'hello', 'hello', 0 ) };
 1          
 -----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer.  The
index to start the search from is '0'.  The string to search for is 'hello'.  The string to
search from is 'hello'. 
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The
index  to start the search from is '0'.  The string to search for is 'hello'.  The string
to search from is 'hello'. 
 ij> values{ fn locate( 'hello', 'hello', 1 ) };
 1          
 -----------
@@ -1862,7 +1862,7 @@
 ij> values{ fn locate( 'hello', 'hellohello', 0 ) };
 1          
 -----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer.  The
index to start the search from is '0'.  The string to search for is 'hello'.  The string to
search from is 'hellohello'. 
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The
index  to start the search from is '0'.  The string to search for is 'hello'.  The string
to search from is 'hellohello'. 
 ij> values{ fn locate( 'hello', 'hellohello', 1 ) };
 1          
 -----------
@@ -1910,15 +1910,15 @@
 ij> values{ fn locate( '?', '?',-1 ) };
 1          
 -----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer.  The
index to start the search from is '-1'.  The string to search for is '?'.  The string to search
from is '?'. 
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The
index  to start the search from is '-1'.  The string to search for is '?'.  The string to
search from is '?'. 
 ij> values{ fn locate( '?', '?',-0 ) };
 1          
 -----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer.  The
index to start the search from is '0'.  The string to search for is '?'.  The string to search
from is '?'. 
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The
index  to start the search from is '0'.  The string to search for is '?'.  The string to search
from is '?'. 
 ij> values{ fn locate( '?', '?', 0 ) };
 1          
 -----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer.  The
index to start the search from is '0'.  The string to search for is '?'.  The string to search
from is '?'. 
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The
index  to start the search from is '0'.  The string to search for is '?'.  The string to search
from is '?'. 
 ij> values{ fn locate( '?', '?', 1 ) };
 1          
 -----------
@@ -1930,7 +1930,7 @@
 ij> values{ fn locate( '\', '\\',0) };
 1          
 -----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer.  The
index to start the search from is '0'.  The string to search for is '\'.  The string to search
from is '\\'. 
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The
index  to start the search from is '0'.  The string to search for is '\'.  The string to search
from is '\\'. 
 ij> values{ fn locate( '\', '\\',1) };
 1          
 -----------
@@ -1946,7 +1946,7 @@
 ij> values{ fn locate( '/', '//',0) };
 1          
 -----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer.  The
index to start the search from is '0'.  The string to search for is '/'.  The string to search
from is '//'. 
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The
index  to start the search from is '0'.  The string to search for is '/'.  The string to search
from is '//'. 
 ij> values{ fn locate( '/', '//',1) };
 1          
 -----------
@@ -2747,11 +2747,11 @@
 ij> select locate(a, b, 0) from foo;
 1          
 -----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer.  The
index to start the search from is '0'.  The string to search for is 'abc'.  The string to
search from is 'abcd'. 
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The
index  to start the search from is '0'.  The string to search for is 'abc'.  The string to
search from is 'abcd'. 
 ij> select locate(a, b, -1) from foo;
 1          
 -----------
-ERROR 22014: The start positon for LOCATE is invalid; it must be a positive integer.  The
index to start the search from is '-1'.  The string to search for is 'abc'.  The string to
search from is 'abcd'. 
+ERROR 22014: The start position for LOCATE is invalid; it must be a positive integer. The
index  to start the search from is '-1'.  The string to search for is 'abc'.  The string to
search from is 'abcd'. 
 ij> select locate(a, b, 1) from foo;
 1          
 -----------
@@ -3477,7 +3477,7 @@
 ----------------------
 ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
 ij> values{fn  sqrt(-DOUBLE( NaN)                    )};
-ERROR 42X04: Column 'NAN' 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
'NAN' is not a column in the target table.
+ERROR 42X04: Column 'NAN' is either not in any table in the FROM list or appears within a
join specification and is outside the scope of the join specification or appears in a HAVING
clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then
'NAN' is not a column in the target table.
 ij> values{fn  sqrt( DOUBLE( 4.9E-324)               )};
 ERROR 22003: The resulting value is outside the range for the data type DOUBLE.
 ij> values{fn  sqrt( DOUBLE( 1.7976931348623157E308) )};
@@ -3598,7 +3598,7 @@
 ij> select { fn mod(dbl, 3) } from modfn;
 ERROR 42Y95: The 'mod' operator with a left operand type of 'DOUBLE' and a right operand
type of 'INTEGER' is not supported.
 ij> select { fn mod(67, t) } from modfn where s <> 0;
-ERROR 42X04: Column 'T' 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
'T' is not a column in the target table.
+ERROR 42X04: Column 'T' is either not in any table in the FROM list or appears within a join
specification and is outside the scope of the join specification or appears in a HAVING clause
and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'T' is
not a column in the target table.
 ij> select { fn mod(67, s) } from modfn where s <> 0;
 1          
 -----------

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out?rev=190512&r1=190511&r2=190512&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/floattypes.out
Mon Jun 13 14:37:34 2005
@@ -1619,7 +1619,7 @@
 ij> insert into t(r) values '1.0';
 ERROR 42821: Columns of type 'REAL' cannot hold values of type 'CHAR'. 
 ij> update t set r = NaN;
-ERROR 42X04: Column 'NAN' 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
'NAN' is not a column in the target table.
+ERROR 42X04: Column 'NAN' is either not in any table in the FROM list or appears within a
join specification and is outside the scope of the join specification or appears in a HAVING
clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then
'NAN' is not a column in the target table.
 ij> update t set r = +3.4021E+38;
 0 rows inserted/updated/deleted
 ij> update t set r = -3.4021E+38;

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out?rev=190512&r1=190511&r2=190512&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/j9_13/groupBy.out
Mon Jun 13 14:37:34 2005
@@ -10,14 +10,14 @@
 ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
 ij> -- column in group by list not in from list
 select a as d from t1 group by d;
-ERROR 42X04: Column 'D' 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
'D' is not a column in the target table.
+ERROR 42X04: Column 'D' is either not in any table in the FROM list or appears within a join
specification and is outside the scope of the join specification or appears in a HAVING clause
and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'D' is
not a column in the target table.
 ij> -- column in group by list not in select list
 select a as b from t1 group by b;
-ERROR 42Y36: Column reference 'A' is invalid.  For a SELECT with a GROUP BY, the SELECT list
may only contain grouping columns and valid aggregate expressions.
+ERROR 42Y36: Column reference 'A' is invalid.  For a SELECT list with a GROUP BY, the list
may only contain grouping columns and valid aggregate expressions.  
 ij> select a from t1 group by b;
-ERROR 42Y36: Column reference 'A' is invalid.  For a SELECT with a GROUP BY, the SELECT list
may only contain grouping columns and valid aggregate expressions.
+ERROR 42Y36: Column reference 'A' is invalid.  For a SELECT list with a GROUP BY, the list
may only contain grouping columns and valid aggregate expressions.  
 ij> select a, char(b) from t1 group by a;
-ERROR 42Y36: Column reference 'B' is invalid.  For a SELECT with a GROUP BY, the SELECT list
may only contain grouping columns and valid aggregate expressions.
+ERROR 42Y36: Column reference 'B' is invalid.  For a SELECT list with a GROUP BY, the list
may only contain grouping columns and valid aggregate expressions.  
 ij> -- columns in group by list must be unique
 select a, b from t1 group by a, a;
 ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list
must be unambiguous.
@@ -25,19 +25,19 @@
 ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in the GROUP BY list
must be unambiguous.
 ij> -- cursor with group by is not updatable
 get cursor c1 as 'select a from t1 group by a for update';
-ERROR 42Y90: FOR UPDATE is not permitted on this type of statement.
+ERROR 42Y90: FOR UPDATE is not permitted in this type of statement.  
 ij> -- noncorrelated subquery that returns too many rows
 select a, (select a from t2) from t1 group by a;
 ERROR 21000: Scalar subquery is only allowed to return a single row.
 ij> -- correlation on outer table
 select t2.a, (select b from t1 where t1.b = t2.b) from t1 t2 group by t2.a;
-ERROR 42Y30: The SELECT list of a grouped query contains at least 1 invalid expression. 
For a SELECT with a GROUP BY, the SELECT list may only contain grouping columns and valid
aggregate expressions.
+ERROR 42Y30: The SELECT list of a grouped query contains at least one invalid expression.
If a SELECT list has a GROUP BY, the list may only contain grouping columns and valid aggregate
expressions.  
 ij> -- having clause
 -- cannot contain column references which are not grouping columns
 select a from t1 group by a having c = 1;
-ERROR 42X04: Column 'C' 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
'C' is not a column in the target table.
+ERROR 42X04: Column 'C' is either not in any table in the FROM list or appears within a join
specification and is outside the scope of the join specification or appears in a HAVING clause
and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then 'C' is
not a column in the target table.
 ij> select a from t1 o group by a having a = (select a from t1 where b = b.o);
-ERROR 42X04: Column 'B.O' 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
'B.O' is not a column in the target table.
+ERROR 42X04: Column 'B.O' is either not in any table in the FROM list or appears within a
join specification and is outside the scope of the join specification or appears in a HAVING
clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then
'B.O' is not a column in the target table.
 ij> -- ?s in group by
 select a from t1 group by ?;
 ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
@@ -45,7 +45,7 @@
 create table unmapped(c1 long varchar);
 0 rows inserted/updated/deleted
 ij> select c1, max(1) from unmapped group by c1;
-ERROR X0X67: Columns of type 'LONG VARCHAR' may not be used in CREATE INDEX, ORDER BY, GROUP
BY, UNION, INTERSECT, EXCEPT or DISTINCT, because comparisons are not supported for that type.
+ERROR X0X67: Columns of type 'LONG VARCHAR' may not be used in CREATE INDEX, ORDER BY, GROUP
BY, UNION, INTERSECT, EXCEPT or DISTINCT statements because comparisons are not supported
for that type.
 ij> -- clean up
 drop table t1;
 0 rows inserted/updated/deleted
@@ -562,13 +562,13 @@
 ERROR 42X19: The WHERE or HAVING clause or CHECK CONSTRAINT definition is a 'INTEGER' expression.
 It must be a BOOLEAN expression.
 ij> -- column references in having clause not allowed if no group by
 select * from t1 having c1 = 1;
-ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least
1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least
one aggregate then all entries must be valid aggregate expressions.  
 ij> select 1 from t1 having c1 = 1;
-ERROR 42X04: Column 'C1' 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
'C1' is not a column in the target table.
+ERROR 42X04: Column 'C1' is either not in any table in the FROM list or appears within a
join specification and is outside the scope of the join specification or appears in a HAVING
clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE  statement then
'C1' is not a column in the target table.
 ij> -- correlated subquery in having clause
 select * from t1 t1_outer 
 having 1 = (select 1 from t1 where c1 = t1_outer.c1);
-ERROR 42Y35: Column reference 'T1_OUTER.C1' is invalid. When the SELECT list contains at
least 1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'T1_OUTER.C1' is invalid. When the SELECT list contains at
least one aggregate then all entries must be valid aggregate expressions.  
 ij> -- drop the table
 drop table t1;
 0 rows inserted/updated/deleted
@@ -588,22 +588,22 @@
 ij> -- all 6 queries below should fail after bug 5653 is fixed
 -- select * 
 select * from t1 having 1=1;
-ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least
1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least
one aggregate then all entries must be valid aggregate expressions.  
 ij> -- select column
 select c1 from t1 having 1=1;
-ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least 1 aggregate
then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least one
aggregate then all entries must be valid aggregate expressions.  
 ij> -- select with a built-in function sqrt
 select sqrt(c1) from t1 having 1=1;
-ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least 1 aggregate
then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least one
aggregate then all entries must be valid aggregate expressions.  
 ij> -- non-correlated subquery in having clause
 select * from t1 having 1 = (select 1 from t1 where c1 = 0.0);
-ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least
1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least
one aggregate then all entries must be valid aggregate expressions.  
 ij> -- expression in select list
 select (c1 * c1) / c1 from t1 where c1 <> 0 having 1=1;
-ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least 1 aggregate
then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'C1' is invalid. When the SELECT list contains at least one
aggregate then all entries must be valid aggregate expressions.  
 ij> -- between
 select * from t1 having 1 between 1 and 2;
-ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least
1 aggregate then all entries must be valid aggregate expressions.
+ERROR 42Y35: Column reference 'T1.C1' is invalid. When the SELECT list contains at least
one aggregate then all entries must be valid aggregate expressions.  
 ij> -- drop the table
 drop table t1;
 0 rows inserted/updated/deleted



Mime
View raw message