public void CountAllValue() { var source = TestData.GetNullableInts(); int result = source.QueryScalar <int?, int>("SELECT count(ALL value()) FROM this"); Assert.IsTrue(result == source.Where(i => i.HasValue).Count()); }
public void StdevPNullableInt() { IEnumerable <int?> source = TestData.GetNullableInts(); double?result = source.QueryScalar <int?, double?>("SELECT StdevP(value()) FROM this"); Assert.AreEqual((double)result, 1.479019945774904, double.Epsilon); }
public void StdevNullableInt() { IEnumerable <int?> source = TestData.GetNullableInts(); double?result = source.QueryScalar <int?, double?>("SELECT Stdev(value()) FROM this"); Assert.AreEqual((double)result, 1.707825127659933, double.Epsilon); }
public void VarPNullableInt() { IEnumerable <int?> source = TestData.GetNullableInts(); double?result = source.QueryScalar <int?, double?>("SELECT varp(value()) FROM this"); Assert.AreEqual((double)result, 2.1875, double.Epsilon); }
public void CountDistinctIgnoresNullValues() { var source = TestData.GetNullableInts(); var nonNUllSource = source.Where(i => i.HasValue).Select(i => (int)i); int result = nonNUllSource.QueryScalar <int>("SELECT count(DISTINCT value()) FROM this"); int nullResults = source.QueryScalar <int?, int>("SELECT count(DISTINCT value()) FROM this"); Assert.IsTrue(result == nullResults); }