Thans for your answer. Do you perhaps know as from which version of nHibernate this fix is available? Did you already test it?
Thanks. Op dinsdag 10 november 2015 17:44:06 UTC+1 schreef fknebels: > > 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] > <javascript:>> 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] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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.
