Derby
  1. Derby
  2. DERBY-883

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

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major 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)

      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

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development