I originally reported this bug https://nhibernate.jira.com/browse/NH-2167
it says it was fixed 2 months ago. On Nov 10, 2015 10:57 AM, "Koen Dobbels" <[email protected]> wrote: > Dear, > > I'm currenty trying to get the following statement out of nhibernate using > criterias: > SELECT coalesce(this_.number, '') FROM TABLE this_ GROUP BY > coalesce(this_.number, '') > > I have the following code: > projections.Add(Projections.GroupProperty(Projections.SqlFunction("COALESCE", > NHibernateUtil.String, Projections.Property("Number"), > Projections.Constant(string.Empty)))); > > The result is however quite disappointing as the result is: > SELECT > coalesce(this_.number, '') > FROM > TABLE this_ > GROUP BY > coalesce(this_.batch_number, ?); > @p0 = '' [Type: String (4000)] > > I've no idea where the '?' is originating from or how to solve this issue. > > The NH version that is used is : 3.3.1.4000 > > Any help would be appreciated. > > Kind regards, > Koen > > P.S. The query above is part of a much larger query, but the issue is also > encountered with this easy query as well. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/nhusers. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
