[ http://issues.apache.org/jira/browse/DERBY-1841?page=all ]
Myrna van Lunteren closed DERBY-1841. ------------------------------------- Didn't see a failure on 10.2. so no need to port back. > lang/groupBy.sql fails with IBM j9 vms > -------------------------------------- > > Key: DERBY-1841 > URL: http://issues.apache.org/jira/browse/DERBY-1841 > Project: Derby > Issue Type: Test > Components: Regression Test Failure > Reporter: Deepa Remesh > Assigned To: Myrna van Lunteren > Fix For: 10.3.0.0 > > Attachments: DERBY-1841_20060927.diff > > > This looks like a master update issue. The canons for j9 vms need to be > updated with changes made for DERBY-883. > Diff: > 8 del > < ij> -- group by position > 8a8,9 > > ij> -- group by constant. should compile but fail because > > -- it is not a valid grouping expression. > 10 del > < ERROR 42X01: Syntax error: Encountered "1" at line 2, column 27. > 10a11 > > 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. > 16 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. > 16a17 > > 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. > 18 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. > 18a19 > > 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. > 20 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. > 21 del > < ij> -- columns in group by list must be unique > 22 del > < select a, b from t1 group by a, a; > 23 del > < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in > the GROUP BY list must be unambiguous. > 24 del > < ij> select a, b from t1 group by a, t1.a; > 25 del > < ERROR 42Y19: 'A' appears multiple times in the GROUP BY list. Columns in > the GROUP BY list must be unambiguous. > 25a21 > > 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 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. > 34a30 > > 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. > 43 del > < ERROR 42X01: Syntax error: Encountered "?" at line 2, column 27. > 43a39 > > 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
