public void TestSelect_Having()
{
SelectBuilder builder = new SelectBuilder();
AliasedSource table = builder.AddTable(new Table("Table"));
builder.AddProjection(table.Column("Column"));
builder.AddHaving(new EqualToFilter(table.Column("Column"), new NumericLiteral(1)));
Formatter formatter = new Formatter();
string commandText = formatter.GetCommandText(builder);
string expected = "SELECT Table.Column FROM Table HAVING Table.Column = 1";
Assert.AreEqual(expected, commandText, "The wrong SQL was generated.");
}
