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."); }