bug in select average in linq to nhibernate

Description

I have a Ticket entity:
public class Ticket
{
public virtual DateTime CreateDate { get; set; }
public virtual DateTime? CloseDate { get; set; }
}

Also I have a linq-to-NHibernte query for select average of (CloseDate - CreateDate) :

var average = SessionInstance.Query<Ticket>()
.Where(x => x.CloseDate != null)
.Average(x => ((DateTime)x.CloseDate).Date.Ticks - x.CreateDate.Date.Ticks);

But above query has a runtime exception by this message :

Exception of type 'Antlr.Runtime.NoViableAltException' was thrown. [.Average[Domain.Model.Ticket](.Where[Domain.Model.Ticket](NHibernate.Linq.NhQueryable`1[Domain.Model.Ticket], Quote((x, ) => (DateTime.op_Inequality(x.CloseDate, NULLp1))), ), Quote((x, ) => (Subtract(Convert(x.CloseDate).Date.Ticks, x.CreateDate.Date.Ticks))), )]

Why?

Environment

None

Activity

Show:

Ehsan Zeynali April 10, 2014 at 6:05 AM

this issue is duplicated by : https://nhibernate.jira.com/browse/NH-3612

Duplicate

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Who's Looking?

Open Who's Looking?

Created April 10, 2014 at 6:01 AM
Updated May 1, 2017 at 3:31 AM
Resolved May 1, 2017 at 3:31 AM
Who's Looking?