[ http://issues.apache.org/jira/browse/DERBY-2058?page=all ]
Myrna van Lunteren resolved DERBY-2058.
---------------------------------------
Fix Version/s: 10.2.1.8
Resolution: Fixed
committed http://svn.apache.org/viewvc?view=rev&revision=476683 :
- fixed up outdated canon.
M java/testing/org/apache/derbyTesting/functionTests/master/j9_22/groupBy.out
> derbyall/derbyall.fail:lang/groupBy.sql failed with wctme5.7 max libraries on
> version 10.2
> ------------------------------------------------------------------------------------------
>
> Key: DERBY-2058
> URL: http://issues.apache.org/jira/browse/DERBY-2058
> Project: Derby
> Issue Type: Bug
> Components: Regression Test Failure
> Affects Versions: 10.2.1.8
> Reporter: Manjula Kutty
> Assigned To: Myrna van Lunteren
> Priority: Minor
> Fix For: 10.2.1.8
>
>
> The diff for the failed tests are :
> *** Start: groupBy jdk1.3.1 subset - 2.2 derbyall:derbylang 2006-11-04
> 09:29:36 ***
> 24 del
> < ij> -- group by position
> 24a24,25
> > ij> -- group by constant. should compile but fail because
> > -- it is not a valid grouping expression.
> 26 del
> < ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27.
> 26a27
> > 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 valid grouping expressions and valid aggregate expressions.
> 32 del
> < 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.
> 32a33
> > 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 valid grouping expressions and valid aggregate expressions.
> 34 del
> < 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.
> 34a35
> > 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 valid grouping expressions and valid aggregate expressions.
> 36 del
> < 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.
> 37 del
> < ij> -- columns in group by list must be unique
> 38 del
> < select a, b from t1 group by a, a;
> 39 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in
> the GROUP BY list must be unambiguous.
> 40 del
> < ij> select a, b from t1 group by a, t1.a;
> 41 del
> < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in
> the GROUP BY list must be unambiguous.
> 41a37
> > 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 valid grouping expressions and valid aggregate expressions.
> 50 del
> < 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.
> 50a46
> > 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 valid grouping expressions and valid aggregate expressions.
> 59 del
> < ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27.
> 59a55
> > ERROR 42X01: Syntax error: ?.
> Test Failed.
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
