[DERBY-2058] derbyall/derbyall.fail:lang/groupBy.sql failed with wctme5.7 max libraries on version 10.2

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.2.0
• Fix Version/s: 10.2.2.0
• Component/s: Test
• Bug behavior facts: Regression Test Failure
• Assignee: Myrna van Lunteren
• Reporter: Manjula Kutty
• Created: 08/Nov/06 21:14
• Updated: 29/Jun/09 22:58
• Resolved: 19/Nov/06 01:48

Description

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.
      --------------------------------------------------------------------------------------------------------------------------------------------------------------------