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:54:11 UTC
[jira] Created: (CAY-1144) EJBQL mixed GROUP BY clause is generated
incorrectly
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.
[jira] Closed: (CAY-1144) EJBQL mixed GROUP BY clause is generated
incorrectly
Posted by "Andrus Adamchik (JIRA)" <ji...@apache.org>.
[ 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.