Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2058

derbyall/derbyall.fail:lang/groupBy.sql failed with wctme5.7 max libraries on version 10.2

    XMLWordPrintableJSON

    Details

    • 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
    • Labels:
      None
    • Bug behavior facts:
      Regression Test Failure

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

        Attachments

          Activity

            People

            • Assignee:
              myrna Myrna van Lunteren
              Reporter:
              mkutty Manjula Kutty
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: