Thread: [nhibernate-issues] [NHJIRA] Created: (NH-2711) Support COALESCE in HQL

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

nhibernate-issues

[nhibernate-issues] [NHJIRA] Created: (NH-2711) Support COALESCE in HQL

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

Support COALESCE in HQL
-----------------------

                 Key: NH-2711
                 URL: http://216.121.112.228/browse/NH-2711
             Project:  NHibernate
          Issue Type: New Feature
          Components: Core
    Affects Versions: 3.2.0Beta1, 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


SQL standard defines the COALESCE operator, which should be implemented in most DBs. HQL should implement it.
I know we can always define it in a custom Dialect, but since this is standard, I think it should be supported by the core.

-- 
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-2711) Support COALESCE in HQL

From: Fabio M. (JIRA) <nh...@gm...> - 2011-05-19 16:00:02

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

Fabio Maulo updated NH-2711:
----------------------------

    Affects Version/s:     (was: 3.2.0Beta1)
                           (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)

Please stop the joke of "Affected version" (2nd times).
A new feature is a new feature you don't have to specify that the affected version are all already released versions including even all alphas.

> Support COALESCE in HQL
> -----------------------
>
>                 Key: NH-2711
>                 URL: http://216.121.112.228/browse/NH-2711
>             Project:  NHibernate
>          Issue Type: New Feature
>          Components: Core
>    Affects Versions: 3.1.0
>            Reporter: Ricardo Peres
>
> SQL standard defines the COALESCE operator, which should be implemented in most DBs. HQL should implement it.
> I know we can always define it in a custom Dialect, but since this is standard, I think it should be supported by the core.

-- 
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-2711) Support COALESCE as HQL function

From: Fabio M. (JIRA) <nh...@gm...> - 2011-05-20 14:10:56

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

Fabio Maulo updated NH-2711:
----------------------------

    Summary: Support COALESCE as HQL function  (was: Support COALESCE in HQL)

The parser does not need to be changed.
Coalesce can be added as standard HQL-function, as 'extract', 'cast' and so on (see Dialect.cs) and then each dialect can override the behavior where needed.

> Support COALESCE as HQL function
> --------------------------------
>
>                 Key: NH-2711
>                 URL: http://216.121.112.228/browse/NH-2711
>             Project:  NHibernate
>          Issue Type: New Feature
>          Components: Core
>    Affects Versions: 3.1.0
>            Reporter: Ricardo Peres
>
> SQL standard defines the COALESCE operator, which should be implemented in most DBs. HQL should implement it.
> I know we can always define it in a custom Dialect, but since this is standard, I think it should be supported by the core.

-- 
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-2711) Support COALESCE as HQL function

From: Ricardo P. (JIRA) <nh...@gm...> - 2011-05-20 14:38:11

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

Ricardo Peres commented on NH-2711:
-----------------------------------

It wasn't a joke, just a mistake... sorry about that.
I agree with you, my point of view is that standard SQL functions should be placed in Dialect.cs.

> Support COALESCE as HQL function
> --------------------------------
>
>                 Key: NH-2711
>                 URL: http://216.121.112.228/browse/NH-2711
>             Project:  NHibernate
>          Issue Type: New Feature
>          Components: Core
>    Affects Versions: 3.1.0
>            Reporter: Ricardo Peres
>
> SQL standard defines the COALESCE operator, which should be implemented in most DBs. HQL should implement it.
> I know we can always define it in a custom Dialect, but since this is standard, I think it should be supported by the core.

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