Hibernate version: v1.1.4322

Name and version of the database you are using: Sql server 2000, SP4

I'm having some problems to concatenate two fields in the projection of my query.

I've tried this:
select width.WidthInCm, width.WidthInCm from Com.Hotec.Manager.Hibernate.Model.Width width and that worked OK but of course that's not concatenation.

but when I try this:

select (width.WidthInCm || '_' || width.WidthInCm) from Com.Hotec.Manager.Hibernate.Model.Width width

or

select (width.WidthInCm + '_' + width.WidthInCm) from Com.Hotec.Manager.Hibernate.Model.Width width

results in this error:
aggregate function expected before (executed query)

when I searched the forum, I've noticed the NHibernate forum doesn't have much topics about this issue. Does that mean it isn't implemented yet?

Thanks for the clarification

The operators might not be supported. Try using concat(...) instead.

As a workaround, I've created a view with the field I wanted to concatenate.

It seems this is also working ok.

Thanks for the help

Was this ever resolved? Is this a known issue?

When I try to do concatenation in a select clause, I can't get it to work.

If I try:


I get:

, expected in SELECT [select o.LastName||o.FirstName from Common.Security.Person o]

If I try:


I get:

alias or expression expected in SELECT [select concat(o.LastName, o.FirstName) from Common.Security.Person o]

I am using NHibernate 1.2

The concat operator only works in the where clause in 1.2.x. However if you look at the trunk you'll see that this feature is now implemented in the select clause too.