LinqConnect Professional Version 4.2.229 (18-Apr-2013) - incorrect SQL for SQLite

[AKRRKA]

I have a Linq query:

Code: Select all

from v in Values
where v.DT > DateTime.Parse("2013-04-10") &&
      v.DT < DateTime.Parse("2013-04-11")
select new 
      {
        dt = v.DT.AddDays(+1),
        v.Val
      }

which will be generated SQL:

Code: Select all

SELECT datetime(t1.DT, '+1 day') AS C1, t1.Val AS Val
FROM "Values" t1
WHERE (t1.DT > :p0) AND (t1.DT < :p1)

If to use such query:

Code: Select all

from v in Values
where v.DT > DateTime.Parse("2013-04-10") &&
      v.DT < DateTime.Parse("2013-04-11")
select new 
      {
        dt = v.DT.AddDays(-1),
        v.Val
      }

it will return incorrect SQL (datetime(t1.DT, '+-1 day') instead of datetime(t1.DT, '-1 day')):

Code: Select all

SELECT datetime(t1.DT, '+-1 day') AS C1, t1.Val AS Val
FROM "Values" t1
WHERE (t1.DT > :p0) AND (t1.DT < :p1)	  

[MariiaI]

Thank you for the report. We have reproduced this issue. We will inform you when it is fixed.