Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

PostgreSQL: Support LINQ DateTime.Date in select clause

Description

For some time the DataTime.Date method can be used in LINQ queries. However, trying to use it in the select clause results in an exception when running on PostgreSQL:

NHibernate.QueryException : No data type for node: MethodNode ( method date ( expr_list ( order0_.OrderDate order0_.OrderId OrderDate ) ) ) [.Select[NHibernate.DomainModel.Northwind.Entities.Order,System.DateTime](.Where[NHibernate.DomainModel.Northwind.Entities.Order](NHibernate.Linq.NhQueryable`1[NHibernate.DomainModel.Northwind.Entities.Order], Quote((o, ) => (DateTime.op_Equality(o.OrderDate.Value.Date, p1))), ), Quote((o, ) => (o.OrderDate.Value.Date)), )] at NHibernate.Hql.Ast.ANTLR.Tree.SelectClause.InitializeExplicitSelectClause(FromClause fromClause) in SelectClause.cs: line 158 at NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.UseSelectClause(IASTNode select) in HqlSqlWalker.cs: line 511 at NHibernate.Hql.Ast.ANTLR.HqlSqlWalker.ProcessQuery(IASTNode select, IASTNode query) in HqlSqlWalker.cs: line 470

Environment

None

Activity

Show:

Oskar Berggren 
July 24, 2014 at 10:43 PM

Fix on master in f978dad59ae74ff425e6b0183fe86fa0e3fb195f.

Fixed

Details

Assignee

Reporter

Labels

Components

Fix versions

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created July 24, 2014 at 10:25 PM
Updated September 21, 2014 at 12:40 PM
Resolved July 24, 2014 at 10:43 PM
Who's Looking?