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

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

    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
          81 kB
          Manish Khettry
        6. 883.patch6.txt
          80 kB
          Manish Khettry
        7. 883.patch7.txt
          81 kB
          Manish Khettry

          Issue Links

            Activity

              People

              • Assignee:
                mkhettry Manish Khettry
                Reporter:
                llturro Lluis Turro
              • Votes:
                1 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: