db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Manish Khettry (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-883) Enhance GROUP BY clause to support expressions instead of just column references.
Date Fri, 28 Jul 2006 21:28:15 GMT
     [ http://issues.apache.org/jira/browse/DERBY-883?page=all ]

Manish Khettry updated DERBY-883:
---------------------------------

    Attachment: 883.patch5.txt

This patch addresses issues raised by Army and Yip. 

1. Flag error for aggregate in group by list.  Changes to sqlgrammar.jj, SQLState.java and
messages_en.properties. Other language files need to be changed too.

2. Remove unused SQL state (42Y19). 

3. Since the junit file (GroupByExpressionTest.java) is new, use spaces instead of tabs to
indent. Fix indentation for long lines.

4. Remove commented out code.

5. Add a few comments suggested by Army.

6. Test ternary operator node#isEquivalent in test case.



> 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
>
>
> 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