SQLite: Translate TimeSpan members · Issue #18844 · dotnet/efcore

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

傻傻的伤痕 · C++ ...· 6 月前 ·

豪气的打火机 · git checkout ...· 7 月前 ·

发财的枕头 · 斗罗大陆2酷漫屋(下拉式) - 百度· 1 年前 ·

文质彬彬的海豚 · 安全抵达_全文在线阅读_goodazy小说作 ...· 1 年前 ·

才高八斗的小狗 · NameError: global ...· 1 年前 ·

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement . We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account punted-for-7.0 type-enhancement

We can enable these by registering two UDFs on the connection:

CreateFunction("ef_days", (TimeSpan value) => value.TotalDays);
CreateFunction("ef_timespan", (double value) => TimeSpan.FromDays(value));

The following translations are enabled.

Most .NET operators have equivalent methods to translate too


    datetime()

should actually be translated as


    rtrim(rtrim(strftime('%Y-%m-%d %H:%M:%f'), '0'), '.')


    julianday(datetime(text, modifiers))

can reduce to


    julianday(text, modifiers)


    julianday(datetime(real))

can reduce to


    real


    ef_days(ef_timespan(real))

can reduce to


    real

closed-fixed label

Jan 22, 2020

I made some good progress in bricelam:timespan , but I ran into floating-point precision issues and wanted to re-examine how we handle TimeSpan and DateTime literals and parameters on SQLite before moving forward.

Assert.Equal() Failure
Expected: 00:01:00
Actual:   00:00:59.9999964
In order to get this to round to the correct time we need to re-create the TimeSpan (and possibly DateTime) instances in various places using a constructor overload that doesn't take double.
  closed-fixed
  The issue has been fixed and is/will be included in the release indicated by the issue milestone.
 label
    Sep 11, 2020
  punted-for-7.0
  Originally planned for the EF Core 7.0 (EF7) release, but moved out due to resource constraints.
    and removed
  propose-punt
  labels
    Apr 23, 2022
      Check for custom sql translation defined on C# special methods: op_LessThan, op_GreaterThan, etc.
      #32227
    punted-for-7.0
  Originally planned for the EF Core 7.0 (EF7) release, but moved out due to resource constraints.
    type-enhancement