You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrus Adamchik (JIRA)" <ji...@apache.org> on 2008/12/10 06:56:11 UTC

[jira] Closed: (CAY-1144) EJBQL mixed GROUP BY clause is generated incorrectly

     [ https://issues.apache.org/cayenne/browse/CAY-1144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik closed CAY-1144.
--------------------------------

    Resolution: Fixed

> EJBQL mixed GROUP BY clause is generated incorrectly
> ----------------------------------------------------
>
>                 Key: CAY-1144
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1144
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Cayenne Core Library
>    Affects Versions: 3.0M5
>            Reporter: Andrus Adamchik
>            Assignee: Andrus Adamchik
>            Priority: Minor
>             Fix For: 3.0M6
>
>
> This EJBQL:
>   SELECT COUNT(p), a, a.artistName FROM Painting p INNER JOIN p.toArtist a GROUP BY a, a.artistName
> Results in missing comma in generated GROUP BY:
>   SELECT COUNT(*) AS sc0, t0.ARTIST_NAME AS ec1_0, t0.ARTIST_ID AS ec1_2, t0.DATE_OF_BIRTH AS ec1_1, t0.ARTIST_NAME AS sc2 FROM PAINTING t1 INNER JOIN ARTIST t0 ON (t1.ARTIST_ID = t0.ARTIST_ID) GROUP BY t0.ARTIST_NAME, t0.ARTIST_ID, t0.DATE_OF_BIRTH t0.ARTIST_NAME

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.