[hibernate-issues] [Hibernate-JIRA] Created: (HHH-2067) Creteria api mysql distinct problem

[MAHMUT YILDIZ (JIRA)]

Creteria api mysql distinct problem
-----------------------------------

         Key: HHH-2067
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2067
     Project: Hibernate3
        Type: Bug

    Versions: 3.1.3    
    Reporter: MAHMUT YILDIZ


Hibernate criteria api created following sql :

SELECT  FIRST_NAME, DISTINCT LAST_NAME FROM PERSONNEL;

But this sql has syntax errors for mysql. Because distinct is located wring place. Right sql must be following:

SELECT  DISTINCT LAST_NAME , FIRST_NAME FROM PERSONNEL;

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira