[ http://issues.apache.org/jira/browse/DERBY-883?page=comments#action_12429218 ] Daniel John Debrunner commented on DERBY-883: ---------------------------------------------
Manish, can you fix up the patch so it works with the current state of the trunk. BaseJDBCTestCase has moved and the changes to sqlgrammar.jaa and CoalesceFunctionNode do not apply cleanly. If you can get this done this weekend then I will apply 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 > Environment: JDK 1.5.0_05 > Reporter: Lluis Turro > Assigned To: Manish Khettry > Attachments: 883.patch.txt, 883.patch3.txt, 883.patch4.txt, > 883.patch5.txt, 883.patch6.txt, 883.patch6.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
