[nhibernate-issues] [NHJIRA] Commented: (NH-2710) Support Unions on HQL

[Fabio M. (JIRA) <nh...@gm...>]

    [ http://216.121.112.228/browse/NH-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21121#action_21121 ] 

Fabio Maulo commented on NH-2710:
---------------------------------

To take that result the UNION is completely unneeded.
1) from Entity e where e.Type = 1 or e.Type = 2
2) you can use multiquery and union the result in RAM using a very simple LINQ to object expression.

Try again with another example.

> Support Unions on HQL
> ---------------------
>
>                 Key: NH-2710
>                 URL: http://216.121.112.228/browse/NH-2710
>             Project:  NHibernate
>          Issue Type: New Feature
>          Components: Core
>    Affects Versions: 3.1.0
>            Reporter: Ricardo Peres
>
> HQL should support the UNION keyword, since it provides better performance on most DBs than OR clauses.

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