Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <7453226.1156564714431.JavaMail.jira@brutus>
Date: Fri, 25 Aug 2006 20:58:34 -0700 (PDT)
From: "Daniel John Debrunner (JIRA)" <derby-dev@db.apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Updated: (DERBY-883) Enhance GROUP BY clause to support
 expressions instead of just column references.
In-Reply-To: <154058036.1138376132958.JavaMail.jira@ajax.apache.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

     [ http://issues.apache.org/jira/browse/DERBY-883?page=all ]

Daniel John Debrunner updated DERBY-883:
----------------------------------------

    Derby Info:   (was: [Patch Available])

Patch 883.patch6.txt applied to trunk with changes below as revision 437070.


0) Merged by hand to latest codeline, only one real clash due to other added methods on ColumnReference
1) Licence header changed for new files to match new policy
2) Adapt patch for new location of BaseJDBCTestCase
3) Cleanup of new GroupByExpressionTest to use new single connection model provided by BaseJDBCTestCase and not have a single static Connection field. Static fields will cause a problem if multiple tests are run concurrently.
4) Minor cleanup of new assert in BaseJDBCTestCase


Thanks Manish, especially for sticking with it. :-)

> Enhance GROUP BY clause to support expressions instead of just column references.
> ---------------------------------------------------------------------------------
>
>                 Key: DERBY-883
>                 URL: http://issues.apache.org/jira/browse/DERBY-883
>             Project: Derby
>          Issue Type: New Feature
>          Components: SQL
>    Affects Versions: 10.1.2.1, 10.2.1.0
>         Environment: JDK 1.5.0_05
>            Reporter: Lluis Turro
>         Assigned To: Manish Khettry
>             Fix For: 10.2.1.0
>
>         Attachments: 883.patch.txt, 883.patch3.txt, 883.patch4.txt, 883.patch5.txt, 883.patch6.txt, 883.patch6.txt, 883.patch7.txt
>
>
> 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)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira