[ 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
