hibernate-issues

[Hibernate-issues] [Hibernate-JIRA] Created: (HB-1563) column alias

[Nithya P. (JIRA) <no...@at...>]

column alias
------------

         Key: HB-1563
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HB-1563
     Project: Hibernate2
        Type: Bug

 Environment: Hibernate 2.0, Cloudscape 
    Reporter: Nithya Priya


Hi,
I have a table that contains 2 columns course_id and  sbu, if I want  to take the max of the count of course_id
using a simple sql query I can use
select max(cnt)  from (select count(course_id) cnt from table group by course_id)
but if I use HQL its giving me query exception if I try to use an alias(cnt in the above case) for the column. Is there any other solution for this problem???
Thanks in advance


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

[Hibernate-issues] [Hibernate-JIRA] Closed: (HB-1563) column alias

[Steve E. (JIRA) <no...@at...>]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HB-1563?page=all ]
     
Steve Ebersole closed HB-1563:
------------------------------

    Resolution: Won't Fix

HQL does not allow queries as "from clause elements".  Use Hibernate's natiove SQL query support to acheive what you want here...

> column alias
> ------------
>
>          Key: HB-1563
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HB-1563
>      Project: Hibernate2
>         Type: Bug

>  Environment: Hibernate 2.0, Cloudscape 
>     Reporter: Nithya Priya

>
>
> Hi,
> I have a table that contains 2 columns course_id and  sbu, if I want  to take the max of the count of course_id
> using a simple sql query I can use
> select max(cnt)  from (select count(course_id) cnt from table group by course_id)
> but if I use HQL its giving me query exception if I try to use an alias(cnt in the above case) for the column. Is there any other solution for this problem???
> Thanks in advance

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