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

Brought to you by: ayenderahien, bahusoid, fabiomaulo, fdelaporte, and 5 others

nhibernate-issues

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

From: Ricardo P. (JIRA) <nh...@gm...> - 2011-05-18 15:46:49

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.2.0Alpha3, 3.2.0Alpha2, 3.2.0Alpha1, 3.1.0, 3.0.0.GA, 3.0.0.CR1, 3.0.0.Beta2, 3.0.0.Beta1, 3.0.0.Alpha3, 3.0.0.Alpha2, 3.0.0.Alpha1, 2.1.2.GA, 2.1.1.GA,  2.0.1.GA, 1.2.1
            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

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

From: Fabio M. (JIRA) <nh...@gm...> - 2011-05-18 17:53:49

     [ http://216.121.112.228/browse/NH-2710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fabio Maulo updated NH-2710:
----------------------------

    Affects Version/s:     (was: 3.2.0Alpha3)
                           (was: 3.2.0Alpha2)
                           (was: 3.2.0Alpha1)
                           (was: 3.0.0.GA)
                           (was: 3.0.0.CR1)
                           (was: 3.0.0.Beta2)
                           (was: 3.0.0.Beta1)
                           (was: 3.0.0.Alpha3)
                           (was: 3.0.0.Alpha2)
                           (was: 2.1.2.GA)
                           (was: 2.1.1.GA)
                           (was: 3.0.0.Alpha1)
                           (was:  2.0.1.GA)
                           (was: 1.2.1)

> 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

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

From: Fabio M. (JIRA) <nh...@gm...> - 2011-05-18 17:53:57

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

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

to do what ?

> 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

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

From: Ricardo P. (JIRA) <nh...@gm...> - 2011-05-18 18:08:52

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

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

from Entity e where e.Type = 1
union
from Entity e where e.Type = 2

> 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

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

From: Fabio M. (JIRA) <nh...@gm...> - 2011-05-18 20:04:52

    [ 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

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

From: Ricardo P. (JIRA) <nh...@gm...> - 2011-05-18 20:15:52

    [ 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