Class E997_DateTimeJulianVerify
Regression probe for SQLite REAL Julian-day datetime storage.
Seeds 3 employees with distinct, far-apart HireDates (incl. a fractional time
of day), then asserts that server-side range filters select EXACTLY the right
rows and that a saved datetime round-trips. A broken comparison (the old TEXT
lexical bug) would make ranges always-true/false and fail these assertions.
[ExampleMeta("E997", "DateTime REAL Julian Verify", "Query", ExampleTier.Free, 1, new string[] { "Where", "DateTime", "Regression" })]
public class E997_DateTimeJulianVerify : ExampleBase
Inheritance
Inherited Members
Methods
RunAsync(IRedbService)
Run the example and return result.
public override Task<ExampleResult> RunAsync(IRedbService redb)