[hibernate-issues] [Hibernate-JIRA] Reopened: (EJB-294) Hibernate throwing QueryException when using alias for aggregate functions in named queries

[Max Rydahl Andersen (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/EJB-294?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Max Rydahl Andersen reopened EJB-294:
-------------------------------------


there *is* an "as" keyword in hibernate, have been there since select new map where introduced and it is usable in context of resulttransformers too.

Please read the docs next time christian (its near the "select new map" description ;)






> Hibernate throwing QueryException when using alias for aggregate functions in named queries
> -------------------------------------------------------------------------------------------
>
>                 Key: EJB-294
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/EJB-294
>             Project: Hibernate Entity Manager
>          Issue Type: Bug
>          Components: EntityManager
>    Affects Versions: 3.2.0.ga
>         Environment: Hibernate 3.2 GA, 
>            Reporter: Saravanabavagugan Vengadasundaram
>
> Hibernate throwing QueryException when using alias for aggregate functions in named queries. The following query does not work:
> select sum(emp.salary) as totalSalary from Employee as emp
> select sum(emp.salary) totalSalary from Employee as emp
> but this works:
> select sum(emp.salary) from Employee as emp

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