[nhibernate-issues] [JIRA] Updated: (NH-280) Using constants in select clause of HQL

[NHibernate J. <mik...@us...>]

     [ http://jira.nhibernate.org/browse/NH-280?page=all ]

Sergey Koshcheyev updated NH-280:
---------------------------------

    Fix Version: LATER
        Version: 1.2.0.Beta2
      Assign To:     (was: Mike Doerfler)

> Using constants in select clause of HQL
> ---------------------------------------
>
>          Key: NH-280
>          URL: http://jira.nhibernate.org/browse/NH-280
>      Project: NHibernate
>         Type: New Feature
>   Components: Core
>     Versions: 1.2.0.Beta2, beta-0.8.3
>  Environment: .net 1.1, nhibernate 0.8.2.0, sql server 2000 sp 3
>     Reporter: Dragos Nuta
>     Priority: Minor
>      Fix For: LATER

>
> It would be nice and easier to have a way to specify constants in the select clause in hql.
> select someobject.property, 1, 'constant string'
> from SomeObject someobject
> If you need a case where this could prove useful think about union (that as far as I know is not supported either) in a case like this:
> ArrayList result = new ArrayList();
> result.AddRange( 
> Session.CreateQuery( "select  o1.Name, 'O1' from Object1 o1" ).List()
> );
> result.AddRange( 
> Session.CreateQuery( "select  o2.Name, 'O2' from Object2 o2" ).List()
> );
> I think it should not be hard to support integer, decimal or string constants, but you may find some difficulties in expressing datetime constants. On possibility whould be to support a new keyword, something like newDate( year, month, day, hour, minute, second), or support a syntax like in Access (I guess) of {year-month-date} or {year-month-date hour:minute:second}.

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