EF5: EntityFunctions.AddMonths() not working for negative values?

EF5: EntityFunctions.AddMonths() not working for negative values?

Postby acsdeveloper » Wed 10 Dec 2014 14:26

I am using dotConnect for PostgreSQL 7.3.293.0, EF 5 and PostgreSQL 9.3.

For the given database
Code: Select all
CREATE TABLE "Users"
(
  "Id" serial NOT NULL,
  "DateRegistered" timestamp without time zone,
  "Month" integer,
  CONSTRAINT "Users_pkey" PRIMARY KEY ("Id")
);

executing this query
Code: Select all
using (var db = new TestDatabaseContainer())
{
    var users = db.Users
        .Where(x => x.DateRegistered != null &&
                    x.Month != null &&
                    x.DateRegistered.Value >
                    EntityFunctions.AddMonths(DateTime.Today, -x.Month.Value))
        .ToList();
}

returns this error
Code: Select all
{Error: 22007: invalid input syntax for type interval: " -("Extent1"."Month") MONTH"}


Sample project here: http://puu.sh/doTOz/46f87e72d8.zip
acsdeveloper
 
Posts: 1
Joined: Fri 05 Dec 2014 13:31

Re: EF5: EntityFunctions.AddMonths() not working for negative values?

Postby Shalex » Thu 11 Dec 2014 10:17

Thank you for your report. We have reproduced the issue and are investigating it. We will notify you about the result.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: EF5: EntityFunctions.AddMonths() not working for negative values?

Postby Shalex » Wed 17 Dec 2014 14:24

The bug with SQL generation for AddYears, AddMonths, AddDays, AddHours, AddMinutes, AddSeconds, AddMilliseconds, AddMicroseconds, AddNanoseconds canonical functions is fixed. We will notify you when the corresponding build of dotConnect for PostgreSQL is available for download.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Re: EF5: EntityFunctions.AddMonths() not working for negative values?

Postby Shalex » Thu 18 Dec 2014 14:51

New build of dotConnect for PostgreSQL 7.3.313 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/postgresql/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=3&t=30982.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL