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.patch7.txt
        81 kB
        Manish Khettry
      2. 883.patch6.txt
        80 kB
        Manish Khettry
      3. 883.patch6.txt
        81 kB
        Manish Khettry
      4. 883.patch5.txt
        81 kB
        Manish Khettry
      5. 883.patch4.txt
        73 kB
        Manish Khettry
      6. 883.patch3.txt
        78 kB
        Manish Khettry
      7. 883.patch.txt
        79 kB
        Manish Khettry

        Issue Links

          Activity

          Kim Haase made changes -
          Link This issue relates to DERBY-2170 [ DERBY-2170 ]
          Knut Anders Hatlen made changes -
          Link This issue relates to DERBY-5313 [ DERBY-5313 ]
          Knut Anders Hatlen made changes -
          Link This issue relates to DERBY-4403 [ DERBY-4403 ]
          Gavin made changes -
          Workflow jira [ 12346271 ] Default workflow, editable Closed status [ 12801373 ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Bryan Pendleton made changes -
          Link This issue relates to DERBY-3094 [ DERBY-3094 ]
          Dyre Tjeldvoll made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Andrew McIntyre made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Yip Ng made changes -
          Component/s Documentation [ 11406 ]
          Fix Version/s 10.2.1.6 [ 11187 ]
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Yip Ng made changes -
          Link This issue relates to DERBY-2014 [ DERBY-2014 ]
          A B made changes -
          Link This issue relates to DERBY-2008 [ DERBY-2008 ]
          Daniel John Debrunner made changes -
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Fix Version/s 10.2.1.0 [ 11187 ]
          Daniel John Debrunner made changes -
          Derby Info [Patch Available]
          Manish Khettry made changes -
          Attachment 883.patch7.txt [ 12339626 ]
          Mike Matrigali made changes -
          Fix Version/s 10.2.1.0 [ 11187 ]
          Mike Matrigali made changes -
          Affects Version/s 10.2.1.0 [ 11187 ]
          Manish Khettry made changes -
          Attachment 883.patch6.txt [ 12338659 ]
          Manish Khettry made changes -
          Attachment 883.patch6.txt [ 12338658 ]
          Manish Khettry made changes -
          Attachment 883.patch5.txt [ 12337731 ]
          Manish Khettry made changes -
          Attachment 883.patch4.txt [ 12337590 ]
          Manish Khettry made changes -
          Attachment 883.patch3.txt [ 12337511 ]
          Manish Khettry made changes -
          Attachment 883.patch.txt [ 12336983 ]
          Manish Khettry made changes -
          Derby Info [Patch Available]
          Manish Khettry made changes -
          Assignee Manish Khettry [ mkhettry ]
          Satheesh Bandaram made changes -
          Summary Date functions are 'syntax error' in group by clause Enhance GROUP BY clause to support expressions instead of just column references.
          Daniel John Debrunner made changes -
          Field Original Value New Value
          Type Bug [ 1 ] New Feature [ 2 ]
          Lluis Turro created 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