public void DoubleBetweenIntAndDoubleWithNegate()
{
var source = TestData.GetDoubleIntData();
var result = source.Query <Tuple <double, int> >("SELECT * FROM this WHERE -item1 BETWEEN 1 AND 4.2");
var answer = from t in source
where - t.Item1 >= 1 && -t.Item1 <= 4.2
select t;
Assert.IsTrue(result.Any());
Assert.IsTrue(result.SequenceEqual(answer));
}
public void CompareIntToDouble()
{
var source = TestData.GetDoubleIntData();
var result = source.Query <Tuple <double, int> >("SELECT * FROM this WHERE item2 > item1");
var answer = from t in source
where t.Item2 > t.Item1
select t;
Assert.IsTrue(result.Any());
Assert.IsTrue(result.SequenceEqual(answer));
}
public void DoubleBetweenDoubleAndInt()
{
var source = TestData.GetDoubleIntData();
var result = source.Query <Tuple <double, int> >("SELECT * FROM this WHERE item1 BETWEEN 1.1 AND 4");
var answer = from t in source
where t.Item1 >= 1.1 && t.Item1 <= 4
select t;
Assert.IsTrue(result.Any());
Assert.IsTrue(result.SequenceEqual(answer));
}