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

[Ricardo P. (JIRA) <nh...@gm...>]

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

Ricardo Peres commented on NH-2710:
-----------------------------------

OK for multiquery (where the DB supports it), but there is an big difference between OR and UNION in most DB servers.
As for joining the results with LINQ to Objects, it is only viable if the queries do not return many results, and, of course, the server already filters duplicates, unless using UNION ALL.
I am using this and I have to use SQL queries. I agree, perhaps it's not a critical functionality, but, IMO, it is useful.


> 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