[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-467) case when then else end IN select clause

[Chirag (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-467?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=32705#action_32705 ] 

Chirag commented on HHH-467:
----------------------------

yes it's *really* required.
In my project I required this feature twice and since I couldn't found it in HQL I had to use native SQL.

> case when then else end IN select clause
> ----------------------------------------
>
>                 Key: HHH-467
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-467
>             Project: Hibernate Core
>          Issue Type: New Feature
>          Components: core
>    Affects Versions: 3.0.3
>         Environment: Hibernate 3.0.3, Oracle 9.2.0.1
>            Reporter: Albert Kam
>            Assignee: Gavin King
>             Fix For: 3.0.4
>
>   Original Estimate: 2 days
>  Remaining Estimate: 2 days
>
> Please see my posting here : 
> http://forum.hibernate.org/viewtopic.php?t=942197
> In summary, i would like to request a new feature, so the 'select case when .. then .. else .. end' will work :)
> Please, our company want to use HQL as wide as possible, without having SQL native queries and HQL get mixed up.
> Thank you very very much.
> Sincerely,
> Albert Kam

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