public void Greaters() { SqlSingle Test1 = new SqlSingle(1e10); SqlSingle Test11 = new SqlSingle(1e10); SqlSingle Test2 = new SqlSingle(64e14); // GreateThan () Assert.IsTrue(!SqlSingle.GreaterThan(Test1, Test2).Value, "#I01"); Assert.IsTrue(SqlSingle.GreaterThan(Test2, Test1).Value, "#I02"); Assert.IsTrue(!SqlSingle.GreaterThan(Test1, Test11).Value, "#I03"); // GreaterTharOrEqual () Assert.IsTrue(!SqlSingle.GreaterThanOrEqual(Test1, Test2).Value, "#I04"); Assert.IsTrue(SqlSingle.GreaterThanOrEqual(Test2, Test1).Value, "#I05"); Assert.IsTrue(SqlSingle.GreaterThanOrEqual(Test1, Test11).Value, "#I06"); }
public void Greaters() { SqlSingle test1 = new SqlSingle(1e10); SqlSingle test11 = new SqlSingle(1e10); SqlSingle test2 = new SqlSingle(64e14); // GreateThan () Assert.False(SqlSingle.GreaterThan(test1, test2).Value); Assert.True(SqlSingle.GreaterThan(test2, test1).Value); Assert.False(SqlSingle.GreaterThan(test1, test11).Value); // GreaterTharOrEqual () Assert.False(SqlSingle.GreaterThanOrEqual(test1, test2).Value); Assert.True(SqlSingle.GreaterThanOrEqual(test2, test1).Value); Assert.True(SqlSingle.GreaterThanOrEqual(test1, test11).Value); }
public override object Aggregate(int[] records, AggregateType kind) { bool hasData = false; try { switch (kind) { case AggregateType.Sum: SqlSingle sum = 0.0f; foreach (int record in records) { if (IsNull(record)) { continue; } checked { sum += _values[record]; } hasData = true; } if (hasData) { return(sum); } return(_nullValue); case AggregateType.Mean: SqlDouble meanSum = 0.0f; int meanCount = 0; foreach (int record in records) { if (IsNull(record)) { continue; } checked { meanSum += _values[record].ToSqlDouble(); } meanCount++; hasData = true; } if (hasData) { SqlSingle mean = 0; checked { mean = (meanSum / meanCount).ToSqlSingle(); } return(mean); } return(_nullValue); case AggregateType.Var: case AggregateType.StDev: int count = 0; SqlDouble var = 0; SqlDouble prec = 0; SqlDouble dsum = 0; SqlDouble sqrsum = 0; foreach (int record in records) { if (IsNull(record)) { continue; } dsum += _values[record].ToSqlDouble(); sqrsum += (_values[record]).ToSqlDouble() * (_values[record]).ToSqlDouble(); count++; } if (count > 1) { var = count * sqrsum - (dsum * dsum); prec = var / (dsum * dsum); // we are dealing with the risk of a cancellation error // double is guaranteed only for 15 digits so a difference // with a result less than 1e-15 should be considered as zero if ((prec < 1e-15) || (var < 0)) { var = 0; } else { var = var / (count * (count - 1)); } if (kind == AggregateType.StDev) { return(Math.Sqrt(var.Value)); } return(var); } return(_nullValue); case AggregateType.Min: SqlSingle min = SqlSingle.MaxValue; for (int i = 0; i < records.Length; i++) { int record = records[i]; if (IsNull(record)) { continue; } if ((SqlSingle.LessThan(_values[record], min)).IsTrue) { min = _values[record]; } hasData = true; } if (hasData) { return(min); } return(_nullValue); case AggregateType.Max: SqlSingle max = SqlSingle.MinValue; for (int i = 0; i < records.Length; i++) { int record = records[i]; if (IsNull(record)) { continue; } if ((SqlSingle.GreaterThan(_values[record], max)).IsTrue) { max = _values[record]; } hasData = true; } if (hasData) { return(max); } return(_nullValue); case AggregateType.First: if (records.Length > 0) { return(_values[records[0]]); } return(null); case AggregateType.Count: count = 0; for (int i = 0; i < records.Length; i++) { if (!IsNull(records[i])) { count++; } } return(count); } } catch (OverflowException) { throw ExprException.Overflow(typeof(SqlSingle)); } throw ExceptionBuilder.AggregateException(kind, _dataType); }
public override object Aggregate(int[] records, AggregateType kind) { bool flag = false; try { int num; SqlDouble num2; SqlDouble num3; int num4; int num5; int num6; int num7; int num8; int num9; int num10; int num11; SqlSingle minValue; int num13; SqlSingle maxValue; SqlDouble num15; int num16; SqlDouble num17; SqlSingle num18; int[] numArray; SqlDouble num19; int num21; int[] numArray2; int num22; int[] numArray3; switch (kind) { case AggregateType.Sum: num18 = 0f; numArray3 = records; num10 = 0; goto Label_007B; case AggregateType.Mean: num17 = 0.0; num16 = 0; numArray2 = records; num9 = 0; goto Label_00F4; case AggregateType.Min: maxValue = SqlSingle.MaxValue; num6 = 0; goto Label_031C; case AggregateType.Max: minValue = SqlSingle.MinValue; num5 = 0; goto Label_039B; case AggregateType.First: if (records.Length <= 0) { return(null); } return(this.values[records[0]]); case AggregateType.Count: num = 0; num4 = 0; goto Label_0400; case AggregateType.Var: case AggregateType.StDev: num = 0; num2 = 0.0; num19 = 0.0; num3 = 0.0; num15 = 0.0; numArray = records; num8 = 0; goto Label_01EF; default: goto Label_0425; } Label_0047: num22 = numArray3[num10]; if (!this.IsNull(num22)) { num18 += this.values[num22]; flag = true; } num10++; Label_007B: if (num10 < numArray3.Length) { goto Label_0047; } if (flag) { return(num18); } return(base.NullValue); Label_00BA: num21 = numArray2[num9]; if (!this.IsNull(num21)) { num17 += this.values[num21].ToSqlDouble(); num16++; flag = true; } num9++; Label_00F4: if (num9 < numArray2.Length) { goto Label_00BA; } if (flag) { SqlDouble num23 = num17 / ((double)num16); return(num23.ToSqlSingle()); } return(base.NullValue); Label_0187: num7 = numArray[num8]; if (!this.IsNull(num7)) { num3 += this.values[num7].ToSqlDouble(); num15 += this.values[num7].ToSqlDouble() * this.values[num7].ToSqlDouble(); num++; } num8++; Label_01EF: if (num8 < numArray.Length) { goto Label_0187; } if (num <= 1) { return(base.NullValue); } num2 = ((SqlDouble)(num * num15)) - (num3 * num3); num19 = num2 / (num3 * num3); bool x = num19 < 1E-15; if (!SqlBoolean.op_True(x)) { } if (SqlBoolean.op_True(x | (num2 < 0.0))) { num2 = 0.0; } else { num2 /= (double)(num * (num - 1)); } if (kind == AggregateType.StDev) { return(Math.Sqrt(num2.Value)); } return(num2); Label_02CC: num13 = records[num6]; if (!this.IsNull(num13)) { if (SqlSingle.LessThan(this.values[num13], maxValue).IsTrue) { maxValue = this.values[num13]; } flag = true; } num6++; Label_031C: if (num6 < records.Length) { goto Label_02CC; } if (flag) { return(maxValue); } return(base.NullValue); Label_034B: num11 = records[num5]; if (!this.IsNull(num11)) { if (SqlSingle.GreaterThan(this.values[num11], minValue).IsTrue) { minValue = this.values[num11]; } flag = true; } num5++; Label_039B: if (num5 < records.Length) { goto Label_034B; } if (flag) { return(minValue); } return(base.NullValue); Label_03EA: if (!this.IsNull(records[num4])) { num++; } num4++; Label_0400: if (num4 < records.Length) { goto Label_03EA; } return(num); } catch (OverflowException) { throw ExprException.Overflow(typeof(SqlSingle)); } Label_0425: throw ExceptionBuilder.AggregateException(kind, base.DataType); }