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

Enhance GROUP BY clause to support expressions instead of just column references.

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.2.1, 10.2.1.6
    • Fix Version/s: 10.2.1.6
    • Component/s: Documentation, SQL
    • Labels:
      None
    • Environment:
      JDK 1.5.0_05

      Description

      This select would return an error syntax on finding "(" after month if group by clause:

      select idissue, month(creation), year(creation), count(distinct idissue)
      where
      ....
      group by idissue, month(creation), year(creation)

        Attachments

        1. 883.patch.txt
          79 kB
          Manish Khettry
        2. 883.patch3.txt
          78 kB
          Manish Khettry
        3. 883.patch4.txt
          73 kB
          Manish Khettry
        4. 883.patch5.txt
          81 kB
          Manish Khettry
        5. 883.patch6.txt
          80 kB
          Manish Khettry
        6. 883.patch6.txt
          81 kB
          Manish Khettry
        7. 883.patch7.txt
          81 kB
          Manish Khettry

        Issue Links

          Activity

            People

            • Assignee:
              mkhettry Manish Khettry
              Reporter:
              llturro Lluis Turro

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment