db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-883) Enhance GROUP BY clause to support expressions instead of just column references.
Date Sat, 26 Aug 2006 03:58:34 GMT
     [ 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

        

Mime
View raw message