Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-1144

EJBQL mixed GROUP BY clause is generated incorrectly

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 3.0M5
    • 3.0M6
    • Core Library
    • None

    Description

      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

      Attachments

        Activity

          People

            andrus Andrus Adamchik
            andrus Andrus Adamchik
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: