[ http://issues.apache.org/jira/browse/DERBY-2058?page=all ]
Myrna van Lunteren closed DERBY-2058. ------------------------------------- > 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
