public void LeftJoin()
{
using (LeftJoinUsersToPeopleByEmail join = new LeftJoinUsersToPeopleByEmail())
{
join.Left(new GenericEnumerableOperation(left))
.Right(new GenericEnumerableOperation(right));
join.PrepareForExecution(new SingleThreadedPipelineExecuter());
IEnumerable <Row> result = join.Execute(null);
List <Row> items = new List <Row>(result);
Assert.Equal(2, items.Count);
Assert.Equal(3, items[0]["person_id"]);
Assert.Null(items[1]["person_id"]);
Assert.Equal("bar", items[1]["name"]);
}
}
public void LeftJoin()
{
using (LeftJoinUsersToPeopleByEmail join = new LeftJoinUsersToPeopleByEmail())
{
join.Left(new GenericEnumerableOperation(left))
.Right(new GenericEnumerableOperation(right));
join.PrepareForExecution(new SingleThreadedPipelineExecuter());
IEnumerable<Row> result = join.Execute(null);
List<Row> items = new List<Row>(result);
Assert.Equal(2, items.Count);
Assert.Equal(3, items[0]["person_id"]);
Assert.Null(items[1]["person_id"]);
Assert.Equal("bar", items[1]["name"]);
}
}