public void RewriteShouldCollapeUnion()
{
// Arrange
var subject = new SqlQueryHelper.Parser();
// Act
var result = subject.Rewrite(@"select a from b
union
select a from b
union all
select a from b
union
select b from c
union
select b from c
");
// Assert
Assert.AreEqual(@"select a from b union select b from c", result);
}
}